oracle.adfnmc.java.sql
Interface ResultSet

public interface ResultSet

An interface to an Object which represents a Table of Data, typically returned as the result of a Query to a Database.

ResultSets have a Cursor which points to a current row of data. When a ResultSet is created, the Cursor is positioned before the first row. To move the Cursor to the next row in the table, use the next method. The next method returns true until there are no more rows in the ResultSet, when it returns false.

The default type of ResultSet cannot be updated and its cursor can only move forward through the rows of data. This means that it is only possible to read through it once. However, it is possible to create types of ResultSet that can be updated and also types where the cursor can be scrolled forward and backward through the rows of data. This is shown in the following code example: Connection con; Statement aStatement = con.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE ); ResultSet theResultSet = theStatement.executeQuery("SELECT price, quantity FROM STOCKTABLE"); // theResultSet will be both scrollable and updateable

The ResultSet interface provides a series of methods for retrieving data from columns in the current row, such as getDate, getFloat. The columns are identified 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, 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 of allowable mappings from SQL types to Java types.

There are also methods for writing data into the ResultSet, such as updateInt, 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 object which generated it closed, executed again or is used to retrieve the next result from a sequence of results.

Field Summary

static java.lang.Class	CLASS_INSTANCE
static int	CLOSE_CURSORS_AT_COMMIT A constant used to indicate that a ResultSet object must be closed when the method Connection.commit is invoked.
static int	CONCUR_READ_ONLY A constant used to indicate the Concurrency Mode for a ResultSet object that cannot be updated.
static int	CONCUR_UPDATABLE A constant used to indicate the Concurrency Mode for a ResultSet object that can be updated.
static int	FETCH_FORWARD A constant used to indicate processing of the rows of a ResultSet in the forward direction, first to last
static int	FETCH_REVERSE A constant used to indicate processing of the rows of a ResultSet in the reverse direction, last to first
static int	FETCH_UNKNOWN A constant used to indicate that the order of processing of the rows of a ResultSet is unknown.
static int	HOLD_CURSORS_OVER_COMMIT A constant used to indicate that a ResultSet object must not be closed when the method Connection.commit is invoked.
static int	TYPE_FORWARD_ONLY A constant used to indicate a ResultSet object whose Cursor can only move forward
static int	TYPE_SCROLL_INSENSITIVE A constant used to indicate a ResultSet object which is Scrollable but which is not sensitive to changes made by others
static int	TYPE_SCROLL_SENSITIVE A constant used to indicate a ResultSet object which is Scrollable but which is sensitive to changes made by others

Method Summary

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

Field Detail

CLASS_INSTANCE

static final java.lang.Class CLASS_INSTANCE

CLOSE_CURSORS_AT_COMMIT

static final int CLOSE_CURSORS_AT_COMMIT

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

See Also:

Constant Field Values

HOLD_CURSORS_OVER_COMMIT

static final int HOLD_CURSORS_OVER_COMMIT

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

See Also:

Constant Field Values

CONCUR_READ_ONLY

static final int CONCUR_READ_ONLY

A constant used to indicate the Concurrency Mode for a ResultSet object that cannot be updated.

See Also:

Constant Field Values

CONCUR_UPDATABLE

static final int CONCUR_UPDATABLE

A constant used to indicate the Concurrency Mode for a ResultSet object that can be updated.

See Also:

Constant Field Values

FETCH_FORWARD

static final int FETCH_FORWARD

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

See Also:

Constant Field Values

FETCH_REVERSE

static final int FETCH_REVERSE

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

See Also:

Constant Field Values

FETCH_UNKNOWN

static final int FETCH_UNKNOWN

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

See Also:

Constant Field Values

TYPE_FORWARD_ONLY

static final int TYPE_FORWARD_ONLY

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

See Also:

Constant Field Values

TYPE_SCROLL_INSENSITIVE

static final int TYPE_SCROLL_INSENSITIVE

A constant used to indicate a ResultSet object which is Scrollable but which is not sensitive to changes made by others

See Also:

Constant Field Values

TYPE_SCROLL_SENSITIVE

static final int TYPE_SCROLL_SENSITIVE

A constant used to indicate a ResultSet object which is Scrollable but which is sensitive to changes made by others

See Also:

Constant Field Values

Method Detail

absolute

boolean absolute(int row)
                 throws SQLException

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

Parameters:

row - The new row number for the Cursor

Returns:

true if the new Cursor position is on the ResultSet, false otherwise

Throws:

SQLException - if a database error happens

afterLast

void afterLast()
               throws SQLException

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

Throws:

SQLException - if a database error happens

beforeFirst

void beforeFirst()
                 throws SQLException

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

Throws:

SQLException - if a database error happens

cancelRowUpdates

void cancelRowUpdates()
                      throws SQLException

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

Throws:

SQLException - if a database error happens

clearWarnings

void clearWarnings()
                   throws SQLException

Clears all the warnings related to this ResultSet.

Throws:

SQLException - if a database error happens

close

void close()
           throws SQLException

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

Throws:

SQLException - if a database error happens

deleteRow

void deleteRow()
               throws SQLException

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

Throws:

SQLException - if a database error happens

findColumn

int findColumn(java.lang.String columnName)
               throws SQLException

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

Parameters:

columnName - the column name

Returns:

the index of the column in the ResultSet for the column name

Throws:

SQLException - if a database error happens

first

boolean first()
              throws SQLException

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

Returns:

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

Throws:

SQLException - if a database error happens

getArray

Array getArray(int columnIndex)
               throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getArray

Array getArray(java.lang.String colName)
               throws SQLException

Gets the value of a column specified as a 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 column

Throws:

SQLException - if a database error happens

getAsciiStream

java.io.InputStream getAsciiStream(int columnIndex)
                                   throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

an InputStream with the data from the column

Throws:

SQLException - if a database error happens

getAsciiStream

java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws SQLException

Gets the value of a column specified as a 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

getBinaryStream

java.io.InputStream getBinaryStream(int columnIndex)
                                    throws SQLException

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

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getBinaryStream

java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws SQLException

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

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getBlob

Blob getBlob(int columnIndex)
             throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getBlob

Blob getBlob(java.lang.String columnName)
             throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getBoolean

boolean getBoolean(int columnIndex)
                   throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getBoolean

boolean getBoolean(java.lang.String columnName)
                   throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getByte

byte getByte(int columnIndex)
             throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getByte

byte getByte(java.lang.String columnName)
             throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getBytes

byte[] getBytes(int columnIndex)
                throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getBytes

byte[] getBytes(java.lang.String columnName)
                throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getCharacterStream

java.io.Reader getCharacterStream(int columnIndex)
                                  throws SQLException

Gets the value of a column specified as a 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

getCharacterStream

java.io.Reader getCharacterStream(java.lang.String columnName)
                                  throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getClob

Clob getClob(int columnIndex)
             throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getClob

Clob getClob(java.lang.String colName)
             throws SQLException

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

Parameters:

colName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getConcurrency

int getConcurrency()
                   throws SQLException

Gets the concurrency mode of this ResultSet.

Returns:

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

Throws:

SQLException - if a database error happens

getCursorName

java.lang.String getCursorName()
                               throws SQLException

Gets the name of the SQL cursor of this ResultSet.

Returns:

a String containing the SQL cursor name

Throws:

SQLException - if a database error happens

getDate

Date getDate(int columnIndex)
             throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getDate

Date getDate(int columnIndex,
             java.util.Calendar cal)
             throws SQLException

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

Parameters:

columnIndex - the index of the column to read

cal - a java.util.Calendar to use in constructing the Date.

Returns:

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

Throws:

SQLException - if a database error happens

getDate

Date getDate(java.lang.String columnName)
             throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getDate

Date getDate(java.lang.String columnName,
             java.util.Calendar cal)
             throws SQLException

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

Parameters:

columnName - the name of the column to read

cal - java.util.Calendar to use in constructing the Date.

Returns:

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

Throws:

SQLException - if a database error happens

getDouble

double getDouble(int columnIndex)
                 throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

a double containing the column value. 0.0 if the column is SQL NULL.

Throws:

SQLException - if a database error happens

getDouble

double getDouble(java.lang.String columnName)
                 throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

a double containing the column value. 0.0 if the column is SQL NULL.

Throws:

SQLException - if a database error happens

getFetchDirection

int getFetchDirection()
                      throws SQLException

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

Returns:

the fetch direction. Will be: ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE or ResultSet.FETCH_UNKNOWN

Throws:

SQLException - if a database error happens

getFetchSize

int getFetchSize()
                 throws SQLException

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

Returns:

the fetch size as an int

Throws:

SQLException - if a database error happens

getFloat

float getFloat(int columnIndex)
               throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

a float containing the column value. 0.0 if the column is SQL NULL.

Throws:

SQLException - if a database error happens

getFloat

float getFloat(java.lang.String columnName)
               throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

a float containing the column value. 0.0 if the column is SQL NULL.

Throws:

SQLException - if a database error happens

getInt

int getInt(int columnIndex)
           throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

an int containing the column value. 0 if the column is SQL NULL.

Throws:

SQLException - if a database error happens

getInt

int getInt(java.lang.String columnName)
           throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

an int containing the column value. 0 if the column is SQL NULL.

Throws:

SQLException - if a database error happens

getLong

long getLong(int columnIndex)
             throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

a long containing the column value. 0 if the column is SQL NULL.

Throws:

SQLException - if a database error happens

getLong

long getLong(java.lang.String columnName)
             throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

a long containing the column value. 0 if the column is SQL NULL.

Throws:

SQLException - if a database error happens

getMetaData

ResultSetMetaData getMetaData()
                              throws SQLException

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

Returns:

a ResultSetMetaData object with information about this ResultSet.

Throws:

SQLException - if a database error happens

getObject

java.lang.Object getObject(int columnIndex)
                           throws SQLException

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

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getObject

java.lang.Object getObject(java.lang.String columnName)
                           throws SQLException

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

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getRef

Ref getRef(int columnIndex)
           throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getRef

Ref getRef(java.lang.String colName)
           throws SQLException

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

Parameters:

colName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getRow

int getRow()
           throws SQLException

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

Returns:

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

Throws:

SQLException - if a database error happens

getShort

short getShort(int columnIndex)
               throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getShort

short getShort(java.lang.String columnName)
               throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getStatement

Statement getStatement()
                       throws SQLException

Gets the Statement that produced this ResultSet. If the ResultSet was not created by a Statement (eg 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

getString

java.lang.String getString(int columnIndex)
                           throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getString

java.lang.String getString(java.lang.String columnName)
                           throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getTime

Time getTime(int columnIndex)
             throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getTime

Time getTime(int columnIndex,
             java.util.Calendar cal)
             throws SQLException

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

Parameters:

columnIndex - the index of the column to read

cal - a Calendar to use in creating the Java Time value.

Returns:

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

Throws:

SQLException - if a database error happens

getTime

Time getTime(java.lang.String columnName)
             throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getTime

Time getTime(java.lang.String columnName,
             java.util.Calendar cal)
             throws SQLException

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

Parameters:

columnName - the name of the column to read

cal - a Calendar to use in creating the Java Time value.

Returns:

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

Throws:

SQLException - if a database error happens

getTimestamp

Timestamp getTimestamp(int columnIndex)
                       throws SQLException

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getTimestamp

Timestamp getTimestamp(int columnIndex,
                       java.util.Calendar cal)
                       throws SQLException

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

Parameters:

columnIndex - the index of the column to read

cal - Calendar to use in creating the Java Timestamp value.

Returns:

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

Throws:

SQLException - if a database error happens

getTimestamp

Timestamp getTimestamp(java.lang.String columnName)
                       throws SQLException

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

Parameters:

columnName - the name of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getTimestamp

Timestamp getTimestamp(java.lang.String columnName,
                       java.util.Calendar cal)
                       throws SQLException

Gets the value of a column specified as a column name, as a java.sql.Timestamp value. The supplied Calendar is used to map between the SQL Timestamp value and the Java Timestamp value.

Parameters:

columnName - the name of the column to read

cal - Calendar to use in creating the Java Timestamp value.

Returns:

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

Throws:

SQLException - if a database error happens

getType

int getType()
            throws SQLException

Gets the type of the ResultSet.

Returns:

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

Throws:

SQLException - if there is a database error

getUnicodeStream

java.io.InputStream getUnicodeStream(int columnIndex)
                                     throws SQLException

Deprecated. Use getCharacterStream.

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

Parameters:

columnIndex - the index of the column to read

Returns:

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

Throws:

SQLException - if a database error happens

getUnicodeStream

java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                     throws SQLException

Deprecated. Use getCharacterStream

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

getWarnings

SQLWarning getWarnings()
                       throws SQLException

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

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

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

Returns:

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

Throws:

SQLException - if a database error happens

insertRow

void insertRow()
               throws SQLException

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

Throws:

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

isAfterLast

boolean isAfterLast()
                    throws SQLException

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

Returns:

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

Throws:

SQLException - if a database error happens

isBeforeFirst

boolean isBeforeFirst()
                      throws SQLException

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

Returns:

true if the Cursor is before the last Row in the ResultSet, false if the cursor is at any other position in the ResultSet.

Throws:

SQLException - if a database error happens

isFirst

boolean isFirst()
                throws SQLException

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

Returns:

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

Throws:

SQLException - if a database error happens

isLast

boolean isLast()
               throws SQLException

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

Returns:

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

Throws:

SQLException

last

boolean last()
             throws SQLException

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

Returns:

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

Throws:

SQLException - if there is a database error

moveToCurrentRow

void moveToCurrentRow()
                      throws SQLException

Moves the cursor to the remembered position, usually the current row. This only applies if the cursor is on the Insert row.

Throws:

SQLException - if a database error happens

moveToInsertRow

void moveToInsertRow()
                     throws SQLException

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

Throws:

SQLException - if a database error happens

next

boolean next()
             throws SQLException

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

Any InputStreams 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 (ie when the cursor is after the last row in the ResultSet).

Throws:

SQLException - if a database error happens

previous

boolean previous()
                 throws SQLException

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

Returns:

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

Throws:

SQLException - if a database error happens

refreshRow

void refreshRow()
                throws SQLException

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

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

Throws:

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

relative

boolean relative(int rows)
                 throws SQLException

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

Parameters:

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

Returns:

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

Throws:

SQLException - if a database error happens

rowDeleted

boolean rowDeleted()
                   throws SQLException

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

Returns:

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

Throws:

SQLException - if a database error happens

rowInserted

boolean rowInserted()
                    throws SQLException

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

Returns:

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

Throws:

SQLException - if a database error happens

rowUpdated

boolean rowUpdated()
                   throws SQLException

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

Returns:

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

Throws:

SQLException - if a database error happens

setFetchDirection

void setFetchDirection(int direction)
                       throws SQLException

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

Parameters:

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

Throws:

SQLException - if there is a database error

setFetchSize

void setFetchSize(int rows)
                  throws SQLException

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

Parameters:

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

Throws:

SQLException - if a database error happens

updateArray

void updateArray(int columnIndex,
                 Array x)
                 throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateArray

void updateArray(java.lang.String columnName,
                 Array x)
                 throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateAsciiStream

void updateAsciiStream(int columnIndex,
                       java.io.InputStream x,
                       int length)
                       throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

length - the length of the data to write from the stream

Throws:

SQLException - if a database error happens

updateAsciiStream

void updateAsciiStream(java.lang.String columnName,
                       java.io.InputStream x,
                       int length)
                       throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

length - the length of the data to write from the stream

Throws:

SQLException - if a database error happens

updateBinaryStream

void updateBinaryStream(int columnIndex,
                        java.io.InputStream x,
                        int length)
                        throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

length -

Throws:

SQLException - if a database error happens

updateBinaryStream

void updateBinaryStream(java.lang.String columnName,
                        java.io.InputStream x,
                        int length)
                        throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

length -

Throws:

SQLException - if a database error happens

updateBlob

void updateBlob(int columnIndex,
                Blob x)
                throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateBlob

void updateBlob(java.lang.String columnName,
                Blob x)
                throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateBoolean

void updateBoolean(int columnIndex,
                   boolean x)
                   throws SQLException

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

Parameters:

columnIndex -

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateBoolean

void updateBoolean(java.lang.String columnName,
                   boolean x)
                   throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateByte

void updateByte(int columnIndex,
                byte x)
                throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateByte

void updateByte(java.lang.String columnName,
                byte x)
                throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateBytes

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

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateBytes

void updateBytes(java.lang.String columnName,
                 byte[] x)
                 throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateCharacterStream

void updateCharacterStream(int columnIndex,
                           java.io.Reader x,
                           int length)
                           throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

length - the length of data to write from the stream

Throws:

SQLException - if a database error happens

updateCharacterStream

void updateCharacterStream(java.lang.String columnName,
                           java.io.Reader reader,
                           int length)
                           throws SQLException

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

Parameters:

columnName - the name of the column to update

reader - the new value for the specified column

length - the length of data to write from the Reader

Throws:

SQLException - if a database error happens

updateClob

void updateClob(int columnIndex,
                Clob x)
                throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateClob

void updateClob(java.lang.String columnName,
                Clob x)
                throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateDate

void updateDate(int columnIndex,
                Date x)
                throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateDate

void updateDate(java.lang.String columnName,
                Date x)
                throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateDouble

void updateDouble(int columnIndex,
                  double x)
                  throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateDouble

void updateDouble(java.lang.String columnName,
                  double x)
                  throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateFloat

void updateFloat(int columnIndex,
                 float x)
                 throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateFloat

void updateFloat(java.lang.String columnName,
                 float x)
                 throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateInt

void updateInt(int columnIndex,
               int x)
               throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateInt

void updateInt(java.lang.String columnName,
               int x)
               throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateLong

void updateLong(int columnIndex,
                long x)
                throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateLong

void updateLong(java.lang.String columnName,
                long x)
                throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateNull

void updateNull(int columnIndex)
                throws SQLException

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

Parameters:

columnIndex - the index of the column to update

Throws:

SQLException - if a database error happens

updateNull

void updateNull(java.lang.String columnName)
                throws SQLException

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

Parameters:

columnName - the name of the column to update

Throws:

SQLException - if a database error happens

updateObject

void updateObject(int columnIndex,
                  java.lang.Object x)
                  throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateObject

void updateObject(int columnIndex,
                  java.lang.Object x,
                  int scale)
                  throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

scale - for the types java.sql.Types.DECIMAL or java.sql.Types.NUMERIC, this specifies the number of digits after the decimal point.

Throws:

SQLException - if a database error happens

updateObject

void updateObject(java.lang.String columnName,
                  java.lang.Object x)
                  throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateObject

void updateObject(java.lang.String columnName,
                  java.lang.Object x,
                  int scale)
                  throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

scale - for the types java.sql.Types.DECIMAL or java.sql.Types.NUMERIC, this specifies the number of digits after the decimal point.

Throws:

SQLException - if a database error happens

updateRef

void updateRef(int columnIndex,
               Ref x)
               throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateRef

void updateRef(java.lang.String columnName,
               Ref x)
               throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateRow

void updateRow()
               throws SQLException

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

Throws:

SQLException

updateShort

void updateShort(int columnIndex,
                 short x)
                 throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateShort

void updateShort(java.lang.String columnName,
                 short x)
                 throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateString

void updateString(int columnIndex,
                  java.lang.String x)
                  throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateString

void updateString(java.lang.String columnName,
                  java.lang.String x)
                  throws SQLException

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

Parameters:

columnName - the name of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateTime

void updateTime(int columnIndex,
                Time x)
                throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateTime

void updateTime(java.lang.String columnName,
                Time x)
                throws SQLException

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

Parameters:

columnName -

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateTimestamp

void updateTimestamp(int columnIndex,
                     Timestamp x)
                     throws SQLException

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

Parameters:

columnIndex - the index of the column to update

x - the new value for the specified column

Throws:

SQLException - if a database error happens

updateTimestamp

void updateTimestamp(java.lang.String columnName,
                     Timestamp x)
                     throws SQLException

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

Parameters:

columnName - the name of the column to update

x -

Throws:

SQLException - if a database error happens

wasNull

boolean wasNull()
                throws SQLException

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

Returns:

true if the last column contained SQL NULL, false otherwise

Throws:

SQLException - if a database error happens