Druid的数据库连接池技术，两种方式

package com3connection;

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

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSource;
import org.junit.Test;

import com.alibaba.druid.pool.DruidDataSourceFactory;

public class DruidTest {
	//方式一
	@Test
	public void getConnection1() throws SQLException{
		//1、创建连接池
		BasicDataSource source=new BasicDataSource();
		//2、配置连接信息
		source.setUrl("jdbc:mysql://localhost:3306/test");
		source.setUsername("root");
		source.setPassword("123456789");
		source.setDriverClassName("com.mysql.jdbc.Driver");
		
		//3、获取连接
		Connection conn=source.getConnection();
		System.out.println("数据库连接状态1："+conn);
		conn.close();
		
	}
	//方式二
	@Test
	public void getConnection2() throws Exception{
		Properties pros = new Properties();
		
		InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
		
		pros.load(is);
		
		DataSource source = DruidDataSourceFactory.createDataSource(pros);
		Connection conn = source.getConnection();
		System.out.println("数据库连接状态2："+conn);
		conn.close();
		
	}
}

方法二使用配置文件创建连接池，配置文件内容如下：

url=jdbc:mysql://localhost:3306/test
username=root
password=123456789
driverClassName=com.mysql.jdbc.Driver

initialSize=10
maxActive=10