dbpool.java

ASP SHOP 的代码

package com.publish.shop.util.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class DbPool
{
  public static Connection getConnection() throws Exception
  {
	String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shop";
	String user="sa";
	String pwd="sa";
    Connection con = null;
    try
    {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      con = DriverManager.getConnection(url,user,pwd);
    }
    catch(Exception e)
    {
      e.printStackTrace();
      throw e;
    }
    return con;
  }

  public static Connection getConnectionEx() throws Exception
  {
	  String url="jdbc:microsoft:sqlserver://localhost:9999;DatabaseName=shop";
		String user="shop";
		String pwd="shop";
	    Connection con = null;
	    try
	    {
	      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
	      con = DriverManager.getConnection(url,user,pwd);
	    }
	    catch(Exception e)
	    {
	      e.printStackTrace();
	      throw e;
	    }
	    return con;
  }
  /*{
    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)
    {

    }
  }
}