ResultSet (Java Platform SE 7 ) (original) (raw)
Modifier and Type
Method and Description
boolean
**[absolute](../../java/sql/ResultSet.html#absolute%28int%29)**(int row)
Moves the cursor to the given row number in this ResultSet
object.
void
**[afterLast](../../java/sql/ResultSet.html#afterLast%28%29)**()
Moves the cursor to the end of this ResultSet
object, just after the last row.
void
**[beforeFirst](../../java/sql/ResultSet.html#beforeFirst%28%29)**()
Moves the cursor to the front of this ResultSet
object, just before the first row.
void
**[cancelRowUpdates](../../java/sql/ResultSet.html#cancelRowUpdates%28%29)**()
Cancels the updates made to the current row in thisResultSet
object.
void
**[clearWarnings](../../java/sql/ResultSet.html#clearWarnings%28%29)**()
Clears all warnings reported on this ResultSet
object.
void
**[close](../../java/sql/ResultSet.html#close%28%29)**()
Releases this ResultSet
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
void
**[deleteRow](../../java/sql/ResultSet.html#deleteRow%28%29)**()
Deletes the current row from this ResultSet
object and from the underlying database.
int
**[findColumn](../../java/sql/ResultSet.html#findColumn%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Maps the given ResultSet
column label to itsResultSet
column index.
boolean
**[first](../../java/sql/ResultSet.html#first%28%29)**()
Moves the cursor to the first row in this ResultSet
object.
[Array](../../java/sql/Array.html "interface in java.sql")
**[getArray](../../java/sql/ResultSet.html#getArray%28int%29)**(int 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.
[Array](../../java/sql/Array.html "interface in java.sql")
**[getArray](../../java/sql/ResultSet.html#getArray%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
[InputStream](../../java/io/InputStream.html "class in java.io")
**[getAsciiStream](../../java/sql/ResultSet.html#getAsciiStream%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a stream of ASCII characters.
[InputStream](../../java/io/InputStream.html "class in java.io")
**[getAsciiStream](../../java/sql/ResultSet.html#getAsciiStream%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a stream of ASCII characters.
[BigDecimal](../../java/math/BigDecimal.html "class in java.math")
**[getBigDecimal](../../java/sql/ResultSet.html#getBigDecimal%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as ajava.math.BigDecimal
with full precision.
[BigDecimal](../../java/math/BigDecimal.html "class in java.math")
**[getBigDecimal](../../java/sql/ResultSet.html#getBigDecimal%28int,%20int%29)**(int columnIndex, int scale)
Deprecated.
[BigDecimal](../../java/math/BigDecimal.html "class in java.math")
**[getBigDecimal](../../java/sql/ResultSet.html#getBigDecimal%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as ajava.math.BigDecimal
with full precision.
[BigDecimal](../../java/math/BigDecimal.html "class in java.math")
**[getBigDecimal](../../java/sql/ResultSet.html#getBigDecimal%28java.lang.String,%20int%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel, int scale)
Deprecated.
[InputStream](../../java/io/InputStream.html "class in java.io")
**[getBinaryStream](../../java/sql/ResultSet.html#getBinaryStream%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a stream of uninterpreted bytes.
[InputStream](../../java/io/InputStream.html "class in java.io")
**[getBinaryStream](../../java/sql/ResultSet.html#getBinaryStream%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a stream of uninterpretedbyte
s.
[Blob](../../java/sql/Blob.html "interface in java.sql")
**[getBlob](../../java/sql/ResultSet.html#getBlob%28int%29)**(int 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.
[Blob](../../java/sql/Blob.html "interface in java.sql")
**[getBlob](../../java/sql/ResultSet.html#getBlob%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
boolean
**[getBoolean](../../java/sql/ResultSet.html#getBoolean%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a boolean
in the Java programming language.
boolean
**[getBoolean](../../java/sql/ResultSet.html#getBoolean%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a boolean
in the Java programming language.
byte
**[getByte](../../java/sql/ResultSet.html#getByte%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a byte
in the Java programming language.
byte
**[getByte](../../java/sql/ResultSet.html#getByte%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a byte
in the Java programming language.
byte[]
**[getBytes](../../java/sql/ResultSet.html#getBytes%28int%29)**(int 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.
byte[]
**[getBytes](../../java/sql/ResultSet.html#getBytes%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
[Reader](../../java/io/Reader.html "class in java.io")
**[getCharacterStream](../../java/sql/ResultSet.html#getCharacterStream%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as ajava.io.Reader
object.
[Reader](../../java/io/Reader.html "class in java.io")
**[getCharacterStream](../../java/sql/ResultSet.html#getCharacterStream%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as ajava.io.Reader
object.
[Clob](../../java/sql/Clob.html "interface in java.sql")
**[getClob](../../java/sql/ResultSet.html#getClob%28int%29)**(int 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.
[Clob](../../java/sql/Clob.html "interface in java.sql")
**[getClob](../../java/sql/ResultSet.html#getClob%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
int
**[getConcurrency](../../java/sql/ResultSet.html#getConcurrency%28%29)**()
Retrieves the concurrency mode of this ResultSet
object.
[String](../../java/lang/String.html "class in java.lang")
**[getCursorName](../../java/sql/ResultSet.html#getCursorName%28%29)**()
Retrieves the name of the SQL cursor used by this ResultSet
object.
[Date](../../java/sql/Date.html "class in java.sql")
**[getDate](../../java/sql/ResultSet.html#getDate%28int%29)**(int 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.
[Date](../../java/sql/Date.html "class in java.sql")
**[getDate](../../java/sql/ResultSet.html#getDate%28int,%20java.util.Calendar%29)**(int columnIndex,[Calendar](../../java/util/Calendar.html "class in java.util") 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.
[Date](../../java/sql/Date.html "class in java.sql")
**[getDate](../../java/sql/ResultSet.html#getDate%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
[Date](../../java/sql/Date.html "class in java.sql")
**[getDate](../../java/sql/ResultSet.html#getDate%28java.lang.String,%20java.util.Calendar%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Calendar](../../java/util/Calendar.html "class in java.util") 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.
double
**[getDouble](../../java/sql/ResultSet.html#getDouble%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a double
in the Java programming language.
double
**[getDouble](../../java/sql/ResultSet.html#getDouble%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a double
in the Java programming language.
int
**[getFetchDirection](../../java/sql/ResultSet.html#getFetchDirection%28%29)**()
Retrieves the fetch direction for thisResultSet
object.
int
**[getFetchSize](../../java/sql/ResultSet.html#getFetchSize%28%29)**()
Retrieves the fetch size for thisResultSet
object.
float
**[getFloat](../../java/sql/ResultSet.html#getFloat%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a float
in the Java programming language.
float
**[getFloat](../../java/sql/ResultSet.html#getFloat%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a float
in the Java programming language.
int
**[getHoldability](../../java/sql/ResultSet.html#getHoldability%28%29)**()
Retrieves the holdability of this ResultSet
object
int
**[getInt](../../java/sql/ResultSet.html#getInt%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as an int
in the Java programming language.
int
**[getInt](../../java/sql/ResultSet.html#getInt%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as an int
in the Java programming language.
long
**[getLong](../../java/sql/ResultSet.html#getLong%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a long
in the Java programming language.
long
**[getLong](../../java/sql/ResultSet.html#getLong%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a long
in the Java programming language.
[ResultSetMetaData](../../java/sql/ResultSetMetaData.html "interface in java.sql")
**[getMetaData](../../java/sql/ResultSet.html#getMetaData%28%29)**()
Retrieves the number, types and properties of this ResultSet
object's columns.
[Reader](../../java/io/Reader.html "class in java.io")
**[getNCharacterStream](../../java/sql/ResultSet.html#getNCharacterStream%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as ajava.io.Reader
object.
[Reader](../../java/io/Reader.html "class in java.io")
**[getNCharacterStream](../../java/sql/ResultSet.html#getNCharacterStream%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as ajava.io.Reader
object.
[NClob](../../java/sql/NClob.html "interface in java.sql")
**[getNClob](../../java/sql/ResultSet.html#getNClob%28int%29)**(int 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.
[NClob](../../java/sql/NClob.html "interface in java.sql")
**[getNClob](../../java/sql/ResultSet.html#getNClob%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
[String](../../java/lang/String.html "class in java.lang")
**[getNString](../../java/sql/ResultSet.html#getNString%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a String
in the Java programming language.
[String](../../java/lang/String.html "class in java.lang")
**[getNString](../../java/sql/ResultSet.html#getNString%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a String
in the Java programming language.
[Object](../../java/lang/Object.html "class in java.lang")
**[getObject](../../java/sql/ResultSet.html#getObject%28int%29)**(int columnIndex)
Gets the value of the designated column in the current row of this ResultSet
object as an Object
in the Java programming language.
<T> T
**[getObject](../../java/sql/ResultSet.html#getObject%28int,%20java.lang.Class%29)**(int columnIndex,[Class](../../java/lang/Class.html "class in java.lang")<T> 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.
[Object](../../java/lang/Object.html "class in java.lang")
**[getObject](../../java/sql/ResultSet.html#getObject%28int,%20java.util.Map%29)**(int columnIndex,[Map](../../java/util/Map.html "interface in java.util")<[String](../../java/lang/String.html "class in java.lang"),[Class](../../java/lang/Class.html "class in java.lang")<?>> map)
Retrieves the value of the designated column in the current row of this ResultSet
object as an Object
in the Java programming language.
[Object](../../java/lang/Object.html "class in java.lang")
**[getObject](../../java/sql/ResultSet.html#getObject%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Gets the value of the designated column in the current row of this ResultSet
object as an Object
in the Java programming language.
<T> T
**[getObject](../../java/sql/ResultSet.html#getObject%28java.lang.String,%20java.lang.Class%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Class](../../java/lang/Class.html "class in java.lang")<T> 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.
[Object](../../java/lang/Object.html "class in java.lang")
**[getObject](../../java/sql/ResultSet.html#getObject%28java.lang.String,%20java.util.Map%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Map](../../java/util/Map.html "interface in java.util")<[String](../../java/lang/String.html "class in java.lang"),[Class](../../java/lang/Class.html "class in java.lang")<?>> map)
Retrieves the value of the designated column in the current row of this ResultSet
object as an Object
in the Java programming language.
[Ref](../../java/sql/Ref.html "interface in java.sql")
**[getRef](../../java/sql/ResultSet.html#getRef%28int%29)**(int 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.
[Ref](../../java/sql/Ref.html "interface in java.sql")
**[getRef](../../java/sql/ResultSet.html#getRef%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
int
**[getRow](../../java/sql/ResultSet.html#getRow%28%29)**()
Retrieves the current row number.
[RowId](../../java/sql/RowId.html "interface in java.sql")
**[getRowId](../../java/sql/ResultSet.html#getRowId%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as a java.sql.RowId
object in the Java programming language.
[RowId](../../java/sql/RowId.html "interface in java.sql")
**[getRowId](../../java/sql/ResultSet.html#getRowId%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of thisResultSet
object as a java.sql.RowId
object in the Java programming language.
short
**[getShort](../../java/sql/ResultSet.html#getShort%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a short
in the Java programming language.
short
**[getShort](../../java/sql/ResultSet.html#getShort%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a short
in the Java programming language.
[SQLXML](../../java/sql/SQLXML.html "interface in java.sql")
**[getSQLXML](../../java/sql/ResultSet.html#getSQLXML%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
as ajava.sql.SQLXML
object in the Java programming language.
[SQLXML](../../java/sql/SQLXML.html "interface in java.sql")
**[getSQLXML](../../java/sql/ResultSet.html#getSQLXML%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
as ajava.sql.SQLXML
object in the Java programming language.
[Statement](../../java/sql/Statement.html "interface in java.sql")
**[getStatement](../../java/sql/ResultSet.html#getStatement%28%29)**()
Retrieves the Statement
object that produced thisResultSet
object.
[String](../../java/lang/String.html "class in java.lang")
**[getString](../../java/sql/ResultSet.html#getString%28int%29)**(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet
object as a String
in the Java programming language.
[String](../../java/lang/String.html "class in java.lang")
**[getString](../../java/sql/ResultSet.html#getString%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet
object as a String
in the Java programming language.
[Time](../../java/sql/Time.html "class in java.sql")
**[getTime](../../java/sql/ResultSet.html#getTime%28int%29)**(int 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.
[Time](../../java/sql/Time.html "class in java.sql")
**[getTime](../../java/sql/ResultSet.html#getTime%28int,%20java.util.Calendar%29)**(int columnIndex,[Calendar](../../java/util/Calendar.html "class in java.util") 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.
[Time](../../java/sql/Time.html "class in java.sql")
**[getTime](../../java/sql/ResultSet.html#getTime%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
[Time](../../java/sql/Time.html "class in java.sql")
**[getTime](../../java/sql/ResultSet.html#getTime%28java.lang.String,%20java.util.Calendar%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Calendar](../../java/util/Calendar.html "class in java.util") 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.
[Timestamp](../../java/sql/Timestamp.html "class in java.sql")
**[getTimestamp](../../java/sql/ResultSet.html#getTimestamp%28int%29)**(int 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.
[Timestamp](../../java/sql/Timestamp.html "class in java.sql")
**[getTimestamp](../../java/sql/ResultSet.html#getTimestamp%28int,%20java.util.Calendar%29)**(int columnIndex,[Calendar](../../java/util/Calendar.html "class in java.util") 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.
[Timestamp](../../java/sql/Timestamp.html "class in java.sql")
**[getTimestamp](../../java/sql/ResultSet.html#getTimestamp%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
[Timestamp](../../java/sql/Timestamp.html "class in java.sql")
**[getTimestamp](../../java/sql/ResultSet.html#getTimestamp%28java.lang.String,%20java.util.Calendar%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Calendar](../../java/util/Calendar.html "class in java.util") 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.
int
**[getType](../../java/sql/ResultSet.html#getType%28%29)**()
Retrieves the type of this ResultSet
object.
[InputStream](../../java/io/InputStream.html "class in java.io")
**[getUnicodeStream](../../java/sql/ResultSet.html#getUnicodeStream%28int%29)**(int columnIndex)
Deprecated.
use getCharacterStream
in place ofgetUnicodeStream
[InputStream](../../java/io/InputStream.html "class in java.io")
**[getUnicodeStream](../../java/sql/ResultSet.html#getUnicodeStream%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Deprecated.
use getCharacterStream
instead
[URL](../../java/net/URL.html "class in java.net")
**[getURL](../../java/sql/ResultSet.html#getURL%28int%29)**(int 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.
[URL](../../java/net/URL.html "class in java.net")
**[getURL](../../java/sql/ResultSet.html#getURL%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") 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.
[SQLWarning](../../java/sql/SQLWarning.html "class in java.sql")
**[getWarnings](../../java/sql/ResultSet.html#getWarnings%28%29)**()
Retrieves the first warning reported by calls on thisResultSet
object.
void
**[insertRow](../../java/sql/ResultSet.html#insertRow%28%29)**()
Inserts the contents of the insert row into thisResultSet
object and into the database.
boolean
**[isAfterLast](../../java/sql/ResultSet.html#isAfterLast%28%29)**()
Retrieves whether the cursor is after the last row in this ResultSet
object.
boolean
**[isBeforeFirst](../../java/sql/ResultSet.html#isBeforeFirst%28%29)**()
Retrieves whether the cursor is before the first row in this ResultSet
object.
boolean
**[isClosed](../../java/sql/ResultSet.html#isClosed%28%29)**()
Retrieves whether this ResultSet
object has been closed.
boolean
**[isFirst](../../java/sql/ResultSet.html#isFirst%28%29)**()
Retrieves whether the cursor is on the first row of this ResultSet
object.
boolean
**[isLast](../../java/sql/ResultSet.html#isLast%28%29)**()
Retrieves whether the cursor is on the last row of this ResultSet
object.
boolean
**[last](../../java/sql/ResultSet.html#last%28%29)**()
Moves the cursor to the last row in this ResultSet
object.
void
**[moveToCurrentRow](../../java/sql/ResultSet.html#moveToCurrentRow%28%29)**()
Moves the cursor to the remembered cursor position, usually the current row.
void
**[moveToInsertRow](../../java/sql/ResultSet.html#moveToInsertRow%28%29)**()
Moves the cursor to the insert row.
boolean
**[next](../../java/sql/ResultSet.html#next%28%29)**()
Moves the cursor froward one row from its current position.
boolean
**[previous](../../java/sql/ResultSet.html#previous%28%29)**()
Moves the cursor to the previous row in thisResultSet
object.
void
**[refreshRow](../../java/sql/ResultSet.html#refreshRow%28%29)**()
Refreshes the current row with its most recent value in the database.
boolean
**[relative](../../java/sql/ResultSet.html#relative%28int%29)**(int rows)
Moves the cursor a relative number of rows, either positive or negative.
boolean
**[rowDeleted](../../java/sql/ResultSet.html#rowDeleted%28%29)**()
Retrieves whether a row has been deleted.
boolean
**[rowInserted](../../java/sql/ResultSet.html#rowInserted%28%29)**()
Retrieves whether the current row has had an insertion.
boolean
**[rowUpdated](../../java/sql/ResultSet.html#rowUpdated%28%29)**()
Retrieves whether the current row has been updated.
void
**[setFetchDirection](../../java/sql/ResultSet.html#setFetchDirection%28int%29)**(int direction)
Gives a hint as to the direction in which the rows in thisResultSet
object will be processed.
void
**[setFetchSize](../../java/sql/ResultSet.html#setFetchSize%28int%29)**(int 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 thisResultSet
object.
void
**[updateArray](../../java/sql/ResultSet.html#updateArray%28int,%20java.sql.Array%29)**(int columnIndex,[Array](../../java/sql/Array.html "interface in java.sql") x)
Updates the designated column with a java.sql.Array
value.
void
**[updateArray](../../java/sql/ResultSet.html#updateArray%28java.lang.String,%20java.sql.Array%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Array](../../java/sql/Array.html "interface in java.sql") x)
Updates the designated column with a java.sql.Array
value.
void
**[updateAsciiStream](../../java/sql/ResultSet.html#updateAsciiStream%28int,%20java.io.InputStream%29)**(int columnIndex,[InputStream](../../java/io/InputStream.html "class in java.io") x)
Updates the designated column with an ascii stream value.
void
**[updateAsciiStream](../../java/sql/ResultSet.html#updateAsciiStream%28int,%20java.io.InputStream,%20int%29)**(int columnIndex,[InputStream](../../java/io/InputStream.html "class in java.io") x, int length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void
**[updateAsciiStream](../../java/sql/ResultSet.html#updateAsciiStream%28int,%20java.io.InputStream,%20long%29)**(int columnIndex,[InputStream](../../java/io/InputStream.html "class in java.io") x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void
**[updateAsciiStream](../../java/sql/ResultSet.html#updateAsciiStream%28java.lang.String,%20java.io.InputStream%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[InputStream](../../java/io/InputStream.html "class in java.io") x)
Updates the designated column with an ascii stream value.
void
**[updateAsciiStream](../../java/sql/ResultSet.html#updateAsciiStream%28java.lang.String,%20java.io.InputStream,%20int%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[InputStream](../../java/io/InputStream.html "class in java.io") x, int length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void
**[updateAsciiStream](../../java/sql/ResultSet.html#updateAsciiStream%28java.lang.String,%20java.io.InputStream,%20long%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[InputStream](../../java/io/InputStream.html "class in java.io") x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void
**[updateBigDecimal](../../java/sql/ResultSet.html#updateBigDecimal%28int,%20java.math.BigDecimal%29)**(int columnIndex,[BigDecimal](../../java/math/BigDecimal.html "class in java.math") x)
Updates the designated column with a java.math.BigDecimal
value.
void
**[updateBigDecimal](../../java/sql/ResultSet.html#updateBigDecimal%28java.lang.String,%20java.math.BigDecimal%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[BigDecimal](../../java/math/BigDecimal.html "class in java.math") x)
Updates the designated column with a java.sql.BigDecimal
value.
void
**[updateBinaryStream](../../java/sql/ResultSet.html#updateBinaryStream%28int,%20java.io.InputStream%29)**(int columnIndex,[InputStream](../../java/io/InputStream.html "class in java.io") x)
Updates the designated column with a binary stream value.
void
**[updateBinaryStream](../../java/sql/ResultSet.html#updateBinaryStream%28int,%20java.io.InputStream,%20int%29)**(int columnIndex,[InputStream](../../java/io/InputStream.html "class in java.io") x, int length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.
void
**[updateBinaryStream](../../java/sql/ResultSet.html#updateBinaryStream%28int,%20java.io.InputStream,%20long%29)**(int columnIndex,[InputStream](../../java/io/InputStream.html "class in java.io") x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.
void
**[updateBinaryStream](../../java/sql/ResultSet.html#updateBinaryStream%28java.lang.String,%20java.io.InputStream%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[InputStream](../../java/io/InputStream.html "class in java.io") x)
Updates the designated column with a binary stream value.
void
**[updateBinaryStream](../../java/sql/ResultSet.html#updateBinaryStream%28java.lang.String,%20java.io.InputStream,%20int%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[InputStream](../../java/io/InputStream.html "class in java.io") x, int length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.
void
**[updateBinaryStream](../../java/sql/ResultSet.html#updateBinaryStream%28java.lang.String,%20java.io.InputStream,%20long%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[InputStream](../../java/io/InputStream.html "class in java.io") x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.
void
**[updateBlob](../../java/sql/ResultSet.html#updateBlob%28int,%20java.sql.Blob%29)**(int columnIndex,[Blob](../../java/sql/Blob.html "interface in java.sql") x)
Updates the designated column with a java.sql.Blob
value.
void
**[updateBlob](../../java/sql/ResultSet.html#updateBlob%28int,%20java.io.InputStream%29)**(int columnIndex,[InputStream](../../java/io/InputStream.html "class in java.io") inputStream)
Updates the designated column using the given input stream.
void
**[updateBlob](../../java/sql/ResultSet.html#updateBlob%28int,%20java.io.InputStream,%20long%29)**(int columnIndex,[InputStream](../../java/io/InputStream.html "class in java.io") inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.
void
**[updateBlob](../../java/sql/ResultSet.html#updateBlob%28java.lang.String,%20java.sql.Blob%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Blob](../../java/sql/Blob.html "interface in java.sql") x)
Updates the designated column with a java.sql.Blob
value.
void
**[updateBlob](../../java/sql/ResultSet.html#updateBlob%28java.lang.String,%20java.io.InputStream%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[InputStream](../../java/io/InputStream.html "class in java.io") inputStream)
Updates the designated column using the given input stream.
void
**[updateBlob](../../java/sql/ResultSet.html#updateBlob%28java.lang.String,%20java.io.InputStream,%20long%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[InputStream](../../java/io/InputStream.html "class in java.io") inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.
void
**[updateBoolean](../../java/sql/ResultSet.html#updateBoolean%28int,%20boolean%29)**(int columnIndex, boolean x)
Updates the designated column with a boolean
value.
void
**[updateBoolean](../../java/sql/ResultSet.html#updateBoolean%28java.lang.String,%20boolean%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel, boolean x)
Updates the designated column with a boolean
value.
void
**[updateByte](../../java/sql/ResultSet.html#updateByte%28int,%20byte%29)**(int columnIndex, byte x)
Updates the designated column with a byte
value.
void
**[updateByte](../../java/sql/ResultSet.html#updateByte%28java.lang.String,%20byte%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel, byte x)
Updates the designated column with a byte
value.
void
**[updateBytes](../../java/sql/ResultSet.html#updateBytes%28int,%20byte[]%29)**(int columnIndex, byte[] x)
Updates the designated column with a byte
array value.
void
**[updateBytes](../../java/sql/ResultSet.html#updateBytes%28java.lang.String,%20byte[]%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel, byte[] x)
Updates the designated column with a byte array value.
void
**[updateCharacterStream](../../java/sql/ResultSet.html#updateCharacterStream%28int,%20java.io.Reader%29)**(int columnIndex,[Reader](../../java/io/Reader.html "class in java.io") x)
Updates the designated column with a character stream value.
void
**[updateCharacterStream](../../java/sql/ResultSet.html#updateCharacterStream%28int,%20java.io.Reader,%20int%29)**(int columnIndex,[Reader](../../java/io/Reader.html "class in java.io") x, int length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void
**[updateCharacterStream](../../java/sql/ResultSet.html#updateCharacterStream%28int,%20java.io.Reader,%20long%29)**(int columnIndex,[Reader](../../java/io/Reader.html "class in java.io") x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void
**[updateCharacterStream](../../java/sql/ResultSet.html#updateCharacterStream%28java.lang.String,%20java.io.Reader%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Reader](../../java/io/Reader.html "class in java.io") reader)
Updates the designated column with a character stream value.
void
**[updateCharacterStream](../../java/sql/ResultSet.html#updateCharacterStream%28java.lang.String,%20java.io.Reader,%20int%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Reader](../../java/io/Reader.html "class in java.io") reader, int length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void
**[updateCharacterStream](../../java/sql/ResultSet.html#updateCharacterStream%28java.lang.String,%20java.io.Reader,%20long%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Reader](../../java/io/Reader.html "class in java.io") reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void
**[updateClob](../../java/sql/ResultSet.html#updateClob%28int,%20java.sql.Clob%29)**(int columnIndex,[Clob](../../java/sql/Clob.html "interface in java.sql") x)
Updates the designated column with a java.sql.Clob
value.
void
**[updateClob](../../java/sql/ResultSet.html#updateClob%28int,%20java.io.Reader%29)**(int columnIndex,[Reader](../../java/io/Reader.html "class in java.io") reader)
Updates the designated column using the given Reader
object.
void
**[updateClob](../../java/sql/ResultSet.html#updateClob%28int,%20java.io.Reader,%20long%29)**(int columnIndex,[Reader](../../java/io/Reader.html "class in java.io") reader, long length)
Updates the designated column using the given Reader
object, which is the given number of characters long.
void
**[updateClob](../../java/sql/ResultSet.html#updateClob%28java.lang.String,%20java.sql.Clob%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Clob](../../java/sql/Clob.html "interface in java.sql") x)
Updates the designated column with a java.sql.Clob
value.
void
**[updateClob](../../java/sql/ResultSet.html#updateClob%28java.lang.String,%20java.io.Reader%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Reader](../../java/io/Reader.html "class in java.io") reader)
Updates the designated column using the given Reader
object.
void
**[updateClob](../../java/sql/ResultSet.html#updateClob%28java.lang.String,%20java.io.Reader,%20long%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Reader](../../java/io/Reader.html "class in java.io") reader, long length)
Updates the designated column using the given Reader
object, which is the given number of characters long.
void
**[updateDate](../../java/sql/ResultSet.html#updateDate%28int,%20java.sql.Date%29)**(int columnIndex,[Date](../../java/sql/Date.html "class in java.sql") x)
Updates the designated column with a java.sql.Date
value.
void
**[updateDate](../../java/sql/ResultSet.html#updateDate%28java.lang.String,%20java.sql.Date%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Date](../../java/sql/Date.html "class in java.sql") x)
Updates the designated column with a java.sql.Date
value.
void
**[updateDouble](../../java/sql/ResultSet.html#updateDouble%28int,%20double%29)**(int columnIndex, double x)
Updates the designated column with a double
value.
void
**[updateDouble](../../java/sql/ResultSet.html#updateDouble%28java.lang.String,%20double%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel, double x)
Updates the designated column with a double
value.
void
**[updateFloat](../../java/sql/ResultSet.html#updateFloat%28int,%20float%29)**(int columnIndex, float x)
Updates the designated column with a float
value.
void
**[updateFloat](../../java/sql/ResultSet.html#updateFloat%28java.lang.String,%20float%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel, float x)
Updates the designated column with a float
value.
void
**[updateInt](../../java/sql/ResultSet.html#updateInt%28int,%20int%29)**(int columnIndex, int x)
Updates the designated column with an int
value.
void
**[updateInt](../../java/sql/ResultSet.html#updateInt%28java.lang.String,%20int%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel, int x)
Updates the designated column with an int
value.
void
**[updateLong](../../java/sql/ResultSet.html#updateLong%28int,%20long%29)**(int columnIndex, long x)
Updates the designated column with a long
value.
void
**[updateLong](../../java/sql/ResultSet.html#updateLong%28java.lang.String,%20long%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel, long x)
Updates the designated column with a long
value.
void
**[updateNCharacterStream](../../java/sql/ResultSet.html#updateNCharacterStream%28int,%20java.io.Reader%29)**(int columnIndex,[Reader](../../java/io/Reader.html "class in java.io") x)
Updates the designated column with a character stream value.
void
**[updateNCharacterStream](../../java/sql/ResultSet.html#updateNCharacterStream%28int,%20java.io.Reader,%20long%29)**(int columnIndex,[Reader](../../java/io/Reader.html "class in java.io") x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void
**[updateNCharacterStream](../../java/sql/ResultSet.html#updateNCharacterStream%28java.lang.String,%20java.io.Reader%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Reader](../../java/io/Reader.html "class in java.io") reader)
Updates the designated column with a character stream value.
void
**[updateNCharacterStream](../../java/sql/ResultSet.html#updateNCharacterStream%28java.lang.String,%20java.io.Reader,%20long%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Reader](../../java/io/Reader.html "class in java.io") reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void
**[updateNClob](../../java/sql/ResultSet.html#updateNClob%28int,%20java.sql.NClob%29)**(int columnIndex,[NClob](../../java/sql/NClob.html "interface in java.sql") nClob)
Updates the designated column with a java.sql.NClob
value.
void
**[updateNClob](../../java/sql/ResultSet.html#updateNClob%28int,%20java.io.Reader%29)**(int columnIndex,[Reader](../../java/io/Reader.html "class in java.io") 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.
void
**[updateNClob](../../java/sql/ResultSet.html#updateNClob%28int,%20java.io.Reader,%20long%29)**(int columnIndex,[Reader](../../java/io/Reader.html "class in java.io") reader, long length)
Updates the designated column using the given Reader
object, which is the given number of characters long.
void
**[updateNClob](../../java/sql/ResultSet.html#updateNClob%28java.lang.String,%20java.sql.NClob%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[NClob](../../java/sql/NClob.html "interface in java.sql") nClob)
Updates the designated column with a java.sql.NClob
value.
void
**[updateNClob](../../java/sql/ResultSet.html#updateNClob%28java.lang.String,%20java.io.Reader%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Reader](../../java/io/Reader.html "class in java.io") reader)
Updates the designated column using the given Reader
object.
void
**[updateNClob](../../java/sql/ResultSet.html#updateNClob%28java.lang.String,%20java.io.Reader,%20long%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Reader](../../java/io/Reader.html "class in java.io") reader, long length)
Updates the designated column using the given Reader
object, which is the given number of characters long.
void
**[updateNString](../../java/sql/ResultSet.html#updateNString%28int,%20java.lang.String%29)**(int columnIndex,[String](../../java/lang/String.html "class in java.lang") nString)
Updates the designated column with a String
value.
void
**[updateNString](../../java/sql/ResultSet.html#updateNString%28java.lang.String,%20java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[String](../../java/lang/String.html "class in java.lang") nString)
Updates the designated column with a String
value.
void
**[updateNull](../../java/sql/ResultSet.html#updateNull%28int%29)**(int columnIndex)
Updates the designated column with a null
value.
void
**[updateNull](../../java/sql/ResultSet.html#updateNull%28java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel)
Updates the designated column with a null
value.
void
**[updateObject](../../java/sql/ResultSet.html#updateObject%28int,%20java.lang.Object%29)**(int columnIndex,[Object](../../java/lang/Object.html "class in java.lang") x)
Updates the designated column with an Object
value.
void
**[updateObject](../../java/sql/ResultSet.html#updateObject%28int,%20java.lang.Object,%20int%29)**(int columnIndex,[Object](../../java/lang/Object.html "class in java.lang") x, int scaleOrLength)
Updates the designated column with an Object
value.
void
**[updateObject](../../java/sql/ResultSet.html#updateObject%28java.lang.String,%20java.lang.Object%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Object](../../java/lang/Object.html "class in java.lang") x)
Updates the designated column with an Object
value.
void
**[updateObject](../../java/sql/ResultSet.html#updateObject%28java.lang.String,%20java.lang.Object,%20int%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Object](../../java/lang/Object.html "class in java.lang") x, int scaleOrLength)
Updates the designated column with an Object
value.
void
**[updateRef](../../java/sql/ResultSet.html#updateRef%28int,%20java.sql.Ref%29)**(int columnIndex,[Ref](../../java/sql/Ref.html "interface in java.sql") x)
Updates the designated column with a java.sql.Ref
value.
void
**[updateRef](../../java/sql/ResultSet.html#updateRef%28java.lang.String,%20java.sql.Ref%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Ref](../../java/sql/Ref.html "interface in java.sql") x)
Updates the designated column with a java.sql.Ref
value.
void
**[updateRow](../../java/sql/ResultSet.html#updateRow%28%29)**()
Updates the underlying database with the new contents of the current row of this ResultSet
object.
void
**[updateRowId](../../java/sql/ResultSet.html#updateRowId%28int,%20java.sql.RowId%29)**(int columnIndex,[RowId](../../java/sql/RowId.html "interface in java.sql") x)
Updates the designated column with a RowId
value.
void
**[updateRowId](../../java/sql/ResultSet.html#updateRowId%28java.lang.String,%20java.sql.RowId%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[RowId](../../java/sql/RowId.html "interface in java.sql") x)
Updates the designated column with a RowId
value.
void
**[updateShort](../../java/sql/ResultSet.html#updateShort%28int,%20short%29)**(int columnIndex, short x)
Updates the designated column with a short
value.
void
**[updateShort](../../java/sql/ResultSet.html#updateShort%28java.lang.String,%20short%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel, short x)
Updates the designated column with a short
value.
void
**[updateSQLXML](../../java/sql/ResultSet.html#updateSQLXML%28int,%20java.sql.SQLXML%29)**(int columnIndex,[SQLXML](../../java/sql/SQLXML.html "interface in java.sql") xmlObject)
Updates the designated column with a java.sql.SQLXML
value.
void
**[updateSQLXML](../../java/sql/ResultSet.html#updateSQLXML%28java.lang.String,%20java.sql.SQLXML%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[SQLXML](../../java/sql/SQLXML.html "interface in java.sql") xmlObject)
Updates the designated column with a java.sql.SQLXML
value.
void
**[updateString](../../java/sql/ResultSet.html#updateString%28int,%20java.lang.String%29)**(int columnIndex,[String](../../java/lang/String.html "class in java.lang") x)
Updates the designated column with a String
value.
void
**[updateString](../../java/sql/ResultSet.html#updateString%28java.lang.String,%20java.lang.String%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[String](../../java/lang/String.html "class in java.lang") x)
Updates the designated column with a String
value.
void
**[updateTime](../../java/sql/ResultSet.html#updateTime%28int,%20java.sql.Time%29)**(int columnIndex,[Time](../../java/sql/Time.html "class in java.sql") x)
Updates the designated column with a java.sql.Time
value.
void
**[updateTime](../../java/sql/ResultSet.html#updateTime%28java.lang.String,%20java.sql.Time%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Time](../../java/sql/Time.html "class in java.sql") x)
Updates the designated column with a java.sql.Time
value.
void
**[updateTimestamp](../../java/sql/ResultSet.html#updateTimestamp%28int,%20java.sql.Timestamp%29)**(int columnIndex,[Timestamp](../../java/sql/Timestamp.html "class in java.sql") x)
Updates the designated column with a java.sql.Timestamp
value.
void
**[updateTimestamp](../../java/sql/ResultSet.html#updateTimestamp%28java.lang.String,%20java.sql.Timestamp%29)**([String](../../java/lang/String.html "class in java.lang") columnLabel,[Timestamp](../../java/sql/Timestamp.html "class in java.sql") x)
Updates the designated column with a java.sql.Timestamp
value.
boolean
**[wasNull](../../java/sql/ResultSet.html#wasNull%28%29)**()
Reports whether the last column read had a value of SQL NULL
.