com.github.drinkjava2.jdialects.tinyjdbc

Class TinyResult

java.lang.Object

com.github.drinkjava2.jdialects.tinyjdbc.TinyResult

public class TinyResult
extends Object

This class is copied from javax.servlet.jsp.jstl.sql package but made tiny changes (Yong said)

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. It is not part of the JSTL API; it serves merely as a back-end to ResultSupport's static methods. Thus, we scope its access to the package.

Author:

Hans Bergsten, Justyna Horwat, Yong Zhu (in jSQLBox project)

Constructor Summary

Constructors

Constructor and Description
TinyResult(ResultSet rs, int startRow, int maxRows) This constructor reads the ResultSet and saves a cached copy.

Method Summary

Methods

Modifier and Type	Method and Description
String[]	getColumnNames() Returns an array of String objects.
String	getDebugInfo() This method is added by Yong Zhu
List	getFirstColumns() This method is added by Yong Zhu
int	getRowCount() Returns the number of rows in the cached ResultSet
SortedMap[]	getRows() Returns an array of SortedMap objects.
Object[][]	getRowsByIndex() Returns an array of Object[] objects.
boolean	isLimitedByMaxRows() Returns true if the query was limited by a maximum row setting

Methods inherited from class java.lang.Object

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

Constructor Detail

TinyResult

public TinyResult(ResultSet rs,
          int startRow,
          int maxRows)
           throws SQLException

This constructor reads the ResultSet and saves a cached copy. It's important to note that this object will be serializable only if the objects returned by the ResultSet are serializable too.

Parameters:

rs - an open ResultSet, positioned before the first row

startRow - beginning row to be cached

maxRows - query maximum rows limit

Throws:

SQLException - if a database error occurs

Method Detail

getRows

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

Returns:

an array of Map, or null if there are no rows

getRowsByIndex

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

Returns:

an array of Object[], or null if there are no rows

getColumnNames

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

Returns:

an array of String[]

getRowCount

public int getRowCount()

Returns the number of rows in the cached ResultSet

Returns:

the number of cached rows, or -1 if the Result could not be initialized due to SQLExceptions

isLimitedByMaxRows

public boolean isLimitedByMaxRows()

Returns true if the query was limited by a maximum row setting

Returns:

true if the query was limited by a MaxRows attribute

getFirstColumns

public List getFirstColumns()

This method is added by Yong Zhu

Returns:

Get a List only include first column values

getDebugInfo

public String getDebugInfo()

This method is added by Yong Zhu