构建JDBC的连接池Pool

最新推荐文章于 2023-12-18 18:23:41 发布

VIP文章正在成为地中海会员的Mark先生

最新推荐文章于 2023-12-18 18:23:41 发布

阅读量229

点赞数

文章标签： java servlet

本文链接：https://blog.csdn.net/m0_72761098/article/details/126890933

版权

首先创建一个配置文件driver.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mydemo
username=root
password=password
init=10
maxsize=20
maxwait=500
validationQuery=select 1

public class NormalLinkedPool {
    public static Connection getConnection() {
        return Pool.getConnection();
    }

    public static void destory(Connection connection) {
        Pool.destoryConnection(connection);
    }

    private static class Pool {
        private static String DRIVER;
        private static String URL;
        private static String USERNAME;
        private static String PASSWORD;
        private static int INIT;
        private static int MAXSIZE;
        private static Long MAXWAIT;
        private static String VALIDATIONQUERY;
        //创建连接创建对象
        private static List<ConnectionEntity> pools = new ArrayList<>();

        static {