Druid数据库连接池技术实现

---

Druid数据库连接池技术实现

---

驱动下载地址提取码qz0p
创建配置文件druid.properties

url=jdbc:mysql:///test
username=root
password=root
driverClassName=com.mysql.jdbc.Driver
initialSize=10
maxActive=10

添加JDBCUtils

import java.io.InputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.commons.dbutils.DbUtils;
import com.alibaba.druid.pool.DruidDataSourceFactory;

public class JDBCUtils {
	/**
	 * 使用Druid数据库连接池技术
	 */
	private static DataSource source;
	static{
		try {
			Properties pros = new Properties();
			InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
			pros.load(is);
			source = DruidDataSourceFactory.createDataSource(pros);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public static Connection getDruidConnection() throws SQLException{
		Connection conn = source.getConnection();
		return conn;
	}
	/**
	 * 
	 * 使用dbutils.jar中提供的DbUtils工具类，实现资源的关闭
	 */
	public static void closeResource(Connection conn,Statement ps,ResultSet rs){
		DbUtils.closeQuietly(conn);
		DbUtils.closeQuietly(ps);
		DbUtils.closeQuietly(rs);
	}
}

然后通过创建dbutil包下的QueryRunner对象的query方法以及BeanListHandler对象实现单条或多条数据的查询操作
例如:

public void queryTest() throws SQLException {
        Connection conn = null;
        QueryRunner queryRunner = null;
        String sql = null;
        try {
            conn = JDBCUtils.getDruidConnection();
            queryRunner = new QueryRunner();
            sql = "select * from customers where id = ?";
            BeanListHandler<Customer> customerBeanHandler = new BeanListHandler<Customer>(Customer.class);
            List<Customer> customer = queryRunner.query(conn, sql, customerBeanHandler,19);
            customer.forEach(System.out::println);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            JDBCUtils.closeResource(conn,null,null);
        }
    }

同理,可通过update方法实现增删改操作

 public void insertTest(){
        Connection conn = null;
        QueryRunner queryRunner = null;
        String sql = null;
        try {
            conn = JDBCUtils.getDruidConnection();
            queryRunner = new QueryRunner();
            sql = "insert into customers(name,email,birth)values(?,?,?)";
            queryRunner.update(conn,sql,"奥迪A7","AidiA7@AODI.com","2021-7-7");
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {
            JDBCUtils.closeResource(conn,null,null);
        }
    }