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)    {    }  }}