gov.va.vinci.leo.tools.db

Class DataManager

java.lang.Object

org.apache.commons.dbutils.AbstractQueryRunner

org.apache.commons.dbutils.QueryRunner

gov.va.vinci.leo.tools.db.DataManager

public class DataManager
extends org.apache.commons.dbutils.QueryRunner

Handle the database connection, query, and result set. Returns one row at a time in the form of an ArrayList via the getRow method.

Author:

thomasginter

Field Summary

Fields

Modifier and Type	Field and Description
protected LeoArrayListHandler	handler Query results handler.

Fields inherited from class org.apache.commons.dbutils.AbstractQueryRunner

ds

Constructor Summary

Constructors

Constructor and Description
DataManager(DatabaseConnectionInformation databaseConnectionInformation) Constructor with database connection information.
DataManager(DataSource dataSource) Initialize the DataManager with a DataSource object.
DataManager(String driver, String url, String user, String pwd) Constructor.

Method Summary

Modifier and Type	Method and Description
LeoArrayListHandler	getHandler() Return a reference to the LeoArrayListHandler which manages query execution and results.
ResultSetMetaData	getResultSetMetaData() Return the MetaData from the ResultSet of the query that was last executed.
List<Object[]>	query(String sql) Execute a SQL query against the database and capture the ResultSet.
List<Object[]>	query(String sql, Object... params) Execute a SQL query against the database and capture the ResultSet.

Methods inherited from class org.apache.commons.dbutils.QueryRunner

batch, batch, insert, insert, insert, insert, insertBatch, insertBatch, query, query, query, query, query, query, query, query, update, update, update, update, update, update

Methods inherited from class org.apache.commons.dbutils.AbstractQueryRunner

close, close, close, fillStatement, fillStatementWithBean, fillStatementWithBean, getDataSource, isPmdKnownBroken, prepareConnection, prepareStatement, prepareStatement, rethrow, wrap

Methods inherited from class java.lang.Object

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

Field Detail

handler

protected LeoArrayListHandler handler

Query results handler.

Constructor Detail

DataManager

public DataManager(String driver,
                   String url,
                   String user,
                   String pwd)
            throws ClassNotFoundException,
                   SQLException

Constructor.

Parameters:

driver - the jdbc driver class.

url - the jdbc connection url.

user - the connection username.

pwd - the connection password.

Throws:

ClassNotFoundException - thrown if the JDBC driver cannot be found.

IllegalAccessException - thrown if there is an access exception making the JDBC driver connection.

InstantiationException - thrown if the JDBC driver cannot be instantiated.

SQLException - thrown if there is an exception with the query or result set.

DataManager

public DataManager(DatabaseConnectionInformation databaseConnectionInformation)
            throws ClassNotFoundException,
                   SQLException

Constructor with database connection information.

Parameters:

databaseConnectionInformation - the connection information object.

Throws:

ClassNotFoundException - thrown if the JDBC driver cannot be found.

IllegalAccessException - thrown if there is an access exception making the JDBC driver connection.

InstantiationException - thrown if the JDBC driver cannot be instantiated.

SQLException - thrown if there is an exception with the query or result set.

DataManager

public DataManager(DataSource dataSource)

Initialize the DataManager with a DataSource object.

Parameters:

dataSource - the data source to use for the query.

Method Detail

query

public List<Object[]> query(String sql)
                     throws SQLException

Execute a SQL query against the database and capture the ResultSet.

Parameters:

sql - the sql to execute.

Returns:

List of Object[], each array represents one row of results.

Throws:

SQLException - if a SQL error occurs.

query

public List<Object[]> query(String sql,
                            Object... params)
                     throws SQLException

Execute a SQL query against the database and capture the ResultSet.

Parameters:

sql - the sql to execute.

params - the parameters to pass to the sql query.

Returns:

List of Object[], each array represents one row of results.

Throws:

SQLException - if a SQL error occurs.

getResultSetMetaData

public ResultSetMetaData getResultSetMetaData()

Return the MetaData from the ResultSet of the query that was last executed.

Returns:

the ResultSetMetaData from the last query.

getHandler

public LeoArrayListHandler getHandler()

Return a reference to the LeoArrayListHandler which manages query execution and results.

Returns:

reference to the LeoArrayListHandler