java.sql.ResultSet
java.sql.ResultSet是执行结果集接口。
方法名 |
返回值类型 |
支持JDBC4 |
支持计划外ALT |
---|---|---|---|
absolute(int row) |
boolean |
Yes |
Yes |
afterLast() |
void |
Yes |
Yes |
beforeFirst() |
void |
Yes |
Yes |
cancelRowUpdates() |
void |
Yes |
Yes |
clearWarnings() |
void |
Yes |
Yes |
close() |
void |
Yes |
Yes |
deleteRow() |
void |
Yes |
Yes |
findColumn(String columnLabel) |
int |
Yes |
Yes |
first() |
boolean |
Yes |
Yes |
getArray(int columnIndex) |
Array |
Yes |
Yes |
getArray(String columnLabel) |
Array |
Yes |
Yes |
getAsciiStream(int columnIndex) |
InputStream |
Yes |
Yes |
getAsciiStream(String columnLabel) |
InputStream |
Yes |
Yes |
getBigDecimal(int columnIndex) |
BigDecimal |
Yes |
Yes |
getBigDecimal(String columnLabel) |
BigDecimal |
Yes |
Yes |
getBinaryStream(int columnIndex) |
InputStream |
Yes |
Yes |
getBinaryStream(String columnLabel) |
InputStream |
Yes |
Yes |
getBlob(int columnIndex) |
Blob |
Yes |
Yes |
getBlob(String columnLabel) |
Blob |
Yes |
Yes |
getBoolean(int columnIndex) |
boolean |
Yes |
Yes |
getBoolean(String columnLabel) |
boolean |
Yes |
Yes |
getByte(int columnIndex) |
byte |
Yes |
Yes |
getBytes(int columnIndex) |
byte[] |
Yes |
Yes |
getByte(String columnLabel) |
byte |
Yes |
Yes |
getBytes(String columnLabel) |
byte[] |
Yes |
Yes |
getCharacterStream(int columnIndex) |
Reader |
Yes |
Yes |
getCharacterStream(String columnLabel) |
Reader |
Yes |
Yes |
getClob(int columnIndex) |
Clob |
Yes |
Yes |
getClob(String columnLabel) |
Clob |
Yes |
Yes |
getConcurrency() |
int |
Yes |
Yes |
getCursorName() |
String |
Yes |
Yes |
getDate(int columnIndex) |
Date |
Yes |
Yes |
getDate(int columnIndex, Calendar cal) |
Date |
Yes |
Yes |
getDate(String columnLabel) |
Date |
Yes |
Yes |
getDate(String columnLabel, Calendar cal) |
Date |
Yes |
Yes |
getDouble(int columnIndex) |
double |
Yes |
Yes |
getDouble(String columnLabel) |
double |
Yes |
Yes |
getFetchDirection() |
int |
Yes |
Yes |
getFetchSize() |
int |
Yes |
Yes |
getFloat(int columnIndex) |
float |
Yes |
Yes |
getFloat(String columnLabel) |
float |
Yes |
Yes |
getInt(int columnIndex) |
int |
Yes |
Yes |
getInt(String columnLabel) |
int |
Yes |
Yes |
getLong(int columnIndex) |
long |
Yes |
Yes |
getLong(String columnLabel) |
long |
Yes |
Yes |
getMetaData() |
ResultSetMetaData |
Yes |
Yes |
getObject(int columnIndex) |
Object |
Yes |
Yes |
getObject(int columnIndex, Class<T> type) |
<T> T |
Yes |
Yes |
getObject(int columnIndex, Map<String,Class<?>> map) |
Object |
Yes |
Yes |
getObject(String columnLabel) |
Object |
Yes |
Yes |
getObject(String columnLabel, Class<T> type) |
<T> T |
Yes |
Yes |
getObject(String columnLabel, Map<String,Class<?>> map) |
Object |
Yes |
Yes |
getRow() |
int |
Yes |
Yes |
getShort(int columnIndex) |
short |
Yes |
Yes |
getShort(String columnLabel) |
short |
Yes |
Yes |
getSQLXML(int columnIndex) |
SQLXML |
Yes |
Yes |
getSQLXML(String columnLabel) |
SQLXML |
Yes |
Yes |
getStatement() |
Statement |
Yes |
Yes |
getString(int columnIndex) |
String |
Yes |
Yes |
getString(String columnLabel) |
String |
Yes |
Yes |
getNString(int columnIndex) |
String |
Yes |
Yes |
getNString(String columnLabel) |
String |
Yes |
Yes |
getTime(int columnIndex) |
Time |
Yes |
Yes |
getTime(int columnIndex, Calendar cal) |
Time |
Yes |
Yes |
getTime(String columnLabel) |
Time |
Yes |
Yes |
getTime(String columnLabel, Calendar cal) |
Time |
Yes |
Yes |
getTimestamp(int columnIndex) |
Timestamp |
Yes |
Yes |
getTimestamp(int columnIndex, Calendar cal) |
Timestamp |
Yes |
Yes |
getTimestamp(String columnLabel) |
Timestamp |
Yes |
Yes |
getTimestamp(String columnLabel, Calendar cal) |
Timestamp |
Yes |
Yes |
getType() |
int |
Yes |
Yes |
getWarnings() |
SQLWarning |
Yes |
Yes |
insertRow() |
void |
Yes |
Yes |
isAfterLast() |
boolean |
Yes |
Yes |
isBeforeFirst() |
boolean |
Yes |
Yes |
isClosed() |
boolean |
Yes |
Yes |
isFirst() |
boolean |
Yes |
Yes |
isLast() |
boolean |
Yes |
Yes |
last() |
boolean |
Yes |
Yes |
moveToCurrentRow() |
void |
Yes |
Yes |
moveToInsertRow() |
void |
Yes |
Yes |
next() |
boolean |
Yes |
Yes |
previous() |
boolean |
Yes |
Yes |
refreshRow() |
void |
Yes |
Yes |
relative(int rows) |
boolean |
Yes |
Yes |
rowDeleted() |
boolean |
Yes |
Yes |
rowInserted() |
boolean |
Yes |
Yes |
rowUpdated() |
boolean |
Yes |
Yes |
setFetchDirection(int direction) |
void |
Yes |
Yes |
setFetchSize(int rows) |
void |
Yes |
Yes |
updateArray(int columnIndex, Array x) |
void |
Yes |
Yes |
updateArray(String columnLabel, Array x) |
void |
Yes |
Yes |
updateAsciiStream(int columnIndex, InputStream x, int length) |
void |
Yes |
No |
updateAsciiStream(String columnLabel, InputStream x, int length) |
void |
Yes |
No |
updateBigDecimal(int columnIndex, BigDecimal x) |
void |
Yes |
Yes |
updateBigDecimal(String columnLabel, BigDecimal x) |
void |
Yes |
Yes |
updateBinaryStream(int columnIndex, InputStream x, int length) |
void |
Yes |
No |
updateBinaryStream(String columnLabel, InputStream x, int length) |
void |
Yes |
No |
updateBoolean(int columnIndex, boolean x) |
void |
Yes |
Yes |
updateBoolean(String columnLabel, boolean x) |
void |
Yes |
Yes |
updateByte(int columnIndex, byte x) |
void |
Yes |
Yes |
updateByte(String columnLabel, byte x) |
void |
Yes |
Yes |
updateBytes(int columnIndex, byte[] x) |
void |
Yes |
Yes |
updateBytes(String columnLabel, byte[] x) |
void |
Yes |
Yes |
updateCharacterStream(int columnIndex, Reader x, int length) |
void |
Yes |
Yes |
updateCharacterStream(String columnLabel, Reader reader, int length) |
void |
Yes |
Yes |
updateDate(int columnIndex, Date x) |
void |
Yes |
Yes |
updateDate(String columnLabel, Date x) |
void |
Yes |
Yes |
updateDouble(int columnIndex, double x) |
void |
Yes |
Yes |
updateDouble(String columnLabel, double x) |
void |
Yes |
Yes |
updateFloat(int columnIndex, float x) |
void |
Yes |
Yes |
updateFloat(String columnLabel, float x) |
void |
Yes |
Yes |
updateInt(int columnIndex, int x) |
void |
Yes |
Yes |
updateInt(String columnLabel, int x) |
void |
Yes |
Yes |
updateLong(int columnIndex, long x) |
void |
Yes |
Yes |
updateLong(String columnLabel, long x) |
void |
Yes |
Yes |
updateNull(int columnIndex) |
void |
Yes |
Yes |
updateNull(String columnLabel) |
void |
Yes |
Yes |
updateObject(int columnIndex, Object x) |
void |
Yes |
No |
updateObject(int columnIndex, Object x, int scaleOrLength) |
void |
Yes |
No |
updateObject(String columnLabel, Object x) |
void |
Yes |
No |
updateObject(String columnLabel, Object x, int scaleOrLength) |
void |
Yes |
No |
updateRow() |
void |
Yes |
Yes |
updateShort(int columnIndex, short x) |
void |
Yes |
Yes |
updateShort(String columnLabel, short x) |
void |
Yes |
Yes |
updateSQLXML(int columnIndex, SQLXML xmlObject) |
void |
Yes |
Yes |
updateSQLXML(String columnLabel, SQLXML xmlObject) |
void |
Yes |
Yes |
updateString(int columnIndex, String x) |
void |
Yes |
Yes |
updateString(String columnLabel, String x) |
void |
Yes |
Yes |
updateTime(int columnIndex, Time x) |
void |
Yes |
Yes |
updateTime(String columnLabel, Time x) |
void |
Yes |
Yes |
updateTimestamp(int columnIndex, Timestamp x) |
void |
Yes |
Yes |
updateTimestamp(String columnLabel, Timestamp x) |
void |
Yes |
Yes |
wasNull() |
boolean |
Yes |
Yes |
- 一个Statement不能有多个处于“open”状态的ResultSet。
- 用于遍历结果集(ResultSet)的游标(Cursor)在被提交后不能保持“open”的状态。