gov.va.vinci.leo.tools.db

Class LeoArrayListHandler

java.lang.Object

org.apache.commons.dbutils.handlers.AbstractListHandler<Object[]>

org.apache.commons.dbutils.handlers.ArrayListHandler

gov.va.vinci.leo.tools.db.LeoArrayListHandler

All Implemented Interfaces:

org.apache.commons.dbutils.ResultSetHandler<List<Object[]>>

public class LeoArrayListHandler
extends org.apache.commons.dbutils.handlers.ArrayListHandler

Handles executing the query and processing the result set. User: Thomas Ginter Date: 7/17/14 Time: 13:39

Field Summary

Fields

Modifier and Type	Field and Description
protected HashMap<String,Integer>	mColumnNames Map of column name to index location in the result set.
protected ResultSetMetaData	mResultSetMetaData Metadata from the ResultSet passed into the handle method.

Constructor Summary

Constructors

Constructor and Description
LeoArrayListHandler()

Method Summary

Modifier and Type	Method and Description
int	getColumnIndex(String name) Get the index of the column name provided from the last query handled.
Set<String>	getColumnNames() Get the set of column names from the last query handled.
ResultSetMetaData	getResultSetMetaData() Return the ResultSetMetaData from the last query handled.
List<Object[]>	handle(ResultSet rs) Whole ResultSet handler.
boolean	hasColumn(String name) Checks the column names from the last executed query, returns true if the name is found.

Methods inherited from class org.apache.commons.dbutils.handlers.ArrayListHandler

handleRow

Methods inherited from class java.lang.Object

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

Field Detail

mResultSetMetaData

protected ResultSetMetaData mResultSetMetaData

Metadata from the ResultSet passed into the handle method.

mColumnNames

protected HashMap<String,Integer> mColumnNames

Map of column name to index location in the result set.

Constructor Detail

LeoArrayListHandler

public LeoArrayListHandler()

Method Detail

handle

public List<Object[]> handle(ResultSet rs)
                      throws SQLException

Whole ResultSet handler. It produce List as result. To convert individual rows into Java objects it uses handleRow(ResultSet) method.

Specified by:

handle in interface org.apache.commons.dbutils.ResultSetHandler<List<Object[]>>

Overrides:

handle in class org.apache.commons.dbutils.handlers.AbstractListHandler<Object[]>

Parameters:

rs - ResultSet to process.

Returns:

a list of all rows in the result set

Throws:

SQLException - error occurs

See Also:

ArrayListHandler.handleRow(java.sql.ResultSet)

getResultSetMetaData

public ResultSetMetaData getResultSetMetaData()

Return the ResultSetMetaData from the last query handled.

Returns:

ResultSetMetaData object

getColumnNames

public Set<String> getColumnNames()

Get the set of column names from the last query handled.

Returns:

Set of column names

hasColumn

public boolean hasColumn(String name)

Checks the column names from the last executed query, returns true if the name is found.

Parameters:

name - Column name to check for

Returns:

true if found, false if not found or the column names have not been set

getColumnIndex

public int getColumnIndex(String name)

Get the index of the column name provided from the last query handled.

Parameters:

name - Column name whose index will be retrieved

Returns:

index of the column or -1 if not found or the list is empty