//包名
package com.guestbook;

import java.sql.*;

public class DBConnection
{

	private String driver;
	private StringBuffer SQLURL;
	private String SQLFilePath;
	private String SQLFileName;
	private StringBuffer SQLServerURL;
	private Connection conn;

	
	  public DBConnection()
	{    
		driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
		SQLURL = new StringBuffer("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guesbook");
		SQLFilePath = "";
		SQLFileName = "";
		SQLServerURL = new StringBuffer("jdbc:odbc:Driver={SQL Server};");
		conn = null;
	}


	  
	 public Connection getConnectionToAccess(String s)
		throws SQLException, ClassNotFoundException
	{
		SQLURL.append(s);
		//加載數(shù)據(jù)庫驅(qū)動
		Class.forName(driver);
		//建立連接
		conn = DriverManager.getConnection(SQLURL.toString());
		return conn;
	}

	public Connection getConnectionToSQLServer(String s, String s1, String s2, String s3, String s4)
		throws SQLException, ClassNotFoundException
	{
		SQLServerURL.append("server=");
		SQLServerURL.append(s);
		SQLServerURL.append(":");
		SQLServerURL.append(s1);
		SQLServerURL.append(";");
		SQLServerURL.append("uid=");
		SQLServerURL.append(s2);
		SQLServerURL.append(";");
		SQLServerURL.append("pwd=");
		SQLServerURL.append(s3);
		SQLServerURL.append(";");
		SQLServerURL.append("database=");
		SQLServerURL.append(s4);
		Class.forName(driver);
		conn = DriverManager.getConnection(SQLServerURL.toString());
		return conn;
	}

	public void close()
	{
		try
		{
			conn.close();
		}
		catch (SQLException sqlexception)
		{
			sqlexception.printStackTrace();
		}
	}
}