IT. Expert System.

Android Reference

ResultSet

java.sql

Interface ResultSet

All Superinterfaces:

AutoCloseable, Wrapper

All Known Subinterfaces:

RowSet
```
public interface ResultSet
extends Wrapper, AutoCloseable
```
An interface for an object which represents a database table entry, returned as the result of the query to the database.
ResultSets have a cursor which points to the current data table row. When the ResultSet is created, the cursor's location is one position ahead of the first row. To move the cursor to the first and consecutive rows, use the next method. The next method returns true as long as there are more rows in the ResultSet, otherwise it returns false.
The default type of ResultSet can not be updated and its cursor can only advance forward through the rows of data. This means that it is only possible to read through it once. However, other kinds of ResultSet are implemented: an updatable type and also types where the cursor can be scrolled forward and backward through the rows of data. How such a ResultSet is created is demonstrated in the following example:
The ResultSet interface provides a series of methods for retrieving data from columns in the current row, such as getDate and getFloat. The columns are retrieved either by their index number (starting at 1) or by their name - there are separate methods for both techniques of column addressing. The column names are case insensitive. If several columns have the same name, then the getter methods use the first matching column. This means that if column names are used, it is not possible to guarantee that the name will retrieve data from the intended column - for certainty it is better to use column indexes. Ideally the columns should be read left-to-right and read once only, since not all databases are optimized to handle other techniques of reading the data.
When reading data via the appropriate getter methods, the JDBC driver maps the SQL data retrieved from the database to the Java type implied by the method invoked by the application. The JDBC specification has a table for the mappings from SQL types to Java types.
There are also methods for writing data into the ResultSet, such as updateInt and updateString. The update methods can be used either to modify the data of an existing row or to insert new data rows into the ResultSet . Modification of existing data involves moving the cursor to the row which needs modification and then using the update methods to modify the data, followed by calling the ResultSet.updateRow method. For insertion of new rows, the cursor is first moved to a special row called the Insert Row, data is added using the update methods, followed by calling the ResultSet.insertRow method.
A ResultSet is closed if the statement which generated it closes, the statement is executed again, or the same statement's next ResultSet is retrieved (if the statement returned of multiple results).

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`CLOSE_CURSORS_AT_COMMIT` A constant used to indicate that a `ResultSet` object must be closed when the method `Connection.commit` is invoked.
`static int`	`CONCUR_READ_ONLY` A constant used to indicate the concurrency mode for a `ResultSet` object that cannot be updated.
`static int`	`CONCUR_UPDATABLE` A constant used to indicate the concurrency mode for a `ResultSet` object that can be updated.
`static int`	`FETCH_FORWARD` A constant used to indicate processing of the rows of a `ResultSet` in the forward direction, first to last.
`static int`	`FETCH_REVERSE` A constant used to indicate processing of the rows of a `ResultSet` in the reverse direction, last to first.
`static int`	`FETCH_UNKNOWN` A constant used to indicate that the order of processing of the rows of a `ResultSet` is unknown.
`static int`	`HOLD_CURSORS_OVER_COMMIT` A constant used to indicate that a `ResultSet` object must not be closed when the method `Connection.commit` is invoked.
`static int`	`TYPE_FORWARD_ONLY` A constant used to indicate a `ResultSet` object whose cursor can only move forward.
`static int`	`TYPE_SCROLL_INSENSITIVE` A constant used to indicate a `ResultSet` object which is scrollable but is insensitive to changes made by others.
`static int`	`TYPE_SCROLL_SENSITIVE` A constant used to indicate a `ResultSet` object which is scrollable and sensitive to changes made by others.

Method Summary

Methods
Modifier and Type	Method and Description
`boolean`	`absolute(int row)` Moves the cursor to a specified row number in the `ResultSet`.
`void`	`afterLast()` Moves the cursor to the end of the `ResultSet`, after the last row.
`void`	`beforeFirst()` Moves the cursor to the start of the `ResultSet`, before the first row.
`void`	`cancelRowUpdates()` Cancels any updates made to the current row in the `ResultSet`.
`void`	`clearWarnings()` Clears all warnings related to this `ResultSet`.
`void`	`close()` Releases this `ResultSet`'s database and JDBC resources.
`void`	`deleteRow()` Deletes the current row from the `ResultSet` and from the underlying database.
`int`	`findColumn(String columnName)` Gets the index number for a column in the `ResultSet` from the provided column name.
`boolean`	`first()` Shifts the cursor position to the first row in the `ResultSet`.
`Array`	`getArray(int columnIndex)` Gets the content of a column specified by column index in the current row of this `ResultSet` as a `java.sql.Array`.
`Array`	`getArray(String colName)` Gets the value of a column specified by column name as a `java.sql.Array`.
`InputStream`	`getAsciiStream(int columnIndex)` Gets the value of a column specified by column index as an ASCII character stream.
`InputStream`	`getAsciiStream(String columnName)` Gets the value of a column specified by column name as an ASCII character stream.
`BigDecimal`	`getBigDecimal(int columnIndex)` Gets the value of a column specified by column index as a `java.math.BigDecimal`.
`BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated. use `getBigDecimal(int)` or `getBigDecimal(String)`
`BigDecimal`	`getBigDecimal(String columnName)` Gets the value of a column specified by column name, as a `java.math.BigDecimal`.
`BigDecimal`	`getBigDecimal(String columnName, int scale)` Deprecated. use `getBigDecimal(int)` or `getBigDecimal(String)`
`InputStream`	`getBinaryStream(int columnIndex)` Gets the value of a column specified by column index as a binary stream.
`InputStream`	`getBinaryStream(String columnName)` Gets the value of a column specified by column name as a binary stream.
`Blob`	`getBlob(int columnIndex)` Gets the value of a column specified by column index as a `java.sql.Blob` object.
`Blob`	`getBlob(String columnName)` Gets the value of a column specified by column name, as a `java.sql.Blob` object.
`boolean`	`getBoolean(int columnIndex)` Gets the value of a column specified by column index as a `boolean` .
`boolean`	`getBoolean(String columnName)` Gets the value of a column specified by column name, as a `boolean` .
`byte`	`getByte(int columnIndex)` Gets the value of a column specified by column index as a `byte`.
`byte`	`getByte(String columnName)` Gets the value of a column specified by column name as a `byte`.
`byte[]`	`getBytes(int columnIndex)` Gets the value of a column specified by column index as a byte array.
`byte[]`	`getBytes(String columnName)` Gets the value of a column specified by column name as a byte array.
`Reader`	`getCharacterStream(int columnIndex)` Gets the value of a column specified by column index as a `java.io.Reader` object.
`Reader`	`getCharacterStream(String columnName)` Gets the value of a column specified by column name as a `java.io.Reader` object.
`Clob`	`getClob(int columnIndex)` Gets the value of a column specified by column index as a `java.sql.Clob`.
`Clob`	`getClob(String colName)` Gets the value of a column specified by column name as a `java.sql.Clob`.
`int`	`getConcurrency()` Gets the concurrency mode of this `ResultSet`.
`String`	`getCursorName()` Gets the name of the SQL cursor of this `ResultSet`.
`Date`	`getDate(int columnIndex)` Gets the value of a column specified by column index as a `java.sql.Date`.
`Date`	`getDate(int columnIndex, Calendar cal)` Gets the value of a column specified by column index as a `java.sql.Date`.
`Date`	`getDate(String columnName)` Gets the value of a column specified by column name as a `java.sql.Date`.
`Date`	`getDate(String columnName, Calendar cal)` Gets the value of a column specified by column name, as a `java.sql.Date` object.
`double`	`getDouble(int columnIndex)` Gets the value of a column specified by column index as a `double` value.
`double`	`getDouble(String columnName)` Gets the value of a column specified by column name as a `double` value.
`int`	`getFetchDirection()` Gets the direction in which rows are fetched for this `ResultSet` object.
`int`	`getFetchSize()` Gets the fetch size (in number of rows) for this `ResultSet`.
`float`	`getFloat(int columnIndex)` Gets the value of a column specified by column index as a `float` value.
`float`	`getFloat(String columnName)` Gets the value of a column specified by column name as a `float` value.
`int`	`getHoldability()` Returns the holdability of this result set: `HOLD_CURSORS_OVER_COMMIT` or `CLOSE_CURSORS_AT_COMMIT`.
`int`	`getInt(int columnIndex)` Gets the value of a column specified by column index as an `int` value.
`int`	`getInt(String columnName)` Gets the value of a column specified by column name, as an `int` value.
`long`	`getLong(int columnIndex)` Gets the value of a column specified by column index as a `long` value.
`long`	`getLong(String columnName)` Gets the value of a column specified by column name, as a `long` value.
`ResultSetMetaData`	`getMetaData()` Gets the metadata for this `ResultSet`.
`Reader`	`getNCharacterStream(int columnIndex)` Returns a `Reader` corresponding to the value at the 1-based `columnIndex`.
`Reader`	`getNCharacterStream(String columnLabel)` Returns a `Reader` corresponding to the value in the named column.
`NClob`	`getNClob(int columnIndex)` Returns an `NClob` corresponding to the value at the 1-based `columnIndex`.
`NClob`	`getNClob(String columnLabel)` Returns an `NClob` corresponding to the value in the named column.
`String`	`getNString(int columnIndex)` Returns a `String` corresponding to the value at the 1-based `columnIndex`.
`String`	`getNString(String columnLabel)` Returns a `String` corresponding to the value in the named column.
`Object`	`getObject(int columnIndex)` Gets the value of a specified column as a Java `Object`.
`Object`	`getObject(int columnIndex, Map<String,Class<?>> map)` Gets the value of a column specified by column index as a Java `Object`.
`Object`	`getObject(String columnName)` Gets the value of a specified column as a Java `Object`.
`Object`	`getObject(String columnName, Map<String,Class<?>> map)` Gets the value of a column specified by column name as a Java `Object`.
`Ref`	`getRef(int columnIndex)` Gets the value of a column specified by column index as a Java `java.sql.Ref`.
`Ref`	`getRef(String colName)` Gets the value of a column specified by column name as a Java `java.sql.Ref`.
`int`	`getRow()` Gets the number of the current row in the `ResultSet`.
`RowId`	`getRowId(int columnIndex)` Returns a `RowId` corresponding to the SQL ROWID at the 1-based `columnIndex`.
`RowId`	`getRowId(String columnLabel)` Returns a `RowId` corresponding to the SQL ROWID at the named column.
`short`	`getShort(int columnIndex)` Gets the value of a column specified by column index as a short value.
`short`	`getShort(String columnName)` Gets the value of a column specified by column name, as a short value.
`SQLXML`	`getSQLXML(int columnIndex)` Returns an `SQLXML` corresponding to the value at the 1-based `columnIndex`.
`SQLXML`	`getSQLXML(String columnLabel)` Returns an `SQLXML` corresponding to the value in the named column.
`Statement`	`getStatement()` Gets the statement that produced this `ResultSet`.
`String`	`getString(int columnIndex)` Gets the value of a column specified by column index as a String.
`String`	`getString(String columnName)` Gets the value of a column specified by column name, as a String.
`Time`	`getTime(int columnIndex)` Gets the value of a column specified by column index as a `java.sql.Time` value.
`Time`	`getTime(int columnIndex, Calendar cal)` Gets the value of a column specified by column index as a `java.sql.Time` value.
`Time`	`getTime(String columnName)` Gets the value of a column specified by column name, as a `java.sql.Time` value.
`Time`	`getTime(String columnName, Calendar cal)` Gets the value of a column specified by column index, as a `java.sql.Time` value.
`Timestamp`	`getTimestamp(int columnIndex)` Gets the value of a column specified by column index as a `java.sql.Timestamp` value.
`Timestamp`	`getTimestamp(int columnIndex, Calendar cal)` Gets the value of a column specified by column index, as a `java.sql.Timestamp` value.
`Timestamp`	`getTimestamp(String columnName)` Gets the value of a column specified by column name, as a `java.sql.Timestamp` value.
`Timestamp`	`getTimestamp(String columnName, Calendar cal)` Gets the value of a column specified by column name, as a `java.sql.Timestamp` value.
`int`	`getType()` Gets the type of the `ResultSet`.
`InputStream`	`getUnicodeStream(int columnIndex)` Deprecated. Use `getCharacterStream(int)`.
`InputStream`	`getUnicodeStream(String columnName)` Deprecated. Use `getCharacterStream(int)`
`URL`	`getURL(int columnIndex)` Gets the value of a column specified by column index as a `java.net.URL`.
`URL`	`getURL(String columnName)` Gets the value of a column specified by column name as a `java.net.URL` object.
`SQLWarning`	`getWarnings()` Gets the first warning generated by calls on this `ResultSet`.
`void`	`insertRow()` Insert the insert row into the `ResultSet` and into the underlying database.
`boolean`	`isAfterLast()` Gets if the cursor is after the last row of the `ResultSet`.
`boolean`	`isBeforeFirst()` Gets if the cursor is before the first row of the `ResultSet`.
`boolean`	`isClosed()` Returns true if this result set has been closed, false otherwise.
`boolean`	`isFirst()` Gets if the cursor is on the first row of the `ResultSet`.
`boolean`	`isLast()` Gets if the cursor is on the last row of the `ResultSet`
`boolean`	`last()` Shifts the cursor position to the last row of the `ResultSet`.
`void`	`moveToCurrentRow()` Moves the cursor to the remembered position, namely the row that was the current row before a call to `moveToInsertRow`.
`void`	`moveToInsertRow()` Moves the cursor position to the Insert Row.
`boolean`	`next()` Shifts the cursor position down one row in this `ResultSet` object.
`boolean`	`previous()` Relocates the cursor position to the preceding row in this `ResultSet`.
`void`	`refreshRow()` Refreshes the current row with its most up to date value in the database.
`boolean`	`relative(int rows)` Moves the cursor position up or down by a specified number of rows.
`boolean`	`rowDeleted()` Indicates whether a row has been deleted.
`boolean`	`rowInserted()` Indicates whether the current row has had an insertion operation.
`boolean`	`rowUpdated()` Indicates whether the current row has been updated.
`void`	`setFetchDirection(int direction)` Indicates which direction (forward/reverse) will be used to process the rows of this `ResultSet` object.
`void`	`setFetchSize(int rows)` Indicates the number of rows to fetch from the database when extra rows are required for this `ResultSet`.
`void`	`updateArray(int columnIndex, Array x)` Updates a column specified by a column index with a `java.sql.Array` value.
`void`	`updateArray(String columnName, Array x)` Updates a column specified by a column name with a `java.sql.Array` value.
`void`	`updateAsciiStream(int columnIndex, InputStream x)` Updates the value at the 1-based `columnIndex`.
`void`	`updateAsciiStream(int columnIndex, InputStream x, int length)` Updates a column specified by a column index with an ASCII stream value.
`void`	`updateAsciiStream(int columnIndex, InputStream x, long length)` Updates the value at the 1-based `columnIndex`.
`void`	`updateAsciiStream(String columnLabel, InputStream x)` Updates the value in the named column.
`void`	`updateAsciiStream(String columnName, InputStream x, int length)` Updates a column specified by a column name with an Ascii stream value.
`void`	`updateAsciiStream(String columnLabel, InputStream x, long length)` Updates the value in the named column.
`void`	`updateBigDecimal(int columnIndex, BigDecimal x)` Updates a column specified by a column index with a `java.sql.BigDecimal` value.
`void`	`updateBigDecimal(String columnName, BigDecimal x)` Updates a column specified by a column name with a `java.sql.BigDecimal` value.
`void`	`updateBinaryStream(int columnIndex, InputStream x)` Updates the value at the 1-based `columnIndex`.
`void`	`updateBinaryStream(int columnIndex, InputStream x, int length)` Updates a column specified by a column index with a binary stream value.
`void`	`updateBinaryStream(int columnIndex, InputStream x, long length)` Updates the value at the 1-based `columnIndex`.
`void`	`updateBinaryStream(String columnLabel, InputStream x)` Updates the value in the named column.
`void`	`updateBinaryStream(String columnName, InputStream x, int length)` Updates a column specified by a column name with a binary stream value.
`void`	`updateBinaryStream(String columnLabel, InputStream x, long length)` Updates the value in the named column.
`void`	`updateBlob(int columnIndex, Blob x)` Updates a column specified by a column index with a `java.sql.Blob` value.
`void`	`updateBlob(int columnIndex, InputStream inputStream)` Updates the value at the 1-based `columnIndex`.
`void`	`updateBlob(int columnIndex, InputStream inputStream, long length)` Updates the value at the 1-based `columnIndex`.
`void`	`updateBlob(String columnName, Blob x)` Updates a column specified by a column name with a `java.sql.Blob` value.
`void`	`updateBlob(String columnLabel, InputStream inputStream)` Updates the value in the named column.
`void`	`updateBlob(String columnLabel, InputStream inputStream, long length)` Updates the value in the named column.
`void`	`updateBoolean(int columnIndex, boolean x)` Updates a column specified by a column index with a `boolean` value.
`void`	`updateBoolean(String columnName, boolean x)` Updates a column specified by a column name with a `boolean` value.
`void`	`updateByte(int columnIndex, byte x)` Updates a column specified by a column index with a `byte` value.
`void`	`updateByte(String columnName, byte x)` Updates a column specified by a column name with a `byte` value.
`void`	`updateBytes(int columnIndex, byte[] x)` Updates a column specified by a column index with a `byte` array value.
`void`	`updateBytes(String columnName, byte[] x)` Updates a column specified by a column name with a byte array value.
`void`	`updateCharacterStream(int columnIndex, Reader x)` Updates the value at the 1-based `columnIndex`.
`void`	`updateCharacterStream(int columnIndex, Reader x, int length)` Updates a column specified by a column index with a character stream value.
`void`	`updateCharacterStream(int columnIndex, Reader x, long length)` Updates the value at the 1-based `columnIndex`.
`void`	`updateCharacterStream(String columnLabel, Reader reader)` Updates the value in the named column.
`void`	`updateCharacterStream(String columnName, Reader reader, int length)` Updates a column specified by a column name with a character stream value.
`void`	`updateCharacterStream(String columnLabel, Reader reader, long length)` Updates the value in the named column.
`void`	`updateClob(int columnIndex, Clob x)` Updates a column specified by a column index with a `java.sql.Clob` value.
`void`	`updateClob(int columnIndex, Reader reader)` Updates the value at the 1-based `columnIndex`.
`void`	`updateClob(int columnIndex, Reader reader, long length)` Updates the value at the 1-based `columnIndex`.
`void`	`updateClob(String columnName, Clob x)` Updates a column specified by a column name with a `java.sql.Clob` value.
`void`	`updateClob(String columnLabel, Reader reader)` Updates the value in the named column.
`void`	`updateClob(String columnLabel, Reader reader, long length)` Updates the value in the named column.
`void`	`updateDate(int columnIndex, Date x)` Updates a column specified by a column index with a `java.sql.Date` value.
`void`	`updateDate(String columnName, Date x)` Updates a column specified by a column name with a `java.sql.Date` value.
`void`	`updateDouble(int columnIndex, double x)` Updates a column specified by a column index with a `double` value.
`void`	`updateDouble(String columnName, double x)` Updates a column specified by a column name with a `double` value.
`void`	`updateFloat(int columnIndex, float x)` Updates a column specified by a column index with a `float` value.
`void`	`updateFloat(String columnName, float x)` Updates a column specified by a column name with a `float` value.
`void`	`updateInt(int columnIndex, int x)` Updates a column specified by a column index with an `int` value.
`void`	`updateInt(String columnName, int x)` Updates a column specified by a column name with an `int` value.
`void`	`updateLong(int columnIndex, long x)` Updates a column specified by a column index with a `long` value.
`void`	`updateLong(String columnName, long x)` Updates a column specified by a column name with a `long` value.
`void`	`updateNCharacterStream(int columnIndex, Reader x)` Updates the value at the 1-based `columnIndex`.
`void`	`updateNCharacterStream(int columnIndex, Reader x, long length)` Updates the value at the 1-based `columnIndex`.
`void`	`updateNCharacterStream(String columnLabel, Reader reader)` Updates the value in the named column.
`void`	`updateNCharacterStream(String columnLabel, Reader reader, long length)` Updates the value in the named column.
`void`	`updateNClob(int columnIndex, NClob nClob)` Updates the value at the 1-based `columnIndex`.
`void`	`updateNClob(int columnIndex, Reader reader)` Updates the value at the 1-based `columnIndex`.
`void`	`updateNClob(int columnIndex, Reader reader, long length)` Updates the value at the 1-based `columnIndex`.
`void`	`updateNClob(String columnLabel, NClob nClob)` Updates the value in the named column.
`void`	`updateNClob(String columnLabel, Reader reader)` Updates the value in the named column.
`void`	`updateNClob(String columnLabel, Reader reader, long length)` Updates the value in the named column.
`void`	`updateNString(int columnIndex, String nString)` Updates the value at the 1-based `columnIndex`.
`void`	`updateNString(String columnLabel, String nString)` Updates the value in the named column.
`void`	`updateNull(int columnIndex)` Updates a column specified by a column index with a `null` value.
`void`	`updateNull(String columnName)` Updates a column specified by a column name with a `null` value.
`void`	`updateObject(int columnIndex, Object x)` Updates a column specified by a column index with an `Object` value.
`void`	`updateObject(int columnIndex, Object x, int scale)` Updates a column specified by a column index with an `Object` value.
`void`	`updateObject(String columnName, Object x)` Updates a column specified by a column name with an `Object` value.
`void`	`updateObject(String columnName, Object x, int scale)` Updates a column specified by a column name with an `Object` value.
`void`	`updateRef(int columnIndex, Ref x)` Updates a column specified by a column index with a `java.sql.Ref` value.
`void`	`updateRef(String columnName, Ref x)` Updates a column specified by a column name with a `java.sql.Ref` value.
`void`	`updateRow()` Updates the database with the new contents of the current row of this `ResultSet` object.
`void`	`updateRowId(int columnIndex, RowId value)` Updates the value at the 1-based `columnIndex`.
`void`	`updateRowId(String columnLabel, RowId value)` Updates the value in the named column.
`void`	`updateShort(int columnIndex, short x)` Updates a column specified by a column index with a `short` value.
`void`	`updateShort(String columnName, short x)` Updates a column specified by a column name with a `short` value.
`void`	`updateSQLXML(int columnIndex, SQLXML xmlObject)` Updates the value at the 1-based `columnIndex`.
`void`	`updateSQLXML(String columnLabel, SQLXML xmlObject)` Updates the value in the named column.
`void`	`updateString(int columnIndex, String x)` Updates a column specified by a column index with a `String` value.
`void`	`updateString(String columnName, String x)` Updates a column specified by a column name with a `String` value.
`void`	`updateTime(int columnIndex, Time x)` Updates a column specified by a column index with a `Time` value.
`void`	`updateTime(String columnName, Time x)` Updates a column specified by a column name with a `Time` value.
`void`	`updateTimestamp(int columnIndex, Timestamp x)` Updates a column specified by a column index with a `Timestamp` value.
`void`	`updateTimestamp(String columnName, Timestamp x)` Updates a column specified by column name with a `Timestamp` value.
`boolean`	`wasNull()` Determines whether the last column read from this `ResultSet` contained SQL `NULL`.

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

- Field Detail
  - CLOSE_CURSORS_AT_COMMIT
```
static final int CLOSE_CURSORS_AT_COMMIT
```
    A constant used to indicate that a ResultSet object must be closed when the method Connection.commit is invoked.
    
    See Also:
    Constant Field Values
  - HOLD_CURSORS_OVER_COMMIT
```
static final int HOLD_CURSORS_OVER_COMMIT
```
    A constant used to indicate that a ResultSet object must not be closed when the method Connection.commit is invoked.
    
    See Also:
    Constant Field Values
  - CONCUR_READ_ONLY
```
static final int CONCUR_READ_ONLY
```
    A constant used to indicate the concurrency mode for a ResultSet object that cannot be updated.
    
    See Also:
    Constant Field Values
  - CONCUR_UPDATABLE
```
static final int CONCUR_UPDATABLE
```
    A constant used to indicate the concurrency mode for a ResultSet object that can be updated.
    
    See Also:
    Constant Field Values
  - FETCH_FORWARD
```
static final int FETCH_FORWARD
```
    A constant used to indicate processing of the rows of a ResultSet in the forward direction, first to last.
    
    See Also:
    Constant Field Values
  - FETCH_REVERSE
```
static final int FETCH_REVERSE
```
    A constant used to indicate processing of the rows of a ResultSet in the reverse direction, last to first.
    
    See Also:
    Constant Field Values
  - FETCH_UNKNOWN
```
static final int FETCH_UNKNOWN
```
    A constant used to indicate that the order of processing of the rows of a ResultSet is unknown.
    
    See Also:
    Constant Field Values
  - TYPE_FORWARD_ONLY
```
static final int TYPE_FORWARD_ONLY
```
    A constant used to indicate a ResultSet object whose cursor can only move forward.
    
    See Also:
    Constant Field Values
  - TYPE_SCROLL_INSENSITIVE
```
static final int TYPE_SCROLL_INSENSITIVE
```
    A constant used to indicate a ResultSet object which is scrollable but is insensitive to changes made by others.
    
    See Also:
    Constant Field Values
  - TYPE_SCROLL_SENSITIVE
```
static final int TYPE_SCROLL_SENSITIVE
```
    A constant used to indicate a ResultSet object which is scrollable and sensitive to changes made by others.
    
    See Also:
    Constant Field Values
- Method Detail
  - absolute
```
boolean absolute(int row)
                 throws SQLException
```
    Moves the cursor to a specified row number in the ResultSet.
    
    Parameters:
    row - the index of the row starting at index 1. Index -1 returns the last row.
    
    Returns:
    true if the new cursor position is on the ResultSet, false otherwise.
    
    Throws:
    
    SQLException - if a database error happens.
  - afterLast
```
void afterLast()
               throws SQLException
```
    Moves the cursor to the end of the ResultSet, after the last row.
    
    Throws:
    
    SQLException - if a database error happens.
  - beforeFirst
```
void beforeFirst()
                 throws SQLException
```
    Moves the cursor to the start of the ResultSet, before the first row.
    
    Throws:
    
    SQLException - if a database error happens.
  - cancelRowUpdates
```
void cancelRowUpdates()
                      throws SQLException
```
    Cancels any updates made to the current row in the ResultSet.
    
    Throws:
    
    SQLException - if a database error happens.
  - clearWarnings
```
void clearWarnings()
                   throws SQLException
```
    Clears all warnings related to this ResultSet.
    
    Throws:
    
    SQLException - if a database error happens.
  - close
```
void close()
           throws SQLException
```
    Releases this ResultSet's database and JDBC resources. You are strongly advised to use this method rather than relying on the release being done when the ResultSet's finalize method is called during garbage collection process. Note that the close() method might take some time to complete since it is dependent on the behavior of the connection to the database and the database itself.
    
    Specified by:
    
    close in interface AutoCloseable
    
    Throws:
    
    SQLException - if a database error happens.
  - deleteRow
```
void deleteRow()
               throws SQLException
```
    Deletes the current row from the ResultSet and from the underlying database.
    
    Throws:
    
    SQLException - if a database error happens.
  - findColumn
```
int findColumn(String columnName)
               throws SQLException
```
    Gets the index number for a column in the ResultSet from the provided column name.
    
    Parameters:
    columnName - the column name.
    
    Returns:
    the column's index in the ResultSet identified by column name.
    
    Throws:
    
    SQLException - if a database error happens.
  - first
```
boolean first()
              throws SQLException
```
    Shifts the cursor position to the first row in the ResultSet.
    
    Returns:
    true if the position is in a legitimate row, false if the ResultSet contains no rows.
    
    Throws:
    
    SQLException - if a database error happens.
  - getArray
```
Array getArray(int columnIndex)
               throws SQLException
```
    Gets the content of a column specified by column index in the current row of this ResultSet as a java.sql.Array.
    
    Parameters:
    columnIndex - the index of the column to read
    
    Returns:
    a java.sql.Array with the data from the column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getArray
```
Array getArray(String colName)
               throws SQLException
```
    Gets the value of a column specified by column name as a java.sql.Array.
    
    Parameters:
    colName - the name of the column to read.
    
    Returns:
    a java.sql.Array with the data from the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getAsciiStream
```
InputStream getAsciiStream(int columnIndex)
                           throws SQLException
```
    Gets the value of a column specified by column index as an ASCII character stream.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    an InputStream with the data from the column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getAsciiStream
```
InputStream getAsciiStream(String columnName)
                           throws SQLException
```
    Gets the value of a column specified by column name as an ASCII character stream.
    
    Parameters:
    columnName - the name of the column to read
    
    Returns:
    an InputStream with the data from the column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBigDecimal
```
BigDecimal getBigDecimal(int columnIndex)
                         throws SQLException
```
    Gets the value of a column specified by column index as a java.math.BigDecimal.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a BigDecimal with the value of the column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBigDecimal
```
@Deprecated
BigDecimal getBigDecimal(int columnIndex,
                                  int scale)
                         throws SQLException
```
    Deprecated. use getBigDecimal(int) or getBigDecimal(String)
    
    Gets the value of a column specified by column index as a java.math.BigDecimal.
    
    Parameters:
    columnIndex - the index of the column to read.
    scale - the number of digits after the decimal point
    
    Returns:
    a BigDecimal with the value of the column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBigDecimal
```
BigDecimal getBigDecimal(String columnName)
                         throws SQLException
```
    Gets the value of a column specified by column name, as a java.math.BigDecimal.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a BigDecimal with value of the column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBigDecimal
```
@Deprecated
BigDecimal getBigDecimal(String columnName,
                                  int scale)
                         throws SQLException
```
    Deprecated. use getBigDecimal(int) or getBigDecimal(String)
    
    Gets the value of a column specified by column name, as a java.math.BigDecimal.
    
    Parameters:
    columnName - the name of the column to read.
    scale - the number of digits after the decimal point
    
    Returns:
    a BigDecimal with value of the column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBinaryStream
```
InputStream getBinaryStream(int columnIndex)
                            throws SQLException
```
    Gets the value of a column specified by column index as a binary stream.
    This method can be used to read LONGVARBINARY values. All of the data in the InputStream should be read before getting data from any other column. A further call to a getter method will implicitly close the InputStream.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    an InputStream with the data from the column. If the column value is SQL NULL, null is returned.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBinaryStream
```
InputStream getBinaryStream(String columnName)
                            throws SQLException
```
    Gets the value of a column specified by column name as a binary stream.
    This method can be used to read LONGVARBINARY values. All of the data in the InputStream should be read before getting data from any other column. A further call to a getter method will implicitly close the InputStream.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    an InputStream with the data from the column if the column value is SQL NULL, null is returned.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBlob
```
Blob getBlob(int columnIndex)
             throws SQLException
```
    Gets the value of a column specified by column index as a java.sql.Blob object.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a java.sql.Blob with the value of the column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBlob
```
Blob getBlob(String columnName)
             throws SQLException
```
    Gets the value of a column specified by column name, as a java.sql.Blob object.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a java.sql.Blob with the value of the column.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBoolean
```
boolean getBoolean(int columnIndex)
                   throws SQLException
```
    Gets the value of a column specified by column index as a boolean .
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a boolean value from the column. If the column is SQL NULL, false is returned.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBoolean
```
boolean getBoolean(String columnName)
                   throws SQLException
```
    Gets the value of a column specified by column name, as a boolean .
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a boolean value from the column. If the column is SQL NULL, false is returned.
    
    Throws:
    
    SQLException - if a database error happens.
  - getByte
```
byte getByte(int columnIndex)
             throws SQLException
```
    Gets the value of a column specified by column index as a byte.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a byte equal to the value of the column. 0 if the value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getByte
```
byte getByte(String columnName)
             throws SQLException
```
    Gets the value of a column specified by column name as a byte.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a byte equal to the value of the column. 0 if the value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBytes
```
byte[] getBytes(int columnIndex)
                throws SQLException
```
    Gets the value of a column specified by column index as a byte array.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a byte array containing the value of the column. null if the column contains SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getBytes
```
byte[] getBytes(String columnName)
                throws SQLException
```
    Gets the value of a column specified by column name as a byte array.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a byte array containing the value of the column. null if the column contains SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getCharacterStream
```
Reader getCharacterStream(int columnIndex)
                          throws SQLException
```
    Gets the value of a column specified by column index as a java.io.Reader object.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a Reader holding the value of the column. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
    See Also:
    Reader
  - getCharacterStream
```
Reader getCharacterStream(String columnName)
                          throws SQLException
```
    Gets the value of a column specified by column name as a java.io.Reader object.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a Reader holding the value of the column. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getClob
```
Clob getClob(int columnIndex)
             throws SQLException
```
    Gets the value of a column specified by column index as a java.sql.Clob.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a Clob object representing the value in the column. null if the value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getClob
```
Clob getClob(String colName)
             throws SQLException
```
    Gets the value of a column specified by column name as a java.sql.Clob.
    
    Parameters:
    colName - the name of the column to read.
    
    Returns:
    a Clob object representing the value in the column. null if the value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getConcurrency
```
int getConcurrency()
                   throws SQLException
```
    Gets the concurrency mode of this ResultSet.
    
    Returns:
    the concurrency mode - one of: ResultSet.CONCUR_READ_ONLY , ResultSet.CONCUR_UPDATABLE.
    
    Throws:
    
    SQLException - if a database error happens.
  - getCursorName
```
String getCursorName()
                     throws SQLException
```
    Gets the name of the SQL cursor of this ResultSet.
    
    Returns:
    the SQL cursor name.
    
    Throws:
    
    SQLException - if a database error happens.
  - getDate
```
Date getDate(int columnIndex)
             throws SQLException
```
    Gets the value of a column specified by column index as a java.sql.Date.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a java.sql.Date matching the column value. null if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getDate
```
Date getDate(int columnIndex,
           Calendar cal)
             throws SQLException
```
    Gets the value of a column specified by column index as a java.sql.Date. This method uses a supplied calendar to compute the Date.
    
    Parameters:
    columnIndex - the index of the column to read.
    cal - a java.util.Calendar to use in constructing the Date.
    
    Returns:
    a java.sql.Date matching the column value. null if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getDate
```
Date getDate(String columnName)
             throws SQLException
```
    Gets the value of a column specified by column name as a java.sql.Date.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a java.sql.Date matching the column value. null if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getDate
```
Date getDate(String columnName,
           Calendar cal)
             throws SQLException
```
    Gets the value of a column specified by column name, as a java.sql.Date object.
    
    Parameters:
    columnName - the name of the column to read.
    cal - java.util.Calendar to use in constructing the Date.
    
    Returns:
    a java.sql.Date matching the column value. null if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getDouble
```
double getDouble(int columnIndex)
                 throws SQLException
```
    Gets the value of a column specified by column index as a double value.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a double equal to the column value. 0.0 if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getDouble
```
double getDouble(String columnName)
                 throws SQLException
```
    Gets the value of a column specified by column name as a double value.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a double equal to the column value. 0.0 if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getFetchDirection
```
int getFetchDirection()
                      throws SQLException
```
    Gets the direction in which rows are fetched for this ResultSet object.
    Returns:
    the fetch direction. Will be one of:
    
    ResultSet.FETCH_FORWARD
    ResultSet.FETCH_REVERSE
    
    ResultSet.FETCH_UNKNOWN
    Throws:
    
    SQLException - if a database error happens.
  - getFetchSize
```
int getFetchSize()
                 throws SQLException
```
    Gets the fetch size (in number of rows) for this ResultSet.
    
    Returns:
    the fetch size as an int
    
    Throws:
    
    SQLException - if a database error happens.
  - getFloat
```
float getFloat(int columnIndex)
               throws SQLException
```
    Gets the value of a column specified by column index as a float value.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a float equal to the column value. 0.0 if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getFloat
```
float getFloat(String columnName)
               throws SQLException
```
    Gets the value of a column specified by column name as a float value.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a float equal to the column value. 0.0 if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getInt
```
int getInt(int columnIndex)
           throws SQLException
```
    Gets the value of a column specified by column index as an int value.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    an int equal to the column value. 0 if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getInt
```
int getInt(String columnName)
           throws SQLException
```
    Gets the value of a column specified by column name, as an int value.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    an int equal to the column value. 0 if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getLong
```
long getLong(int columnIndex)
             throws SQLException
```
    Gets the value of a column specified by column index as a long value.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a long equal to the column value. 0 if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getLong
```
long getLong(String columnName)
             throws SQLException
```
    Gets the value of a column specified by column name, as a long value.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a long equal to the column value. 0 if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getMetaData
```
ResultSetMetaData getMetaData()
                              throws SQLException
```
    Gets the metadata for this ResultSet. This defines the number, types and properties of the columns in the ResultSet.
    
    Returns:
    a ResultSetMetaData object with information about this ResultSet.
    
    Throws:
    
    SQLException - if a database error happens.
  - getObject
```
Object getObject(int columnIndex)
                 throws SQLException
```
    Gets the value of a specified column as a Java Object. The type of the returned object will be the default according to the column's SQL type, following the JDBC specification for built-in types.
    For SQL User Defined Types, if a column value is Structured or Distinct, this method behaves the same as a call to: getObject(columnIndex,this.getStatement().getConnection().getTypeMap())
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    an Object containing the value of the column. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getObject
```
Object getObject(int columnIndex,
               Map<String,Class<?>> map)
                 throws SQLException
```
    Gets the value of a column specified by column index as a Java Object.
    The type of the Java object will be determined by the supplied Map to perform the mapping of SQL Struct or Distinct types into Java objects.
    
    Parameters:
    columnIndex - the index of the column to read.
    map - a java.util.Map containing a mapping from SQL Type names to Java classes.
    
    Returns:
    an Object containing the value of the column. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getObject
```
Object getObject(String columnName)
                 throws SQLException
```
    Gets the value of a specified column as a Java Object. The type of the returned object will be the default according to the column's SQL type, following the JDBC specification for built-in types.
    For SQL User Defined Types, if a column value is structured or distinct, this method behaves the same as a call to: getObject(columnIndex,this.getStatement().getConnection().getTypeMap())
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    an Object containing the value of the column. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getObject
```
Object getObject(String columnName,
               Map<String,Class<?>> map)
                 throws SQLException
```
    Gets the value of a column specified by column name as a Java Object.
    The type of the Java object will be determined by the supplied Map to perform the mapping of SQL Struct or Distinct types into Java objects.
    
    Parameters:
    columnName - the name of the column to read.
    map - a java.util.Map containing a mapping from SQL Type names to Java classes.
    
    Returns:
    an Object containing the value of the column. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getRef
```
Ref getRef(int columnIndex)
           throws SQLException
```
    Gets the value of a column specified by column index as a Java java.sql.Ref.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a Ref representing the value of the SQL REF in the column
    
    Throws:
    
    SQLException - if a database error happens.
  - getRef
```
Ref getRef(String colName)
           throws SQLException
```
    Gets the value of a column specified by column name as a Java java.sql.Ref.
    
    Parameters:
    colName - the name of the column to read.
    
    Returns:
    a Ref representing the value of the SQL REF in the column
    
    Throws:
    
    SQLException - if a database error happens.
  - getRow
```
int getRow()
           throws SQLException
```
    Gets the number of the current row in the ResultSet. Row numbers start at 1 for the first row.
    
    Returns:
    the index number of the current row. 0 is returned if there is no current row.
    
    Throws:
    
    SQLException - if a database error happens.
  - getShort
```
short getShort(int columnIndex)
               throws SQLException
```
    Gets the value of a column specified by column index as a short value.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a short value equal to the value of the column. 0 if the value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getShort
```
short getShort(String columnName)
               throws SQLException
```
    Gets the value of a column specified by column name, as a short value.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a short value equal to the value of the column. 0 if the value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getStatement
```
Statement getStatement()
                       throws SQLException
```
    Gets the statement that produced this ResultSet. If the ResultSet was not created by a statement (i.e. because it was returned from one of the DatabaseMetaData methods), null is returned.
    
    Returns:
    the Statement which produced this ResultSet, or null if the ResultSet was not created by a Statement.
    
    Throws:
    
    SQLException - if a database error happens.
  - getString
```
String getString(int columnIndex)
                 throws SQLException
```
    Gets the value of a column specified by column index as a String.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    the String representing the value of the column, null if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getString
```
String getString(String columnName)
                 throws SQLException
```
    Gets the value of a column specified by column name, as a String.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    the String representing the value of the column, null if the column is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getTime
```
Time getTime(int columnIndex)
             throws SQLException
```
    Gets the value of a column specified by column index as a java.sql.Time value.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a Time representing the column value, null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getTime
```
Time getTime(int columnIndex,
           Calendar cal)
             throws SQLException
```
    Gets the value of a column specified by column index as a java.sql.Time value. The supplied Calendar is used to map the SQL Time value to a Java Time value.
    
    Parameters:
    columnIndex - the index of the column to read.
    cal - a Calendar to use in creating the Java Time value.
    
    Returns:
    a Time representing the column value, null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getTime
```
Time getTime(String columnName)
             throws SQLException
```
    Gets the value of a column specified by column name, as a java.sql.Time value.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    the column value, null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getTime
```
Time getTime(String columnName,
           Calendar cal)
             throws SQLException
```
    Gets the value of a column specified by column index, as a java.sql.Time value. The supplied Calendar is used to map the SQL Time value to a Java Time value.
    
    Parameters:
    columnName - the name of the column to read.
    cal - a Calendar to use in creating the Java time value.
    
    Returns:
    a Time representing the column value, null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getTimestamp
```
Timestamp getTimestamp(int columnIndex)
                       throws SQLException
```
    Gets the value of a column specified by column index as a java.sql.Timestamp value.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a timestamp representing the column value, null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getTimestamp
```
Timestamp getTimestamp(int columnIndex,
                     Calendar cal)
                       throws SQLException
```
    Gets the value of a column specified by column index, as a java.sql.Timestamp value. The supplied Calendar is used when mapping the SQL Timestamp value to a Java Timestamp value.
    
    Parameters:
    columnIndex - the index of the column to read.
    cal - Calendar to use in creating the Java timestamp value.
    
    Returns:
    a timestamp representing the column value, null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getTimestamp
```
Timestamp getTimestamp(String columnName)
                       throws SQLException
```
    Gets the value of a column specified by column name, as a java.sql.Timestamp value.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    a timestamp representing the column value, null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getTimestamp
```
Timestamp getTimestamp(String columnName,
                     Calendar cal)
                       throws SQLException
```
    Gets the value of a column specified by column name, as a java.sql.Timestamp value. The supplied Calendar is used when mapping the SQL Timestamp value to a Java Timestamp value.
    
    Parameters:
    columnName - the name of the column to read.
    cal - Calendar to use in creating the Java Timestamp value.
    
    Returns:
    a timestamp representing the column value, null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getType
```
int getType()
            throws SQLException
```
    Gets the type of the ResultSet.
    Returns:
    The ResultSet type, one of:
    
    ResultSet.TYPE_FORWARD_ONLY
    
    ResultSet.TYPE_SCROLL_INSENSITIVE
    
    ResultSet.TYPE_SCROLL_SENSITIVE
    Throws:
    
    SQLException - if there is a database error.
  - getUnicodeStream
```
@Deprecated
InputStream getUnicodeStream(int columnIndex)
                             throws SQLException
```
    Deprecated. Use getCharacterStream(int).
    
    Gets the value of the column as an InputStream of unicode characters.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    an InputStream holding the value of the column. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getUnicodeStream
```
@Deprecated
InputStream getUnicodeStream(String columnName)
                             throws SQLException
```
    Deprecated. Use getCharacterStream(int)
    
    Gets the value of the column as an InputStream of Unicode characters.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    an InputStream holding the value of the column. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getURL
```
URL getURL(int columnIndex)
           throws SQLException
```
    Gets the value of a column specified by column index as a java.net.URL.
    
    Parameters:
    columnIndex - the index of the column to read.
    
    Returns:
    a URL. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getURL
```
URL getURL(String columnName)
           throws SQLException
```
    Gets the value of a column specified by column name as a java.net.URL object.
    
    Parameters:
    columnName - the name of the column to read.
    
    Returns:
    the column vaule as a URL. null if the column value is SQL NULL.
    
    Throws:
    
    SQLException - if a database error happens.
  - getWarnings
```
SQLWarning getWarnings()
                       throws SQLException
```
    Gets the first warning generated by calls on this ResultSet. Subsequent warnings on this ResultSet are chained to the first one.
    The warnings are cleared when a new Row is read from the ResultSet. The warnings returned by this method are only the warnings generated by ResultSet method calls - warnings generated by Statement methods are held by the Statement.
    An SQLException is generated if this method is called on a closed ResultSet.
    
    Returns:
    an SQLWarning which is the first warning for this ResultSet. null if there are no warnings.
    
    Throws:
    
    SQLException - if a database error happens.
  - insertRow
```
void insertRow()
               throws SQLException
```
    Insert the insert row into the ResultSet and into the underlying database. The cursor must be set to the Insert Row before this method is invoked.
    
    Throws:
    
    SQLException - if a database error happens. Particular cases include the cursor not being on the Insert Row or if any columns in the row do not have a value where the column is declared as not-nullable.
  - isAfterLast
```
boolean isAfterLast()
                    throws SQLException
```
    Gets if the cursor is after the last row of the ResultSet.
    
    Returns:
    true if the cursor is after the last row in the ResultSet, false if the cursor is at any other position in the ResultSet.
    
    Throws:
    
    SQLException - if a database error happens.
  - isBeforeFirst
```
boolean isBeforeFirst()
                      throws SQLException
```
    Gets if the cursor is before the first row of the ResultSet.
    
    Returns:
    true if the cursor is before the first row in the ResultSet, false if the cursor is at any other position in the ResultSet.
    
    Throws:
    
    SQLException - if a database error happens.
  - isFirst
```
boolean isFirst()
                throws SQLException
```
    Gets if the cursor is on the first row of the ResultSet.
    
    Returns:
    true if the cursor is on the first row in the ResultSet, false if the cursor is at any other position in the ResultSet.
    
    Throws:
    
    SQLException - if a database error happens.
  - isLast
```
boolean isLast()
               throws SQLException
```
    Gets if the cursor is on the last row of the ResultSet
    
    Returns:
    true if the cursor is on the last row in the ResultSet, false if the cursor is at any other position in the ResultSet.
    
    Throws:
    
    SQLException - if a database error happens.
  - last
```
boolean last()
             throws SQLException
```
    Shifts the cursor position to the last row of the ResultSet.
    
    Returns:
    true if the new position is in a legitimate row, false if the ResultSet contains no rows.
    
    Throws:
    
    SQLException - if there is a database error.
  - moveToCurrentRow
```
void moveToCurrentRow()
                      throws SQLException
```
    Moves the cursor to the remembered position, namely the row that was the current row before a call to moveToInsertRow. This only applies if the cursor is on the Insert Row.
    
    Throws:
    
    SQLException - if a database error happens.
  - moveToInsertRow
```
void moveToInsertRow()
                     throws SQLException
```
    Moves the cursor position to the Insert Row. The current position is remembered and the cursor is positioned at the Insert Row. The columns in the Insert Row should be filled in with the appropriate update methods, before calling insertRow to insert the new row into the database.
    
    Throws:
    
    SQLException - if a database error happens.
  - next
```
boolean next()
             throws SQLException
```
    Shifts the cursor position down one row in this ResultSet object.
    Any input streams associated with the current row are closed and any warnings are cleared.
    
    Returns:
    true if the updated cursor position is pointing to a valid row, false otherwise (i.e. when the cursor is after the last row in the ResultSet).
    
    Throws:
    
    SQLException - if a database error happens.
  - previous
```
boolean previous()
                 throws SQLException
```
    Relocates the cursor position to the preceding row in this ResultSet.
    
    Returns:
    true if the new position is in a legitimate row, false if the cursor is now before the first row.
    
    Throws:
    
    SQLException - if a database error happens.
  - refreshRow
```
void refreshRow()
                throws SQLException
```
    Refreshes the current row with its most up to date value in the database. Must not be called when the cursor is on the Insert Row.
    If any columns in the current row have been updated but the updateRow has not been called, then the updates are lost when this method is called.
    
    Throws:
    
    SQLException - if a database error happens., including if the current row is the Insert row.
  - relative
```
boolean relative(int rows)
                 throws SQLException
```
    Moves the cursor position up or down by a specified number of rows. If the new position is beyond the start row (or end row), the cursor position is set before the first row (or, respectively, after the last row).
    
    Parameters:
    rows - a number of rows to move the cursor - may be positive or negative
    
    Returns:
    true if the new cursor position is on a row, false otherwise
    
    Throws:
    
    SQLException - if a database error happens.
  - rowDeleted
```
boolean rowDeleted()
                   throws SQLException
```
    Indicates whether a row has been deleted. This method depends on whether the JDBC driver and database can detect deletions.
    
    Returns:
    true if a row has been deleted and if deletions are detected, false otherwise.
    
    Throws:
    
    SQLException - if a database error happens.
  - rowInserted
```
boolean rowInserted()
                    throws SQLException
```
    Indicates whether the current row has had an insertion operation. This method depends on whether the JDBC driver and database can detect insertions.
    
    Returns:
    true if a row has been inserted and if insertions are detected, false otherwise.
    
    Throws:
    
    SQLException - if a database error happens.
  - rowUpdated
```
boolean rowUpdated()
                   throws SQLException
```
    Indicates whether the current row has been updated. This method depends on whether the JDBC driver and database can detect updates.
    
    Returns:
    true if the current row has been updated and if updates can be detected, false otherwise.
    
    Throws:
    
    SQLException - if a database error happens.
  - setFetchDirection
```
void setFetchDirection(int direction)
                       throws SQLException
```
    Indicates which direction (forward/reverse) will be used to process the rows of this ResultSet object. This is treated as a hint by the JDBC driver.
    
    Parameters:
    direction - can be ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
    
    Throws:
    
    SQLException - if there is a database error.
  - setFetchSize
```
void setFetchSize(int rows)
                  throws SQLException
```
    Indicates the number of rows to fetch from the database when extra rows are required for this ResultSet. This used as a hint to the JDBC driver.
    
    Parameters:
    rows - the number of rows to fetch. 0 implies that the JDBC driver can make its own decision about the fetch size. The number should not be greater than the maximum number of rows established by the statement that generated the ResultSet.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateArray
```
void updateArray(int columnIndex,
               Array x)
                 throws SQLException
```
    Updates a column specified by a column index with a java.sql.Array value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateArray
```
void updateArray(String columnName,
               Array x)
                 throws SQLException
```
    Updates a column specified by a column name with a java.sql.Array value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateAsciiStream
```
void updateAsciiStream(int columnIndex,
                     InputStream x,
                     int length)
                       throws SQLException
```
    Updates a column specified by a column index with an ASCII stream value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    length - the length of the data to write from the stream
    
    Throws:
    
    SQLException - if a database error happens.
  - updateAsciiStream
```
void updateAsciiStream(String columnName,
                     InputStream x,
                     int length)
                       throws SQLException
```
    Updates a column specified by a column name with an Ascii stream value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    length - the length of the data to write from the stream
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBigDecimal
```
void updateBigDecimal(int columnIndex,
                    BigDecimal x)
                      throws SQLException
```
    Updates a column specified by a column index with a java.sql.BigDecimal value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBigDecimal
```
void updateBigDecimal(String columnName,
                    BigDecimal x)
                      throws SQLException
```
    Updates a column specified by a column name with a java.sql.BigDecimal value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBinaryStream
```
void updateBinaryStream(int columnIndex,
                      InputStream x,
                      int length)
                        throws SQLException
```
    Updates a column specified by a column index with a binary stream value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    length - the number of bytes to be read from the the stream.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBinaryStream
```
void updateBinaryStream(String columnName,
                      InputStream x,
                      int length)
                        throws SQLException
```
    Updates a column specified by a column name with a binary stream value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    length - he number of bytes to be read from the the stream.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBlob
```
void updateBlob(int columnIndex,
              Blob x)
                throws SQLException
```
    Updates a column specified by a column index with a java.sql.Blob value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBlob
```
void updateBlob(String columnName,
              Blob x)
                throws SQLException
```
    Updates a column specified by a column name with a java.sql.Blob value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBoolean
```
void updateBoolean(int columnIndex,
                 boolean x)
                   throws SQLException
```
    Updates a column specified by a column index with a boolean value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBoolean
```
void updateBoolean(String columnName,
                 boolean x)
                   throws SQLException
```
    Updates a column specified by a column name with a boolean value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateByte
```
void updateByte(int columnIndex,
              byte x)
                throws SQLException
```
    Updates a column specified by a column index with a byte value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateByte
```
void updateByte(String columnName,
              byte x)
                throws SQLException
```
    Updates a column specified by a column name with a byte value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBytes
```
void updateBytes(int columnIndex,
               byte[] x)
                 throws SQLException
```
    Updates a column specified by a column index with a byte array value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateBytes
```
void updateBytes(String columnName,
               byte[] x)
                 throws SQLException
```
    Updates a column specified by a column name with a byte array value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateCharacterStream
```
void updateCharacterStream(int columnIndex,
                         Reader x,
                         int length)
                           throws SQLException
```
    Updates a column specified by a column index with a character stream value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    length - the length of data to write from the stream
    
    Throws:
    
    SQLException - if a database error happens.
  - updateCharacterStream
```
void updateCharacterStream(String columnName,
                         Reader reader,
                         int length)
                           throws SQLException
```
    Updates a column specified by a column name with a character stream value.
    
    Parameters:
    columnName - the name of the column to update.
    reader - the new value for the specified column.
    length - the length of data to write from the Reader
    
    Throws:
    
    SQLException - if a database error happens.
  - updateClob
```
void updateClob(int columnIndex,
              Clob x)
                throws SQLException
```
    Updates a column specified by a column index with a java.sql.Clob value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateClob
```
void updateClob(String columnName,
              Clob x)
                throws SQLException
```
    Updates a column specified by a column name with a java.sql.Clob value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateDate
```
void updateDate(int columnIndex,
              Date x)
                throws SQLException
```
    Updates a column specified by a column index with a java.sql.Date value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateDate
```
void updateDate(String columnName,
              Date x)
                throws SQLException
```
    Updates a column specified by a column name with a java.sql.Date value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateDouble
```
void updateDouble(int columnIndex,
                double x)
                  throws SQLException
```
    Updates a column specified by a column index with a double value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateDouble
```
void updateDouble(String columnName,
                double x)
                  throws SQLException
```
    Updates a column specified by a column name with a double value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateFloat
```
void updateFloat(int columnIndex,
               float x)
                 throws SQLException
```
    Updates a column specified by a column index with a float value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateFloat
```
void updateFloat(String columnName,
               float x)
                 throws SQLException
```
    Updates a column specified by a column name with a float value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateInt
```
void updateInt(int columnIndex,
             int x)
               throws SQLException
```
    Updates a column specified by a column index with an int value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateInt
```
void updateInt(String columnName,
             int x)
               throws SQLException
```
    Updates a column specified by a column name with an int value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateLong
```
void updateLong(int columnIndex,
              long x)
                throws SQLException
```
    Updates a column specified by a column index with a long value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column..
    
    Throws:
    
    SQLException - if a database error happens.
  - updateLong
```
void updateLong(String columnName,
              long x)
                throws SQLException
```
    Updates a column specified by a column name with a long value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateNull
```
void updateNull(int columnIndex)
                throws SQLException
```
    Updates a column specified by a column index with a null value.
    
    Parameters:
    columnIndex - the index of the column to update.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateNull
```
void updateNull(String columnName)
                throws SQLException
```
    Updates a column specified by a column name with a null value.
    
    Parameters:
    columnName - the name of the column to update.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateObject
```
void updateObject(int columnIndex,
                Object x)
                  throws SQLException
```
    Updates a column specified by a column index with an Object value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateObject
```
void updateObject(int columnIndex,
                Object x,
                int scale)
                  throws SQLException
```
    Updates a column specified by a column index with an Object value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    scale - for the types java.sql.Types.DECIMAL or java.sql.Types.NUMERIC, this specifies the number of digits after the decimal point.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateObject
```
void updateObject(String columnName,
                Object x)
                  throws SQLException
```
    Updates a column specified by a column name with an Object value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateObject
```
void updateObject(String columnName,
                Object x,
                int scale)
                  throws SQLException
```
    Updates a column specified by a column name with an Object value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    scale - for the types java.sql.Types.DECIMAL or java.sql.Types.NUMERIC, this specifies the number of digits after the decimal point.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateRef
```
void updateRef(int columnIndex,
             Ref x)
               throws SQLException
```
    Updates a column specified by a column index with a java.sql.Ref value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateRef
```
void updateRef(String columnName,
             Ref x)
               throws SQLException
```
    Updates a column specified by a column name with a java.sql.Ref value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateRow
```
void updateRow()
               throws SQLException
```
    Updates the database with the new contents of the current row of this ResultSet object.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateShort
```
void updateShort(int columnIndex,
               short x)
                 throws SQLException
```
    Updates a column specified by a column index with a short value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateShort
```
void updateShort(String columnName,
               short x)
                 throws SQLException
```
    Updates a column specified by a column name with a short value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateString
```
void updateString(int columnIndex,
                String x)
                  throws SQLException
```
    Updates a column specified by a column index with a String value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateString
```
void updateString(String columnName,
                String x)
                  throws SQLException
```
    Updates a column specified by a column name with a String value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateTime
```
void updateTime(int columnIndex,
              Time x)
                throws SQLException
```
    Updates a column specified by a column index with a Time value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateTime
```
void updateTime(String columnName,
              Time x)
                throws SQLException
```
    Updates a column specified by a column name with a Time value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateTimestamp
```
void updateTimestamp(int columnIndex,
                   Timestamp x)
                     throws SQLException
```
    Updates a column specified by a column index with a Timestamp value.
    
    Parameters:
    columnIndex - the index of the column to update.
    x - the new timestamp value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - updateTimestamp
```
void updateTimestamp(String columnName,
                   Timestamp x)
                     throws SQLException
```
    Updates a column specified by column name with a Timestamp value.
    
    Parameters:
    columnName - the name of the column to update.
    x - the new timestamp value for the specified column.
    
    Throws:
    
    SQLException - if a database error happens.
  - wasNull
```
boolean wasNull()
                throws SQLException
```
    Determines whether the last column read from this ResultSet contained SQL NULL.
    
    Returns:
    {@code true} if the last column contained SQL {@code NULL}, {@code false} otherwise
    
    Throws:
    
    SQLException - if a database error happens.
  - getRowId
```
RowId getRowId(int columnIndex)
               throws SQLException
```
    Returns a RowId corresponding to the SQL ROWID at the 1-based columnIndex.
    
    Throws:
    
    SQLException
  - getRowId
```
RowId getRowId(String columnLabel)
               throws SQLException
```
    Returns a RowId corresponding to the SQL ROWID at the named column.
    
    Throws:
    
    SQLException
  - updateRowId
```
void updateRowId(int columnIndex,
               RowId value)
                 throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateRowId
```
void updateRowId(String columnLabel,
               RowId value)
                 throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - getHoldability
```
int getHoldability()
                   throws SQLException
```
    Returns the holdability of this result set: HOLD_CURSORS_OVER_COMMIT or CLOSE_CURSORS_AT_COMMIT.
    
    Throws:
    
    SQLException
  - isClosed
```
boolean isClosed()
                 throws SQLException
```
    Returns true if this result set has been closed, false otherwise.
    
    Throws:
    
    SQLException
  - updateNString
```
void updateNString(int columnIndex,
                 String nString)
                   throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNString
```
void updateNString(String columnLabel,
                 String nString)
                   throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNClob
```
void updateNClob(int columnIndex,
               NClob nClob)
                 throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNClob
```
void updateNClob(String columnLabel,
               NClob nClob)
                 throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - getNClob
```
NClob getNClob(int columnIndex)
               throws SQLException
```
    Returns an NClob corresponding to the value at the 1-based columnIndex.
    
    Throws:
    
    SQLException
  - getNClob
```
NClob getNClob(String columnLabel)
               throws SQLException
```
    Returns an NClob corresponding to the value in the named column.
    
    Throws:
    
    SQLException
  - getSQLXML
```
SQLXML getSQLXML(int columnIndex)
                 throws SQLException
```
    Returns an SQLXML corresponding to the value at the 1-based columnIndex.
    
    Throws:
    
    SQLException
  - getSQLXML
```
SQLXML getSQLXML(String columnLabel)
                 throws SQLException
```
    Returns an SQLXML corresponding to the value in the named column.
    
    Throws:
    
    SQLException
  - updateSQLXML
```
void updateSQLXML(int columnIndex,
                SQLXML xmlObject)
                  throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateSQLXML
```
void updateSQLXML(String columnLabel,
                SQLXML xmlObject)
                  throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - getNString
```
String getNString(int columnIndex)
                  throws SQLException
```
    Returns a String corresponding to the value at the 1-based columnIndex.
    
    Throws:
    
    SQLException
  - getNString
```
String getNString(String columnLabel)
                  throws SQLException
```
    Returns a String corresponding to the value in the named column.
    
    Throws:
    
    SQLException
  - getNCharacterStream
```
Reader getNCharacterStream(int columnIndex)
                           throws SQLException
```
    Returns a Reader corresponding to the value at the 1-based columnIndex.
    
    Throws:
    
    SQLException
  - getNCharacterStream
```
Reader getNCharacterStream(String columnLabel)
                           throws SQLException
```
    Returns a Reader corresponding to the value in the named column.
    
    Throws:
    
    SQLException
  - updateNCharacterStream
```
void updateNCharacterStream(int columnIndex,
                          Reader x,
                          long length)
                            throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNCharacterStream
```
void updateNCharacterStream(String columnLabel,
                          Reader reader,
                          long length)
                            throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateAsciiStream
```
void updateAsciiStream(int columnIndex,
                     InputStream x,
                     long length)
                       throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateBinaryStream
```
void updateBinaryStream(int columnIndex,
                      InputStream x,
                      long length)
                        throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateCharacterStream
```
void updateCharacterStream(int columnIndex,
                         Reader x,
                         long length)
                           throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateAsciiStream
```
void updateAsciiStream(String columnLabel,
                     InputStream x,
                     long length)
                       throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateBinaryStream
```
void updateBinaryStream(String columnLabel,
                      InputStream x,
                      long length)
                        throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateCharacterStream
```
void updateCharacterStream(String columnLabel,
                         Reader reader,
                         long length)
                           throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateBlob
```
void updateBlob(int columnIndex,
              InputStream inputStream,
              long length)
                throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateBlob
```
void updateBlob(String columnLabel,
              InputStream inputStream,
              long length)
                throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateClob
```
void updateClob(int columnIndex,
              Reader reader,
              long length)
                throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateClob
```
void updateClob(String columnLabel,
              Reader reader,
              long length)
                throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNClob
```
void updateNClob(int columnIndex,
               Reader reader,
               long length)
                 throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNClob
```
void updateNClob(String columnLabel,
               Reader reader,
               long length)
                 throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNCharacterStream
```
void updateNCharacterStream(int columnIndex,
                          Reader x)
                            throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNCharacterStream
```
void updateNCharacterStream(String columnLabel,
                          Reader reader)
                            throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateAsciiStream
```
void updateAsciiStream(int columnIndex,
                     InputStream x)
                       throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateBinaryStream
```
void updateBinaryStream(int columnIndex,
                      InputStream x)
                        throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateCharacterStream
```
void updateCharacterStream(int columnIndex,
                         Reader x)
                           throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateAsciiStream
```
void updateAsciiStream(String columnLabel,
                     InputStream x)
                       throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateBinaryStream
```
void updateBinaryStream(String columnLabel,
                      InputStream x)
                        throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateCharacterStream
```
void updateCharacterStream(String columnLabel,
                         Reader reader)
                           throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateBlob
```
void updateBlob(int columnIndex,
              InputStream inputStream)
                throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateBlob
```
void updateBlob(String columnLabel,
              InputStream inputStream)
                throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateClob
```
void updateClob(int columnIndex,
              Reader reader)
                throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateClob
```
void updateClob(String columnLabel,
              Reader reader)
                throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNClob
```
void updateNClob(int columnIndex,
               Reader reader)
                 throws SQLException
```
    Updates the value at the 1-based columnIndex. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException
  - updateNClob
```
void updateNClob(String columnLabel,
               Reader reader)
                 throws SQLException
```
    Updates the value in the named column. The underlying database isn't changed until the next row update or insert operation.
    
    Throws:
    
    SQLException

Content

Android Reference

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.

All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.

IT. Expert System.

Android Reference

ResultSet

Interface ResultSet

Field Summary

Method Summary

Methods inherited from interface java.sql.Wrapper

Field Detail

CLOSE_CURSORS_AT_COMMIT

HOLD_CURSORS_OVER_COMMIT

CONCUR_READ_ONLY

CONCUR_UPDATABLE

FETCH_FORWARD

FETCH_REVERSE

FETCH_UNKNOWN

TYPE_FORWARD_ONLY

TYPE_SCROLL_INSENSITIVE

TYPE_SCROLL_SENSITIVE

Method Detail

absolute

afterLast

beforeFirst

cancelRowUpdates

clearWarnings

close

deleteRow

findColumn

first

getArray

getArray

getAsciiStream

getAsciiStream

getBigDecimal

getBigDecimal

getBigDecimal

getBigDecimal

getBinaryStream

getBinaryStream

getBlob

getBlob

getBoolean

getBoolean

getByte

getByte

getBytes

getBytes

getCharacterStream

getCharacterStream

getClob

getClob

getConcurrency

getCursorName

getDate

getDate

getDate

getDate

getDouble

getDouble

getFetchDirection

getFetchSize

getFloat

getFloat

getInt

getInt

getLong

getLong

getMetaData

getObject

getObject

getObject

getObject

getRef

getRef

getRow

getShort

getShort

getStatement

getString

getString

getTime