Summary: Constants | Methods | [Expand All]

public interface

ResultSet

java.sql.ResultSet

Known Indirect Subclasses

RowSet

Class Overview

An interface for an object which represents a database table entry, returned as the result of the query to the database.

ResultSets have a cursor which points to the current data table row. When the ResultSet is created, the cursor's location is one position ahead of the first row. To move the cursor to the first and consecutive rows, use the next method. The next method returns true as long as there are more rows in the ResultSet, otherwise it returns false.

The default type of ResultSet can not be updated and its cursor can only advance forward through the rows of data. This means that it is only possible to read through it once. However, other kinds of ResultSet are implemented: an updatable type and also types where the cursor can be scrolled forward and backward through the rows of data. How such a ResultSet is created is demonstrated in the following example:

Connection con;

Statement aStatement = con.createStatement(
 ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE );

ResultSet theResultSet =
 theStatement.executeQuery("SELECT price, quantity FROM STOCKTABLE");

// theResultSet is both scrollable and updatable

The ResultSet interface provides a series of methods for retrieving data from columns in the current row, such as getDate and getFloat. The columns are retrieved either by their index number (starting at 1) or by their name - there are separate methods for both techniques of column addressing. The column names are case insensitive. If several columns have the same name, then the getter methods use the first matching column. This means that if column names are used, it is not possible to guarantee that the name will retrieve data from the intended column - for certainty it is better to use column indexes. Ideally the columns should be read left-to-right and read once only, since not all databases are optimized to handle other techniques of reading the data.

When reading data via the appropriate getter methods, the JDBC driver maps the SQL data retrieved from the database to the Java type implied by the method invoked by the application. The JDBC specification has a table for the mappings from SQL types to Java types.

There are also methods for writing data into the ResultSet, such as updateInt and updateString. The update methods can be used either to modify the data of an existing row or to insert new data rows into the ResultSet . Modification of existing data involves moving the cursor to the row which needs modification and then using the update methods to modify the data, followed by calling the ResultSet.updateRow method. For insertion of new rows, the cursor is first moved to a special row called the Insert Row, data is added using the update methods, followed by calling the ResultSet.insertRow method.

A ResultSet is closed if the statement which generated it closes, the statement is executed again, or the same statement's next ResultSet is retrieved (if the statement returned of multiple results).

Summary

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

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

Constants

public static final int CLOSE_CURSORS_AT_COMMIT

Since: API Level 1

A constant used to indicate that a ResultSet object must be closed when the method Connection.commit is invoked.

Constant Value: 2 (0x00000002)

public static final int CONCUR_READ_ONLY

Since: API Level 1

A constant used to indicate the concurrency mode for a ResultSet object that cannot be updated.

Constant Value: 1007 (0x000003ef)

public static final int CONCUR_UPDATABLE

Since: API Level 1

A constant used to indicate the concurrency mode for a ResultSet object that can be updated.

Constant Value: 1008 (0x000003f0)

public static final int FETCH_FORWARD

Since: API Level 1

A constant used to indicate processing of the rows of a ResultSet in the forward direction, first to last.

Constant Value: 1000 (0x000003e8)

public static final int FETCH_REVERSE

Since: API Level 1

A constant used to indicate processing of the rows of a ResultSet in the reverse direction, last to first.

Constant Value: 1001 (0x000003e9)

public static final int FETCH_UNKNOWN

Since: API Level 1

A constant used to indicate that the order of processing of the rows of a ResultSet is unknown.

Constant Value: 1002 (0x000003ea)

public static final int HOLD_CURSORS_OVER_COMMIT

Since: API Level 1

A constant used to indicate that a ResultSet object must not be closed when the method Connection.commit is invoked.

Constant Value: 1 (0x00000001)

public static final int TYPE_FORWARD_ONLY

Since: API Level 1

A constant used to indicate a ResultSet object whose cursor can only move forward.

Constant Value: 1003 (0x000003eb)

public static final int TYPE_SCROLL_INSENSITIVE

Since: API Level 1

A constant used to indicate a ResultSet object which is scrollable but is insensitive to changes made by others.

Constant Value: 1004 (0x000003ec)

public static final int TYPE_SCROLL_SENSITIVE

Since: API Level 1

A constant used to indicate a ResultSet object which is scrollable and sensitive to changes made by others.

Constant Value: 1005 (0x000003ed)

Public Methods

public abstract boolean absolute (int row)

Since: API Level 1

Moves the cursor to a specified row number in the ResultSet.

Parameters

row	the index of the row starting at index 1. Index `-1` returns the last row.

Returns

true if the new cursor position is on the ResultSet, false otherwise.

Throws

SQLException	if a database error happens.

public abstract void afterLast ()

Since: API Level 1

Moves the cursor to the end of the ResultSet, after the last row.

Throws

SQLException	if a database error happens.

public abstract void beforeFirst ()

Since: API Level 1

Moves the cursor to the start of the ResultSet, before the first row.

Throws

SQLException	if a database error happens.

public abstract void cancelRowUpdates ()

Since: API Level 1

Cancels any updates made to the current row in the ResultSet.

Throws

SQLException	if a database error happens.

public abstract void clearWarnings ()

Since: API Level 1

Clears all warnings related to this ResultSet.

Throws

SQLException	if a database error happens.

public abstract void close ()

Since: API Level 1

Releases this ResultSet's database and JDBC resources. You are strongly advised to use this method rather than relying on the release being done when the ResultSet's finalize method is called during garbage collection process. Note that the close() method might take some time to complete since it is dependent on the behavior of the connection to the database and the database itself.

Throws

SQLException	if a database error happens.

public abstract void deleteRow ()

Since: API Level 1

Deletes the current row from the ResultSet and from the underlying database.

Throws

SQLException	if a database error happens.

public abstract int findColumn (String columnName)

Since: API Level 1

Gets the index number for a column in the ResultSet from the provided column name.

Parameters

columnName	the column name.

Returns

the column's index in the ResultSet identified by column name.

Throws

SQLException	if a database error happens.

public abstract boolean first ()

Since: API Level 1

Shifts the cursor position to the first row in the ResultSet.

Returns

true if the position is in a legitimate row, false if the ResultSet contains no rows.

Throws

SQLException	if a database error happens.

public abstract Array getArray (String colName)

Since: API Level 1

Gets the value of a column specified by column name as a java.sql.Array.

Parameters

colName	the name of the column to read.

Returns

a java.sql.Array with the data from the specified column.

Throws

SQLException	if a database error happens.

public abstract Array getArray (int columnIndex)

Since: API Level 1

Gets the content of a column specified by column index in the current row of this ResultSet as a java.sql.Array.

Parameters

columnIndex	the index of the column to read

Returns

a java.sql.Array with the data from the column.

Throws

SQLException	if a database error happens.

public abstract InputStream getAsciiStream (String columnName)

Since: API Level 1

Gets the value of a column specified by column name as an ASCII character stream.

Parameters

columnName	the name of the column to read

Returns

an InputStream with the data from the column.

Throws

SQLException	if a database error happens.

public abstract InputStream getAsciiStream (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as an ASCII character stream.

Parameters

columnIndex	the index of the column to read.

Returns

an InputStream with the data from the column.

Throws

SQLException	if a database error happens.

public abstract BigDecimal getBigDecimal (String columnName, int scale)

Since: API Level 1

This method is deprecated.
use getBigDecimal(int) or getBigDecimal(String)

Gets the value of a column specified by column name, as a java.math.BigDecimal.

Parameters

columnName	the name of the column to read.
scale	the number of digits after the decimal point

Returns

a BigDecimal with value of the column.

Throws

SQLException	if a database error happens.

public abstract BigDecimal getBigDecimal (int columnIndex, int scale)

Since: API Level 1

This method is deprecated.
use getBigDecimal(int) or getBigDecimal(String)

Gets the value of a column specified by column index as a java.math.BigDecimal.

Parameters

columnIndex	the index of the column to read.
scale	the number of digits after the decimal point

Returns

a BigDecimal with the value of the column.

Throws

SQLException	if a database error happens.

public abstract BigDecimal getBigDecimal (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a java.math.BigDecimal.

Parameters

columnIndex	the index of the column to read.

Returns

a BigDecimal with the value of the column.

Throws

SQLException	if a database error happens.

public abstract BigDecimal getBigDecimal (String columnName)

Since: API Level 1

Gets the value of a column specified by column name, as a java.math.BigDecimal.

Parameters

columnName	the name of the column to read.

Returns

a BigDecimal with value of the column.

Throws

SQLException	if a database error happens.

public abstract InputStream getBinaryStream (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a binary stream.

This method can be used to read LONGVARBINARY values. All of the data in the InputStream should be read before getting data from any other column. A further call to a getter method will implicitly close the InputStream.

Parameters

columnIndex	the index of the column to read.

Returns

an InputStream with the data from the column. If the column value is SQL NULL, null is returned.

Throws

SQLException	if a database error happens.

public abstract InputStream getBinaryStream (String columnName)

Since: API Level 1

Gets the value of a column specified by column name as a binary stream.

This method can be used to read LONGVARBINARY values. All of the data in the InputStream should be read before getting data from any other column. A further call to a getter method will implicitly close the InputStream.

Parameters

columnName	the name of the column to read.

Returns

an InputStream with the data from the column if the column value is SQL NULL, null is returned.

Throws

SQLException	if a database error happens.

public abstract Blob getBlob (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a java.sql.Blob object.

Parameters

columnIndex	the index of the column to read.

Returns

a java.sql.Blob with the value of the column.

Throws

SQLException	if a database error happens.

public abstract Blob getBlob (String columnName)

Since: API Level 1

Gets the value of a column specified by column name, as a java.sql.Blob object.

Parameters

columnName	the name of the column to read.

Returns

a java.sql.Blob with the value of the column.

Throws

SQLException	if a database error happens.

public abstract boolean getBoolean (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a boolean .

Parameters

columnIndex	the index of the column to read.

Returns

a boolean value from the column. If the column is SQL NULL, false is returned.

Throws

SQLException	if a database error happens.

public abstract boolean getBoolean (String columnName)

Since: API Level 1

Gets the value of a column specified by column name, as a boolean .

Parameters

columnName	the name of the column to read.

Returns

a boolean value from the column. If the column is SQL NULL, false is returned.

Throws

SQLException	if a database error happens.

public abstract byte getByte (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a byte.

Parameters

columnIndex	the index of the column to read.

Returns

a byte equal to the value of the column. 0 if the value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract byte getByte (String columnName)

Since: API Level 1

Gets the value of a column specified by column name as a byte.

Parameters

columnName	the name of the column to read.

Returns

a byte equal to the value of the column. 0 if the value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract byte[] getBytes (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a byte array.

Parameters

columnIndex	the index of the column to read.

Returns

a byte array containing the value of the column. null if the column contains SQL NULL.

Throws

SQLException	if a database error happens.

public abstract byte[] getBytes (String columnName)

Since: API Level 1

Gets the value of a column specified by column name as a byte array.

Parameters

columnName	the name of the column to read.

Returns

a byte array containing the value of the column. null if the column contains SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Reader getCharacterStream (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a java.io.Reader object.

Parameters

columnIndex	the index of the column to read.

Returns

a Reader holding the value of the column. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Reader getCharacterStream (String columnName)

Since: API Level 1

Gets the value of a column specified by column name as a java.io.Reader object.

Parameters

columnName	the name of the column to read.

Returns

a Reader holding the value of the column. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Clob getClob (String colName)

Since: API Level 1

Gets the value of a column specified by column name as a java.sql.Clob.

Parameters

colName	the name of the column to read.

Returns

a Clob object representing the value in the column. null if the value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Clob getClob (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a java.sql.Clob.

Parameters

columnIndex	the index of the column to read.

Returns

a Clob object representing the value in the column. null if the value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract int getConcurrency ()

Since: API Level 1

Gets the concurrency mode of this ResultSet.

Returns

the concurrency mode - one of: ResultSet.CONCUR_READ_ONLY , ResultSet.CONCUR_UPDATABLE.

Throws

SQLException	if a database error happens.

public abstract String getCursorName ()

Since: API Level 1

Gets the name of the SQL cursor of this ResultSet.

Returns

the SQL cursor name.

Throws

SQLException	if a database error happens.

public abstract Date getDate (String columnName, Calendar cal)

Since: API Level 1

Gets the value of a column specified by column name, as a java.sql.Date object.

Parameters

columnName	the name of the column to read.
cal	`java.util.Calendar` to use in constructing the Date.

Returns

a java.sql.Date matching the column value. null if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Date getDate (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a java.sql.Date.

Parameters

columnIndex	the index of the column to read.

Returns

a java.sql.Date matching the column value. null if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Date getDate (String columnName)

Since: API Level 1

Gets the value of a column specified by column name as a java.sql.Date.

Parameters

columnName	the name of the column to read.

Returns

a java.sql.Date matching the column value. null if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Date getDate (int columnIndex, Calendar cal)

Since: API Level 1

Gets the value of a column specified by column index as a java.sql.Date. This method uses a supplied calendar to compute the Date.

Parameters

columnIndex	the index of the column to read.
cal	a `java.util.Calendar` to use in constructing the Date.

Returns

a java.sql.Date matching the column value. null if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract double getDouble (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a double value.

Parameters

columnIndex	the index of the column to read.

Returns

a double equal to the column value. 0.0 if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract double getDouble (String columnName)

Since: API Level 1

Gets the value of a column specified by column name as a double value.

Parameters

columnName	the name of the column to read.

Returns

a double equal to the column value. 0.0 if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract int getFetchDirection ()

Since: API Level 1

Gets the direction in which rows are fetched for this ResultSet object.

Returns

the fetch direction. Will be one of:
- ResultSet.FETCH_FORWARD
- ResultSet.FETCH_REVERSE
- ResultSet.FETCH_UNKNOWN

Throws

SQLException	if a database error happens.

public abstract int getFetchSize ()

Since: API Level 1

Gets the fetch size (in number of rows) for this ResultSet.

Returns

the fetch size as an int

Throws

SQLException	if a database error happens.

public abstract float getFloat (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a float value.

Parameters

columnIndex	the index of the column to read.

Returns

a float equal to the column value. 0.0 if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract float getFloat (String columnName)

Since: API Level 1

Gets the value of a column specified by column name as a float value.

Parameters

columnName	the name of the column to read.

Returns

a float equal to the column value. 0.0 if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract int getInt (String columnName)

Since: API Level 1

Gets the value of a column specified by column name, as an int value.

Parameters

columnName	the name of the column to read.

Returns

an int equal to the column value. 0 if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract int getInt (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as an int value.

Parameters

columnIndex	the index of the column to read.

Returns

an int equal to the column value. 0 if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract long getLong (String columnName)

Since: API Level 1

Gets the value of a column specified by column name, as a long value.

Parameters

columnName	the name of the column to read.

Returns

a long equal to the column value. 0 if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract long getLong (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a long value.

Parameters

columnIndex	the index of the column to read.

Returns

a long equal to the column value. 0 if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract ResultSetMetaData getMetaData ()

Since: API Level 1

Gets the metadata for this ResultSet. This defines the number, types and properties of the columns in the ResultSet.

Returns

a ResultSetMetaData object with information about this ResultSet.

Throws

SQLException	if a database error happens.

public abstract Object getObject (String columnName, Map<String, Class<?>> map)

Since: API Level 1

Gets the value of a column specified by column name as a Java Object.

The type of the Java object will be determined by the supplied Map to perform the mapping of SQL Struct or Distinct types into Java objects.

Parameters

columnName	the name of the column to read.
map	a `java.util.Map` containing a mapping from SQL Type names to Java classes.

Returns

an Object containing the value of the column. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Object getObject (String columnName)

Since: API Level 1

Gets the value of a specified column as a Java Object. The type of the returned object will be the default according to the column's SQL type, following the JDBC specification for built-in types.

For SQL User Defined Types, if a column value is structured or distinct, this method behaves the same as a call to: getObject(columnIndex,this.getStatement().getConnection().getTypeMap())

Parameters

columnName	the name of the column to read.

Returns

an Object containing the value of the column. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Object getObject (int columnIndex, Map<String, Class<?>> map)

Since: API Level 1

Gets the value of a column specified by column index as a Java Object.

The type of the Java object will be determined by the supplied Map to perform the mapping of SQL Struct or Distinct types into Java objects.

Parameters

columnIndex	the index of the column to read.
map	a `java.util.Map` containing a mapping from SQL Type names to Java classes.

Returns

an Object containing the value of the column. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Object getObject (int columnIndex)

Since: API Level 1

Gets the value of a specified column as a Java Object. The type of the returned object will be the default according to the column's SQL type, following the JDBC specification for built-in types.

For SQL User Defined Types, if a column value is Structured or Distinct, this method behaves the same as a call to: getObject(columnIndex,this.getStatement().getConnection().getTypeMap())

Parameters

columnIndex	the index of the column to read.

Returns

an Object containing the value of the column. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Ref getRef (String colName)

Since: API Level 1

Gets the value of a column specified by column name as a Java java.sql.Ref.

Parameters

colName	the name of the column to read.

Returns

a Ref representing the value of the SQL REF in the column

Throws

SQLException	if a database error happens.

public abstract Ref getRef (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a Java java.sql.Ref.

Parameters

columnIndex	the index of the column to read.

Returns

a Ref representing the value of the SQL REF in the column

Throws

SQLException	if a database error happens.

public abstract int getRow ()

Since: API Level 1

Gets the number of the current row in the ResultSet. Row numbers start at 1 for the first row.

Returns

the index number of the current row. 0 is returned if there is no current row.

Throws

SQLException	if a database error happens.

public abstract short getShort (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a short value.

Parameters

columnIndex	the index of the column to read.

Returns

a short value equal to the value of the column. 0 if the value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract short getShort (String columnName)

Since: API Level 1

Gets the value of a column specified by column name, as a short value.

Parameters

columnName	the name of the column to read.

Returns

a short value equal to the value of the column. 0 if the value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Statement getStatement ()

Since: API Level 1

Gets the statement that produced this ResultSet. If the ResultSet was not created by a statement (i.e. because it was returned from one of the DatabaseMetaData methods), null is returned.

Returns

the Statement which produced this ResultSet, or null if the ResultSet was not created by a Statement.

Throws

SQLException	if a database error happens.

public abstract String getString (String columnName)

Since: API Level 1

Gets the value of a column specified by column name, as a String.

Parameters

columnName	the name of the column to read.

Returns

the String representing the value of the column, null if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract String getString (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a String.

Parameters

columnIndex	the index of the column to read.

Returns

the String representing the value of the column, null if the column is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Time getTime (int columnIndex, Calendar cal)

Since: API Level 1

Gets the value of a column specified by column index as a java.sql.Time value. The supplied Calendar is used to map the SQL Time value to a Java Time value.

Parameters

columnIndex	the index of the column to read.
cal	a `Calendar` to use in creating the Java Time value.

Returns

a Time representing the column value, null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Time getTime (String columnName, Calendar cal)

Since: API Level 1

Gets the value of a column specified by column index, as a java.sql.Time value. The supplied Calendar is used to map the SQL Time value to a Java Time value.

Parameters

columnName	the name of the column to read.
cal	a `Calendar` to use in creating the Java time value.

Returns

a Time representing the column value, null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Time getTime (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a java.sql.Time value.

Parameters

columnIndex	the index of the column to read.

Returns

a Time representing the column value, null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Time getTime (String columnName)

Since: API Level 1

Gets the value of a column specified by column name, as a java.sql.Time value.

Parameters

columnName	the name of the column to read.

Returns

the column value, null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Timestamp getTimestamp (String columnName)

Since: API Level 1

Gets the value of a column specified by column name, as a java.sql.Timestamp value.

Parameters

columnName	the name of the column to read.

Returns

a timestamp representing the column value, null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Timestamp getTimestamp (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a java.sql.Timestamp value.

Parameters

columnIndex	the index of the column to read.

Returns

a timestamp representing the column value, null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Timestamp getTimestamp (int columnIndex, Calendar cal)

Since: API Level 1

Gets the value of a column specified by column index, as a java.sql.Timestamp value. The supplied Calendar is used when mapping the SQL Timestamp value to a Java Timestamp value.

Parameters

columnIndex	the index of the column to read.
cal	Calendar to use in creating the Java timestamp value.

Returns

a timestamp representing the column value, null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract Timestamp getTimestamp (String columnName, Calendar cal)

Since: API Level 1

Gets the value of a column specified by column name, as a java.sql.Timestamp value. The supplied Calendar is used when mapping the SQL Timestamp value to a Java Timestamp value.

Parameters

columnName	the name of the column to read.
cal	Calendar to use in creating the Java `Timestamp` value.

Returns

a timestamp representing the column value, null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract int getType ()

Since: API Level 1

Gets the type of the ResultSet.

Returns

The ResultSet type, one of:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE

Throws

SQLException	if there is a database error.

public abstract URL getURL (int columnIndex)

Since: API Level 1

Gets the value of a column specified by column index as a java.net.URL.

Parameters

columnIndex	the index of the column to read.

Returns

a URL. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract URL getURL (String columnName)

Since: API Level 1

Gets the value of a column specified by column name as a java.net.URL object.

Parameters

columnName	the name of the column to read.

Returns

the column vaule as a URL. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract InputStream getUnicodeStream (String columnName)

Since: API Level 1

This method is deprecated.
Use getCharacterStream(int)

Gets the value of the column as an InputStream of Unicode characters.

Parameters

columnName	the name of the column to read.

Returns

an InputStream holding the value of the column. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract InputStream getUnicodeStream (int columnIndex)

Since: API Level 1

This method is deprecated.
Use getCharacterStream(int).

Gets the value of the column as an InputStream of unicode characters.

Parameters

columnIndex	the index of the column to read.

Returns

an InputStream holding the value of the column. null if the column value is SQL NULL.

Throws

SQLException	if a database error happens.

public abstract SQLWarning getWarnings ()

Since: API Level 1

Gets the first warning generated by calls on this ResultSet. Subsequent warnings on this ResultSet are chained to the first one.

The warnings are cleared when a new Row is read from the ResultSet. The warnings returned by this method are only the warnings generated by ResultSet method calls - warnings generated by Statement methods are held by the Statement.

An SQLException is generated if this method is called on a closed ResultSet.

Returns

an SQLWarning which is the first warning for this ResultSet. null if there are no warnings.

Throws

SQLException	if a database error happens.

public abstract void insertRow ()

Since: API Level 1

Insert the insert row into the ResultSet and into the underlying database. The cursor must be set to the Insert Row before this method is invoked.

Throws

SQLException	if a database error happens. Particular cases include the cursor not being on the Insert Row or if any columns in the row do not have a value where the column is declared as not-nullable.

public abstract boolean isAfterLast ()

Since: API Level 1

Gets if the cursor is after the last row of the ResultSet.

Returns

true if the cursor is after the last row in the ResultSet, false if the cursor is at any other position in the ResultSet.

Throws

SQLException	if a database error happens.

public abstract boolean isBeforeFirst ()

Since: API Level 1

Gets if the cursor is before the first row of the ResultSet.

Returns

true if the cursor is before the first row in the ResultSet, false if the cursor is at any other position in the ResultSet.

Throws

SQLException	if a database error happens.

public abstract boolean isFirst ()

Since: API Level 1

Gets if the cursor is on the first row of the ResultSet.

Returns

true if the cursor is on the first row in the ResultSet, false if the cursor is at any other position in the ResultSet.

Throws

SQLException	if a database error happens.

public abstract boolean isLast ()

Since: API Level 1

Gets if the cursor is on the last row of the ResultSet

Returns

true if the cursor is on the last row in the ResultSet, false if the cursor is at any other position in the ResultSet.

Throws

SQLException	if a database error happens.

public abstract boolean last ()

Since: API Level 1

Shifts the cursor position to the last row of the ResultSet.

Returns

true if the new position is in a legitimate row, false if the ResultSet contains no rows.

Throws

SQLException	if there is a database error.

public abstract void moveToCurrentRow ()

Since: API Level 1

Moves the cursor to the remembered position, namely the row that was the current row before a call to moveToInsertRow. This only applies if the cursor is on the Insert Row.

Throws

SQLException	if a database error happens.

public abstract void moveToInsertRow ()

Since: API Level 1

Moves the cursor position to the Insert Row. The current position is remembered and the cursor is positioned at the Insert Row. The columns in the Insert Row should be filled in with the appropriate update methods, before calling insertRow to insert the new row into the database.

Throws

SQLException	if a database error happens.

public abstract boolean next ()

Since: API Level 1

Shifts the cursor position down one row in this ResultSet object.

Any input streams associated with the current row are closed and any warnings are cleared.

Returns

true if the updated cursor position is pointing to a valid row, false otherwise (i.e. when the cursor is after the last row in the ResultSet).

Throws

SQLException	if a database error happens.

public abstract boolean previous ()

Since: API Level 1

Relocates the cursor position to the preceding row in this ResultSet.

Returns

true if the new position is in a legitimate row, false if the cursor is now before the first row.

Throws

SQLException	if a database error happens.

public abstract void refreshRow ()

Since: API Level 1

Refreshes the current row with its most up to date value in the database. Must not be called when the cursor is on the Insert Row.

If any columns in the current row have been updated but the updateRow has not been called, then the updates are lost when this method is called.

Throws

SQLException	if a database error happens., including if the current row is the Insert row.

public abstract boolean relative (int rows)

Since: API Level 1

Moves the cursor position up or down by a specified number of rows. If the new position is beyond the start row (or end row), the cursor position is set before the first row (or, respectively, after the last row).

Parameters

rows	a number of rows to move the cursor - may be positive or negative

Returns

true if the new cursor position is on a row, false otherwise

Throws

SQLException	if a database error happens.

public abstract boolean rowDeleted ()

Since: API Level 1

Indicates whether a row has been deleted. This method depends on whether the JDBC driver and database can detect deletions.

Returns

true if a row has been deleted and if deletions are detected, false otherwise.

Throws

SQLException	if a database error happens.

public abstract boolean rowInserted ()

Since: API Level 1

Indicates whether the current row has had an insertion operation. This method depends on whether the JDBC driver and database can detect insertions.

Returns

true if a row has been inserted and if insertions are detected, false otherwise.

Throws

SQLException	if a database error happens.

public abstract boolean rowUpdated ()

Since: API Level 1

Indicates whether the current row has been updated. This method depends on whether the JDBC driver and database can detect updates.

Returns

true if the current row has been updated and if updates can be detected, false otherwise.

Throws

SQLException	if a database error happens.

public abstract void setFetchDirection (int direction)

Since: API Level 1

Indicates which direction (forward/reverse) will be used to process the rows of this ResultSet object. This is treated as a hint by the JDBC driver.

Parameters

direction	can be `ResultSet.FETCH_FORWARD`, `ResultSet.FETCH_REVERSE`, or `ResultSet.FETCH_UNKNOWN`

Throws

SQLException	if there is a database error.

public abstract void setFetchSize (int rows)

Since: API Level 1

Indicates the number of rows to fetch from the database when extra rows are required for this ResultSet. This used as a hint to the JDBC driver.

Parameters

rows	the number of rows to fetch. `0` implies that the JDBC driver can make its own decision about the fetch size. The number should not be greater than the maximum number of rows established by the statement that generated the `ResultSet`.

Throws

SQLException	if a database error happens.

public abstract void updateArray (int columnIndex, Array x)

Since: API Level 1

Updates a column specified by a column index with a java.sql.Array value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateArray (String columnName, Array x)

Since: API Level 1

Updates a column specified by a column name with a java.sql.Array value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateAsciiStream (String columnName, InputStream x, int length)

Since: API Level 1

Updates a column specified by a column name with an Ascii stream value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.
length	the length of the data to write from the stream

Throws

SQLException	if a database error happens.

public abstract void updateAsciiStream (int columnIndex, InputStream x, int length)

Since: API Level 1

Updates a column specified by a column index with an ASCII stream value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.
length	the length of the data to write from the stream

Throws

SQLException	if a database error happens.

public abstract void updateBigDecimal (int columnIndex, BigDecimal x)

Since: API Level 1

Updates a column specified by a column index with a java.sql.BigDecimal value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateBigDecimal (String columnName, BigDecimal x)

Since: API Level 1

Updates a column specified by a column name with a java.sql.BigDecimal value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateBinaryStream (String columnName, InputStream x, int length)

Since: API Level 1

Updates a column specified by a column name with a binary stream value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.
length	he number of bytes to be read from the the stream.

Throws

SQLException	if a database error happens.

public abstract void updateBinaryStream (int columnIndex, InputStream x, int length)

Since: API Level 1

Updates a column specified by a column index with a binary stream value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.
length	the number of bytes to be read from the the stream.

Throws

SQLException	if a database error happens.

public abstract void updateBlob (int columnIndex, Blob x)

Since: API Level 1

Updates a column specified by a column index with a java.sql.Blob value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateBlob (String columnName, Blob x)

Since: API Level 1

Updates a column specified by a column name with a java.sql.Blob value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateBoolean (String columnName, boolean x)

Since: API Level 1

Updates a column specified by a column name with a boolean value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateBoolean (int columnIndex, boolean x)

Since: API Level 1

Updates a column specified by a column index with a boolean value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateByte (String columnName, byte x)

Since: API Level 1

Updates a column specified by a column name with a byte value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateByte (int columnIndex, byte x)

Since: API Level 1

Updates a column specified by a column index with a byte value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateBytes (String columnName, byte[] x)

Since: API Level 1

Updates a column specified by a column name with a byte array value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateBytes (int columnIndex, byte[] x)

Since: API Level 1

Updates a column specified by a column index with a byte array value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateCharacterStream (int columnIndex, Reader x, int length)

Since: API Level 1

Updates a column specified by a column index with a character stream value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.
length	the length of data to write from the stream

Throws

SQLException	if a database error happens.

public abstract void updateCharacterStream (String columnName, Reader reader, int length)

Since: API Level 1

Updates a column specified by a column name with a character stream value.

Parameters

columnName	the name of the column to update.
reader	the new value for the specified column.
length	the length of data to write from the Reader

Throws

SQLException	if a database error happens.

public abstract void updateClob (String columnName, Clob x)

Since: API Level 1

Updates a column specified by a column name with a java.sql.Clob value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateClob (int columnIndex, Clob x)

Since: API Level 1

Updates a column specified by a column index with a java.sql.Clob value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateDate (String columnName, Date x)

Since: API Level 1

Updates a column specified by a column name with a java.sql.Date value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateDate (int columnIndex, Date x)

Since: API Level 1

Updates a column specified by a column index with a java.sql.Date value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateDouble (int columnIndex, double x)

Since: API Level 1

Updates a column specified by a column index with a double value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateDouble (String columnName, double x)

Since: API Level 1

Updates a column specified by a column name with a double value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateFloat (int columnIndex, float x)

Since: API Level 1

Updates a column specified by a column index with a float value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateFloat (String columnName, float x)

Since: API Level 1

Updates a column specified by a column name with a float value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateInt (String columnName, int x)

Since: API Level 1

Updates a column specified by a column name with an int value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateInt (int columnIndex, int x)

Since: API Level 1

Updates a column specified by a column index with an int value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateLong (int columnIndex, long x)

Since: API Level 1

Updates a column specified by a column index with a long value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column..

Throws

SQLException	if a database error happens.

public abstract void updateLong (String columnName, long x)

Since: API Level 1

Updates a column specified by a column name with a long value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateNull (int columnIndex)

Since: API Level 1

Updates a column specified by a column index with a null value.

Parameters

columnIndex	the index of the column to update.

Throws

SQLException	if a database error happens.

public abstract void updateNull (String columnName)

Since: API Level 1

Updates a column specified by a column name with a null value.

Parameters

columnName	the name of the column to update.

Throws

SQLException	if a database error happens.

public abstract void updateObject (int columnIndex, Object x)

Since: API Level 1

Updates a column specified by a column index with an Object value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateObject (int columnIndex, Object x, int scale)

Since: API Level 1

Updates a column specified by a column index with an Object value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.
scale	for the types `java.sql.Types.DECIMAL` or `java.sql.Types.NUMERIC`, this specifies the number of digits after the decimal point.

Throws

SQLException	if a database error happens.

public abstract void updateObject (String columnName, Object x)

Since: API Level 1

Updates a column specified by a column name with an Object value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateObject (String columnName, Object x, int scale)

Since: API Level 1

Updates a column specified by a column name with an Object value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.
scale	for the types `java.sql.Types.DECIMAL` or `java.sql.Types.NUMERIC`, this specifies the number of digits after the decimal point.

Throws

SQLException	if a database error happens.

public abstract void updateRef (int columnIndex, Ref x)

Since: API Level 1

Updates a column specified by a column index with a java.sql.Ref value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateRef (String columnName, Ref x)

Since: API Level 1

Updates a column specified by a column name with a java.sql.Ref value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateRow ()

Since: API Level 1

Updates the database with the new contents of the current row of this ResultSet object.

Throws

SQLException	if a database error happens.

public abstract void updateShort (String columnName, short x)

Since: API Level 1

Updates a column specified by a column name with a short value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateShort (int columnIndex, short x)

Since: API Level 1

Updates a column specified by a column index with a short value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateString (String columnName, String x)

Since: API Level 1

Updates a column specified by a column name with a String value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateString (int columnIndex, String x)

Since: API Level 1

Updates a column specified by a column index with a String value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateTime (int columnIndex, Time x)

Since: API Level 1

Updates a column specified by a column index with a Time value.

Parameters

columnIndex	the index of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateTime (String columnName, Time x)

Since: API Level 1

Updates a column specified by a column name with a Time value.

Parameters

columnName	the name of the column to update.
x	the new value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateTimestamp (int columnIndex, Timestamp x)

Since: API Level 1

Updates a column specified by a column index with a Timestamp value.

Parameters

columnIndex	the index of the column to update.
x	the new timestamp value for the specified column.

Throws

SQLException	if a database error happens.

public abstract void updateTimestamp (String columnName, Timestamp x)

Since: API Level 1

Updates a column specified by column name with a Timestamp value.

Parameters

columnName	the name of the column to update.
x	the new timestamp value for the specified column.

Throws

SQLException	if a database error happens.

public abstract boolean wasNull ()

Since: API Level 1

Determines whether the last column read from this ResultSet contained SQL NULL.

Returns

{@code true if the last column contained SQL NULL, false otherwise

Throws

SQLException	if a database error happens.

Interfaces

Classes

Exceptions

ResultSet

Class Overview

Summary

Constants

public static final int CLOSE_CURSORS_AT_COMMIT

public static final int CONCUR_READ_ONLY

public static final int CONCUR_UPDATABLE

public static final int FETCH_FORWARD

public static final int FETCH_REVERSE

public static final int FETCH_UNKNOWN

public static final int HOLD_CURSORS_OVER_COMMIT

public static final int TYPE_FORWARD_ONLY

public static final int TYPE_SCROLL_INSENSITIVE

public static final int TYPE_SCROLL_SENSITIVE

Public Methods

public abstract boolean absolute (int row)

Parameters

Returns

Throws

public abstract void afterLast ()

Throws

public abstract void beforeFirst ()

Throws

public abstract void cancelRowUpdates ()

Throws

public abstract void clearWarnings ()

Throws

public abstract void close ()

Throws

public abstract void deleteRow ()

Throws

public abstract int findColumn (String columnName)

Parameters

Returns

Throws

public abstract boolean first ()

Returns

Throws

public abstract Array getArray (String colName)

Parameters

Returns

Throws

public abstract Array getArray (int columnIndex)

Parameters

Returns

Throws

public abstract InputStream getAsciiStream (String columnName)

Parameters

Returns

Throws

public abstract InputStream getAsciiStream (int columnIndex)

Parameters

Returns

Throws

public abstract BigDecimal getBigDecimal (String columnName, int scale)

Parameters

Returns

Throws

public abstract BigDecimal getBigDecimal (int columnIndex, int scale)

Parameters

Returns

Throws

public abstract BigDecimal getBigDecimal (int columnIndex)

Parameters

Returns

Throws

public abstract BigDecimal getBigDecimal (String columnName)

Parameters

Returns

Throws

public abstract InputStream getBinaryStream (int columnIndex)

Parameters

Returns

Throws

public abstract InputStream getBinaryStream (String columnName)

Parameters

Returns