public interface ResultSet
Statement
.
This class models a cursor, which can be stepped through one row at a time. Methods are provided for accessing columns by column name or by index.
Note that a result set is invalidated if the statement that returned it is closed.
Modifier and Type | Field and Description |
---|---|
static int |
CLOSE_CURSORS_AT_COMMIT |
static int |
CONCUR_READ_ONLY
The concurrency mode of for the result set may not be modified.
|
static int |
CONCUR_UPDATABLE
The concurrency mode of for the result set may be modified.
|
static int |
FETCH_FORWARD
The rows will be processed in order from first to last.
|
static int |
FETCH_REVERSE
The rows will be processed in order from last to first.
|
static int |
FETCH_UNKNOWN
The rows will be processed in an unknown order
|
static int |
HOLD_CURSORS_OVER_COMMIT |
static int |
TYPE_FORWARD_ONLY
This type of result set may only step forward through the rows returned.
|
static int |
TYPE_SCROLL_INSENSITIVE
This type of result set is scrollable and is not sensitive to changes
made by other statements.
|
static int |
TYPE_SCROLL_SENSITIVE
This type of result set is scrollable and is also sensitive to changes
made by other statements.
|
Modifier and Type | Method and Description |
---|---|
boolean |
absolute(int row)
This method positions the result set to the specified absolute row.
|
void |
afterLast()
This method repositions the cursor to after the last row in the result
set.
|
void |
beforeFirst()
This method repositions the cursor to before the first row in the
result set.
|
void |
cancelRowUpdates()
This method cancels any changes that have been made to a row.
|
void |
clearWarnings()
This method clears all warnings associated with this result set.
|
void |
close()
This method closes the result set and frees any associated resources.
|
void |
deleteRow()
This method deletes the current row in the database.
|
int |
findColumn(String columnName)
This method returns the column index of the specified named column.
|
boolean |
first()
This method repositions the cursor on the first row in the
result set.
|
Array |
getArray(int columnIndex)
This method returns the specified column value as an
Array . |
Array |
getArray(String columnName)
This method returns the specified column value as an
Array . |
InputStream |
getAsciiStream(int columnIndex)
This method returns the value of the specified column as an ASCII
stream.
|
InputStream |
getAsciiStream(String columnName)
This method returns the value of the specified column as an ASCII
stream.
|
BigDecimal |
getBigDecimal(int columnIndex)
This method returns the value of the specified column as a Java
BigDecimal . |
BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Deprecated.
|
BigDecimal |
getBigDecimal(String columnName)
This method returns the value of the specified column as a Java
BigDecimal . |
BigDecimal |
getBigDecimal(String columnName,
int scale)
Deprecated.
|
InputStream |
getBinaryStream(int columnIndex)
This method returns the value of the specified column as a raw byte
stream.
|
InputStream |
getBinaryStream(String columnName)
This method returns the value of the specified column as a raw byte
stream.
|
Blob |
getBlob(int columnIndex)
This method returns the specified column value as a BLOB.
|
Blob |
getBlob(String columnName)
This method returns the specified column value as a BLOB.
|
boolean |
getBoolean(int columnIndex)
This method returns the value of the specified column as a Java
boolean . |
boolean |
getBoolean(String columnName)
This method returns the value of the specified column as a Java
boolean . |
byte |
getByte(int columnIndex)
This method returns the value of the specified column as a Java
byte . |
byte |
getByte(String columnName)
This method returns the value of the specified column as a Java
byte . |
byte[] |
getBytes(int columnIndex)
This method returns the value of the specified column as a Java
byte array.
|
byte[] |
getBytes(String columnName)
This method returns the value of the specified column as a Java
byte array.
|
Reader |
getCharacterStream(int columnIndex)
This method returns the value of the specified column as a character
stream.
|
Reader |
getCharacterStream(String columnName)
This method returns the value of the specified column as a character
stream.
|
Clob |
getClob(int columnIndex)
This method returns the specified column value as a CLOB.
|
Clob |
getClob(String columnName)
This method returns the specified column value as a CLOB.
|
int |
getConcurrency()
This method returns the concurrency type of this result set.
|
String |
getCursorName()
This method returns the name of the database cursor used by this
result set.
|
Date |
getDate(int columnIndex)
This method returns the value of the specified column as a Java
java.sql.Date . |
Date |
getDate(int columnIndex,
Calendar cal)
This method returns the specified column value as a
java.sql.Date . |
Date |
getDate(String columnName)
This method returns the value of the specified column as a Java
java.sql.Date . |
Date |
getDate(String columnName,
Calendar cal)
This method returns the specified column value as a
java.sql.Date . |
double |
getDouble(int columnIndex)
This method returns the value of the specified column as a Java
double . |
double |
getDouble(String columnName)
This method returns the value of the specified column as a Java
double . |
int |
getFetchDirection()
This method returns the current fetch direction for this result set.
|
int |
getFetchSize()
This method returns the current number of rows that will be fetched
from the database at a time.
|
float |
getFloat(int columnIndex)
This method returns the value of the specified column as a Java
float . |
float |
getFloat(String columnName)
This method returns the value of the specified column as a Java
float . |
int |
getInt(int columnIndex)
This method returns the value of the specified column as a Java
int . |
int |
getInt(String columnName)
This method returns the value of the specified column as a Java
int . |
long |
getLong(int columnIndex)
This method returns the value of the specified column as a Java
long . |
long |
getLong(String columnName)
This method returns the value of the specified column as a Java
long . |
ResultSetMetaData |
getMetaData()
This method returns data about the columns returned as part of the
result set as a
ResultSetMetaData instance. |
Object |
getObject(int columnIndex)
This method returns the value of the specified column as a Java
Object . |
Object |
getObject(int columnIndex,
Map<String,Class<?>> map)
This method returns the value of the specified column as a Java
Object using the specified SQL type to Java type map. |
Object |
getObject(String columnName)
This method returns the value of the specified column as a Java
Object . |
Object |
getObject(String columnName,
Map<String,Class<?>> map)
This method returns the value of the specified column as a Java
Object using the specified SQL type to Java type map. |
Ref |
getRef(int columnIndex)
This method returns a
Ref for the specified column which
represents the structured type for the column. |
Ref |
getRef(String columnName)
This method returns a
Ref for the specified column which
represents the structured type for the column. |
int |
getRow()
This method returns the current row number in the cursor.
|
short |
getShort(int columnIndex)
This method returns the value of the specified column as a Java
short . |
short |
getShort(String columnName)
This method returns the value of the specified column as a Java
short . |
Statement |
getStatement()
This method returns a the
Statement that was used to
produce this result set. |
String |
getString(int columnIndex)
This method returns the value of the specified column as a Java
String . |
String |
getString(String columnName)
This method returns the value of the specified column as a Java
String . |
Time |
getTime(int columnIndex)
This method returns the value of the specified column as a Java
java.sql.Time . |
Time |
getTime(int columnIndex,
Calendar cal)
This method returns the specified column value as a
java.sql.Time . |
Time |
getTime(String columnName)
This method returns the value of the specified column as a Java
java.sql.Time . |
Time |
getTime(String columnName,
Calendar cal)
This method returns the specified column value as a
java.sql.Time . |
Timestamp |
getTimestamp(int columnIndex)
This method returns the value of the specified column as a Java
java.sql.Timestamp . |
Timestamp |
getTimestamp(int columnIndex,
Calendar cal)
This method returns the specified column value as a
java.sql.Timestamp . |
Timestamp |
getTimestamp(String columnName)
This method returns the value of the specified column as a Java
java.sql.Timestamp . |
Timestamp |
getTimestamp(String columnName,
Calendar cal)
This method returns the specified column value as a
java.sql.Timestamp . |
int |
getType()
This method returns the result set type of this result set.
|
InputStream |
getUnicodeStream(int columnIndex)
Deprecated.
Use getCharacterStream instead.
|
InputStream |
getUnicodeStream(String columnName)
Deprecated.
Use getCharacterStream instead.
|
URL |
getURL(int columnIndex)
This method returns the specified column value as a
java.net.URL . |
URL |
getURL(String columnName)
This method returns the specified column value as a
java.net.URL . |
SQLWarning |
getWarnings()
This method returns the first SQL warning associated with this result
set.
|
void |
insertRow()
This method inserts the current row into the database.
|
boolean |
isAfterLast()
This method tests whether or not the cursor is after the last row
in the result set.
|
boolean |
isBeforeFirst()
This method tests whether or not the cursor is before the first row
in the result set.
|
boolean |
isFirst()
This method tests whether or not the cursor is positioned on the first
row in the result set.
|
boolean |
isLast()
This method tests whether or not the cursor is on the last row
in the result set.
|
boolean |
last()
This method repositions the cursor on the last row in the result
set.
|
void |
moveToCurrentRow()
This method moves the result set position from the insert row back to
the current row that was selected prior to moving to the insert row.
|
void |
moveToInsertRow()
This method positions the result set to the "insert row", which allows
a new row to be inserted into the database from the result set.
|
boolean |
next()
This method advances to the next row in the result set.
|
boolean |
previous()
This method moves the current position to the previous row in the
result set.
|
void |
refreshRow()
This method refreshes the contents of the current row from the database.
|
boolean |
relative(int rows)
This method moves the result set position relative to the current row.
|
boolean |
rowDeleted()
This method tests whether or not the current row in the result set
has been deleted.
|
boolean |
rowInserted()
This method tests whether or not the current row in the result set
has been inserted.
|
boolean |
rowUpdated()
This method tests whether or not the current row in the result set
has been updated.
|
void |
setFetchDirection(int direction)
This method provides a hint to the driver about which direction the
result set will be processed in.
|
void |
setFetchSize(int rows)
This method provides a hint to the driver about how many rows at a
time it should fetch from the database.
|
void |
updateArray(int columnIndex,
Array value)
This method updates the specified column to have a
java.sqlArray value. |
void |
updateArray(String columnName,
Array value)
This method updates the specified column to have a
java.sqlArray value. |
void |
updateAsciiStream(int columnIndex,
InputStream stream,
int count)
This method updates the specified column from an ASCII text stream.
|
void |
updateAsciiStream(String columnName,
InputStream stream,
int count)
This method updates the specified column from an ASCII text stream.
|
void |
updateBigDecimal(int columnIndex,
BigDecimal value)
This method updates the specified column to have a BigDecimal value.
|
void |
updateBigDecimal(String columnName,
BigDecimal value)
This method updates the specified column to have a BigDecimal value.
|
void |
updateBinaryStream(int columnIndex,
InputStream stream,
int count)
This method updates the specified column from a binary stream.
|
void |
updateBinaryStream(String columnName,
InputStream stream,
int count)
This method updates the specified column from a binary stream.
|
void |
updateBlob(int columnIndex,
Blob value)
This method updates the specified column to have a
java.sql.Blob value. |
void |
updateBlob(String columnName,
Blob value)
This method updates the specified column to have a
java.sql.Blob value. |
void |
updateBoolean(int columnIndex,
boolean value)
This method updates the specified column to have a boolean value.
|
void |
updateBoolean(String columnName,
boolean value)
This method updates the specified column to have a boolean value.
|
void |
updateByte(int columnIndex,
byte value)
This method updates the specified column to have a byte value.
|
void |
updateByte(String columnName,
byte value)
This method updates the specified column to have a byte value.
|
void |
updateBytes(int columnIndex,
byte[] value)
This method updates the specified column to have a byte array value.
|
void |
updateBytes(String columnName,
byte[] value)
This method updates the specified column to have a byte array value.
|
void |
updateCharacterStream(int columnIndex,
Reader reader,
int count)
This method updates the specified column from a character stream.
|
void |
updateCharacterStream(String columnName,
Reader reader,
int count)
This method updates the specified column from a character stream.
|
void |
updateClob(int columnIndex,
Clob value)
This method updates the specified column to have a
java.sql.Clob value. |
void |
updateClob(String columnName,
Clob value)
This method updates the specified column to have a
java.sql.Clob value. |
void |
updateDate(int columnIndex,
Date value)
This method updates the specified column to have a java.sql.Date value.
|
void |
updateDate(String columnName,
Date value)
This method updates the specified column to have a java.sql.Date value.
|
void |
updateDouble(int columnIndex,
double value)
This method updates the specified column to have a double value.
|
void |
updateDouble(String columnName,
double value)
This method updates the specified column to have a double value.
|
void |
updateFloat(int columnIndex,
float value)
This method updates the specified column to have a float value.
|
void |
updateFloat(String columnName,
float value)
This method updates the specified column to have a float value.
|
void |
updateInt(int columnIndex,
int value)
This method updates the specified column to have an int value.
|
void |
updateInt(String columnName,
int value)
This method updates the specified column to have an int value.
|
void |
updateLong(int columnIndex,
long value)
This method updates the specified column to have a long value.
|
void |
updateLong(String columnName,
long value)
This method updates the specified column to have a long value.
|
void |
updateNull(int columnIndex)
This method updates the specified column to have a NULL value.
|
void |
updateNull(String columnName)
This method updates the specified column to have a NULL value.
|
void |
updateObject(int columnIndex,
Object value)
This method updates the specified column to have an Object value.
|
void |
updateObject(int columnIndex,
Object value,
int scale)
This method updates the specified column to have an Object value.
|
void |
updateObject(String columnName,
Object value)
This method updates the specified column to have an Object value.
|
void |
updateObject(String columnName,
Object value,
int scale)
This method updates the specified column to have an Object value.
|
void |
updateRef(int columnIndex,
Ref value)
This method updates the specified column to have a
java.sql.Ref value. |
void |
updateRef(String columnName,
Ref value)
This method updates the specified column to have a
java.sql.Ref value. |
void |
updateRow()
This method updates the current row in the database.
|
void |
updateShort(int columnIndex,
short value)
This method updates the specified column to have a short value.
|
void |
updateShort(String columnName,
short value)
This method updates the specified column to have a short value.
|
void |
updateString(int columnIndex,
String value)
This method updates the specified column to have a String value.
|
void |
updateString(String columnName,
String value)
This method updates the specified column to have a String value.
|
void |
updateTime(int columnIndex,
Time value)
This method updates the specified column to have a java.sql.Time value.
|
void |
updateTime(String columnName,
Time value)
This method updates the specified column to have a java.sql.Time value.
|
void |
updateTimestamp(int columnIndex,
Timestamp value)
This method updates the specified column to have a java.sql.Timestamp value.
|
void |
updateTimestamp(String columnName,
Timestamp value)
This method updates the specified column to have a java.sql.Timestamp value.
|
boolean |
wasNull()
This method tests whether the value of the last column that was fetched
was actually a SQL NULL value.
|
static final int FETCH_FORWARD
static final int FETCH_REVERSE
static final int FETCH_UNKNOWN
static final int TYPE_FORWARD_ONLY
static final int TYPE_SCROLL_INSENSITIVE
static final int TYPE_SCROLL_SENSITIVE
static final int CONCUR_READ_ONLY
static final int CONCUR_UPDATABLE
static final int HOLD_CURSORS_OVER_COMMIT
static final int CLOSE_CURSORS_AT_COMMIT
boolean next() throws SQLException
true
if the next row exists, false
otherwise.SQLException
- If an error occurs.void close() throws SQLException
SQLException
- If an error occurs.boolean wasNull() throws SQLException
true
if the last column fetched was a NULL,
false
otherwise.SQLException
- If an error occurs.String getString(int columnIndex) throws SQLException
String
.columnIndex
- The index of the column to return.String
.SQLException
- If an error occurs.boolean getBoolean(int columnIndex) throws SQLException
boolean
.columnIndex
- The index of the column to return.boolean
.SQLException
- If an error occurs.byte getByte(int columnIndex) throws SQLException
byte
.columnIndex
- The index of the column to return.byte
.SQLException
- If an error occurs.short getShort(int columnIndex) throws SQLException
short
.columnIndex
- The index of the column to return.short
.SQLException
- If an error occurs.int getInt(int columnIndex) throws SQLException
int
.columnIndex
- The index of the column to return.int
.SQLException
- If an error occurs.long getLong(int columnIndex) throws SQLException
long
.columnIndex
- The index of the column to return.long
.SQLException
- If an error occurs.float getFloat(int columnIndex) throws SQLException
float
.columnIndex
- The index of the column to return.float
.SQLException
- If an error occurs.double getDouble(int columnIndex) throws SQLException
double
.columnIndex
- The index of the column to return.double
.SQLException
- If an error occurs.BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
BigDecimal
.columnIndex
- The index of the column to return.scale
- The number of digits to the right of the decimal to return.BigDecimal
.SQLException
- If an error occurs.byte[] getBytes(int columnIndex) throws SQLException
columnIndex
- The index of the column to return.SQLException
- If an error occurs.Date getDate(int columnIndex) throws SQLException
java.sql.Date
.columnIndex
- The index of the column to return.java.sql.Date
.SQLException
- If an error occurs.Time getTime(int columnIndex) throws SQLException
java.sql.Time
.columnIndex
- The index of the column to return.java.sql.Time
.SQLException
- If an error occurs.Timestamp getTimestamp(int columnIndex) throws SQLException
java.sql.Timestamp
.columnIndex
- The index of the column to return.java.sql.Timestamp
.SQLException
- If an error occurs.InputStream getAsciiStream(int columnIndex) throws SQLException
next()
or close()
on this result set
will close this stream as well.columnIndex
- The index of the column to return.InputStream
.SQLException
- If an error occurs.InputStream getUnicodeStream(int columnIndex) throws SQLException
next()
or close()
on this result set
will close this stream as well.columnIndex
- The index of the column to return.InputStream
.SQLException
- If an error occurs.InputStream getBinaryStream(int columnIndex) throws SQLException
next()
or close()
on this result set
will close this stream as well.columnIndex
- The index of the column to return.InputStream
.SQLException
- If an error occurs.String getString(String columnName) throws SQLException
String
.columnName
- The name of the column to return.String
.SQLException
- If an error occurs.boolean getBoolean(String columnName) throws SQLException
boolean
.columnName
- The name of the column to return.boolean
.SQLException
- If an error occurs.byte getByte(String columnName) throws SQLException
byte
.columnName
- The name of the column to return.byte
.SQLException
- If an error occurs.short getShort(String columnName) throws SQLException
short
.columnName
- The name of the column to return.short
.SQLException
- If an error occurs.int getInt(String columnName) throws SQLException
int
.columnName
- The name of the column to return.int
.SQLException
- If an error occurs.long getLong(String columnName) throws SQLException
long
.columnName
- The name of the column to return.long
.SQLException
- If an error occurs.float getFloat(String columnName) throws SQLException
float
.columnName
- The name of the column to return.float
.SQLException
- If an error occurs.double getDouble(String columnName) throws SQLException
double
.columnName
- The name of the column to return.double
.SQLException
- If an error occurs.BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
BigDecimal
.columnName
- The name of the column to return.BigDecimal
.SQLException
- If an error occurs.byte[] getBytes(String columnName) throws SQLException
columnName
- The name of the column to return.SQLException
- If an error occurs.Date getDate(String columnName) throws SQLException
java.sql.Date
.columnName
- The name of the column to return.java.sql.Date
.SQLException
- If an error occurs.Time getTime(String columnName) throws SQLException
java.sql.Time
.columnName
- The name of the column to return.java.sql.Time
.SQLException
- If an error occurs.Timestamp getTimestamp(String columnName) throws SQLException
java.sql.Timestamp
.columnName
- The name of the column to return.java.sql.Timestamp
.SQLException
- If an error occurs.InputStream getAsciiStream(String columnName) throws SQLException
next()
or close()
on this result set
will close this stream as well.columnName
- The name of the column to return.InputStream
.SQLException
- If an error occurs.InputStream getUnicodeStream(String columnName) throws SQLException
next()
or close()
on this result set
will close this stream as well.columnName
- The name of the column to return.InputStream
.SQLException
- If an error occurs.InputStream getBinaryStream(String columnName) throws SQLException
next()
or close()
on this result set
will close this stream as well.columnName
- The name of the column to return.InputStream
.SQLException
- If an error occurs.SQLWarning getWarnings() throws SQLException
null
if
there are no warnings.SQLException
- If an error occurs.void clearWarnings() throws SQLException
SQLException
- If an error occurs.String getCursorName() throws SQLException
SQLException
- If an error occurs.ResultSetMetaData getMetaData() throws SQLException
ResultSetMetaData
instance.ResultSetMetaData
instance for this result set.SQLException
- If an error occurs.Object getObject(int columnIndex) throws SQLException
Object
.columnIndex
- The index of the column to return.Object
.SQLException
- If an error occurs.Object getObject(String columnName) throws SQLException
Object
.columnName
- The name of the column to return.Object
.SQLException
- If an error occurs.int findColumn(String columnName) throws SQLException
columnName
- The name of the column.SQLException
- If an error occurs.Reader getCharacterStream(int columnIndex) throws SQLException
next()
or close()
on this result set
will close this stream as well.columnIndex
- The index of the column to return.Reader
.SQLException
- If an error occurs.Reader getCharacterStream(String columnName) throws SQLException
next()
or close()
on this result set
will close this stream as well.columnName
- The name of the column to return.Reader
.SQLException
- If an error occurs.BigDecimal getBigDecimal(int columnIndex) throws SQLException
BigDecimal
.columnIndex
- The index of the column to return.BigDecimal
.SQLException
- If an error occurs.BigDecimal getBigDecimal(String columnName) throws SQLException
BigDecimal
.columnName
- The name of the column to return.BigDecimal
.SQLException
- If an error occurs.boolean isBeforeFirst() throws SQLException
true
if the cursor is positioned before the first
row, false
otherwise.SQLException
- If an error occurs.boolean isAfterLast() throws SQLException
true
if the cursor is positioned after the last
row, false
otherwise.SQLException
- If an error occurs.boolean isFirst() throws SQLException
true
if the cursor is positioned on the first
row, false
otherwise.SQLException
- If an error occurs.boolean isLast() throws SQLException
true
if the cursor is positioned on the last
row, false
otherwise.SQLException
- If an error occurs.void beforeFirst() throws SQLException
SQLException
- If an error occurs.void afterLast() throws SQLException
SQLException
- If an error occurs.boolean first() throws SQLException
true
if the cursor is on a valid row;
false
if there are no rows in the result set.SQLException
- If an error occurs.boolean last() throws SQLException
true
if the cursor is on a valid row;
false
if there are no rows in the result set.SQLException
- If an error occurs.int getRow() throws SQLException
SQLException
- If an error occurs.boolean absolute(int row) throws SQLException
row
- The row to position the result set to.true
if the current position was changed,
false
otherwise.SQLException
- If an error occurs.boolean relative(int rows) throws SQLException
rows
- The number of row positions to move.true
if the current position was changed,
false
otherwise.SQLException
- If an error occurs.boolean previous() throws SQLException
true
if the previous row exists, false
otherwise.SQLException
- If an error occurs.void setFetchDirection(int direction) throws SQLException
direction
- The direction in which rows will be processed. The
allowed values are the FETCH_*
constants
defined in this interface.SQLException
- If an error occurs.int getFetchDirection() throws SQLException
SQLException
- If an error occurs.void setFetchSize(int rows) throws SQLException
rows
- The number of rows the driver should fetch per call.SQLException
- If an error occurs.int getFetchSize() throws SQLException
SQLException
- If an error occurs.int getType() throws SQLException
TYPE_*
constants defined in this interface.SQLException
- If an error occurs.int getConcurrency() throws SQLException
CONCUR_*
constants defined in this interface.SQLException
- If an error occurs.boolean rowUpdated() throws SQLException
true
if the row has been updated, false
otherwise.SQLException
- If an error occurs.boolean rowInserted() throws SQLException
true
if the row has been inserted, false
otherwise.SQLException
- If an error occurs.boolean rowDeleted() throws SQLException
true
if the row has been deleted, false
otherwise.SQLException
- If an error occurs.void updateNull(int columnIndex) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.SQLException
- If an error occurs.void updateBoolean(int columnIndex, boolean value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateByte(int columnIndex, byte value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateShort(int columnIndex, short value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateInt(int columnIndex, int value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateLong(int columnIndex, long value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateFloat(int columnIndex, float value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateDouble(int columnIndex, double value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateBigDecimal(int columnIndex, BigDecimal value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateString(int columnIndex, String value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateBytes(int columnIndex, byte[] value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateDate(int columnIndex, Date value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateTime(int columnIndex, Time value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateTimestamp(int columnIndex, Timestamp value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateAsciiStream(int columnIndex, InputStream stream, int count) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.stream
- The stream from which the column value is updated.count
- The length of the stream.SQLException
- If an error occurs.void updateBinaryStream(int columnIndex, InputStream stream, int count) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.stream
- The stream from which the column value is updated.count
- The length of the stream.SQLException
- If an error occurs.void updateCharacterStream(int columnIndex, Reader reader, int count) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.reader
- The reader from which the column value is updated.count
- The length of the stream.SQLException
- If an error occurs.void updateObject(int columnIndex, Object value, int scale) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.scale
- The scale of the object in question, which is used only
for numeric type objects.SQLException
- If an error occurs.void updateObject(int columnIndex, Object value) throws SQLException
updateRow
must be
called in order to do that.columnIndex
- The index of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateNull(String columnName) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.SQLException
- If an error occurs.void updateBoolean(String columnName, boolean value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateByte(String columnName, byte value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateShort(String columnName, short value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateInt(String columnName, int value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateLong(String columnName, long value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateFloat(String columnName, float value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateDouble(String columnName, double value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateBigDecimal(String columnName, BigDecimal value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateString(String columnName, String value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateBytes(String columnName, byte[] value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateDate(String columnName, Date value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateTime(String columnName, Time value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateTimestamp(String columnName, Timestamp value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void updateAsciiStream(String columnName, InputStream stream, int count) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.stream
- The stream from which the column value is updated.count
- The length of the stream.SQLException
- If an error occurs.void updateBinaryStream(String columnName, InputStream stream, int count) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.stream
- The stream from which the column value is updated.count
- The length of the stream.SQLException
- If an error occurs.void updateCharacterStream(String columnName, Reader reader, int count) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.reader
- The reader from which the column value is updated.count
- The length of the stream.SQLException
- If an error occurs.void updateObject(String columnName, Object value, int scale) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.scale
- The scale of the object in question, which is used only
for numeric type objects.SQLException
- If an error occurs.void updateObject(String columnName, Object value) throws SQLException
updateRow
must be
called in order to do that.columnName
- The name of the column to update.value
- The new value of the column.SQLException
- If an error occurs.void insertRow() throws SQLException
SQLException
- If an error occurs.void updateRow() throws SQLException
SQLException
- If an error occurs.void deleteRow() throws SQLException
SQLException
- If an error occurs.void refreshRow() throws SQLException
SQLException
- If an error occurs.void cancelRowUpdates() throws SQLException
rowUpdate
method has been called, then the changes
cannot be undone.SQLException
- If an error occurs.void moveToInsertRow() throws SQLException
SQLException
- If an error occurs.void moveToCurrentRow() throws SQLException
SQLException
- If an error occurs.Statement getStatement() throws SQLException
Statement
that was used to
produce this result set.Statement
used to produce this result set.SQLException
- If an error occurs.Object getObject(int columnIndex, Map<String,Class<?>> map) throws SQLException
Object
using the specified SQL type to Java type map.columnIndex
- The index of the column to return.map
- The SQL type to Java type map to use.Object
.SQLException
- If an error occurs.Ref getRef(int columnIndex) throws SQLException
Ref
for the specified column which
represents the structured type for the column.columnIndex
- The index of the column to return.Ref
object for the columnSQLException
- If an error occurs.Blob getBlob(int columnIndex) throws SQLException
columnIndex
- The index of the column value to return.SQLException
- If an error occurs.Clob getClob(int columnIndex) throws SQLException
columnIndex
- The index of the column value to return.SQLException
- If an error occurs.Array getArray(int columnIndex) throws SQLException
Array
.columnIndex
- The index of the column value to return.Array
.SQLException
- If an error occurs.Object getObject(String columnName, Map<String,Class<?>> map) throws SQLException
Object
using the specified SQL type to Java type map.columnName
- The name of the column to return.map
- The SQL type to Java type map to use.Object
.SQLException
- If an error occurs.Ref getRef(String columnName) throws SQLException
Ref
for the specified column which
represents the structured type for the column.columnName
- The name of the column to return.Ref
object for the columnSQLException
- If an error occurs.Blob getBlob(String columnName) throws SQLException
columnName
- The name of the column value to return.SQLException
- If an error occurs.Clob getClob(String columnName) throws SQLException
columnName
- The name of the column value to return.SQLException
- If an error occurs.Array getArray(String columnName) throws SQLException
Array
.columnName
- The name of the column value to return.Array
.SQLException
- If an error occurs.Date getDate(int columnIndex, Calendar cal) throws SQLException
java.sql.Date
. The specified Calendar
is used
to generate a value for the date if the database does not support
timezones.columnIndex
- The index of the column value to return.cal
- The Calendar
to use for calculating timezones.java.sql.Date
.SQLException
- If an error occurs.Date getDate(String columnName, Calendar cal) throws SQLException
java.sql.Date
. The specified Calendar
is used
to generate a value for the date if the database does not support
timezones.columnName
- The name of the column value to return.cal
- The Calendar
to use for calculating timezones.java.sql.Date
.SQLException
- If an error occurs.Time getTime(int columnIndex, Calendar cal) throws SQLException
java.sql.Time
. The specified Calendar
is used
to generate a value for the time if the database does not support
timezones.columnIndex
- The index of the column value to return.cal
- The Calendar
to use for calculating timezones.java.sql.Time
.SQLException
- If an error occurs.Time getTime(String columnName, Calendar cal) throws SQLException
java.sql.Time
. The specified Calendar
is used
to generate a value for the time if the database does not support
timezones.columnName
- The name of the column value to return.cal
- The Calendar
to use for calculating timezones.java.sql.Time
.SQLException
- If an error occurs.Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
java.sql.Timestamp
. The specified Calendar
is used
to generate a value for the timestamp if the database does not support
timezones.columnIndex
- The index of the column value to return.cal
- The Calendar
to use for calculating timezones.java.sql.Timestamp
.SQLException
- If an error occurs.Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
java.sql.Timestamp
. The specified Calendar
is used
to generate a value for the timestamp if the database does not support
timezones.columnName
- The name of the column value to return.cal
- The Calendar
to use for calculating timezones.java.sql.Timestamp
.SQLException
- If an error occurs.URL getURL(int columnIndex) throws SQLException
java.net.URL
.columnIndex
- The index of the column value to return.SQLException
- If an error occurs.URL getURL(String columnName) throws SQLException
java.net.URL
.columnName
- The name of the column value to return.SQLException
- If an error occurs.void updateRef(int columnIndex, Ref value) throws SQLException
java.sql.Ref
value.
This does not update the actual database. updateRow
must be
called in order to do that.SQLException
- If an error occurs.void updateRef(String columnName, Ref value) throws SQLException
java.sql.Ref
value.
This does not update the actual database. updateRow
must be
called in order to do that.SQLException
- If an error occurs.void updateBlob(int columnIndex, Blob value) throws SQLException
java.sql.Blob
value.
This does not update the actual database. updateRow
must be
called in order to do that.SQLException
- If an error occurs.void updateBlob(String columnName, Blob value) throws SQLException
java.sql.Blob
value.
This does not update the actual database. updateRow
must be
called in order to do that.SQLException
- If an error occurs.void updateClob(int columnIndex, Clob value) throws SQLException
java.sql.Clob
value.
This does not update the actual database. updateRow
must be
called in order to do that.SQLException
- If an error occurs.void updateClob(String columnName, Clob value) throws SQLException
java.sql.Clob
value.
This does not update the actual database. updateRow
must be
called in order to do that.SQLException
- If an error occurs.void updateArray(int columnIndex, Array value) throws SQLException
java.sqlArray
value.
This does not update the actual database. updateRow
must be
called in order to do that.SQLException
- If an error occurs.void updateArray(String columnName, Array value) throws SQLException
java.sqlArray
value.
This does not update the actual database. updateRow
must be
called in order to do that.SQLException
- If an error occurs.