JDBC通过DBUtils提供的jar包实现CRUD操作

导入jar包：

使用现成的jar中的QueryRunner测试增、删、改的操作:

package COM.XZH.JDBC;
import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.junit.Test;
import java.sql.Connection;


/**
 * 使用Druid数据库连接池技术
 * 用QueryRunner实现数据库修改
 */

public class ChangeDB{
    @Test
    public void getConnection() throws Exception {
        //用Druid方式获取链接  可写在另外的函数里
        //DruidConnection类详见下面连接文章
        //https://blog.csdn.net/qq_42923605/article/details/115326619
        Connection conn=DruidConnection.getConnection3();

        //这里单纯实现的是添加  如有其他增删改操作 替换sql语句就可以
        QueryRunner runner = new QueryRunner();
        String sql = "insert into customers(name,email,birth)values(?,?,?)";
        int insertCount = runner.update(conn, sql, "蔡徐坤","caixukun@126.com","1997-09-08");
        System.out.println("添加了" + insertCount + "条记录");


        //关闭链接
        DbUtils.closeQuietly(conn);
    }
}

使用现成的jar中的QueryRunner测试查询的操作:

package COM.XZH.JDBC;

import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ScalarHandler;
import org.junit.Test;
import java.sql.Connection;
import java.sql.Date;


/**
 * 使用Druid数据库连接池技术
 * 用QueryRunner实现数据库查询
 */

public class SqlectDB {
    /*
     * ScalarHandler:用于查询特殊值
     */
    @Test
    public void testQuery5(){
        Connection conn = null;
        try {
            conn=DruidConnection.getConnection3();

            String sql = "select count(*) from customers";

            ScalarHandler handler = new ScalarHandler();
            QueryRunner runner = new QueryRunner();

            Long count = (Long) runner.query(conn, sql,handler);
            System.out.println(count);
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            DbUtils.closeQuietly(conn);

        }

    }
    @Test
    public void testQuery6(){
        Connection conn = null;
        try {

           //用Druid方式获取链接
        //DruidConnection类详见下面连接文章
        //https://blog.csdn.net/qq_42923605/article/details/115326619
            conn=DruidConnection.getConnection3();

            QueryRunner runner = new QueryRunner();
            String sql = "select max(birth) from customers";

            ScalarHandler handler = new ScalarHandler();
            Date maxBirth = (Date) runner.query(conn, sql, handler);
            System.out.println(maxBirth);
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            DbUtils.closeQuietly(conn);

        }

    }
}

使用dbutils.jar包中的DbUtils工具类实现连接等资源的关闭：

//导入import org.apache.commons.dbutils.DbUtils;
//调用
DbUtils.closeQuietly(conn);
DbUtils.closeQuietly(ps);
DbUtils.closeQuietly(conn);