connectbean.java

用JSP实现的一个网上书店的程序

package com;

/**
 * User: qing
 * Date: 2005-6-30
 * Time: 11:22:12
 */
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;
public class connectBean {
   public static Connection getconnect(){
        Connection con=null;
        String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
        String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shop";
        String USER="sa";
        String PWD="sa";
        try {
            Class.forName(CLASSFORNAME);
            con=DriverManager.getConnection(SERVANDDB,USER,PWD);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        } catch (SQLException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }
        return con;
    }
}