|
||||||||||
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 occursvoid close() throws OdaException
OdaException
- if data source error occursvoid 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 occursboolean next() throws OdaException
OdaException
- if data source error occursint getRow() throws OdaException
OdaException
- if data source error occursjava.lang.String getString(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occursjava.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 occursint getInt(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occursdouble getDouble(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occursdouble getDouble(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occursjava.math.BigDecimal getBigDecimal(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occursjava.math.BigDecimal getBigDecimal(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occursjava.sql.Date getDate(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occursjava.sql.Date getDate(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occursjava.sql.Time getTime(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occursjava.sql.Time getTime(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occursjava.sql.Timestamp getTimestamp(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occursjava.sql.Timestamp getTimestamp(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occursIBlob 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 occursIBlob 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 occursIClob 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 occursIClob 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 occursboolean getBoolean(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occursboolean getBoolean(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occursjava.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 occursjava.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 occursboolean wasNull() throws OdaException
OdaException
- if data source error occursint 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 |