Package org.apache.taglibs.standard.tag.common.sql

Class ResultImpl

  • All Implemented Interfaces:
    Result
    public class ResultImpl
extends java.lang.Object
implements Result

    This class creates a cached version of a ResultSet. It's represented as a Result implementation, capable of returing an array of Row objects containing a Column instance for each column in the row.

    Note -- this is a private copy for the RI to avoid making the corresponding class in javax.servlet.* public.

    • Constructor Summary

      Constructors 
      Constructor Description
      ResultImpl​(java.sql.ResultSet rs)
      Build a Result object from a ResultSet object.
      ResultImpl​(java.sql.ResultSet rs, int maxRows)
      Build a Result object from a ResultSet object.
      ResultImpl​(java.sql.ResultSet rs, int startRow, int maxRows)
      This constructor reads the ResultSet and saves a cached copy.

    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      java.lang.String[] getColumnNames()
      Returns an array of String objects.
      int getRowCount()
      Returns the number of rows in the cached ResultSet
      java.util.SortedMap[] getRows()
      Returns an array of SortedMap objects.
      java.lang.Object[][] getRowsByIndex()
      Returns an array of Object[] objects.
      boolean isLimitedByMaxRows()
      Returns true of the query was limited by a maximum row setting

      • Methods inherited from class java.lang.Object

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

    • Constructor Detail

      • ResultImpl

        public ResultImpl​(java.sql.ResultSet rs)
           throws java.sql.SQLException
        Build a Result object from a ResultSet object.
        Parameters:
        rs - an open ResultSet, positioned before the first row
        Throws:
        java.sql.SQLException - if a database error occurs

      • ResultImpl

        public ResultImpl​(java.sql.ResultSet rs,
                  int maxRows)
           throws java.sql.SQLException
        Build a Result object from a ResultSet object.
        Parameters:
        rs - an open ResultSet, positioned before the first row
        maxRows - query maximum rows limit
        Throws:
        java.sql.SQLException - if a database error occurs

      • ResultImpl

        public ResultImpl​(java.sql.ResultSet rs,
                  int startRow,
                  int maxRows)
           throws java.sql.SQLException
        This constructor reads the ResultSet and saves a cached copy.
        Parameters:
        rs - an open ResultSet, positioned before the first row
        startRow - beginning row to be cached
        maxRows - query maximum rows limit
        Throws:
        java.sql.SQLException - if a database error occurs

    • Method Detail

      • getRows

        public java.util.SortedMap[] getRows()
        Returns an array of SortedMap objects. The SortedMap object key is the ColumnName and the value is the ColumnValue. SortedMap was created using the CASE_INSENSITIVE_ORDER Comparator so the key is the case insensitive representation of the ColumnName.
        Specified by:
        getRows in interface Result
        Returns:
        an array of Map, or null if there are no rows

      • getRowsByIndex

        public java.lang.Object[][] getRowsByIndex()
        Returns an array of Object[] objects. The first index designates the Row, the second the Column. The array stores the value at the specified row and column.
        Specified by:
        getRowsByIndex in interface Result
        Returns:
        an array of Object[], or null if there are no rows

      • getColumnNames

        public java.lang.String[] getColumnNames()
        Returns an array of String objects. The array represents the names of the columns arranged in the same order as in the getRowsByIndex() method.
        Specified by:
        getColumnNames in interface Result
        Returns:
        an array of String[]

      • getRowCount

        public int getRowCount()
        Returns the number of rows in the cached ResultSet
        Specified by:
        getRowCount in interface Result
        Returns:
        the number of cached rows, or -1 if the Result could not be initialized due to SQLExceptions

      • isLimitedByMaxRows

        public boolean isLimitedByMaxRows()
        Returns true of the query was limited by a maximum row setting
        Specified by:
        isLimitedByMaxRows in interface Result
        Returns:
        true if the query was limited by a MaxRows attribute