Java模拟.NET的连接池

public CallableStatement prepareCall(String sql, int resultSetType,
                    int resultSetConcurrency,
                    int resultSetHoldability) throws
   SQLException {
  /**@todo Implement this java.sql.Connection method*/
  //throw new java.lang.UnsupportedOperationException("Method prepareCall() not yet implemented.");
  return aCon.prepareCall(sql, resultSetType, resultSetConcurrency,
              resultSetHoldability);
 }

 public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws
   SQLException {
  /**@todo Implement this java.sql.Connection method*/
  //throw new java.lang.UnsupportedOperationException("Method prepareStatement() not yet implemented.");
  return aCon.prepareStatement(sql, autoGeneratedKeys);
 }

 public PreparedStatement prepareStatement(String sql, int[] columnIndexes) throws
   SQLException {
  /**@todo Implement this java.sql.Connection method*/
  // throw new java.lang.UnsupportedOperationException("Method prepareStatement() not yet implemented.");
  return aCon.prepareStatement(sql, columnIndexes);
 }

 public PreparedStatement prepareStatement(String sql, String[] columnNames) throws
   SQLException {
  /**@todo Implement this java.sql.Connection method*/
  //throw new java.lang.UnsupportedOperationException("Method prepareStatement() not yet implemented.");
  return aCon.prepareStatement(sql, columnNames);
 }

 public void closeConnection() throws SQLException {
  if (onClose != null) {
   onClose.Action(this);
  }
  aCon.close();

 }

 public boolean isUsed() {
  return inUse;

 }

 public void use() {
  inUse = true;
 }

 public void setOnClose(OnConnectionClose Action) {
  onClose = Action;

 }

}

以上就是我所写的连接池代码.

使用方法:
DBTools.DBConnectionPool.SetJDBC("jdbc:mysql://fireBird/trmg?useUnicode=true&characterEncoding=GB2312",
"Administrator","");
   DBTools.DBConnectionPool.setDriverName("com.mysql.jdbc.Driver");

java.sql.Connection con = DBTools.DBConnectionPool.getConnection();

当使用完毕了别忘记将con关闭:).

好像现在使用java的人不允许人说java的问题,java的内存回收存在大问题.内存泄漏的厉害,建议如非必要不要使用new来生成新的对象.这样可能可以让我们的系统可以活的更长久一些.还有linux下java性能惨不忍睹,在俺测试的平台中win32反而是最高的.郁闷郁闷不是罪.