|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet
public class ResultSetWrappingSqlRowSet
Default implementation of Spring's SqlRowSet interface.
This implementation wraps a javax.sql.ResultSet,
catching any SQLExceptions and translating them to the
appropriate Spring InvalidResultSetAccessException.
The passed-in ResultSets should already be disconnected if the SqlRowSet
is supposed to be usable in a disconnected fashion. This means that
you will usually pass in a javax.sql.rowset.CachedRowSet,
which implements the ResultSet interface.
Note: This class implements the java.io.Serializable
marker interface through the SqlRowSet interface, but is only actually
serializable if the disconnected ResultSet/RowSet contained in it is
serializable. Most CachedRowSet implementations are actually serializable.
ResultSet,
CachedRowSet,
Serialized Form| Constructor Summary | |
|---|---|
ResultSetWrappingSqlRowSet(ResultSet resultSet)
Create a new ResultSetWrappingSqlRowSet for the given ResultSet. |
|
| 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 i,
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. |
ResultSet |
getResultSet()
Return the underlying ResultSet (usually a javax.sql.rowset.CachedRowSet). |
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. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
public ResultSetWrappingSqlRowSet(ResultSet resultSet)
throws InvalidResultSetAccessException
resultSet - a disconnected ResultSet to wrap
(usually a javax.sql.rowset.CachedRowSet)
InvalidResultSetAccessException - if extracting
the ResultSetMetaData failedCachedRowSet,
ResultSet.getMetaData(),
ResultSetWrappingSqlRowSetMetaData| Method Detail |
|---|
public final ResultSet getResultSet()
javax.sql.rowset.CachedRowSet).
CachedRowSetpublic final SqlRowSetMetaData getMetaData()
SqlRowSet
getMetaData in interface SqlRowSetResultSetMetaData.getCatalogName(int)
public int findColumn(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
findColumn in interface SqlRowSetcolumnName - the name of the column
InvalidResultSetAccessExceptionResultSet.findColumn(String)
public BigDecimal getBigDecimal(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getBigDecimal in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getBigDecimal(int)
public BigDecimal getBigDecimal(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getBigDecimal in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getBigDecimal(String)
public boolean getBoolean(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getBoolean in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getBoolean(int)
public boolean getBoolean(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getBoolean in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getBoolean(String)
public byte getByte(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getByte in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getByte(int)
public byte getByte(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getByte in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getByte(String)
public Date getDate(int columnIndex,
Calendar cal)
throws InvalidResultSetAccessException
SqlRowSet
getDate in interface SqlRowSetcolumnIndex - the column indexcal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getDate(int, java.util.Calendar)
public Date getDate(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getDate in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getDate(int)
public Date getDate(String columnName,
Calendar cal)
throws InvalidResultSetAccessException
SqlRowSet
getDate in interface SqlRowSetcolumnName - the column namecal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getDate(String, java.util.Calendar)
public Date getDate(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getDate in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getDate(String)
public double getDouble(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getDouble in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getDouble(int)
public double getDouble(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getDouble in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getDouble(String)
public float getFloat(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getFloat in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getFloat(int)
public float getFloat(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getFloat in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getFloat(String)
public int getInt(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getInt in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getInt(int)
public int getInt(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getInt in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getInt(String)
public long getLong(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getLong in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getLong(int)
public long getLong(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getLong in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getLong(String)
public Object getObject(int i,
Map map)
throws InvalidResultSetAccessException
SqlRowSet
getObject in interface SqlRowSeti - the column indexmap - a Map object containing the mapping from SQL types to Java types
InvalidResultSetAccessExceptionResultSet.getObject(int, java.util.Map)
public Object getObject(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getObject in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getObject(int)
public Object getObject(String columnName,
Map map)
throws InvalidResultSetAccessException
SqlRowSet
getObject in interface SqlRowSetcolumnName - the column namemap - a Map object containing the mapping from SQL types to Java types
InvalidResultSetAccessExceptionResultSet.getObject(String, java.util.Map)
public Object getObject(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getObject in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getObject(String)
public short getShort(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getShort in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getShort(int)
public short getShort(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getShort in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getShort(String)
public String getString(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getString in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getString(int)
public String getString(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getString in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getString(String)
public Time getTime(int columnIndex,
Calendar cal)
throws InvalidResultSetAccessException
SqlRowSet
getTime in interface SqlRowSetcolumnIndex - the column indexcal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTime(int, java.util.Calendar)
public Time getTime(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getTime in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getTime(int)
public Time getTime(String columnName,
Calendar cal)
throws InvalidResultSetAccessException
SqlRowSet
getTime in interface SqlRowSetcolumnName - the column namecal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTime(String, java.util.Calendar)
public Time getTime(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getTime in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getTime(String)
public Timestamp getTimestamp(int columnIndex,
Calendar cal)
throws InvalidResultSetAccessException
SqlRowSet
getTimestamp in interface SqlRowSetcolumnIndex - the column indexcal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTimestamp(int, java.util.Calendar)
public Timestamp getTimestamp(int columnIndex)
throws InvalidResultSetAccessException
SqlRowSet
getTimestamp in interface SqlRowSetcolumnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getTimestamp(int)
public Timestamp getTimestamp(String columnName,
Calendar cal)
throws InvalidResultSetAccessException
SqlRowSet
getTimestamp in interface SqlRowSetcolumnName - the column namecal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTimestamp(String, java.util.Calendar)
public Timestamp getTimestamp(String columnName)
throws InvalidResultSetAccessException
SqlRowSet
getTimestamp in interface SqlRowSetcolumnName - the column name
InvalidResultSetAccessExceptionResultSet.getTimestamp(String)
public boolean absolute(int row)
throws InvalidResultSetAccessException
SqlRowSet
absolute in interface SqlRowSetrow - the number of the row where the cursor should move
InvalidResultSetAccessExceptionResultSet.absolute(int)
public void afterLast()
throws InvalidResultSetAccessException
SqlRowSet
afterLast in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.afterLast()
public void beforeFirst()
throws InvalidResultSetAccessException
SqlRowSet
beforeFirst in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.beforeFirst()
public boolean first()
throws InvalidResultSetAccessException
SqlRowSet
first in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.first()
public int getRow()
throws InvalidResultSetAccessException
SqlRowSet
getRow in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.getRow()
public boolean isAfterLast()
throws InvalidResultSetAccessException
SqlRowSet
isAfterLast in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.isAfterLast()
public boolean isBeforeFirst()
throws InvalidResultSetAccessException
SqlRowSet
isBeforeFirst in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.isBeforeFirst()
public boolean isFirst()
throws InvalidResultSetAccessException
SqlRowSet
isFirst in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.isFirst()
public boolean isLast()
throws InvalidResultSetAccessException
SqlRowSet
isLast in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.isLast()
public boolean last()
throws InvalidResultSetAccessException
SqlRowSet
last in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.last()
public boolean next()
throws InvalidResultSetAccessException
SqlRowSet
next in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.next()
public boolean previous()
throws InvalidResultSetAccessException
SqlRowSet
previous in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.previous()
public boolean relative(int rows)
throws InvalidResultSetAccessException
SqlRowSet
relative in interface SqlRowSetInvalidResultSetAccessExceptionResultSet.relative(int)
public boolean wasNull()
throws InvalidResultSetAccessException
SqlRowSetNULL.
Note that you must first call one of the getter methods and then call
the wasNull method.
wasNull in interface SqlRowSetNULL,
false otherwise
InvalidResultSetAccessExceptionResultSet.wasNull()
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||