------- <a href="http://www.itheima.com" target="blank">android培训</a>、<a href="http://www.itheima.com" target="blank">java培训</a>、期待与您交流! ----------
数据库连接池
- private static LinkedList<Connection> pool=new LinkedList<Connection>();
private static String driverClassName="com.mysql.jdbc.Driver";
private static String url="mysql:jdbc://localhost:3306/jdbc";
private static String username="root";
private static String password="1111";
static{
// 加载驱动
try {
Class.forName(driverClassName);
for(int i=0;i<10;i++){
Connection conn=DriverManager.getConnection(url, username, password);
pool.add(conn);
}
} catch (Exception e) {
// TODO Auto-generated catch block
throw new ExceptionInInitializerError(e);
}
}
public synchronized static Connection getConnection(){
return pool.removeFirst();//返回被删除的
}
public static void release(Connection conn){
pool.addLast(conn);
}