#java.sql.ResultSet
ResultSet接口表示SQL查询语句执行完成后的结果集,可以通过Statement的executeQuery方法或者getResultSet方法获取。该接口用于遍历查询结果。
YashanDB JDBC驱动对ResultSet接口已支持功能:
| 返回类型 | 方法 |
|---|---|
| boolean | next() |
| void | close() |
| boolean | wasNull() |
| String | getString(int columnIndex) |
| String | getString(String columnLabel) |
| String | getNString(int columnIndex) |
| String | getNString(String columnLabel) |
| boolean | getBoolean(int columnIndex) |
| boolean | getBoolean(String columnLabel) |
| byte | getByte(int columnIndex) |
| byte | getByte(String columnLabel) |
| short | getShort(int columnIndex) |
| short | getShort(String columnLabel) |
| int | getInt(int columnIndex) |
| int | getInt(String columnLabel) |
| long | getLong(int columnIndex) |
| long | getLong(String columnLabel) |
| SQLXML | getSQLXML(int columnIndex) |
| SQLXML | getSQLXML(String columnLabel) |
| float | getFloat(int columnIndex) |
| float | float getFloat(String columnLabel) |
| double | getDouble(int columnIndex) |
| double | getDouble(String columnLabel) |
| BigDecimal | getBigDecimal(int columnIndex) |
| BigDecimal | getBigDecimal(String columnLabel) |
| BigDecimal | getBigDecimal(int columnIndex, int scale) |
| BigDecimal | getBigDecimal(String columnLabel, int scale) |
| byte[] | getBytes(int columnIndex) |
| byte[] | getBytes(String columnLabel) |
| java.sql.Date | getDate(int columnIndex) |
| java.sql.Date | getDate(String columnLabel) |
| java.sql.Date | getDate(int columnIndex, Calendar cal) |
| java.sql.Date | getDate(String columnLabel, Calendar cal) |
| java.sql.Timestamp | getTimestamp(int columnIndex) |
| java.sql.Timestamp | getTimestamp(String columnLabel) |
| java.sql.Timestamp | getTimestamp(int columnIndex, Calendar cal) |
| java.sql.Timestamp | getTimestamp(String columnLabel, Calendar cal) |
| java.io.InputStream | getAsciiStream(int columnIndex) |
| java.io.InputStream | getAsciiStream(String columnLabel) |
| java.io.InputStream | getBinaryStream(int columnIndex) |
| java.io.InputStream | getBinaryStream(String columnLabel) |
| java.io.Reader | getCharacterStream(int columnIndex) |
| java.io.Reader | getCharacterStream(String columnLabel) |
| ResultSetMetaData | getMetaData() |
| Object | getObject(int columnIndex) |
| Object | getObject(String columnLabel) |
| int | findColumn(String columnLabel) |
| boolean | isFirst() |
| int | getRow() |
| int | getType() |
| int | getConcurrency() |
| Statement | getStatement() |
| RowId | getRowId(int columnIndex) |
| RowId | getRowId(String columnLabel) |
| boolean | isClosed() |
| java.sql.Time | getTime(int columnIndex) |
| java.sql.Time | getTime(String columnLabel) |
| java.sql.Time | getTime(int columnIndex, Calendar cal) |
| java.sql.Time | getTime(String columnLabel, Calendar cal) |
| Blob | getBlob(int columnIndex) |
| Blob | getBlob(String columnLabel) |
| Clob | getClob(int columnIndex) |
| Clob | getClob(String columnLabel) |
| <T> T | getObject(int columnIndex, Class<T> type) |
| <T> T | getObject(String columnLabel, Class<T> type) |
| Object | getObject(int columnIndex, java.util.Map<String,Class<?>> map) |
| Object | getObject(String columnLabel, java.util.Map<String,Class<?>> map) |
| Array | getArray(int columnIndex) |
| Array | getArray(String columnLabel) |
| boolean | isBeforeFirst() |
| boolean | isAfterLast() |
| boolean | isLast() |
| void | beforeFirst() |
| void | afterLast() |
| boolean | first() |
| boolean | last() |
| boolean | absolute( int row ) |
| boolean | relative( int rows ) |
| boolean | previous() |
| boolean | rowUpdated() |
| boolean | rowInserted() |
| boolean | rowDeleted() |
| void | updateNull(int columnIndex) |
| void | updateNull(String columnLabel) |
| void | updateByte(int columnIndex, byte x) |
| void | updateByte(String columnLabel, byte x) |
| void | updateShort(int columnIndex, short x) |
| void | updateShort(String columnLabel, short x) |
| void | updateInt(int columnIndex, int x) |
| void | updateInt(String columnLabel, int x) |
| void | updateLong(int columnIndex, long x) |
| void | updateLong(String columnLabel, long x) |
| void | updateFloat(int columnIndex, float x) |
| void | updateFloat(String columnLabel, float x) |
| void | updateDouble(int columnIndex, double x) |
| void | updateDouble(String columnLabel, double x) |
| void | updateBigDecimal(int columnIndex, BigDecimal x) |
| void | updateBigDecimal(String columnLabel, BigDecimal x) |
| void | updateString(int columnIndex, String x) |
| void | updateString(String columnLabel, String x) |
| void | updateSQLXML(int columnIndex, SQLXML xmlObject) |
| void | updateSQLXML(String columnLabel, SQLXML xmlObject) |
| void | updateDate(int columnIndex, java.sql.Date x) |
| void | updateDate(String columnLabel, java.sql.Date x) |
| void | updateTime(int columnIndex, java.sql.Time x) |
| void | updateTime(String columnLabel, java.sql.Time x) |
| void | updateTimestamp(int columnIndex, java.sql.Timestamp x) |
| void | updateTimestamp(String columnLabel, java.sql.Timestamp x) |
| void | updateBoolean(String columnLabel, boolean x) |
| void | updateObject(int columnIndex, Object x, int scaleOrLength) |
| void | updateObject(int columnIndex, Object x) |
| void | updateObject(String columnLabel, Object x, int scaleOrLength) |
| void | updateObject(String columnLabel, Object x) |
| void | updateObject(int columnIndex, Object x, SQLType targetSqlType, int scaleOrLength) |
| void | updateObject(String columnLabel, Object x, SQLType targetSqlType, int scaleOrLength) |
| void | updateObject(int columnIndex, Object x, SQLType targetSqlType) |
| void | updateObject(String columnLabel, Object x, SQLType targetSqlType) |
| void | insertRow() |
| void | updateRow() |
| void | deleteRow() |
| void | updateBytes(int columnIndex, byte x[]) |
| void | updateBytes(String columnLabel, byte x[]) |
| void | updateRowId(int columnIndex, RowId x) |
| void | updateRowId(String columnLabel, RowId x) |
| void | moveToInsertRow() |
| void | moveToCurrentRow() |
| void | refreshRow() |
未支持功能:
| 返回类型 | 方法 |
|---|---|
| java.net.URL | getURL(int columnIndex) |
| java.net.URL | getURL(String columnLabel) |
| java.io.InputStream | getUnicodeStream(int columnIndex) |
| java.io.InputStream | getUnicodeStream(String columnLabel) |
| java.io.Reader | getNCharacterStream(int columnIndex) |
| java.io.Reader | getNCharacterStream(String columnLabel) |
| SQLWarning | getWarnings() |
| void | clearWarnings() |
| String | getCursorName() |
| void | setFetchDirection(int direction) |
| int | getFetchDirection() |
| void | setFetchSize(int rows) |
| int | getFetchSize() |
| void | updateArray(int columnIndex, java.sql.Array x) |
| void | updateArray(String columnLabel, java.sql.Array x) |
| void | updateRef(int columnIndex, java.sql.Ref x) |
| void | updateRef(String columnLabel, java.sql.Ref x) |
| void | updateBlob(int columnIndex, java.sql.Blob x) |
| void | updateBlob(String columnLabel, java.sql.Blob x) |
| void | updateBlob(int columnIndex, InputStream inputStream, long length) |
| void | updateBlob(String columnLabel, InputStream inputStream, long length) |
| void | updateBlob(int columnIndex, InputStream inputStream) |
| void | updateBlob(String columnLabel, InputStream inputStream) |
| void | updateClob(int columnIndex, java.sql.Clob x) |
| void | updateClob(int columnIndex, Reader reader) |
| void | updateClob(String columnLabel, Reader reader) |
| void | updateClob(String columnLabel, java.sql.Clob x) |
| void | updateClob(int columnIndex, Reader reader, long length) |
| void | updateClob(String columnLabel, Reader reader, long length) |
| void | updateNClob(int columnIndex, NClob nClob) |
| void | updateNClob(String columnLabel, NClob nClob) |
| void | updateNClob(int columnIndex, Reader reader, long length) |
| void | updateNClob(String columnLabel, Reader reader, long length) |
| void | updateNClob(int columnIndex, Reader reader) |
| void | updateNClob(String columnLabel, Reader reader) |
| void | updateCharacterStream(int columnIndex, java.io.Reader x, int length) |
| void | updateCharacterStream(String columnLabel, java.io.Reader reader, int length) |
| void | updateCharacterStream(int columnIndex, java.io.Reader x, long length) |
| void | updateCharacterStream(String columnLabel,java.io.Reader reader,long length) |
| void | updateCharacterStream(int columnIndex, java.io.Reader x) |
| void | updateCharacterStream(String columnLabel, java.io.Reader reader) |
| void | updateNCharacterStream(int columnIndex, java.io.Reader x) |
| void | updateNCharacterStream(int columnIndex, java.io.Reader x, long length) |
| void | updateNCharacterStream(String columnLabel, java.io.Reader reader, long length) |
| void | updateNCharacterStream(String columnLabel, java.io.Reader reader) |
| void | updateAsciiStream(int columnIndex, java.io.InputStream x, long length) |
| void | updateAsciiStream(String columnLabel, java.io.InputStream x, long length) |
| void | updateAsciiStream(int columnIndex, java.io.InputStream x) |
| void | updateBinaryStream(int columnIndex, java.io.InputStream x, long length) |
| void | updateAsciiStream(String columnLabel, java.io.InputStream x) |
| void | updateBinaryStream(int columnIndex, java.io.InputStream x, int length) |
| void | updateBinaryStream(String columnLabel, java.io.InputStream x, int length) |
| void | updateBinaryStream(String columnLabel,java.io.InputStream x,long length) |
| void | updateBinaryStream(int columnIndex, java.io.InputStream x) |
| void | updateBinaryStream(String columnLabel, java.io.InputStream x) |
| void | updateNString(int columnIndex, String nString) |
| void | updateNString(String columnLabel, String nString) |
| void | cancelRowUpdates() |
| Ref | getRef(int columnIndex) |
| Ref | getRef(String columnLabel) |
| NClob | getNClob(int columnIndex) |
| NClob | getNClob(String columnLabel) |
| int | getHoldability() |

