oracle java 连接池_Oracle JDBC 连接池

public class DataSourceImpl implementsDataSource {private ReentrantLock lock = newReentrantLock();//定义连接池中连接对象的存储容器

private List list = Collections.synchronizedList(new LinkedList<>());//定义数据库连接属性

private final static String DRIVER_CLASS = PropertiesUtils.getInstance().getProperty("jdbc.driver_class");private final static String URL = PropertiesUtils.getInstance().getProperty("jdbc.url");private final static String USERNAME = PropertiesUtils.getInstance().getProperty("jdbc.username");private final static String PASSWORD = PropertiesUtils.getInstance().getProperty("jdbc.password");//定义默认连接池属性配置

private int initSize = 2;private int maxSize = 4;private int stepSize = 1;private int timeout = 2000;publicDataSourceImpl() {

initPool();

}//初始化连接池

private voidinitPool() {

String init= PropertiesUtils.getInstance().getProperty("initSize");

String step= PropertiesUtils.getInstance().getProperty("stepSize");

String max= PropertiesUtils.getInstance().getProperty("maxSize");

String time= PropertiesUtils.getInstance().getProperty("timeout");

initSize= init == null ?initSize : Integer.parseInt(init);

maxSize= max == null ?maxSize : Integer.parseInt(max);

stepSize= step == null ?stepSize : Integer.parseInt(step);

timeout= time == null ?timeout : Integer.parseInt(time);try{//加载驱动

Driver driver =(Driver) Class.forName(DRIVER_CLASS).newInstance();//使用DriverManager注册驱动

DriverManager.registerDriver(driver);

}catch(Exception e) {

e.printStackTrace();

}

}

@OverridepublicPoolConnection getDataSource() {

PoolConnection poolConnection= null;try{

lock.lock();//连接池对象为空时，初始化连接对象

if (list.size() == 0) {

createConnection(initSize);

}//获取可用连接对象

poolConnection =getAvailableConnection();//没有可用连接对象时，等待连接对象的释放或者创建新的连接对象使用

while (poolConnection == null) {

System.out.println("---------------等待连接---------------");

createConnection(stepSize);

poolConnection=getAvailableConnection();if (poolConnection == null) {

TimeUnit.MILLISECONDS.sleep(30);

}

}

}catch(Exception e) {

e.printStackTrace();

}finally{

lock.unlock();

}returnpoolConnection;

}//创建数据库连接

private void createConnection(int count) throwsSQLException {if (list.size() + count <=maxSize) {for (int i = 0; i < count; i++) {

System.out.println("初始化了" + (i + 1) + "个连接");

Connection connect=DriverManager.getConnection(URL, USERNAME, PASSWORD);

PoolConnection pool= new PoolConnection(connect, true);

list.add(pool);

}

}

}//获取可用连接对象

private PoolConnection getAvailableConnection() throwsSQLException {for(PoolConnection pool : list) {if(pool.isStatus()) {

Connection con=pool.getConnect();//验证连接是否超时

if (!con.isValid(timeout)) {

Connection connect=DriverManager.getConnection(URL, USERNAME, PASSWORD);

pool.setConnect(connect);

}

pool.setStatus(false);returnpool;

}

}return null;

}

}