dbcp连接数据库

public class TestDs {
public static void main(String[] args)throws Exception {
BasicDataSource bds = new BasicDataSource();

	//设置基本的连接属性
	bds.setDriverClassName("com.mysql.jdbc.Driver");
	bds.setUrl("jdbc:mysql:///db1?useUnicode=true&characterEncoding=utf-8");
	bds.setUsername("sun");
	bds.setPassword("sun");
	
	//设置连接池的属性
	bds.setInitialSize(10);
	bds.setMaxWait(3600000);
	bds.setMinIdle(5);
	
	//从连接池当中获取连接
	Connection conn = bds.getConnection();
	
	PreparedStatement pst = conn.prepareStatement("select * from emp");
	ResultSet rs = pst.executeQuery();
	while(rs.next()) {
		System.out.println(rs.getObject(1)+":"+rs.getObject(2));
	}
	
	rs.close();
	pst.close();
	conn.close();
}

//dbcp结合配置文件使用
@Test
public void mm()throws Exception{
	//创建dbcp连接工厂
	BasicDataSourceFactory bsd = new BasicDataSourceFactory();
	
	//加载配置信息到集合中
	Properties prop = new Properties();
	prop.load(new FileInputStream("db.properties"));
	//创建连接池
	DataSource bds = bsd.createDataSource(prop);
	
	//从连接池当中获取连接
	Connection conn = bds.getConnection();
	
	PreparedStatement pst = conn.prepareStatement("select * from emp");
	ResultSet rs = pst.executeQuery();
	while(rs.next()) {
		System.out.println(rs.getObject(1)+":"+rs.getObject(2));
	}
	
	rs.close();
	pst.close();
	conn.close();
}

}
配置文件

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///db1?useUnicode=true&characterEncoding=utf-8
username=sun
password=sun

initialSize=10
maxWait=3600000
minIdle=5