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 uninterpretedbytes.

[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.