|
The Spring Framework | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface SqlRowSet
Mirror interface for 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)
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 columnIndex,
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. |
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 . |
Method Detail |
---|
SqlRowSetMetaData getMetaData()
ResultSet.getMetaData()
int findColumn(String columnName) throws InvalidResultSetAccessException
columnName
- the name of the column
InvalidResultSetAccessException
ResultSet.findColumn(String)
BigDecimal getBigDecimal(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getBigDecimal(int)
BigDecimal getBigDecimal(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getBigDecimal(java.lang.String)
boolean getBoolean(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getBoolean(int)
boolean getBoolean(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getBoolean(java.lang.String)
byte getByte(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getByte(int)
byte getByte(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getByte(java.lang.String)
Date getDate(int columnIndex, Calendar cal) throws InvalidResultSetAccessException
columnIndex
- the column indexcal
- the Calendar to use in constructing the Date
InvalidResultSetAccessException
ResultSet.getDate(int, java.util.Calendar)
Date getDate(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getDate(int)
Date getDate(String columnName, Calendar cal) throws InvalidResultSetAccessException
columnName
- the column namecal
- the Calendar to use in constructing the Date
InvalidResultSetAccessException
ResultSet.getDate(java.lang.String, java.util.Calendar)
Date getDate(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getDate(java.lang.String)
double getDouble(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getDouble(int)
double getDouble(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getDouble(java.lang.String)
float getFloat(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getFloat(int)
float getFloat(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getFloat(java.lang.String)
int getInt(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getInt(int)
int getInt(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getInt(java.lang.String)
long getLong(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getLong(int)
long getLong(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getLong(java.lang.String)
Object getObject(int columnIndex, Map map) throws InvalidResultSetAccessException
columnIndex
- the column indexmap
- a Map object containing the mapping from SQL types to Java types
InvalidResultSetAccessException
ResultSet.getObject(int, java.util.Map)
Object getObject(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getObject(int)
Object getObject(String columnName, Map map) throws InvalidResultSetAccessException
columnName
- the column namemap
- a Map object containing the mapping from SQL types to Java types
InvalidResultSetAccessException
ResultSet.getObject(java.lang.String, java.util.Map)
Object getObject(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getObject(java.lang.String)
short getShort(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getShort(int)
short getShort(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getShort(java.lang.String)
String getString(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getString(int)
String getString(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getString(java.lang.String)
Time getTime(int columnIndex, Calendar cal) throws InvalidResultSetAccessException
columnIndex
- the column indexcal
- the Calendar to use in constructing the Date
InvalidResultSetAccessException
ResultSet.getTime(int, java.util.Calendar)
Time getTime(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getTime(int)
Time getTime(String columnName, Calendar cal) throws InvalidResultSetAccessException
columnName
- the column namecal
- the Calendar to use in constructing the Date
InvalidResultSetAccessException
ResultSet.getTime(java.lang.String, java.util.Calendar)
Time getTime(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getTime(java.lang.String)
Timestamp getTimestamp(int columnIndex, Calendar cal) throws InvalidResultSetAccessException
columnIndex
- the column indexcal
- the Calendar to use in constructing the Date
InvalidResultSetAccessException
ResultSet.getTimestamp(int, java.util.Calendar)
Timestamp getTimestamp(int columnIndex) throws InvalidResultSetAccessException
columnIndex
- the column index
InvalidResultSetAccessException
ResultSet.getTimestamp(int)
Timestamp getTimestamp(String columnName, Calendar cal) throws InvalidResultSetAccessException
columnName
- the column namecal
- the Calendar to use in constructing the Date
InvalidResultSetAccessException
ResultSet.getTimestamp(java.lang.String, java.util.Calendar)
Timestamp getTimestamp(String columnName) throws InvalidResultSetAccessException
columnName
- the column name
InvalidResultSetAccessException
ResultSet.getTimestamp(java.lang.String)
boolean absolute(int row) throws InvalidResultSetAccessException
row
- the number of the row where the cursor should move
InvalidResultSetAccessException
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 otherwise
InvalidResultSetAccessException
ResultSet.wasNull()
|
The Spring Framework | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |