package org.itstar.netbar.utils;

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

public class ConnectDB 
{
	private static Connection con=null;
	
	static
	{//加載類
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		
		String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=NetBar";
		String dbUsername="sa";
		String dbPassword="sa";
		try {//建立與數據源的連接
			con=DriverManager.getConnection(url,dbUsername,dbPassword);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static Connection getConn()
	{//此方法得到一個連接
		return con;
	}
	
	public static void closeConn()
	{//此方法關閉一個連接
		try {
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}