nl.gx.webmanager.services.datasource
Interface QueryResult

Deprecated. Interface which is not needed when using the standard java JDBC api.

@Deprecated
public interface QueryResult

Interface used to retrieve results of a query executed using the QueryManagerService.

Method Summary

int	getColumnCount() Deprecated. Returns the amount of columns in the result.
int	getRowCount() Deprecated. Returns the amount of rows in the result.
java.util.ArrayList<java.util.HashMap<java.lang.String,java.lang.Object>>	getRows() Deprecated. Returns all rows in the result as arraylist of mappings of column names onto values
java.lang.Object	getValue() Deprecated. Returns the value of the result assuming there is exactly one row and one column in the result.
java.lang.Object	getValue(int row) Deprecated. Returns the value of the result on the specified row assuming there is exactly one column in the result.
java.lang.Object	getValue(int row, java.lang.String column) Deprecated. Returns the value of the result on the specified row and column name.
boolean	hasResults() Deprecated. Returns if the query returned results (at least one row with one column)

Method Detail

getRowCount

int getRowCount()

Deprecated.

Returns the amount of rows in the result.

Returns:

amount of rows in the result

getColumnCount

int getColumnCount()

Deprecated.

Returns the amount of columns in the result.

Returns:

amount of columns in the result

getValue

java.lang.Object getValue()
                          throws java.sql.SQLException

Deprecated.

Returns the value of the result assuming there is exactly one row and one column in the result.

Returns:

value of the result

Throws:

java.sql.SQLException - if there is not exactly one row and one column in the result.

getValue

java.lang.Object getValue(int row)
                          throws java.sql.SQLException

Deprecated.

Returns the value of the result on the specified row assuming there is exactly one column in the result. Throws an SQLException if there is not exactly one column in the result or the specified row exceeds the number of rows contained by the result.

Parameters:

row - Row to retrieve the result for

Returns:

value of the result at the specified row

Throws:

java.sql.SQLException - if there is not exactly one column in the result or the specified row exceeds the number of rows contained by the result.

getValue

java.lang.Object getValue(int row,
                          java.lang.String column)
                          throws java.sql.SQLException

Deprecated.

Returns the value of the result on the specified row and column name.

Parameters:

row - Row to retrieve the result for

column - Name of the column to retrieve the result for

Returns:

value of the result at the specified row and column

Throws:

java.sql.SQLException - in case there is no column in the result with the specified name or if the specified row exceeds the number of rows contained by the result.

getRows

java.util.ArrayList<java.util.HashMap<java.lang.String,java.lang.Object>> getRows()

Deprecated.

Returns all rows in the result as arraylist of mappings of column names onto values

Returns:

all rows in the result

hasResults

boolean hasResults()

Deprecated.

Returns if the query returned results (at least one row with one column)

Returns:

true if the query returned results, false otherwise