数据库连接池

1.数据库连接池必须实现javax.sql.DataSource接口

2.dbcp连接池

所需jar包:commons-dbcp,commons-logging,commons-pool,mysql-driver

public static void main(String[] args) {
		BasicDataSource datasource=new BasicDataSource();
		
		datasource.setDriverClassName("com.mysql.jdbc.Driver");
		datasource.setUrl("jdbc:mysql://localhost:3306/BookDB");
		datasource.setUsername("root");
		datasource.setPassword("");
		
		try {
			Connection con=datasource.getConnection();
			System.out.println(con.getClass().getName());
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

3.c3p0连接池

所需jar包:mchange-commons, c3p0, mysql-driver

public static void main(String[] args) {
		ComboPooledDataSource data=new ComboPooledDataSource();
		
		try {
			data.setDriverClass("com.mysql.jdbc.Driver");
			data.setJdbcUrl("jdbc:mysql://localhost:3306/BookDB");
			data.setUser("root");
			data.setPassword("");
			
			
			Connection con=data.getConnection();
			System.out.println(con.getClass().getName());
			con.close();
		} catch (PropertyVetoException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

输出结果为:

com.mchange.v2.c3p0.impl.NewProxyConnection

4.在web中配置