JAVAWeb连接数据库

driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis//数据库库名
username=root
password=123456

initialSize=0
maxTotal=20
maxIdle=8
minIdle=0
maxWaitMillis=-1

package cn.kgc.util;

import org.apache.commons.dbcp2.BasicDataSourceFactory;

import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

public class Dbcp2Utils {
    private static Properties properties;
    private static DataSource dataSource;
    static{
        String configFile = "db.properties";
        InputStream in = Dbcp2Utils.class.getClassLoader().getResourceAsStream(configFile);
        properties = new Properties();
        try {
            properties.load(in);
            //获取连接池
            dataSource = BasicDataSourceFactory.createDataSource(properties);
        } catch (IOException e) {
            throw new RuntimeException(e);
        } catch (Exception e) {
            throw new RuntimeException(e);
        }
    }

    //提供一个获取连接的方法
    public static Connection getConnection(){
        try {
            return dataSource.getConnection();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}