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

java.sql.ResultSet - 图1 说明:

  • 一个Statement不能有多个处于“open”状态的ResultSet。

  • 用于遍历结果集(ResultSet)的游标(Cursor)在被提交后不能保持“open”的状态。