QueryRunner的API

最新推荐文章于 2020-12-11 19:47:21 发布
最新推荐文章于 2020-12-11 19:47:21 发布
阅读量268 收藏 1
点赞数
文章标签： java 数据库
原文链接：http://www.cnblogs.com/TTTTT/p/5927747.html
版权
org.apache.commons.dbutils

Class QueryRunner

    • Constructor Detail

      • QueryRunner
        public QueryRunner()
        Constructor for QueryRunner.
      • QueryRunner
        public QueryRunner(boolean pmdKnownBroken)
        Constructor for QueryRunner that controls the use of  ParameterMetaData.
        Parameters:
        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.
      • QueryRunner
        public QueryRunner(DataSource ds)
        Constructor for QueryRunner that takes a  DataSource to use. Methods that do not take a  Connection parameter will retrieve connections from this  DataSource.
        Parameters:
        ds - The  DataSource to retrieve connections from.
      • QueryRunner
        public QueryRunner(DataSource ds,
           boolean pmdKnownBroken)
        Constructor for QueryRunner that takes a  DataSource and controls the use of  ParameterMetaData. Methods that do not take a  Connection parameter will retrieve connections from this  DataSource.
        Parameters:
        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.

    • 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. The  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.
        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
        @Deprecated
public <T> T query(Connection conn,
                     String sql,
                     Object param,
                     ResultSetHandler<T> rsh)
        throws SQLException
        Deprecated. Use query(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
        @Deprecated
public <T> T query(Connection conn,
                     String sql,
                     Object[] params,
                     ResultSetHandler<T> rsh)
        throws SQLException
        Deprecated. Use query(Connection,String,ResultSetHandler,Object...) instead
        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.
        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
        @Deprecated
public <T> T query(String sql,
                     Object param,
                     ResultSetHandler<T> rsh)
        throws SQLException
        Deprecated. Use query(String, ResultSetHandler, Object...)
        Executes the given SELECT SQL with a single replacement parameter. The  Connection is retrieved from the  DataSource 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 the  ResultSet.
        Returns:
        An object generated by the handler.
        Throws:
        SQLException - if a database access error occurs
      • query
        @Deprecated
public <T> T query(String sql,
                     Object[] params,
                     ResultSetHandler<T> rsh)
        throws SQLException
        Deprecated. Use query(String, ResultSetHandler, Object...)
        Executes the given SELECT SQL query and returns a result object. The  Connection is retrieved from the  DataSource 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 the  ResultSet.
        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. The  Connection is retrieved from the  DataSource 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 the  ResultSet.
        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. The  Connection is retrieved from the  DataSource 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 the  ResultSet.
        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. The  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.
        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. The  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.
        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. The  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.
        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. The  Connection is retrieved from the  DataSource 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 the  ResultSet 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. The  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.
        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 the  ResultSet 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 the  ResultSet 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 the  ResultSet 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. The  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.
        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 the  ResultSet 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 the  ResultSet 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

转载于:https://www.cnblogs.com/TTTTT/p/5927747.html

weixin_30566111
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Query Runner
03-18
QreryRunner类(org.apache.commons.dbutils.QueryRunner) 显著的简化了SQL查询，并与ResultSetHandler协同工作将使编码量大为减少。
DBUtils-对JDBC简单封装的开源工具类库
weixin_30501857的博客
11-01 110
DBUtils 是对JDBC简单封装的开源工具类 详细介绍地址： https://baike.baidu.com/item/Dbutils/10655914?fr=aladdin 在使用DBUtils工具类之前需要DBUtil jar包 登录官方网址 下载最新jar包和API 也可以直接点击 下载 解压下载的压缩包 主要用到 Quer...
[JavaWeb]DBUtils中的QueryRunner
zjkC050818的博客
06-09 533
QueryRunner类 QueryRunner中提供对sql语句操作的API 它主要有三个方法 　　query() 用于执行select 　　update() 用于执行insert/update/delete 　　batch() 批处理 public class JdbcUtil { /** * 去src目录下加载c3p0-config.xml配置文件 */ priv
DBUtils学习笔记
Switch的博客
10-01 3536
DBUtils学习笔记 基本介绍      Commons DbUtils是Apache组织提供的一个对JDBC进行简单封装的开源工具类库，使用它能够简化JDBC应用程序的开发，同时也不会影响程序的性能。      DBUtils是java编程中的数据库操作实用工具，小巧简单实用， 对于数据表的读操作，他可以把结果转换成List，Array，Set等java集合，便于程序员
JDBC QueryRunner（开源框架）之查询 详解
xiongfeng
10-17 8033
QueryRunner查询数据库& QueryRunner如何封装起来的 一、简单描述JDBC获取连接Connection后能做什么？ 首先 查看相关API(一).使用类和方法 QueryRunner（接口的方法如下两个）： update(connection,sql,object…objs) //进行增删改方法 query(connection,sql,ResultSetHandler,objec
QueryRunner常用方法
孔的博客
12-11 4427
maven依赖： <!-- https://mvnrepository.com/artifact/commons-dbutils/commons-dbutils --> <dependency> <groupId>commons-dbutils</groupId> <artifactId>commons-dbutils</artifactId> <version>1.6</version> </dep
QueryRunner使用
03-11
QueryRunner使ET ,为了帮助我们更高效的学习工作，从JDBC的繁重代码中解脱出来，详尽介绍了一个简化JDBC操作的组件——DBUtils
QueryRunner
11-22
QueryRunner 封装的一些方法 下载可使用
queryrunner的全部
03-20
DBUtils 使用： （1）copy jar包： （2）核心类： QueryRunner类： （3）使用核心类完成读写，以及批量操作：
springmvc+queryrunner自动生成
11-16
该工程是对jdbc的封装控制层使用springmvc持久层使用queryrunner
采用事务、c3p0连接池配置、DBUtiles中的QueryRunner结合
10-27
采用事务、c3p0连接池配置、DBUtiles中的QueryRunner结合作为mysql数据库的插入一条数据
Apache—DBUtils框架
Qiluluwawa的专栏
11-28 682
Apache—DBUtils框架 一、简介 1、commons-dbutils是 Apache 组织提供的一个开源 JDBC工具类库，它是对JDBC的简单封装，学习成本极低，并且使用dbutils能极大简化jdbc编码的工作量，同时也不会影响程序的性能。因此dbutils成为很多不喜欢hibernate的公司的首选。 2、 API介绍： （1）org.apache.commons.dbu
QueryRunner--常见方法
weixin_33681778的博客
04-21 1288
数据库链接池的使用，一方面解决了数据库访问过多时造成数据库承受的压力，另一方面也简化了数据查询，今天就 DBUtils包所提供的QueryRunner类(org.apache.commons.dbutils.QueryRunner)作出说明： 简化SQL查询 与ResultSetHandler协同工作将使编码量大为减少。 常见方法 query(Strin...
网络爬虫之java基础篇QueryRunner（Ⅲ）
qy20115549的博客
08-13 7206
目录1Java操作数据库 java操作数据库第一种方法 java操作数据库的QueryRunner方法1、Java操作数据库如何将爬虫爬取的数据存储下来也是我们关注的问题之前，常用的存储方式有.txt,mysql,hbase等。前面已经介绍了Java输入流输出流操作文本的方式，现在主要介绍几种Java操作mysql的方式。java操作数据库第一种方法这种方法，是操作数据库的最简单，也是最原始的方法。
1、DBUtils 2、连接池
weixin_33918114的博客
06-03 439
01DButils工具类的介绍个三个核心类 * A: DButils工具类的介绍个三个核心类 * a: 概述 * DBUtils是java编程中的数据库操作实用工具，小巧简单实用。 * DBUtils封装了对JDBC的操作，简化了JDBC操作，可以少写代码。 * DBUtils就是J...
使用DBUtils的QueryRunner类的query方法
dust_fall的博客
02-11 2872
使用DBUtils的QueryRunner类的query方法 最近在复习基础，今天在学习使用DBUtils的QueryRunner类时产生疑问，再次想起自己的博客太少了，所以又开始充数了。。哈哈 String sql = "select * from user"; try { // 执行 /** * 注意:这里传递第二个参数是new BeanHandler&lt;User&gt;(...
DBUtils学习----QueryRunner类
晚晴小筑
08-18 9593
QueryRunner 使用可插拔的策略执行SQL查询，并处理 ResultSet结果集 package org.apache.commons.dbutils;import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
QueryRunner中query方法
热门推荐
热爱生活 热爱编码
07-17 2万+
commons.dbutils.QueryRunner query方法中RequestSetHandler 参数对应的返回类型： AbstractListHandler -- 返回多行List的抽象类 ArrayHandler -- 返回一行的Object[] ArrayListHandler -- 返回List，每行是Object[] BeanHandler -- 返回第一个Be...
QueryRunner 小结
兔的骄傲
08-03 1589
方法： 1.query：一般情况多用于查询。（返回值类型根据需求自己定义实现类） 2.insert：一般不常用，多用于返回结果集对象需要Id。 3.update：被用来执行插入、更新、或者删除（通常结果是返回操作受影响的记录条数）。 实现类： 1.ArrayHandler：把结果集中的第一行数据转成对象数组。 2.ArrayListHandler：把结果集中的每一行数据都转成一个对象数组...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值