APIdia Launch Partner
Top Description Fields Methods
java.sql

public Interface ResultSet

extends Wrapper, AutoCloseable
Known Direct Subinterfaces
javax.sql.RowSet
Imports
java.math.BigDecimal, java.util.Calendar, java.io.Reader, .InputStream
A table of data representing a database result set, which is usually generated by executing a statement that queries the database.

A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.

A default ResultSet object is not updatable and has a cursor that moves forward only. Thus, you can iterate through it only once and only from the first row to the last row. It is possible to produce ResultSet objects that are scrollable and/or updatable. The following code fragment, in which con is a valid Connection object, illustrates how to make a result set that is scrollable and insensitive to updates by others, and that is updatable. See ResultSet fields for other options. 


       Statement stmt = con.createStatement(
                                      ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
       ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2");
       // rs will be scrollable, will not show changes made by others,
       // and will be updatable
The ResultSet interface provides getter methods (getBoolean, getLong, and so on) for retrieving column values from the current row. Values can be retrieved using either the index number of the column or the name of the column. In general, using the column index will be more efficient. Columns are numbered from 1. For maximum portability, result set columns within each row should be read in left-to-right order, and each column should be read only once.

For the getter methods, a JDBC driver attempts to convert the underlying data to the Java type specified in the getter method and returns a suitable Java value. The JDBC specification has a table showing the allowable mappings from SQL types to Java types that can be used by the ResultSet getter methods.

Column names used as input to getter methods are case insensitive. When a getter method is called with a column name and several columns have the same name, the value of the first matching column will be returned. The column name option is designed to be used when column names are used in the SQL query that generated the result set. For columns that are NOT explicitly named in the query, it is best to use column numbers. If column names are used, the programmer should take care to guarantee that they uniquely refer to the intended columns, which can be assured with the SQL AS clause.

A set of updater methods were added to this interface in the JDBC 2.0 API (Java 2 SDK, Standard Edition, version 1.2). The comments regarding parameters to the getter methods also apply to parameters to the updater methods.

The updater methods may be used in two ways:

  1. to update a column value in the current row. In a scrollable ResultSet object, the cursor can be moved backwards and forwards, to an absolute position, or to a position relative to the current row. The following code fragment updates the NAME column in the fifth row of the ResultSet object rs and then uses the method updateRow to update the data source table from which rs was derived. 
    
       rs.absolute(5); // moves the cursor to the fifth row of rs
       rs.updateString("NAME", "AINSWORTH"); // updates the
          // NAME column of row 5 to be AINSWORTH
       rs.updateRow(); // updates the row in the data source
  2. to insert column values into the insert row. An updatable ResultSet object has a special row associated with it that serves as a staging area for building a row to be inserted. The following code fragment moves the cursor to the insert row, builds a three-column row, and inserts it into rs and into the data source table using the method insertRow. 
    
       rs.moveToInsertRow(); // moves cursor to the insert row
       rs.updateString(1, "AINSWORTH"); // updates the
          // first column of the insert row to be AINSWORTH
       rs.updateInt(2,35); // updates the second column to be 35
       rs.updateBoolean(3, true); // updates the third column to true
       rs.insertRow();
       rs.moveToCurrentRow();

A ResultSet object is automatically closed when the Statement object that generated it is closed, re-executed, or used to retrieve the next result from a sequence of multiple results.

The number, types and properties of a ResultSet object's columns are provided by the ResultSetMetaData object returned by the ResultSet.getMetaData method.

Since
1.1
See Also
Statement#executeQuery, Statement#getResultSet, ResultSetMetaData

Field Summary

Modifier and TypeField and Description
public static final int
CLOSE_CURSORS_AT_COMMIT

The constant indicating that open ResultSet objects with this holdability will be closed when the current transaction is committed.

public static final int
CONCUR_READ_ONLY

The constant indicating the concurrency mode for a ResultSet object that may NOT be updated.

public static final int
CONCUR_UPDATABLE

The constant indicating the concurrency mode for a ResultSet object that may be updated.

public static final int
FETCH_FORWARD

The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last.

public static final int
FETCH_REVERSE

The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first.

public static final int
FETCH_UNKNOWN

The constant indicating that the order in which rows in a result set will be processed is unknown.

public static final int
HOLD_CURSORS_OVER_COMMIT

The constant indicating that open ResultSet objects with this holdability will remain open when the current transaction is committed.

public static final int
TYPE_FORWARD_ONLY

The constant indicating the type for a ResultSet object whose cursor may move only forward.

public static final int
TYPE_SCROLL_INSENSITIVE

The constant indicating the type for a ResultSet object that is scrollable but generally not sensitive to changes to the data that underlies the ResultSet.

public static final int
TYPE_SCROLL_SENSITIVE

The constant indicating the type for a ResultSet object that is scrollable and generally sensitive to changes to the data that underlies the ResultSet.

Method Summary

Modifier and TypeMethod and Description
public boolean

Returns:

true if the cursor is moved to a position in this ResultSet object; false if the cursor is before the first row or after the last row
absolute(int
the number of the row to which the cursor should move. A value of zero indicates that the cursor will be positioned before the first row; a positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set
row)

Moves the cursor to the given row number in this ResultSet object.

public void
afterLast()

Moves the cursor to the end of this ResultSet object, just after the last row.

public void
beforeFirst()

Moves the cursor to the front of this ResultSet object, just before the first row.

public void
cancelRowUpdates()

Cancels the updates made to the current row in this ResultSet object.

public void
clearWarnings()

Clears all warnings reported on this ResultSet object.

public void
close()

Redeclares java.lang.AutoCloseable.close.

Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

public void
deleteRow()

Deletes the current row from this ResultSet object and from the underlying database.

public int

Returns:

the column index of the given column name
findColumn(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Maps the given ResultSet column label to its ResultSet column index.

public boolean

Returns:

true if the cursor is on a valid row; false if there are no rows in the result set
first()

Moves the cursor to the first row in this ResultSet object.

public Array

Returns:

an Array object representing the SQL ARRAY value in the specified column
getArray(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.

public Array

Returns:

an Array object representing the SQL ARRAY value in the specified column
getArray(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of one-byte ASCII characters; if the value is SQL NULL, the value returned is null
getAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the value returned is null.
getAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

public BigDecimal

Returns:

the column value; if the value is SQL NULL, the value returned is null
getBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex, int
the number of digits to the right of the decimal point
scale)
Deprecated since 1.2. Use getBigDecimal(int columnIndex) or getBigDecimal(String columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.BigDecimal in the Java programming language.

public BigDecimal

Returns:

the column value; if the value is SQL NULL, the value returned is null
getBigDecimal(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, int
the number of digits to the right of the decimal point
scale)
Deprecated since 1.2. Use getBigDecimal(int columnIndex) or getBigDecimal(String columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal in the Java programming language.

public BigDecimal

Returns:

the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.
getBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

public BigDecimal

Returns:

the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.
getBigDecimal(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the value returned is null
getBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the result is null
getBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.

public Blob

Returns:

a Blob object representing the SQL BLOB value in the specified column
getBlob(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

public Blob

Returns:

a Blob object representing the SQL BLOB value in the specified column
getBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

public boolean

Returns:

the column value; if the value is SQL NULL, the value returned is false
getBoolean(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

public boolean

Returns:

the column value; if the value is SQL NULL, the value returned is false
getBoolean(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

public byte

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getByte(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

public byte

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getByte(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

public byte[]

Returns:

the column value; if the value is SQL NULL, the value returned is null
getBytes(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

public byte[]

Returns:

the column value; if the value is SQL NULL, the value returned is null
getBytes(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

public Reader

Returns:

a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language.
getCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public Reader

Returns:

a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language
getCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public Clob

Returns:

a Clob object representing the SQL CLOB value in the specified column
getClob(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.

public Clob

Returns:

a Clob object representing the SQL CLOB value in the specified column
getClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.

public int

Returns:

the concurrency type, either ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
getConcurrency()

Retrieves the concurrency mode of this ResultSet object.

public String

Returns:

the SQL name for this ResultSet object's cursor
getCursorName()

Retrieves the name of the SQL cursor used by this ResultSet object.

public Date

Returns:

the column value; if the value is SQL NULL, the value returned is null
getDate(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

public Date

Returns:

the column value; if the value is SQL NULL, the value returned is null
getDate(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

public Date

Returns:

the column value as a java.sql.Date object; if the value is SQL NULL, the value returned is null in the Java programming language
getDate(int
the first column is 1, the second is 2, ...
columnIndex, Calendar
the java.util.Calendar object to use in constructing the date
cal)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

public Date

Returns:

the column value as a java.sql.Date object; if the value is SQL NULL, the value returned is null in the Java programming language
getDate(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Calendar
the java.util.Calendar object to use in constructing the date
cal)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

public double

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getDouble(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

public double

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getDouble(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

public int

Returns:

the current fetch direction for this ResultSet object
getFetchDirection()

Retrieves the fetch direction for this ResultSet object.

public int

Returns:

the current fetch size for this ResultSet object
getFetchSize()

Retrieves the fetch size for this ResultSet object.

public float

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getFloat(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

public float

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getFloat(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

public int

Returns:

either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
getHoldability()

Retrieves the holdability of this ResultSet object

public int

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getInt(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

public int

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getInt(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

public long

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getLong(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

public long

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getLong(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

public ResultSetMetaData

Returns:

the description of this ResultSet object's columns
getMetaData()

Retrieves the number, types and properties of this ResultSet object's columns.

public Reader

Returns:

a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language.
getNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public Reader

Returns:

a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language
getNCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public NClob

Returns:

a NClob object representing the SQL NCLOB value in the specified column
getNClob(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.

public NClob

Returns:

a NClob object representing the SQL NCLOB value in the specified column
getNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.

public String

Returns:

the column value; if the value is SQL NULL, the value returned is null
getNString(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

public String

Returns:

the column value; if the value is SQL NULL, the value returned is null
getNString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

public Object

Returns:

a java.lang.Object holding the column value
getObject(int
the first column is 1, the second is 2, ...
columnIndex)

Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public Object

Returns:

a java.lang.Object holding the column value
getObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public Object

Returns:

an Object in the Java programming language representing the SQL value
getObject(int
the first column is 1, the second is 2, ...
columnIndex, Map<String, Class<?>>
a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
map)

Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public Object

Returns:

an Object representing the SQL value in the specified column
getObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Map<String, Class<?>>
a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
map)

Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public <
the type of the class modeled by this Class object
T> T

Returns:

an instance of type holding the column value
getObject(int
the first column is 1, the second is 2, ...
columnIndex, Class<T>
Class representing the Java data type to convert the designated column to.
type)

Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.

public <
the type of the class modeled by this Class object
T> T

Returns:

an instance of type holding the column value
getObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Class<T>
Class representing the Java data type to convert the designated column to.
type)

Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.

public Ref

Returns:

a Ref object representing an SQL REF value
getRef(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.

public Ref

Returns:

a Ref object representing the SQL REF value in the specified column
getRef(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.

public int

Returns:

the current row number; 0 if there is no current row
getRow()

Retrieves the current row number.

public RowId

Returns:

the column value; if the value is a SQL NULL the value returned is null
getRowId(int
the first column is 1, the second 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.

public RowId

Returns:

the column value ; if the value is a SQL NULL the value returned is null
getRowId(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.

public short

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getShort(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

public short

Returns:

the column value; if the value is SQL NULL, the value returned is 0
getShort(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

public SQLXML

Returns:

a SQLXML object that maps an SQL XML value
getSQLXML(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.

public SQLXML

Returns:

a SQLXML object that maps an SQL XML value
getSQLXML(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.

public Statement

Returns:

the Statement object that produced this ResultSet object or null if the result set was produced some other way
getStatement()

Retrieves the Statement object that produced this ResultSet object.

public String

Returns:

the column value; if the value is SQL NULL, the value returned is null
getString(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

public String

Returns:

the column value; if the value is SQL NULL, the value returned is null
getString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

public Time

Returns:

the column value; if the value is SQL NULL, the value returned is null
getTime(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

public Time

Returns:

the column value; if the value is SQL NULL, the value returned is null
getTime(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

public Time

Returns:

the column value as a java.sql.Time object; if the value is SQL NULL, the value returned is null in the Java programming language
getTime(int
the first column is 1, the second is 2, ...
columnIndex, Calendar
the java.util.Calendar object to use in constructing the time
cal)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

public Time

Returns:

the column value as a java.sql.Time object; if the value is SQL NULL, the value returned is null in the Java programming language
getTime(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Calendar
the java.util.Calendar object to use in constructing the time
cal)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

public Timestamp

Returns:

the column value; if the value is SQL NULL, the value returned is null
getTimestamp(int
the first column is 1, the second is 2, ...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

public Timestamp

Returns:

the column value; if the value is SQL NULL, the value returned is null
getTimestamp(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

public Timestamp

Returns:

the column value as a java.sql.Timestamp object; if the value is SQL NULL, the value returned is null in the Java programming language
getTimestamp(int
the first column is 1, the second is 2, ...
columnIndex, Calendar
the java.util.Calendar object to use in constructing the timestamp
cal)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

public Timestamp

Returns:

the column value as a java.sql.Timestamp object; if the value is SQL NULL, the value returned is null in the Java programming language
getTimestamp(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Calendar
the java.util.Calendar object to use in constructing the date
cal)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

public int

Returns:

ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
getType()

Retrieves the type of this ResultSet object.

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of two-byte Unicode characters; if the value is SQL NULL, the value returned is null
getUnicodeStream(int
the first column is 1, the second is 2, ...
columnIndex)
Deprecated since 1.2. use getCharacterStream in place of getUnicodeStream

Retrieves the value of the designated column in the current row of this ResultSet object as as a stream of two-byte 3 characters.

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQL NULL, the value returned is null.
getUnicodeStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)
Deprecated since 1.2. use getCharacterStream instead

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of two-byte Unicode characters.

public URL

Returns:

the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language
getURL(int
the index of the column 1 is the first, 2 is the second,...
columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.

public URL

Returns:

the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language
getURL(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.

public SQLWarning

Returns:

the first SQLWarning object reported or null if there are none
getWarnings()

Retrieves the first warning reported by calls on this ResultSet object.

public void
insertRow()

Inserts the contents of the insert row into this ResultSet object and into the database.

public boolean

Returns:

true if the cursor is after the last row; false if the cursor is at any other position or the result set contains no rows
isAfterLast()

Retrieves whether the cursor is after the last row in this ResultSet object.

public boolean

Returns:

true if the cursor is before the first row; false if the cursor is at any other position or the result set contains no rows
isBeforeFirst()

Retrieves whether the cursor is before the first row in this ResultSet object.

public boolean

Returns:

true if this ResultSet object is closed; false if it is still open
isClosed()

Retrieves whether this ResultSet object has been closed.

public boolean

Returns:

true if the cursor is on the first row; false otherwise
isFirst()

Retrieves whether the cursor is on the first row of this ResultSet object.

public boolean

Returns:

true if the cursor is on the last row; false otherwise
isLast()

Retrieves whether the cursor is on the last row of this ResultSet object

Note

Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.

public boolean

Returns:

true if the cursor is on a valid row; false if there are no rows in the result set
last()

Moves the cursor to the last row in this ResultSet object.

public void
moveToCurrentRow()

Moves the cursor to the remembered cursor position, usually the current row.

public void
moveToInsertRow()

Moves the cursor to the insert row.

public boolean

Returns:

true if the new current row is valid; false if there are no more rows
next()

Moves the cursor forward one row from its current position.

public boolean

Returns:

true if the cursor is now positioned on a valid row; false if the cursor is positioned before the first row
previous()

Moves the cursor to the previous row in this ResultSet object.

public void
refreshRow()

Refreshes the current row with its most recent value in the database.

public boolean

Returns:

true if the cursor is on a row; false otherwise
relative(int
an int specifying the number of rows to move from the current row; a positive number moves the cursor forward; a negative number moves the cursor backward
rows)

Moves the cursor a relative number of rows, either positive or negative.

public boolean

Returns:

true if the current row is detected to have been deleted by the owner or another; false otherwise
rowDeleted()

Retrieves whether a row has been deleted.

public boolean

Returns:

true if the current row is detected to have been inserted; false otherwise
rowInserted()

Retrieves whether the current row has had an insertion.

public boolean

Returns:

true if the current row is detected to have been visibly updated by the owner or another; false otherwise
rowUpdated()

Retrieves whether the current row has been updated.

public void
setFetchDirection(int
an int specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
direction)

Gives a hint as to the direction in which the rows in this ResultSet object will be processed.

public void
setFetchSize(int
the number of rows to fetch
rows)

Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object.

public void
updateArray(int
the first column is 1, the second is 2, ...
columnIndex, Array
the new column value
x)

Updates the designated column with a java.sql.Array value.

public void
updateArray(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Array
the new column value
x)

Updates the designated column with a java.sql.Array value.

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x, int
the length of the stream
length)

Updates the designated column with an ascii stream value, which will have the specified number of bytes.

public void
updateAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, InputStream
the new column value
x, int
the length of the stream
length)

Updates the designated column with an ascii stream value, which will have the specified number of bytes.

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x, long
the length of the stream
length)

Updates the designated column with an ascii stream value, which will have the specified number of bytes.

public void
updateAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, InputStream
the new column value
x, long
the length of the stream
length)

Updates the designated column with an ascii stream value, which will have the specified number of bytes.

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x)

Updates the designated column with an ascii stream value.

public void
updateAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, InputStream
the new column value
x)

Updates the designated column with an ascii stream value.

public void
updateBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex, BigDecimal
the new column value
x)

Updates the designated column with a java.math.BigDecimal value.

public void
updateBigDecimal(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, BigDecimal
the new column value
x)

Updates the designated column with a java.sql.BigDecimal value.

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x, int
the length of the stream
length)

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, InputStream
the new column value
x, int
the length of the stream
length)

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x, long
the length of the stream
length)

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, InputStream
the new column value
x, long
the length of the stream
length)

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x)

Updates the designated column with a binary stream value.

public void
updateBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, InputStream
the new column value
x)

Updates the designated column with a binary stream value.

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex, Blob
the new column value
x)

Updates the designated column with a java.sql.Blob value.

public void
updateBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Blob
the new column value
x)

Updates the designated column with a java.sql.Blob value.

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
An object that contains the data to set the parameter value to.
inputStream, long
the number of bytes in the parameter data.
length)

Updates the designated column using the given input stream, which will have the specified number of bytes.

public void
updateBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, InputStream
An object that contains the data to set the parameter value to.
inputStream, long
the number of bytes in the parameter data.
length)

Updates the designated column using the given input stream, which will have the specified number of bytes.

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
An object that contains the data to set the parameter value to.
inputStream)

Updates the designated column using the given input stream.

public void
updateBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, InputStream
An object that contains the data to set the parameter value to.
inputStream)

Updates the designated column using the given input stream.

public void
updateBoolean(int
the first column is 1, the second is 2, ...
columnIndex, boolean
the new column value
x)

Updates the designated column with a boolean value.

public void
updateBoolean(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, boolean
the new column value
x)

Updates the designated column with a boolean value.

public void
updateByte(int
the first column is 1, the second is 2, ...
columnIndex, byte
the new column value
x)

Updates the designated column with a byte value.

public void
updateByte(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, byte
the new column value
x)

Updates the designated column with a byte value.

public void
updateBytes(int
the first column is 1, the second is 2, ...
columnIndex, byte[]
the new column value
x)

Updates the designated column with a byte array value.

public void
updateBytes(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, byte[]
the new column value
x)

Updates the designated column with a byte array value.

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex, Reader
the new column value
x, int
the length of the stream
length)

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Reader
the java.io.Reader object containing the new column value
reader, int
the length of the stream
length)

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex, Reader
the new column value
x, long
the length of the stream
length)

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Reader
the java.io.Reader object containing the new column value
reader, long
the length of the stream
length)

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex, Reader
the new column value
x)

Updates the designated column with a character stream value.

public void
updateCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Reader
the java.io.Reader object containing the new column value
reader)

Updates the designated column with a character stream value.

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex, Clob
the new column value
x)

Updates the designated column with a java.sql.Clob value.

public void
updateClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Clob
the new column value
x)

Updates the designated column with a java.sql.Clob value.

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex, Reader
An object that contains the data to set the parameter value to.
reader, long
the number of characters in the parameter data.
length)

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Reader
An object that contains the data to set the parameter value to.
reader, long
the number of characters in the parameter data.
length)

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex, Reader
An object that contains the data to set the parameter value to.
reader)

Updates the designated column using the given Reader object.

public void
updateClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Reader
An object that contains the data to set the parameter value to.
reader)

Updates the designated column using the given Reader object.

public void
updateDate(int
the first column is 1, the second is 2, ...
columnIndex, Date
the new column value
x)

Updates the designated column with a java.sql.Date value.

public void
updateDate(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Date
the new column value
x)

Updates the designated column with a java.sql.Date value.

public void
updateDouble(int
the first column is 1, the second is 2, ...
columnIndex, double
the new column value
x)

Updates the designated column with a double value.

public void
updateDouble(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, double
the new column value
x)

Updates the designated column with a double value.

public void
updateFloat(int
the first column is 1, the second is 2, ...
columnIndex, float
the new column value
x)

Updates the designated column with a float value.

public void
updateFloat(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, float
the new column value
x)

Updates the designated column with a float value.

public void
updateInt(int
the first column is 1, the second is 2, ...
columnIndex, int
the new column value
x)

Updates the designated column with an int value.

public void
updateInt(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, int
the new column value
x)

Updates the designated column with an int value.

public void
updateLong(int
the first column is 1, the second is 2, ...
columnIndex, long
the new column value
x)

Updates the designated column with a long value.

public void
updateLong(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, long
the new column value
x)

Updates the designated column with a long value.

public void
updateNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex, Reader
the new column value
x, long
the length of the stream
length)

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateNCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Reader
the java.io.Reader object containing the new column value
reader, long
the length of the stream
length)

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex, Reader
the new column value
x)

Updates the designated column with a character stream value.

public void
updateNCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Reader
the java.io.Reader object containing the new column value
reader)

Updates the designated column with a character stream value.

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex, NClob
the value for the column to be updated
nClob)

Updates the designated column with a java.sql.NClob value.

public void
updateNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, NClob
the value for the column to be updated
nClob)

Updates the designated column with a java.sql.NClob value.

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex, Reader
An object that contains the data to set the parameter value to.
reader, long
the number of characters in the parameter data.
length)

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Reader
An object that contains the data to set the parameter value to.
reader, long
the number of characters in the parameter data.
length)

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex, Reader
An object that contains the data to set the parameter value to.
reader)

Updates the designated column using the given Reader The data will be read from the stream as needed until end-of-stream is reached.

public void
updateNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Reader
An object that contains the data to set the parameter value to.
reader)

Updates the designated column using the given Reader object.

public void
updateNString(int
the first column is 1, the second 2, ...
columnIndex, String
the value for the column to be updated
nString)

Updates the designated column with a String value.

public void
updateNString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, String
the value for the column to be updated
nString)

Updates the designated column with a String value.

public void
updateNull(int
the first column is 1, the second is 2, ...
columnIndex)

Updates the designated column with a null value.

public void
updateNull(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel)

Updates the designated column with a null value.

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex, Object
the new column value
x, int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scaleOrLength)

Updates the designated column with an Object value.

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex, Object
the new column value
x)

Updates the designated column with an Object value.

public void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Object
the new column value
x, int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scaleOrLength)

Updates the designated column with an Object value.

public void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Object
the new column value
x)

Updates the designated column with an Object value.

public default void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex, Object
the new column value
x, SQLType
the SQL type to be sent to the database
targetSqlType, int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scaleOrLength)

Updates the designated column with an Object value.

public default void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Object
the new column value
x, SQLType
the SQL type to be sent to the database
targetSqlType, int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scaleOrLength)

Updates the designated column with an Object value.

public default void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex, Object
the new column value
x, SQLType
the SQL type to be sent to the database
targetSqlType)

Updates the designated column with an Object value.

public default void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Object
the new column value
x, SQLType
the SQL type to be sent to the database
targetSqlType)

Updates the designated column with an Object value.

public void
updateRef(int
the first column is 1, the second is 2, ...
columnIndex, Ref
the new column value
x)

Updates the designated column with a java.sql.Ref value.

public void
updateRef(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Ref
the new column value
x)

Updates the designated column with a java.sql.Ref value.

public void
updateRow()

Updates the underlying database with the new contents of the current row of this ResultSet object.

public void
updateRowId(int
the first column is 1, the second 2, ...
columnIndex, RowId
the column value
x)

Updates the designated column with a RowId value.

public void
updateRowId(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, RowId
the column value
x)

Updates the designated column with a RowId value.

public void
updateShort(int
the first column is 1, the second is 2, ...
columnIndex, short
the new column value
x)

Updates the designated column with a short value.

public void
updateShort(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, short
the new column value
x)

Updates the designated column with a short value.

public void
updateSQLXML(int
the first column is 1, the second 2, ...
columnIndex, SQLXML
the value for the column to be updated
xmlObject)

Updates the designated column with a java.sql.SQLXML value.

public void
updateSQLXML(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, SQLXML
the column value
xmlObject)

Updates the designated column with a java.sql.SQLXML value.

public void
updateString(int
the first column is 1, the second is 2, ...
columnIndex, String
the new column value
x)

Updates the designated column with a String value.

public void
updateString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, String
the new column value
x)

Updates the designated column with a String value.

public void
updateTime(int
the first column is 1, the second is 2, ...
columnIndex, Time
the new column value
x)

Updates the designated column with a java.sql.Time value.

public void
updateTime(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Time
the new column value
x)

Updates the designated column with a java.sql.Time value.

public void
updateTimestamp(int
the first column is 1, the second is 2, ...
columnIndex, Timestamp
the new column value
x)

Updates the designated column with a java.sql.Timestamp value.

public void
updateTimestamp(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel, Timestamp
the new column value
x)

Updates the designated column with a java.sql.Timestamp value.

public boolean

Returns:

true if the last column value read was SQL NULL and false otherwise
wasNull()

Reports whether the last column read had a value of SQL NULL.

Inherited from java.sql.Wrapper:
isWrapperForunwrap