package informationsystem.database;

import java.sql.*;

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

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

  static final String strConn =
      "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;
  }

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

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

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

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