|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
public interface IResultSet
The interface used to access a set of data rows retrieved by an IQuery object. An IResultSet object maintains a cursor pointing to its current row of data. Initially, the cursor is positioned before the first row. The next() method moves the cursor to the next row until there are no more rows, or if the MaxRows limit has been reached.
A result set column may be referenced by name or position.
The case-sensitivity of a name is implementation-dependent.
All indices in this interface are 1-based.
| Method Summary | |
|---|---|
void |
close()
Closes the cursor associated with this IResultSet. |
int |
findColumn(java.lang.String columnName)
Returns the column index of the specified column name. |
java.math.BigDecimal |
getBigDecimal(int index)
Gets the value of the designated column in the current row as a decimal. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName)
Gets the value of the designated column in the current row as a decimal. |
IBlob |
getBlob(int index)
Gets the value of the designated column in the current row as an IBlob object. |
IBlob |
getBlob(java.lang.String columnName)
Gets the value of the designated column in the current row as an IBlob object. |
boolean |
getBoolean(int index)
Gets the value of the designated column in the current row as a boolean. |
boolean |
getBoolean(java.lang.String columnName)
Gets the value of the designated column in the current row as a boolean. |
IClob |
getClob(int index)
Gets the value of the designated column in the current row as an IClob object. |
IClob |
getClob(java.lang.String columnName)
Gets the value of the designated column in the current row as an IClob object. |
java.sql.Date |
getDate(int index)
Gets the value of the designated column in the current row as a java.sql.Date. |
java.sql.Date |
getDate(java.lang.String columnName)
Gets the value of the designated column in the current row as a java.sql.Date. |
double |
getDouble(int index)
Gets the value of the designated column in the current row as a double. |
double |
getDouble(java.lang.String columnName)
Gets the value of the designated column in the current row as a double. |
int |
getInt(int index)
Gets the value of the designated column in the current row as an int. |
int |
getInt(java.lang.String columnName)
Gets the value of the designated column in the current row as an int. |
IResultSetMetaData |
getMetaData()
Returns the metadata associated with this IResultSet. |
java.lang.Object |
getObject(int index)
Gets the value of the designated column in the current row as an Object. |
java.lang.Object |
getObject(java.lang.String columnName)
Gets the value of the designated column in the current row as an Object. |
int |
getRow()
Returns the current row's 1-based index position. |
java.lang.String |
getString(int index)
Gets the value of the designated column in the current row as a String. |
java.lang.String |
getString(java.lang.String columnName)
Gets the value of the designated column in the current row as a String. |
java.sql.Time |
getTime(int index)
Gets the value of the designated column in the current row as a java.sql.Time. |
java.sql.Time |
getTime(java.lang.String columnName)
Gets the value of the designated column in the current row as a java.sql.Time. |
java.sql.Timestamp |
getTimestamp(int index)
Gets the value of the designated column in the current row as a java.sql.Timestamp. |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName)
Gets the value of the designated column in the current row as a java.sql.Timestamp. |
boolean |
next()
Moves the cursor down one row from its current position. |
void |
setMaxRows(int max)
Specifies the maximum number of rows that can be fetched from this result set. |
boolean |
wasNull()
Returns whether the value read from the previous get<type> method was invalid or null. |
| Method Detail |
|---|
IResultSetMetaData getMetaData()
throws OdaException
OdaException - if data source error occurs
void close()
throws OdaException
OdaException - if data source error occurs
void setMaxRows(int max)
throws OdaException
max - maximum number of rows that can be fetched from this IResultSet;
zero means there is no limit.
This value should not be greater than the maximum number of rows
specified in the related IQuery.
OdaException - if data source error occurs
boolean next()
throws OdaException
OdaException - if data source error occurs
int getRow()
throws OdaException
OdaException - if data source error occurs
java.lang.String getString(int index)
throws OdaException
index - column number (1-based)
OdaException - if data source error occurs
java.lang.String getString(java.lang.String columnName)
throws OdaException
columnName - column name
OdaException - if data source error occurs.
int getInt(int index)
throws OdaException
index - column number (1-based)
OdaException - if data source error occurs
int getInt(java.lang.String columnName)
throws OdaException
columnName - column name
OdaException - if data source error occurs
double getDouble(int index)
throws OdaException
index - column number (1-based)
OdaException - if data source error occurs
double getDouble(java.lang.String columnName)
throws OdaException
columnName - column name
OdaException - if data source error occurs
java.math.BigDecimal getBigDecimal(int index)
throws OdaException
index - column number (1-based)
OdaException - if data source error occurs
java.math.BigDecimal getBigDecimal(java.lang.String columnName)
throws OdaException
columnName - column name
OdaException - if data source error occurs
java.sql.Date getDate(int index)
throws OdaException
index - column number (1-based)
OdaException - if data source error occurs
java.sql.Date getDate(java.lang.String columnName)
throws OdaException
columnName - column name
OdaException - if data source error occurs
java.sql.Time getTime(int index)
throws OdaException
index - column number (1-based)
OdaException - if data source error occurs
java.sql.Time getTime(java.lang.String columnName)
throws OdaException
columnName - column name
OdaException - if data source error occurs
java.sql.Timestamp getTimestamp(int index)
throws OdaException
index - column number (1-based)
OdaException - if data source error occurs
java.sql.Timestamp getTimestamp(java.lang.String columnName)
throws OdaException
columnName - column name
OdaException - if data source error occurs
IBlob getBlob(int index)
throws OdaException
Note: The driver must guarantee that the returned object and its BLOB data would remain valid and accessible until this result set is closed.
index - column number (1-based)
null if the specific column has null value
OdaException - if data source error occurs
IBlob getBlob(java.lang.String columnName)
throws OdaException
Note: The driver must guarantee that the returned object and its BLOB data would remain valid and accessible until this result set is closed.
columnName - column name
null if the specific column has null value
OdaException - if data source error occurs
IClob getClob(int index)
throws OdaException
Note: The driver must guarantee that the returned object and its CLOB data would remain valid and accessible until this result set is closed.
index - column number (1-based)
null if the specific column has null value
OdaException - if data source error occurs
IClob getClob(java.lang.String columnName)
throws OdaException
Note: The driver must guarantee that the returned object and its CLOB data would remain valid and accessible until this result set is closed.
columnName - column name
null if the specific column has null value
OdaException - if data source error occurs
boolean getBoolean(int index)
throws OdaException
index - column number (1-based)
OdaException - if data source error occurs
boolean getBoolean(java.lang.String columnName)
throws OdaException
columnName - column name
OdaException - if data source error occurs
java.lang.Object getObject(int index)
throws OdaException
Object.
If the column value is intended to be sortable by its consumer, the type of Object
returned must implement the Comparable interface.
index - column number (1-based)
Object value in the specific column of the current row
OdaException - if data source error occurs
java.lang.Object getObject(java.lang.String columnName)
throws OdaException
Object.
If the column value is intended to be sortable by its consumer, the type of Object
returned must implement the Comparable interface.
columnName - column name
Object value in the specific column of the current row; may be null
OdaException - if data source error occurs
boolean wasNull()
throws OdaException
OdaException - if data source error occurs
int findColumn(java.lang.String columnName)
throws OdaException
columnName - name or alias of the column
OdaException - if data source error occurs
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||