com.aquafold.openapi.rdbms
Interface AQResultSet

All Superinterfaces:

AQDataReader, 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

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.

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 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 Closeable

Throws:

IOException - if an I/O error occurs

isNull

boolean isNull(int columnIndex)
               throws 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:

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(String columnName)
               throws 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:

Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.

getString

String getString(int columnIndex)
                 throws 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:

Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.

getString

String getString(String columnName)
                 throws 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:

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 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:

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(String columnName)
                    throws 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:

Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.

getBigDecimal

BigDecimal getBigDecimal(int columnIndex)
                         throws 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:

Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.

getBigDecimal

BigDecimal getBigDecimal(String columnName)
                         throws 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:

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 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:

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(String columnName)
                  throws 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:

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 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:

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(String columnName)
                   throws 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:

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 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:

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(String columnName)
             throws 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:

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 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:

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(String columnName)
                throws 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:

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 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:

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(String columnName)
                  throws 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:

Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set

getDate

String getDate(int columnIndex)
               throws 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:

Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.

getDate

String getDate(String columnName)
               throws 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:

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 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:

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(String columnName)
                 throws 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:

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 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:

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(String columnName)
               throws 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:

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 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:

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(String columnName)
           throws 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:

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 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:

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(String columnName)
             throws 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:

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 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:

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(String columnName)
                    throws 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:

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

String getNString(int columnIndex)
                  throws 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:

Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.

getNString

String getNString(String columnName)
                  throws 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:

Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.

getObject

Object getObject(int columnIndex)
                 throws 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:

Exception - If the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set.

getObject

Object getObject(String columnName)
                 throws 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:

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 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:

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(String columnName)
                    throws 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:

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 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:

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(String columnName)
               throws 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:

Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.

getTime

String getTime(int columnIndex)
               throws 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:

Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.

getTime

String getTime(String columnName)
               throws 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:

Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.

getTimestamp

String getTimestamp(int columnIndex)
                    throws 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:

Exception - If the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.

getTimestamp

String getTimestamp(String columnName)
                    throws 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:

Exception - If the columnName is not valid; if a database access error occurs or this method is called on a closed result set.

getURL

String getURL(int columnIndex)
              throws 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:

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

String getURL(String columnName)
              throws 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:

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 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:

Exception - If a database access error occurs or this method is called on a closed result set.

getRow

AQDataRow getRow()
                 throws Exception

Extracts current data row.

Returns:

An AQDataRow object; null if result set has no rows.

Throws:

Exception - On error.

getCurrentRow

int getCurrentRow()
                  throws 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:

Exception - If a database access error occurs or this method is called on a closed result set.