Package com.aquima.interactions.foundation.connectivity.impl

Class SqlQueryResult

java.lang.Object

com.aquima.interactions.foundation.connectivity.impl.SqlQueryResult

All Implemented Interfaces:

IQueryResult

public class SqlQueryResult
extends Object
implements IQueryResult

Java implementation of the IQueryResult interface.

Since:

6.3

Author:

O. Kerpershoek

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	SqlQueryResult(ResultSet result)

Method Summary

Modifier and Type	Method	Description
BooleanValue	getBooleanValue(String columnName)	This method returns the BooleanValue for the specified column.
byte[]	getBytes(String columnName)	Retrieves a byte array from the resultset for the specodoed column.
Currency	getCurrency(String columnName)	This method returns the Currency value for the specified column.
DateValue	getDate(String columnName)	Retrieves a Date object from the resultset for the specified column.
DateTimeValue	getDateTime(String columnName)	Retrieves a date time object from the resultset for the specified column.
IntegerValue	getIntegerValue(String columnName)	Retrieves an IntegerValue object from the resultset for the specified column.
NumberValue	getNumberValue(String columnName)	Retrieves a NumberValue object from the resultset for the specified column.
Percentage	getPercentage(String columnName)	Retrieves a Percentage object from the resultset for the specified column.
StringValue	getString(String columnName)	Retrieves a String object from the resultset for the specified column.
IPrimitiveValue	getValue(String columnName)
boolean	next()	This method will move the result iterator to the next row in the result, and return a boolean indicating if a next row is available.

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlQueryResult

protected SqlQueryResult(ResultSet result)

Method Detail

next

public boolean next()

Description copied from interface: IQueryResult

This method will move the result iterator to the next row in the result, and return a boolean indicating if a next row is available. The next method should always be invoked before results can be retrieved from this object.

Specified by:

next in interface IQueryResult

Returns:

Boolean indicating if (more) results are available.

getBooleanValue

public BooleanValue getBooleanValue(String columnName)

Description copied from interface: IQueryResult

This method returns the BooleanValue for the specified column. The value returned will never be null, but the value might be unknown.

Specified by:

getBooleanValue in interface IQueryResult

Parameters:

columnName - The name of the column for which the value is requested.

Returns:

BooleanValue for the specified column.

getCurrency

public Currency getCurrency(String columnName)

Description copied from interface: IQueryResult

This method returns the Currency value for the specified column. The value returned will never be null, but the value might be unknown.

Specified by:

getCurrency in interface IQueryResult

Parameters:

columnName - the name of the column for which the value is requested.

Returns:

Currency for the specified column

getDate

public DateValue getDate(String columnName)

Description copied from interface: IQueryResult

Retrieves a Date object from the resultset for the specified column.

Specified by:

getDate in interface IQueryResult

Parameters:

columnName - The name of the column for which the value is requested.

Returns:

The Date value from the resultset for the specified column name.

getDateTime

public DateTimeValue getDateTime(String columnName)

Description copied from interface: IQueryResult

Retrieves a date time object from the resultset for the specified column.

Specified by:

getDateTime in interface IQueryResult

Parameters:

columnName - The name of the column for which the value is requested.

Returns:

The Date value from the resultset for the specified column name.

getIntegerValue

public IntegerValue getIntegerValue(String columnName)

Description copied from interface: IQueryResult

Retrieves an IntegerValue object from the resultset for the specified column.

Specified by:

getIntegerValue in interface IQueryResult

Parameters:

columnName - The name of the column for which the value is requested.

Returns:

The Integer value from the resultset for the specified column name.

getNumberValue

public NumberValue getNumberValue(String columnName)

Description copied from interface: IQueryResult

Retrieves a NumberValue object from the resultset for the specified column.

Specified by:

getNumberValue in interface IQueryResult

Parameters:

columnName - The name of the column for which the value is requested.

Returns:

The Double value from the resultset for the specified column name.

getPercentage

public Percentage getPercentage(String columnName)

Description copied from interface: IQueryResult

Retrieves a Percentage object from the resultset for the specified column.

Specified by:

getPercentage in interface IQueryResult

Parameters:

columnName - The name of the column for which the value is requested.

Returns:

The Percentage value from the resultset for the specified column name.

getString

public StringValue getString(String columnName)

Description copied from interface: IQueryResult

Retrieves a String object from the resultset for the specified column.

Specified by:

getString in interface IQueryResult

Parameters:

columnName - The name of the column for which the value is requested.

Returns:

The String value from the resultset for the specified column name.

getValue

public IPrimitiveValue getValue(String columnName)

getBytes

public byte[] getBytes(String columnName)

Description copied from interface: IQueryResult

Retrieves a byte array from the resultset for the specodoed column.

Specified by:

getBytes in interface IQueryResult

Parameters:

columnName - The name of the column for which the value is requested.

Returns:

The byte array value from the resultset for the specified column name.