数据库连接池
database connection pool
先创建连接试一下
public static void main(String[] args) throws Exception {
//加载驱动类
String className = "com.mysql.jdbc.Driver";
//地址
String url = "jdbc:mysql://localhost:3306/abc?useSSL=false&rewriteBatchedStatements=true";
//账号和密码
String username = "root";
String password = "123";
//第一种办法
BasicDataSource source = BasicDataSourceFactory.createDataSource(new Properties());
//第二种办法
BasicDataSource source = new BasicDataSource();
source.setDriverClassName(className);
source.setUrl(url);
source.setUsername(username);
source.setPassword(password);
source.setMaxTotal(20);
source.setMinIdle(3);
source.setMaxWaitMillis(1000);
Connection connection = source.getConnection();
System.out.println(connection.getClass().getName());
}
连接池内部使用四个参数
创建连接对象
也就是mysql驱动提供的connection