Druid数据库连接池

package 数据库连接池;


import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.File;
import java.io.FileInputStream;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

/**
 * 使用德鲁伊数据库连接池
 * @author coffee
 * @date 2021-02-28 12:16
 */
public class DruidTest {

    private static DataSource Source;
    static {
        Properties pros = new Properties();

        try {
            pros.load(new FileInputStream(new File("E:\\idea-workspace\\JDBC\\JDBC练习\\src\\Druid.properties")));
            Source = DruidDataSourceFactory.createDataSource(pros);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection() throws SQLException {

        return Source.getConnection();

    }
}

Druid.properties

url=jdbc:mysql:///test
username=root
password=soulxl
driverClassName=com.mysql.cj.jdbc.Driver

initialSize=10
maxActive=10