package informationsystem.database;

import java.sql.*;

/**
 * 這個類主要是維護與數據庫的連接；
 */
public class DBConnection {
  private String db_user;
  private String db_password;

  static final String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";

  static final String strConn =
      "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Mydb";

     // "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:/information.mdb";

  public DBConnection(String user, String password) {
    this.db_user = user;
    this.db_password = password;

  }

  // 獲取數據庫連接;
  public Connection getConnection() throws SQLException {
    DBConnection.loadDriver();


    return java.sql.DriverManager.getConnection(this.strConn, this.db_user,
                                                this.db_password);
  }

  /**
   * 加載 JDBC-ODBC驅動
   * @return String
   */
  private static String loadDriver() {
    String sErr = "";
    try {
       Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      /*java.sql.DriverManager.registerDriver( (java.sql.Driver) (Class
          .forName(DBDriver).newInstance()));*/
    }
    catch (Exception e) {
      sErr = e.toString();
    }
    return (sErr);
  }

  // 關閉數據庫連接
  public static void close(Connection conn) {
    try {
      conn.close();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }
}