javax.servlet.jsp.jstl.sql
Interface Result

public interface Result

This interface represents the result of a <sql:query> action. It provides access to the following information in the query result:

• result rows
• result rows using an index
• number of rows in the result
• result meta data
• indication whether result returned is a complete set or a subset limited by a maximum row setting

Method Summary

java.lang.String[]	getColumnNames() Returns an array of column names.
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 Objects[].
boolean	isLimitedByMaxRows() Returns true of the query was limited by a maximum row setting

Method Detail

getRows

public java.util.SortedMap[] getRows()

Returns an array of SortedMap objects. Column name is used as the key for the column value. SortedMap must use the CASE_INSENSITIVE_ORDER Comparator so that the key is the case insensitive representation of the column name.

Returns:

the result rows as an array of SortedMap objects

getRowsByIndex

public java.lang.Object[][] getRowsByIndex()

Returns an array of Objects[]. The first index designates the Row, the second the Column. The array stores the value at the specified row and column.

Returns:

the result rows as an array of Object[] objects

getColumnNames

public java.lang.String[] getColumnNames()

Returns an array of column names.

Returns:

the column names as an array of String objects

getRowCount

public int getRowCount()

Returns the number of rows in the cached ResultSet

Returns:

the number of rows in the result

isLimitedByMaxRows

public boolean isLimitedByMaxRows()

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

Returns:

true if the query was limited by a maximum row setting