package?test.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;

public?class?ConnectionDAL?{
	
	public?Connection?getConnection（）?{
		String?driverName?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;?//?加載JDBC驅(qū)動
		String?dbURL?=?“jdbc:sqlserver://localhost:1433;?DatabaseName=firstdb“;?//?連接服務(wù)器和數(shù)據(jù)庫sample
		//String?driverName?=?“sun.jdbc.odbc.JdbcOdbcDriver“;
		//String?dbURL?=?“jdbc:odbc:firstdb“;
		String?userName?=?“sa“;?//?默認用戶名
		String?userPwd?=?“12345678“;?//?密碼
		Connection?dbConn?=?null;
		try?{
			Class.forName（driverName）;
			dbConn?=?DriverManager.getConnection（dbURL）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?dbConn;
	}

}