首页 > 代码库 > QueryRunner的API
QueryRunner的API
org.apache.commons.dbutils
Class QueryRunner
- java.lang.Object
- org.apache.commons.dbutils.AbstractQueryRunner
- org.apache.commons.dbutils.QueryRunner
public class QueryRunnerextends AbstractQueryRunner
Executes SQL queries with pluggable strategies for handlingResultSet
s. This class is thread safe.- See Also:
ResultSetHandler
Field Summary
Fields inherited from class org.apache.commons.dbutils.AbstractQueryRunner
ds
Constructor Summary
Constructors Constructor and Description QueryRunner()
Constructor for QueryRunner.QueryRunner(boolean pmdKnownBroken)
Constructor for QueryRunner that controls the use ofParameterMetaData
.QueryRunner(DataSource ds)
Constructor for QueryRunner that takes aDataSource
to use.QueryRunner(DataSource ds, boolean pmdKnownBroken)
Constructor for QueryRunner that takes aDataSource
and controls the use ofParameterMetaData
.
Method Summary
Methods 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.Usequery(Connection,String,ResultSetHandler,Object...)
instead<T> T
query(Connection conn, String sql, Object param, ResultSetHandler<T> rsh)
Deprecated.Usequery(Connection, String, ResultSetHandler, Object...)
<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.Usequery(String, ResultSetHandler, Object...)
<T> T
query(String sql, Object param, ResultSetHandler<T> rsh)
Deprecated.Usequery(String, ResultSetHandler, Object...)
<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.Methods inherited from class org.apache.commons.dbutils.AbstractQueryRunner
close, close, close, fillStatement, fillStatementWithBean, fillStatementWithBean, getDataSource, isPmdKnownBroken, prepareConnection, prepareStatement, prepareStatement, rethrow, wrap
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Constructor Detail
QueryRunner
public QueryRunner()
Constructor for QueryRunner.
QueryRunner
public QueryRunner(boolean pmdKnownBroken)
Constructor for QueryRunner that controls the use ofParameterMetaData
.- Parameters:
pmdKnownBroken
- Some drivers don‘t supportParameterMetaData.getParameterType(int)
; ifpmdKnownBroken
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.
QueryRunner
public QueryRunner(DataSource ds)
Constructor for QueryRunner that takes aDataSource
to use. Methods that do not take aConnection
parameter will retrieve connections from thisDataSource
.- Parameters:
ds
- TheDataSource
to retrieve connections from.
QueryRunner
public QueryRunner(DataSource ds, boolean pmdKnownBroken)
Constructor for QueryRunner that takes aDataSource
and controls the use ofParameterMetaData
. Methods that do not take aConnection
parameter will retrieve connections from thisDataSource
.- Parameters:
ds
- TheDataSource
to retrieve connections from.pmdKnownBroken
- Some drivers don‘t supportParameterMetaData.getParameterType(int)
; ifpmdKnownBroken
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.
Method Detail
batch
public int[] batch(Connection conn, String sql, Object[][] params) throws SQLException
Execute a batch of SQL INSERT, UPDATE, or DELETE queries.- Parameters:
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.- Returns:
- The number of rows updated per statement.
- Throws:
SQLException
- if a database access error occurs- Since:
- DbUtils 1.1
batch
public int[] batch(String sql, Object[][] params) throws SQLException
Execute a batch of SQL INSERT, UPDATE, or DELETE queries. TheConnection
is retrieved from theDataSource
set in the constructor. ThisConnection
must be in auto-commit mode or the update will not be saved.- Parameters:
sql
- The SQL to execute.params
- An array of query replacement parameters. Each row in this array is one set of batch replacement values.- Returns:
- The number of rows updated per statement.
- Throws:
SQLException
- if a database access error occurs- Since:
- DbUtils 1.1
query
@Deprecatedpublic <T> T query(Connection conn, String sql, Object param, ResultSetHandler<T> rsh) throws SQLException
Deprecated. Usequery(Connection, String, ResultSetHandler, Object...)
Execute an SQL SELECT query with a single replacement parameter. The caller is responsible for closing the connection.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
conn
- 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.- Returns:
- The object returned by the handler.
- Throws:
SQLException
- if a database access error occurs
query
@Deprecatedpublic <T> T query(Connection conn, String sql, Object[] params, ResultSetHandler<T> rsh) throws SQLException
Deprecated. Usequery(Connection,String,ResultSetHandler,Object...)
insteadExecute an SQL SELECT query with replacement parameters. The caller is responsible for closing the connection.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
conn
- 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.- Returns:
- The object returned by the handler.
- Throws:
SQLException
- if a database access error occurs
query
public <T> T query(Connection conn, String sql, ResultSetHandler<T> rsh, Object... params) throws SQLException
Execute an SQL SELECT query with replacement parameters. The caller is responsible for closing the connection.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
conn
- 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.- Returns:
- The object returned by the handler.
- Throws:
SQLException
- if a database access error occurs
query
public <T> T query(Connection conn, String sql, ResultSetHandler<T> rsh) throws SQLException
Execute an SQL SELECT query without any replacement parameters. The caller is responsible for closing the connection.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
conn
- The connection to execute the query in.sql
- The query to execute.rsh
- The handler that converts the results into an object.- Returns:
- The object returned by the handler.
- Throws:
SQLException
- if a database access error occurs
query
@Deprecatedpublic <T> T query(String sql, Object param, ResultSetHandler<T> rsh) throws SQLException
Deprecated. Usequery(String, ResultSetHandler, Object...)
Executes the given SELECT SQL with a single replacement parameter. TheConnection
is retrieved from theDataSource
set in the constructor.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
sql
- The SQL statement to execute.param
- The replacement parameter.rsh
- The handler used to create the result object from theResultSet
.- Returns:
- An object generated by the handler.
- Throws:
SQLException
- if a database access error occurs
query
@Deprecatedpublic <T> T query(String sql, Object[] params, ResultSetHandler<T> rsh) throws SQLException
Deprecated. Usequery(String, ResultSetHandler, Object...)
Executes the given SELECT SQL query and returns a result object. TheConnection
is retrieved from theDataSource
set in the constructor.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
sql
- 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 theResultSet
.- Returns:
- An object generated by the handler.
- Throws:
SQLException
- if a database access error occurs
query
public <T> T query(String sql, ResultSetHandler<T> rsh, Object... params) throws SQLException
Executes the given SELECT SQL query and returns a result object. TheConnection
is retrieved from theDataSource
set in the constructor.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
sql
- The SQL statement to execute.rsh
- The handler used to create the result object from theResultSet
.params
- Initialize the PreparedStatement‘s IN parameters with this array.- Returns:
- An object generated by the handler.
- Throws:
SQLException
- if a database access error occurs
query
public <T> T query(String sql, ResultSetHandler<T> rsh) throws SQLException
Executes the given SELECT SQL without any replacement parameters. TheConnection
is retrieved from theDataSource
set in the constructor.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
sql
- The SQL statement to execute.rsh
- The handler used to create the result object from theResultSet
.- Returns:
- An object generated by the handler.
- Throws:
SQLException
- if a database access error occurs
update
public int update(Connection conn, String sql) throws SQLException
Execute an SQL INSERT, UPDATE, or DELETE query without replacement parameters.- Parameters:
conn
- The connection to use to run the query.sql
- The SQL to execute.- Returns:
- The number of rows updated.
- Throws:
SQLException
- if a database access error occurs
update
public int update(Connection conn, String sql, Object param) throws SQLException
Execute an SQL INSERT, UPDATE, or DELETE query with a single replacement parameter.- Parameters:
conn
- The connection to use to run the query.sql
- The SQL to execute.param
- The replacement parameter.- Returns:
- The number of rows updated.
- Throws:
SQLException
- if a database access error occurs
update
public int update(Connection conn, String sql, Object... params) throws SQLException
Execute an SQL INSERT, UPDATE, or DELETE query.- Parameters:
conn
- The connection to use to run the query.sql
- The SQL to execute.params
- The query replacement parameters.- Returns:
- The number of rows updated.
- Throws:
SQLException
- if a database access error occurs
update
public int update(String sql) throws SQLException
Executes the given INSERT, UPDATE, or DELETE SQL statement without any replacement parameters. TheConnection
is retrieved from theDataSource
set in the constructor. ThisConnection
must be in auto-commit mode or the update will not be saved.- Parameters:
sql
- The SQL statement to execute.- Returns:
- The number of rows updated.
- Throws:
SQLException
- if a database access error occurs
update
public int update(String sql, Object param) throws SQLException
Executes the given INSERT, UPDATE, or DELETE SQL statement with a single replacement parameter. TheConnection
is retrieved from theDataSource
set in the constructor. ThisConnection
must be in auto-commit mode or the update will not be saved.- Parameters:
sql
- The SQL statement to execute.param
- The replacement parameter.- Returns:
- The number of rows updated.
- Throws:
SQLException
- if a database access error occurs
update
public int update(String sql, Object... params) throws SQLException
Executes the given INSERT, UPDATE, or DELETE SQL statement. TheConnection
is retrieved from theDataSource
set in the constructor. ThisConnection
must be in auto-commit mode or the update will not be saved.- Parameters:
sql
- The SQL statement to execute.params
- Initializes the PreparedStatement‘s IN (i.e. ‘?‘) parameters.- Returns:
- The number of rows updated.
- Throws:
SQLException
- if a database access error occurs
insert
public <T> T insert(String sql, ResultSetHandler<T> rsh) throws SQLException
Executes the given INSERT SQL without any replacement parameters. TheConnection
is retrieved from theDataSource
set in the constructor.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
sql
- The SQL statement to execute.rsh
- The handler used to create the result object from theResultSet
of auto-generated keys.- Returns:
- An object generated by the handler.
- Throws:
SQLException
- if a database access error occurs- Since:
- 1.6
insert
public <T> T insert(String sql, ResultSetHandler<T> rsh, Object... params) throws SQLException
Executes the given INSERT SQL statement. TheConnection
is retrieved from theDataSource
set in the constructor. ThisConnection
must be in auto-commit mode or the insert will not be saved.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
sql
- The SQL statement to execute.rsh
- The handler used to create the result object from theResultSet
of auto-generated keys.params
- Initializes the PreparedStatement‘s IN (i.e. ‘?‘)- Returns:
- An object generated by the handler.
- Throws:
SQLException
- if a database access error occurs- Since:
- 1.6
insert
public <T> T insert(Connection conn, String sql, ResultSetHandler<T> rsh) throws SQLException
Execute an SQL INSERT query without replacement parameters.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
conn
- The connection to use to run the query.sql
- The SQL to execute.rsh
- The handler used to create the result object from theResultSet
of auto-generated keys.- Returns:
- An object generated by the handler.
- Throws:
SQLException
- if a database access error occurs- Since:
- 1.6
insert
public <T> T insert(Connection conn, String sql, ResultSetHandler<T> rsh, Object... params) throws SQLException
Execute an SQL INSERT query.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
conn
- The connection to use to run the query.sql
- The SQL to execute.rsh
- The handler used to create the result object from theResultSet
of auto-generated keys.params
- The query replacement parameters.- Returns:
- An object generated by the handler.
- Throws:
SQLException
- if a database access error occurs- Since:
- 1.6
insertBatch
public <T> T insertBatch(String sql, ResultSetHandler<T> rsh, Object[][] params) throws SQLException
Executes the given batch of INSERT SQL statements. TheConnection
is retrieved from theDataSource
set in the constructor. ThisConnection
must be in auto-commit mode or the insert will not be saved.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
sql
- The SQL statement to execute.rsh
- The handler used to create the result object from theResultSet
of auto-generated keys.params
- Initializes the PreparedStatement‘s IN (i.e. ‘?‘)- Returns:
- The result generated by the handler.
- Throws:
SQLException
- if a database access error occurs- Since:
- 1.6
insertBatch
public <T> T insertBatch(Connection conn, String sql, ResultSetHandler<T> rsh, Object[][] params) throws SQLException
Executes the given batch of INSERT SQL statements.- Type Parameters:
T
- The type of object that the handler returns- Parameters:
conn
- The connection to use to run the query.sql
- The SQL to execute.rsh
- The handler used to create the result object from theResultSet
of auto-generated keys.params
- The query replacement parameters.- Returns:
- The result generated by the handler.
- Throws:
SQLException
- if a database access error occurs- Since:
- 1.6
QueryRunner的API
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。