德鲁伊数据连接池

druid.properties配置文件

# key = value
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/db02?rewriteBatchedStatements=true
username=root_db02
password=root_db02
# 初始连接大小
initialSize=10
# 最小空闲连接大小
minIdle=5
# 最大活动连接大小
maxActive=50
# 最大等待时间（5000ms）
maxWait=5000

pom.xml|druid-jar包

        <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.9</version>
</dependency>

DruidUtils类

package com.data_source.utils;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 * Created by Lenovo on 2022-05-16-下午 8:43.
 *
 * @author 小象
 * @version 1.0
 */
public class DruidUtils {

    private static final DataSource dataSource;

    static {
        try {
            // 加载配置文件
            Properties properties = new Properties();
            properties.load(new FileReader("G:\\Xx-hH\\TechnicalArea\\WebBackEnd\\Java\\JavaSE\\Phase_II\\chapter25\\src\\druid.properties"));
            // 创建 druid 数据库连接池
            dataSource = DruidDataSourceFactory.createDataSource(properties);
        } catch (Exception e) {
            throw new RuntimeException(e);
        }
    }

    /**
     * <h3>建立连接</h3>
     */
    public static Connection getConnection() throws SQLException {
        return dataSource.getConnection();
    }

    /**
     * <h3>关闭资源</h3>
     * 在数据库连接池技术中，close 不是真的断掉连接而是把使用的 Connection 对象放回连接池
     */
    @SuppressWarnings("DuplicatedCode")
    public static void close(ResultSet resultSet, Statement statement, Connection connection) {
        try {
            if (resultSet != null) {
                resultSet.close();
            }
            if (statement != null) {
                statement.close();
            }
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

}

DruidUtilsUse类

package com.data_source.utils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * Created by Lenovo on 2022-05-16-下午 8:55.
 *
 * @author 小象
 * @version 1.0
 */
public class DruidUtilsUse {

    /**
     * <h2>封装德鲁伊Utils</h2>
     *
     * @param args 形参数组
     */
    public static void main(String[] args) {

        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;

        // sql语句
        String selectSql = "select * from admin where name = ?";

        try {
            // 获取连接
            connection = DruidUtils.getConnection();
            // 预处理sql
            preparedStatement = connection.prepareStatement(selectSql);
            // 执行sql
            preparedStatement.setString(1, "fx");
            resultSet = preparedStatement.executeQuery();
            // 打印查询结果
            while (resultSet.next()) {
                String name = resultSet.getString("name");
                String pwd = resultSet.getString("pwd");
                System.out.println(name + "\t" + pwd);
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        } finally {
            // 关闭资源
            DruidUtils.close(resultSet, preparedStatement, connection);
        }
    }

}