import java.sql.SQLException;
import org.apache.commons.dbcp2.BasicDataSource;
public class TestDbcp {
public static void main(String[] args) {
// TODO Auto-generated method stub
BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/demo");
dataSource.setUsername("root");
dataSource.setPassword("0524");
dataSource.setMaxActive(10);
dataSource.setInitialSize(2);
Connection conn=null;
for(int i=0;i<15;i++){
try{
conn=dataSource.getConnection();
System.out.println("connection"+i+":"+conn.hashCode());
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
MaxActive,连接池的最大数据库连接数。设为0表示无限制
http://commons.apache.org/proper/commons-dbcp/configuration.html
你想知道什么呀?