dblink.java

网上购书系统！jsp+servlet+jdbc实现！数据库sqlserver2

package DbUtil;

import java.sql.*;

public class DbLink {
    private static final String DRIVER =
            "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private static final String URL =
            "jdbc:microsoft:sqlserver://localhost:1433;databaseName=BookShpping";
    private static final String USER = "sa";
    private static final String PASSWORD = "821023";
    public static Connection getConnection() {
        Connection con = null;
        try {
            Class.forName(DRIVER);
            con = DriverManager.getConnection(URL,USER,PASSWORD);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return con;
    }
}