public interface SqlRowSet
extends java.io.Serializable
javax.sql.RowSet
, representing
disconnected java.sql.ResultSet
data.
The main difference to the standard JDBC RowSet is that an SQLException
is never thrown here. This allows a SqlRowSet to be used without having
to deal with checked exceptions. A SqlRowSet will throw Spring's
org.springframework.jdbc.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)
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(java.lang.String columnLabel)
Maps the given column label to its column index.
|
boolean |
first()
Moves the cursor to the first row of this RowSet.
|
java.math.BigDecimal |
getBigDecimal(int columnIndex)
Retrieves the value of the indicated column in the current row as
an BigDecimal object.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnLabel)
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(java.lang.String columnLabel)
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(java.lang.String columnLabel)
Retrieves the value of the indicated column in the current row as
a byte.
|
java.sql.Date |
getDate(int columnIndex)
Retrieves the value of the indicated column in the current row as
a Date object.
|
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal)
Retrieves the value of the indicated column in the current row as
a Date object.
|
java.sql.Date |
getDate(java.lang.String columnLabel)
Retrieves the value of the indicated column in the current row as
a Date object.
|
java.sql.Date |
getDate(java.lang.String columnLabel,
java.util.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(java.lang.String columnLabel)
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(java.lang.String columnLabel)
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(java.lang.String columnLabel)
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(java.lang.String columnLabel)
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.
|
java.lang.Object |
getObject(int columnIndex)
Retrieves the value of the indicated column in the current row as
an Object.
|
java.lang.Object |
getObject(int columnIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
Retrieves the value of the indicated column in the current row as
an Object.
|
java.lang.Object |
getObject(java.lang.String columnLabel)
Retrieves the value of the indicated column in the current row as
an Object.
|
java.lang.Object |
getObject(java.lang.String columnLabel,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
Retrieves the value of the indicated column in the current row as
an Object.
|
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(java.lang.String columnLabel)
Retrieves the value of the indicated column in the current row as
a short.
|
java.lang.String |
getString(int columnIndex)
Retrieves the value of the indicated column in the current row as
a String.
|
java.lang.String |
getString(java.lang.String columnLabel)
Retrieves the value of the indicated column in the current row as
a String.
|
java.sql.Time |
getTime(int columnIndex)
Retrieves the value of the indicated column in the current row as
a Time object.
|
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal)
Retrieves the value of the indicated column in the current row as
a Time object.
|
java.sql.Time |
getTime(java.lang.String columnLabel)
Retrieves the value of the indicated column in the current row as
a Time object.
|
java.sql.Time |
getTime(java.lang.String columnLabel,
java.util.Calendar cal)
Retrieves the value of the indicated column in the current row as
a Time object.
|
java.sql.Timestamp |
getTimestamp(int columnIndex)
Retrieves the value of the indicated column in the current row as
a Timestamp object.
|
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal)
Retrieves the value of the indicated column in the current row as
a Timestamp object.
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel)
Retrieves the value of the indicated column in the current row as
a Timestamp object.
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel,
java.util.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 . |
SqlRowSetMetaData getMetaData()
ResultSet.getMetaData()
int findColumn(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the name of the columnInvalidResultSetAccessException
ResultSet.findColumn(String)
java.math.BigDecimal getBigDecimal(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getBigDecimal(int)
java.math.BigDecimal getBigDecimal(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getBigDecimal(java.lang.String)
boolean getBoolean(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getBoolean(int)
boolean getBoolean(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getBoolean(java.lang.String)
byte getByte(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getByte(int)
byte getByte(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getByte(java.lang.String)
java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws InvalidResultSetAccessException
columnIndex
- the column indexcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getDate(int, java.util.Calendar)
java.sql.Date getDate(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getDate(int)
java.sql.Date getDate(java.lang.String columnLabel, java.util.Calendar cal) throws InvalidResultSetAccessException
columnLabel
- the column labelcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getDate(java.lang.String, java.util.Calendar)
java.sql.Date getDate(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getDate(java.lang.String)
double getDouble(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getDouble(int)
double getDouble(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getDouble(java.lang.String)
float getFloat(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getFloat(int)
float getFloat(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getFloat(java.lang.String)
int getInt(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getInt(int)
int getInt(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getInt(java.lang.String)
long getLong(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getLong(int)
long getLong(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getLong(java.lang.String)
java.lang.Object getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws InvalidResultSetAccessException
columnIndex
- the column indexmap
- a Map object containing the mapping from SQL types to Java typesInvalidResultSetAccessException
ResultSet.getObject(int, java.util.Map)
java.lang.Object getObject(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getObject(int)
java.lang.Object getObject(java.lang.String columnLabel, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws InvalidResultSetAccessException
columnLabel
- the column labelmap
- a Map object containing the mapping from SQL types to Java typesInvalidResultSetAccessException
ResultSet.getObject(java.lang.String, java.util.Map)
java.lang.Object getObject(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getObject(java.lang.String)
short getShort(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getShort(int)
short getShort(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getShort(java.lang.String)
java.lang.String getString(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getString(int)
java.lang.String getString(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getString(java.lang.String)
java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws InvalidResultSetAccessException
columnIndex
- the column indexcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getTime(int, java.util.Calendar)
java.sql.Time getTime(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getTime(int)
java.sql.Time getTime(java.lang.String columnLabel, java.util.Calendar cal) throws InvalidResultSetAccessException
columnLabel
- the column labelcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getTime(java.lang.String, java.util.Calendar)
java.sql.Time getTime(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getTime(java.lang.String)
java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws InvalidResultSetAccessException
columnIndex
- the column indexcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getTimestamp(int, java.util.Calendar)
java.sql.Timestamp getTimestamp(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column indexInvalidResultSetAccessException
ResultSet.getTimestamp(int)
java.sql.Timestamp getTimestamp(java.lang.String columnLabel, java.util.Calendar cal) throws InvalidResultSetAccessException
columnLabel
- the column labelcal
- the Calendar to use in constructing the DateInvalidResultSetAccessException
ResultSet.getTimestamp(java.lang.String, java.util.Calendar)
java.sql.Timestamp getTimestamp(java.lang.String columnLabel) throws InvalidResultSetAccessException
columnLabel
- the column labelInvalidResultSetAccessException
ResultSet.getTimestamp(java.lang.String)
boolean absolute(int row) throws InvalidResultSetAccessException
row
- the number of the row where the cursor should moveInvalidResultSetAccessException
ResultSet.absolute(int)
void afterLast() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.afterLast()
void beforeFirst() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.beforeFirst()
boolean first() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.first()
int getRow() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.getRow()
boolean isAfterLast() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.isAfterLast()
boolean isBeforeFirst() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.isBeforeFirst()
boolean isFirst() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.isFirst()
boolean isLast() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.isLast()
boolean last() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.last()
boolean next() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.next()
boolean previous() throws InvalidResultSetAccessException
InvalidResultSetAccessException
ResultSet.previous()
boolean relative(int rows) throws InvalidResultSetAccessException
InvalidResultSetAccessException
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.NULL
,
false otherwiseInvalidResultSetAccessException
ResultSet.wasNull()