|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
public interface ResultSet
This interface provides access to the data set returned by a SQL
statement. An instance of this interface is returned by the various
execution methods in the 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.
| Field Summary | |
|---|---|
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. |
| Method Summary | |
|---|---|
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. |
| Field Detail |
|---|
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
| Method Detail |
|---|
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 column
SQLException - 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 column
SQLException - 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.
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||