/*
 * @author Ram Vakada
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.PreparedStatement;

public class DatabaseConnection {
    //
    // If you want to use you ODBC DSN
    //
    //private static final String URL = "jdbc:odbc:TestDB";

    private final String USERNAME = "";
    private final String PASSWORD = "";
    private final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
    private Connection conn = null;

    private final String URL =
        "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=E:\\Ram10E\\ExamRoomRandomizer\\db.accdb";

    public DatabaseConnection() {
        initiateConnection();
    }

    public void initiateConnection() {
        try {
            Class.forName(DRIVER);
            conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
            System.out.println("Connection to database established.");
        } catch (Exception e) {
            System.out.println("Exception at initiateConnection() - " +e);
        }
    }

    public Connection getConnection() {
        return conn;
    }

    public void closeConnection() {
            try {
            conn.close();
            } catch (Exception e) {
                System.out.println("Exception at initiateConnection() - " +e);
            }
            System.out.println("Database connection closed.");
    }
}