Package net.sf.jett.jdbc

Class JDBCExecutor

java.lang.Object

net.sf.jett.jdbc.JDBCExecutor

public class JDBCExecutor
extends java.lang.Object

A JDBCExecutor has the capability of running SQL statements via JDBC over a supplied Connection.

Since:

0.6.0

Author:

Randy Gettman

Constructor Summary

Constructors

Constructor	Description
JDBCExecutor(java.sql.Connection connection)	Constructs a JDBCExecutor that will operate over the given open Connection to a database.

Method Summary

Modifier and Type	Method	Description
java.util.List<ResultSetRow>	execQuery(java.lang.String sql)	Executes the given SQL statement using a Statement to obtain a List of ResultSetRows.
java.util.List<ResultSetRow>	execQuery(java.lang.String sql, java.lang.Object... bindVariableValues)	Executes the given SQL statement using a PreparedStatement to obtain a List of ResultSetRows.

Methods inherited from class java.lang.Object

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

Constructor Detail

JDBCExecutor

public JDBCExecutor(java.sql.Connection connection)

Constructs a JDBCExecutor that will operate over the given open Connection to a database.

Parameters:

connection - An open Connection.

Method Detail

execQuery

public java.util.List<ResultSetRow> execQuery(java.lang.String sql)
                                       throws java.sql.SQLException

Executes the given SQL statement using a Statement to obtain a List of ResultSetRows. Execution of the Statement yields a ResultSet, which is processed to create the ResultSetRows.

Parameters:

sql - The SQL statement.

Returns:

A List of ResultSetRows.

Throws:

java.sql.SQLException - If there was a problem executing the statement.

execQuery

public java.util.List<ResultSetRow> execQuery(java.lang.String sql,
                                              java.lang.Object... bindVariableValues)
                                       throws java.sql.SQLException

Executes the given SQL statement using a PreparedStatement to obtain a List of ResultSetRows. Execution of the PreparedStatement yields a ResultSet, which is processed to create the ResultSetRows.

Parameters:

sql - The SQL statement.

bindVariableValues - Optional bind variable values. There must be exactly one of these for every ? in the SQL query.

Returns:

A List of ResultSetRows.

Throws:

java.sql.SQLException - If there was a problem executing the statement.