SResultSet (stSoftware API)

java.lang.Object
- com.aspc.remote.database.internal.SResultSet

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper

Direct Known Subclasses:

CSQL, SoapResultSet
```
public class SResultSet
extends java.lang.Object
implements java.sql.ResultSet
```
SResultSet
THREAD MODE: SINGLE-THREADED sql

Since:

29 September 2006

Author:

Nigel Leck

Field Summary

Fields
Modifier and Type	Field and Description
`static java.lang.ThreadLocal<java.lang.Boolean>`	`ALLOW_OVERFLOW`
`protected java.util.HashMap`	`columnKeys`
`protected java.util.ArrayList<Column>`	`columns`
`protected Row`	`currentData`
`protected int`	`rowOffset`
`protected java.util.ArrayList`	`rowPage`

Fields inherited from interface java.sql.ResultSet
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary

Constructors
Constructor and Description

SResultSet()

SResultSet(java.lang.String data)

Constructors
Constructor and Description
`SResultSet()`
`SResultSet(java.lang.String data)`

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`boolean`	`absolute(int row)` JDBC 2.0
`void`	`afterLast()` JDBC 2.0
`void`	`beforeFirst()` JDBC 2.0
`void`	`cancelRowUpdates()` JDBC 2.0 Cancels the updates made to a row.
`protected void`	`clear()`
`void`	`clearWarnings()` After this call getWarnings returns null until a new warning is reported for this ResultSet.
`void`	`close()` In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
`void`	`decodeTableData(java.lang.String data)` Produces a tab separated data string.
`void`	`deleteRow()` JDBC 2.0 Deletes the current row from the result set and the underlying database.
`protected Row`	`fetchRow(int row)`
`int`	`findColumn(java.lang.String name)`
`protected Column`	`findColumnData(int col)`
`protected Column`	`findColumnData(java.lang.String oKey)`
`boolean`	`first()` JDBC 2.0
`java.lang.String`	`formatOutput()`
`java.sql.Array`	`getArray(int i)` JDBC 2.0 Gets an SQL ARRAY value from the current row of this `ResultSet` object.
`java.sql.Array`	`getArray(java.lang.String colName)` JDBC 2.0 Gets an SQL ARRAY value in the current row of this `ResultSet` object.
`java.io.InputStream`	`getAsciiStream(int columnIndex)` A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
`java.io.InputStream`	`getAsciiStream(java.lang.String columnName)` A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
`java.math.BigDecimal`	`getBigDecimal(int columnIndex)` Deprecated.
`java.math.BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName)` JDBC 2.0 Gets the value of a column in the current row as a java.math.BigDecimal object with full precision.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName, int scale)` Deprecated.
`java.io.InputStream`	`getBinaryStream(int columnIndex)` A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
`java.io.InputStream`	`getBinaryStream(java.lang.String columnName)` A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
`java.sql.Blob`	`getBlob(int i)` JDBC 2.0 Gets a BLOB value in the current row of this `ResultSet` object.
`java.sql.Blob`	`getBlob(java.lang.String colName)` JDBC 2.0 Gets a BLOB value in the current row of this `ResultSet` object.
`boolean`	`getBoolean(int columnIndex)` Get the value of a column in the current row as a Java boolean.
`boolean`	`getBoolean(java.lang.String columnName)` Get the value of a column in the current row as a Java boolean.
`byte`	`getByte(int columnIndex)`
`byte`	`getByte(java.lang.String columnName)` Get the value of a column in the current row as a Java byte.
`byte[]`	`getBytes(int columnIndex)` Get the value of a column in the current row as a Java byte array.
`byte[]`	`getBytes(java.lang.String columnName)` Get the value of a column in the current row as a Java byte array.
`java.io.Reader`	`getCharacterStream(int columnIndex)` JDBC 2.0
`java.io.Reader`	`getCharacterStream(java.lang.String columnName)` JDBC 2.0
`java.sql.Clob`	`getClob(int i)` JDBC 2.0 Gets a CLOB value in the current row of this `ResultSet` object.
`java.sql.Clob`	`getClob(java.lang.String colName)` JDBC 2.0 Gets a CLOB value in the current row of this `ResultSet` object.
`int`	`getColumnCount()` How many columns ?
`int`	`getColumnDisplaySize(int col)`
`java.lang.String`	`getColumnName(int columnIndex)` Returns the name of the column at index.
`java.util.List<Column>`	`getColumns()`
`int`	`getColumnType(int columnIndex)` Returns the name of the column at index.
`int`	`getConcurrency()`
`java.lang.String`	`getCursorName()` Get the name of the SQL cursor used by this ResultSet.
`java.sql.Date`	`getDate(int columnIndex)` Get the value of a column in the current row as a java.sql.Date object.
`java.sql.Date`	`getDate(int columnIndex, java.util.Calendar cal)`
`java.sql.Date`	`getDate(java.lang.String columnName)` Get the value of a column in the current row as a java.sql.Date object.
`java.sql.Date`	`getDate(java.lang.String columnName, java.util.Calendar cal)` Gets the value of a column in the current row as a java.sql.Date object.
`double`	`getDouble(int columnIndex)` Get the value of a column in the current row as a Java double.
`double`	`getDouble(java.lang.String columnName)` Get the value of a column in the current row as a Java double.
`int`	`getFetchDirection()` JDBC 2.0 Returns the fetch direction for this result set.
`int`	`getFetchSize()` JDBC 2.0 Returns the fetch size for this result set.
`float`	`getFloat(int columnIndex)` Get the value of a column in the current row as a Java float.
`float`	`getFloat(java.lang.String columnName)` Get the value of a column in the current row as a Java float.
`int`	`getHoldability()`
`int`	`getInt(int columnIndex)` Get the value of a column in the current row as a Java int.
`int`	`getInt(java.lang.String columnName)` Get the value of a column in the current row as a Java int.
`long`	`getLong(int columnIndex)` Get the value of a column in the current row as a Java long.
`long`	`getLong(java.lang.String columnName)` Get e trd the value of a column in the current row as a Java long.
`java.sql.ResultSetMetaData`	`getMetaData()` The number, types and properties of a ResultSet's columns are provided by the getMetaData method.
`java.io.Reader`	`getNCharacterStream(int columnIndex)`
`java.io.Reader`	`getNCharacterStream(java.lang.String columnName)`
`java.sql.NClob`	`getNClob(int columnIndex)`
`java.sql.NClob`	`getNClob(java.lang.String columnName)`
`java.lang.String`	`getNString(int columnIndex)`
`java.lang.String`	`getNString(java.lang.String columnName)`
`java.lang.Object`	`getObject(int col)`
`<T> T`	`getObject(int columnIndex, java.lang.Class<T> type)`
`java.lang.Object`	`getObject(int i, java.util.Map map)` JDBC 2.0 Returns the value of a column in the current row as a Java object.
`java.lang.Object`	`getObject(java.lang.String columnName)`
`<T> T`	`getObject(java.lang.String columnLabel, java.lang.Class<T> type)`
`java.lang.Object`	`getObject(java.lang.String colName, java.util.Map map)` JDBC 2.0 Returns the value in the specified column as a Java object.
`java.sql.Ref`	`getRef(int i)` JDBC 2.0 Gets a REF(<structured-type>) column value from the current row.
`java.sql.Ref`	`getRef(java.lang.String colName)` JDBC 2.0 Gets a REF(<structured-type>) column value from the current row.
`int`	`getRow()` JDBC 2.0
`java.sql.RowId`	`getRowId(int columnIndex)`
`java.sql.RowId`	`getRowId(java.lang.String columnName)`
`short`	`getShort(int columnIndex)` Get the value of a column in the current row as a Java short.
`short`	`getShort(java.lang.String columnName)` Get the value of a column in the current row as a Java short.
`java.sql.SQLXML`	`getSQLXML(int columnIndex)`
`java.sql.SQLXML`	`getSQLXML(java.lang.String columnName)`
`java.sql.Statement`	`getStatement()` JDBC 2.0 Returns the Statement that produced this `ResultSet` object.
`java.lang.String`	`getString(int columnIndex)` Get the value of a column in the current row as a Java String.
`java.lang.String`	`getString(java.lang.String columnName)` // Methods for accessing results by column name /** Get the value of a column in the current row as a Java String.
`java.sql.Time`	`getTime(int columnIndex)` Get the value of a column in the current row as a java.sql.Time object.
`java.sql.Time`	`getTime(int columnIndex, java.util.Calendar cal)` Gets the value of a column in the current row as a java.sql.Time object.
`java.sql.Time`	`getTime(java.lang.String columnName)` Get the value of a column in the current row as a java.sql.Time object.
`java.sql.Time`	`getTime(java.lang.String columnName, java.util.Calendar cal)` Gets the value of a column in the current row as a java.sql.Time object.
`java.sql.Timestamp`	`getTimestamp(int columnIndex)` Get the value of a column in the current row as a java.sql.Timestamp object.
`java.sql.Timestamp`	`getTimestamp(int columnIndex, java.util.Calendar cal)` Gets the value of a column in the current row as a java.sql.Timestamp object.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName)` Get the value of a column in the current row as a java.sql.Timestamp object.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName, java.util.Calendar cal)` Gets the value of a column in the current row as a java.sql.Timestamp object.
`int`	`getType()`
`java.io.InputStream`	`getUnicodeStream(int columnIndex)` Deprecated.
`java.io.InputStream`	`getUnicodeStream(java.lang.String columnName)` Deprecated.
`java.net.URL`	`getURL(int param)`
`java.net.URL`	`getURL(java.lang.String str)`
`java.sql.SQLWarning`	`getWarnings()` The first warning reported by calls on this ResultSet is returned.
`void`	`insertRow()` JDBC 2.0 Inserts the contents of the insert row into the result set and the database.
`boolean`	`isAfterLast()` JDBC 2.0
`boolean`	`isBeforeFirst()` JDBC 2.0
`boolean`	`isClosed()`
`boolean`	`isFirst()` JDBC 2.0
`boolean`	`isLast()` JDBC 2.0
`boolean`	`isNull(int col)`
`boolean`	`isNull(java.lang.String name)`
`boolean`	`isWrapperFor(java.lang.Class iface)`
`boolean`	`last()` JDBC 2.0
`void`	`load()` Load all the data for a result set.
`void`	`moveToCurrentRow()` JDBC 2.0 Moves the cursor to the remembered cursor position, usually the current row.
`void`	`moveToInsertRow()` JDBC 2.0 Moves the cursor to the insert row.
`boolean`	`next()` A ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
`boolean`	`previous()`
`void`	`refreshRow()` JDBC 2.0 Refreshes the current row with its most recent value in the database.
`boolean`	`relative(int rows)` JDBC 2.0
`void`	`rewind()` Rewinds the result list back to before the first row.
`boolean`	`rowDeleted()` JDBC 2.0 Indicates whether a row has been deleted.
`boolean`	`rowInserted()` JDBC 2.0 Indicates whether the current row has had an insertion.
`boolean`	`rowUpdated()` JDBC 2.0 Indicates whether the current row has been updated.
`void`	`setCurrentRow(int newRow)`
`void`	`setFetchDirection(int direction)`
`void`	`setFetchSize(int rows)` JDBC 2.0 Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set.
`protected int`	`sqlColumnNr(java.lang.String name)`
`java.lang.String`	`toString()` Returns a formatted plain text representation of this result set, by calling the method formatOutput.
`java.lang.Object`	`unwrap(java.lang.Class iface)`
`void`	`updateArray(int param, java.sql.Array array)`
`void`	`updateArray(java.lang.String str, java.sql.Array array)`
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x)`
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x, int length)` JDBC 2.0 Updates a column with an ascii stream value.
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x, long length)`
`void`	`updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)`
`void`	`updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)` JDBC 2.0 Updates a column with an ascii stream value.
`void`	`updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)`
`void`	`updateBigDecimal(int columnIndex, java.math.BigDecimal x)` JDBC 2.0 Updates a column with a BigDecimal value.
`void`	`updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)` JDBC 2.0 Updates a column with a BigDecimal value.
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x)`
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x, int length)` JDBC 2.0 Updates a column with a binary stream value.
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x, long length)`
`void`	`updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)`
`void`	`updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)` JDBC 2.0 Updates a column with a binary stream value.
`void`	`updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)`
`void`	`updateBlob(int param, java.sql.Blob blob)`
`void`	`updateBlob(int columnIndex, java.io.InputStream inputStream)`
`void`	`updateBlob(int columnIndex, java.io.InputStream inputStream, long length)`
`void`	`updateBlob(java.lang.String str, java.sql.Blob blob)`
`void`	`updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)`
`void`	`updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)`
`void`	`updateBoolean(int columnIndex, boolean x)` JDBC 2.0 Updates a column with a boolean value.
`void`	`updateBoolean(java.lang.String columnName, boolean x)` JDBC 2.0 Updates a column with a boolean value.
`void`	`updateByte(int columnIndex, byte x)` JDBC 2.0 Updates a column with a byte value.
`void`	`updateByte(java.lang.String columnName, byte x)` JDBC 2.0 Updates a column with a byte value.
`void`	`updateBytes(int columnIndex, byte[] x)` JDBC 2.0 Updates a column with a byte array value.
`void`	`updateBytes(java.lang.String columnName, byte[] x)` JDBC 2.0 Updates a column with a byte array value.
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x)`
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x, int length)` JDBC 2.0 Updates a column with a character stream value.
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x, long length)`
`void`	`updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)` JDBC 2.0 Updates a column with a character stream value.
`void`	`updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateClob(int param, java.sql.Clob clob)`
`void`	`updateClob(int columnIndex, java.io.Reader reader)`
`void`	`updateClob(int columnIndex, java.io.Reader reader, long length)`
`void`	`updateClob(java.lang.String str, java.sql.Clob clob)`
`void`	`updateClob(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateDate(int columnIndex, java.sql.Date x)` JDBC 2.0 Updates a column with a Date value.
`void`	`updateDate(java.lang.String columnName, java.sql.Date x)` JDBC 2.0 Updates a column with a Date value.
`void`	`updateDouble(int columnIndex, double x)` JDBC 2.0 Updates a column with a Double value.
`void`	`updateDouble(java.lang.String columnName, double x)` JDBC 2.0 Updates a column with a double value.
`void`	`updateFloat(int columnIndex, float x)` JDBC 2.0 Updates a column with a float value.
`void`	`updateFloat(java.lang.String columnName, float x)` JDBC 2.0 Updates a column with a float value.
`void`	`updateInt(int columnIndex, int x)` JDBC 2.0 Updates a column with an integer value.
`void`	`updateInt(java.lang.String columnName, int x)` JDBC 2.0 Updates a column with an integer value.
`void`	`updateLong(int columnIndex, long x)` JDBC 2.0 Updates a column with a long value.
`void`	`updateLong(java.lang.String columnName, long x)` JDBC 2.0 Updates a column with a long value.
`void`	`updateNCharacterStream(int columnIndex, java.io.Reader x)`
`void`	`updateNCharacterStream(int columnIndex, java.io.Reader x, int length)`
`void`	`updateNCharacterStream(int columnIndex, java.io.Reader x, long length)`
`void`	`updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateNCharacterStream(java.lang.String columnName, java.io.Reader x, int length)`
`void`	`updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateNClob(int columnIndex, java.sql.NClob nClob)`
`void`	`updateNClob(int columnIndex, java.io.Reader reader)`
`void`	`updateNClob(int columnIndex, java.io.Reader reader, long length)`
`void`	`updateNClob(java.lang.String columnName, java.sql.NClob nClob)`
`void`	`updateNClob(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateNString(int columnIndex, java.lang.String nString)`
`void`	`updateNString(java.lang.String columnName, java.lang.String nString)`
`void`	`updateNull(int columnIndex)` JDBC 2.0 Give a nullable column a null value.
`void`	`updateNull(java.lang.String columnName)` JDBC 2.0 Updates a column with a null value.
`void`	`updateObject(int columnIndex, java.lang.Object x)` JDBC 2.0 Updates a column with an Object value.
`void`	`updateObject(int columnIndex, java.lang.Object x, int scale)` JDBC 2.0 Updates a column with an Object value.
`void`	`updateObject(java.lang.String columnName, java.lang.Object x)` JDBC 2.0 Updates a column with an Object value.
`void`	`updateObject(java.lang.String columnName, java.lang.Object x, int scale)` JDBC 2.0 Updates a column with an Object value.
`void`	`updateRef(int param, java.sql.Ref ref)`
`void`	`updateRef(java.lang.String str, java.sql.Ref ref)`
`void`	`updateRow()` JDBC 2.0 Updates the underlying database with the new contents of the current row.
`void`	`updateRowId(int columnIndex, java.sql.RowId x)`
`void`	`updateRowId(java.lang.String columnName, java.sql.RowId x)`
`void`	`updateShort(int columnIndex, short x)` JDBC 2.0 Updates a column with a short value.
`void`	`updateShort(java.lang.String columnName, short x)` JDBC 2.0 Updates a column with a short value.
`void`	`updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)`
`void`	`updateSQLXML(java.lang.String columnName, java.sql.SQLXML xmlObject)`
`void`	`updateString(int columnIndex, java.lang.String x)` JDBC 2.0 Updates a column with a String value.
`void`	`updateString(java.lang.String columnName, java.lang.String x)` JDBC 2.0 Updates a column with a String value.
`void`	`updateTime(int columnIndex, java.sql.Time x)` JDBC 2.0 Updates a column with a Time value.
`void`	`updateTime(java.lang.String columnName, java.sql.Time x)` JDBC 2.0 Updates a column with a Time value.
`void`	`updateTimestamp(int columnIndex, java.sql.Timestamp x)` JDBC 2.0 Updates a column with a Timestamp value.
`void`	`updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)` JDBC 2.0 Updates a column with a Timestamp value.
`protected void`	`validToGet()`
`boolean`	`wasNull()` A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.ResultSet
updateObject, updateObject, updateObject, updateObject

- Field Detail
  - ALLOW_OVERFLOW
```
public static final java.lang.ThreadLocal<java.lang.Boolean> ALLOW_OVERFLOW
```
  - rowOffset
```
protected int rowOffset
```
  - rowPage
```
protected java.util.ArrayList rowPage
```
  - columns
```
protected java.util.ArrayList<Column> columns
```
  - columnKeys
```
protected java.util.HashMap columnKeys
```
  - currentData
```
protected Row currentData
```
- Constructor Detail
  - SResultSet
```
public SResultSet()
```
  - SResultSet
```
public SResultSet(java.lang.String data)
           throws java.sql.SQLException
```
    Parameters:
    
    data - the data
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
- Method Detail
  - getColumns
```
@CheckReturnValue
 @Nonnull
public java.util.List<Column> getColumns()
```
    Returns:
    
    the value
  - formatOutput
```
@CheckReturnValue
 @Nonnull
public java.lang.String formatOutput()
                                                          throws java.lang.Exception
```
    Returns:
    
    the value
    
    Throws:
    
    java.lang.Exception - a serious problem
  - getColumnCount
```
@CheckReturnValue
public int getColumnCount()
```
    How many columns ?
    
    Returns:
    
    the number
  - getColumnName
```
@CheckReturnValue
 @Nonnull
public java.lang.String getColumnName(int columnIndex)
```
    Returns the name of the column at index.
    
    Parameters:
    
    columnIndex - the column
    
    Returns:
    
    the value
  - getColumnType
```
@CheckReturnValue
public int getColumnType(int columnIndex)
```
    Returns the name of the column at index.
    
    Parameters:
    
    columnIndex - the column
    
    Returns:
    
    the value
  - getColumnDisplaySize
```
@CheckReturnValue
public int getColumnDisplaySize(int col)
                                           throws java.sql.SQLException
```
    Parameters:
    
    col - the column
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - rewind
```
public void rewind()
```
    Rewinds the result list back to before the first row.
  - next
```
@CheckReturnValue
public boolean next()
                               throws java.sql.SQLException
```
    A ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
    If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read.
    
    Specified by:
    
    next in interface java.sql.ResultSet
    
    Returns:
    
    true if the new current row is valid; false if there are no more rows
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - fetchRow
```
@CheckReturnValue
 @Nullable
protected Row fetchRow(int row)
                                             throws java.sql.SQLException
```
    Parameters:
    
    row - the row to use
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - load
```
public void load()
          throws java.sql.SQLException
```
    Load all the data for a result set.
    
    Throws:
    
    java.sql.SQLException - a serious problem
  - setCurrentRow
```
public void setCurrentRow(int newRow)
                   throws java.sql.SQLException
```
    Parameters:
    
    newRow - the row
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - close
```
public void close()
           throws java.sql.SQLException
```
    In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
    Note: A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet is also automatically closed when it is garbage collected.
    
    Specified by:
    
    close in interface java.lang.AutoCloseable
    
    Specified by:
    
    close in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - wasNull
```
@CheckReturnValue
public boolean wasNull()
                                  throws java.sql.SQLException
```
    A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value. Note that you must first call getXXX on a column to try to read its value and then call wasNull() to find if the value was the SQL NULL.
    
    Specified by:
    
    wasNull in interface java.sql.ResultSet
    
    Returns:
    
    true if last column read was SQL NULL
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - validToGet
```
protected void validToGet()
                   throws java.lang.RuntimeException
```
    Throws:
    
    java.lang.RuntimeException - a problem
  - getString
```
@CheckReturnValue
 @Nullable
public java.lang.String getString(int columnIndex)
                                                        throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java String.
    
    Specified by:
    
    getString in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBoolean
```
@CheckReturnValue
public boolean getBoolean(int columnIndex)
                                     throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java boolean.
    
    Specified by:
    
    getBoolean in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is false
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getByte
```
public byte getByte(int columnIndex)
             throws java.sql.SQLException
```
    Specified by:
    
    getByte in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getShort
```
@CheckReturnValue
public short getShort(int columnIndex)
                                 throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java short.
    
    Specified by:
    
    getShort in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getInt
```
@CheckReturnValue
public int getInt(int columnIndex)
                             throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java int.
    
    Specified by:
    
    getInt in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getLong
```
public long getLong(int columnIndex)
             throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java long.
    
    Specified by:
    
    getLong in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getFloat
```
@CheckReturnValue
public float getFloat(int columnIndex)
                                 throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java float.
    
    Specified by:
    
    getFloat in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getDouble
```
@CheckReturnValue
public double getDouble(int columnIndex)
                                   throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java double.
    
    Specified by:
    
    getDouble in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBigDecimal
```
@CheckReturnValue
public java.math.BigDecimal getBigDecimal(int columnIndex,
                                                            int scale)
                                                     throws java.sql.SQLException
```
    Deprecated.
    
    Get the value of a column in the current row as a java.lang.BigDecimal object.
    
    Specified by:
    
    getBigDecimal in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    scale - the number of digits to the right of the decimal
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBytes
```
@CheckReturnValue
 @Nullable
public byte[] getBytes(int columnIndex)
                                             throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java byte array. The bytes represent the raw values returned by the driver.
    
    Specified by:
    
    getBytes in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getDate
```
@CheckReturnValue
 @Nullable
public java.sql.Date getDate(int columnIndex)
                                                   throws java.sql.SQLException
```
    Get the value of a column in the current row as a java.sql.Date object.
    
    Specified by:
    
    getDate in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getTime
```
@CheckReturnValue
 @Nullable
public java.sql.Time getTime(int columnIndex)
                                                   throws java.sql.SQLException
```
    Get the value of a column in the current row as a java.sql.Time object.
    
    Specified by:
    
    getTime in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getTimestamp
```
@CheckReturnValue
 @Nullable
public java.sql.Timestamp getTimestamp(int columnIndex)
                                                             throws java.sql.SQLException
```
    Get the value of a column in the current row as a java.sql.Timestamp object.
    
    Specified by:
    
    getTimestamp in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getAsciiStream
```
@CheckReturnValue
public java.io.InputStream getAsciiStream(int columnIndex)
                                                     throws java.sql.SQLException
```
    A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.
    Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.
    
    Specified by:
    
    getAsciiStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    a Java input stream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getUnicodeStream
```
@CheckReturnValue
 @Nullable
public java.io.InputStream getUnicodeStream(int columnIndex)
                                                                  throws java.sql.SQLException
```
    Deprecated.
    
    A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into Unicode.
    Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.
    
    Specified by:
    
    getUnicodeStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    a Java input stream that delivers the database column value as a stream of two byte Unicode characters. If the value is SQL NULL then the result is null.
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBinaryStream
```
@CheckReturnValue
 @Nonnull
public java.io.InputStream getBinaryStream(int columnIndex)
                                                                throws java.sql.SQLException
```
    A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.
    Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
    
    Specified by:
    
    getBinaryStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - sqlColumnNr
```
@CheckReturnValue
protected int sqlColumnNr(@Nonnull
                                            java.lang.String name)
                                     throws NoColumnException
```
    Throws:
    
    NoColumnException
  - getString
```
@CheckReturnValue
 @Nullable
public java.lang.String getString(@Nonnull
                                                               java.lang.String columnName)
                                                        throws java.sql.SQLException
```
    // Methods for accessing results by column name /** Get the value of a column in the current row as a Java String.
    
    Specified by:
    
    getString in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBoolean
```
@CheckReturnValue
public boolean getBoolean(@Nonnull
                                            java.lang.String columnName)
                                     throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java boolean.
    
    Specified by:
    
    getBoolean in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is false
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getByte
```
@CheckReturnValue
public byte getByte(@Nonnull
                                      java.lang.String columnName)
                               throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java byte.
    
    Specified by:
    
    getByte in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getShort
```
@CheckReturnValue
public short getShort(@Nonnull
                                        java.lang.String columnName)
                                 throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java short.
    
    Specified by:
    
    getShort in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getObject
```
@CheckReturnValue
 @Nullable
public java.lang.Object getObject(int col)
                                                        throws java.sql.SQLException
```
    Specified by:
    
    getObject in interface java.sql.ResultSet
    
    Parameters:
    
    col - the column
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getObject
```
@CheckReturnValue
 @Nullable
public java.lang.Object getObject(@Nonnull
                                                               java.lang.String columnName)
```
    Specified by:
    
    getObject in interface java.sql.ResultSet
    
    Parameters:
    
    columnName -
    
    Returns:
    
    the value
  - getInt
```
@CheckReturnValue
public int getInt(@Nonnull
                                    java.lang.String columnName)
                             throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java int.
    
    Specified by:
    
    getInt in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getLong
```
@CheckReturnValue
public long getLong(@Nonnull
                                      java.lang.String columnName)
                               throws java.sql.SQLException
```
    Get e trd the value of a column in the current row as a Java long.
    
    Specified by:
    
    getLong in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getFloat
```
@CheckReturnValue
public float getFloat(@Nonnull
                                        java.lang.String columnName)
                                 throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java float.
    
    Specified by:
    
    getFloat in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getDouble
```
@CheckReturnValue
public double getDouble(@Nonnull
                                          java.lang.String columnName)
                                   throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java double.
    
    Specified by:
    
    getDouble in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is 0
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBigDecimal
```
@CheckReturnValue
public java.math.BigDecimal getBigDecimal(@Nonnull
                                                            java.lang.String columnName,
                                                            int scale)
                                                     throws java.sql.SQLException
```
    Deprecated.
    
    Get the value of a column in the current row as a java.lang.BigDecimal object.
    
    Specified by:
    
    getBigDecimal in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    scale - the number of digits to the right of the decimal
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBytes
```
@CheckReturnValue
 @Nullable
public byte[] getBytes(@Nonnull
                                                    java.lang.String columnName)
                                             throws java.sql.SQLException
```
    Get the value of a column in the current row as a Java byte array. The bytes represent the raw values returned by the driver.
    
    Specified by:
    
    getBytes in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getDate
```
@CheckReturnValue
 @Nullable
public java.sql.Date getDate(@Nonnull
                                                          java.lang.String columnName)
                                                   throws java.sql.SQLException
```
    Get the value of a column in the current row as a java.sql.Date object.
    
    Specified by:
    
    getDate in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getTime
```
@CheckReturnValue
 @Nullable
public java.sql.Time getTime(@Nonnull
                                                          java.lang.String columnName)
                                                   throws java.sql.SQLException
```
    Get the value of a column in the current row as a java.sql.Time object.
    
    Specified by:
    
    getTime in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getTimestamp
```
@CheckReturnValue
 @Nullable
public java.sql.Timestamp getTimestamp(@Nonnull
                                                                    java.lang.String columnName)
                                                             throws java.sql.SQLException
```
    Get the value of a column in the current row as a java.sql.Timestamp object.
    
    Specified by:
    
    getTimestamp in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getAsciiStream
```
@CheckReturnValue
public java.io.InputStream getAsciiStream(@Nonnull
                                                            java.lang.String columnName)
                                                     throws java.sql.SQLException
```
    A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.
    Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
    
    Specified by:
    
    getAsciiStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    a Java input stream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getUnicodeStream
```
@CheckReturnValue
 @Nullable
public java.io.InputStream getUnicodeStream(@Nonnull
                                                                         java.lang.String columnName)
                                                                  throws java.sql.SQLException
```
    Deprecated.
    
    A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into Unicode.
    Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
    
    Specified by:
    
    getUnicodeStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    a Java input stream that delivers the database column value as a stream of two byte Unicode characters. If the value is SQL NULL then the result is null.
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBinaryStream
```
@CheckReturnValue
 @Nonnull
public java.io.InputStream getBinaryStream(@Nonnull
                                                                       java.lang.String columnName)
                                                                throws java.sql.SQLException
```
    A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.
    Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
    
    Specified by:
    
    getBinaryStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - is the SQL name of the column
    
    Returns:
    
    a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getWarnings
```
@CheckReturnValue
 @Nullable
public java.sql.SQLWarning getWarnings()
                                                             throws java.sql.SQLException
```
    The first warning reported by calls on this ResultSet is returned. Subsequent ResultSet warnings will be chained to this SQLWarning.
    The warning chain is automatically cleared each time a new row is read.
    Note: This warning chain only covers warnings caused by ResultSet methods. Any warning caused by statement methods (such as reading OUT parameters) will be chained on the Statement object.
    
    Specified by:
    
    getWarnings in interface java.sql.ResultSet
    
    Returns:
    
    the first SQLWarning or null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - clearWarnings
```
public void clearWarnings()
                   throws java.sql.SQLException
```
    After this call getWarnings returns null until a new warning is reported for this ResultSet.
    
    Specified by:
    
    clearWarnings in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getCursorName
```
@CheckReturnValue
 @Nullable
public java.lang.String getCursorName()
                                                            throws java.sql.SQLException
```
    Get the name of the SQL cursor used by this ResultSet.
    In SQL, a result table is retrieved through a cursor that is named. The current row of a result can be updated or deleted using a positioned update/delete statement that references the cursor name.
    JDBC supports this SQL feature by providing the name of the SQL cursor used by a ResultSet. The current row of a ResultSet is also the current row of this SQL cursor.
    Note: If positioned update is not supported a SQLException is thrown
    
    Specified by:
    
    getCursorName in interface java.sql.ResultSet
    
    Returns:
    
    the ResultSet's SQL cursor name
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getMetaData
```
@CheckReturnValue
 @Nonnull
public java.sql.ResultSetMetaData getMetaData()
                                                                   throws java.sql.SQLException
```
    The number, types and properties of a ResultSet's columns are provided by the getMetaData method.
    
    Specified by:
    
    getMetaData in interface java.sql.ResultSet
    
    Returns:
    
    the description of a ResultSet's columns
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - isNull
```
@CheckReturnValue
public boolean isNull(@Nonnull
                                        java.lang.String name)
                                 throws NoColumnException
```
    Parameters:
    
    name -
    
    Returns:
    
    the value
    
    Throws:
    
    NoColumnException
  - isNull
```
@CheckReturnValue
public boolean isNull(int col)
                                 throws java.sql.SQLException
```
    Parameters:
    
    col - the column
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - findColumnData
```
@CheckReturnValue
protected final Column findColumnData(@Nonnull
                                                        java.lang.String oKey)
                                                 throws NoColumnException
```
    Parameters:
    
    oKey -
    
    Returns:
    
    the value
    
    Throws:
    
    NoColumnException - no column
  - findColumnData
```
@CheckReturnValue
protected final Column findColumnData(int col)
                                                 throws java.sql.SQLException
```
    Parameters:
    
    col - the column
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - findColumn
```
@CheckReturnValue
public int findColumn(java.lang.String name)
                                 throws java.sql.SQLException
```
    Specified by:
    
    findColumn in interface java.sql.ResultSet
    
    Parameters:
    
    name -
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - decodeTableData
```
public final void decodeTableData(@Nonnull
                                  java.lang.String data)
                           throws java.sql.SQLException
```
    Produces a tab separated data string. Data is produced with or with out header info ( encoded not to include tabs in data)
    
    Parameters:
    
    data -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateNull
```
public void updateNull(int columnIndex)
                throws java.sql.SQLException
```
    JDBC 2.0 Give a nullable column a null value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateNull in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateBoolean
```
public void updateBoolean(int columnIndex,
                          boolean x)
                   throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a boolean value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBoolean in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateByte
```
public void updateByte(int columnIndex,
                       byte x)
                throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a byte value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateByte in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateShort
```
public void updateShort(int columnIndex,
                        short x)
                 throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a short value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateShort in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateInt
```
public void updateInt(int columnIndex,
                      int x)
               throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with an integer value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateInt in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateLong
```
public void updateLong(int columnIndex,
                       long x)
                throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a long value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateLong in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateFloat
```
public void updateFloat(int columnIndex,
                        float x)
                 throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a float value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateFloat in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateDouble
```
public void updateDouble(int columnIndex,
                         double x)
                  throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a Double value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateDouble in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateBigDecimal
```
public void updateBigDecimal(int columnIndex,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a BigDecimal value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBigDecimal in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateString
```
public void updateString(int columnIndex,
                         java.lang.String x)
                  throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a String value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateString in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateBytes
```
public void updateBytes(int columnIndex,
                        byte[] x)
                 throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a byte array value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBytes in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateDate
```
public void updateDate(int columnIndex,
                       java.sql.Date x)
                throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a Date value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateDate in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateTime
```
public void updateTime(int columnIndex,
                       java.sql.Time x)
                throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a Time value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateTime in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateTimestamp
```
public void updateTimestamp(int columnIndex,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a Timestamp value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateTimestamp in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateAsciiStream
```
public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with an ascii stream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateAsciiStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    length - the length of the stream
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateBinaryStream
```
public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a binary stream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBinaryStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    length - the length of the stream
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateCharacterStream
```
public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  int length)
                           throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a character stream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateCharacterStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    length - the length of the stream
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateObject
```
public void updateObject(int columnIndex,
                         java.lang.Object x,
                         int scale)
                  throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with an Object value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateObject in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types this is the number of digits after the decimal. For all other types this value will be ignored.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateObject
```
public void updateObject(int columnIndex,
                         java.lang.Object x)
                  throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with an Object value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateObject in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateNull
```
public void updateNull(@Nonnull
                       java.lang.String columnName)
                throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a null value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateNull in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateBoolean
```
public void updateBoolean(@Nonnull
                          java.lang.String columnName,
                          boolean x)
                   throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a boolean value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBoolean in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateByte
```
public void updateByte(@Nonnull
                       java.lang.String columnName,
                       byte x)
                throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a byte value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateByte in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateShort
```
public void updateShort(@Nonnull
                        java.lang.String columnName,
                        short x)
                 throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a short value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateShort in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateInt
```
public void updateInt(@Nonnull
                      java.lang.String columnName,
                      int x)
               throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with an integer value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateInt in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateLong
```
public void updateLong(@Nonnull
                       java.lang.String columnName,
                       long x)
                throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a long value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateLong in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateFloat
```
public void updateFloat(@Nonnull
                        java.lang.String columnName,
                        float x)
                 throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a float value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateFloat in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateDouble
```
public void updateDouble(@Nonnull
                         java.lang.String columnName,
                         double x)
                  throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a double value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateDouble in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateBigDecimal
```
public void updateBigDecimal(@Nonnull
                             java.lang.String columnName,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a BigDecimal value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBigDecimal in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateString
```
public void updateString(@Nonnull
                         java.lang.String columnName,
                         java.lang.String x)
                  throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a String value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateString in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateBytes
```
public void updateBytes(@Nonnull
                        java.lang.String columnName,
                        byte[] x)
                 throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a byte array value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBytes in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateDate
```
public void updateDate(@Nonnull
                       java.lang.String columnName,
                       java.sql.Date x)
                throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a Date value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateDate in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateTime
```
public void updateTime(@Nonnull
                       java.lang.String columnName,
                       java.sql.Time x)
                throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a Time value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateTime in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateTimestamp
```
public void updateTimestamp(@Nonnull
                            java.lang.String columnName,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a Timestamp value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateTimestamp in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateAsciiStream
```
public void updateAsciiStream(@Nonnull
                              java.lang.String columnName,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with an ascii stream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateAsciiStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    length - of the stream
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateBinaryStream
```
public void updateBinaryStream(@Nonnull
                               java.lang.String columnName,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a binary stream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBinaryStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    length - of the stream
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateCharacterStream
```
public void updateCharacterStream(@Nonnull
                                  java.lang.String columnName,
                                  java.io.Reader reader,
                                  int length)
                           throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with a character stream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateCharacterStream in interface java.sql.ResultSet
    
    Parameters:
    
    reader -
    
    columnName - the name of the column
    
    length - of the stream
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateObject
```
public void updateObject(@Nonnull
                         java.lang.String columnName,
                         java.lang.Object x,
                         int scale)
                  throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with an Object value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateObject in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types this is the number of digits after the decimal. For all other types this value will be ignored.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateObject
```
public void updateObject(@Nonnull
                         java.lang.String columnName,
                         java.lang.Object x)
                  throws java.sql.SQLException
```
    JDBC 2.0 Updates a column with an Object value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateObject in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    x - the new column value
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - insertRow
```
public void insertRow()
               throws java.sql.SQLException
```
    JDBC 2.0 Inserts the contents of the insert row into the result set and the database. Must be on the insert row when this method is called.
    
    Specified by:
    
    insertRow in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs, if called when not on the insert row, or if not all of non-nullable columns in the insert row have been given a value
  - updateRow
```
public void updateRow()
               throws java.sql.SQLException
```
    JDBC 2.0 Updates the underlying database with the new contents of the current row. Cannot be called when on the insert row.
    
    Specified by:
    
    updateRow in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or if called when on the insert row
  - deleteRow
```
public void deleteRow()
               throws java.sql.SQLException
```
    JDBC 2.0 Deletes the current row from the result set and the underlying database. Cannot be called when on the insert row.
    
    Specified by:
    
    deleteRow in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or if called when on the insert row.
  - refreshRow
```
public void refreshRow()
                throws java.sql.SQLException
```
    JDBC 2.0 Refreshes the current row with its most recent value in the database. Cannot be called when on the insert row. The refreshRow method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database. An application may want to call refreshRow when caching or prefetching is being done by the JDBC driver to fetch the latest value of a row from the database. The JDBC driver may actually refresh multiple rows at once if the fetch size is greater than one. All values are refetched subject to the transaction isolation level and cursor sensitivity. If refreshRow is called after calling updateXXX, but before calling updateRow, then the updates made to the row are lost. Calling the method refreshRow frequently will likely slow performance.
    
    Specified by:
    
    refreshRow in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or if called when on the insert row
  - cancelRowUpdates
```
public void cancelRowUpdates()
                      throws java.sql.SQLException
```
    JDBC 2.0 Cancels the updates made to a row. This method may be called after calling an updateXXX method(s) and before calling updateRow to rollback the updates made to a row. If no updates have been made or updateRow has already been called, then this method has no effect.
    
    Specified by:
    
    cancelRowUpdates in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or if called when on the insert row
  - moveToInsertRow
```
public void moveToInsertRow()
                     throws java.sql.SQLException
```
    JDBC 2.0 Moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row. The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the updateXXX methods prior to inserting the row into the result set. Only the updateXXX, getXXX, and insertRow methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling insertRow. The method updateXXX must be called before a getXXX method can be called on a column value.
    
    Specified by:
    
    moveToInsertRow in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or the result set is not updatable
  - moveToCurrentRow
```
public void moveToCurrentRow()
                      throws java.sql.SQLException
```
    JDBC 2.0 Moves the cursor to the remembered cursor position, usually the current row. This method has no effect if the cursor is not on the insert row.
    
    Specified by:
    
    moveToCurrentRow in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or the result set is not updatable
  - getStatement
```
@CheckReturnValue
 @Nullable
public java.sql.Statement getStatement()
                                                             throws java.sql.SQLException
```
    JDBC 2.0 Returns the Statement that produced this ResultSet object. If the result set was generated some other way, such as by a DatabaseMetaData method, this method returns null.
    
    Specified by:
    
    getStatement in interface java.sql.ResultSet
    
    Returns:
    
    the Statement that produced the result set or null if the result set was produced some other way
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - getObject
```
@CheckReturnValue
 @Nullable
public java.lang.Object getObject(int i,
                                                               java.util.Map map)
                                                        throws java.sql.SQLException
```
    JDBC 2.0 Returns the value of a column in the current row as a Java object. This method uses the given Map object for the custom mapping of the SQL structured or distinct type that is being retrieved.
    
    Specified by:
    
    getObject in interface java.sql.ResultSet
    
    Parameters:
    
    i - the first column is 1, the second is 2, ...
    
    map - the mapping from SQL type names to Java classes
    
    Returns:
    
    an object representing the SQL value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getRef
```
@CheckReturnValue
 @Nullable
public java.sql.Ref getRef(int i)
                                                 throws java.sql.SQLException
```
    JDBC 2.0 Gets a REF(<structured-type>) column value from the current row.
    
    Specified by:
    
    getRef in interface java.sql.ResultSet
    
    Parameters:
    
    i - the first column is 1, the second is 2, ...
    
    Returns:
    
    a Ref object representing an SQL REF value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBlob
```
@CheckReturnValue
 @Nonnull
public java.sql.Blob getBlob(int i)
                                                  throws java.sql.SQLException
```
    JDBC 2.0 Gets a BLOB value in the current row of this ResultSet object.
    
    Specified by:
    
    getBlob in interface java.sql.ResultSet
    
    Parameters:
    
    i - the first column is 1, the second is 2, ...
    
    Returns:
    
    a Blob object representing the SQL BLOB value in the specified column
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getClob
```
@CheckReturnValue
 @Nullable
public java.sql.Clob getClob(int i)
                                                   throws java.sql.SQLException
```
    JDBC 2.0 Gets a CLOB value in the current row of this ResultSet object.
    
    Specified by:
    
    getClob in interface java.sql.ResultSet
    
    Parameters:
    
    i - the first column is 1, the second is 2, ...
    
    Returns:
    
    a Clob object representing the SQL CLOB value in the specified column
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getArray
```
@CheckReturnValue
public java.sql.Array getArray(int i)
                                          throws java.sql.SQLException
```
    JDBC 2.0 Gets an SQL ARRAY value from the current row of this ResultSet object.
    
    Specified by:
    
    getArray in interface java.sql.ResultSet
    
    Parameters:
    
    i - the first column is 1, the second is 2, ...
    
    Returns:
    
    an Array object representing the SQL ARRAY value in the specified column
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getObject
```
@CheckReturnValue
 @Nullable
public java.lang.Object getObject(java.lang.String colName,
                                                               java.util.Map map)
                                                        throws java.sql.SQLException
```
    JDBC 2.0 Returns the value in the specified column as a Java object. This method uses the specified Map object for custom mapping if appropriate.
    
    Specified by:
    
    getObject in interface java.sql.ResultSet
    
    Parameters:
    
    colName - the name of the column from which to retrieve the value
    
    map - the mapping from SQL type names to Java classes
    
    Returns:
    
    an object representing the SQL value in the specified column
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getRef
```
@CheckReturnValue
 @Nullable
public java.sql.Ref getRef(@Nonnull
                                                        java.lang.String colName)
                                                 throws java.sql.SQLException
```
    JDBC 2.0 Gets a REF(<structured-type>) column value from the current row.
    
    Specified by:
    
    getRef in interface java.sql.ResultSet
    
    Parameters:
    
    colName - the column name
    
    Returns:
    
    a Ref object representing the SQL REF value in the specified column
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBlob
```
@CheckReturnValue
 @Nonnull
public java.sql.Blob getBlob(java.lang.String colName)
                                                  throws java.sql.SQLException
```
    JDBC 2.0 Gets a BLOB value in the current row of this ResultSet object.
    
    Specified by:
    
    getBlob in interface java.sql.ResultSet
    
    Parameters:
    
    colName - the name of the column from which to retrieve the value
    
    Returns:
    
    a Blob object representing the SQL BLOB value in the specified column
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getClob
```
@CheckReturnValue
 @Nullable
public java.sql.Clob getClob(@Nonnull
                                                          java.lang.String colName)
                                                   throws java.sql.SQLException
```
    JDBC 2.0 Gets a CLOB value in the current row of this ResultSet object.
    
    Specified by:
    
    getClob in interface java.sql.ResultSet
    
    Parameters:
    
    colName - the name of the column from which to retrieve the value
    
    Returns:
    
    a Clob object representing the SQL CLOB value in the specified column
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getArray
```
@CheckReturnValue
public java.sql.Array getArray(java.lang.String colName)
                                          throws java.sql.SQLException
```
    JDBC 2.0 Gets an SQL ARRAY value in the current row of this ResultSet object.
    
    Specified by:
    
    getArray in interface java.sql.ResultSet
    
    Parameters:
    
    colName - the name of the column from which to retrieve the value
    
    Returns:
    
    an Array object representing the SQL ARRAY value in the specified column
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - setFetchDirection
```
@CheckReturnValue
public void setFetchDirection(int direction)
                                         throws java.sql.SQLException
```
    Specified by:
    
    setFetchDirection in interface java.sql.ResultSet
    
    Parameters:
    
    direction -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getFetchDirection
```
@CheckReturnValue
public int getFetchDirection()
                                        throws java.sql.SQLException
```
    JDBC 2.0 Returns the fetch direction for this result set.
    
    Specified by:
    
    getFetchDirection in interface java.sql.ResultSet
    
    Returns:
    
    the current fetch direction for this result set
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - setFetchSize
```
@CheckReturnValue
public void setFetchSize(int rows)
                                    throws java.sql.SQLException
```
    JDBC 2.0 Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the statement that created the result set. The fetch size may be changed at any time.
    
    Specified by:
    
    setFetchSize in interface java.sql.ResultSet
    
    Parameters:
    
    rows - the number of rows to fetch
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or the condition 0 <= rows <= this.getMaxRows() is not satisfied.
  - getFetchSize
```
@CheckReturnValue
public int getFetchSize()
                                   throws java.sql.SQLException
```
    JDBC 2.0 Returns the fetch size for this result set.
    
    Specified by:
    
    getFetchSize in interface java.sql.ResultSet
    
    Returns:
    
    the current fetch size for this result set
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - rowUpdated
```
@CheckReturnValue
public boolean rowUpdated()
                                     throws java.sql.SQLException
```
    JDBC 2.0 Indicates whether the current row has been updated. The value returned depends on whether or not the result set can detect updates.
    
    Specified by:
    
    rowUpdated in interface java.sql.ResultSet
    
    Returns:
    
    true if the row has been visibly updated by the owner or another, and updates are detected
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
    
    See Also:
    
    DatabaseMetaData.updatesAreDetected(int)
  - rowInserted
```
@CheckReturnValue
public boolean rowInserted()
                                      throws java.sql.SQLException
```
    JDBC 2.0 Indicates whether the current row has had an insertion. The value returned depends on whether or not the result set can detect visible inserts.
    
    Specified by:
    
    rowInserted in interface java.sql.ResultSet
    
    Returns:
    
    true if a row has had an insertion and insertions are detected
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
    
    See Also:
    
    DatabaseMetaData.insertsAreDetected(int)
  - rowDeleted
```
@CheckReturnValue
public boolean rowDeleted()
                                     throws java.sql.SQLException
```
    JDBC 2.0 Indicates whether a row has been deleted. A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not the result set can detect deletions.
    
    Specified by:
    
    rowDeleted in interface java.sql.ResultSet
    
    Returns:
    
    true if a row was deleted and deletions are detected
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
    
    See Also:
    
    DatabaseMetaData.deletesAreDetected(int)
  - absolute
```
@CheckReturnValue
public boolean absolute(int row)
                                   throws java.sql.SQLException
```
    JDBC 2.0
    Moves the cursor to the given row number in the result set.
    If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.
    If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, and so on.
    An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before/after the first/last row, respectively.
    Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().
    
    Specified by:
    
    absolute in interface java.sql.ResultSet
    
    Parameters:
    
    row - the row to use
    
    Returns:
    
    true if the cursor is on the result set; false otherwise
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or row is 0, or result set type is TYPE_FORWARD_ONLY.
  - relative
```
@CheckReturnValue
public boolean relative(int rows)
                                   throws java.sql.SQLException
```
    JDBC 2.0
    Moves the cursor a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.
    Note: Calling relative(1) is different from calling next() because is makes sense to call next() when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.
    
    Specified by:
    
    relative in interface java.sql.ResultSet
    
    Parameters:
    
    rows -
    
    Returns:
    
    true if the cursor is on a row; false otherwise
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs, there is no current row, or the result set type is TYPE_FORWARD_ONLY
  - previous
```
@CheckReturnValue
public boolean previous()
                                   throws java.sql.SQLException
```
    Specified by:
    
    previous in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - isBeforeFirst
```
@CheckReturnValue
public boolean isBeforeFirst()
                                        throws java.sql.SQLException
```
    JDBC 2.0
    Indicates whether the cursor is before the first row in the result set.
    
    Specified by:
    
    isBeforeFirst in interface java.sql.ResultSet
    
    Returns:
    
    true if the cursor is before the first row, false otherwise. Returns false when the result set contains no rows.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - isAfterLast
```
@CheckReturnValue
public boolean isAfterLast()
                                      throws java.sql.SQLException
```
    JDBC 2.0
    Indicates whether the cursor is after the last row in the result set.
    
    Specified by:
    
    isAfterLast in interface java.sql.ResultSet
    
    Returns:
    
    true if the cursor is after the last row, false otherwise. Returns false when the result set contains no rows.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - isFirst
```
@CheckReturnValue
public boolean isFirst()
                                  throws java.sql.SQLException
```
    JDBC 2.0
    Indicates whether the cursor is on the first row of the result set.
    
    Specified by:
    
    isFirst in interface java.sql.ResultSet
    
    Returns:
    
    true if the cursor is on the first row, false otherwise.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - isLast
```
@CheckReturnValue
public boolean isLast()
                                 throws java.sql.SQLException
```
    JDBC 2.0
    Indicates whether the cursor is on the last row of the result set. Note: Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.
    
    Specified by:
    
    isLast in interface java.sql.ResultSet
    
    Returns:
    
    true if the cursor is on the last row, false otherwise.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - beforeFirst
```
@CheckReturnValue
public void beforeFirst()
                                   throws java.sql.SQLException
```
    JDBC 2.0
    Moves the cursor to the front of the result set, just before the first row. Has no effect if the result set contains no rows.
    
    Specified by:
    
    beforeFirst in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
  - afterLast
```
@CheckReturnValue
public void afterLast()
                                 throws java.sql.SQLException
```
    JDBC 2.0
    Moves the cursor to the end of the result set, just after the last row. Has no effect if the result set contains no rows.
    
    Specified by:
    
    afterLast in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
  - first
```
@CheckReturnValue
public boolean first()
                                throws java.sql.SQLException
```
    JDBC 2.0
    Moves the cursor to the first row in the result set.
    
    Specified by:
    
    first in interface java.sql.ResultSet
    
    Returns:
    
    true if the cursor is on a valid row; false if there are no rows in the result set
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
  - last
```
@CheckReturnValue
public boolean last()
                               throws java.sql.SQLException
```
    JDBC 2.0
    Moves the cursor to the last row in the result set.
    
    Specified by:
    
    last in interface java.sql.ResultSet
    
    Returns:
    
    true if the cursor is on a valid row; false if there are no rows in the result set
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY.
  - getType
```
@CheckReturnValue
 @Nullable
public int getType()
                                         throws java.sql.SQLException
```
    Specified by:
    
    getType in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getTimestamp
```
@CheckReturnValue
 @Nullable
public java.sql.Timestamp getTimestamp(int columnIndex,
                                                                    java.util.Calendar cal)
                                                             throws java.sql.SQLException
```
    Gets the value of a column in the current row as a java.sql.Timestamp object. This method uses the given calendar to construct an appropriate millisecond value for the Timestamp if the underlying database does not store timezone information.
    
    Specified by:
    
    getTimestamp in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    cal - the calendar to use in constructing the timestamp
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - getTimestamp
```
@CheckReturnValue
 @Nullable
public java.sql.Timestamp getTimestamp(@Nonnull
                                                                    java.lang.String columnName,
                                                                    java.util.Calendar cal)
                                                             throws java.sql.SQLException
```
    Gets the value of a column in the current row as a java.sql.Timestamp object. This method uses the given calendar to construct an appropriate millisecond value for the Timestamp if the underlying database does not store timezone information.
    
    Specified by:
    
    getTimestamp in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the SQL name of the column
    
    cal - the calendar to use in constructing the timestamp
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - getTime
```
@CheckReturnValue
 @Nullable
public java.sql.Time getTime(int columnIndex,
                                                          java.util.Calendar cal)
                                                   throws java.sql.SQLException
```
    Gets the value of a column in the current row as a java.sql.Time object. This method uses the given calendar to construct an appropriate millisecond value for the Time if the underlying database does not store timezone information.
    
    Specified by:
    
    getTime in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    cal - the calendar to use in constructing the time
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - getTime
```
@CheckReturnValue
 @Nullable
public java.sql.Time getTime(@Nonnull
                                                          java.lang.String columnName,
                                                          java.util.Calendar cal)
                                                   throws java.sql.SQLException
```
    Gets the value of a column in the current row as a java.sql.Time object. This method uses the given calendar to construct an appropriate millisecond value for the Time if the underlying database does not store timezone information.
    
    Specified by:
    
    getTime in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the SQL name of the column
    
    cal - the calendar to use in constructing the time
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - getRow
```
@CheckReturnValue
public int getRow()
                             throws java.sql.SQLException
```
    JDBC 2.0
    Retrieves the current row number. The first row is number 1, the second number 2, and so on.
    
    Specified by:
    
    getRow in interface java.sql.ResultSet
    
    Returns:
    
    the current row number; 0 if there is no current row
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - getDate
```
@CheckReturnValue
 @Nullable
public java.sql.Date getDate(int columnIndex,
                                                          java.util.Calendar cal)
                                                   throws java.sql.SQLException
```
    Specified by:
    
    getDate in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex -
    
    cal -
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getDate
```
@CheckReturnValue
 @Nullable
public java.sql.Date getDate(@Nonnull
                                                          java.lang.String columnName,
                                                          java.util.Calendar cal)
                                                   throws java.sql.SQLException
```
    Gets the value of a column in the current row as a java.sql.Date object. This method uses the given calendar to construct an appropriate millisecond value for the Date, if the underlying database does not store timezone information.
    
    Specified by:
    
    getDate in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the SQL name of the column from which to retrieve the value
    
    cal - the calendar to use in constructing the date
    
    Returns:
    
    the column value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - getConcurrency
```
@CheckReturnValue
public int getConcurrency()
                                     throws java.sql.SQLException
```
    Specified by:
    
    getConcurrency in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getCharacterStream
```
@CheckReturnValue
 @Nullable
public java.io.Reader getCharacterStream(int columnIndex)
                                                               throws java.sql.SQLException
```
    JDBC 2.0
    Gets the value of a column in the current row as a java.io.Reader.
    
    Specified by:
    
    getCharacterStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getCharacterStream
```
@CheckReturnValue
 @Nullable
public java.io.Reader getCharacterStream(@Nonnull
                                                                      java.lang.String columnName)
                                                               throws java.sql.SQLException
```
    JDBC 2.0
    Gets the value of a column in the current row as a java.io.Reader.
    
    Specified by:
    
    getCharacterStream in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the name of the column
    
    Returns:
    
    the value in the specified column as a java.io.Reader
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBigDecimal
```
@CheckReturnValue
 @Nonnull
public java.math.BigDecimal getBigDecimal(int columnIndex)
                                                               throws java.sql.SQLException
```
    Deprecated.
    
    JDBC 2.0 Gets the value of a column in the current row as a java.math.BigDecimal object with full precision.
    
    Specified by:
    
    getBigDecimal in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex - the first column is 1, the second is 2, ...
    
    Returns:
    
    the column value (full precision); if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - getBigDecimal
```
@CheckReturnValue
 @Nonnull
public java.math.BigDecimal getBigDecimal(@Nonnull
                                                                      java.lang.String columnName)
                                                               throws java.sql.SQLException
```
    JDBC 2.0 Gets the value of a column in the current row as a java.math.BigDecimal object with full precision.
    
    Specified by:
    
    getBigDecimal in interface java.sql.ResultSet
    
    Parameters:
    
    columnName - the column name
    
    Returns:
    
    the column value (full precision); if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - updateRef
```
public void updateRef(java.lang.String str,
                      java.sql.Ref ref)
               throws java.sql.SQLException
```
    Specified by:
    
    updateRef in interface java.sql.ResultSet
    
    Parameters:
    
    str -
    
    ref -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getURL
```
@CheckReturnValue
 @Nullable
public java.net.URL getURL(int param)
                                                 throws java.sql.SQLException
```
    Specified by:
    
    getURL in interface java.sql.ResultSet
    
    Parameters:
    
    param -
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateBlob
```
public void updateBlob(int param,
                       java.sql.Blob blob)
                throws java.sql.SQLException
```
    Specified by:
    
    updateBlob in interface java.sql.ResultSet
    
    Parameters:
    
    param -
    
    blob -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateArray
```
public void updateArray(int param,
                        java.sql.Array array)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateArray in interface java.sql.ResultSet
    
    Parameters:
    
    param -
    
    array -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateClob
```
public void updateClob(java.lang.String str,
                       java.sql.Clob clob)
                throws java.sql.SQLException
```
    Specified by:
    
    updateClob in interface java.sql.ResultSet
    
    Parameters:
    
    str -
    
    clob -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateRef
```
public void updateRef(int param,
                      java.sql.Ref ref)
               throws java.sql.SQLException
```
    Specified by:
    
    updateRef in interface java.sql.ResultSet
    
    Parameters:
    
    param -
    
    ref -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getURL
```
@CheckReturnValue
 @Nullable
public java.net.URL getURL(java.lang.String str)
                                                 throws java.sql.SQLException
```
    Specified by:
    
    getURL in interface java.sql.ResultSet
    
    Parameters:
    
    str -
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateBlob
```
public void updateBlob(java.lang.String str,
                       java.sql.Blob blob)
                throws java.sql.SQLException
```
    Specified by:
    
    updateBlob in interface java.sql.ResultSet
    
    Parameters:
    
    str -
    
    blob -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateArray
```
public void updateArray(java.lang.String str,
                        java.sql.Array array)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateArray in interface java.sql.ResultSet
    
    Parameters:
    
    str -
    
    array -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateClob
```
public void updateClob(int param,
                       java.sql.Clob clob)
                throws java.sql.SQLException
```
    Specified by:
    
    updateClob in interface java.sql.ResultSet
    
    Parameters:
    
    param -
    
    clob -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - toString
```
@CheckReturnValue
 @Nonnull
public java.lang.String toString()
```
    Returns a formatted plain text representation of this result set, by calling the method formatOutput. If the formatOutput method throws an Exception, then this method will return the result of calling the toString method of its super class.
    
    Overrides:
    
    toString in class java.lang.Object
    
    Returns:
    
    String the string representation of this result set
  - getRowId
```
@CheckReturnValue
 @Nullable
public java.sql.RowId getRowId(int columnIndex)
                                                     throws java.sql.SQLException
```
    Specified by:
    
    getRowId in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getRowId
```
@CheckReturnValue
 @Nullable
public java.sql.RowId getRowId(@Nonnull
                                                            java.lang.String columnName)
                                                     throws java.sql.SQLException
```
    Specified by:
    
    getRowId in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateRowId
```
public void updateRowId(int columnIndex,
                        java.sql.RowId x)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateRowId in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateRowId
```
public void updateRowId(@Nonnull
                        java.lang.String columnName,
                        java.sql.RowId x)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateRowId in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getHoldability
```
@CheckReturnValue
public int getHoldability()
                                     throws java.sql.SQLException
```
    Specified by:
    
    getHoldability in interface java.sql.ResultSet
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - isClosed
```
@CheckReturnValue
public boolean isClosed()
                                   throws java.sql.SQLException
```
    Specified by:
    
    isClosed in interface java.sql.ResultSet
    
    Returns:
    
    the value
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateNString
```
public void updateNString(int columnIndex,
                          java.lang.String nString)
                   throws java.sql.SQLException
```
    Specified by:
    
    updateNString in interface java.sql.ResultSet
    
    Parameters:
    
    columnIndex -
    
    nString -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateNString
```
public void updateNString(@Nonnull
                          java.lang.String columnName,
                          java.lang.String nString)
                   throws java.sql.SQLException
```
    Specified by:
    
    updateNString in interface java.sql.ResultSet
    
    Parameters:
    
    columnName -
    
    nString -
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - updateNClob
```
public void updateNClob(int columnIndex,
                        java.sql.NClob nClob)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateNClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateNClob
```
public void updateNClob(@Nonnull
                        java.lang.String columnName,
                        java.sql.NClob nClob)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateNClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getNClob
```
@CheckReturnValue
 @Nullable
public java.sql.NClob getNClob(int columnIndex)
                                                     throws java.sql.SQLException
```
    Specified by:
    
    getNClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getNClob
```
@CheckReturnValue
 @Nullable
public java.sql.NClob getNClob(@Nonnull
                                                            java.lang.String columnName)
                                                     throws java.sql.SQLException
```
    Specified by:
    
    getNClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getSQLXML
```
@CheckReturnValue
 @Nullable
public java.sql.SQLXML getSQLXML(int columnIndex)
                                                       throws java.sql.SQLException
```
    Specified by:
    
    getSQLXML in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getSQLXML
```
@CheckReturnValue
 @Nullable
public java.sql.SQLXML getSQLXML(@Nonnull
                                                              java.lang.String columnName)
                                                       throws java.sql.SQLException
```
    Specified by:
    
    getSQLXML in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateSQLXML
```
public void updateSQLXML(int columnIndex,
                         java.sql.SQLXML xmlObject)
                  throws java.sql.SQLException
```
    Specified by:
    
    updateSQLXML in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateSQLXML
```
public void updateSQLXML(@Nonnull
                         java.lang.String columnName,
                         java.sql.SQLXML xmlObject)
                  throws java.sql.SQLException
```
    Specified by:
    
    updateSQLXML in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getNString
```
@CheckReturnValue
 @Nullable
public java.lang.String getNString(int columnIndex)
                                                         throws java.sql.SQLException
```
    Specified by:
    
    getNString in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getNString
```
@CheckReturnValue
 @Nullable
public java.lang.String getNString(@Nonnull
                                                                java.lang.String columnName)
                                                         throws java.sql.SQLException
```
    Specified by:
    
    getNString in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getNCharacterStream
```
@CheckReturnValue
 @Nullable
public java.io.Reader getNCharacterStream(int columnIndex)
                                                                throws java.sql.SQLException
```
    Specified by:
    
    getNCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getNCharacterStream
```
@CheckReturnValue
 @Nullable
public java.io.Reader getNCharacterStream(@Nonnull
                                                                       java.lang.String columnName)
                                                                throws java.sql.SQLException
```
    Specified by:
    
    getNCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateNCharacterStream
```
public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x,
                                   int length)
                            throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - updateNCharacterStream
```
public void updateNCharacterStream(@Nonnull
                                   java.lang.String columnName,
                                   java.io.Reader x,
                                   int length)
                            throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - unwrap
```
@CheckReturnValue
public java.lang.Object unwrap(java.lang.Class iface)
                                          throws java.sql.SQLException
```
    Specified by:
    
    unwrap in interface java.sql.Wrapper
    
    Throws:
    
    java.sql.SQLException
  - isWrapperFor
```
@CheckReturnValue
public boolean isWrapperFor(java.lang.Class iface)
                                       throws java.sql.SQLException
```
    Specified by:
    
    isWrapperFor in interface java.sql.Wrapper
    
    Throws:
    
    java.sql.SQLException
  - updateNCharacterStream
```
public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x,
                                   long length)
                            throws java.sql.SQLException
```
    Specified by:
    
    updateNCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateNCharacterStream
```
public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader,
                                   long length)
                            throws java.sql.SQLException
```
    Specified by:
    
    updateNCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateAsciiStream
```
public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException
```
    Specified by:
    
    updateAsciiStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateBinaryStream
```
public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException
```
    Specified by:
    
    updateBinaryStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateCharacterStream
```
public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  long length)
                           throws java.sql.SQLException
```
    Specified by:
    
    updateCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateAsciiStream
```
public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException
```
    Specified by:
    
    updateAsciiStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateBinaryStream
```
public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException
```
    Specified by:
    
    updateBinaryStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateCharacterStream
```
public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader,
                                  long length)
                           throws java.sql.SQLException
```
    Specified by:
    
    updateCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateBlob
```
public void updateBlob(int columnIndex,
                       java.io.InputStream inputStream,
                       long length)
                throws java.sql.SQLException
```
    Specified by:
    
    updateBlob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateBlob
```
public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream,
                       long length)
                throws java.sql.SQLException
```
    Specified by:
    
    updateBlob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateClob
```
public void updateClob(int columnIndex,
                       java.io.Reader reader,
                       long length)
                throws java.sql.SQLException
```
    Specified by:
    
    updateClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateClob
```
public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader,
                       long length)
                throws java.sql.SQLException
```
    Specified by:
    
    updateClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateNClob
```
public void updateNClob(int columnIndex,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateNClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateNClob
```
public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateNClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateNCharacterStream
```
public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x)
                            throws java.sql.SQLException
```
    Specified by:
    
    updateNCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateNCharacterStream
```
public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader)
                            throws java.sql.SQLException
```
    Specified by:
    
    updateNCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateAsciiStream
```
public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x)
                       throws java.sql.SQLException
```
    Specified by:
    
    updateAsciiStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateBinaryStream
```
public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x)
                        throws java.sql.SQLException
```
    Specified by:
    
    updateBinaryStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateCharacterStream
```
public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x)
                           throws java.sql.SQLException
```
    Specified by:
    
    updateCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateAsciiStream
```
public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x)
                       throws java.sql.SQLException
```
    Specified by:
    
    updateAsciiStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateBinaryStream
```
public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x)
                        throws java.sql.SQLException
```
    Specified by:
    
    updateBinaryStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateCharacterStream
```
public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader)
                           throws java.sql.SQLException
```
    Specified by:
    
    updateCharacterStream in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateBlob
```
public void updateBlob(int columnIndex,
                       java.io.InputStream inputStream)
                throws java.sql.SQLException
```
    Specified by:
    
    updateBlob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateBlob
```
public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream)
                throws java.sql.SQLException
```
    Specified by:
    
    updateBlob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateClob
```
public void updateClob(int columnIndex,
                       java.io.Reader reader)
                throws java.sql.SQLException
```
    Specified by:
    
    updateClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateClob
```
public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader)
                throws java.sql.SQLException
```
    Specified by:
    
    updateClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateNClob
```
public void updateNClob(int columnIndex,
                        java.io.Reader reader)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateNClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - updateNClob
```
public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader)
                 throws java.sql.SQLException
```
    Specified by:
    
    updateNClob in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - clear
```
@OverridingMethodsMustInvokeSuper
protected void clear()
```
  - getObject
```
@CheckReturnValue
 @Nullable
public <T> T getObject(int columnIndex,
                                                    java.lang.Class<T> type)
                                             throws java.sql.SQLException
```
    Specified by:
    
    getObject in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException
  - getObject
```
@CheckReturnValue
 @Nullable
public <T> T getObject(java.lang.String columnLabel,
                                                    java.lang.Class<T> type)
                                             throws java.sql.SQLException
```
    Specified by:
    
    getObject in interface java.sql.ResultSet
    
    Throws:
    
    java.sql.SQLException

Class SResultSet

Field Summary

Fields inherited from interface java.sql.ResultSet

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.ResultSet

Field Detail

ALLOW_OVERFLOW

rowOffset

rowPage

columns

columnKeys

currentData

Constructor Detail

SResultSet

SResultSet

Method Detail

getColumns

formatOutput

getColumnCount

getColumnName

getColumnType

getColumnDisplaySize

rewind

next

fetchRow

load

setCurrentRow

close

wasNull

validToGet

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

sqlColumnNr

getString

getBoolean

getByte

getShort

getObject

getObject

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

getWarnings

clearWarnings

getCursorName

getMetaData

isNull

isNull

findColumnData

findColumnData

findColumn

decodeTableData

updateNull

updateBoolean

updateByte