java.sql.ResultSet
java.sql.ResultSet是执行结果集接口,具体信息如表1所示。
|
方法名 |
返回值类型 |
支持JDBC4 |
|---|---|---|
|
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 |
|
getByte(String columnLabel) |
BYTE |
Yes |
|
getBytes(int columnIndex) |
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 |
|
getNString(int columnIndex) |
STRING |
Yes |
|
getNString(String columnLabel) |
STRING |
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 |
|
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 |
No |
|
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 |
No |
|
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 |