opendbbean.java

hibernate+spring的相片上传项目

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();
        }
     */
  }

}