ResultSet (Java Platform SE 6)

A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.

A default ResultSet object is not updatable and has a cursor that moves forward only. Thus, you can iterate through it only once and only from the first row to the last row. It is possible to produce ResultSet objects that are scrollable and/or updatable. The following code fragment, in which con is a valid Connection object, illustrates how to make a result set that is scrollable and insensitive to updates by others, and that is updatable. See ResultSet fields for other options.


       Statement stmt = con.createStatement(
                                      ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
       ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2");
       // rs will be scrollable, will not show changes made by others,
       // and will be updatable

The ResultSet interface provides getter methods (getBoolean, getLong, and so on) for retrieving column values from the current row. Values can be retrieved using either the index number of the column or the name of the column. In general, using the column index will be more efficient. Columns are numbered from 1. For maximum portability, result set columns within each row should be read in left-to-right order, and each column should be read only once.

For the getter methods, a JDBC driver attempts to convert the underlying data to the Java type specified in the getter method and returns a suitable Java value. The JDBC specification has a table showing the allowable mappings from SQL types to Java types that can be used by the ResultSet getter methods.

Column names used as input to getter methods are case insensitive. When a getter method is called with a column name and several columns have the same name, the value of the first matching column will be returned. The column name option is designed to be used when column names are used in the SQL query that generated the result set. For columns that are NOT explicitly named in the query, it is best to use column numbers. If column names are used, the programmer should take care to guarantee that they uniquely refer to the intended columns, which can be assured with the SQL AS clause.

A set of updater methods were added to this interface in the JDBC 2.0 API (Java^TM 2 SDK, Standard Edition, version 1.2). The comments regarding parameters to the getter methods also apply to parameters to the updater methods.

The updater methods may be used in two ways:

to update a column value in the current row. In a scrollable ResultSet object, the cursor can be moved backwards and forwards, to an absolute position, or to a position relative to the current row. The following code fragment updates the NAME column in the fifth row of the ResultSet object rs and then uses the method updateRow to update the data source table from which rs was derived.
```
       rs.absolute(5); // moves the cursor to the fifth row of rs
       rs.updateString("NAME", "AINSWORTH"); // updates the 
          // NAME column of row 5 to be AINSWORTH
       rs.updateRow(); // updates the row in the data source

 
```

to insert column values into the insert row. An updatable ResultSet object has a special row associated with it that serves as a staging area for building a row to be inserted. The following code fragment moves the cursor to the insert row, builds a three-column row, and inserts it into rs and into the data source table using the method insertRow.


       rs.moveToInsertRow(); // moves cursor to the insert row
       rs.updateString(1, "AINSWORTH"); // updates the 
          // first column of the insert row to be AINSWORTH
       rs.updateInt(2,35); // updates the second column to be 35
       rs.updateBoolean(3, true); // updates the third column to true
       rs.insertRow();
       rs.moveToCurrentRow();

A ResultSet object is automatically closed when the Statement object that generated it is closed, re-executed, or used to retrieve the next result from a sequence of multiple results.

The number, types and properties of a ResultSet object's columns are provided by the ResulSetMetaData object returned by the ResultSet.getMetaData method.

See Also:: Statement.executeQuery(java.lang.String), Statement.getResultSet(), ResultSetMetaData

Field Summary
`static int`	`CLOSE_CURSORS_AT_COMMIT` The constant indicating that open `ResultSet` objects with this holdability will be closed when the current transaction is commited.
`static int`	`CONCUR_READ_ONLY` The constant indicating the concurrency mode for a `ResultSet` object that may NOT be updated.
`static int`	`CONCUR_UPDATABLE` The constant indicating the concurrency mode for a `ResultSet` object that may be updated.
`static int`	`FETCH_FORWARD` The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last.
`static int`	`FETCH_REVERSE` The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first.
`static int`	`FETCH_UNKNOWN` The constant indicating that the order in which rows in a result set will be processed is unknown.
`static int`	`HOLD_CURSORS_OVER_COMMIT` The constant indicating that open `ResultSet` objects with this holdability will remain open when the current transaction is commited.
`static int`	`TYPE_FORWARD_ONLY` The constant indicating the type for a `ResultSet` object whose cursor may move only forward.
`static int`	`TYPE_SCROLL_INSENSITIVE` The constant indicating the type for a `ResultSet` object that is scrollable but generally not sensitive to changes to the data that underlies the `ResultSet`.
`static int`	`TYPE_SCROLL_SENSITIVE` The constant indicating the type for a `ResultSet` object that is scrollable and generally sensitive to changes to the data that underlies the `ResultSet`.

Method Summary
`boolean`	`absolute(int row)` Moves the cursor to the given row number in this `ResultSet` object.
`void`	`afterLast()` Moves the cursor to the end of this `ResultSet` object, just after the last row.
`void`	`beforeFirst()` Moves the cursor to the front of this `ResultSet` object, just before the first row.
`void`	`cancelRowUpdates()` Cancels the updates made to the current row in this `ResultSet` object.
`void`	`clearWarnings()` Clears all warnings reported on this `ResultSet` object.
`void`	`close()` Releases this `ResultSet` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
`void`	`deleteRow()` Deletes the current row from this `ResultSet` object and from the underlying database.
`int`	`findColumn(String columnLabel)` Maps the given `ResultSet` column label to its `ResultSet` column index.
`boolean`	`first()` Moves the cursor to the first row in this `ResultSet` object.
`Array`	`getArray(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
`Array`	`getArray(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
`InputStream`	`getAsciiStream(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
`InputStream`	`getAsciiStream(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
`BigDecimal`	`getBigDecimal(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated.
`BigDecimal`	`getBigDecimal(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`BigDecimal`	`getBigDecimal(String columnLabel, int scale)` Deprecated.
`InputStream`	`getBinaryStream(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of uninterpreted bytes.
`InputStream`	`getBinaryStream(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of uninterpreted `byte`s.
`Blob`	`getBlob(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
`Blob`	`getBlob(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
`boolean`	`getBoolean(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
`boolean`	`getBoolean(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
`byte`	`getByte(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
`byte`	`getByte(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
`byte[]`	`getBytes(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
`byte[]`	`getBytes(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
`Reader`	`getCharacterStream(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`Reader`	`getCharacterStream(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`Clob`	`getClob(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
`Clob`	`getClob(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
`int`	`getConcurrency()` Retrieves the concurrency mode of this `ResultSet` object.
`String`	`getCursorName()` Retrieves the name of the SQL cursor used by this `ResultSet` object.
`Date`	`getDate(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Date`	`getDate(int columnIndex, Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Date`	`getDate(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Date`	`getDate(String columnLabel, Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`double`	`getDouble(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
`double`	`getDouble(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
`int`	`getFetchDirection()` Retrieves the fetch direction for this `ResultSet` object.
`int`	`getFetchSize()` Retrieves the fetch size for this `ResultSet` object.
`float`	`getFloat(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
`float`	`getFloat(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
`int`	`getHoldability()` Retrieves the holdability of this `ResultSet` object
`int`	`getInt(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
`int`	`getInt(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
`long`	`getLong(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
`long`	`getLong(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
`ResultSetMetaData`	`getMetaData()` Retrieves the number, types and properties of this `ResultSet` object's columns.
`Reader`	`getNCharacterStream(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`Reader`	`getNCharacterStream(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`NClob`	`getNClob(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `NClob` object in the Java programming language.
`NClob`	`getNClob(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `NClob` object in the Java programming language.
`String`	`getNString(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`String`	`getNString(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`Object`	`getObject(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Object`	`getObject(int columnIndex, Map<String,Class<?>> map)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Object`	`getObject(String columnLabel)` Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Object`	`getObject(String columnLabel, Map<String,Class<?>> map)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Ref`	`getRef(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
`Ref`	`getRef(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
`int`	`getRow()` Retrieves the current row number.
`RowId`	`getRowId(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.RowId` object in the Java programming language.
`RowId`	`getRowId(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.RowId` object in the Java programming language.
`short`	`getShort(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
`short`	`getShort(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
`SQLXML`	`getSQLXML(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` as a `java.sql.SQLXML` object in the Java programming language.
`SQLXML`	`getSQLXML(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` as a `java.sql.SQLXML` object in the Java programming language.
`Statement`	`getStatement()` Retrieves the `Statement` object that produced this `ResultSet` object.
`String`	`getString(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`String`	`getString(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`Time`	`getTime(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Time`	`getTime(int columnIndex, Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Time`	`getTime(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Time`	`getTime(String columnLabel, Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Timestamp`	`getTimestamp(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`Timestamp`	`getTimestamp(int columnIndex, Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`Timestamp`	`getTimestamp(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`Timestamp`	`getTimestamp(String columnLabel, Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`int`	`getType()` Retrieves the type of this `ResultSet` object.
`InputStream`	`getUnicodeStream(int columnIndex)` Deprecated. use `getCharacterStream` in place of `getUnicodeStream`
`InputStream`	`getUnicodeStream(String columnLabel)` Deprecated. use `getCharacterStream` instead
`URL`	`getURL(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object in the Java programming language.
`URL`	`getURL(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object in the Java programming language.
`SQLWarning`	`getWarnings()` Retrieves the first warning reported by calls on this `ResultSet` object.
`void`	`insertRow()` Inserts the contents of the insert row into this `ResultSet` object and into the database.
`boolean`	`isAfterLast()` Retrieves whether the cursor is after the last row in this `ResultSet` object.
`boolean`	`isBeforeFirst()` Retrieves whether the cursor is before the first row in this `ResultSet` object.
`boolean`	`isClosed()` Retrieves whether this `ResultSet` object has been closed.
`boolean`	`isFirst()` Retrieves whether the cursor is on the first row of this `ResultSet` object.
`boolean`	`isLast()` Retrieves whether the cursor is on the last row of this `ResultSet` object.
`boolean`	`last()` Moves the cursor to the last row in this `ResultSet` object.
`void`	`moveToCurrentRow()` Moves the cursor to the remembered cursor position, usually the current row.
`void`	`moveToInsertRow()` Moves the cursor to the insert row.
`boolean`	`next()` Moves the cursor froward one row from its current position.
`boolean`	`previous()` Moves the cursor to the previous row in this `ResultSet` object.
`void`	`refreshRow()` Refreshes the current row with its most recent value in the database.
`boolean`	`relative(int rows)` Moves the cursor a relative number of rows, either positive or negative.
`boolean`	`rowDeleted()` Retrieves whether a row has been deleted.
`boolean`	`rowInserted()` Retrieves whether the current row has had an insertion.
`boolean`	`rowUpdated()` Retrieves whether the current row has been updated.
`void`	`setFetchDirection(int direction)` Gives a hint as to the direction in which the rows in this `ResultSet` object will be processed.
`void`	`setFetchSize(int rows)` Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this `ResultSet` object.
`void`	`updateArray(int columnIndex, Array x)` Updates the designated column with a `java.sql.Array` value.
`void`	`updateArray(String columnLabel, Array x)` Updates the designated column with a `java.sql.Array` value.
`void`	`updateAsciiStream(int columnIndex, InputStream x)` Updates the designated column with an ascii stream value.
`void`	`updateAsciiStream(int columnIndex, InputStream x, int length)` Updates the designated column with an ascii stream value, which will have the specified number of bytes.
`void`	`updateAsciiStream(int columnIndex, InputStream x, long length)` Updates the designated column with an ascii stream value, which will have the specified number of bytes.
`void`	`updateAsciiStream(String columnLabel, InputStream x)` Updates the designated column with an ascii stream value.
`void`	`updateAsciiStream(String columnLabel, InputStream x, int length)` Updates the designated column with an ascii stream value, which will have the specified number of bytes.
`void`	`updateAsciiStream(String columnLabel, InputStream x, long length)` Updates the designated column with an ascii stream value, which will have the specified number of bytes.
`void`	`updateBigDecimal(int columnIndex, BigDecimal x)` Updates the designated column with a `java.math.BigDecimal` value.
`void`	`updateBigDecimal(String columnLabel, BigDecimal x)` Updates the designated column with a `java.sql.BigDecimal` value.
`void`	`updateBinaryStream(int columnIndex, InputStream x)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(int columnIndex, InputStream x, int length)` Updates the designated column with a binary stream value, which will have the specified number of bytes.
`void`	`updateBinaryStream(int columnIndex, InputStream x, long length)` Updates the designated column with a binary stream value, which will have the specified number of bytes.
`void`	`updateBinaryStream(String columnLabel, InputStream x)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(String columnLabel, InputStream x, int length)` Updates the designated column with a binary stream value, which will have the specified number of bytes.
`void`	`updateBinaryStream(String columnLabel, InputStream x, long length)` Updates the designated column with a binary stream value, which will have the specified number of bytes.
`void`	`updateBlob(int columnIndex, Blob x)` Updates the designated column with a `java.sql.Blob` value.
`void`	`updateBlob(int columnIndex, InputStream inputStream)` Updates the designated column using the given input stream.
`void`	`updateBlob(int columnIndex, InputStream inputStream, long length)` Updates the designated column using the given input stream, which will have the specified number of bytes.
`void`	`updateBlob(String columnLabel, Blob x)` Updates the designated column with a `java.sql.Blob` value.
`void`	`updateBlob(String columnLabel, InputStream inputStream)` Updates the designated column using the given input stream.
`void`	`updateBlob(String columnLabel, InputStream inputStream, long length)` Updates the designated column using the given input stream, which will have the specified number of bytes.
`void`	`updateBoolean(int columnIndex, boolean x)` Updates the designated column with a `boolean` value.
`void`	`updateBoolean(String columnLabel, boolean x)` Updates the designated column with a `boolean` value.
`void`	`updateByte(int columnIndex, byte x)` Updates the designated column with a `byte` value.
`void`	`updateByte(String columnLabel, byte x)` Updates the designated column with a `byte` value.
`void`	`updateBytes(int columnIndex, byte[] x)` Updates the designated column with a `byte` array value.
`void`	`updateBytes(String columnLabel, byte[] x)` Updates the designated column with a byte array value.
`void`	`updateCharacterStream(int columnIndex, Reader x)` Updates the designated column with a character stream value.
`void`	`updateCharacterStream(int columnIndex, Reader x, int length)` Updates the designated column with a character stream value, which will have the specified number of bytes.
`void`	`updateCharacterStream(int columnIndex, Reader x, long length)` Updates the designated column with a character stream value, which will have the specified number of bytes.
`void`	`updateCharacterStream(String columnLabel, Reader reader)` Updates the designated column with a character stream value.
`void`	`updateCharacterStream(String columnLabel, Reader reader, int length)` Updates the designated column with a character stream value, which will have the specified number of bytes.
`void`	`updateCharacterStream(String columnLabel, Reader reader, long length)` Updates the designated column with a character stream value, which will have the specified number of bytes.
`void`	`updateClob(int columnIndex, Clob x)` Updates the designated column with a `java.sql.Clob` value.
`void`	`updateClob(int columnIndex, Reader reader)` Updates the designated column using the given `Reader` object.
`void`	`updateClob(int columnIndex, Reader reader, long length)` Updates the designated column using the given `Reader` object, which is the given number of characters long.
`void`	`updateClob(String columnLabel, Clob x)` Updates the designated column with a `java.sql.Clob` value.
`void`	`updateClob(String columnLabel, Reader reader)` Updates the designated column using the given `Reader` object.
`void`	`updateClob(String columnLabel, Reader reader, long length)` Updates the designated column using the given `Reader` object, which is the given number of characters long.
`void`	`updateDate(int columnIndex, Date x)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDate(String columnLabel, Date x)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDouble(int columnIndex, double x)` Updates the designated column with a `double` value.
`void`	`updateDouble(String columnLabel, double x)` Updates the designated column with a `double` value.
`void`	`updateFloat(int columnIndex, float x)` Updates the designated column with a `float` value.
`void`	`updateFloat(String columnLabel, float x)` Updates the designated column with a `float` value.
`void`	`updateInt(int columnIndex, int x)` Updates the designated column with an `int` value.
`void`	`updateInt(String columnLabel, int x)` Updates the designated column with an `int` value.
`void`	`updateLong(int columnIndex, long x)` Updates the designated column with a `long` value.
`void`	`updateLong(String columnLabel, long x)` Updates the designated column with a `long` value.
`void`	`updateNCharacterStream(int columnIndex, Reader x)` Updates the designated column with a character stream value.
`void`	`updateNCharacterStream(int columnIndex, Reader x, long length)` Updates the designated column with a character stream value, which will have the specified number of bytes.
`void`	`updateNCharacterStream(String columnLabel, Reader reader)` Updates the designated column with a character stream value.
`void`	`updateNCharacterStream(String columnLabel, Reader reader, long length)` Updates the designated column with a character stream value, which will have the specified number of bytes.
`void`	`updateNClob(int columnIndex, NClob nClob)` Updates the designated column with a `java.sql.NClob` value.
`void`	`updateNClob(int columnIndex, Reader reader)` Updates the designated column using the given `Reader` The data will be read from the stream as needed until end-of-stream is reached.
`void`	`updateNClob(int columnIndex, Reader reader, long length)` Updates the designated column using the given `Reader` object, which is the given number of characters long.
`void`	`updateNClob(String columnLabel, NClob nClob)` Updates the designated column with a `java.sql.NClob` value.
`void`	`updateNClob(String columnLabel, Reader reader)` Updates the designated column using the given `Reader` object.
`void`	`updateNClob(String columnLabel, Reader reader, long length)` Updates the designated column using the given `Reader` object, which is the given number of characters long.
`void`	`updateNString(int columnIndex, String nString)` Updates the designated column with a `String` value.
`void`	`updateNString(String columnLabel, String nString)` Updates the designated column with a `String` value.
`void`	`updateNull(int columnIndex)` Updates the designated column with a `null` value.
`void`	`updateNull(String columnLabel)` Updates the designated column with a `null` value.
`void`	`updateObject(int columnIndex, Object x)` Updates the designated column with an `Object` value.
`void`	`updateObject(int columnIndex, Object x, int scaleOrLength)` Updates the designated column with an `Object` value.
`void`	`updateObject(String columnLabel, Object x)` Updates the designated column with an `Object` value.
`void`	`updateObject(String columnLabel, Object x, int scaleOrLength)` Updates the designated column with an `Object` value.
`void`	`updateRef(int columnIndex, Ref x)` Updates the designated column with a `java.sql.Ref` value.
`void`	`updateRef(String columnLabel, Ref x)` Updates the designated column with a `java.sql.Ref` value.
`void`	`updateRow()` Updates the underlying database with the new contents of the current row of this `ResultSet` object.
`void`	`updateRowId(int columnIndex, RowId x)` Updates the designated column with a `RowId` value.
`void`	`updateRowId(String columnLabel, RowId x)` Updates the designated column with a `RowId` value.
`void`	`updateShort(int columnIndex, short x)` Updates the designated column with a `short` value.
`void`	`updateShort(String columnLabel, short x)` Updates the designated column with a `short` value.
`void`	`updateSQLXML(int columnIndex, SQLXML xmlObject)` Updates the designated column with a `java.sql.SQLXML` value.
`void`	`updateSQLXML(String columnLabel, SQLXML xmlObject)` Updates the designated column with a `java.sql.SQLXML` value.
`void`	`updateString(int columnIndex, String x)` Updates the designated column with a `String` value.
`void`	`updateString(String columnLabel, String x)` Updates the designated column with a `String` value.
`void`	`updateTime(int columnIndex, Time x)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTime(String columnLabel, Time x)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTimestamp(int columnIndex, Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`void`	`updateTimestamp(String columnLabel, Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`boolean`	`wasNull()` Reports whether the last column read had a value of SQL `NULL`.

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

Field Detail

FETCH_FORWARD

static final int FETCH_FORWARD

The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last. This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

Since:: 1.2
See Also:: Constant Field Values

FETCH_REVERSE

static final int FETCH_REVERSE

The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first. This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

Since:: 1.2
See Also:: Constant Field Values

FETCH_UNKNOWN

static final int FETCH_UNKNOWN

The constant indicating that the order in which rows in a result set will be processed is unknown. This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

See Also:: Constant Field Values

TYPE_FORWARD_ONLY

static final int TYPE_FORWARD_ONLY

The constant indicating the type for a ResultSet object whose cursor may move only forward.

Since:: 1.2
See Also:: Constant Field Values

TYPE_SCROLL_INSENSITIVE

static final int TYPE_SCROLL_INSENSITIVE

The constant indicating the type for a ResultSet object that is scrollable but generally not sensitive to changes to the data that underlies the ResultSet.

Since:: 1.2
See Also:: Constant Field Values

TYPE_SCROLL_SENSITIVE

static final int TYPE_SCROLL_SENSITIVE

The constant indicating the type for a ResultSet object that is scrollable and generally sensitive to changes to the data that underlies the ResultSet.

Since:: 1.2
See Also:: Constant Field Values

CONCUR_READ_ONLY

static final int CONCUR_READ_ONLY

The constant indicating the concurrency mode for a ResultSet object that may NOT be updated.

Since:: 1.2
See Also:: Constant Field Values

CONCUR_UPDATABLE

static final int CONCUR_UPDATABLE

The constant indicating the concurrency mode for a ResultSet object that may be updated.

Since:: 1.2
See Also:: Constant Field Values

HOLD_CURSORS_OVER_COMMIT

static final int HOLD_CURSORS_OVER_COMMIT

The constant indicating that open ResultSet objects with this holdability will remain open when the current transaction is commited.

Since:: 1.4
See Also:: Constant Field Values

CLOSE_CURSORS_AT_COMMIT

static final int CLOSE_CURSORS_AT_COMMIT

The constant indicating that open ResultSet objects with this holdability will be closed when the current transaction is commited.

Since:: 1.4
See Also:: Constant Field Values

Method Detail

boolean next()
             throws SQLException

Moves the cursor froward one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.

When a call to the next method returns false, the cursor is positioned after the last row. Any invocation of a ResultSet method which requires a current row will result in a SQLException being thrown. If the result set type is TYPE_FORWARD_ONLY, it is vendor specified whether their JDBC driver implementation will return false or throw an SQLException on a subsequent call to next.

If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.

Returns:: true if the new current row is valid; false if there are no more rows
Throws:

java.sql Interface ResultSet