cleardbresource.java

来自「短信系统SMS：支持普通短信、长短信和wap push短信的发送。」· Java 代码 · 共 85 行

package com.ekun.common.db;

import java.sql.*;
import com.ekun.common.log.*;

public final class ClearDBResource
{
  private static Logger log = LoggerFactory.getLogger(ClearDBResource.class);
  /**
   * 关闭数据库连接
   * @param conn Connection
   */
  public static void closeConnection(Connection conn)
  {
    if (conn != null)
    {
      try
      {
        if (!conn.isClosed())  conn.close();
      }
      catch (SQLException ex)
      {
        log.error("Unable to close database connection!",ex);
      }
    }
  }

  /**
   * 释放记录集对象
   * @param rs
   */
  public static void closeResultSet(java.sql.ResultSet rs)
  {
    if (rs != null)
    {
      try
      {
        rs.close();
      }
      catch (SQLException ex)
      {
        log.error("Unable to close database ResultSet",ex);
      }
    }
  }

  /**
   * 释放PreparedStatement对象
   * @param stmt
   */
  public static void closeStatment(java.sql.PreparedStatement stmt)
  {
    if (stmt != null)
    {
      try
      {
        stmt.close();
      }
      catch (SQLException ex)
      {
        log.error("Unable to close database PreparedStatement ",ex);
      }
    }
  }

  /**
   * 释放Statement对象占用资源
   * @param stmt
   */
  public static void closeStatment(java.sql.Statement stmt)
  {
    if (stmt != null)
    {
      try
      {
        stmt.close();
      }
      catch (SQLException ex)
      {
        log.error("Unable to close database Statement ",ex);
      }
    }
  }
}