public class QueryRunner extends AbstractQueryRunner
ResultSets. This class is thread safe.ResultSetHandlerds| 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 |
insert(Connection conn, String sql, ResultSetHandler<T> rsh)
Execute an SQL INSERT query without replacement parameters.
|
<T> T |
insert(Connection conn, String sql, ResultSetHandler<T> rsh, Object... params)
Execute an SQL INSERT query.
|
<T> T |
insert(String sql, ResultSetHandler<T> rsh)
Executes the given INSERT SQL without any replacement parameters.
|
<T> T |
insert(String sql, ResultSetHandler<T> rsh, Object... params)
Executes the given INSERT SQL statement.
|
<T> T |
insertBatch(Connection conn, String sql, ResultSetHandler<T> rsh, Object[][] params)
Executes the given batch of INSERT SQL statements.
|
<T> T |
insertBatch(String sql, ResultSetHandler<T> rsh, Object[][] params)
Executes the given batch of INSERT SQL statements.
|
<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, prepareStatement, rethrow, wrappublic 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 occurspublic <T> T insert(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 of auto-generated keys.SQLException - if a database access error occurspublic <T> T insert(String sql, ResultSetHandler<T> rsh, Object... params) throws SQLException
Connection is retrieved from the DataSource set in the constructor. This Connection must be in auto-commit mode or the insert will not be saved.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 of auto-generated keys.params - Initializes the PreparedStatement‘s IN (i.e. ‘?‘)SQLException - if a database access error occurspublic <T> T insert(Connection conn, String sql, ResultSetHandler<T> rsh) throws SQLException
T - The type of object that the handler returnsconn - The connection to use to run the query.sql - The SQL to execute.rsh - The handler used to create the result object from the ResultSet of auto-generated keys.SQLException - if a database access error occurspublic <T> T insert(Connection conn, String sql, ResultSetHandler<T> rsh, Object... params) throws SQLException
T - The type of object that the handler returnsconn - The connection to use to run the query.sql - The SQL to execute.rsh - The handler used to create the result object from the ResultSet of auto-generated keys.params - The query replacement parameters.SQLException - if a database access error occurspublic <T> T insertBatch(String sql, ResultSetHandler<T> rsh, Object[][] params) throws SQLException
Connection is retrieved from the DataSource set in the constructor. This Connection must be in auto-commit mode or the insert will not be saved.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 of auto-generated keys.params - Initializes the PreparedStatement‘s IN (i.e. ‘?‘)SQLException - if a database access error occurspublic <T> T insertBatch(Connection conn, String sql, ResultSetHandler<T> rsh, Object[][] params) throws SQLException
T - The type of object that the handler returnsconn - The connection to use to run the query.sql - The SQL to execute.rsh - The handler used to create the result object from the ResultSet of auto-generated keys.params - The query replacement parameters.SQLException - if a database access error occurs原文：http://www.cnblogs.com/TTTTT/p/5927747.html