Interface SqlRowSet

All Superinterfaces:
Serializable
All Known Implementing Classes:
ResultSetWrappingSqlRowSet

public interface SqlRowSet extends Serializable
Mirror interface for RowSet, representing a disconnected variant of ResultSet data.

The main difference to the standard JDBC RowSet is that a SQLException is never thrown here. This allows an SqlRowSet to be used without having to deal with checked exceptions. An SqlRowSet will throw Spring's InvalidResultSetAccessException instead (when appropriate).

Note: This interface extends the java.io.Serializable marker interface. Implementations, which typically hold disconnected data, are encouraged to be actually serializable (as far as possible).

Since:
1.2
Author:
Thomas Risberg, Juergen Hoeller
See Also:
  • 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
    Move the cursor to the end of this row set.
    void
    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
    Move the cursor to the first row of this row set.
    getBigDecimal(int columnIndex)
    Retrieve the value of the indicated column in the current row as a BigDecimal object.
    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.
    getDate(int columnIndex)
    Retrieve the value of the indicated column in the current row as a Date object.
    getDate(int columnIndex, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Date object.
    getDate(String columnLabel)
    Retrieve the value of the indicated column in the current row as a Date object.
    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.
    Retrieve the meta-data, i.e.
    getNString(int columnIndex)
    Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns).
    getNString(String columnLabel)
    Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns).
    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.
    getObject(int columnIndex, Map<String,Class<?>> map)
    Retrieve the value of the indicated column in the current row as an 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.
    getObject(String columnLabel, Map<String,Class<?>> map)
    Retrieve the value of the indicated column in the current row as an Object.
    int
    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.
    getString(int columnIndex)
    Retrieve the value of the indicated column in the current row as a String.
    getString(String columnLabel)
    Retrieve the value of the indicated column in the current row as a String.
    getTime(int columnIndex)
    Retrieve the value of the indicated column in the current row as a Time object.
    getTime(int columnIndex, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Time object.
    getTime(String columnLabel)
    Retrieve the value of the indicated column in the current row as a Time object.
    getTime(String columnLabel, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Time object.
    getTimestamp(int columnIndex)
    Retrieve the value of the indicated column in the current row as a Timestamp object.
    getTimestamp(int columnIndex, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Timestamp object.
    getTimestamp(String columnLabel)
    Retrieve the value of the indicated column in the current row as a Timestamp object.
    getTimestamp(String columnLabel, Calendar cal)
    Retrieve the value of the indicated column in the current row as a Timestamp object.
    boolean
    Retrieve whether the cursor is after the last row of this row set.
    boolean
    Retrieve whether the cursor is before the first row of this row set.
    boolean
    Retrieve whether the cursor is on the first row of this row set.
    boolean
    Retrieve whether the cursor is on the last row of this row set.
    boolean
    Move the cursor to the last row of this row set.
    boolean
    Move the cursor to the next row.
    boolean
    Move the cursor to the previous row.
    boolean
    relative(int rows)
    Move the cursor a relative number of rows, either positive or negative.
    boolean
    Report whether the last column read had a value of SQL NULL.