public interface SqlRowSet extends Serializable
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).
RowSet
,
ResultSet
,
InvalidResultSetAccessException
,
JdbcTemplate.queryForRowSet(java.lang.String)
Modifier and Type | Method and 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.
|
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.
|
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 . |
SqlRowSetMetaData getMetaData()
ResultSet.getMetaData()
int findColumn(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the name of the columnInvalidResultSetAccessException
ResultSet.findColumn(String)
@Nullable BigDecimal getBigDecimal(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getBigDecimal(int)
@Nullable BigDecimal getBigDecimal(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getBigDecimal(String)
boolean getBoolean(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getBoolean(int)
boolean getBoolean(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getBoolean(String)
byte getByte(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getByte(int)
byte getByte(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getByte(String)
@Nullable Date getDate(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getDate(int)
@Nullable Date getDate(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getDate(String)
@Nullable Date getDate(int columnIndex, Calendar cal) throws InvalidResultSetAccessException
columnIndex
- the column indexcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getDate(int, Calendar)
@Nullable Date getDate(String columnLabel, Calendar cal) throws InvalidResultSetAccessException
columnLabel
- the column labelcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getDate(String, Calendar)
double getDouble(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getDouble(int)
double getDouble(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getDouble(String)
float getFloat(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getFloat(int)
float getFloat(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getFloat(String)
int getInt(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getInt(int)
int getInt(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getInt(String)
long getLong(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getLong(int)
long getLong(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getLong(String)
@Nullable String getNString(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getNString(int)
@Nullable String getNString(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getNString(String)
@Nullable Object getObject(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getObject(int)
@Nullable Object getObject(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getObject(String)
@Nullable Object getObject(int columnIndex, Map<String,Class<?>> map) throws InvalidResultSetAccessException
columnIndex
- the column indexmap
- a Map object containing the mapping from SQL types to Java typesInvalidResultSetAccessException
ResultSet.getObject(int, Map)
@Nullable Object getObject(String columnLabel, Map<String,Class<?>> map) throws InvalidResultSetAccessException
columnLabel
- the column labelmap
- a Map object containing the mapping from SQL types to Java typesInvalidResultSetAccessException
ResultSet.getObject(String, Map)
@Nullable <T> T getObject(int columnIndex, Class<T> type) throws InvalidResultSetAccessException
columnIndex
- the column indextype
- the Java type to convert the designated column toInvalidResultSetAccessException
ResultSet.getObject(int, Class)
@Nullable <T> T getObject(String columnLabel, Class<T> type) throws InvalidResultSetAccessException
columnLabel
- the column labeltype
- the Java type to convert the designated column toInvalidResultSetAccessException
ResultSet.getObject(String, Class)
short getShort(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getShort(int)
short getShort(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getShort(String)
@Nullable String getString(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getString(int)
@Nullable String getString(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getString(String)
@Nullable Time getTime(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getTime(int)
@Nullable Time getTime(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getTime(String)
@Nullable Time getTime(int columnIndex, Calendar cal) throws InvalidResultSetAccessException
columnIndex
- the column indexcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getTime(int, Calendar)
@Nullable Time getTime(String columnLabel, Calendar cal) throws InvalidResultSetAccessException
columnLabel
- the column labelcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getTime(String, Calendar)
@Nullable Timestamp getTimestamp(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getTimestamp(int)
@Nullable Timestamp getTimestamp(String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getTimestamp(String)
@Nullable Timestamp getTimestamp(int columnIndex, Calendar cal) throws InvalidResultSetAccessException
columnIndex
- the column indexcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getTimestamp(int, Calendar)
@Nullable Timestamp getTimestamp(String columnLabel, Calendar cal) throws InvalidResultSetAccessException
columnLabel
- the column labelcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getTimestamp(String, Calendar)
boolean absolute(int row) throws InvalidResultSetAccessException
row
- the number of the row where the cursor should movetrue
if the cursor is on the row set, false
otherwiseInvalidResultSetAccessException
ResultSet.absolute(int)
void afterLast() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.afterLast()
void beforeFirst() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.beforeFirst()
boolean first() throws InvalidResultSetAccessException
true
if the cursor is on a valid row, false
otherwiseInvalidResultSetAccessException
ResultSet.first()
int getRow() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.getRow()
boolean isAfterLast() throws InvalidResultSetAccessException
true
if the cursor is after the last row, false
otherwiseInvalidResultSetAccessException
ResultSet.isAfterLast()
boolean isBeforeFirst() throws InvalidResultSetAccessException
true
if the cursor is before the first row, false
otherwiseInvalidResultSetAccessException
ResultSet.isBeforeFirst()
boolean isFirst() throws InvalidResultSetAccessException
true
if the cursor is after the first row, false
otherwiseInvalidResultSetAccessException
ResultSet.isFirst()
boolean isLast() throws InvalidResultSetAccessException
true
if the cursor is after the last row, false
otherwiseInvalidResultSetAccessException
ResultSet.isLast()
boolean last() throws InvalidResultSetAccessException
true
if the cursor is on a valid row, false
otherwiseInvalidResultSetAccessException
ResultSet.last()
boolean next() throws InvalidResultSetAccessException
true
if the new row is valid, false
if there are no more rowsInvalidResultSetAccessException
ResultSet.next()
boolean previous() throws InvalidResultSetAccessException
true
if the new row is valid, false
if it is off the row setInvalidResultSetAccessException
ResultSet.previous()
boolean relative(int rows) throws InvalidResultSetAccessException
true
if the cursor is on a row, false
otherwiseInvalidResultSetAccessException
ResultSet.relative(int)
boolean wasNull() throws InvalidResultSetAccessException
NULL
.
Note that you must first call one of the getter methods and then
call the wasNull()
method.
true
if the most recent column retrieved was
SQL NULL
, false
otherwiseInvalidResultSetAccessException
ResultSet.wasNull()