com.sparsity.sparksee.gdb.ResultSet Class Reference

ResultSet class. More...

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

Detailed Description

ResultSet class.

Author

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

Member Function Documentation

GetColumn() [1/2]

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.

GetColumn() [2/2]

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.

GetColumnDataType()

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.

GetColumnIndex()

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.

GetColumnName()

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.

GetJSON()

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

GetNumColumns()

int com.sparsity.sparksee.gdb.ResultSet.GetNumColumns

(

)

Gets the number of columns.

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

Returns

The number of columns.

Next()

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.