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 Details

    • SqlQueryResult

      protected SqlQueryResult(ResultSet result)

  • Method Details

    • 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.