dbcp创建连接池

package com.hong.dao;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

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

public class DbcpApp {
/***
 * 导入dbcp和pool包
 * 配置
 * 
 */
	@Test
	public  void testBasicDataSource(){
		BasicDataSource dataSource = new BasicDataSource();
		dataSource.setUrl("jdbc:mysql:///test");
		dataSource.setDriverClassName("com.mysql.jdbc.Driver");
		dataSource.setUsername("root");
		dataSource.setPassword("825z.jkc76");
		dataSource.setInitialSize(3);
		dataSource.setMaxActive(6);
		dataSource.setMaxIdle(3000);
		
		try {
			Connection conn = dataSource.getConnection();
			String sql ="select * from userinfo;";
			PreparedStatement prep =conn.prepareStatement(sql);
			ResultSet result = prep.executeQuery();
			while(result.next()){
				System.out.println(result.getString("name"));
				System.out.println(result.getString("password"));
			}
		} catch (SQLException e) {
			throw new RuntimeException(e);
		}
	}


	@Test
	public void testConfigDbcp(){
		//通过配置文件进行创建DataSource
		Properties prop = new Properties();
		InputStream in = DbcpApp.class.getClassLoader().getResourceAsStream("dbcpconfig.properties");
		try {
			prop.load(in);
			DataSource dataSource= BasicDataSourceFactory.createDataSource(prop);
			Connection conn = dataSource.getConnection();
			String sql ="select * from userinfo;";
			PreparedStatement prep =conn.prepareStatement(sql);
			ResultSet result = prep.executeQuery();
			while(result.next()){
				System.out.println(result.getString("name"));
				System.out.println(result.getString("password"));
			}
		} catch (IOException e) {
			throw new RuntimeException(e);
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
		
	}
}