java.sql.ResultSet
java.sql.ResultSet is an execution result set API.
Method Name |
Return Type |
Support JDBC 4 |
---|---|---|
absolute(int row) |
Boolean |
Yes |
afterLast() |
void |
Yes |
beforeFirst() |
void |
Yes |
cancelRowUpdates() |
void |
Yes |
clearWarnings() |
void |
Yes |
close() |
void |
Yes |
deleteRow() |
void |
Yes |
findColumn(String columnLabel) |
int |
Yes |
first() |
Boolean |
Yes |
getArray(int columnIndex) |
Array |
Yes |
getArray(String columnLabel) |
Array |
Yes |
getAsciiStream(int columnIndex) |
InputStream |
Yes |
getAsciiStream(String columnLabel) |
InputStream |
Yes |
getBigDecimal(int columnIndex) |
BigDecimal |
Yes |
getBigDecimal(String columnLabel) |
BigDecimal |
Yes |
getBinaryStream(int columnIndex) |
InputStream |
Yes |
getBinaryStream(String columnLabel) |
InputStream |
Yes |
getBlob(int columnIndex) |
Blob |
Yes |
getBlob(String columnLabel) |
Blob |
Yes |
getBoolean(int columnIndex) |
Boolean |
Yes |
getBoolean(String columnLabel) |
Boolean |
Yes |
getByte(int columnIndex) |
byte |
Yes |
getBytes(int columnIndex) |
byte[] |
Yes |
getByte(String columnLabel) |
byte |
Yes |
getBytes(String columnLabel) |
byte[] |
Yes |
getCharacterStream(int columnIndex) |
Reader |
Yes |
getCharacterStream(String columnLabel) |
Reader |
Yes |
getClob(int columnIndex) |
Clob |
Yes |
getClob(String columnLabel) |
Clob |
Yes |
getConcurrency() |
int |
Yes |
getCursorName() |
String |
Yes |
getDate(int columnIndex) |
Date |
Yes |
getDate(int columnIndex, Calendar cal) |
Date |
Yes |
getDate(String columnLabel) |
Date |
Yes |
getDate(String columnLabel, Calendar cal) |
Date |
Yes |
getDouble(int columnIndex) |
double |
Yes |
getDouble(String columnLabel) |
double |
Yes |
getFetchDirection() |
int |
Yes |
getFetchSize() |
int |
Yes |
getFloat(int columnIndex) |
float |
Yes |
getFloat(String columnLabel) |
float |
Yes |
getInt(int columnIndex) |
int |
Yes |
getInt(String columnLabel) |
int |
Yes |
getLong(int columnIndex) |
long |
Yes |
getLong(String columnLabel) |
long |
Yes |
getMetaData() |
ResultSetMetaData |
Yes |
getObject(int columnIndex) |
Object |
Yes |
getObject(int columnIndex, Class<T> type) |
<T> T |
Yes |
getObject(int columnIndex, Map<String,Class<?>> map) |
Object |
Yes |
getObject(String columnLabel) |
Object |
Yes |
getObject(String columnLabel, Class<T> type) |
<T> T |
Yes |
getObject(String columnLabel, Map<String,Class<?>> map) |
Object |
Yes |
getRow() |
int |
Yes |
getShort(int columnIndex) |
short |
Yes |
getShort(String columnLabel) |
short |
Yes |
getSQLXML(int columnIndex) |
SQLXML |
Yes |
getSQLXML(String columnLabel) |
SQLXML |
Yes |
getStatement() |
Statement |
Yes |
getString(int columnIndex) |
String |
Yes |
getString(String columnLabel) |
String |
Yes |
getNString(int columnIndex) |
String |
Yes |
getNString(String columnLabel) |
String |
Yes |
getTime(int columnIndex) |
Time |
Yes |
getTime(int columnIndex, Calendar cal) |
Time |
Yes |
getTime(String columnLabel) |
Time |
Yes |
getTime(String columnLabel, Calendar cal) |
Time |
Yes |
getTimestamp(int columnIndex) |
Timestamp |
Yes |
getTimestamp(int columnIndex, Calendar cal) |
Timestamp |
Yes |
getTimestamp(String columnLabel) |
Timestamp |
Yes |
getTimestamp(String columnLabel, Calendar cal) |
Timestamp |
Yes |
getType() |
int |
Yes |
getWarnings() |
SQLWarning |
Yes |
insertRow() |
void |
Yes |
isAfterLast() |
Boolean |
Yes |
isBeforeFirst() |
Boolean |
Yes |
isClosed() |
Boolean |
Yes |
isFirst() |
Boolean |
Yes |
isLast() |
Boolean |
Yes |
last() |
Boolean |
Yes |
moveToCurrentRow() |
void |
Yes |
moveToInsertRow() |
void |
Yes |
next() |
Boolean |
Yes |
previous() |
Boolean |
Yes |
refreshRow() |
void |
Yes |
relative(int rows) |
Boolean |
Yes |
rowDeleted() |
Boolean |
Yes |
rowInserted() |
Boolean |
Yes |
rowUpdated() |
Boolean |
Yes |
setFetchDirection(int direction) |
void |
Yes |
setFetchSize(int rows) |
void |
Yes |
updateArray(int columnIndex, Array x) |
void |
Yes |
updateArray(String columnLabel, Array x) |
void |
Yes |
updateAsciiStream(int columnIndex, InputStream x, int length) |
void |
Yes |
updateAsciiStream(String columnLabel, InputStream x, int length) |
void |
Yes |
updateBigDecimal(int columnIndex, BigDecimal x) |
void |
Yes |
updateBigDecimal(String columnLabel, BigDecimal x) |
void |
Yes |
updateBinaryStream(int columnIndex, InputStream x, int length) |
void |
Yes |
updateBinaryStream(String columnLabel, InputStream x, int length) |
void |
Yes |
updateBoolean(int columnIndex, boolean x) |
void |
Yes |
updateBoolean(String columnLabel, boolean x) |
void |
Yes |
updateByte(int columnIndex, byte x) |
void |
Yes |
updateByte(String columnLabel, byte x) |
void |
Yes |
updateBytes(int columnIndex, byte[] x) |
void |
Yes |
updateBytes(String columnLabel, byte[] x) |
void |
Yes |
updateCharacterStream(int columnIndex, Reader x, int length) |
void |
Yes |
updateCharacterStream(String columnLabel, Reader reader, int length) |
void |
Yes |
updateDate(int columnIndex, Date x) |
void |
Yes |
updateDate(String columnLabel, Date x) |
void |
Yes |
updateDouble(int columnIndex, double x) |
void |
Yes |
updateDouble(String columnLabel, double x) |
void |
Yes |
updateFloat(int columnIndex, float x) |
void |
Yes |
updateFloat(String columnLabel, float x) |
void |
Yes |
updateInt(int columnIndex, int x) |
void |
Yes |
updateInt(String columnLabel, int x) |
void |
Yes |
updateLong(int columnIndex, long x) |
void |
Yes |
updateLong(String columnLabel, long x) |
void |
Yes |
updateNull(int columnIndex) |
void |
Yes |
updateNull(String columnLabel) |
void |
Yes |
updateObject(int columnIndex, Object x) |
void |
Yes |
updateObject(int columnIndex, Object x, int scaleOrLength) |
void |
Yes |
updateObject(String columnLabel, Object x) |
void |
Yes |
updateObject(String columnLabel, Object x, int scaleOrLength) |
void |
Yes |
updateRow() |
void |
Yes |
updateShort(int columnIndex, short x) |
void |
Yes |
updateShort(String columnLabel, short x) |
void |
Yes |
updateSQLXML(int columnIndex, SQLXML xmlObject) |
void |
Yes |
updateSQLXML(String columnLabel, SQLXML xmlObject) |
void |
Yes |
updateString(int columnIndex, String x) |
void |
Yes |
updateString(String columnLabel, String x) |
void |
Yes |
updateTime(int columnIndex, Time x) |
void |
Yes |
updateTime(String columnLabel, Time x) |
void |
Yes |
updateTimestamp(int columnIndex, Timestamp x) |
void |
Yes |
updateTimestamp(String columnLabel, Timestamp x) |
void |
Yes |
wasNull() |
Boolean |
Yes |
- One statement cannot have multiple open ResultSets.
- The cursor that is used for traversing the ResultSet cannot be open after being committed.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot