Show TOC Start of Content Area

Object documentation java.sql.ResultSet  Locate the document in its SAP Library structure

Definition

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

Integration

Methods of Interface java.sql.ResultSet

Method Name

Support in Open SQL

Comments

boolean absolute( int )

r

 

void afterLast()

r

 

void beforeFirst()

r

 

void cancelRowUpdates()

r

 

void clearWarnings()

a

 

void close()

a

 

void deleteRow()

r

 

int findColumn (String)

a

 

boolean first()

r

 

Array getArray (String)

r

 

Array getArray (int)

r

 

InputStream getAsciiStream (String)

r

 

InputStream getAsciiStream( int )

r

 

BigDecimal getBigDecimal (String)

a

 

BigDecimal getBigDecimal (String, int)

r

 

BigDecimal getBigDecimal (int)

a

 

BigDecimal getBigDecimal (int, int)

r

 

InputStream getBinaryStream (String)

a

 

InputStream getBinaryStream (int)

a

 

Blob getBlob (String)

a

 

Blob getBlob (int)

a

 

boolean getBoolean (String)

a

 

boolean getBoolean (int)

a

 

byte getByte (String)

r

 

byte getByte (int)

r

 

byte[] getBytes (String)

a

 

byte[] getBytes (int)

a

 

Reader getCharacterStream (String)

a

 

Reader getCharacterStream (int)

a

 

Clob getClob (String)

a

 

Clob getClob (int)

a

 

int getConcurrency()

a

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

String getCursorName()

r

 

Date getDate (String)

a

 

Date getDate (String, Calendar)

r

 

Date getDate (int)

a

 

Date getDate (int, Calendar)

r

 

double getDouble (String)

a

 

double getDouble (int)

a

 

int getFetchDirection()

a

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()

a

 

float getFloat (String)

a

 

float getFloat (int)

a

 

int getInt (String)

a

 

int getInt (int)

a

 

long getLong (String)

a

 

long getLong (int)

a

 

ResultSetMetaData getMetaData()

a

 

Object getObject (String)

a

 

Object getObject (String, Map)

a

 

Object getObject (int)

a

 

Object getObject (int, Map)

r

 

Ref getRef (String)

r

 

Ref getRef (int)

r

 

int getRow()

a

 

short getShort (String)

a

 

short getShort (int)

a

 

Statement getStatement()

a

 

String getString (String)

a

 

String getString (int)

a

 

Time getTime (String)

a

 

Time getTime (String, Calendar)

r

 

Time getTime (int)

a

 

Time getTime (int, Calendar)

r

 

Timestamp getTimestamp (String)

a

 

Timestamp getTimestamp (String, Calendar)

a

 

Timestamp getTimestamp (int)

a

 

Timestamp getTimestamp (int, Calendar)

a

 

int getType()

a

Returns TYPE_FORWARD_ONLY.

InputStream getUnicodeStream (String)

r

 

InputStream getUnicodeStream (int)

r

 

SQLWarning getWarnings()

a

 

void insertRow()

r

 

boolean isAfterLast()

r

 

boolean isBeforeFirst()

r

 

boolean isFirst()

r

 

boolean isLast()

r

 

boolean last()

r

 

void moveToCurrentRow()

r

 

void moveToInsertRow()

r

 

boolean next()

a

 

boolean previous()

r

 

void refreshRow()

r

 

boolean relative (int)

r

 

boolean rowDeleted()

r

 

boolean rowInserted()

r

 

boolean rowUpdated()

r

 

void setFetchDirection (int)

r

 

void setFetchSize (int)

r

 

void updateAsciiStream (String, InputStream, int)

r

 

void updateAsciiStream (int, InputStream, int)

r

 

void updateBigDecimal (String, BigDecimal)

r

 

void updateBigDecimal (int, BigDecimal)

r

 

void updateBinaryStream (String, InputStream, int)

r

 

void updateBinaryStream (int, InputStream, int)

r

 

void updateBoolean (String, boolean)

r

 

void updateBoolean (int, boolean)

r

 

void updateByte (String, byte)

r

 

void updateByte (int, byte)

r

 

void updateBytes (String, byte[])

r

 

void updateBytes (int, byte[])

r

 

void updateCharacterStream (String, Reader, int)

r

 

void updateCharacterStream (int, Reader, int)

r

 

void updateDate (String, Date)

r

 

void updateDate (int, Date)

r

 

void updateDouble (String, double)

r

 

void updateDouble (int, double)

r

 

void updateFloat (String, float)

r

 

void updateFloat (int, float)

r

 

void updateInt (String, int)

r

 

void updateInt (int, int)

r

 

void updateLong (String, long)

r

 

void updateLong (int, long)

r

 

void updateNull (String)

r

 

void updateNull (int)

r

 

void updateObject (String, Object)

r

 

void updateObject (String, Object, int)

r

 

void updateObject (int, Object)

r

 

void updateObject (int, Object, int)

r

 

void updateRow()

r

 

void updateShort (String, short)

r

 

void updateShort (int, short)

r

 

void updateString (String, String)

r

 

void updateString (int, String)

r

 

void updateTime (String, Time)

r

 

void updateTime (int, Time)

r

 

void updateTimestamp (String, Timestamp)

r

 

void updateTimestamp (int, Timestamp)

r

 

boolean wasNull()

a

 

 

 

 

End of Content Area