Interface SqlResult

All Known Implementing Classes:
DynamicResultIterator.SqlResultImpl, PlotServlet.CFSqlResult

public interface SqlResult
This interface represents a single row in the results of a SqlQuery.
Version:
2.0
Author:
Nicklas
Last modified
$Date: 2009-06-23 11:28:29 +0200 (ti, 23 jun 2009) $
  • Method Summary

    Modifier and Type
    Method
    Description
    float
    getFloat(int index)
    Get the value of the specified column as a float.
    int
    getInt(int index)
    Get the value of the specified column as an integer.
    getObject(int index)
    Get the value of the specified column as an object.
    short
    getShort(int index)
    Get the value of the specified column as a short.
    getString(int index)
    Get the value of the specified column as a string.
  • Method Details

    • getShort

      short getShort(int index) throws SQLException
      Get the value of the specified column as a short.
      Parameters:
      index - The index of the column, starting at 1
      Returns:
      The value, or 0 if the database contains null
      Throws:
      SQLException - If an error occurs
    • getInt

      int getInt(int index) throws SQLException
      Get the value of the specified column as an integer.
      Parameters:
      index - The index of the column, starting at 1
      Returns:
      The value, or 0 if the database contains null
      Throws:
      SQLException - If an error occurs
    • getFloat

      float getFloat(int index) throws SQLException
      Get the value of the specified column as a float.
      Parameters:
      index - The index of the column, starting at 1
      Returns:
      The value, or 0 if the database contains null
      Throws:
      SQLException - If an error occurs
    • getString

      String getString(int index) throws SQLException
      Get the value of the specified column as a string.
      Parameters:
      index - The index of the column, starting at 1
      Returns:
      The string value
      Throws:
      SQLException - If an error occurs
    • getObject

      Object getObject(int index) throws SQLException
      Get the value of the specified column as an object.
      Parameters:
      index - The index of the column, starting at 1
      Returns:
      The string value
      Throws:
      SQLException - If an error occurs