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 |