java.sql

Interface ResultSet

All Superinterfaces:: AutoCloseable

Known Subinterfaces:: RowSet

public interface ResultSet

extends AutoCloseable

This interface provides access to the data set returned by a SQL statement. An instance of this interface is returned by the various execution methods in the Statement.

This class models a cursor, which can be stepped through one row at a time. Methods are provided for accessing columns by column name or by index.

Note that a result set is invalidated if the statement that returned it is closed.

Field Summary
`static int`	`CLOSE_CURSORS_AT_COMMIT`
`static int`	`CONCUR_READ_ONLY` The concurrency mode of for the result set may not be modified.
`static int`	`CONCUR_UPDATABLE` The concurrency mode of for the result set may be modified.
`static int`	`FETCH_FORWARD` The rows will be processed in order from first to last.
`static int`	`FETCH_REVERSE` The rows will be processed in order from last to first.
`static int`	`FETCH_UNKNOWN` The rows will be processed in an unknown order
`static int`	`HOLD_CURSORS_OVER_COMMIT`
`static int`	`TYPE_FORWARD_ONLY` This type of result set may only step forward through the rows returned.
`static int`	`TYPE_SCROLL_INSENSITIVE` This type of result set is scrollable and is not sensitive to changes made by other statements.
`static int`	`TYPE_SCROLL_SENSITIVE` This type of result set is scrollable and is also sensitive to changes made by other statements.

Method Summary
`boolean`	`absolute(int row)` This method positions the result set to the specified absolute row.
`void`	`afterLast()` This method repositions the cursor to after the last row in the result set.
`void`	`beforeFirst()` This method repositions the cursor to before the first row in the result set.
`void`	`cancelRowUpdates()` This method cancels any changes that have been made to a row.
`void`	`clearWarnings()` This method clears all warnings associated with this result set.
`void`	`close()` This method closes the result set and frees any associated resources.
`void`	`deleteRow()` This method deletes the current row in the database.
`int`	`findColumn(String columnName)` This method returns the column index of the specified named column.
`boolean`	`first()` This method repositions the cursor on the first row in the result set.
`Array`	`getArray(int columnIndex)` This method returns the specified column value as an `Array`.
`Array`	`getArray(String columnName)` This method returns the specified column value as an `Array`.
`InputStream`	`getAsciiStream(int columnIndex)` This method returns the value of the specified column as an ASCII stream.
`InputStream`	`getAsciiStream(String columnName)` This method returns the value of the specified column as an ASCII stream.
`BigDecimal`	`getBigDecimal(int columnIndex)` This method returns the value of the specified column as a Java `BigDecimal`.
`BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated.
`BigDecimal`	`getBigDecimal(String columnName)` This method returns the value of the specified column as a Java `BigDecimal`.
`BigDecimal`	`getBigDecimal(String columnName, int scale)` Deprecated.
`InputStream`	`getBinaryStream(int columnIndex)` This method returns the value of the specified column as a raw byte stream.
`InputStream`	`getBinaryStream(String columnName)` This method returns the value of the specified column as a raw byte stream.
`Blob`	`getBlob(int columnIndex)` This method returns the specified column value as a BLOB.
`Blob`	`getBlob(String columnName)` This method returns the specified column value as a BLOB.
`boolean`	`getBoolean(int columnIndex)` This method returns the value of the specified column as a Java `boolean`.
`boolean`	`getBoolean(String columnName)` This method returns the value of the specified column as a Java `boolean`.
`byte`	`getByte(int columnIndex)` This method returns the value of the specified column as a Java `byte`.
`byte`	`getByte(String columnName)` This method returns the value of the specified column as a Java `byte`.
`byte[]`	`getBytes(int columnIndex)` This method returns the value of the specified column as a Java byte array.
`byte[]`	`getBytes(String columnName)` This method returns the value of the specified column as a Java byte array.
`Reader`	`getCharacterStream(int columnIndex)` This method returns the value of the specified column as a character stream.
`Reader`	`getCharacterStream(String columnName)` This method returns the value of the specified column as a character stream.
`Clob`	`getClob(int columnIndex)` This method returns the specified column value as a CLOB.
`Clob`	`getClob(String columnName)` This method returns the specified column value as a CLOB.
`int`	`getConcurrency()` This method returns the concurrency type of this result set.
`String`	`getCursorName()` This method returns the name of the database cursor used by this result set.
`Date`	`getDate(int columnIndex)` This method returns the value of the specified column as a Java `java.sql.Date`.
`Date`	`getDate(int columnIndex, Calendar cal)` This method returns the specified column value as a `java.sql.Date`.
`Date`	`getDate(String columnName)` This method returns the value of the specified column as a Java `java.sql.Date`.
`Date`	`getDate(String columnName, Calendar cal)` This method returns the specified column value as a `java.sql.Date`.
`double`	`getDouble(int columnIndex)` This method returns the value of the specified column as a Java `double`.
`double`	`getDouble(String columnName)` This method returns the value of the specified column as a Java `double`.
`int`	`getFetchDirection()` This method returns the current fetch direction for this result set.
`int`	`getFetchSize()` This method returns the current number of rows that will be fetched from the database at a time.
`float`	`getFloat(int columnIndex)` This method returns the value of the specified column as a Java `float`.
`float`	`getFloat(String columnName)` This method returns the value of the specified column as a Java `float`.
`int`	`getInt(int columnIndex)` This method returns the value of the specified column as a Java `int`.
`int`	`getInt(String columnName)` This method returns the value of the specified column as a Java `int`.
`long`	`getLong(int columnIndex)` This method returns the value of the specified column as a Java `long`.
`long`	`getLong(String columnName)` This method returns the value of the specified column as a Java `long`.
`ResultSetMetaData`	`getMetaData()` This method returns data about the columns returned as part of the result set as a `ResultSetMetaData` instance.
`Object`	`getObject(int columnIndex)` This method returns the value of the specified column as a Java `Object`.
`Object`	`getObject(int columnIndex, Map> map)` This method returns the value of the specified column as a Java `Object` using the specified SQL type to Java type map.
`Object`	`getObject(String columnName)` This method returns the value of the specified column as a Java `Object`.
`Object`	`getObject(String columnName, Map> map)` This method returns the value of the specified column as a Java `Object` using the specified SQL type to Java type map.
`Ref`	`getRef(int columnIndex)` This method returns a `Ref` for the specified column which represents the structured type for the column.
`Ref`	`getRef(String columnName)` This method returns a `Ref` for the specified column which represents the structured type for the column.
`int`	`getRow()` This method returns the current row number in the cursor.
`short`	`getShort(int columnIndex)` This method returns the value of the specified column as a Java `short`.
`short`	`getShort(String columnName)` This method returns the value of the specified column as a Java `short`.
`Statement`	`getStatement()` This method returns a the `Statement` that was used to produce this result set.
`String`	`getString(int columnIndex)` This method returns the value of the specified column as a Java `String`.
`String`	`getString(String columnName)` This method returns the value of the specified column as a Java `String`.
`Time`	`getTime(int columnIndex)` This method returns the value of the specified column as a Java `java.sql.Time`.
`Time`	`getTime(int columnIndex, Calendar cal)` This method returns the specified column value as a `java.sql.Time`.
`Time`	`getTime(String columnName)` This method returns the value of the specified column as a Java `java.sql.Time`.
`Time`	`getTime(String columnName, Calendar cal)` This method returns the specified column value as a `java.sql.Time`.
`Timestamp`	`getTimestamp(int columnIndex)` This method returns the value of the specified column as a Java `java.sql.Timestamp`.
`Timestamp`	`getTimestamp(int columnIndex, Calendar cal)` This method returns the specified column value as a `java.sql.Timestamp`.
`Timestamp`	`getTimestamp(String columnName)` This method returns the value of the specified column as a Java `java.sql.Timestamp`.
`Timestamp`	`getTimestamp(String columnName, Calendar cal)` This method returns the specified column value as a `java.sql.Timestamp`.
`int`	`getType()` This method returns the result set type of this result set.
`URL`	`getURL(int columnIndex)` This method returns the specified column value as a `java.net.URL`.
`URL`	`getURL(String columnName)` This method returns the specified column value as a `java.net.URL`.
`InputStream`	`getUnicodeStream(int columnIndex)` Deprecated. Use getCharacterStream instead.
`InputStream`	`getUnicodeStream(String columnName)` Deprecated. Use getCharacterStream instead.
`SQLWarning`	`getWarnings()` This method returns the first SQL warning associated with this result set.
`void`	`insertRow()` This method inserts the current row into the database.
`boolean`	`isAfterLast()` This method tests whether or not the cursor is after the last row in the result set.
`boolean`	`isBeforeFirst()` This method tests whether or not the cursor is before the first row in the result set.
`boolean`	`isFirst()` This method tests whether or not the cursor is positioned on the first row in the result set.
`boolean`	`isLast()` This method tests whether or not the cursor is on the last row in the result set.
`boolean`	`last()` This method repositions the cursor on the last row in the result set.
`void`	`moveToCurrentRow()` This method moves the result set position from the insert row back to the current row that was selected prior to moving to the insert row.
`void`	`moveToInsertRow()` This method positions the result set to the "insert row", which allows a new row to be inserted into the database from the result set.
`boolean`	`next()` This method advances to the next row in the result set.
`boolean`	`previous()` This method moves the current position to the previous row in the result set.
`void`	`refreshRow()` This method refreshes the contents of the current row from the database.
`boolean`	`relative(int rows)` This method moves the result set position relative to the current row.
`boolean`	`rowDeleted()` This method tests whether or not the current row in the result set has been deleted.
`boolean`	`rowInserted()` This method tests whether or not the current row in the result set has been inserted.
`boolean`	`rowUpdated()` This method tests whether or not the current row in the result set has been updated.
`void`	`setFetchDirection(int direction)` This method provides a hint to the driver about which direction the result set will be processed in.
`void`	`setFetchSize(int rows)` This method provides a hint to the driver about how many rows at a time it should fetch from the database.
`void`	`updateArray(int columnIndex, Array value)` This method updates the specified column to have a `java.sqlArray` value.
`void`	`updateArray(String columnName, Array value)` This method updates the specified column to have a `java.sqlArray` value.
`void`	`updateAsciiStream(int columnIndex, InputStream stream, int count)` This method updates the specified column from an ASCII text stream.
`void`	`updateAsciiStream(String columnName, InputStream stream, int count)` This method updates the specified column from an ASCII text stream.
`void`	`updateBigDecimal(int columnIndex, BigDecimal value)` This method updates the specified column to have a BigDecimal value.
`void`	`updateBigDecimal(String columnName, BigDecimal value)` This method updates the specified column to have a BigDecimal value.
`void`	`updateBinaryStream(int columnIndex, InputStream stream, int count)` This method updates the specified column from a binary stream.
`void`	`updateBinaryStream(String columnName, InputStream stream, int count)` This method updates the specified column from a binary stream.
`void`	`updateBlob(int columnIndex, Blob value)` This method updates the specified column to have a `java.sql.Blob` value.
`void`	`updateBlob(String columnName, Blob value)` This method updates the specified column to have a `java.sql.Blob` value.
`void`	`updateBoolean(int columnIndex, boolean value)` This method updates the specified column to have a boolean value.
`void`	`updateBoolean(String columnName, boolean value)` This method updates the specified column to have a boolean value.
`void`	`updateByte(int columnIndex, byte value)` This method updates the specified column to have a byte value.
`void`	`updateByte(String columnName, byte value)` This method updates the specified column to have a byte value.
`void`	`updateBytes(int columnIndex, byte[] value)` This method updates the specified column to have a byte array value.
`void`	`updateBytes(String columnName, byte[] value)` This method updates the specified column to have a byte array value.
`void`	`updateCharacterStream(int columnIndex, Reader reader, int count)` This method updates the specified column from a character stream.
`void`	`updateCharacterStream(String columnName, Reader reader, int count)` This method updates the specified column from a character stream.
`void`	`updateClob(int columnIndex, Clob value)` This method updates the specified column to have a `java.sql.Clob` value.
`void`	`updateClob(String columnName, Clob value)` This method updates the specified column to have a `java.sql.Clob` value.
`void`	`updateDate(int columnIndex, Date value)` This method updates the specified column to have a java.sql.Date value.
`void`	`updateDate(String columnName, Date value)` This method updates the specified column to have a java.sql.Date value.
`void`	`updateDouble(int columnIndex, double value)` This method updates the specified column to have a double value.
`void`	`updateDouble(String columnName, double value)` This method updates the specified column to have a double value.
`void`	`updateFloat(int columnIndex, float value)` This method updates the specified column to have a float value.
`void`	`updateFloat(String columnName, float value)` This method updates the specified column to have a float value.
`void`	`updateInt(int columnIndex, int value)` This method updates the specified column to have an int value.
`void`	`updateInt(String columnName, int value)` This method updates the specified column to have an int value.
`void`	`updateLong(int columnIndex, long value)` This method updates the specified column to have a long value.
`void`	`updateLong(String columnName, long value)` This method updates the specified column to have a long value.
`void`	`updateNull(int columnIndex)` This method updates the specified column to have a NULL value.
`void`	`updateNull(String columnName)` This method updates the specified column to have a NULL value.
`void`	`updateObject(int columnIndex, Object value)` This method updates the specified column to have an Object value.
`void`	`updateObject(int columnIndex, Object value, int scale)` This method updates the specified column to have an Object value.
`void`	`updateObject(String columnName, Object value)` This method updates the specified column to have an Object value.
`void`	`updateObject(String columnName, Object value, int scale)` This method updates the specified column to have an Object value.
`void`	`updateRef(int columnIndex, Ref value)` This method updates the specified column to have a `java.sql.Ref` value.
`void`	`updateRef(String columnName, Ref value)` This method updates the specified column to have a `java.sql.Ref` value.
`void`	`updateRow()` This method updates the current row in the database.
`void`	`updateShort(int columnIndex, short value)` This method updates the specified column to have a short value.
`void`	`updateShort(String columnName, short value)` This method updates the specified column to have a short value.
`void`	`updateString(int columnIndex, String value)` This method updates the specified column to have a String value.
`void`	`updateString(String columnName, String value)` This method updates the specified column to have a String value.
`void`	`updateTime(int columnIndex, Time value)` This method updates the specified column to have a java.sql.Time value.
`void`	`updateTime(String columnName, Time value)` This method updates the specified column to have a java.sql.Time value.
`void`	`updateTimestamp(int columnIndex, Timestamp value)` This method updates the specified column to have a java.sql.Timestamp value.
`void`	`updateTimestamp(String columnName, Timestamp value)` This method updates the specified column to have a java.sql.Timestamp value.
`boolean`	`wasNull()` This method tests whether the value of the last column that was fetched was actually a SQL NULL value.

Methods inherited from interface java.lang.AutoCloseable
`close`

CLOSE_CURSORS_AT_COMMIT

public static final int CLOSE_CURSORS_AT_COMMIT

Field Value:
2

CONCUR_READ_ONLY

public static final int CONCUR_READ_ONLY

The concurrency mode of for the result set may not be modified.
Field Value:
1007

CONCUR_UPDATABLE

public static final int CONCUR_UPDATABLE

The concurrency mode of for the result set may be modified.
Field Value:
1008

FETCH_FORWARD

public static final int FETCH_FORWARD

The rows will be processed in order from first to last.
Field Value:
1000

FETCH_REVERSE

public static final int FETCH_REVERSE

The rows will be processed in order from last to first.
Field Value:
1001

FETCH_UNKNOWN

public static final int FETCH_UNKNOWN

The rows will be processed in an unknown order
Field Value:
1002

HOLD_CURSORS_OVER_COMMIT

public static final int HOLD_CURSORS_OVER_COMMIT

Field Value:
1

TYPE_FORWARD_ONLY

public static final int TYPE_FORWARD_ONLY

This type of result set may only step forward through the rows returned.
Field Value:
1003

TYPE_SCROLL_INSENSITIVE

public static final int TYPE_SCROLL_INSENSITIVE

This type of result set is scrollable and is not sensitive to changes made by other statements.
Field Value:
1004

TYPE_SCROLL_SENSITIVE

public static final int TYPE_SCROLL_SENSITIVE

This type of result set is scrollable and is also sensitive to changes made by other statements.
Field Value:
1005

absolute

public boolean absolute(int row)
            throws SQLException

This method positions the result set to the specified absolute row. Positive numbers are row offsets from the beginning of the result set (numbering starts from row 1) and negative numbers are row offsets from the end of the result set (numbering starts from -1).
Parameters:
row - The row to position the result set to.
Returns:
true if the current position was changed, false otherwise.
Throws:
SQLException - If an error occurs.

afterLast

public void afterLast()
            throws SQLException

This method repositions the cursor to after the last row in the result set.
Throws:
SQLException - If an error occurs.

beforeFirst

public void beforeFirst()
            throws SQLException

This method repositions the cursor to before the first row in the result set.
Throws:
SQLException - If an error occurs.

cancelRowUpdates

public void cancelRowUpdates()
            throws SQLException

This method cancels any changes that have been made to a row. If the rowUpdate method has been called, then the changes cannot be undone.
Throws:
SQLException - If an error occurs.

clearWarnings

public void clearWarnings()
            throws SQLException

This method clears all warnings associated with this result set.
Throws:
SQLException - If an error occurs.

close

public void close()
            throws SQLException

This method closes the result set and frees any associated resources.
Specified by:
close in interface AutoCloseable
Throws:
SQLException - If an error occurs.

deleteRow

public void deleteRow()
            throws SQLException

This method deletes the current row in the database.
Throws:
SQLException - If an error occurs.

findColumn

public int findColumn(String columnName)
            throws SQLException

This method returns the column index of the specified named column.
Parameters:
columnName - The name of the column.
Returns:
The index of the column.
Throws:
SQLException - If an error occurs.

first

public boolean first()
            throws SQLException

This method repositions the cursor on the first row in the result set.
Returns:
true if the cursor is on a valid row; false if there are no rows in the result set.
Throws:
SQLException - If an error occurs.

getArray

public Array getArray(int columnIndex)
            throws SQLException

This method returns the specified column value as an Array.
Parameters:
columnIndex - The index of the column value to return.
Returns:
The value of the column as an Array.
Throws:
SQLException - If an error occurs.

getArray

public Array getArray(String columnName)
            throws SQLException

This method returns the specified column value as an Array.
Parameters:
columnName - The name of the column value to return.
Returns:
The value of the column as an Array.
Throws:
SQLException - If an error occurs.

getAsciiStream

public InputStream getAsciiStream(int columnIndex)
            throws SQLException

This method returns the value of the specified column as an ASCII stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as an ASCII InputStream.
Throws:
SQLException - If an error occurs.

getAsciiStream

public InputStream getAsciiStream(String columnName)
            throws SQLException

This method returns the value of the specified column as an ASCII stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as an ASCII InputStream.
Throws:
SQLException - If an error occurs.

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java BigDecimal.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex,
                                int scale)
            throws SQLException

Deprecated.
This method returns the value of the specified column as a Java BigDecimal.
Parameters:
columnIndex - The index of the column to return.
scale - The number of digits to the right of the decimal to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBigDecimal

public BigDecimal getBigDecimal(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java BigDecimal.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBigDecimal

public BigDecimal getBigDecimal(String columnName,
                                int scale)
            throws SQLException

Deprecated.
This method returns the value of the specified column as a Java BigDecimal.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBinaryStream

public InputStream getBinaryStream(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a raw byte stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a raw byte InputStream.
Throws:
SQLException - If an error occurs.

getBinaryStream

public InputStream getBinaryStream(String columnName)
            throws SQLException

This method returns the value of the specified column as a raw byte stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a raw byte InputStream.
Throws:
SQLException - If an error occurs.

getBlob

public Blob getBlob(int columnIndex)
            throws SQLException

This method returns the specified column value as a BLOB.
Parameters:
columnIndex - The index of the column value to return.
Returns:
The value of the column as a BLOB.
Throws:
SQLException - If an error occurs.

getBlob

public Blob getBlob(String columnName)
            throws SQLException

This method returns the specified column value as a BLOB.
Parameters:
columnName - The name of the column value to return.
Returns:
The value of the column as a BLOB.
Throws:
SQLException - If an error occurs.

getBoolean

public boolean getBoolean(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java boolean.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a boolean.
Throws:
SQLException - If an error occurs.

getBoolean

public boolean getBoolean(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java boolean.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a boolean.
Throws:
SQLException - If an error occurs.

getByte

public byte getByte(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java byte.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a byte.
Throws:
SQLException - If an error occurs.

getByte

public byte getByte(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java byte.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a byte.
Throws:
SQLException - If an error occurs.

getBytes

public byte[] getBytes(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java byte array.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a byte array
Throws:
SQLException - If an error occurs.

getBytes

public byte[] getBytes(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java byte array.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a byte array
Throws:
SQLException - If an error occurs.

getCharacterStream

public Reader getCharacterStream(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a character stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as an character Reader.
Throws:
SQLException - If an error occurs.

getCharacterStream

public Reader getCharacterStream(String columnName)
            throws SQLException

This method returns the value of the specified column as a character stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as an character Reader.
Throws:
SQLException - If an error occurs.

getClob

public Clob getClob(int columnIndex)
            throws SQLException

This method returns the specified column value as a CLOB.
Parameters:
columnIndex - The index of the column value to return.
Returns:
The value of the column as a CLOB.
Throws:
SQLException - If an error occurs.

getClob

public Clob getClob(String columnName)
            throws SQLException

This method returns the specified column value as a CLOB.
Parameters:
columnName - The name of the column value to return.
Returns:
The value of the column as a CLOB.
Throws:
SQLException - If an error occurs.

getConcurrency

public int getConcurrency()
            throws SQLException

This method returns the concurrency type of this result set. This will be one of the CONCUR_* constants defined in this interface.
Returns:
The result set concurrency type.
Throws:
SQLException - If an error occurs.

getCursorName

public String getCursorName()
            throws SQLException

This method returns the name of the database cursor used by this result set.
Returns:
The name of the database cursor used by this result set.
Throws:
SQLException - If an error occurs.

getDate

public Date getDate(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java java.sql.Date.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getDate

public Date getDate(int columnIndex,
                    Calendar cal)
            throws SQLException

This method returns the specified column value as a java.sql.Date. The specified Calendar is used to generate a value for the date if the database does not support timezones.
Parameters:
columnIndex - The index of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getDate

public Date getDate(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java java.sql.Date.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getDate

public Date getDate(String columnName,
                    Calendar cal)
            throws SQLException

This method returns the specified column value as a java.sql.Date. The specified Calendar is used to generate a value for the date if the database does not support timezones.
Parameters:
columnName - The name of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getDouble

public double getDouble(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java double.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a double.
Throws:
SQLException - If an error occurs.

getDouble

public double getDouble(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java double.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a double.
Throws:
SQLException - If an error occurs.

getFetchDirection

public int getFetchDirection()
            throws SQLException

This method returns the current fetch direction for this result set.
Returns:
The fetch direction for this result set.
Throws:
SQLException - If an error occurs.

getFetchSize

public int getFetchSize()
            throws SQLException

This method returns the current number of rows that will be fetched from the database at a time.
Returns:
The current fetch size for this result set.
Throws:
SQLException - If an error occurs.

getFloat

public float getFloat(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java float.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a float.
Throws:
SQLException - If an error occurs.

getFloat

public float getFloat(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java float.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a float.
Throws:
SQLException - If an error occurs.

getInt

public int getInt(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java int.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a int.
Throws:
SQLException - If an error occurs.

getInt

public int getInt(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java int.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a int.
Throws:
SQLException - If an error occurs.

getLong

public long getLong(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java long.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a long.
Throws:
SQLException - If an error occurs.

getLong

public long getLong(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java long.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a long.
Throws:
SQLException - If an error occurs.

getMetaData

public ResultSetMetaData getMetaData()
            throws SQLException

This method returns data about the columns returned as part of the result set as a ResultSetMetaData instance.
Returns:
The ResultSetMetaData instance for this result set.
Throws:
SQLException - If an error occurs.

getObject

public Object getObject(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java Object.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as an Object.
Throws:
SQLException - If an error occurs.

getObject

public Object getObject(int columnIndex,
                        Map> map)
            throws SQLException

This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
Parameters:
columnIndex - The index of the column to return.
map - The SQL type to Java type map to use.
Returns:
The value of the column as an Object.
Throws:
SQLException - If an error occurs.

getObject

public Object getObject(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java Object.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as an Object.
Throws:
SQLException - If an error occurs.

getObject

public Object getObject(String columnName,
                        Map> map)
            throws SQLException

This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
Parameters:
columnName - The name of the column to return.
map - The SQL type to Java type map to use.
Returns:
The value of the column as an Object.
Throws:
SQLException - If an error occurs.

getRef

public Ref getRef(int columnIndex)
            throws SQLException

This method returns a Ref for the specified column which represents the structured type for the column.
Parameters:
columnIndex - The index of the column to return.
Returns:
A Ref object for the column
Throws:
SQLException - If an error occurs.

getRef

public Ref getRef(String columnName)
            throws SQLException

This method returns a Ref for the specified column which represents the structured type for the column.
Parameters:
columnName - The name of the column to return.
Returns:
A Ref object for the column
Throws:
SQLException - If an error occurs.

getRow

public int getRow()
            throws SQLException

This method returns the current row number in the cursor. Numbering begins at index 1.
Returns:
The current row number, or 0 if there is not current row.
Throws:
SQLException - If an error occurs.

getShort

public short getShort(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java short.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a short.
Throws:
SQLException - If an error occurs.

getShort

public short getShort(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java short.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a short.
Throws:
SQLException - If an error occurs.

getStatement

public Statement getStatement()
            throws SQLException

This method returns a the Statement that was used to produce this result set.
Returns:
The Statement used to produce this result set.
Throws:
SQLException - If an error occurs.

getString

public String getString(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java String.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a String.
Throws:
SQLException - If an error occurs.

getString

public String getString(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java String.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a String.
Throws:
SQLException - If an error occurs.

getTime

public Time getTime(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java java.sql.Time.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTime

public Time getTime(int columnIndex,
                    Calendar cal)
            throws SQLException

This method returns the specified column value as a java.sql.Time. The specified Calendar is used to generate a value for the time if the database does not support timezones.
Parameters:
columnIndex - The index of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTime

public Time getTime(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java java.sql.Time.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTime

public Time getTime(String columnName,
                    Calendar cal)
            throws SQLException

This method returns the specified column value as a java.sql.Time. The specified Calendar is used to generate a value for the time if the database does not support timezones.
Parameters:
columnName - The name of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTimestamp

public Timestamp getTimestamp(int columnIndex)
            throws SQLException

This method returns the value of the specified column as a Java java.sql.Timestamp.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getTimestamp

public Timestamp getTimestamp(int columnIndex,
                              Calendar cal)
            throws SQLException

This method returns the specified column value as a java.sql.Timestamp. The specified Calendar is used to generate a value for the timestamp if the database does not support timezones.
Parameters:
columnIndex - The index of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getTimestamp

public Timestamp getTimestamp(String columnName)
            throws SQLException

This method returns the value of the specified column as a Java java.sql.Timestamp.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getTimestamp

public Timestamp getTimestamp(String columnName,
                              Calendar cal)
            throws SQLException

This method returns the specified column value as a java.sql.Timestamp. The specified Calendar is used to generate a value for the timestamp if the database does not support timezones.
Parameters:
columnName - The name of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getType

public int getType()
            throws SQLException

This method returns the result set type of this result set. This will be one of the TYPE_* constants defined in this interface.
Returns:
The result set type.
Throws:
SQLException - If an error occurs.

getURL

public URL getURL(int columnIndex)
            throws SQLException

This method returns the specified column value as a java.net.URL.
Parameters:
columnIndex - The index of the column value to return.
Throws:
SQLException - If an error occurs.
Since:
1.4

getURL

public URL getURL(String columnName)
            throws SQLException

This method returns the specified column value as a java.net.URL.
Parameters:
columnName - The name of the column value to return.
Throws:
SQLException - If an error occurs.
Since:
1.4

getUnicodeStream

public InputStream getUnicodeStream(int columnIndex)
            throws SQLException

Deprecated. Use getCharacterStream instead.
This method returns the value of the specified column as a Unicode UTF-8 stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a Unicode UTF-8 InputStream.
Throws:
SQLException - If an error occurs.

getUnicodeStream

public InputStream getUnicodeStream(String columnName)
            throws SQLException

Deprecated. Use getCharacterStream instead.
This method returns the value of the specified column as a Unicode UTF-8 stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a Unicode UTF-8 InputStream.
Throws:
SQLException - If an error occurs.

getWarnings

public SQLWarning getWarnings()
            throws SQLException

This method returns the first SQL warning associated with this result set. Any additional warnings will be chained to this one.
Returns:
The first SQLWarning for this result set, or null if there are no warnings.
Throws:
SQLException - If an error occurs.

insertRow

public void insertRow()
            throws SQLException

This method inserts the current row into the database. The result set must be positioned on the insert row in order to call this method successfully.
Throws:
SQLException - If an error occurs.

isAfterLast

public boolean isAfterLast()
            throws SQLException

This method tests whether or not the cursor is after the last row in the result set.
Returns:
true if the cursor is positioned after the last row, false otherwise.
Throws:
SQLException - If an error occurs.

isBeforeFirst

public boolean isBeforeFirst()
            throws SQLException

This method tests whether or not the cursor is before the first row in the result set.
Returns:
true if the cursor is positioned before the first row, false otherwise.
Throws:
SQLException - If an error occurs.

isFirst

public boolean isFirst()
            throws SQLException

This method tests whether or not the cursor is positioned on the first row in the result set.
Returns:
true if the cursor is positioned on the first row, false otherwise.
Throws:
SQLException - If an error occurs.

isLast

public boolean isLast()
            throws SQLException

This method tests whether or not the cursor is on the last row in the result set.
Returns:
true if the cursor is positioned on the last row, false otherwise.
Throws:
SQLException - If an error occurs.

last

public boolean last()
            throws SQLException

This method repositions the cursor on the last row in the result set.
Returns:
true if the cursor is on a valid row; false if there are no rows in the result set.
Throws:
SQLException - If an error occurs.

moveToCurrentRow

public void moveToCurrentRow()
            throws SQLException

This method moves the result set position from the insert row back to the current row that was selected prior to moving to the insert row.
Throws:
SQLException - If an error occurs.

moveToInsertRow

public void moveToInsertRow()
            throws SQLException

This method positions the result set to the "insert row", which allows a new row to be inserted into the database from the result set.
Throws:
SQLException - If an error occurs.

public boolean next()
            throws SQLException

This method advances to the next row in the result set. Any streams open on the current row are closed automatically.
Returns:
true if the next row exists, false otherwise.
Throws:
SQLException - If an error occurs.

public boolean previous()
            throws SQLException

This method moves the current position to the previous row in the result set.
Returns:
true if the previous row exists, false otherwise.
Throws:
SQLException - If an error occurs.

refreshRow

public void refreshRow()
            throws SQLException

This method refreshes the contents of the current row from the database.
Throws:
SQLException - If an error occurs.

relative

public boolean relative(int rows)
            throws SQLException

This method moves the result set position relative to the current row. The offset can be positive or negative.
Parameters:
rows - The number of row positions to move.
Returns:
true if the current position was changed, false otherwise.
Throws:
SQLException - If an error occurs.

rowDeleted

public boolean rowDeleted()
            throws SQLException

This method tests whether or not the current row in the result set has been deleted. Deletes must be visible in order of this method to detect the deletion.
Returns:
true if the row has been deleted, false otherwise.
Throws:
SQLException - If an error occurs.

rowInserted

public boolean rowInserted()
            throws SQLException

This method tests whether or not the current row in the result set has been inserted. Inserts must be visible in order of this method to detect the insert.
Returns:
true if the row has been inserted, false otherwise.
Throws:
SQLException - If an error occurs.

rowUpdated

public boolean rowUpdated()
            throws SQLException

This method tests whether or not the current row in the result set has been updated. Updates must be visible in order of this method to detect the update.
Returns:
true if the row has been updated, false otherwise.
Throws:
SQLException - If an error occurs.

setFetchDirection

public void setFetchDirection(int direction)
            throws SQLException

This method provides a hint to the driver about which direction the result set will be processed in.
Parameters:
direction - The direction in which rows will be processed. The allowed values are the FETCH_* constants defined in this interface.
Throws:
SQLException - If an error occurs.

setFetchSize

public void setFetchSize(int rows)
            throws SQLException

This method provides a hint to the driver about how many rows at a time it should fetch from the database.
Parameters:
rows - The number of rows the driver should fetch per call.
Throws:
SQLException - If an error occurs.

updateArray

public void updateArray(int columnIndex,
                        Array value)
            throws SQLException

This method updates the specified column to have a java.sqlArray value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateArray

public void updateArray(String columnName,
                        Array value)
            throws SQLException

This method updates the specified column to have a java.sqlArray value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream stream,
                              int count)
            throws SQLException

This method updates the specified column from an ASCII text stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream stream,
                              int count)
            throws SQLException

This method updates the specified column from an ASCII text stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             BigDecimal value)
            throws SQLException

This method updates the specified column to have a BigDecimal value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBigDecimal

public void updateBigDecimal(String columnName,
                             BigDecimal value)
            throws SQLException

This method updates the specified column to have a BigDecimal value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream stream,
                               int count)
            throws SQLException

This method updates the specified column from a binary stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream stream,
                               int count)
            throws SQLException

This method updates the specified column from a binary stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateBlob

public void updateBlob(int columnIndex,
                       Blob value)
            throws SQLException

This method updates the specified column to have a java.sql.Blob value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateBlob

public void updateBlob(String columnName,
                       Blob value)
            throws SQLException

This method updates the specified column to have a java.sql.Blob value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean value)
            throws SQLException

This method updates the specified column to have a boolean value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBoolean

public void updateBoolean(String columnName,
                          boolean value)
            throws SQLException

This method updates the specified column to have a boolean value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateByte

public void updateByte(int columnIndex,
                       byte value)
            throws SQLException

This method updates the specified column to have a byte value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateByte

public void updateByte(String columnName,
                       byte value)
            throws SQLException

This method updates the specified column to have a byte value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBytes

public void updateBytes(int columnIndex,
                        byte[] value)
            throws SQLException

This method updates the specified column to have a byte array value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBytes

public void updateBytes(String columnName,
                        byte[] value)
            throws SQLException

This method updates the specified column to have a byte array value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader reader,
                                  int count)
            throws SQLException

This method updates the specified column from a character stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
reader - The reader from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader reader,
                                  int count)
            throws SQLException

This method updates the specified column from a character stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
reader - The reader from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateClob

public void updateClob(int columnIndex,
                       Clob value)
            throws SQLException

This method updates the specified column to have a java.sql.Clob value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateClob

public void updateClob(String columnName,
                       Clob value)
            throws SQLException

This method updates the specified column to have a java.sql.Clob value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateDate

public void updateDate(int columnIndex,
                       Date value)
            throws SQLException

This method updates the specified column to have a java.sql.Date value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDate

public void updateDate(String columnName,
                       Date value)
            throws SQLException

This method updates the specified column to have a java.sql.Date value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDouble

public void updateDouble(int columnIndex,
                         double value)
            throws SQLException

This method updates the specified column to have a double value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDouble

public void updateDouble(String columnName,
                         double value)
            throws SQLException

This method updates the specified column to have a double value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateFloat

public void updateFloat(int columnIndex,
                        float value)
            throws SQLException

This method updates the specified column to have a float value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateFloat

public void updateFloat(String columnName,
                        float value)
            throws SQLException

This method updates the specified column to have a float value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateInt

public void updateInt(int columnIndex,
                      int value)
            throws SQLException

This method updates the specified column to have an int value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateInt

public void updateInt(String columnName,
                      int value)
            throws SQLException

This method updates the specified column to have an int value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateLong

public void updateLong(int columnIndex,
                       long value)
            throws SQLException

This method updates the specified column to have a long value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateLong

public void updateLong(String columnName,
                       long value)
            throws SQLException

This method updates the specified column to have a long value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateNull

public void updateNull(int columnIndex)
            throws SQLException

This method updates the specified column to have a NULL value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
Throws:
SQLException - If an error occurs.

updateNull

public void updateNull(String columnName)
            throws SQLException

This method updates the specified column to have a NULL value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
Throws:
SQLException - If an error occurs.

updateObject

public void updateObject(int columnIndex,
                         Object value)
            throws SQLException

This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateObject

public void updateObject(int columnIndex,
                         Object value,
                         int scale)
            throws SQLException

This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
scale - The scale of the object in question, which is used only for numeric type objects.
Throws:
SQLException - If an error occurs.

updateObject

public void updateObject(String columnName,
                         Object value)
            throws SQLException

This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateObject

public void updateObject(String columnName,
                         Object value,
                         int scale)
            throws SQLException

This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
scale - The scale of the object in question, which is used only for numeric type objects.
Throws:
SQLException - If an error occurs.

updateRef

public void updateRef(int columnIndex,
                      Ref value)
            throws SQLException

This method updates the specified column to have a java.sql.Ref value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateRef

public void updateRef(String columnName,
                      Ref value)
            throws SQLException

This method updates the specified column to have a java.sql.Ref value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateRow

public void updateRow()
            throws SQLException

This method updates the current row in the database.
Throws:
SQLException - If an error occurs.

updateShort

public void updateShort(int columnIndex,
                        short value)
            throws SQLException

This method updates the specified column to have a short value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateShort

public void updateShort(String columnName,
                        short value)
            throws SQLException

This method updates the specified column to have a short value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateString

public void updateString(int columnIndex,
                         String value)
            throws SQLException

This method updates the specified column to have a String value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateString

public void updateString(String columnName,
                         String value)
            throws SQLException

This method updates the specified column to have a String value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTime

public void updateTime(int columnIndex,
                       Time value)
            throws SQLException

This method updates the specified column to have a java.sql.Time value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTime

public void updateTime(String columnName,
                       Time value)
            throws SQLException

This method updates the specified column to have a java.sql.Time value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTimestamp

public void updateTimestamp(int columnIndex,
                            Timestamp value)
            throws SQLException

This method updates the specified column to have a java.sql.Timestamp value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTimestamp

public void updateTimestamp(String columnName,
                            Timestamp value)
            throws SQLException

This method updates the specified column to have a java.sql.Timestamp value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

wasNull

public boolean wasNull()
            throws SQLException

This method tests whether the value of the last column that was fetched was actually a SQL NULL value.
Returns:
true if the last column fetched was a NULL, false otherwise.
Throws:
SQLException - If an error occurs.

ResultSet.java -- A SQL statement result set. Copyright (C) 1999, 2000, 2002, 2006 Free Software Foundation, Inc. This file is part of GNU Classpath. GNU Classpath is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2, or (at your option) any later version. GNU Classpath is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with GNU Classpath; see the file COPYING. If not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. Linking this library statically or dynamically with other modules is making a combined work based on this library. Thus, the terms and conditions of the GNU General Public License cover the whole combination. As a special exception, the copyright holders of this library give you permission to link this library with independent modules to produce an executable, regardless of the license terms of these independent modules, and to copy and distribute the resulting executable under terms of your choice, provided that you also meet, for each linked independent module, the terms and conditions of the license of that module. An independent module is a module which is not derived from or based on this library. If you modify this library, you may extend this exception to your version of the library, but you are not obligated to do so. If you do not wish to do so, delete this exception statement from your version.

Overview Package Class Use Source Tree Index Deprecated About
Prev Class \| Next Class		Frames \| No Frames
Summary: Nested \| Field \| Method \| Constr	Detail: Nested \| Field \| Method \| Constr

java.sql

Interface ResultSet

Field Summary

Method Summary

Methods inherited from interface java.lang.AutoCloseable

Field Details

CLOSE_CURSORS_AT_COMMIT

CONCUR_READ_ONLY

CONCUR_UPDATABLE

FETCH_FORWARD

FETCH_REVERSE

FETCH_UNKNOWN

HOLD_CURSORS_OVER_COMMIT

TYPE_FORWARD_ONLY

TYPE_SCROLL_INSENSITIVE

TYPE_SCROLL_SENSITIVE

Method Details

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

getTime

getTime