dbpool.java

jsp网站开发四“酷”全书原码

package com.publish.shop.util.db;

import javax.naming.Context;
import javax.sql.DataSource;
import javax.naming.InitialContext;
import java.sql.*;

//import com.publish.shop.util.javabeans.ResourceLocator;
import sun.jdbc.odbc.JdbcOdbcDriver;

public class DbPool
{
  public static Connection getConnection() throws Exception
  {
    Connection con = null;
    try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con = DriverManager.getConnection("jdbc:odbc:shop", "shop", "shop");
    }
    catch(Exception e)
    {
      e.printStackTrace();
      throw e;
    }
    return con;
  }

  public static Connection getConnectionEx() throws Exception
  {
    Connection con = null;
    try
    {
      DataSource ds = null;
      Context initCtx = new InitialContext();
      Context envCtx = (Context)initCtx.lookup("java:comp/env");
      ds = (DataSource)envCtx.lookup("jdbc/shop");
      if (ds != null)
      {
        con = ds.getConnection();
      }
    }
    catch(Exception e)
    {
      e.printStackTrace();
      throw e;
    }
    return con;
  }

  public static void closeConnection(Connection con)
  {
    try
    {
      if (con != null)
        con.close();
    }
    catch(Exception e)
    {

    }
  }

  public static void closeStatement(Statement stmt)
  {
    try
    {
      if (stmt != null)
        stmt.close();
    }
    catch(Exception e)
    {

    }
  }

  public static void closeStatement(PreparedStatement stmt)
  {
    try
    {
      if (stmt != null)
        stmt.close();
    }
    catch(Exception e)
    {

    }
  }

  public static void closeResultSet(ResultSet rs)
  {
    try
    {
      if (rs != null)
        rs.close();
    }
    catch(Exception e)
    {

    }
  }
}