dbpool.java

来自「中国联通短信通信协议」· Java 代码 · 共 65 行

package com.wireless.sms.unsoap.global;

import java.sql.Connection;
import java.sql.SQLException;

import com.wireless.sms.gwif.smsagent.global.LoggerConstant;
import com.wireless.sms.pub.db.ConnectionPool;

public class DBPool {

  /**
   * 数据库连接池对象
   */
  public static ConnectionPool POOL = null;

  /**
   * 取得数据库连接
   * @return Connection
   */
  public static Connection getConnection() {
    Connection conn = null;
    try {
      conn = POOL.getConnection();
    }
    catch (Exception e) {
      LoggerConstant.sql_log.error(e.getMessage());
    }
    return conn;
  }

  /**
   * 关闭数据库连接
   * @param conn Connection
   */
  public static void closeConnection(Connection conn) {
    if (conn != null) {
      try {
        conn.close();
      }
      catch (SQLException ex) {
        ex.printStackTrace();
      }
      conn = null;
    }
  }

  public static void main(String[] args) throws Exception {
    Connection conn = null;
    try {
//      DBPool cc = new DBPool();
      conn = DBPool.getConnection();
      System.out.println(conn);
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      conn.close();
      conn = null;
    }
  }


}