|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
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. |
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 |
public IResultSetMetaData getMetaData() throws OdaException
OdaException
- if data source error occurspublic void close() throws OdaException
OdaException
- if data source error occurspublic 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 occurspublic boolean next() throws OdaException
OdaException
- if data source error occurspublic int getRow() throws OdaException
OdaException
- if data source error occurspublic java.lang.String getString(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occurspublic java.lang.String getString(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occurs.public int getInt(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occurspublic int getInt(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occurspublic double getDouble(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occurspublic double getDouble(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occurspublic java.math.BigDecimal getBigDecimal(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occurspublic java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occurspublic java.sql.Date getDate(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occurspublic java.sql.Date getDate(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occurspublic java.sql.Time getTime(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occurspublic java.sql.Time getTime(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occurspublic java.sql.Timestamp getTimestamp(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occurspublic java.sql.Timestamp getTimestamp(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occurspublic 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 occurspublic 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 occurspublic 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 occurspublic 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 occurspublic boolean getBoolean(int index) throws OdaException
index
- column number (1-based)
OdaException
- if data source error occurspublic boolean getBoolean(java.lang.String columnName) throws OdaException
columnName
- column name
OdaException
- if data source error occurspublic boolean wasNull() throws OdaException
OdaException
- if data source error occurspublic int findColumn(java.lang.String columnName) throws OdaException
columnName
- name 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 |