java 資料庫連接方式（四）

import java.util.ArrayList;import java.util.Iterator;import java.util.Timer;import java.util.TimerTask;import com.xxx.config.*;/** * 串連池串連工廠實作類別。<br> * 配置說明：<br> * DBMaxConnectionCount：串連池最大串連數<br> * DBMinConnectionCount：串連池最小串連數<br> * DBInitConnectionCount：串連池初始串連數<br> * DBUseCount：資料庫連接對象使用次數，預設-1；<br> * DBTimeout：資料庫連接對象空閑時間，預設-1；<br> * DBUseTime：資料庫連接對象最大使用時間，預設-1；<br> * DBTimerInterval：資料庫定時器整理串連池的間隔時間，預設-1；<br> * 如果DBTimerInterval配置為-1，則不啟動串連池定時器。 * @author  */public class CPoolConnectionFactory extends SimpleConnectionFactory {int connectionPoolSize = 1;int connectionPoolMin = 1;int connectionPoolMax = 30;int connectionPoolFree = -1;int connectionUseCount = -1;long connectionWaitTimeout = -1;long connectionTimeout = -1;long connectionUseTime = -1;int timerInterval = -1;protected ArrayList connectionObjs;protected Timer timer; protected CPoolConnectionFactory() {}/** * 銷毀串連池 */public void destroy() {synchronized (connectionObjs) {Iterator it = connectionObjs.iterator();while (it.hasNext()) {ConnectionObject co = (ConnectionObject) it.next();co.close();}this.connectionObjs.clear();}}/** * 從串連池得到連線物件 * @return ConnectionObject對象 */public ConnectionObject getConnection() {ConnectionObject co = this.getConnectionInternal(false);return co; }/** * 建立連線物件 * @return 一個新的ConnectionObject對象 */public ConnectionObject newConnection() {ConnectionObject co = this.getConnectionInternal(true);return co; }/** * 釋放連線物件到串連池 * @param co 將被釋放的ConnectionObject對象 */public void freeConnection(ConnectionObject co) {if (co == null) return;synchronized (connectionObjs) {co.useCount++;if (connectionUseCount > 0 && co.useCount > connectionUseCount) {co.close();this.connectionObjs.remove(co);co = null;} else {co.endTransaction();co.closeStatement();co.isusing = false;co.lastAccess = System.currentTimeMillis();}}}/** * 關閉連線物件 * @param co 將被關閉的ConnectionObject對象 */public void closeConnection(ConnectionObject co) {if (co == null) return;synchronized (connectionObjs) {co.close();this.connectionObjs.remove(co);co = null;}}/** * 初始化 * @param conf 資料庫配置 */public void init(Configs conf){super.init(conf);try {connectionPoolMin = Integer.parseInt(conf.getConfig(ConfigKeys.dbMinConnKey, "1"));}catch(Exception ex){}if (connectionPoolMin < 0)connectionPoolMin = 1;try {connectionPoolSize = Integer.parseInt(conf.getConfig(ConfigKeys.dbInitConnKey, "1"));}catch(Exception ex){}if (connectionPoolSize < connectionPoolMin)connectionPoolSize = connectionPoolMin;try {connectionPoolMax = Integer.parseInt(conf.getConfig(ConfigKeys.dbMaxConnKey, "30"));}catch(Exception ex){}if (connectionPoolMax < 0)connectionPoolMax = 100;if (connectionPoolMax < connectionPoolMin)connectionPoolMax = connectionPoolMin + 3;try {connectionUseCount = Integer.parseInt(conf.getConfig(ConfigKeys.dbUseCountKey, "-1"));}catch(Exception ex){}try {connectionTimeout = Long.parseLong(conf.getConfig(ConfigKeys.dbTimeoutKey, "-1")) * 60 * 1000;}catch(Exception ex){}try {connectionWaitTimeout = Long.parseLong(conf.getConfig(ConfigKeys.dbWaitTimeoutKey, "-1")) * 1000;}catch(Exception ex){}try {connectionUseTime = Long.parseLong(conf.getConfig(ConfigKeys.dbUseTimeKey, "-1")) * 60 * 1000;}catch(Exception ex){}try {timerInterval = Integer.parseInt(conf.getConfig(ConfigKeys.dbTimerIntervalKey, "-1")) * 60 * 1000;}catch(Exception ex){}if (timerInterval > 0) {timer = new Timer(); timer.schedule(new TimerTask() {             public void run() {             TimerEvent();            }         }, timerInterval, timerInterval); }connectionObjs = new ArrayList(connectionPoolMax);for (int i = 0; i < connectionPoolSize; i++) {ConnectionObject co = super.newConnection();this.connectionObjs.add(co);}}protected ConnectionObject getConnectionInternal(boolean isNew) {long sys = System.currentTimeMillis();while (true) {ConnectionObject ret = null;synchronized (connectionObjs) {if (connectionObjs.size() > 0 && (isNew == false || this.connectionObjs.size() >= connectionPoolMax)) {ArrayList removes = new ArrayList();Iterator it = connectionObjs.iterator();while (it.hasNext()) {ConnectionObject co = (ConnectionObject) it.next();if (!co.isusing) {if (isNew) {co.close();this.connectionObjs.remove(co);break;}if ((connectionTimeout < 0 || System.currentTimeMillis() - co.createTime < connectionTimeout) && !co.isClosed()) {ret = co;break;}co.close();removes.add(co);}}if (removes.size() > 0) this.connectionObjs.removeAll(removes);}if (ret == null && this.connectionObjs.size() < connectionPoolMax) {ret = super.newConnection();this.connectionObjs.add(ret);}//System.out.println("get connection ret=====================" + ret);if (ret != null) {ret.isusing = true;ret.lastAccess = System.currentTimeMillis();//System.out.println("get connection size=====================" + this.connectionObjs.size());return ret;}}if (this.connectionWaitTimeout > 0 && System.currentTimeMillis() - sys > this.connectionWaitTimeout)throw new DBException("已達到最大的等待時間，沒取到可用的串連！");try {Thread.sleep(500);}catch(Exception ex){}}}protected void TimerEvent() {synchronized (connectionObjs) {if (connectionObjs.size() > 0) {ArrayList removes = new ArrayList();Iterator it = connectionObjs.iterator();int cc = 0;while (it.hasNext()) {ConnectionObject co = (ConnectionObject) it.next();try {if (!co.conn.isClosed()) {if (co.isusing) {if (connectionUseTime < 0 || System.currentTimeMillis() - co.lastAccess < connectionUseTime)continue;} else {if ((connectionTimeout < 0 || System.currentTimeMillis() - co.createTime < connectionTimeout)&& (connectionUseCount < 0 || co.useCount <= connectionUseCount)&& !co.isClosed()) {if (this.connectionPoolFree < 0 || cc < this.connectionPoolFree) {cc++;continue;}}}}}catch(Exception ex){ex.printStackTrace();}co.close();removes.add(co);}if (removes.size() > 0) this.connectionObjs.removeAll(removes);}if (connectionObjs.size() < connectionPoolMin) {for (int i = this.connectionObjs.size(); i < connectionPoolMin; i++) {ConnectionObject co = super.newConnection();this.connectionObjs.add(co);}}//System.out.println("connection size***********************" + this.connectionObjs.size());}}}