dbpool.java

来自「中国电信ISMP管理平台SMS订购关系同步接口」· Java 代码 · 共 64 行

package com.wireless.sms.ismp.global;

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

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;
	    }
	  }


}