数据库连接池------druid

数据库连接池------druid

1.将jar包导入lib文件

 

 

 

测试连接的代码：

/**
     * 使用Druid数据库连接池技术
     */
    private static DataSource source1;
    static{
        try {
            Properties pros = new Properties();
            
            InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
            
            pros.load(is);
            
            source1 = DruidDataSourceFactory.createDataSource(pros);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection3() throws SQLException{
        
        Connection conn = source1.getConnection();
        return conn;
    }

其中，配置文件定义在src下：druid.properties

url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF8";
username=root
password=12345
driverClassName=com.mysql.jdbc.Driver