Java org.apache.commons.dbutils QueryRunner fields, constructors, methods, implement or subclass

Introduction

In this page you can find the methods, fields and constructors for org.apache.commons.dbutils QueryRunner.

The text is from its open source code.

Subclass

org.apache.commons.dbutils.QueryRunner has subclasses.
Click this link to see all its subclasses.

Constructor

	QueryRunner() Constructor for QueryRunner.
	QueryRunner(boolean pmdKnownBroken) Constructor for QueryRunner that controls the use of `ParameterMetaData`.
	QueryRunner(DataSource ds) Constructor for QueryRunner that takes a `DataSource` to use.
	QueryRunner(DataSource ds, boolean pmdKnownBroken) Constructor for QueryRunner that takes a `DataSource` and controls the use of `ParameterMetaData`.

Method

int[]	batch(Connection conn, String sql, Object[][] params) Execute a batch of SQL INSERT, UPDATE, or DELETE queries.
int[]	batch(String sql, Object[][] params) Execute a batch of SQL INSERT, UPDATE, or DELETE queries.
Class	getClass() Returns the runtime class of this Object .
DataSource	getDataSource() Returns the `DataSource` this runner is using.
T	query(Connection conn, String sql, ResultSetHandler rsh) Execute an SQL SELECT query without any replacement parameters.
T	query(String sql, Object param, ResultSetHandler rsh) Executes the given SELECT SQL with a single replacement parameter.
T	query(String sql, Object[] params, ResultSetHandler rsh) Executes the given SELECT SQL query and returns a result object.
T	query(String sql, ResultSetHandler rsh, Object... params) Executes the given SELECT SQL query and returns a result object.
T	query(Connection conn, String sql, Object param, ResultSetHandler rsh) Execute an SQL SELECT query with a single replacement parameter.
T	query(Connection conn, String sql, Object[] params, ResultSetHandler rsh) Execute an SQL SELECT query with replacement parameters.
T	query(Connection conn, String sql, ResultSetHandler rsh, Object... params) Execute an SQL SELECT query with replacement parameters.
T	query(String sql, ResultSetHandler rsh) Executes the given SELECT SQL without any replacement parameters.
T	query(Connection conn, boolean closeConn, String sql, ResultSetHandler rsh, Object... params) Calls query after checking the parameters to ensure nothing is null.
int	update(String sql) Executes the given INSERT, UPDATE, or DELETE SQL statement without any replacement parameters.
int	update(Connection conn, String sql, Object param) Execute an SQL INSERT, UPDATE, or DELETE query with a single replacement parameter.
int	update(Connection conn, String sql, Object... params) Execute an SQL INSERT, UPDATE, or DELETE query.
int	update(Connection conn, String sql) Execute an SQL INSERT, UPDATE, or DELETE query without replacement parameters.
int	update(String sql, Object param) Executes the given INSERT, UPDATE, or DELETE SQL statement with a single replacement parameter.
int	update(String sql, Object... params) Executes the given INSERT, UPDATE, or DELETE SQL statement.
int	update(Connection conn, boolean closeConn, String sql, Object... params) Calls update after checking the parameters to ensure nothing is null.