Package com.avoka.core.sql

Class PreparedStatementExecutor

java.lang.Object

com.avoka.core.sql.PreparedStatementExecutor

public class PreparedStatementExecutor
extends Object

Provide a utility to execute PreparedStatements.

Constructor Summary

Constructors

Constructor	Description
PreparedStatementExecutor()	Create a PreparedStatementExecutor.
PreparedStatementExecutor(Connection connection)	Create a PreparedStatementExecutor which will use the given connection.

Method Summary

Modifier and Type	Method	Description
void	executeQuery(String sqlStatement, ResultSetProcessor resultSetProcessor)	Execute the sql statement and the result is handled by the processor.
void	executeQuery(String sqlStatement, String[] args, ResultSetProcessor resultSetProcessor)	Execute the sql statement with list of arguments and the result is handled by the processor.
int	executeUpdate(String sqlStatement, Object[] args)	Execute the sql statement with list of arguments and the result is handled by the processor.

Methods inherited from class java.lang.Object

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

Constructor Details

PreparedStatementExecutor

public PreparedStatementExecutor()

Create a PreparedStatementExecutor.

PreparedStatementExecutor

public PreparedStatementExecutor(Connection connection)

Create a PreparedStatementExecutor which will use the given connection. The provided connection will not be closed after the query has been executed.

Parameters:

connection - the database connection to use

Method Details

executeQuery

public void executeQuery(String sqlStatement,
 ResultSetProcessor resultSetProcessor)

Execute the sql statement and the result is handled by the processor.

Parameters:

sqlStatement - sql statement

resultSetProcessor - the result set processor

executeQuery

public void executeQuery(String sqlStatement,
 String[] args,
 ResultSetProcessor resultSetProcessor)

Execute the sql statement with list of arguments and the result is handled by the processor.

Parameters:

sqlStatement - sql statement

args - arguments for the prepared statement

resultSetProcessor - the result set processor

executeUpdate

public int executeUpdate(String sqlStatement,
 Object[] args)

Execute the sql statement with list of arguments and the result is handled by the processor.

Parameters:

sqlStatement - sql statement (required)

args - arguments for the prepared statement

Returns:

number of rows updated.