Show TOC

java.sql.ResultSetLocate this document in the navigation structure

Definition

A table of data representing a database result set, which is usually generated by executing a statement that queries the database.

Integration

Method Name

Support in Open SQL

Comments

boolean absolute( int )

void afterLast()

void beforeFirst()

void cancelRowUpdates()

void clearWarnings()

void close()

void deleteRow()

int findColumn (String)

boolean first()

Array getArray (String)

Array getArray (int)

InputStream getAsciiStream (String)

InputStream getAsciiStream( int )

BigDecimal getBigDecimal (String)

BigDecimal getBigDecimal (String, int)

BigDecimal getBigDecimal (int)

BigDecimal getBigDecimal (int, int)

InputStream getBinaryStream (String)

InputStream getBinaryStream (int)

Blob getBlob (String)

Blob getBlob (int)

boolean getBoolean (String)

boolean getBoolean (int)

byte getByte (String)

byte getByte (int)

byte[] getBytes (String)

byte[] getBytes (int)

Reader getCharacterStream (String)

Reader getCharacterStream (int)

Clob getClob (String)

Clob getClob (int)

int getConcurrency()

Since Open SQL does not support updatable result sets, the method always returns CONCUR_READ_ONLY.

String getCursorName()

Date getDate (String)

Date getDate (String, Calendar)

Date getDate (int)

Date getDate (int, Calendar)

double getDouble (String)

double getDouble (int)

int getFetchDirection()

Open SQL only supports forward iteration of the result set - that is, the order of the fetched rows is from the first to the last. Therefore, the method always returns FETCH_FORWARD.

int getFetchSize()

float getFloat (String)

float getFloat (int)

int getInt (String)

int getInt (int)

long getLong (String)

long getLong (int)

ResultSetMetaData getMetaData()

Object getObject (String)

Object getObject (String, Map)

Object getObject (int)

Object getObject (int, Map)

Ref getRef (String)

Ref getRef (int)

int getRow()

short getShort (String)

short getShort (int)

Statement getStatement()

String getString (String)

String getString (int)

Time getTime (String)

Time getTime (String, Calendar)

Time getTime (int)

Time getTime (int, Calendar)

Timestamp getTimestamp (String)

Timestamp getTimestamp (String, Calendar)

Timestamp getTimestamp (int)

Timestamp getTimestamp (int, Calendar)

int getType()

Returns TYPE_FORWARD_ONLY.

InputStream getUnicodeStream (String)

InputStream getUnicodeStream (int)

SQLWarning getWarnings()

void insertRow()

boolean isAfterLast()

boolean isBeforeFirst()

boolean isFirst()

boolean isLast()

boolean last()

void moveToCurrentRow()

void moveToInsertRow()

boolean next()

boolean previous()

void refreshRow()

boolean relative (int)

boolean rowDeleted()

boolean rowInserted()

boolean rowUpdated()

void setFetchDirection (int)

void setFetchSize (int)

void updateAsciiStream (String, InputStream, int)

void updateAsciiStream (int, InputStream, int)

void updateBigDecimal (String, BigDecimal)

void updateBigDecimal (int, BigDecimal)

void updateBinaryStream (String, InputStream, int)

void updateBinaryStream (int, InputStream, int)

void updateBoolean (String, boolean)

void updateBoolean (int, boolean)

void updateByte (String, byte)

void updateByte (int, byte)

void updateBytes (String, byte[])

void updateBytes (int, byte[])

void updateCharacterStream (String, Reader, int)

void updateCharacterStream (int, Reader, int)

void updateDate (String, Date)

void updateDate (int, Date)

void updateDouble (String, double)

void updateDouble (int, double)

void updateFloat (String, float)

void updateFloat (int, float)

void updateInt (String, int)

void updateInt (int, int)

void updateLong (String, long)

void updateLong (int, long)

void updateNull (String)

void updateNull (int)

void updateObject (String, Object)

void updateObject (String, Object, int)

void updateObject (int, Object)

void updateObject (int, Object, int)

void updateRow()

void updateShort (String, short)

void updateShort (int, short)

void updateString (String, String)

void updateString (int, String)

void updateTime (String, Time)

void updateTime (int, Time)

void updateTimestamp (String, Timestamp)

void updateTimestamp (int, Timestamp)

boolean wasNull()