java——数据库连接池——druid_基本使用

阳光穿透心脏的1/2处 2024-03-31 11:59 21阅读 0赞

![1553ad522ea6df9dc87346685e1011f3.png][]

5. Druid：数据库连接池实现技术，由阿里巴巴提供的
            1. 步骤：
                1. 导入jar包 druid-1.0.9.jar
                2. 定义配置文件：
                    * 是properties形式的
                    * 可以叫任意名称，可以放在任意目录下
                3. 加载配置文件。Properties
                4. 获取数据库连接池对象：通过工厂来来获取  DruidDataSourceFactory
                5. 获取连接：getConnection
            * 代码：
                 //3.加载配置文件
                Properties pro = new Properties();
                InputStream is = DruidDemo.class.getClassLoader().getResourceAsStream("druid.properties");
                pro.load(is);
                //4.获取连接池对象
                DataSource ds = DruidDataSourceFactory.createDataSource(pro);
                //5.获取连接
                Connection conn = ds.getConnection();

![d3d9fd4e076a70a7ae60e7de33177a6b.png][]

![553f3af60e561c3b75739bc136551d64.png][]

2. 定义工具类
                1. 定义一个类 JDBCUtils
                2. 提供静态代码块加载配置文件，初始化连接池对象
                3. 提供方法
                    1. 获取连接方法：通过数据库连接池获取连接
                    2. 释放资源
                    3. 获取连接池的方法

* 代码：
                public class JDBCUtils {
    
                    //1.定义成员变量 DataSource
                    private static DataSource ds ;
                
                    static{
                        try {
                            //1.加载配置文件
                            Properties pro = new Properties();
                            pro.load(JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
                            //2.获取DataSource
                            ds = DruidDataSourceFactory.createDataSource(pro);
                        } catch (IOException e) {
                            e.printStackTrace();
                        } catch (Exception e) {
                            e.printStackTrace();
                        }
                    }
                
                    /**
                     * 获取连接
                     */
                    public static Connection getConnection() throws SQLException {
                        return ds.getConnection();
                    }
                
                    /**
                     * 释放资源
                     */
                    public static void close(Statement stmt,Connection conn){
                       /* if(stmt != null){
                            try {
                                stmt.close();
                            } catch (SQLException e) {
                                e.printStackTrace();
                            }
                        }
                
                        if(conn != null){
                            try {
                                conn.close();//归还连接
                            } catch (SQLException e) {
                                e.printStackTrace();
                            }
                        }*/
                
                       close(null,stmt,conn);
                    }
                
                
                    public static void close(ResultSet rs , Statement stmt, Connection conn){
                
                
                        if(rs != null){
                            try {
                                rs.close();
                            } catch (SQLException e) {
                                e.printStackTrace();
                            }
                        }
                
                
                        if(stmt != null){
                            try {
                                stmt.close();
                            } catch (SQLException e) {
                                e.printStackTrace();
                            }
                        }
                
                        if(conn != null){
                            try {
                                conn.close();//归还连接
                            } catch (SQLException e) {
                                e.printStackTrace();
                            }
                        }
                    }
                
                    /**
                     * 获取连接池方法
                     */
                
                    public static DataSource getDataSource(){
                        return  ds;
                    }
                
                }

![24a2f5487706b67742033f444d34b91c.png][]

![45a714954b644f0fe94559c0559b5464.png][]

![f9217be61555cddd43a1411867a27de5.png][]

![2d4807825423e574c74d2beb08721db1.png][]

![7b2d53c6436d8c512fccc7f2fdf67977.png][]

![58dab38f4705b486bbad18c319371e4b.png][]

![c7c2a93e0499ededf4698f7f791ed2d4.png][]

[1553ad522ea6df9dc87346685e1011f3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/e8ede91a0e5f402eac8aafe962dfd452.png
[d3d9fd4e076a70a7ae60e7de33177a6b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/9b2146081fe74ccb98a23a9af5dc35e5.png
[553f3af60e561c3b75739bc136551d64.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/11bcd24606ea49eca0f87005648fad43.png
[24a2f5487706b67742033f444d34b91c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/0b826d7aef4548d0a835d2f2d6f77446.png
[45a714954b644f0fe94559c0559b5464.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/c93404111c7849ab86a7e5e242d815e8.png
[f9217be61555cddd43a1411867a27de5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/f5f649a45f2b4f2f91b1f46d85d7bb7c.png
[2d4807825423e574c74d2beb08721db1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/a14fe64a8339445a90d3d79e5b50aa0e.png
[7b2d53c6436d8c512fccc7f2fdf67977.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/f7fc3d040ab14222b96c2f6f18572260.png
[58dab38f4705b486bbad18c319371e4b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/3866c78c9fbe4831b12f91f9b1ccfc44.png
[c7c2a93e0499ededf4698f7f791ed2d4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/4f4c7d469f064de8aebf1600d9b9246e.png