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”的状态。