Oracle×Ô´úµÄÏ̳߳Ø

µÚÒ»¸öÀࣺ
/**
 *
 * ´æ·ÅoracleÊý¾Ý¿âµÄÁ´½ÓÐÅÏ¢¡£
 *
 * @author ZhongHuiQiang
 *
 */
public interface IOracleDAOInfor {
 String DB_SERVER_HOSET = "localhost";
 String DB_SERVER_NAME = "ppoo";
 String DB_USER_NAME = "system";
 String DB_USER_PASSWORD = "ppoo";
 String DB_URL = "jdbc:oracle:thin:@" + DB_SERVER_HOSET + ":1521:"
   + DB_SERVER_NAME;
}
µÚ¶þ¸öÀࣨ²âÊÔ£©£º
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.jdbc.pool.OracleConnectionCacheImpl;
/**
 *
 * ¿ÉÒÔ»ñµÃÊý¾Ý¿âÁ¬½ÓµÄConnection¡£<br>
 * ÒÔ¼°¹Ø±ÕÖ¸¶¨µÄÊý¾Ý¿âConnection`£ÒesultSetºÍStatement<br>
 *
 * @author ZhongHuiQiang
 *
 */
public class OracleDAOFactory implements IOracleDAOInfor {
 /**
  *
  * µÃµ½Ò»¸öConnection¶ÔÏó
  *
  * @return java.sql.Connection
  */
 public static Connection getConn() {
  Connection conn = null;
  try {
   OracleConnectionCacheImpl occi = new OracleConnectionCacheImpl();
   occi.setURL(DB_URL);
   occi.setUser(DB_USER_NAME);
   occi.setPassword(DB_USER_PASSWORD);
   occi.setMinLimit(2); // ×îСÁ¬½ÓÊý
   occi.setMaxLimit(10); // ×î´óÁ¬½ÓÊý
   conn = occi.getConnection();
  } catch (SQLException e) {
   System.out.println("Êý¾Ý¿âÁ´½ÓÓÐÎÊÌ⣬Õâ¸öÔÚOracleDAO.javaÀàÖÐ");
  }
  return conn;
 }
 /**
  *
  * ¹Ø±ÕÖ¸¶¨µÄ½á¹û¼¯
  *
  * @param rs
  *            Òª¹Ø±ÕµÄResultSet
  */
 public static void closeResultSet(ResultSet rs) {
  try {
   if (rs != null) {
    rs.close();
&nbs