JDBC Druid数据库连接池

Druid数据库连接池

public class DruidTest {
    @Test
    public void getConnection() throws Exception{
        Properties pros = new Properties();
        InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
        pros.load(is);
        DataSource source = DruidDataSourceFactory.createDataSource(pros);
        Connection conn = source.getConnection();
        System.out.println(conn);
    }
}
//输出
十二月 23, 2019 4:18:00 下午 com.alibaba.druid.pool.DruidDataSource info
信息: {dataSource-1} inited
com.mysql.jdbc.JDBC4Connection@5dfcfece

使用Druid数据库连接池技术

public class JDBCUtils {
    /**
    * @Description: 使用Druid的数据库连接池技术
    * @Param: 
    * @return: 
    * @Author: fish
    * @Date: 4:22 PM 2019/12/23
    */ 
    //创建一个Druid数据库连接池
    private static DataSource source0;
    static{
       try {
           Properties pros = new Properties();
           InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
           pros.load(is);
           source0 = DruidDataSourceFactory.createDataSource(pros);
       }catch (Exception e){
           e.printStackTrace();
       }
    }
    public static Connection getConnection3() throws Exception{
        Connection conn = source0.getConnection();
        return conn;
    }
}
    @Test
    public void getCustomerById(){
        Connection conn = null;
        try{
            conn = JDBCUtils.getConnection3();
            Customer customer = dao.getCustomerById(conn,8);
            System.out.println(customer);
            System.out.println("查询成功");
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            JDBCUtils.closeResource(conn,null);
        }
    }
//输出
十二月 23, 2019 4:18:00 下午 com.alibaba.druid.pool.DruidDataSource info
信息: {dataSource-1} inited
com.mysql.jdbc.JDBC4Connection@5dfcfece