Package com.aquima.interactions.foundation.connectivity

Interface IQueryResult

All Known Implementing Classes:
SqlQueryResult
public interface IQueryResult
This interface defines the methods that can be used to iterate over the result of a query.
Since:
6.3
Author:
O. Kerpershoek

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

  • Method Details

    • next

      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. The next method should always be invoked before results can be retrieved from this object.
      Returns:
      Boolean indicating if (more) results are available.

    • getBooleanValue

      BooleanValue getBooleanValue(String columnName)
      This method returns the BooleanValue for the specified column. The value returned will never be null, but the value might be unknown.
      Parameters:
      columnName - The name of the column for which the value is requested.
      Returns:
      BooleanValue for the specified column.

    • getCurrency

      Currency getCurrency(String columnName)
      This method returns the Currency value for the specified column. The value returned will never be null, but the value might be unknown.
      Parameters:
      columnName - the name of the column for which the value is requested.
      Returns:
      Currency for the specified column

    • getDate

      DateValue getDate(String columnName)
      Retrieves a Date object from the resultset for the specified column.
      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

      DateTimeValue getDateTime(String columnName)
      Retrieves a date time object from the resultset for the specified column.
      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.

    • getNumberValue

      NumberValue getNumberValue(String columnName)
      Retrieves a NumberValue object from the resultset for the specified column.
      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

      Percentage getPercentage(String columnName)
      Retrieves a Percentage object from the resultset for the specified column.
      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.

    • getIntegerValue

      IntegerValue getIntegerValue(String columnName)
      Retrieves an IntegerValue object from the resultset for the specified column.
      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.

    • getString

      StringValue getString(String columnName)
      Retrieves a String object from the resultset for the specified column.
      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.

    • getBytes

      byte[] getBytes(String columnName)
      Retrieves a byte array from the resultset for the specodoed column.
      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.