public interface AQResultSet extends AQDataReader
Modifier and Type | Method and Description |
---|---|
void |
close()
Releases this ResultSet object's database and JDBC resources immediately instead
of waiting for this to happen when it is automatically closed.
|
AQSQLArray |
getArray(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object.
|
AQSQLArray |
getArray(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object.
|
BigDecimal |
getBigDecimal(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a BigDecimal with full precision.
|
BigDecimal |
getBigDecimal(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a BigDecimal with full precision.
|
AQSQLBlob |
getBlob(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object.
|
AQSQLBlob |
getBlob(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object.
|
boolean |
getBoolean(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a boolean.
|
boolean |
getBoolean(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a boolean.
|
byte |
getByte(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a byte.
|
byte |
getByte(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a byte.
|
byte[] |
getBytes(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in
the Java programming language.
|
byte[] |
getBytes(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in
the Java programming language.
|
AQSQLClob |
getClob(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object.
|
AQSQLClob |
getClob(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object.
|
AQColumnStructure |
getColumnStructure()
To get the associated column structure of the result set.
|
int |
getCurrentRow()
Retrieves the current row number.
|
String |
getDate(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a Date object.
|
String |
getDate(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a Date object.
|
double |
getDouble(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a double.
|
double |
getDouble(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a double.
|
float |
getFloat(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a float.
|
float |
getFloat(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a float.
|
int |
getInt(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as an int.
|
int |
getInt(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as an int.
|
long |
getLong(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as an long.
|
long |
getLong(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as an long.
|
AQSQLNClob |
getNClob(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object.
|
AQSQLNClob |
getNClob(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object.
|
String |
getNString(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a String.
|
String |
getNString(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a String.
|
Object |
getObject(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as an Object.
|
Object |
getObject(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as an Object.
|
AQDataRow |
getRow()
Extracts current data row.
|
AQSQLRowId |
getRowId(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a RowId Object.
|
AQSQLRowId |
getRowId(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a RowId Object.
|
short |
getShort(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a short.
|
short |
getShort(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a short.
|
String |
getString(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a String.
|
String |
getString(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a String.
|
String |
getTime(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a Time object.
|
String |
getTime(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a Time object.
|
String |
getTimestamp(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a Timestamp object.
|
String |
getTimestamp(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a Timestamp object.
|
String |
getURL(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a URL string.
|
String |
getURL(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a URL string.
|
boolean |
isNull(int columnIndex)
To check for null values in the column of the current row.
|
boolean |
isNull(String columnName)
To check for null values in the column of the current row.
|
boolean |
next()
Moves the cursor froward one row from its current position.
|
read, readNextRow
AQColumnStructure getColumnStructure()
getColumnStructure
in interface AQDataReader
void close() throws IOException
close
in interface AQDataReader
close
in interface AutoCloseable
close
in interface Closeable
IOException
- if an I/O error occursboolean isNull(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.boolean isNull(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column .Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.String getString(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.String getString(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.AQSQLArray getArray(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.AQSQLArray getArray(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.BigDecimal getBigDecimal(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.BigDecimal getBigDecimal(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.AQSQLBlob getBlob(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
Also, if the JDBC driver does not support this operation.AQSQLBlob getBlob(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
Also, if the JDBC driver does not support this operation.boolean getBoolean(int columnIndex) throws Exception
If the designated column has a datatype of CHAR or VARCHAR and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 0, a value of false is returned. If the designated column has a datatype of CHAR or VARCHAR and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 1, a value of true is returned.
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.boolean getBoolean(String columnName) throws Exception
If the designated column has a datatype of CHAR or VARCHAR and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 0, a value of false is returned. If the designated column has a datatype of CHAR or VARCHAR and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 1, a value of true is returned.
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.byte getByte(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on
a closed result set.byte getByte(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on
a closed result set.byte[] getBytes(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a
closed result setbyte[] getBytes(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on
a closed result set.AQSQLClob getClob(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result setAQSQLClob getClob(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result setString getDate(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.String getDate(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.double getDouble(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.double getDouble(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.float getFloat(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.float getFloat(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.int getInt(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result setint getInt(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result setlong getLong(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.long getLong(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.AQSQLNClob getNClob(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnName is not valid; if the driver does not support national character sets;
if the driver can detect that a data conversion error could occur; this method is called
on a closed result set or if a database access error occursAQSQLNClob getNClob(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if the driver does not support national character sets;
if the driver can detect that a data conversion error could occur; this method is called
on a closed result set or if a database access error occursString getNString(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.String getNString(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.Object getObject(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set.Object getObject(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set.AQSQLRowId getRowId(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.AQSQLRowId getRowId(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result setshort getShort(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.short getShort(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.String getTime(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.String getTime(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.String getTimestamp(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.String getTimestamp(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.String getURL(int columnIndex) throws Exception
columnIndex
- The column index; the first column is 0, the second is 1, ...Exception
- If the columnIndex is not valid; if a database access error occurs; this method is called on a closed result set or if a URL is
malformed.String getURL(String columnName) throws Exception
columnName
- The name of the column specified with the SQL AS clause. If the SQL AS clause was
not specified, then the label is the name of the column.Exception
- If the columnIndex is not valid; if a database access error occurs; this method is called on a closed result set or if a URL is
malformed.boolean next() throws Exception
Exception
- If a database access error occurs or this method is called on a closed result set.AQDataRow getRow() throws Exception
Exception
- On error.int getCurrentRow() throws Exception
Exception
- If a database access error occurs or this method is called on a closed result set.
Copyright © 2017 AquaFold, Inc. All Rights Reserved. Use is subject to license terms.