package com.gc.dao;

import java.sql.*;

public class dao {
	
	private Connection con = null;
	
	/**
	 * 實(shí)現(xiàn)數(shù)據(jù)庫(kù)連接的類
	 */
	public dao()
	{
		String dbURL = "jdbc:sqlserver://localhost:1433;databaseName=Shopper;";
		String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
		String userName = "sa";       //SQL用戶名
		String userPwd = "sa";  //SQL密碼
		try
		{
			Class.forName(driverName); //加載JDBC驅(qū)動(dòng)
			con = DriverManager.getConnection(dbURL,userName,userPwd);//連接數(shù)據(jù)庫(kù)和服務(wù)器
		}catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public Connection getCon()
	{
		return con;
	}
}