SparkseeNet  5.2.0
Public Member Functions | List of all members
com.sparsity.sparksee.gdb.ResultSet Class Reference

ResultSet class. More...

Public Member Functions

void Rewind ()
 Positions the cursor before the first row.
 
void GetColumn (int index, com.sparsity.sparksee.gdb.Value value)
 Gets the value for the given column. More...
 
com.sparsity.sparksee.gdb.Value GetColumn (int index)
 Gets the value for the given column. More...
 
int GetColumnIndex (System.String name)
 Gets the column index for the given column name. More...
 
bool Next ()
 Fetches the next row. More...
 
System.String GetJSON (int rows)
 Returns rows in JSON format. More...
 
System.String GetColumnName (int index)
 Gets the name for the given column. More...
 
com.sparsity.sparksee.gdb.DataType GetColumnDataType (int index)
 Gets the datatype for the given column. More...
 
int GetNumColumns ()
 Gets the number of columns. More...
 

Detailed Description

ResultSet class.

Author
Sparsity Technologies http://www.sparsity-technologies.com

Member Function Documentation

void com.sparsity.sparksee.gdb.ResultSet.GetColumn ( int  index,
com.sparsity.sparksee.gdb.Value  value 
)

Gets the value for the given column.

QueryExceptionIf a database access error occurs.

Parameters
index[in] Column index.
value[in|out] Value.
com.sparsity.sparksee.gdb.Value com.sparsity.sparksee.gdb.ResultSet.GetColumn ( int  index)

Gets the value for the given column.

QueryExceptionIf a database access error occurs.

Parameters
index[in] Column index.
Returns
The Value of the given column.
com.sparsity.sparksee.gdb.DataType com.sparsity.sparksee.gdb.ResultSet.GetColumnDataType ( int  index)

Gets the datatype for the given column.

Parameters
index[in] Column index.
Returns
DataType for the given column.
int com.sparsity.sparksee.gdb.ResultSet.GetColumnIndex ( System.String  name)

Gets the column index for the given column name.

Parameters
name[in] Column name.
Returns
Column index.
System.String com.sparsity.sparksee.gdb.ResultSet.GetColumnName ( int  index)

Gets the name for the given column.

Parameters
index[in] Column index.
Returns
Column name.
System.String com.sparsity.sparksee.gdb.ResultSet.GetJSON ( int  rows)

Returns rows in JSON format.

Rows are returned from the current position.

Parameters
rows[in] Maximum number of rows
Returns
JSON representation of the next <rows> rows in the resultset
int com.sparsity.sparksee.gdb.ResultSet.GetNumColumns ( )

Gets the number of columns.

Columns are in the range [0...COLUMNS).

Returns
The number of columns.
bool com.sparsity.sparksee.gdb.ResultSet.Next ( )

Fetches the next row.

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.

QueryExceptionIf a database access error occurs.

Returns
TRUE if the next row has been successfully fetched, FALSE otherwise.