ResultSet

Represents a result set. Column names are case-insensitive, quotes are not supported. The first column has the column index 1. Result sets are updatable when the result only contains columns from one table, and if it contains all columns of a unique index (primary key or other) of this table.

Methods
boolean absolute(int rowNumber)
Moves the current position to a specific row.
void afterLast()
Moves the current position to after the last row, that means after the end.
void beforeFirst()
Moves the current position to before the first row, that means resets the result set.
void cancelRowUpdates()
Cancels updating a row.
void clearWarnings()
Clears all warnings.
void close()
Closes the result set.
void deleteRow()
Deletes the current row.
int findColumn(String columnName)
Searches for a specific column in the result set.
boolean first()
Moves the current position to the first row.
Array getArray(int columnIndex)
Returns the value of the specified column as an Array.
Array getArray(String columnName)
Returns the value of the specified column as an Array.
InputStream getAsciiStream(int columnIndex)
Returns the value of the specified column as input stream.
InputStream getAsciiStream(String columnName)
Returns the value of the specified column as input stream.
BigDecimal getBigDecimal(int columnIndex)
Returns the value of the specified column as a String.
BigDecimal getBigDecimal(String columnName)
Returns the value of the specified column as a String.
BigDecimal getBigDecimal(String columnName, int scale)
Returns the value of the specified column as a String.
BigDecimal getBigDecimal(int columnIndex, int scale)
Returns the value of the specified column as a String.
InputStream getBinaryStream(int columnIndex)
Returns the value of the specified column as input stream.
InputStream getBinaryStream(String columnName)
Returns the value of the specified column as input stream.
Blob getBlob(int columnIndex)
Returns the value of the specified column as a Blob.
Blob getBlob(String columnName)
Returns the value of the specified column as a Blob.
boolean getBoolean(int columnIndex)
Returns the value of the specified column as a boolean.
boolean getBoolean(String columnName)
Returns the value of the specified column as a boolean.
byte getByte(int columnIndex)
Returns the value of the specified column as a byte.
byte getByte(String columnName)
Returns the value of the specified column as a byte.
byte[] getBytes(int columnIndex)
Returns the value of the specified column as a byte array.
byte[] getBytes(String columnName)
Returns the value of the specified column as a byte array.
Reader getCharacterStream(int columnIndex)
Returns the value of the specified column as input stream.
Reader getCharacterStream(String columnName)
Returns the value of the specified column as input stream.
Clob getClob(int columnIndex)
Returns the value of the specified column as a Clob.
Clob getClob(String columnName)
Returns the value of the specified column as a Clob.
int getConcurrency()
Gets the result set concurrency.
String getCursorName()
[Not supported] Gets the cursor name if it was defined.
Date getDate(int columnIndex)
Returns the value of the specified column as a java.sql.Date.
Date getDate(String columnName)
Returns the value of the specified column as a java.sql.Date.
Date getDate(int columnIndex, Calendar calendar)
Returns the value of the specified column as a java.sql.Date using a specified time zone.
Date getDate(String columnName, Calendar calendar)
Returns the value of the specified column as a java.sql.Date using a specified time zone.
double getDouble(int columnIndex)
Returns the value of the specified column as a double.
double getDouble(String columnName)
Returns the value of the specified column as a double.
int getFetchDirection()
Gets the fetch direction.
int getFetchSize()
Gets the number of rows suggested to read in one step.
float getFloat(int columnIndex)
Returns the value of the specified column as a float.
float getFloat(String columnName)
Returns the value of the specified column as a float.
int getHoldability()
Returns the current result set holdability.
int getInt(int columnIndex)
Returns the value of the specified column as an int.
int getInt(String columnName)
Returns the value of the specified column as an int.
long getLong(int columnIndex)
Returns the value of the specified column as a long.
long getLong(String columnName)
Returns the value of the specified column as a long.
ResultSetMetaData getMetaData()
Gets the meta data of this result set.
Reader getNCharacterStream(int columnIndex)
Returns the value of the specified column as input stream.
Reader getNCharacterStream(String columnName)
Returns the value of the specified column as input stream.
String getNString(int columnIndex)
Returns the value of the specified column as a String.
String getNString(String columnName)
Returns the value of the specified column as a String.
Object getObject(int columnIndex)
Returns a column value as a Java object.
Object getObject(String columnName)
Returns a column value as a Java object.
Object getObject(int columnIndex, Map map)
[Not supported] Gets a column as a object using the specified type mapping.
Object getObject(String columnName, Map map)
[Not supported] Gets a column as a object using the specified type mapping.
Ref getRef(int columnIndex)
[Not supported] Gets a column as a reference.
Ref getRef(String columnName)
[Not supported] Gets a column as a reference.
int getRow()
Gets the current row number.
short getShort(int columnIndex)
Returns the value of the specified column as a short.
short getShort(String columnName)
Returns the value of the specified column as a short.
Statement getStatement()
Returns the statement that created this object.
String getString(int columnIndex)
Returns the value of the specified column as a String.
String getString(String columnName)
Returns the value of the specified column as a String.
Time getTime(int columnIndex)
Returns the value of the specified column as a java.sql.Time.
Time getTime(String columnName)
Returns the value of the specified column as a java.sql.Time.
Time getTime(int columnIndex, Calendar calendar)
Returns the value of the specified column as a java.sql.Time using a specified time zone.
Time getTime(String columnName, Calendar calendar)
Returns the value of the specified column as a java.sql.Time using a specified time zone.
Timestamp getTimestamp(int columnIndex)
Returns the value of the specified column as a java.sql.Timestamp.
Timestamp getTimestamp(String columnName)
Returns the value of the specified column as a java.sql.Timestamp.
Timestamp getTimestamp(int columnIndex, Calendar calendar)
Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.
Timestamp getTimestamp(String columnName, Calendar calendar)
Returns the value of the specified column as a java.sql.Timestamp.
int getType()
Get the result set type.
URL getURL(int columnIndex)
[Not supported]
URL getURL(String columnName)
[Not supported]
InputStream getUnicodeStream(int columnIndex)
[Not supported]
InputStream getUnicodeStream(String columnName)
[Not supported]
SQLWarning getWarnings()
Gets the first warning reported by calls on this object.
void insertRow()
Inserts the current row.
boolean isAfterLast()
Checks if the current position is after the last row, that means next() was called and returned false.
boolean isBeforeFirst()
Checks if the current position is before the first row, that means next() was not called yet.
boolean isClosed()
Returns whether this result set is closed.
boolean isFirst()
Checks if the current position is row 1, that means next() was called once and returned true.
boolean isLast()
Checks if the current position is the last row, that means next() was called and did not yet returned false, but will in the next call.
boolean last()
Moves the current position to the last row.
void moveToCurrentRow()
Moves the current position to the current row.
void moveToInsertRow()
Moves the current position to the insert row.
boolean next()
Moves the cursor to the next row of the result set.
boolean previous()
Moves the cursor to the last row, or row before first row if the current position is the first row.
void refreshRow()
Re-reads the current row from the database.
boolean relative(int rowCount)
Moves the current position to a specific row relative to the current row.
boolean rowDeleted()
Detects if the row was deleted (by somebody else or the caller).
boolean rowInserted()
Detects if the row was inserted.
boolean rowUpdated()
Detects if the row was updated (by somebody else or the caller).
void setFetchDirection(int direction)
Sets (changes) the fetch direction for this result set.
void setFetchSize(int rowCount)
Sets the number of rows suggested to read in one step.
void updateArray(int columnIndex, Array x)
[Not supported]
void updateArray(String columnName, Array x)
[Not supported]
void updateAsciiStream(int columnIndex, InputStream x, int length)
Updates a column in the current or insert row.
void updateAsciiStream(int columnIndex, InputStream x)
Updates a column in the current or insert row.
void updateAsciiStream(int columnIndex, InputStream x, long length)
Updates a column in the current or insert row.
void updateAsciiStream(String columnName, InputStream x, int length)
Updates a column in the current or insert row.
void updateAsciiStream(String columnName, InputStream x)
Updates a column in the current or insert row.
void updateAsciiStream(String columnName, InputStream x, long length)
Updates a column in the current or insert row.
void updateBigDecimal(int columnIndex, BigDecimal x)
Updates a column in the current or insert row.
void updateBigDecimal(String columnName, BigDecimal x)
Updates a column in the current or insert row.
void updateBinaryStream(int columnIndex, InputStream x, int length)
Updates a column in the current or insert row.
void updateBinaryStream(int columnIndex, InputStream x)
Updates a column in the current or insert row.
void updateBinaryStream(int columnIndex, InputStream x, long length)
Updates a column in the current or insert row.
void updateBinaryStream(String columnName, InputStream x)
Updates a column in the current or insert row.
void updateBinaryStream(String columnName, InputStream x, int length)
Updates a column in the current or insert row.
void updateBinaryStream(String columnName, InputStream x, long length)
Updates a column in the current or insert row.
void updateBlob(int columnIndex, InputStream x)
Updates a column in the current or insert row.
void updateBlob(int columnIndex, InputStream x, long length)
Updates a column in the current or insert row.
void updateBlob(int columnIndex, Blob x)
Updates a column in the current or insert row.
void updateBlob(String columnName, Blob x)
Updates a column in the current or insert row.
void updateBlob(String columnName, InputStream x)
Updates a column in the current or insert row.
void updateBlob(String columnName, InputStream x, long length)
Updates a column in the current or insert row.
void updateBoolean(int columnIndex, boolean x)
Updates a column in the current or insert row.
void updateBoolean(String columnName, boolean x)
Updates a column in the current or insert row.
void updateByte(int columnIndex, byte x)
Updates a column in the current or insert row.
void updateByte(String columnName, byte x)
Updates a column in the current or insert row.
void updateBytes(int columnIndex, byte[] x)
Updates a column in the current or insert row.
void updateBytes(String columnName, byte[] x)
Updates a column in the current or insert row.
void updateCharacterStream(int columnIndex, Reader x, long length)
Updates a column in the current or insert row.
void updateCharacterStream(int columnIndex, Reader x, int length)
Updates a column in the current or insert row.
void updateCharacterStream(int columnIndex, Reader x)
Updates a column in the current or insert row.
void updateCharacterStream(String columnName, Reader x, int length)
Updates a column in the current or insert row.
void updateCharacterStream(String columnName, Reader x)
Updates a column in the current or insert row.
void updateCharacterStream(String columnName, Reader x, long length)
Updates a column in the current or insert row.
void updateClob(int columnIndex, Clob x)
Updates a column in the current or insert row.
void updateClob(int columnIndex, Reader x)
Updates a column in the current or insert row.
void updateClob(int columnIndex, Reader x, long length)
Updates a column in the current or insert row.
void updateClob(String columnName, Clob x)
Updates a column in the current or insert row.
void updateClob(String columnName, Reader x)
Updates a column in the current or insert row.
void updateClob(String columnName, Reader x, long length)
Updates a column in the current or insert row.
void updateDate(int columnIndex, Date x)
Updates a column in the current or insert row.
void updateDate(String columnName, Date x)
Updates a column in the current or insert row.
void updateDouble(int columnIndex, double x)
Updates a column in the current or insert row.
void updateDouble(String columnName, double x)
Updates a column in the current or insert row.
void updateFloat(int columnIndex, float x)
Updates a column in the current or insert row.
void updateFloat(String columnName, float x)
Updates a column in the current or insert row.
void updateInt(int columnIndex, int x)
Updates a column in the current or insert row.
void updateInt(String columnName, int x)
Updates a column in the current or insert row.
void updateLong(int columnIndex, long x)
Updates a column in the current or insert row.
void updateLong(String columnName, long x)
Updates a column in the current or insert row.
void updateNCharacterStream(int columnIndex, Reader x)
Updates a column in the current or insert row.
void updateNCharacterStream(int columnIndex, Reader x, long length)
Updates a column in the current or insert row.
void updateNCharacterStream(String columnName, Reader x)
Updates a column in the current or insert row.
void updateNCharacterStream(String columnName, Reader x, long length)
Updates a column in the current or insert row.
void updateNString(int columnIndex, String x)
Updates a column in the current or insert row.
void updateNString(String columnName, String x)
Updates a column in the current or insert row.
void updateNull(int columnIndex)
Updates a column in the current or insert row.
void updateNull(String columnName)
Updates a column in the current or insert row.
void updateObject(int columnIndex, Object x, int scale)
Updates a column in the current or insert row.
void updateObject(String columnName, Object x, int scale)
Updates a column in the current or insert row.
void updateObject(int columnIndex, Object x)
Updates a column in the current or insert row.
void updateObject(String columnName, Object x)
Updates a column in the current or insert row.
void updateRef(int columnIndex, Ref x)
[Not supported]
void updateRef(String columnName, Ref x)
[Not supported]
void updateRow()
Updates the current row.
void updateShort(int columnIndex, short x)
Updates a column in the current or insert row.
void updateShort(String columnName, short x)
Updates a column in the current or insert row.
void updateString(int columnIndex, String x)
Updates a column in the current or insert row.
void updateString(String columnName, String x)
Updates a column in the current or insert row.
void updateTime(int columnIndex, Time x)
Updates a column in the current or insert row.
void updateTime(String columnName, Time x)
Updates a column in the current or insert row.
void updateTimestamp(int columnIndex, Timestamp x)
Updates a column in the current or insert row.
void updateTimestamp(String columnName, Timestamp x)
Updates a column in the current or insert row.
boolean wasNull()
Returns whether the last column accessed was a null value.

boolean absolute(int rowNumber) throws SQLException

Moves the current position to a specific row.

Parameters:
rowNumber - the row number. 0 is not allowed, 1 means the first row, 2 the second. -1 means the last row, -2 the row before the last row. If the value is too large, the position is moved after the last row, if if the value is too small it is moved before the first row.
Returns:
true if there is a row available, false if not
Throws:
SQLException - if the result set is closed

void afterLast() throws SQLException

Moves the current position to after the last row, that means after the end.

Throws:
SQLException - if the result set is closed

void beforeFirst() throws SQLException

Moves the current position to before the first row, that means resets the result set.

Throws:
SQLException - if the result set is closed

void cancelRowUpdates() throws SQLException

Cancels updating a row.

Throws:
SQLException - if the result set is closed or if the current row is the insert row

void clearWarnings() throws SQLException

Clears all warnings.

void close() throws SQLException

Closes the result set.

void deleteRow() throws SQLException

Deletes the current row.

Throws:
SQLException - if the result set is closed or if the current row is the insert row or if not on a valid row

int findColumn(String columnName) throws SQLException

Searches for a specific column in the result set. A case-insensitive search is made.

Parameters:
columnName - the name of the column label
Returns:
the column index (1,2,...)
Throws:
SQLException - if the column is not found or if the result set is closed

boolean first() throws SQLException

Moves the current position to the first row. This is the same as calling beforeFirst() followed by next().

Returns:
true if there is a row available, false if not
Throws:
SQLException - if the result set is closed

Array getArray(int columnIndex) throws SQLException

Returns the value of the specified column as an Array.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Array getArray(String columnName) throws SQLException

Returns the value of the specified column as an Array.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

InputStream getAsciiStream(int columnIndex) throws SQLException

Returns the value of the specified column as input stream.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

InputStream getAsciiStream(String columnName) throws SQLException

Returns the value of the specified column as input stream.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

BigDecimal getBigDecimal(int columnIndex) throws SQLException

Returns the value of the specified column as a String.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

BigDecimal getBigDecimal(String columnName) throws SQLException

Returns the value of the specified column as a String.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

BigDecimal getBigDecimal(String columnName, int scale) throws SQLException

Returns the value of the specified column as a String.

Parameters:
columnName -
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException

Returns the value of the specified column as a String.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

InputStream getBinaryStream(int columnIndex) throws SQLException

Returns the value of the specified column as input stream.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

InputStream getBinaryStream(String columnName) throws SQLException

Returns the value of the specified column as input stream.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Blob getBlob(int columnIndex) throws SQLException

Returns the value of the specified column as a Blob.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Blob getBlob(String columnName) throws SQLException

Returns the value of the specified column as a Blob.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

boolean getBoolean(int columnIndex) throws SQLException

Returns the value of the specified column as a boolean.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

boolean getBoolean(String columnName) throws SQLException

Returns the value of the specified column as a boolean.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

byte getByte(int columnIndex) throws SQLException

Returns the value of the specified column as a byte.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

byte getByte(String columnName) throws SQLException

Returns the value of the specified column as a byte.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

byte[] getBytes(int columnIndex) throws SQLException

Returns the value of the specified column as a byte array.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

byte[] getBytes(String columnName) throws SQLException

Returns the value of the specified column as a byte array.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Reader getCharacterStream(int columnIndex) throws SQLException

Returns the value of the specified column as input stream.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Reader getCharacterStream(String columnName) throws SQLException

Returns the value of the specified column as input stream.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Clob getClob(int columnIndex) throws SQLException

Returns the value of the specified column as a Clob.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Clob getClob(String columnName) throws SQLException

Returns the value of the specified column as a Clob.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

int getConcurrency() throws SQLException

Gets the result set concurrency.

Returns:
ResultSet.CONCUR_UPDATABLE

String getCursorName() throws SQLException

[Not supported] Gets the cursor name if it was defined. This feature is superseded by updateX methods. This method throws a SQLException because cursor names are not supported.

Date getDate(int columnIndex) throws SQLException

Returns the value of the specified column as a java.sql.Date.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Date getDate(String columnName) throws SQLException

Returns the value of the specified column as a java.sql.Date.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Date getDate(int columnIndex, Calendar calendar) throws SQLException

Returns the value of the specified column as a java.sql.Date using a specified time zone.

Parameters:
columnIndex - (1,2,...)
calendar - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Date getDate(String columnName, Calendar calendar) throws SQLException

Returns the value of the specified column as a java.sql.Date using a specified time zone.

Parameters:
columnName - the name of the column label
calendar - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

double getDouble(int columnIndex) throws SQLException

Returns the value of the specified column as a double.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

double getDouble(String columnName) throws SQLException

Returns the value of the specified column as a double.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

int getFetchDirection() throws SQLException

Gets the fetch direction.

Returns:
the direction: FETCH_FORWARD

int getFetchSize() throws SQLException

Gets the number of rows suggested to read in one step.

Returns:
the current fetch size

float getFloat(int columnIndex) throws SQLException

Returns the value of the specified column as a float.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

float getFloat(String columnName) throws SQLException

Returns the value of the specified column as a float.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

int getHoldability() throws SQLException

Returns the current result set holdability.

Returns:
the holdability
Throws:
SQLException - if the connection is closed

int getInt(int columnIndex) throws SQLException

Returns the value of the specified column as an int.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

int getInt(String columnName) throws SQLException

Returns the value of the specified column as an int.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

long getLong(int columnIndex) throws SQLException

Returns the value of the specified column as a long.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

long getLong(String columnName) throws SQLException

Returns the value of the specified column as a long.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

ResultSetMetaData getMetaData() throws SQLException

Gets the meta data of this result set.

Returns:
the meta data

Reader getNCharacterStream(int columnIndex) throws SQLException

Returns the value of the specified column as input stream.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Reader getNCharacterStream(String columnName) throws SQLException

Returns the value of the specified column as input stream.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

String getNString(int columnIndex) throws SQLException

Returns the value of the specified column as a String.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

String getNString(String columnName) throws SQLException

Returns the value of the specified column as a String.

Parameters:
columnName -
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Object getObject(int columnIndex) throws SQLException

Returns a column value as a Java object. For BINARY data, the data is de-serialized into a Java Object.

Parameters:
columnIndex - (1,2,...)
Returns:
the value or null
Throws:
SQLException - if the column is not found or if the result set is closed

Object getObject(String columnName) throws SQLException

Returns a column value as a Java object. For BINARY data, the data is de-serialized into a Java Object.

Parameters:
columnName - the name of the column label
Returns:
the value or null
Throws:
SQLException - if the column is not found or if the result set is closed

Object getObject(int columnIndex, Map map) throws SQLException

[Not supported] Gets a column as a object using the specified type mapping.

Object getObject(String columnName, Map map) throws SQLException

[Not supported] Gets a column as a object using the specified type mapping.

Ref getRef(int columnIndex) throws SQLException

[Not supported] Gets a column as a reference.

Ref getRef(String columnName) throws SQLException

[Not supported] Gets a column as a reference.

int getRow() throws SQLException

Gets the current row number. The first row is row 1, the second 2 and so on. This method returns 0 before the first and after the last row.

Returns:
the row number

short getShort(int columnIndex) throws SQLException

Returns the value of the specified column as a short.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

short getShort(String columnName) throws SQLException

Returns the value of the specified column as a short.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Statement getStatement() throws SQLException

Returns the statement that created this object.

Returns:
the statement or prepared statement, or null if created by a DatabaseMetaData call.

String getString(int columnIndex) throws SQLException

Returns the value of the specified column as a String.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

String getString(String columnName) throws SQLException

Returns the value of the specified column as a String.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Time getTime(int columnIndex) throws SQLException

Returns the value of the specified column as a java.sql.Time.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Time getTime(String columnName) throws SQLException

Returns the value of the specified column as a java.sql.Time.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Time getTime(int columnIndex, Calendar calendar) throws SQLException

Returns the value of the specified column as a java.sql.Time using a specified time zone.

Parameters:
columnIndex - (1,2,...)
calendar - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Time getTime(String columnName, Calendar calendar) throws SQLException

Returns the value of the specified column as a java.sql.Time using a specified time zone.

Parameters:
columnName - the name of the column label
calendar - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Timestamp getTimestamp(int columnIndex) throws SQLException

Returns the value of the specified column as a java.sql.Timestamp.

Parameters:
columnIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Timestamp getTimestamp(String columnName) throws SQLException

Returns the value of the specified column as a java.sql.Timestamp.

Parameters:
columnName - the name of the column label
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Timestamp getTimestamp(int columnIndex, Calendar calendar) throws SQLException

Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.

Parameters:
columnIndex - (1,2,...)
calendar - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

Timestamp getTimestamp(String columnName, Calendar calendar) throws SQLException

Returns the value of the specified column as a java.sql.Timestamp.

Parameters:
columnName - the name of the column label
calendar - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if the result set is closed

int getType() throws SQLException

Get the result set type.

Returns:
the result set type (TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE)
Throws:
SQLException - if the column is not found or if the result set is closed

URL getURL(int columnIndex) throws SQLException

[Not supported]

URL getURL(String columnName) throws SQLException

[Not supported]

InputStream getUnicodeStream(int columnIndex) throws SQLException

[Not supported]

InputStream getUnicodeStream(String columnName) throws SQLException

[Not supported]

SQLWarning getWarnings() throws SQLException

Gets the first warning reported by calls on this object.

Returns:
null

void insertRow() throws SQLException

Inserts the current row. The current position must be the insert row.

Throws:
SQLException - if the result set is closed or if not on the insert row

boolean isAfterLast() throws SQLException

Checks if the current position is after the last row, that means next() was called and returned false.

Returns:
if the current position is after the last row
Throws:
SQLException - if the result set is closed

boolean isBeforeFirst() throws SQLException

Checks if the current position is before the first row, that means next() was not called yet.

Returns:
if the current position is before the first row
Throws:
SQLException - if the result set is closed

boolean isClosed() throws SQLException

Returns whether this result set is closed.

Returns:
true if the result set is closed

boolean isFirst() throws SQLException

Checks if the current position is row 1, that means next() was called once and returned true.

Returns:
if the current position is the first row
Throws:
SQLException - if the result set is closed

boolean isLast() throws SQLException

Checks if the current position is the last row, that means next() was called and did not yet returned false, but will in the next call.

Returns:
if the current position is the last row
Throws:
SQLException - if the result set is closed

boolean last() throws SQLException

Moves the current position to the last row.

Returns:
true if there is a row available, false if not
Throws:
SQLException - if the result set is closed

void moveToCurrentRow() throws SQLException

Moves the current position to the current row.

Throws:
SQLException - if the result set is closed

void moveToInsertRow() throws SQLException

Moves the current position to the insert row. The current row is remembered.

Throws:
SQLException - if the result set is closed

boolean next() throws SQLException

Moves the cursor to the next row of the result set.

Returns:
true if successful, false if there are no more rows

boolean previous() throws SQLException

Moves the cursor to the last row, or row before first row if the current position is the first row.

Returns:
true if there is a row available, false if not
Throws:
SQLException - if the result set is closed

void refreshRow() throws SQLException

Re-reads the current row from the database.

Throws:
SQLException - if the result set is closed or if the current row is the insert row or if the row has been deleted or if not on a valid row

boolean relative(int rowCount) throws SQLException

Moves the current position to a specific row relative to the current row.

Parameters:
rowCount - 0 means don't do anything, 1 is the next row, -1 the previous. If the value is too large, the position is moved after the last row, if if the value is too small it is moved before the first row.
Returns:
true if there is a row available, false if not
Throws:
SQLException - if the result set is closed

boolean rowDeleted() throws SQLException

Detects if the row was deleted (by somebody else or the caller).

Returns:
false because this driver does not detect this

boolean rowInserted() throws SQLException

Detects if the row was inserted.

Returns:
false because this driver does not detect this

boolean rowUpdated() throws SQLException

Detects if the row was updated (by somebody else or the caller).

Returns:
false because this driver does not detect this

void setFetchDirection(int direction) throws SQLException

Sets (changes) the fetch direction for this result set. This method should only be called for scrollable result sets, otherwise it will throw an exception (no matter what direction is used).

Parameters:
direction - the new fetch direction
Throws:
SQLException - Unsupported Feature if the method is called for a forward-only result set

void setFetchSize(int rowCount) throws SQLException

Sets the number of rows suggested to read in one step. This value cannot be higher than the maximum rows (setMaxRows) set by the statement or prepared statement, otherwise an exception is throws.

Parameters:
rowCount - the number of rows

void updateArray(int columnIndex, Array x) throws SQLException

[Not supported]

void updateArray(String columnName, Array x) throws SQLException

[Not supported]

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

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateAsciiStream(int columnIndex, InputStream x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateAsciiStream(String columnName, InputStream x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateAsciiStream(String columnName, InputStream x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateBigDecimal(String columnName, BigDecimal x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

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

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateBinaryStream(int columnIndex, InputStream x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateBinaryStream(String columnName, InputStream x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateBinaryStream(String columnName, InputStream x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateBlob(int columnIndex, InputStream x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateBlob(int columnIndex, InputStream x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
length - the length
Throws:
SQLException - if the result set is closed

void updateBlob(int columnIndex, Blob x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateBlob(String columnName, Blob x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateBlob(String columnName, InputStream x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateBlob(String columnName, InputStream x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
length - the length
Throws:
SQLException - if the result set is closed

void updateBoolean(int columnIndex, boolean x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateBoolean(String columnName, boolean x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if result set is closed

void updateByte(int columnIndex, byte x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateByte(String columnName, byte x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

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

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

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

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

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

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateCharacterStream(int columnIndex, Reader x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateCharacterStream(String columnName, Reader x, int length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateCharacterStream(String columnName, Reader x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateCharacterStream(String columnName, Reader x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateClob(int columnIndex, Clob x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateClob(int columnIndex, Reader x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateClob(int columnIndex, Reader x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
length - the length
Throws:
SQLException - if the result set is closed

void updateClob(String columnName, Clob x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateClob(String columnName, Reader x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateClob(String columnName, Reader x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
length - the length
Throws:
SQLException - if the result set is closed

void updateDate(int columnIndex, Date x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateDate(String columnName, Date x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateDouble(int columnIndex, double x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateDouble(String columnName, double x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateFloat(int columnIndex, float x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateFloat(String columnName, float x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateInt(int columnIndex, int x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateInt(String columnName, int x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateLong(int columnIndex, long x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateLong(String columnName, long x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateNCharacterStream(int columnIndex, Reader x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateNCharacterStream(String columnName, Reader x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateNCharacterStream(String columnName, Reader x, long length) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
length - the number of characters
Throws:
SQLException - if the result set is closed

void updateNString(int columnIndex, String x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateNString(String columnName, String x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateNull(int columnIndex) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
Throws:
SQLException - if the result set is closed

void updateNull(String columnName) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
Throws:
SQLException - if the result set is closed

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

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
scale - is ignored
Throws:
SQLException - if the result set is closed

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

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
scale - is ignored
Throws:
SQLException - if the result set is closed

void updateObject(int columnIndex, Object x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateObject(String columnName, Object x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateRef(int columnIndex, Ref x) throws SQLException

[Not supported]

void updateRef(String columnName, Ref x) throws SQLException

[Not supported]

void updateRow() throws SQLException

Updates the current row.

Throws:
SQLException - if the result set is closed or if the current row is the insert row or if not on a valid row

void updateShort(int columnIndex, short x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateShort(String columnName, short x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateString(int columnIndex, String x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateString(String columnName, String x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateTime(int columnIndex, Time x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateTime(String columnName, Time x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

void updateTimestamp(int columnIndex, Timestamp x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnIndex - (1,2,...)
x - the value
Throws:
SQLException - if the result set is closed

void updateTimestamp(String columnName, Timestamp x) throws SQLException

Updates a column in the current or insert row.

Parameters:
columnName - the name of the column label
x - the value
Throws:
SQLException - if the result set is closed

boolean wasNull() throws SQLException

Returns whether the last column accessed was a null value.

Returns:
true if the last column accessed was a null value