| 
 | ||||||||||
| 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
InvalidResultSetAccessExceptionResultSet.findColumn(String)
BigDecimal getBigDecimal(int columnIndex)
                         throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getBigDecimal(int)
BigDecimal getBigDecimal(String columnName)
                         throws InvalidResultSetAccessException
columnName - the column name
InvalidResultSetAccessExceptionResultSet.getBigDecimal(java.lang.String)
boolean getBoolean(int columnIndex)
                   throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getBoolean(int)
boolean getBoolean(String columnName)
                   throws InvalidResultSetAccessException
columnName - the column name
InvalidResultSetAccessExceptionResultSet.getBoolean(java.lang.String)
byte getByte(int columnIndex)
             throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getByte(int)
byte getByte(String columnName)
             throws InvalidResultSetAccessException
columnName - the column name
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 columnName,
             Calendar cal)
             throws InvalidResultSetAccessException
columnName - the column namecal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getDate(java.lang.String, java.util.Calendar)
Date getDate(String columnName)
             throws InvalidResultSetAccessException
columnName - the column name
InvalidResultSetAccessExceptionResultSet.getDate(java.lang.String)
double getDouble(int columnIndex)
                 throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getDouble(int)
double getDouble(String columnName)
                 throws InvalidResultSetAccessException
columnName - the column name
InvalidResultSetAccessExceptionResultSet.getDouble(java.lang.String)
float getFloat(int columnIndex)
               throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getFloat(int)
float getFloat(String columnName)
               throws InvalidResultSetAccessException
columnName - the column name
InvalidResultSetAccessExceptionResultSet.getFloat(java.lang.String)
int getInt(int columnIndex)
           throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getInt(int)
int getInt(String columnName)
           throws InvalidResultSetAccessException
columnName - the column name
InvalidResultSetAccessExceptionResultSet.getInt(java.lang.String)
long getLong(int columnIndex)
             throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getLong(int)
long getLong(String columnName)
             throws InvalidResultSetAccessException
columnName - the column name
InvalidResultSetAccessExceptionResultSet.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
InvalidResultSetAccessExceptionResultSet.getObject(int, java.util.Map)
Object getObject(int columnIndex)
                 throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.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
InvalidResultSetAccessExceptionResultSet.getObject(java.lang.String, java.util.Map)
Object getObject(String columnName)
                 throws InvalidResultSetAccessException
columnName - the column name
InvalidResultSetAccessExceptionResultSet.getObject(java.lang.String)
short getShort(int columnIndex)
               throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getShort(int)
short getShort(String columnName)
               throws InvalidResultSetAccessException
columnName - the column name
InvalidResultSetAccessExceptionResultSet.getShort(java.lang.String)
String getString(int columnIndex)
                 throws InvalidResultSetAccessException
columnIndex - the column index
InvalidResultSetAccessExceptionResultSet.getString(int)
String getString(String columnName)
                 throws InvalidResultSetAccessException
columnName - the column name
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 columnName,
             Calendar cal)
             throws InvalidResultSetAccessException
columnName - the column namecal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTime(java.lang.String, java.util.Calendar)
Time getTime(String columnName)
             throws InvalidResultSetAccessException
columnName - the column name
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 columnName,
                       Calendar cal)
                       throws InvalidResultSetAccessException
columnName - the column namecal - the Calendar to use in constructing the Date
InvalidResultSetAccessExceptionResultSet.getTimestamp(java.lang.String, java.util.Calendar)
Timestamp getTimestamp(String columnName)
                       throws InvalidResultSetAccessException
columnName - the column name
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 | |||||||||