ResultSetRepresents 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.
boolean absolute(int rowNumber) throws SQLExceptionMoves 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 SQLExceptionMoves the current position to after the last row, that means after the end.Throws:
SQLException - if the result set is closed
void beforeFirst() throws SQLExceptionMoves 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 SQLExceptionCancels updating a row.Throws:
SQLException - if the result set is closed or if the current row is
the insert row
void clearWarnings() throws SQLExceptionClears all warnings.void close() throws SQLExceptionCloses the result set.void deleteRow() throws SQLExceptionDeletes 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 SQLExceptionSearches 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 SQLExceptionMoves 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionGets 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionGets the fetch direction.Returns:
the direction: FETCH_FORWARD
int getFetchSize() throws SQLExceptionGets the number of rows suggested to read in one step.Returns:
the current fetch size
float getFloat(int columnIndex) throws SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns the current result set holdability.Returns:
the holdability
Throws:
SQLException - if the connection is closed
int getInt(int columnIndex) throws SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionGets the meta data of this result set.Returns:
the meta data
Reader getNCharacterStream(int columnIndex) throws SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionGets 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionReturns 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 SQLExceptionGet 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 SQLExceptionGets the first warning reported by calls on this object.Returns:
null
void insertRow() throws SQLExceptionInserts 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 SQLExceptionChecks 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 SQLExceptionChecks 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 SQLExceptionReturns whether this result set is closed.Returns:
true if the result set is closed
boolean isFirst() throws SQLExceptionChecks 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 SQLExceptionChecks 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 SQLExceptionMoves 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 SQLExceptionMoves the current position to the current row.Throws:
SQLException - if the result set is closed
void moveToInsertRow() throws SQLExceptionMoves the current position to the insert row. The current row is remembered.Throws:
SQLException - if the result set is closed
boolean next() throws SQLExceptionMoves the cursor to the next row of the result set.Returns:
true if successful, false if there are no more rows
boolean previous() throws SQLExceptionMoves 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 SQLExceptionRe-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 SQLExceptionMoves 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 SQLExceptionDetects if the row was deleted (by somebody else or the caller).Returns:
false because this driver does not detect this
boolean rowInserted() throws SQLExceptionDetects if the row was inserted.Returns:
false because this driver does not detect this
boolean rowUpdated() throws SQLExceptionDetects 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 SQLExceptionSets (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 SQLExceptionSets 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionUpdates 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 SQLExceptionReturns whether the last column accessed was a null value.Returns:
true if the last column accessed was a null value
|