ResultSetWrappingSqlRowSet (Spring Framework API 2.1) - Spring Framework 2.1.0 API 文档英文版

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

The Spring Framework

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.springframework.jdbc.support.rowset
Class ResultSetWrappingSqlRowSet

java.lang.Object
  org.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet

All Implemented Interfaces:: Serializable, SqlRowSet

public class ResultSetWrappingSqlRowSet
extends Object
implements SqlRowSet
extends Object
implements SqlRowSet

Default implementation of Spring's SqlRowSet interface.

This implementation wraps a javax.sql.ResultSet, catching any SQLExceptions and translating them to the appropriate Spring DataAccessException.

The passed-in ResultSets should already be disconnected if the SqlRowSet is supposed to be usable in a disconnected fashion. This means that you will usually pass in a javax.sql.rowset.CachedRowSet, which implements the ResultSet interface.

Note: This class implements the java.io.Serializable marker interface through the SqlRowSet interface, but is only actually serializable if the disconnected ResultSet/RowSet contained in it is serializable. Most CachedRowSet implementations are serializable.

Since:: 1.2
Author:: Thomas Risberg, Juergen Hoeller
See Also:: ResultSet, CachedRowSet, Serialized Form

Constructor Summary

ResultSetWrappingSqlRowSet(ResultSet resultSet)
          Create a new ResultSetWrappingSqlRowSet for the given ResultSet.

Method Summary

boolean absolute(int row)
          Moves the cursor to the given row number in the RowSet, just after the last row.

void afterLast()
          Moves the cursor to the end of this RowSet.

void beforeFirst()
          Moves the cursor to the front of this RowSet, just before the first row.

int findColumn(String columnName)
          Maps the given column name to its column index.

boolean first()
          Moves the cursor to the first row of this RowSet.

BigDecimal getBigDecimal(int columnIndex)
          Retrieves the value of the indicated column in the current row as an BigDecimal object.

BigDecimal getBigDecimal(String columnName)
          Retrieves the value of the indicated column in the current row as an BigDecimal object.

boolean getBoolean(int columnIndex)
          Retrieves the value of the indicated column in the current row as a boolean.

boolean getBoolean(String columnName)
          Retrieves the value of the indicated column in the current row as a boolean.

byte getByte(int columnIndex)
          Retrieves the value of the indicated column in the current row as a byte.

byte getByte(String columnName)
          Retrieves the value of the indicated column in the current row as a byte.

Date getDate(int columnIndex)
          Retrieves the value of the indicated column in the current row as a Date object.

Date getDate(int columnIndex, Calendar cal)
          Retrieves the value of the indicated column in the current row as a Date object.

Date getDate(String columnName)
          Retrieves the value of the indicated column in the current row as a Date object.

Date getDate(String columnName, Calendar cal)
          Retrieves the value of the indicated column in the current row as a Date object.

double getDouble(int columnIndex)
          Retrieves the value of the indicated column in the current row as a Double object.

double getDouble(String columnName)
          Retrieves the value of the indicated column in the current row as a Double object.

float getFloat(int columnIndex)
          Retrieves the value of the indicated column in the current row as a float.

float getFloat(String columnName)
          Retrieves the value of the indicated column in the current row as a float.

int getInt(int columnIndex)
          Retrieves the value of the indicated column in the current row as an int.

int getInt(String columnName)
          Retrieves the value of the indicated column in the current row as an int.

long getLong(int columnIndex)
          Retrieves the value of the indicated column in the current row as a long.

long getLong(String columnName)
          Retrieves the value of the indicated column in the current row as a long.

SqlRowSetMetaData getMetaData()
          Retrieves the meta data (number, types and properties for the columns) of this row set.

Object getObject(int columnIndex)
          Retrieves the value of the indicated column in the current row as an Object.

Object getObject(int i, Map map)
          Retrieves the value of the indicated column in the current row as an Object.

Object getObject(String columnName)
          Retrieves the value of the indicated column in the current row as an Object.

Object getObject(String columnName, Map map)
          Retrieves the value of the indicated column in the current row as an Object.

ResultSet getResultSet()
          Return the underlying ResultSet (usually a javax.sql.rowset.CachedRowSet).

int getRow()
          Retrieves the current row number.

short getShort(int columnIndex)
          Retrieves the value of the indicated column in the current row as a short.

short getShort(String columnName)
          Retrieves the value of the indicated column in the current row as a short.

String getString(int columnIndex)
          Retrieves the value of the indicated column in the current row as a String.

String getString(String columnName)
          Retrieves the value of the indicated column in the current row as a String.

Time getTime(int columnIndex)
          Retrieves the value of the indicated column in the current row as a Time object.

Time getTime(int columnIndex, Calendar cal)
          Retrieves the value of the indicated column in the current row as a Time object.

Time getTime(String columnName)
          Retrieves the value of the indicated column in the current row as a Time object.

Time getTime(String columnName, Calendar cal)
          Retrieves the value of the indicated column in the current row as a Time object.

Timestamp getTimestamp(int columnIndex)
          Retrieves the value of the indicated column in the current row as a Timestamp object.

Timestamp getTimestamp(int columnIndex, Calendar cal)
          Retrieves the value of the indicated column in the current row as a Timestamp object.

Timestamp getTimestamp(String columnName)
          Retrieves the value of the indicated column in the current row as a Timestamp object.

Timestamp getTimestamp(String columnName, Calendar cal)
          Retrieves the value of the indicated column in the current row as a Timestamp object.

boolean isAfterLast()
          Retrieves whether the cursor is after the last row of this RowSet.

boolean isBeforeFirst()
          Retrieves whether the cursor is after the first row of this RowSet.

boolean isFirst()
          Retrieves whether the cursor is on the first row of this RowSet.

boolean isLast()
          Retrieves whether the cursor is on the last row of this RowSet.

boolean last()
          Moves the cursor to the last row of this RowSet.

boolean next()
          Moves the cursor to the next row.

boolean previous()
          Moves the cursor to the previous row.

boolean relative(int rows)
          Moves the cursor a relative number f rows, either positive or negative.

boolean wasNull()
          Reports whether the last column read had a value of SQL NULL.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Summary
`ResultSetWrappingSqlRowSet(ResultSet resultSet)` Create a new ResultSetWrappingSqlRowSet for the given ResultSet.

Method Summary
`boolean`	`absolute(int row)` Moves the cursor to the given row number in the RowSet, just after the last row.
`void`	`afterLast()` Moves the cursor to the end of this RowSet.
`void`	`beforeFirst()` Moves the cursor to the front of this RowSet, just before the first row.
`int`	`findColumn(String columnName)` Maps the given column name to its column index.
`boolean`	`first()` Moves the cursor to the first row of this RowSet.
`BigDecimal`	`getBigDecimal(int columnIndex)` Retrieves the value of the indicated column in the current row as an BigDecimal object.
`BigDecimal`	`getBigDecimal(String columnName)` Retrieves the value of the indicated column in the current row as an BigDecimal object.
`boolean`	`getBoolean(int columnIndex)` Retrieves the value of the indicated column in the current row as a boolean.
`boolean`	`getBoolean(String columnName)` Retrieves the value of the indicated column in the current row as a boolean.
`byte`	`getByte(int columnIndex)` Retrieves the value of the indicated column in the current row as a byte.
`byte`	`getByte(String columnName)` Retrieves the value of the indicated column in the current row as a byte.
`Date`	`getDate(int columnIndex)` Retrieves the value of the indicated column in the current row as a Date object.
`Date`	`getDate(int columnIndex, Calendar cal)` Retrieves the value of the indicated column in the current row as a Date object.
`Date`	`getDate(String columnName)` Retrieves the value of the indicated column in the current row as a Date object.
`Date`	`getDate(String columnName, Calendar cal)` Retrieves the value of the indicated column in the current row as a Date object.
`double`	`getDouble(int columnIndex)` Retrieves the value of the indicated column in the current row as a Double object.
`double`	`getDouble(String columnName)` Retrieves the value of the indicated column in the current row as a Double object.
`float`	`getFloat(int columnIndex)` Retrieves the value of the indicated column in the current row as a float.
`float`	`getFloat(String columnName)` Retrieves the value of the indicated column in the current row as a float.
`int`	`getInt(int columnIndex)` Retrieves the value of the indicated column in the current row as an int.
`int`	`getInt(String columnName)` Retrieves the value of the indicated column in the current row as an int.
`long`	`getLong(int columnIndex)` Retrieves the value of the indicated column in the current row as a long.
`long`	`getLong(String columnName)` Retrieves the value of the indicated column in the current row as a long.
`SqlRowSetMetaData`	`getMetaData()` Retrieves the meta data (number, types and properties for the columns) of this row set.
`Object`	`getObject(int columnIndex)` Retrieves the value of the indicated column in the current row as an Object.
`Object`	`getObject(int i, Map map)` Retrieves the value of the indicated column in the current row as an Object.
`Object`	`getObject(String columnName)` Retrieves the value of the indicated column in the current row as an Object.
`Object`	`getObject(String columnName, Map map)` Retrieves the value of the indicated column in the current row as an Object.
`ResultSet`	`getResultSet()` Return the underlying ResultSet (usually a `javax.sql.rowset.CachedRowSet`).
`int`	`getRow()` Retrieves the current row number.
`short`	`getShort(int columnIndex)` Retrieves the value of the indicated column in the current row as a short.
`short`	`getShort(String columnName)` Retrieves the value of the indicated column in the current row as a short.
`String`	`getString(int columnIndex)` Retrieves the value of the indicated column in the current row as a String.
`String`	`getString(String columnName)` Retrieves the value of the indicated column in the current row as a String.
`Time`	`getTime(int columnIndex)` Retrieves the value of the indicated column in the current row as a Time object.
`Time`	`getTime(int columnIndex, Calendar cal)` Retrieves the value of the indicated column in the current row as a Time object.
`Time`	`getTime(String columnName)` Retrieves the value of the indicated column in the current row as a Time object.
`Time`	`getTime(String columnName, Calendar cal)` Retrieves the value of the indicated column in the current row as a Time object.
`Timestamp`	`getTimestamp(int columnIndex)` Retrieves the value of the indicated column in the current row as a Timestamp object.
`Timestamp`	`getTimestamp(int columnIndex, Calendar cal)` Retrieves the value of the indicated column in the current row as a Timestamp object.
`Timestamp`	`getTimestamp(String columnName)` Retrieves the value of the indicated column in the current row as a Timestamp object.
`Timestamp`	`getTimestamp(String columnName, Calendar cal)` Retrieves the value of the indicated column in the current row as a Timestamp object.
`boolean`	`isAfterLast()` Retrieves whether the cursor is after the last row of this RowSet.
`boolean`	`isBeforeFirst()` Retrieves whether the cursor is after the first row of this RowSet.
`boolean`	`isFirst()` Retrieves whether the cursor is on the first row of this RowSet.
`boolean`	`isLast()` Retrieves whether the cursor is on the last row of this RowSet.
`boolean`	`last()` Moves the cursor to the last row of this RowSet.
`boolean`	`next()` Moves the cursor to the next row.
`boolean`	`previous()` Moves the cursor to the previous row.
`boolean`	`relative(int rows)` Moves the cursor a relative number f rows, either positive or negative.
`boolean`	`wasNull()` Reports whether the last column read had a value of SQL `NULL`.

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Constructor Detail

ResultSetWrappingSqlRowSet

public ResultSetWrappingSqlRowSet(ResultSet resultSet)
                           throws InvalidResultSetAccessException

Create a new ResultSetWrappingSqlRowSet for the given ResultSet.

Parameters:: resultSet - a disconnected ResultSet to wrap (usually a javax.sql.rowset.CachedRowSet)
Throws:: InvalidResultSetAccessException - if extracting the ResultSetMetaData failed
See Also:: CachedRowSet, ResultSet.getMetaData(), ResultSetWrappingSqlRowSetMetaData

Method Detail

getResultSet

public ResultSet getResultSet()

Return the underlying ResultSet (usually a javax.sql.rowset.CachedRowSet).

See Also:: CachedRowSet