public class QueryRunner extends AbstractQueryRunner
ResultSet
s. This class is thread safe.ResultSetHandler
ds
Constructor and Description |
---|
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 . |
Modifier and Type | Method and Description |
---|---|
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.
|
<T> T |
query(Connection conn,
String sql,
Object[] params,
ResultSetHandler<T> rsh)
Deprecated.
|
<T> T |
query(Connection conn,
String sql,
Object param,
ResultSetHandler<T> rsh)
Deprecated.
|
<T> T |
query(Connection conn,
String sql,
ResultSetHandler<T> rsh)
Execute an SQL SELECT query without any replacement parameters.
|
<T> T |
query(Connection conn,
String sql,
ResultSetHandler<T> rsh,
Object... params)
Execute an SQL SELECT query with replacement parameters.
|
<T> T |
query(String sql,
Object[] params,
ResultSetHandler<T> rsh)
Deprecated.
|
<T> T |
query(String sql,
Object param,
ResultSetHandler<T> rsh)
Deprecated.
|
<T> T |
query(String sql,
ResultSetHandler<T> rsh)
Executes the given SELECT SQL without any replacement parameters.
|
<T> T |
query(String sql,
ResultSetHandler<T> rsh,
Object... params)
Executes the given SELECT SQL query and returns a result object.
|
int |
update(Connection conn,
String sql)
Execute an SQL INSERT, UPDATE, or DELETE query without replacement
parameters.
|
int |
update(Connection conn,
String sql,
Object... params)
Execute an SQL INSERT, UPDATE, or DELETE query.
|
int |
update(Connection conn,
String sql,
Object param)
Execute an SQL INSERT, UPDATE, or DELETE query with a single replacement
parameter.
|
int |
update(String sql)
Executes the given INSERT, UPDATE, or DELETE SQL statement without
any replacement parameters.
|
int |
update(String sql,
Object... params)
Executes the given INSERT, UPDATE, or DELETE SQL statement.
|
int |
update(String sql,
Object param)
Executes the given INSERT, UPDATE, or DELETE SQL statement with
a single replacement parameter.
|
close, close, close, fillStatement, fillStatementWithBean, fillStatementWithBean, getDataSource, isPmdKnownBroken, prepareConnection, prepareStatement, rethrow, wrap
public QueryRunner()
public QueryRunner(boolean pmdKnownBroken)
ParameterMetaData
.pmdKnownBroken
- Some drivers don't support ParameterMetaData.getParameterType(int)
;
if pmdKnownBroken
is set to true, we won't even try it; if false, we'll try it,
and if it breaks, we'll remember not to use it again.public QueryRunner(DataSource ds)
DataSource
to use.
Methods that do not take a Connection
parameter will retrieve connections from this
DataSource
.ds
- The DataSource
to retrieve connections from.public QueryRunner(DataSource ds, boolean pmdKnownBroken)
DataSource
and controls the use of ParameterMetaData
.
Methods that do not take a Connection
parameter will retrieve connections from this
DataSource
.ds
- The DataSource
to retrieve connections from.pmdKnownBroken
- Some drivers don't support ParameterMetaData.getParameterType(int)
;
if pmdKnownBroken
is set to true, we won't even try it; if false, we'll try it,
and if it breaks, we'll remember not to use it again.public int[] batch(Connection conn, String sql, Object[][] params) throws SQLException
conn
- The Connection to use to run the query. The caller is
responsible for closing this Connection.sql
- The SQL to execute.params
- An array of query replacement parameters. Each row in
this array is one set of batch replacement values.SQLException
- if a database access error occurspublic int[] batch(String sql, Object[][] params) throws SQLException
Connection
is retrieved from the DataSource
set in the constructor. This Connection
must be in
auto-commit mode or the update will not be saved.sql
- The SQL to execute.params
- An array of query replacement parameters. Each row in
this array is one set of batch replacement values.SQLException
- if a database access error occurs@Deprecated public <T> T query(Connection conn, String sql, Object param, ResultSetHandler<T> rsh) throws SQLException
query(Connection, String, ResultSetHandler, Object...)
T
- The type of object that the handler returnsconn
- The connection to execute the query in.sql
- The query to execute.param
- The replacement parameter.rsh
- The handler that converts the results into an object.SQLException
- if a database access error occurs@Deprecated public <T> T query(Connection conn, String sql, Object[] params, ResultSetHandler<T> rsh) throws SQLException
query(Connection,String,ResultSetHandler,Object...)
insteadT
- The type of object that the handler returnsconn
- The connection to execute the query in.sql
- The query to execute.params
- The replacement parameters.rsh
- The handler that converts the results into an object.SQLException
- if a database access error occurspublic <T> T query(Connection conn, String sql, ResultSetHandler<T> rsh, Object... params) throws SQLException
T
- The type of object that the handler returnsconn
- The connection to execute the query in.sql
- The query to execute.rsh
- The handler that converts the results into an object.params
- The replacement parameters.SQLException
- if a database access error occurspublic <T> T query(Connection conn, String sql, ResultSetHandler<T> rsh) throws SQLException
T
- The type of object that the handler returnsconn
- The connection to execute the query in.sql
- The query to execute.rsh
- The handler that converts the results into an object.SQLException
- if a database access error occurs@Deprecated public <T> T query(String sql, Object param, ResultSetHandler<T> rsh) throws SQLException
query(String, ResultSetHandler, Object...)
Connection
is retrieved from the
DataSource
set in the constructor.T
- The type of object that the handler returnssql
- The SQL statement to execute.param
- The replacement parameter.rsh
- The handler used to create the result object from
the ResultSet
.SQLException
- if a database access error occurs@Deprecated public <T> T query(String sql, Object[] params, ResultSetHandler<T> rsh) throws SQLException
query(String, ResultSetHandler, Object...)
Connection
is retrieved from the
DataSource
set in the constructor.T
- The type of object that the handler returnssql
- The SQL statement to execute.params
- Initialize the PreparedStatement's IN parameters with
this array.rsh
- The handler used to create the result object from
the ResultSet
.SQLException
- if a database access error occurspublic <T> T query(String sql, ResultSetHandler<T> rsh, Object... params) throws SQLException
Connection
is retrieved from the
DataSource
set in the constructor.T
- The type of object that the handler returnssql
- The SQL statement to execute.rsh
- The handler used to create the result object from
the ResultSet
.params
- Initialize the PreparedStatement's IN parameters with
this array.SQLException
- if a database access error occurspublic <T> T query(String sql, ResultSetHandler<T> rsh) throws SQLException
Connection
is retrieved from the
DataSource
set in the constructor.T
- The type of object that the handler returnssql
- The SQL statement to execute.rsh
- The handler used to create the result object from
the ResultSet
.SQLException
- if a database access error occurspublic int update(Connection conn, String sql) throws SQLException
conn
- The connection to use to run the query.sql
- The SQL to execute.SQLException
- if a database access error occurspublic int update(Connection conn, String sql, Object param) throws SQLException
conn
- The connection to use to run the query.sql
- The SQL to execute.param
- The replacement parameter.SQLException
- if a database access error occurspublic int update(Connection conn, String sql, Object... params) throws SQLException
conn
- The connection to use to run the query.sql
- The SQL to execute.params
- The query replacement parameters.SQLException
- if a database access error occurspublic int update(String sql) throws SQLException
Connection
is retrieved
from the DataSource
set in the constructor. This
Connection
must be in auto-commit mode or the update will
not be saved.sql
- The SQL statement to execute.SQLException
- if a database access error occurspublic int update(String sql, Object param) throws SQLException
Connection
is
retrieved from the DataSource
set in the constructor.
This Connection
must be in auto-commit mode or the
update will not be saved.sql
- The SQL statement to execute.param
- The replacement parameter.SQLException
- if a database access error occurspublic int update(String sql, Object... params) throws SQLException
Connection
is retrieved from the DataSource
set in the constructor. This Connection
must be in
auto-commit mode or the update will not be saved.sql
- The SQL statement to execute.params
- Initializes the PreparedStatement's IN (i.e. '?')
parameters.SQLException
- if a database access error occursCopyright © 2002-2013 The Apache Software Foundation. All Rights Reserved.