opendbbean.java~2~

来自「hibernate+spring的相片上传项目」· JAVA~2~ 代码 · 共 158 行

package org.lenovoAC.tools;

import java.sql.*;
import javax.naming.NamingException;
import javax.naming.*;
import javax.sql.DataSource;

public class OpenDbBean {
  //空的构造函数
private DBConnectionManager connMgr;
  private Connection conn = null;
  private ResultSet rs = null;
  private Statement ps = null;

  //**@建立数据库连接代码*/
 /*
  for test
  */
 /*
    public Connection getConnection() { //throws SQLException
      connMgr = DBConnectionManager.getInstance();
      Connection con = connMgr.getConnection("idb");
      if (con == null) {
         System.out.println("申请连接池内可连接时超过最大允许连接数.");
        //throw new SQLException("数据库忙，无法为用户指定空闲的连接");
      }
      //connMgr.freeConnection("idb", con);
      return con;
    }
  */



  /* for jboss*/
  public Connection getConnection() throws SQLException {
    javax.sql.DataSource ds = null;
    java.sql.Connection con = null;
    try
    {

      Context ctx=new javax.naming.InitialContext();

      ds = (javax.sql.DataSource) ctx.lookup("java:comp/env/jdbc/OracleDB");

    }
    catch (NamingException e)
    {
      e.printStackTrace();
    }

//    System.out.println("getting a connection");
    return ds.getConnection();
  }



  //**@清除数据库连接信息代码*/
  public void CleanConnection(Connection con, Statement ps, ResultSet rs) throws
      SQLException {
    if (rs != null) {
      rs.close();
    }
    if (ps != null) {
      ps.close();
    }
    if (con != null) {
      con.close();
    }
   // connMgr.freeConnection("idb", con);
  //  connMgr.release();
  }

  //**@清除数据库连接信息代码*/
  public void CleanConnection(
      Connection con,
      PreparedStatement ps,
      ResultSet rs) throws SQLException {
    if (rs != null) {
      rs.close();
    }
    if (ps != null) {
      ps.close();
    }

    if (con != null) {
      con.close();

    }
   //connMgr.freeConnection("idb", con);
 //  connMgr.release();
  }

  //**@清除数据库连接信息代码*/
  public void CleanConnection(
      Connection con,
      CallableStatement ps,
      ResultSet rs) throws SQLException {
    if (rs != null) {
      rs.close();
    }
    if (ps != null) {
      ps.close();
    }

    if (con != null) {
      con.close();

    }

 // connMgr.freeConnection("idb", con);
 // connMgr.release();
  }

  //**@清除数据库连接信息代码*/
  public void CleanConnection(Connection con, CallableStatement ps) throws
      SQLException {
    if (ps != null) {
      ps.close();
    }

    if (con != null) {
      con.close();

    }
//  connMgr.freeConnection("idb", con);
 //  connMgr.release();
  }

  //**@清除数据库连接信息代码*/
  public void CleanConnection(Connection con, PreparedStatement ps) throws
      SQLException {
    if (ps != null) {
      ps.close();
    }


     if (con != null) {
      con.close();

    }
  //connMgr.freeConnection("idb", con);
//   connMgr.release();
  }

  //**@清除数据库连接信息代码*/
  public void CleanConnection(Connection con) throws SQLException {
 // connMgr.freeConnection("idb", con);
  //connMgr.release();
/*
  if (con != null) {
      con.close();
    }
*/
  }


}