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:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/BookStore_MSAccess.mdb";


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

  // 獲取數據庫連接;
  public Connection getConnection() throws SQLException {
    try {
      Class.forName("org.gjt.mm.mysql.Driver");
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }

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

  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);
  }

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