package?lgcsgwxt;

import?java.sql.*;

public?class?DBAccess?{

????private?static?final?String?DRIVER?=
????????????“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
????private?static?final?String?URL?=
????????????“jdbc:microsoft:sqlserver://localhost:1433;databaseName=SuperMarket;“;
????private?static?final?String?USER?=?“sa“;
????private?static?final?String?PASSWORD?=?“sa“;
????public?static?Connection?getConnection（）?{?//連接數據庫
????????Connection?conn?=?null;
????????try?{
????????????Class.forName（DRIVER）;
????????????conn?=?DriverManager.getConnection（URL?USER?PASSWORD）;

????????}?catch?（Exception?ex）?{
????????????ex.printStackTrace（）;
????????}
????????return?conn;
????}

}