mysql的java串連池，用openSTA測試50人並發訪問一萬次,沒有出現問題，很好用

package dbc;import java.sql.Connection;import java.sql.DriverManager;import java.util.ArrayList;public class DataBaseConnection {private static int maxConnectNum = 20;private java.sql.Connection conn[] = new Connection[maxConnectNum];private static ArrayList connectPool = new ArrayList();private static int flag = 0;public DataBaseConnection() {if (flag == 0) {init();}}private Connection getConnectionFromDatabase() {Connection trueConn = null;try {//Class.forName("org.gjt.mm.mysql.Driver").newInstance();Class.forName("com.mysql.jdbc.Driver").newInstance();String url = "jdbc:mysql://localhost:3306/ssk?user=root&password=dzjc&useUnicode=true&characterEncoding=GBK";trueConn = DriverManager.getConnection(url);} catch (Exception ex) {System.out.println("資料連線出錯了:" + ex.toString());}return trueConn;}//這裡建立所有的串連;private void init() {for (int i = 0; i < maxConnectNum; i++) {conn[i] = getConnectionFromDatabase();connectPool.add(i, conn[i]);}flag = 1;}//從串連池中取得一個可用的串連public Connection getConnection() {Connection conn = null;if (connectPool.size() == 0) {try {java.lang.Thread.sleep(1000);getConnection();} catch (InterruptedException ex) {System.out.println("串連全部用光,這裡sleep出錯了.");}} else {conn = (Connection) connectPool.remove(0);}return conn;}//提供給外部程式調用,不用的串連放回串連池當中...public boolean release(Connection conn) {return connectPool.add(conn);}public static void main(String[] args) {}}