com.testarchitect

Interface QueryResult

public interface QueryResult

This interface contains result of the query execution. A table of data representing the result of an executed SQL query. The result set contains rows, each row having columns with the values in the table.

To access the results, navigate the result set row by row with the 'next' method. For the current row get the column (cell) values with 'getValueByColIndex' or 'getValueByColName', using a column index or a column name respectively.

Method Summary

Modifier and Type	Method and Description
int	getColumnCount() Returns the number of columns in the current result set.
String	getColumnNameByIndex(int columnIndex) Returns the name of a specified column with a given column index value.
int	getRowCount() Returns the number of rows in the current result set .
String	getValueByColIndex(int columnIndex) Returns the value of the specified column in the current row indicated by a column index value.
String	getValueByColName(String columnName) Returns the value of the specified column in the current row indicated by a column name value.
boolean	next() Move the cursor forward one row from its current position.

Method Detail

getColumnNameByIndex

String getColumnNameByIndex(int columnIndex)

Returns the name of a specified column with a given column index value.

Parameters:

columnIndex - the index value of the column. The index is zero-based.

Returns:

A string with the column name at the specified column

getValueByColIndex

String getValueByColIndex(int columnIndex)

Returns the value of the specified column in the current row indicated by a column index value.

Parameters:

columnIndex - the index value of the column. The index is zero-based.

Returns:

A string with the value of the specified column.

getValueByColName

String getValueByColName(String columnName)

Returns the value of the specified column in the current row indicated by a column name value.

Parameters:

columnName - the name of the column

Returns:

A string with the value of the specified column.

getColumnCount

int getColumnCount()

Returns the number of columns in the current result set.

Returns:

An integer value contains the number of columns in the current result set.

next

boolean next()

Move the cursor forward one row from its current position. A result set 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.

Returns:

true if result set has next row; otherwise, false .

getRowCount

int getRowCount()

Returns the number of rows in the current result set .

Returns:

An integer value contains the number of rows in the current result set.