|
|||||||||
| 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 columnLabel)
Maps the given column label 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 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(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(String columnLabel)
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 columnLabel)
Retrieves the value of the indicated column in the current row as a Date object. |
Date |
getDate(String columnLabel,
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 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(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(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(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. |
Object |
getObject(int columnIndex)
Retrieves the value of the indicated column in the current row as an Object. |
Object |
getObject(int columnIndex,
Map<String,Class<?>> map)
Retrieves the value of the indicated column in the current row as an Object. |
Object |
getObject(String columnLabel)
Retrieves the value of the indicated column in the current row as an Object. |
Object |
getObject(String columnLabel,
Map<String,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(String columnLabel)
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 columnLabel)
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 columnLabel)
Retrieves the value of the indicated column in the current row as a Time object. |
Time |
getTime(String columnLabel,
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 columnLabel)
Retrieves the value of the indicated column in the current row as a Timestamp object. |
Timestamp |
getTimestamp(String columnLabel,
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 columnLabel)
throws InvalidResultSetAccessException
columnLabel - the name of the column
InvalidResultSetAccessExceptionResultSet.findColumn(String)
BigDecimal getBigDecimal(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getBigDecimal(int)
BigDecimal getBigDecimal(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getBigDecimal(java.lang.String)
boolean getBoolean(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getBoolean(int)
boolean getBoolean(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getBoolean(java.lang.String)
byte getByte(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getByte(int)
byte getByte(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getByte(java.lang.String)
Date getDate(int columnIndex,
Calendar cal)
throws InvalidResultSetAccessException
columnIndex - the column indexcal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getDate(int, java.util.Calendar)
Date getDate(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getDate(int)
Date getDate(String columnLabel,
Calendar cal)
throws InvalidResultSetAccessException
columnLabel - the column labelcal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getDate(java.lang.String, java.util.Calendar)
Date getDate(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getDate(java.lang.String)
double getDouble(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getDouble(int)
double getDouble(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getDouble(java.lang.String)
float getFloat(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getFloat(int)
float getFloat(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getFloat(java.lang.String)
int getInt(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getInt(int)
int getInt(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getInt(java.lang.String)
long getLong(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getLong(int)
long getLong(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getLong(java.lang.String)
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 types
InvalidResultSetAccessExceptionResultSet.getObject(int, java.util.Map)
Object getObject(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getObject(int)
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 types
InvalidResultSetAccessExceptionResultSet.getObject(java.lang.String, java.util.Map)
Object getObject(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getObject(java.lang.String)
short getShort(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getShort(int)
short getShort(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getShort(java.lang.String)
String getString(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getString(int)
String getString(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getString(java.lang.String)
Time getTime(int columnIndex,
Calendar cal)
throws InvalidResultSetAccessException
columnIndex - the column indexcal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTime(int, java.util.Calendar)
Time getTime(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getTime(int)
Time getTime(String columnLabel,
Calendar cal)
throws InvalidResultSetAccessException
columnLabel - the column labelcal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTime(java.lang.String, java.util.Calendar)
Time getTime(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getTime(java.lang.String)
Timestamp getTimestamp(int columnIndex,
Calendar cal)
throws InvalidResultSetAccessException
columnIndex - the column indexcal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTimestamp(int, java.util.Calendar)
Timestamp getTimestamp(int columnIndex)
throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getTimestamp(int)
Timestamp getTimestamp(String columnLabel,
Calendar cal)
throws InvalidResultSetAccessException
columnLabel - the column labelcal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTimestamp(java.lang.String, java.util.Calendar)
Timestamp getTimestamp(String columnLabel)
throws InvalidResultSetAccessException
columnLabel - the column label
InvalidResultSetAccessExceptionResultSet.getTimestamp(java.lang.String)
boolean absolute(int row)
throws InvalidResultSetAccessException
row - the number of the row where the cursor should move
InvalidResultSetAccessExceptionResultSet.absolute(int)
void afterLast()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.afterLast()
void beforeFirst()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.beforeFirst()
boolean first()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.first()
int getRow()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.getRow()
boolean isAfterLast()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.isAfterLast()
boolean isBeforeFirst()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.isBeforeFirst()
boolean isFirst()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.isFirst()
boolean isLast()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.isLast()
boolean last()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.last()
boolean next()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.next()
boolean previous()
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.previous()
boolean relative(int rows)
throws InvalidResultSetAccessException
InvalidResultSetAccessExceptionResultSet.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
InvalidResultSetAccessExceptionResultSet.wasNull()
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||