Package nl.b3p.brmo.sql

Class LoggingQueryRunner

java.lang.Object

org.apache.commons.dbutils.AbstractQueryRunner

org.apache.commons.dbutils.QueryRunner

nl.b3p.brmo.sql.LoggingQueryRunner

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

Wrapper for QueryRunner that logs the SQL to commons-logging. Enable TRACE logging to also log parameters.

Field Summary

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

ds

Constructor Summary

Constructors

Constructor	Description
LoggingQueryRunner()
LoggingQueryRunner(boolean pmdKnownBroken)
LoggingQueryRunner(DataSource ds)
LoggingQueryRunner(DataSource ds, boolean pmdKnownBroken)
LoggingQueryRunner(DataSource ds, boolean pmdKnownBroken, org.apache.commons.dbutils.StatementConfiguration stmtConfig)
LoggingQueryRunner(DataSource ds, org.apache.commons.dbutils.StatementConfiguration stmtConfig)
LoggingQueryRunner(org.apache.commons.dbutils.StatementConfiguration stmtConfig)

Method Summary

Modifier and Type	Method	Description
int[]	batch(String sql, Object[][] params)
int[]	batch(Connection conn, String sql, Object[][] params)
int	execute(String sql, Object... params)
<T> List<T>	execute(String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh, Object... params)
int	execute(Connection conn, String sql, Object... params)
<T> List<T>	execute(Connection conn, String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh, Object... params)
<T> T	insert(String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh)
<T> T	insert(String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh, Object... params)
<T> T	insert(Connection conn, String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh)
<T> T	insert(Connection conn, String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh, Object... params)
<T> T	insertBatch(String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh, Object[][] params)
<T> T	insertBatch(Connection conn, String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh, Object[][] params)
<T> T	query(String sql, Object[] params, org.apache.commons.dbutils.ResultSetHandler<T> rsh)	Deprecated.
<T> T	query(String sql, Object param, org.apache.commons.dbutils.ResultSetHandler<T> rsh)	Deprecated.
<T> T	query(String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh)
<T> T	query(String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh, Object... params)
<T> T	query(Connection conn, String sql, Object[] params, org.apache.commons.dbutils.ResultSetHandler<T> rsh)	Deprecated.
<T> T	query(Connection conn, String sql, Object param, org.apache.commons.dbutils.ResultSetHandler<T> rsh)	Deprecated.
<T> T	query(Connection conn, String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh)
<T> T	query(Connection conn, String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh, Object... params)
int	update(String sql)
int	update(String sql, Object param)
int	update(String sql, Object... params)
int	update(Connection conn, String sql)
int	update(Connection conn, String sql, Object param)
int	update(Connection conn, String sql, Object... params)

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

close, close, close, closeQuietly, closeQuietly, closeQuietly, fillStatement, fillStatement, fillStatementWithBean, fillStatementWithBean, getDataSource, getParameterMetaData, isPmdKnownBroken, prepareCall, prepareConnection, prepareStatement, prepareStatement, rethrow, wrap

Methods inherited from class java.lang.Object

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

Constructor Details

LoggingQueryRunner

public LoggingQueryRunner()

LoggingQueryRunner

public LoggingQueryRunner(boolean pmdKnownBroken)

LoggingQueryRunner

public LoggingQueryRunner(DataSource ds)

LoggingQueryRunner

public LoggingQueryRunner(org.apache.commons.dbutils.StatementConfiguration stmtConfig)

LoggingQueryRunner

public LoggingQueryRunner(DataSource ds,
 boolean pmdKnownBroken)

LoggingQueryRunner

public LoggingQueryRunner(DataSource ds,
 org.apache.commons.dbutils.StatementConfiguration stmtConfig)

LoggingQueryRunner

public LoggingQueryRunner(DataSource ds,
 boolean pmdKnownBroken,
 org.apache.commons.dbutils.StatementConfiguration stmtConfig)

Method Details

batch

public int[] batch(Connection conn,
 String sql,
 Object[][] params)
            throws SQLException

Overrides:

batch in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

batch

public int[] batch(String sql,
 Object[][] params)
            throws SQLException

Overrides:

batch in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

query

@Deprecated
public <T> T query(Connection conn,
 String sql,
 Object param,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh)
            throws SQLException

Deprecated.

Overrides:

query in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

query

@Deprecated
public <T> T query(Connection conn,
 String sql,
 Object[] params,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh)
            throws SQLException

Deprecated.

Overrides:

query in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

query

public <T> T query(Connection conn,
 String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh,
 Object... params)
            throws SQLException

Overrides:

query in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

query

public <T> T query(Connection conn,
 String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh)
            throws SQLException

Overrides:

query in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

query

@Deprecated
public <T> T query(String sql,
 Object param,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh)
            throws SQLException

Deprecated.

Overrides:

query in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

query

@Deprecated
public <T> T query(String sql,
 Object[] params,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh)
            throws SQLException

Deprecated.

Overrides:

query in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

query

public <T> T query(String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh,
 Object... params)
            throws SQLException

Overrides:

query in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

query

public <T> T query(String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh)
            throws SQLException

Overrides:

query in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

update

public int update(Connection conn,
 String sql)
           throws SQLException

Overrides:

update in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

update

public int update(Connection conn,
 String sql,
 Object param)
           throws SQLException

Overrides:

update in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

update

public int update(Connection conn,
 String sql,
 Object... params)
           throws SQLException

Overrides:

update in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

update

public int update(String sql)
           throws SQLException

Overrides:

update in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

update

public int update(String sql,
 Object param)
           throws SQLException

Overrides:

update in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

update

public int update(String sql,
 Object... params)
           throws SQLException

Overrides:

update in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

insert

public <T> T insert(String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh)
             throws SQLException

Overrides:

insert in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

insert

public <T> T insert(String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh,
 Object... params)
             throws SQLException

Overrides:

insert in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

insert

public <T> T insert(Connection conn,
 String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh)
             throws SQLException

Overrides:

insert in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

insert

public <T> T insert(Connection conn,
 String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh,
 Object... params)
             throws SQLException

Overrides:

insert in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

insertBatch

public <T> T insertBatch(String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh,
 Object[][] params)
                  throws SQLException

Overrides:

insertBatch in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

insertBatch

public <T> T insertBatch(Connection conn,
 String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh,
 Object[][] params)
                  throws SQLException

Overrides:

insertBatch in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

execute

public int execute(Connection conn,
 String sql,
 Object... params)
            throws SQLException

Overrides:

execute in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

execute

public int execute(String sql,
 Object... params)
            throws SQLException

Overrides:

execute in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

execute

public <T> List<T> execute(Connection conn,
 String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh,
 Object... params)
                    throws SQLException

Overrides:

execute in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException

execute

public <T> List<T> execute(String sql,
 org.apache.commons.dbutils.ResultSetHandler<T> rsh,
 Object... params)
                    throws SQLException

Overrides:

execute in class org.apache.commons.dbutils.QueryRunner

Throws:

SQLException