dbconnection.java

购物网站

package com;
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;

public class DBConnection
{
    public static Connection getConnection() throws SQLException
    {
		String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	    String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=DVDSHOPPING";
	    String USER="sa";
	    String PWD="";
    	
      try
      {
        Class.forName(CLASSFORNAME);
        return DriverManager.getConnection(SERVANDDB,USER,PWD);
    	  /*Context initCtx = new javax.naming.InitialContext(); 
          Context envCtx = (Context) initCtx.lookup("java:comp/env"); 
          DataSource ds = (DataSource)envCtx.lookup("jdbc/dd"); ;
          return ds.getConnection();*/
      }
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }
    }
}