Package 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
The default implementation of Spring's SqlRowSet interface, wrapping a ResultSet, catching any SQLExceptions and translating them to a corresponding Spring InvalidResultSetAccessException.

The passed-in ResultSet 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: Since JDBC 4.0, it has been clarified that any methods using a String to identify the column should be using the column label. The column label is assigned using the ALIAS keyword in the SQL query string. When the query doesn't use an ALIAS, the default label is the column name. Most JDBC ResultSet implementations follow this new pattern but there are exceptions such as the com.sun.rowset.CachedRowSetImpl class which only uses the column name, ignoring any column labels. As of Spring 3.0.5, ResultSetWrappingSqlRowSet will translate column labels to the correct column index to provide better support for the com.sun.rowset.CachedRowSetImpl which is the default implementation used by JdbcTemplate when working with RowSets.

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 actually serializable, so this should usually work out.

Since:
1.2
Author:
Thomas Risberg, Juergen Hoeller
See Also:

  • Constructor Summary

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

  • Method Summary

    Modifier and Type
    Method
    Description
    boolean
    absolute(int row)
    Move the cursor to the given row number in the row set, just after the last row.
    void
    afterLast()
    Move the cursor to the end of this row set.
    void
    beforeFirst()
    Move the cursor to the front of this row set, just before the first row.
    int
    findColumn(String columnLabel)
    Map the given column label to its column index.
    boolean
    first()
    Move the cursor to the first row of this row set.
    BigDecimal
    getBigDecimal(int columnIndex)
    Retrieve the value of the indicated column in the current row as a BigDecimal object.
    BigDecimal
    getBigDecimal(String columnLabel)
    Retrieve the value of the indicated column in the current row as a BigDecimal object.
    boolean
    getBoolean(int columnIndex)
    Retrieve the value of the indicated column in the current row as a boolean.
    boolean
    getBoolean(String columnLabel)
    Retrieve the value of the indicated column in the current row as a boolean.
    byte
    getByte(int columnIndex)
    Retrieve the value of the indicated column in the current row as a byte.
    byte
    getByte(String columnLabel)
    Retrieve the value of the indicated column in the current row as a byte.
    Date
    getDate(int columnIndex)
    Retrieve the value of the indicated column in the current row as a Date object.
    Date
    getDate(int columnIndex, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Date object.
    Date
    getDate(String columnLabel)
    Retrieve the value of the indicated column in the current row as a Date object.
    Date
    getDate(String columnLabel, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Date object.
    double
    getDouble(int columnIndex)
    Retrieve the value of the indicated column in the current row as a Double object.
    double
    getDouble(String columnLabel)
    Retrieve the value of the indicated column in the current row as a Double object.
    float
    getFloat(int columnIndex)
    Retrieve the value of the indicated column in the current row as a float.
    float
    getFloat(String columnLabel)
    Retrieve the value of the indicated column in the current row as a float.
    int
    getInt(int columnIndex)
    Retrieve the value of the indicated column in the current row as an int.
    int
    getInt(String columnLabel)
    Retrieve the value of the indicated column in the current row as an int.
    long
    getLong(int columnIndex)
    Retrieve the value of the indicated column in the current row as a long.
    long
    getLong(String columnLabel)
    Retrieve the value of the indicated column in the current row as a long.
    final SqlRowSetMetaData
    getMetaData()
    Retrieve the meta-data, i.e.
    String
    getNString(int columnIndex)
    Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns).
    String
    getNString(String columnLabel)
    Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns).
    Object
    getObject(int columnIndex)
    Retrieve the value of the indicated column in the current row as an Object.
    <T> T
    getObject(int columnIndex, Class<T> type)
    Retrieve the value of the indicated column in the current row as an Object.
    Object
    getObject(int columnIndex, Map<String,Class<?>> map)
    Retrieve the value of the indicated column in the current row as an Object.
    Object
    getObject(String columnLabel)
    Retrieve the value of the indicated column in the current row as an Object.
    <T> T
    getObject(String columnLabel, Class<T> type)
    Retrieve the value of the indicated column in the current row as an Object.
    Object
    getObject(String columnLabel, Map<String,Class<?>> map)
    Retrieve the value of the indicated column in the current row as an Object.
    final ResultSet
    getResultSet()
    Return the underlying ResultSet (usually a javax.sql.rowset.CachedRowSet).
    int
    getRow()
    Retrieve the current row number.
    short
    getShort(int columnIndex)
    Retrieve the value of the indicated column in the current row as a short.
    short
    getShort(String columnLabel)
    Retrieve the value of the indicated column in the current row as a short.
    String
    getString(int columnIndex)
    Retrieve the value of the indicated column in the current row as a String.
    String
    getString(String columnLabel)
    Retrieve the value of the indicated column in the current row as a String.
    Time
    getTime(int columnIndex)
    Retrieve the value of the indicated column in the current row as a Time object.
    Time
    getTime(int columnIndex, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Time object.
    Time
    getTime(String columnLabel)
    Retrieve the value of the indicated column in the current row as a Time object.
    Time
    getTime(String columnLabel, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Time object.
    Timestamp
    getTimestamp(int columnIndex)
    Retrieve the value of the indicated column in the current row as a Timestamp object.
    Timestamp
    getTimestamp(int columnIndex, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Timestamp object.
    Timestamp
    getTimestamp(String columnLabel)
    Retrieve the value of the indicated column in the current row as a Timestamp object.
    Timestamp
    getTimestamp(String columnLabel, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Timestamp object.
    boolean
    isAfterLast()
    Retrieve whether the cursor is after the last row of this row set.
    boolean
    isBeforeFirst()
    Retrieve whether the cursor is before the first row of this row set.
    boolean
    isFirst()
    Retrieve whether the cursor is on the first row of this row set.
    boolean
    isLast()
    Retrieve whether the cursor is on the last row of this row set.
    boolean
    last()
    Move the cursor to the last row of this row set.
    boolean
    next()
    Move the cursor to the next row.
    boolean
    previous()
    Move the cursor to the previous row.
    boolean
    relative(int rows)
    Move the cursor a relative number of rows, either positive or negative.
    boolean
    wasNull()
    Report 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