杩炴帴姹犲師鐞?/p>
铏界劧鐜板湪鐢?/p>
APACHE COMMONS DBCP
鍙互闈炲父鏂逛究鐨勫缓绔嬫暟鎹簱杩炴帴姹狅紝
浣嗘槸鍍忚繖绡囨枃绔犳妸鏁版嵁搴撹繛鎺ユ睜鐨勫唴閮ㄥ師鐞嗗啓鐨勮繖涔堥�忓交锛屾敞瑙嗚繖涔堝畬鏁达紝
鐪熸槸闈炲父闅惧緱锛岃寮�鍙戜汉鍛樺彲浠ユ洿娣卞眰娆＄殑鐞嗚В鏁版嵁搴撹繛鎺ユ睜锛岀湡鏄潪甯告劅
璋㈣繖绡囨枃绔犵殑浣滆�呫�?/p>
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Enumeration;
import java.util.Vector;
public class ConnectionPool {
private String jdbcDriver = ""; //
鏁版嵁搴撻┍鍔?/p>
private String dbUrl = ""; //
鏁版嵁
URL
private String dbUsername = ""; //
鏁版嵁搴撶敤鎴峰悕
private String dbPassword = ""; //
鏁版嵁搴撶敤鎴峰瘑鐮?/p>
private String testTable = ""; //
娴嬭瘯杩炴帴鏄惁鍙敤鐨勬祴璇曡〃鍚嶏紝榛樿娌℃湁娴嬭瘯琛?/p>
private int initialConnections = 10; //
杩炴帴姹犵殑鍒濆澶у皬
private int incrementalConnections = 5;//
杩炴帴姹犺嚜鍔ㄥ鍔犵殑澶у皬
private int maxConnections = 50; //
杩炴帴姹犳渶澶х殑澶у皬
private Vector connections = null; //
瀛樻斁杩炴帴姹犱腑鏁版嵁搴撹繛鎺ョ殑鍚戦噺
,
鍒濆鏃朵负
null
//
瀹冧腑瀛樻斁鐨勫璞′负
PooledConnection
鍨?/p>
/**
*
鏋勯�犲嚱鏁?/p>
*