?? dbpool.java
字號:
package com.huang.common.DB;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.ArrayList;
public class DBpool {
private static String driver = "oracle.jdbc.driver.OracleDriver";
private static String url = "jdbc:oracle:thin:@localhost:1521:sccp";
private static String username = "system";
private static String password = "sccp456";
private static ArrayList list = null;
private static Connection conn;
private static int conMax = 10;
private static Connection createConnection() {
try {
java.lang.Class.forName(driver);
return DriverManager.getConnection(url, username, password);
}catch(Exception e) {
e.printStackTrace();
return null;
}
}
public static Connection getConnection() {
if(list == null) {
list = new ArrayList();
}
if(list.isEmpty()) {
return createConnection();
}else {
System.out.println("************conection************"+list.size());
conn = (Connection)list.get(list.size()-1);
list.remove(list.size()-1);
return conn;
}
}
public static void returnTOConnection(Connection con) {
if(list.size() == conMax) {
try {
con.close();
}catch(Exception e) {
e.printStackTrace();
}
}else {
list.add(con);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -