Java java.sql ResultSet fields, constructors, methods, implement or subclass

Introduction

In this page you can find the methods, fields and constructors for java.sql ResultSet.

The text is from its open source code.

Implementation

java.sql.ResultSet has the following implementations.
Click this link to see all its implementation.

Field

int	FETCH_FORWARD The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last.
int	FETCH_REVERSE The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first.
int	FETCH_UNKNOWN The constant indicating that the order in which rows in a result set will be processed is unknown.
int	TYPE_FORWARD_ONLY The constant indicating the type for a `ResultSet` object whose cursor may move only forward.
int	TYPE_SCROLL_INSENSITIVE The constant indicating the type for a `ResultSet` object that is scrollable but generally not sensitive to changes to the data that underlies the `ResultSet`.
int	TYPE_SCROLL_SENSITIVE The constant indicating the type for a `ResultSet` object that is scrollable and generally sensitive to changes to the data that underlies the `ResultSet`.
int	CONCUR_READ_ONLY The constant indicating the concurrency mode for a `ResultSet` object that may NOT be updated.
int	CONCUR_UPDATABLE The constant indicating the concurrency mode for a `ResultSet` object that may be updated.
int	HOLD_CURSORS_OVER_COMMIT The constant indicating that open `ResultSet` objects with this holdability will remain open when the current transaction is committed.
int	CLOSE_CURSORS_AT_COMMIT The constant indicating that open `ResultSet` objects with this holdability will be closed when the current transaction is committed.

Method

boolean	absolute(int row) Moves the cursor to the given row number in this `ResultSet` object.
void	afterLast() Moves the cursor to the end of this `ResultSet` object, just after the last row.
void	beforeFirst() Moves the cursor to the front of this `ResultSet` object, just before the first row.
void	cancelRowUpdates() Cancels the updates made to the current row in this `ResultSet` object.
void	clearWarnings() Clears all warnings reported on this `ResultSet` object.
void	close() Releases this `ResultSet` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
void	deleteRow() Deletes the current row from this `ResultSet` object and from the underlying database.
boolean	equals(Object obj) Indicates whether some other object is "equal to" this one.
int	findColumn(String columnLabel) Maps the given `ResultSet` column label to its `ResultSet` column index.
boolean	first() Moves the cursor to the first row in this `ResultSet` object.
Array	getArray(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	getArray(String 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.
java.io.InputStream	getAsciiStream(int columnIndex) Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
java.io.InputStream	getAsciiStream(String columnLabel) Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
BigDecimal	getBigDecimal(int columnIndex) Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
BigDecimal	getBigDecimal(String columnLabel) Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
java.io.InputStream	getBinaryStream(int columnIndex) Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of uninterpreted bytes.
java.io.InputStream	getBinaryStream(String columnLabel) Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of uninterpreted `byte`s.
Blob	getBlob(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	getBlob(String 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(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(String 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(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(String 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(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(String 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.
java.io.Reader	getCharacterStream(int columnIndex) Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
java.io.Reader	getCharacterStream(String columnLabel) Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
Class	getClass() Returns the runtime class of this Object .
Clob	getClob(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	getClob(String 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() Retrieves the concurrency mode of this `ResultSet` object.
String	getCursorName() Retrieves the name of the SQL cursor used by this `ResultSet` object.
java.sql.Date	getDate(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.
java.sql.Date	getDate(String 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.
java.sql.Date	getDate(int columnIndex, Calendar 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.
java.sql.Date	getDate(String columnLabel, Calendar 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(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(String 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() Retrieves the fetch direction for this `ResultSet` object.
int	getFetchSize() Retrieves the fetch size for this `ResultSet` object.
float	getFloat(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(String 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() Retrieves the holdability of this `ResultSet` object
int	getInt(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(String 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(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(String 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	getMetaData() Retrieves the number, types and properties of this `ResultSet` object's columns.
java.io.Reader	getNCharacterStream(int columnIndex) Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
java.io.Reader	getNCharacterStream(String columnLabel) Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
NClob	getNClob(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	getNClob(String 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	getNString(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	getNString(String 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	getObject(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.
Object	getObject(String columnLabel) Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
Object	getObject(int columnIndex, java.util.Map> 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	getObject(String columnLabel, java.util.Map> map) Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
T	getObject(int columnIndex, Class 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.
T	getObject(String columnLabel, Class 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.
Ref	getRef(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	getRef(String 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() Retrieves the current row number.
RowId	getRowId(int columnIndex) Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.RowId` object in the Java programming language.
RowId	getRowId(String columnLabel) Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.RowId` object in the Java programming language.
short	getShort(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(String 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	getSQLXML(int columnIndex) Retrieves the value of the designated column in the current row of this `ResultSet` as a `java.sql.SQLXML` object in the Java programming language.
SQLXML	getSQLXML(String columnLabel) Retrieves the value of the designated column in the current row of this `ResultSet` as a `java.sql.SQLXML` object in the Java programming language.
Statement	getStatement() Retrieves the `Statement` object that produced this `ResultSet` object.
String	getString(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	getString(String columnLabel) Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
java.sql.Time	getTime(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.
java.sql.Time	getTime(String 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.
java.sql.Time	getTime(int columnIndex, Calendar 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.
java.sql.Time	getTime(String columnLabel, Calendar 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.
java.sql.Timestamp	getTimestamp(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.
java.sql.Timestamp	getTimestamp(String 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.
java.sql.Timestamp	getTimestamp(int columnIndex, Calendar 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.
java.sql.Timestamp	getTimestamp(String columnLabel, Calendar 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() Retrieves the type of this `ResultSet` object.
java.io.InputStream	getUnicodeStream(int columnIndex) Retrieves the value of the designated column in the current row of this `ResultSet` object as as a stream of two-byte 3 characters.
java.io.InputStream	getUnicodeStream(String columnLabel) Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of two-byte Unicode characters.
java.net.URL	getURL(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.
java.net.URL	getURL(String 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	getWarnings() Retrieves the first warning reported by calls on this `ResultSet` object.
int	hashCode() Returns a hash code value for the object.
void	insertRow() Inserts the contents of the insert row into this `ResultSet` object and into the database.
boolean	isAfterLast() Retrieves whether the cursor is after the last row in this `ResultSet` object.
boolean	isBeforeFirst() Retrieves whether the cursor is before the first row in this `ResultSet` object.
boolean	isClosed() Retrieves whether this `ResultSet` object has been closed.
boolean	isFirst() Retrieves whether the cursor is on the first row of this `ResultSet` object.
boolean	isLast() Retrieves whether the cursor is on the last row of this `ResultSet` object.
boolean	isWrapperFor(java.lang.Class iface) Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
boolean	last() Moves the cursor to the last row in this `ResultSet` object.
void	moveToCurrentRow() Moves the cursor to the remembered cursor position, usually the current row.
void	moveToInsertRow() Moves the cursor to the insert row.
boolean	next() Moves the cursor forward one row from its current position.
boolean	previous() Moves the cursor to the previous row in this `ResultSet` object.
void	refreshRow() Refreshes the current row with its most recent value in the database.
boolean	relative(int rows) Moves the cursor a relative number of rows, either positive or negative.
boolean	rowDeleted() Retrieves whether a row has been deleted.
boolean	rowInserted() Retrieves whether the current row has had an insertion.
boolean	rowUpdated() Retrieves whether the current row has been updated.
void	setFetchDirection(int direction) Gives a hint as to the direction in which the rows in this `ResultSet` object will be processed.
void	setFetchSize(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 this `ResultSet` object.
String	toString() Returns a string representation of the object.
T	unwrap(java.lang.Class iface) Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
void	updateArray(int columnIndex, java.sql.Array x) Updates the designated column with a `java.sql.Array` value.
void	updateArray(String columnLabel, java.sql.Array x) Updates the designated column with a `java.sql.Array` value.
void	updateAsciiStream(int columnIndex, java.io.InputStream x, int length) Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void	updateAsciiStream(String columnLabel, java.io.InputStream x, int length) Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void	updateAsciiStream(int columnIndex, java.io.InputStream x, long length) Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void	updateAsciiStream(String columnLabel, java.io.InputStream x, long length) Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void	updateBigDecimal(int columnIndex, BigDecimal x) Updates the designated column with a `java.math.BigDecimal` value.
void	updateBigDecimal(String columnLabel, BigDecimal x) Updates the designated column with a `java.sql.BigDecimal` value.
void	updateBinaryStream(int columnIndex, java.io.InputStream x, int length) Updates the designated column with a binary stream value, which will have the specified number of bytes.
void	updateBinaryStream(String columnLabel, java.io.InputStream x, int length) Updates the designated column with a binary stream value, which will have the specified number of bytes.
void	updateBinaryStream(int columnIndex, java.io.InputStream x, long length) Updates the designated column with a binary stream value, which will have the specified number of bytes.
void	updateBinaryStream(String columnLabel, java.io.InputStream x, long length) Updates the designated column with a binary stream value, which will have the specified number of bytes.
void	updateBlob(int columnIndex, java.sql.Blob x) Updates the designated column with a `java.sql.Blob` value.
void	updateBlob(String columnLabel, java.sql.Blob x) Updates the designated column with a `java.sql.Blob` value.
void	updateBlob(int columnIndex, InputStream inputStream) Updates the designated column using the given input stream.
void	updateBlob(String columnLabel, InputStream inputStream) Updates the designated column using the given input stream.
void	updateBoolean(int columnIndex, boolean x) Updates the designated column with a `boolean` value.
void	updateBoolean(String columnLabel, boolean x) Updates the designated column with a `boolean` value.
void	updateByte(int columnIndex, byte x) Updates the designated column with a `byte` value.
void	updateByte(String columnLabel, byte x) Updates the designated column with a `byte` value.
void	updateBytes(int columnIndex, byte x[]) Updates the designated column with a `byte` array value.
void	updateBytes(String columnLabel, byte x[]) Updates the designated column with a byte array value.
void	updateCharacterStream(int columnIndex, java.io.Reader x, int length) Updates the designated column with a character stream value, which will have the specified number of bytes.
void	updateCharacterStream(String columnLabel, java.io.Reader reader, int length) Updates the designated column with a character stream value, which will have the specified number of bytes.
void	updateCharacterStream(int columnIndex, java.io.Reader x, long length) Updates the designated column with a character stream value, which will have the specified number of bytes.
void	updateCharacterStream(String columnLabel, java.io.Reader reader, long length) Updates the designated column with a character stream value, which will have the specified number of bytes.
void	updateClob(int columnIndex, java.sql.Clob x) Updates the designated column with a `java.sql.Clob` value.
void	updateClob(String columnLabel, java.sql.Clob x) Updates the designated column with a `java.sql.Clob` value.
void	updateClob(int columnIndex, Reader reader) Updates the designated column using the given `Reader` object.
void	updateClob(String columnLabel, Reader reader) Updates the designated column using the given `Reader` object.
void	updateDate(int columnIndex, java.sql.Date x) Updates the designated column with a `java.sql.Date` value.
void	updateDate(String columnLabel, java.sql.Date x) Updates the designated column with a `java.sql.Date` value.
void	updateDouble(int columnIndex, double x) Updates the designated column with a `double` value.
void	updateDouble(String columnLabel, double x) Updates the designated column with a `double` value.
void	updateFloat(int columnIndex, float x) Updates the designated column with a `float` value.
void	updateFloat(String columnLabel, float x) Updates the designated column with a `float` value.
void	updateInt(int columnIndex, int x) Updates the designated column with an `int` value.
void	updateInt(String columnLabel, int x) Updates the designated column with an `int` value.
void	updateLong(int columnIndex, long x) Updates the designated column with a `long` value.
void	updateLong(String columnLabel, long x) Updates the designated column with a `long` value.
void	updateNCharacterStream(int columnIndex, java.io.Reader x, long length) Updates the designated column with a character stream value, which will have the specified number of bytes.
void	updateNCharacterStream(String columnLabel, java.io.Reader reader, long length) Updates the designated column with a character stream value, which will have the specified number of bytes.
void	updateNClob(int columnIndex, NClob nClob) Updates the designated column with a `java.sql.NClob` value.
void	updateNClob(String columnLabel, NClob nClob) Updates the designated column with a `java.sql.NClob` value.
void	updateNClob(int columnIndex, Reader 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(String columnLabel, Reader reader) Updates the designated column using the given `Reader` object.
void	updateNString(int columnIndex, String nString) Updates the designated column with a `String` value.
void	updateNString(String columnLabel, String nString) Updates the designated column with a `String` value.
void	updateNull(int columnIndex) Updates the designated column with a `null` value.
void	updateNull(String columnLabel) Updates the designated column with a `null` value.
void	updateObject(int columnIndex, Object x) Updates the designated column with an `Object` value.
void	updateObject(String columnLabel, Object x) Updates the designated column with an `Object` value.
void	updateObject(int columnIndex, Object x, int scaleOrLength) Updates the designated column with an `Object` value.
void	updateObject(String columnLabel, Object x, int scaleOrLength) Updates the designated column with an `Object` value.
void	updateObject(int columnIndex, Object x, SQLType targetSqlType) Updates the designated column with an Object value.
void	updateObject(String columnLabel, Object x, SQLType targetSqlType) Updates the designated column with an Object value.
void	updateRef(int columnIndex, java.sql.Ref x) Updates the designated column with a `java.sql.Ref` value.
void	updateRef(String columnLabel, java.sql.Ref x) Updates the designated column with a `java.sql.Ref` value.
void	updateRow() Updates the underlying database with the new contents of the current row of this `ResultSet` object.
void	updateRowId(int columnIndex, RowId x) Updates the designated column with a `RowId` value.
void	updateRowId(String columnLabel, RowId x) Updates the designated column with a `RowId` value.
void	updateShort(int columnIndex, short x) Updates the designated column with a `short` value.
void	updateShort(String columnLabel, short x) Updates the designated column with a `short` value.
void	updateSQLXML(int columnIndex, SQLXML xmlObject) Updates the designated column with a `java.sql.SQLXML` value.
void	updateSQLXML(String columnLabel, SQLXML xmlObject) Updates the designated column with a `java.sql.SQLXML` value.
void	updateString(int columnIndex, String x) Updates the designated column with a `String` value.
void	updateString(String columnLabel, String x) Updates the designated column with a `String` value.
void	updateTime(int columnIndex, java.sql.Time x) Updates the designated column with a `java.sql.Time` value.
void	updateTime(String columnLabel, java.sql.Time x) Updates the designated column with a `java.sql.Time` value.
void	updateTimestamp(int columnIndex, java.sql.Timestamp x) Updates the designated column with a `java.sql.Timestamp` value.
void	updateTimestamp(String columnLabel, java.sql.Timestamp x) Updates the designated column with a `java.sql.Timestamp` value.
boolean	wasNull() Reports whether the last column read had a value of SQL `NULL`.