DBCP连接池

引入两个新的jar包

public class DbcpTest {
	public DataSource getDataSource() {
		BasicDataSource ds=new BasicDataSource();
		//设置连接数据库的四要素
		ds.setDriverClassName("com.mysql.jdbc.Driver");
		ds.setUrl("jdbc:mysql://localhost:3306/student");
		ds.setUsername("root");
		ds.setPassword("123456");
		ds.setMaxActive(5);
		return ds;
	}
	@Test
	public void test() throws Exception {
		 DataSource ds=this.getDataSource();
		 Connection conn=ds.getConnection();
		 String sql="select * from user1";
		 PreparedStatement pst=conn.prepareStatement(sql);
		 ResultSet rs=pst.executeQuery();
		 while(rs.next()) {
			 System.out.println(rs.getString("name"));
		 }
		 rs.close();
		 pst.close();
		 conn.close();
	}
}

使用properties文件解耦DBCP

public class DBCPUtil {
	private static DataSource ds=null;
	static {
		Properties p=new Properties();
		try {
			p.load(Thread.currentThread().getContextClassLoader().getResourceAsStream("db.properties"));
			ds=BasicDataSourceFactory.createDataSource(p);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public static Connection getConn() {
		try {
			return ds.getConnection();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}
}