package com.wy.tool;

import java.sql.*;

public class JDBConnection {
	private String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 數據庫的驅動

	private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shopping"; // URL地址

	public Connection connection = null;

	public JDBConnection() {
		try {
			Class.forName(dbDriver).newInstance(); // 加載數據庫驅動
			connection = DriverManager.getConnection(url, "sa", ""); // 加載數據庫
		} catch (Exception ex) {
			System.out.println("數據庫加載失敗");
		}
	}
}