加粗样式我自定义的连接池
package web10;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.util.LinkedList;
import java.util.logging.Logger;
import javax.sql.DataSource;
//自定义的连接池,不过测试有问题,解决不了
public class demo01 implements DataSource {
//创建一个容易,存储connection对象
private static LinkedList pool=new LinkedList();
static {
for (int i = 0; i < 5; i++) {
Connection conn=demo03.getConnection();
pool.add(conn);
}
}
@Override
public Connection getConnection() throws SQLException {
// TODO Auto-generated method stub
Connection conn=null;
//使用前先判断
if (pool.size()==0) {
for (int i = 0; i < 5; i++) {
conn=demo03.getConnection();
pool.add(conn);
}
}else {
conn=pool.remove(0);
}