资源池的创建过程，三种方式 mysql、java、idea、properties、druid

1.连接池

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-qbDlgLSp-1637726169320)(C:\Users\忠你\AppData\Roaming\Typora\typora-user-images\image-20211124110429026.png)]

1.导入架包

druid-1.0.9.jar

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-UTcxcaJt-1637726169323)(C:\Users\忠你\AppData\Roaming\Typora\typora-user-images\image-20211124114920308.png)]

2.编写jdbcUtils.java

public static void main(String[] args) throws Exception {
   
queryMore("select * from t_emps");
    }

    public static void queryMore(String sql) throws Exception {
   

        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bailiban", "root", "123456");

        Statement stat = conn.createStatement();

        ResultSet query = stat.executeQuery(sql);

        ArrayList<Emps> list = new ArrayList<>();

        while (query.next()){
   
            String id = query.getString("id");
            String name = query.getString("name");
            String sex = query.getString("sex");
            Date birth = query.getDate("birth");
            double salary = query.getDouble("salary");
            int deptId = query.getInt("deptId");

            Emps emps = new Emps(id, name