package com.JFreeChat.DB;
import java.sql.*;
public class DBTools {
	//private static String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	//private static String url = "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=pubs";
	private static String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
	
	private static String url = "jdbc:odbc:test";
	
	private static String userName = "sa";
	private static String password = "";
	
	
	/**
	 * 加載驅動程序
	 */
	static{
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	
	/**
	 * 動態連接數據庫
	 * @return
	 */
	public static Connection getConnection()
	{
		try {
			return DriverManager.getConnection(url,userName,password);
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}
	}
	
}