java.sql

Interface ResultSet

Known Subinterfaces:
RowSet

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> 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> 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.
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.
InputStream
getUnicodeStream(int columnIndex)
Deprecated. Use getCharacterStream instead.
InputStream
getUnicodeStream(String columnName)
Deprecated. Use getCharacterStream instead.
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 Details

CLOSE_CURSORS_AT_COMMIT

public static final int CLOSE_CURSORS_AT_COMMIT
Field Value:
2

CONCUR_READ_ONLY

public static final int CONCUR_READ_ONLY
The concurrency mode of for the result set may not be modified.
Field Value:
1007

CONCUR_UPDATABLE

public static final int CONCUR_UPDATABLE
The concurrency mode of for the result set may be modified.
Field Value:
1008

FETCH_FORWARD

public static final int FETCH_FORWARD
The rows will be processed in order from first to last.
Field Value:
1000

FETCH_REVERSE

public static final int FETCH_REVERSE
The rows will be processed in order from last to first.
Field Value:
1001

FETCH_UNKNOWN

public static final int FETCH_UNKNOWN
The rows will be processed in an unknown order
Field Value:
1002

HOLD_CURSORS_OVER_COMMIT

public static final int HOLD_CURSORS_OVER_COMMIT
Field Value:
1

TYPE_FORWARD_ONLY

public static final int TYPE_FORWARD_ONLY
This type of result set may only step forward through the rows returned.
Field Value:
1003

TYPE_SCROLL_INSENSITIVE

public static final int TYPE_SCROLL_INSENSITIVE
This type of result set is scrollable and is not sensitive to changes made by other statements.
Field Value:
1004

TYPE_SCROLL_SENSITIVE

public static final int TYPE_SCROLL_SENSITIVE
This type of result set is scrollable and is also sensitive to changes made by other statements.
Field Value:
1005

Method Details

absolute

public boolean absolute(int row)
            throws SQLException
This method positions the result set to the specified absolute row. Positive numbers are row offsets from the beginning of the result set (numbering starts from row 1) and negative numbers are row offsets from the end of the result set (numbering starts from -1).
Parameters:
row - The row to position the result set to.
Returns:
true if the current position was changed, false otherwise.
Throws:
SQLException - If an error occurs.

afterLast

public void afterLast()
            throws SQLException
This method repositions the cursor to after the last row in the result set.
Throws:
SQLException - If an error occurs.

beforeFirst

public void beforeFirst()
            throws SQLException
This method repositions the cursor to before the first row in the result set.
Throws:
SQLException - If an error occurs.

cancelRowUpdates

public void cancelRowUpdates()
            throws SQLException
This method cancels any changes that have been made to a row. If the rowUpdate method has been called, then the changes cannot be undone.
Throws:
SQLException - If an error occurs.

clearWarnings

public void clearWarnings()
            throws SQLException
This method clears all warnings associated with this result set.
Throws:
SQLException - If an error occurs.

close

public void close()
            throws SQLException
This method closes the result set and frees any associated resources.
Throws:
SQLException - If an error occurs.

deleteRow

public void deleteRow()
            throws SQLException
This method deletes the current row in the database.
Throws:
SQLException - If an error occurs.

findColumn

public int findColumn(String columnName)
            throws SQLException
This method returns the column index of the specified named column.
Parameters:
columnName - The name of the column.
Returns:
The index of the column.
Throws:
SQLException - If an error occurs.

first

public boolean first()
            throws SQLException
This method repositions the cursor on the first row in the result set.
Returns:
true if the cursor is on a valid row; false if there are no rows in the result set.
Throws:
SQLException - If an error occurs.

getArray

public Array getArray(int columnIndex)
            throws SQLException
This method returns the specified column value as an Array.
Parameters:
columnIndex - The index of the column value to return.
Returns:
The value of the column as an Array.
Throws:
SQLException - If an error occurs.

getArray

public Array getArray(String columnName)
            throws SQLException
This method returns the specified column value as an Array.
Parameters:
columnName - The name of the column value to return.
Returns:
The value of the column as an Array.
Throws:
SQLException - If an error occurs.

getAsciiStream

public InputStream getAsciiStream(int columnIndex)
            throws SQLException
This method returns the value of the specified column as an ASCII stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as an ASCII InputStream.
Throws:
SQLException - If an error occurs.

getAsciiStream

public InputStream getAsciiStream(String columnName)
            throws SQLException
This method returns the value of the specified column as an ASCII stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as an ASCII InputStream.
Throws:
SQLException - If an error occurs.

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java BigDecimal.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex,
                                int scale)
            throws SQLException

Deprecated.

This method returns the value of the specified column as a Java BigDecimal.
Parameters:
columnIndex - The index of the column to return.
scale - The number of digits to the right of the decimal to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBigDecimal

public BigDecimal getBigDecimal(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java BigDecimal.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBigDecimal

public BigDecimal getBigDecimal(String columnName,
                                int scale)
            throws SQLException

Deprecated.

This method returns the value of the specified column as a Java BigDecimal.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBinaryStream

public InputStream getBinaryStream(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a raw byte stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a raw byte InputStream.
Throws:
SQLException - If an error occurs.

getBinaryStream

public InputStream getBinaryStream(String columnName)
            throws SQLException
This method returns the value of the specified column as a raw byte stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a raw byte InputStream.
Throws:
SQLException - If an error occurs.

getBlob

public Blob getBlob(int columnIndex)
            throws SQLException
This method returns the specified column value as a BLOB.
Parameters:
columnIndex - The index of the column value to return.
Returns:
The value of the column as a BLOB.
Throws:
SQLException - If an error occurs.

getBlob

public Blob getBlob(String columnName)
            throws SQLException
This method returns the specified column value as a BLOB.
Parameters:
columnName - The name of the column value to return.
Returns:
The value of the column as a BLOB.
Throws:
SQLException - If an error occurs.

getBoolean

public boolean getBoolean(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java boolean.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a boolean.
Throws:
SQLException - If an error occurs.

getBoolean

public boolean getBoolean(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java boolean.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a boolean.
Throws:
SQLException - If an error occurs.

getByte

public byte getByte(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java byte.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a byte.
Throws:
SQLException - If an error occurs.

getByte

public byte getByte(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java byte.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a byte.
Throws:
SQLException - If an error occurs.

getBytes

public byte[] getBytes(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java byte array.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a byte array
Throws:
SQLException - If an error occurs.

getBytes

public byte[] getBytes(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java byte array.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a byte array
Throws:
SQLException - If an error occurs.

getCharacterStream

public Reader getCharacterStream(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a character stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as an character Reader.
Throws:
SQLException - If an error occurs.

getCharacterStream

public Reader getCharacterStream(String columnName)
            throws SQLException
This method returns the value of the specified column as a character stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as an character Reader.
Throws:
SQLException - If an error occurs.

getClob

public Clob getClob(int columnIndex)
            throws SQLException
This method returns the specified column value as a CLOB.
Parameters:
columnIndex - The index of the column value to return.
Returns:
The value of the column as a CLOB.
Throws:
SQLException - If an error occurs.

getClob

public Clob getClob(String columnName)
            throws SQLException
This method returns the specified column value as a CLOB.
Parameters:
columnName - The name of the column value to return.
Returns:
The value of the column as a CLOB.
Throws:
SQLException - If an error occurs.

getConcurrency

public int getConcurrency()
            throws SQLException
This method returns the concurrency type of this result set. This will be one of the CONCUR_* constants defined in this interface.
Returns:
The result set concurrency type.
Throws:
SQLException - If an error occurs.

getCursorName

public String getCursorName()
            throws SQLException
This method returns the name of the database cursor used by this result set.
Returns:
The name of the database cursor used by this result set.
Throws:
SQLException - If an error occurs.

getDate

public Date getDate(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java java.sql.Date.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getDate

public Date getDate(int columnIndex,
                    Calendar cal)
            throws SQLException
This method returns the specified column value as a java.sql.Date. The specified Calendar is used to generate a value for the date if the database does not support timezones.
Parameters:
columnIndex - The index of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getDate

public Date getDate(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java java.sql.Date.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getDate

public Date getDate(String columnName,
                    Calendar cal)
            throws SQLException
This method returns the specified column value as a java.sql.Date. The specified Calendar is used to generate a value for the date if the database does not support timezones.
Parameters:
columnName - The name of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getDouble

public double getDouble(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java double.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a double.
Throws:
SQLException - If an error occurs.

getDouble

public double getDouble(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java double.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a double.
Throws:
SQLException - If an error occurs.

getFetchDirection

public int getFetchDirection()
            throws SQLException
This method returns the current fetch direction for this result set.
Returns:
The fetch direction for this result set.
Throws:
SQLException - If an error occurs.

getFetchSize

public int getFetchSize()
            throws SQLException
This method returns the current number of rows that will be fetched from the database at a time.
Returns:
The current fetch size for this result set.
Throws:
SQLException - If an error occurs.

getFloat

public float getFloat(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java float.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a float.
Throws:
SQLException - If an error occurs.

getFloat

public float getFloat(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java float.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a float.
Throws:
SQLException - If an error occurs.

getInt

public int getInt(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java int.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a int.
Throws:
SQLException - If an error occurs.

getInt

public int getInt(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java int.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a int.
Throws:
SQLException - If an error occurs.

getLong

public long getLong(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java long.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a long.
Throws:
SQLException - If an error occurs.

getLong

public long getLong(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java long.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a long.
Throws:
SQLException - If an error occurs.

getMetaData

public ResultSetMetaData getMetaData()
            throws SQLException
This method returns data about the columns returned as part of the result set as a ResultSetMetaData instance.
Returns:
The ResultSetMetaData instance for this result set.
Throws:
SQLException - If an error occurs.

getObject

public Object getObject(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java Object.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as an Object.
Throws:
SQLException - If an error occurs.

getObject

public Object getObject(int columnIndex,
                        Map> map)
            throws SQLException
This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
Parameters:
columnIndex - The index of the column to return.
map - The SQL type to Java type map to use.
Returns:
The value of the column as an Object.
Throws:
SQLException - If an error occurs.

getObject

public Object getObject(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java Object.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as an Object.
Throws:
SQLException - If an error occurs.

getObject

public Object getObject(String columnName,
                        Map> map)
            throws SQLException
This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
Parameters:
columnName - The name of the column to return.
map - The SQL type to Java type map to use.
Returns:
The value of the column as an Object.
Throws:
SQLException - If an error occurs.

getRef

public Ref getRef(int columnIndex)
            throws SQLException
This method returns a Ref for the specified column which represents the structured type for the column.
Parameters:
columnIndex - The index of the column to return.
Returns:
A Ref object for the column
Throws:
SQLException - If an error occurs.

getRef

public Ref getRef(String columnName)
            throws SQLException
This method returns a Ref for the specified column which represents the structured type for the column.
Parameters:
columnName - The name of the column to return.
Returns:
A Ref object for the column
Throws:
SQLException - If an error occurs.

getRow

public int getRow()
            throws SQLException
This method returns the current row number in the cursor. Numbering begins at index 1.
Returns:
The current row number, or 0 if there is not current row.
Throws:
SQLException - If an error occurs.

getShort

public short getShort(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java short.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a short.
Throws:
SQLException - If an error occurs.

getShort

public short getShort(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java short.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a short.
Throws:
SQLException - If an error occurs.

getStatement

public Statement getStatement()
            throws SQLException
This method returns a the Statement that was used to produce this result set.
Returns:
The Statement used to produce this result set.
Throws:
SQLException - If an error occurs.

getString

public String getString(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java String.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a String.
Throws:
SQLException - If an error occurs.

getString

public String getString(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java String.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a String.
Throws:
SQLException - If an error occurs.

getTime

public Time getTime(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java java.sql.Time.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTime

public Time getTime(int columnIndex,
                    Calendar cal)
            throws SQLException
This method returns the specified column value as a java.sql.Time. The specified Calendar is used to generate a value for the time if the database does not support timezones.
Parameters:
columnIndex - The index of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTime

public Time getTime(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java java.sql.Time.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTime

public Time getTime(String columnName,
                    Calendar cal)
            throws SQLException
This method returns the specified column value as a java.sql.Time. The specified Calendar is used to generate a value for the time if the database does not support timezones.
Parameters:
columnName - The name of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTimestamp

public Timestamp getTimestamp(int columnIndex)
            throws SQLException
This method returns the value of the specified column as a Java java.sql.Timestamp.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getTimestamp

public Timestamp getTimestamp(int columnIndex,
                              Calendar cal)
            throws SQLException
This method returns the specified column value as a java.sql.Timestamp. The specified Calendar is used to generate a value for the timestamp if the database does not support timezones.
Parameters:
columnIndex - The index of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getTimestamp

public Timestamp getTimestamp(String columnName)
            throws SQLException
This method returns the value of the specified column as a Java java.sql.Timestamp.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getTimestamp

public Timestamp getTimestamp(String columnName,
                              Calendar cal)
            throws SQLException
This method returns the specified column value as a java.sql.Timestamp. The specified Calendar is used to generate a value for the timestamp if the database does not support timezones.
Parameters:
columnName - The name of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getType

public int getType()
            throws SQLException
This method returns the result set type of this result set. This will be one of the TYPE_* constants defined in this interface.
Returns:
The result set type.
Throws:
SQLException - If an error occurs.

getURL

public URL getURL(int columnIndex)
            throws SQLException
This method returns the specified column value as a java.net.URL.
Parameters:
columnIndex - The index of the column value to return.
Throws:
SQLException - If an error occurs.
Since:
1.4

getURL

public URL getURL(String columnName)
            throws SQLException
This method returns the specified column value as a java.net.URL.
Parameters:
columnName - The name of the column value to return.
Throws:
SQLException - If an error occurs.
Since:
1.4

getUnicodeStream

public InputStream getUnicodeStream(int columnIndex)
            throws SQLException

Deprecated. Use getCharacterStream instead.

This method returns the value of the specified column as a Unicode UTF-8 stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a Unicode UTF-8 InputStream.
Throws:
SQLException - If an error occurs.

getUnicodeStream

public InputStream getUnicodeStream(String columnName)
            throws SQLException

Deprecated. Use getCharacterStream instead.

This method returns the value of the specified column as a Unicode UTF-8 stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.
Parameters:
columnName - The name of the column to return.
Returns:
The column value as a Unicode UTF-8 InputStream.
Throws:
SQLException - If an error occurs.

getWarnings

public SQLWarning getWarnings()
            throws SQLException
This method returns the first SQL warning associated with this result set. Any additional warnings will be chained to this one.
Returns:
The first SQLWarning for this result set, or null if there are no warnings.
Throws:
SQLException - If an error occurs.

insertRow

public void insertRow()
            throws SQLException
This method inserts the current row into the database. The result set must be positioned on the insert row in order to call this method successfully.
Throws:
SQLException - If an error occurs.

isAfterLast

public boolean isAfterLast()
            throws SQLException
This method tests whether or not the cursor is after the last row in the result set.
Returns:
true if the cursor is positioned after the last row, false otherwise.
Throws:
SQLException - If an error occurs.

isBeforeFirst

public boolean isBeforeFirst()
            throws SQLException
This method tests whether or not the cursor is before the first row in the result set.
Returns:
true if the cursor is positioned before the first row, false otherwise.
Throws:
SQLException - If an error occurs.

isFirst

public boolean isFirst()
            throws SQLException
This method tests whether or not the cursor is positioned on the first row in the result set.
Returns:
true if the cursor is positioned on the first row, false otherwise.
Throws:
SQLException - If an error occurs.

isLast

public boolean isLast()
            throws SQLException
This method tests whether or not the cursor is on the last row in the result set.
Returns:
true if the cursor is positioned on the last row, false otherwise.
Throws:
SQLException - If an error occurs.

last

public boolean last()
            throws SQLException
This method repositions the cursor on the last row in the result set.
Returns:
true if the cursor is on a valid row; false if there are no rows in the result set.
Throws:
SQLException - If an error occurs.

moveToCurrentRow

public void moveToCurrentRow()
            throws SQLException
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.
Throws:
SQLException - If an error occurs.

moveToInsertRow

public void moveToInsertRow()
            throws SQLException
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.
Throws:
SQLException - If an error occurs.

next

public boolean next()
            throws SQLException
This method advances to the next row in the result set. Any streams open on the current row are closed automatically.
Returns:
true if the next row exists, false otherwise.
Throws:
SQLException - If an error occurs.

previous

public boolean previous()
            throws SQLException
This method moves the current position to the previous row in the result set.
Returns:
true if the previous row exists, false otherwise.
Throws:
SQLException - If an error occurs.

refreshRow

public void refreshRow()
            throws SQLException
This method refreshes the contents of the current row from the database.
Throws:
SQLException - If an error occurs.

relative

public boolean relative(int rows)
            throws SQLException
This method moves the result set position relative to the current row. The offset can be positive or negative.
Parameters:
rows - The number of row positions to move.
Returns:
true if the current position was changed, false otherwise.
Throws:
SQLException - If an error occurs.

rowDeleted

public boolean rowDeleted()
            throws SQLException
This method tests whether or not the current row in the result set has been deleted. Deletes must be visible in order of this method to detect the deletion.
Returns:
true if the row has been deleted, false otherwise.
Throws:
SQLException - If an error occurs.

rowInserted

public boolean rowInserted()
            throws SQLException
This method tests whether or not the current row in the result set has been inserted. Inserts must be visible in order of this method to detect the insert.
Returns:
true if the row has been inserted, false otherwise.
Throws:
SQLException - If an error occurs.

rowUpdated

public boolean rowUpdated()
            throws SQLException
This method tests whether or not the current row in the result set has been updated. Updates must be visible in order of this method to detect the update.
Returns:
true if the row has been updated, false otherwise.
Throws:
SQLException - If an error occurs.

setFetchDirection

public void setFetchDirection(int direction)
            throws SQLException
This method provides a hint to the driver about which direction the result set will be processed in.
Parameters:
direction - The direction in which rows will be processed. The allowed values are the FETCH_* constants defined in this interface.
Throws:
SQLException - If an error occurs.

setFetchSize

public void setFetchSize(int rows)
            throws SQLException
This method provides a hint to the driver about how many rows at a time it should fetch from the database.
Parameters:
rows - The number of rows the driver should fetch per call.
Throws:
SQLException - If an error occurs.

updateArray

public void updateArray(int columnIndex,
                        Array value)
            throws SQLException
This method updates the specified column to have a java.sqlArray value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateArray

public void updateArray(String columnName,
                        Array value)
            throws SQLException
This method updates the specified column to have a java.sqlArray value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream stream,
                              int count)
            throws SQLException
This method updates the specified column from an ASCII text stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream stream,
                              int count)
            throws SQLException
This method updates the specified column from an ASCII text stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             BigDecimal value)
            throws SQLException
This method updates the specified column to have a BigDecimal value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBigDecimal

public void updateBigDecimal(String columnName,
                             BigDecimal value)
            throws SQLException
This method updates the specified column to have a BigDecimal value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream stream,
                               int count)
            throws SQLException
This method updates the specified column from a binary stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream stream,
                               int count)
            throws SQLException
This method updates the specified column from a binary stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateBlob

public void updateBlob(int columnIndex,
                       Blob value)
            throws SQLException
This method updates the specified column to have a java.sql.Blob value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateBlob

public void updateBlob(String columnName,
                       Blob value)
            throws SQLException
This method updates the specified column to have a java.sql.Blob value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean value)
            throws SQLException
This method updates the specified column to have a boolean value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBoolean

public void updateBoolean(String columnName,
                          boolean value)
            throws SQLException
This method updates the specified column to have a boolean value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateByte

public void updateByte(int columnIndex,
                       byte value)
            throws SQLException
This method updates the specified column to have a byte value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateByte

public void updateByte(String columnName,
                       byte value)
            throws SQLException
This method updates the specified column to have a byte value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBytes

public void updateBytes(int columnIndex,
                        byte[] value)
            throws SQLException
This method updates the specified column to have a byte array value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBytes

public void updateBytes(String columnName,
                        byte[] value)
            throws SQLException
This method updates the specified column to have a byte array value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader reader,
                                  int count)
            throws SQLException
This method updates the specified column from a character stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
reader - The reader from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader reader,
                                  int count)
            throws SQLException
This method updates the specified column from a character stream. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
reader - The reader from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateClob

public void updateClob(int columnIndex,
                       Clob value)
            throws SQLException
This method updates the specified column to have a java.sql.Clob value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateClob

public void updateClob(String columnName,
                       Clob value)
            throws SQLException
This method updates the specified column to have a java.sql.Clob value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateDate

public void updateDate(int columnIndex,
                       Date value)
            throws SQLException
This method updates the specified column to have a java.sql.Date value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDate

public void updateDate(String columnName,
                       Date value)
            throws SQLException
This method updates the specified column to have a java.sql.Date value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDouble

public void updateDouble(int columnIndex,
                         double value)
            throws SQLException
This method updates the specified column to have a double value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDouble

public void updateDouble(String columnName,
                         double value)
            throws SQLException
This method updates the specified column to have a double value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateFloat

public void updateFloat(int columnIndex,
                        float value)
            throws SQLException
This method updates the specified column to have a float value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateFloat

public void updateFloat(String columnName,
                        float value)
            throws SQLException
This method updates the specified column to have a float value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateInt

public void updateInt(int columnIndex,
                      int value)
            throws SQLException
This method updates the specified column to have an int value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateInt

public void updateInt(String columnName,
                      int value)
            throws SQLException
This method updates the specified column to have an int value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateLong

public void updateLong(int columnIndex,
                       long value)
            throws SQLException
This method updates the specified column to have a long value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateLong

public void updateLong(String columnName,
                       long value)
            throws SQLException
This method updates the specified column to have a long value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateNull

public void updateNull(int columnIndex)
            throws SQLException
This method updates the specified column to have a NULL value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
Throws:
SQLException - If an error occurs.

updateNull

public void updateNull(String columnName)
            throws SQLException
This method updates the specified column to have a NULL value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
Throws:
SQLException - If an error occurs.

updateObject

public void updateObject(int columnIndex,
                         Object value)
            throws SQLException
This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateObject

public void updateObject(int columnIndex,
                         Object value,
                         int scale)
            throws SQLException
This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
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.
Throws:
SQLException - If an error occurs.

updateObject

public void updateObject(String columnName,
                         Object value)
            throws SQLException
This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateObject

public void updateObject(String columnName,
                         Object value,
                         int scale)
            throws SQLException
This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
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.
Throws:
SQLException - If an error occurs.

updateRef

public void updateRef(int columnIndex,
                      Ref value)
            throws SQLException
This method updates the specified column to have a java.sql.Ref value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateRef

public void updateRef(String columnName,
                      Ref value)
            throws SQLException
This method updates the specified column to have a java.sql.Ref value. This does not update the actual database. updateRow must be called in order to do that.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateRow

public void updateRow()
            throws SQLException
This method updates the current row in the database.
Throws:
SQLException - If an error occurs.

updateShort

public void updateShort(int columnIndex,
                        short value)
            throws SQLException
This method updates the specified column to have a short value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateShort

public void updateShort(String columnName,
                        short value)
            throws SQLException
This method updates the specified column to have a short value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateString

public void updateString(int columnIndex,
                         String value)
            throws SQLException
This method updates the specified column to have a String value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateString

public void updateString(String columnName,
                         String value)
            throws SQLException
This method updates the specified column to have a String value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTime

public void updateTime(int columnIndex,
                       Time value)
            throws SQLException
This method updates the specified column to have a java.sql.Time value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTime

public void updateTime(String columnName,
                       Time value)
            throws SQLException
This method updates the specified column to have a java.sql.Time value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTimestamp

public void updateTimestamp(int columnIndex,
                            Timestamp value)
            throws SQLException
This method updates the specified column to have a java.sql.Timestamp value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTimestamp

public void updateTimestamp(String columnName,
                            Timestamp value)
            throws SQLException
This method updates the specified column to have a java.sql.Timestamp value. This does not update the actual database. updateRow must be called in order to do that.
Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

wasNull

public boolean wasNull()
            throws SQLException
This method tests whether the value of the last column that was fetched was actually a SQL NULL value.
Returns:
true if the last column fetched was a NULL, false otherwise.
Throws:
SQLException - If an error occurs.

ResultSet.java -- A SQL statement result set. Copyright (C) 1999, 2000, 2002, 2006 Free Software Foundation, Inc. This file is part of GNU Classpath. GNU Classpath is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2, or (at your option) any later version. GNU Classpath is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with GNU Classpath; see the file COPYING. If not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. Linking this library statically or dynamically with other modules is making a combined work based on this library. Thus, the terms and conditions of the GNU General Public License cover the whole combination. As a special exception, the copyright holders of this library give you permission to link this library with independent modules to produce an executable, regardless of the license terms of these independent modules, and to copy and distribute the resulting executable under terms of your choice, provided that you also meet, for each linked independent module, the terms and conditions of the license of that module. An independent module is a module which is not derived from or based on this library. If you modify this library, you may extend this exception to your version of the library, but you are not obligated to do so. If you do not wish to do so, delete this exception statement from your version.