Package quadbase.util

Class QueryResultSet

java.lang.Object

quadbase.util.QueryResultSet

All Implemented Interfaces:

IResultSet, IRow, IRSMetaData

public class QueryResultSet
extends Object
implements IResultSet, IRSMetaData

A wrapper around java.sql.ResultSet/ResultSetMetaData to implement IResultSet and IRSMetaData interfaces. This class was implemented later to create a uniform IResultSet interface for data obtained from all sources.

Constructor Summary

Constructors

Constructor	Description
QueryResultSet(ResultSet rs)	Creates a QueryResultSet object using the specified ResultSet
QueryResultSet(Statement stmt)	Creates a QueryResultSet object using the specified Statement
QueryResultSet(Statement stmt, String productName)	Creates a QueryResultSet object using the specified Statement and product name
QueryResultSet(Statement stmt, ResultSet resultSet, String productName)

Method Summary

Modifier and Type	Method	Description
void	close()	Closes the cursor
int	getColumnCount()	Gets the number of columns in the result set.
int	getColumnDisplaySize(int col)
String	getColumnName(int col)	Gets the name of a column in the result set.
int	getColumnType(int col)	Gets the data type of a column in the result set.
IRSMetaData	getMetaData()	Gets the meta data object
Object	getObject(int colNo)	Returns the data value stored in the specified column of this row.
String	getTableName(int col)
boolean	next()	Advances cursor to next row

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

QueryResultSet

public QueryResultSet(ResultSet rs)
               throws SQLException

Creates a QueryResultSet object using the specified ResultSet

Throws:

SQLException

QueryResultSet

public QueryResultSet(Statement stmt)
               throws SQLException

Creates a QueryResultSet object using the specified Statement

Parameters:

stmt - must be an executed statement

Throws:

SQLException

QueryResultSet

public QueryResultSet(Statement stmt,
 String productName)
               throws SQLException

Creates a QueryResultSet object using the specified Statement and product name

Parameters:

stmt - must be an executed statement

productName - product name

Throws:

SQLException

QueryResultSet

public QueryResultSet(Statement stmt,
 ResultSet resultSet,
 String productName)

Method Details

next

public boolean next()
             throws SQLException

Description copied from interface: IResultSet

Advances cursor to next row

Specified by:

next in interface IResultSet

Throws:

SQLException

close

public void close()
           throws SQLException

Description copied from interface: IResultSet

Closes the cursor

Specified by:

close in interface IResultSet

Throws:

SQLException

getObject

public Object getObject(int colNo)
                 throws SQLException

Description copied from interface: IRow

Returns the data value stored in the specified column of this row.

Specified by:

getObject in interface IRow

Parameters:

colNo - The column number for the field, beginning with 1.

Returns:

The data value stored in that column field.

Throws:

SQLException

getMetaData

public IRSMetaData getMetaData()
                        throws SQLException

Description copied from interface: IResultSet

Gets the meta data object

Specified by:

getMetaData in interface IResultSet

Throws:

SQLException

getColumnCount

public int getColumnCount()
                   throws SQLException

Description copied from interface: IRSMetaData

Gets the number of columns in the result set.

Specified by:

getColumnCount in interface IRSMetaData

Throws:

SQLException

getColumnName

public String getColumnName(int col)
                     throws SQLException

Description copied from interface: IRSMetaData

Gets the name of a column in the result set.

Specified by:

getColumnName in interface IRSMetaData

Returns:

col the column name

Throws:

SQLException

getTableName

public String getTableName(int col)
                    throws SQLException

Specified by:

getTableName in interface IRSMetaData

Throws:

SQLException

getColumnType

public int getColumnType(int col)
                  throws SQLException

Description copied from interface: IRSMetaData

Gets the data type of a column in the result set.

Specified by:

getColumnType in interface IRSMetaData

Parameters:

col - the column index (beginning at 1)

Returns:

the column SQL data type (as represented in java.sql.Types).

Throws:

SQLException

getColumnDisplaySize

public int getColumnDisplaySize(int col)
                         throws SQLException

Throws:

SQLException