DBCP连接池

package erchou;


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


import javax.sql.DataSource;


import org.apache.commons.dbcp.BasicDataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.junit.Test;


public class Demo {
    /*@Test
    public void testDbcp() throws Exception{
    BasicDataSource dataSource = new BasicDataSource();
        
    dataSource.setUrl("jdbc:mysql://localhost:3306/day16");
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setInitialSize(3);
        dataSource.setMaxActive(6);
        dataSource.setUsername("root"); //连接用户
        dataSource.setPassword("root"); //连接密码
        //达到最大时间自动关闭
        dataSource.setMaxIdle(3000);
        QueryRunner runner = new QueryRunner();
        String sql = "SELECT *FROM student";
        Connection connection = dataSource.getConnection();
        List<student> list = runner.query(connection,sql, new BeanListHandler<student>(student.class));
        for(student stu:list){
        System.out.println(stu.toString());
        }
        
        connection.close();
    }*/
    
    //配置方式实现连接池
    @Test
    public void testDemo() throws Exception{
    //加载prop配置文件
    InputStream in = Demo.class.getResourceAsStream("/db.properties");
    Properties prop = new Properties();
    prop.load(in);
    DataSource dataSouse = BasicDataSourceFactory.createDataSource(prop);
    Connection connection = dataSouse.getConnection();
    System.out.println(connection);
    }
}