用户注册



邮箱:

密码:

用户登录


邮箱:

密码:
记住登录一个月忘记密码?

发表随想


还能输入:200字
云代码 - java代码库

Java 连接池的工作原理

2015-07-29 作者: java源代码大全举报

[java]代码库

String connUrl = "jdbc:mysql://your.database.domain/yourDBname";
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection (connUrl); //源代码片段来自云代码http://yuncode.net
             
 
 
  String connUrl = "jdbc:mysql://your.database.domain/yourDBname";
  String driver = "com.mysql.jdbc.Driver";
  private Map<java.sql.Connection, String> connectionPool = null;
  private void initPool() {
    try {
      connectionPool = new HashMap<java.sql.Connection, String>();
      Class.forName(driver);
      java.sql.Connection con = DriverManager.getConnection(dbUrl);
      for (int poolInd = poolSize; poolInd < 0; poolInd++) {
        connectionPool.put(con, "AVAILABLE");
      }
  }
... //源代码片段来自云代码http://yuncode.net
             
 
 
...
  public java.sql.Connection getConnection() throws ClassNotFoundException, SQLException
  {
      boolean isConnectionAvailable = true;
      for (Entry<java.sql.Connection, String> entry : connectionPool.entrySet()) {
          synchronized (entry) {
              if (entry.getValue()=="AVAILABLE") {
                  entry.setValue("NOTAVAILABLE");
                  return (java.sql.Connection) entry.getKey();
              }
              isConnectionAvailable = false;
          }
      }
      if (!isConnectionAvailable) {
          Class.forName(driver);
          java.sql.Connection con = DriverManager.getConnection(connUrl);
          connectionPool.put(con, "NOTAVAILABLE");
          return con;
      }
      return null;
  }
  ... //源代码片段来自云代码http://yuncode.net
             
 
 
...
public void closeConnection(java.sql.Connection connection) throws ClassNotFoundException, SQLException {
    for (Entry<java.sql.Connection, String> entry : connectionPool.entrySet()) {
        synchronized (entry) {
            if (entry.getKey().equals(connection)) {
                //Getting Back the conncetion to Pool
                entry.setValue("AVAILABLE");
            }
        }
    }
}
... //源代码片段来自云代码http://yuncode.net
            


网友评论    (发表评论)


发表评论:

评论须知:

  • 1、评论每次加2分,每天上限为30;
  • 2、请文明用语,共同创建干净的技术交流环境;
  • 3、若被发现提交非法信息,评论将会被删除,并且给予扣分处理,严重者给予封号处理;
  • 4、请勿发布广告信息或其他无关评论,否则将会删除评论并扣分,严重者给予封号处理。


扫码下载

加载中,请稍后...

输入口令后可复制整站源码

加载中,请稍后...