# java.sql.ResultSet
java.sql.ResultSet是执行结果集接口。
表1对java.sql.ResultSet的支持情况 
| 方法名                                                                  | 返回值类型             | 支持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      |
   
![](https://support.huaweicloud.com/centralized-devg-v2-gaussdb/public_sys-resources/note_3.0-zh-cn.png)
- 一个Statement不能有多个处于"open"状态的ResultSet。
- 用于遍历结果集（ResultSet）的游标（Cursor）在被提交后不能保持"open"的状态。