AQResultSet (OpenAPI)

All Superinterfaces:

AQDataReader, java.lang.AutoCloseable, java.io.Closeable
```
public interface AQResultSet
extends AQDataReader
```
This interface represents a table of data representing a database result set, which is usually generated by executing a statement that queries the database.

Method Summary

All Methods Instance Methods Abstract Methods
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(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this ResultSet object as an Array object.
`java.math.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.
`java.math.BigDecimal`	`getBigDecimal(java.lang.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(java.lang.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(java.lang.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(java.lang.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(java.lang.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(java.lang.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.
`java.lang.String`	`getDate(int columnIndex)` Retrieves the value of the designated column in the current row of this ResultSet object as a Date object.
`java.lang.String`	`getDate(java.lang.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(java.lang.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(java.lang.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(java.lang.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(java.lang.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(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object.
`java.lang.String`	`getNString(int columnIndex)` Retrieves the value of the designated column in the current row of this ResultSet object as a String.
`java.lang.String`	`getNString(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this ResultSet object as a String.
`java.lang.Object`	`getObject(int columnIndex)` Retrieves the value of the designated column in the current row of this ResultSet object as an Object.
`java.lang.Object`	`getObject(java.lang.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(java.lang.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(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this ResultSet object as a short.
`java.lang.String`	`getString(int columnIndex)` Retrieves the value of the designated column in the current row of this ResultSet object as a String.
`java.lang.String`	`getString(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this ResultSet object as a String.
`java.lang.String`	`getTime(int columnIndex)` Retrieves the value of the designated column in the current row of this ResultSet object as a Time object.
`java.lang.String`	`getTime(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this ResultSet object as a Time object.
`java.lang.String`	`getTimestamp(int columnIndex)` Retrieves the value of the designated column in the current row of this ResultSet object as a Timestamp object.
`java.lang.String`	`getTimestamp(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this ResultSet object as a Timestamp object.
`java.lang.String`	`getURL(int columnIndex)` Retrieves the value of the designated column in the current row of this ResultSet object as a URL string.
`java.lang.String`	`getURL(java.lang.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(java.lang.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.

Methods inherited from interface com.aquafold.openapi.io.AQDataReader
read, readNextRow

- Method Detail
  - getColumnStructure
```
AQColumnStructure getColumnStructure()
```
    To get the associated column structure of the result set.
    
    Specified by:
    
    getColumnStructure in interface AQDataReader
    
    Returns:
    
    An AQColumnStructure object.
  - close
```
void close()
    throws java.io.IOException
```
    Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
    
    Specified by:
    
    close in interface AQDataReader
    
    Specified by:
    
    close in interface java.lang.AutoCloseable
    
    Specified by:
    
    close in interface java.io.Closeable
    
    Throws:
    
    java.io.IOException - if an I/O error occurs
  - isNull
```
boolean isNull(int columnIndex)
        throws java.lang.Exception
```
    To check for null values in the column of the current row.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    boolean - true if the column specified contains null; false otherwise.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - isNull
```
boolean isNull(java.lang.String columnName)
        throws java.lang.Exception
```
    To check for null values in the column of the current row.
    
    Parameters:
    
    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 .
    
    Returns:
    
    boolean - true if the data filed contains null; false otherwise.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getString
```
java.lang.String getString(int columnIndex)
                    throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a String.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is null
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getString
```
java.lang.String getString(java.lang.String columnName)
                    throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a String.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is null
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getArray
```
AQSQLArray getArray(int columnIndex)
             throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as an Array object.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    An Array object representing the SQL ARRAY value in the specified column.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getArray
```
AQSQLArray getArray(java.lang.String columnName)
             throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as an Array object.
    
    Parameters:
    
    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.
    
    Returns:
    
    An Array object representing the SQL ARRAY value in the specified column.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getBigDecimal
```
java.math.BigDecimal getBigDecimal(int columnIndex)
                            throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a BigDecimal with full precision.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value (full precision); if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getBigDecimal
```
java.math.BigDecimal getBigDecimal(java.lang.String columnName)
                            throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a BigDecimal with full precision.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value (full precision); if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getBlob
```
AQSQLBlob getBlob(int columnIndex)
           throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    A Blob object representing the SQL BLOB value in the specified column.
    
    Throws:
    
    java.lang.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.
  - getBlob
```
AQSQLBlob getBlob(java.lang.String columnName)
           throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object.
    
    Parameters:
    
    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.
    
    Returns:
    
    A AQSQLBlob object representing the SQL BLOB value in the specified column.
    
    Throws:
    
    java.lang.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.
  - getBoolean
```
boolean getBoolean(int columnIndex)
            throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a boolean.
    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.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is false.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getBoolean
```
boolean getBoolean(java.lang.String columnName)
            throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a boolean.
    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.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is false.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getByte
```
byte getByte(int columnIndex)
      throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a byte.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getByte
```
byte getByte(java.lang.String columnName)
      throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a byte.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getBytes
```
byte[] getBytes(int columnIndex)
         throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. The bytes represent the raw values returned by the driver.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set
  - getBytes
```
byte[] getBytes(java.lang.String columnName)
         throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. The bytes represent the raw values returned by the driver.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getClob
```
AQSQLClob getClob(int columnIndex)
           throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    A Clob object representing the SQL CLOB value in the specified column.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set
  - getClob
```
AQSQLClob getClob(java.lang.String columnName)
           throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object.
    
    Parameters:
    
    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.
    
    Returns:
    
    A Clob object representing the SQL CLOB value in the specified column.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set
  - getDate
```
java.lang.String getDate(int columnIndex)
                  throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Date object.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value as a string; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getDate
```
java.lang.String getDate(java.lang.String columnName)
                  throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Date object.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value as a string; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getDouble
```
double getDouble(int columnIndex)
          throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a double.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getDouble
```
double getDouble(java.lang.String columnName)
          throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a double.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getFloat
```
float getFloat(int columnIndex)
        throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a float.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getFloat
```
float getFloat(java.lang.String columnName)
        throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a float.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getInt
```
int getInt(int columnIndex)
    throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as an int.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set
  - getInt
```
int getInt(java.lang.String columnName)
    throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as an int.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set
  - getLong
```
long getLong(int columnIndex)
      throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as an long.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getLong
```
long getLong(java.lang.String columnName)
      throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as an long.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getNClob
```
AQSQLNClob getNClob(int columnIndex)
             throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    A NClob object representing the SQL NCLOB value in the specified column.
    
    Throws:
    
    java.lang.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 occurs
  - getNClob
```
AQSQLNClob getNClob(java.lang.String columnName)
             throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object.
    
    Parameters:
    
    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.
    
    Returns:
    
    A NClob object representing the SQL NCLOB value in the specified column.
    
    Throws:
    
    java.lang.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 occurs
  - getNString
```
java.lang.String getNString(int columnIndex)
                     throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a String. It is intended for use when accessing NCHAR,NVARCHAR and LONGNVARCHAR columns.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getNString
```
java.lang.String getNString(java.lang.String columnName)
                     throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a String. It is intended for use when accessing NCHAR,NVARCHAR and LONGNVARCHAR columns.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getObject
```
java.lang.Object getObject(int columnIndex)
                    throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as an Object.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    A java.lang.Object holding the column value.
    
    Throws:
    
    java.lang.Exception - If the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set.
  - getObject
```
java.lang.Object getObject(java.lang.String columnName)
                    throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as an Object.
    
    Parameters:
    
    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.
    
    Returns:
    
    A java.lang.Object holding the column value.
    
    Throws:
    
    java.lang.Exception - If the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set.
  - getRowId
```
AQSQLRowId getRowId(int columnIndex)
             throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a RowId Object.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is a SQL NULL the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getRowId
```
AQSQLRowId getRowId(java.lang.String columnName)
             throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a RowId Object.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is a SQL NULL the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set
  - getShort
```
short getShort(int columnIndex)
        throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a short.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getShort
```
short getShort(java.lang.String columnName)
        throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a short.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value; if the value is SQL NULL, the value returned is 0.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getTime
```
java.lang.String getTime(int columnIndex)
                  throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Time object.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value as a string; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getTime
```
java.lang.String getTime(java.lang.String columnName)
                  throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Time object.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value as a string; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getTimestamp
```
java.lang.String getTimestamp(int columnIndex)
                       throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Timestamp object.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value as a string; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.
  - getTimestamp
```
java.lang.String getTimestamp(java.lang.String columnName)
                       throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a Timestamp object.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value as a string; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.
  - getURL
```
java.lang.String getURL(int columnIndex)
                 throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a URL string.
    
    Parameters:
    
    columnIndex - The column index; the first column is 0, the second is 1, ...
    
    Returns:
    
    The column value as an URL object; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.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.
  - getURL
```
java.lang.String getURL(java.lang.String columnName)
                 throws java.lang.Exception
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a URL string.
    
    Parameters:
    
    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.
    
    Returns:
    
    The column value as an URL object; if the value is SQL NULL, the value returned is null.
    
    Throws:
    
    java.lang.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.
  - next
```
boolean next()
      throws java.lang.Exception
```
    Moves the cursor froward one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.
    When a call to the next method returns false, the cursor is positioned after the last row. Any invocation of a ResultSet method which requires a current row will result in a SQLException being thrown. If the result set type is TYPE_FORWARD_ONLY, it is vendor specified whether their JDBC driver implementation will return false or throw an SQLException on a subsequent call to next.
    If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.
    
    Returns:
    
    true if the new current row is valid; false if there are no more rows.
    
    Throws:
    
    java.lang.Exception - If a database access error occurs or this method is called on a closed result set.
  - getRow
```
AQDataRow getRow()
          throws java.lang.Exception
```
    Extracts current data row.
    
    Returns:
    
    An AQDataRow object; null if result set has no rows.
    
    Throws:
    
    java.lang.Exception - On error.
  - getCurrentRow
```
int getCurrentRow()
           throws java.lang.Exception
```
    Retrieves the current row number. The first row is number 0, the second number 1, and so on.
    
    Returns:
    
    The current row, -1 if there is no current row.
    
    Throws:
    
    java.lang.Exception - If a database access error occurs or this method is called on a closed result set.

Interface AQResultSet

Method Summary

Methods inherited from interface com.aquafold.openapi.io.AQDataReader

Method Detail

getColumnStructure

close

isNull

isNull

getString

getString

getArray

getArray

getBigDecimal

getBigDecimal

getBlob

getBlob

getBoolean

getBoolean

getByte

getByte

getBytes

getBytes

getClob

getClob

getDate

getDate

getDouble

getDouble

getFloat

getFloat

getInt

getInt

getLong

getLong

getNClob

getNClob

getNString

getNString

getObject

getObject

getRowId

getRowId

getShort

getShort

getTime

getTime

getTimestamp

getTimestamp

getURL

getURL

next

getRow

getCurrentRow