A table of data representing a database result set, which is usually generated by executing a statement that queries the database.
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 |
|