java--数据库连接池

1、导入druid的jar包

2、设置配置文件

3、创建连接

package com.ruqi.druidtest;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import org.junit.Test;
import javax.sql.DataSource;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;

public class ConnectDruid {
    @Test
    public void connection() throws Exception {
        InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.propries");
        Properties pros = new Properties();
        pros.load(is);
        DataSource source = DruidDataSourceFactory.createDataSource(pros);
        Connection conn = source.getConnection();
        System.out.println(conn);
    }
}


/**
配置文件信息
url=jdbc:mysql:///test1111111?rewriteBatchedstatements=true
username=gac_travel_dev
password=gac@6666
driverClassName=com.mysql.jdbc.Driver
initialSize=10
maxActive=20
*/