更新时间:2024-11-12 GMT+08:00
分享

java.sql.ResultSet

java.sql.ResultSet是执行结果集接口。

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

相关文档