public class DBManager {

      public HashMap<String, Staff> loadStaff()
    {
        HashMap<String, Staff> staff = new HashMap<String, Staff>();

        try
        {
            Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
            Connection conn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\Ryan\\Desktop\\Graded Unit\\PaRkEaSyPrOjEcT\\ParkEasyAirportParking\\lib\\BookingDB.accdb");

            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM Staff");

            while(rs.next())
            {

                String firstName = rs.getString("FirstName");
                String lastName = rs.getString("LastName");
                String password = rs.getString("Password");
                String phoneNumber = rs.getString("PhoneNumber");
                String mobileNumber = rs.getString("MobileNumber");
                String email = rs.getString("Email");
                String postcode = rs.getString("PostCode");
                String town = rs.getString("Town");
                String street = rs.getString("Street");
                String houseNo = rs.getString("HouseNo");
                int staffID = rs.getInt("StaffID");
                boolean isStaff = rs.getBoolean("IsStaff");

                Staff s = new Staff(staffID, isStaff, firstName, lastName, password, phoneNumber, mobileNumber, email, postcode, town, street, houseNo);
                staff.put(email, s);
            }
            return staff;
        }
        catch(Exception ex)
        {
            return staff;
        }
    }

    public HashMap<String, Customer> loadCustomers()
    {
        HashMap<String, Customer> cust = new HashMap<String, Customer>();

        try
        {
            Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
            Connection conn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\Ryan\\Desktop\\Graded Unit\\PaRkEaSyPrOjEcT\\ParkEasyAirportParking\\lib\\BookingDB.accdb");

            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM Customers");

            while(rs.next())
            {
                int customerID = rs.getInt("CustomerID");
                String firstName = rs.getString("FirstName");
                String lastName = rs.getString("LastName");
                String password = rs.getString("Password");
                String phoneNumber = rs.getString("PhoneNumber");
                String mobileNumber = rs.getString("MobileNumber");
                String email = rs.getString("Email");
                String postcode = rs.getString("PostCode");
                String town = rs.getString("Town");
                String street = rs.getString("Street");
                String houseNo = rs.getString("HouseNo");

                Customer c = new Customer(customerID, firstName, lastName, password, phoneNumber, mobileNumber, email, postcode, town, street, houseNo);
                cust.put(email, c);
            }
            return cust;
        }
        catch(Exception ex)
        {
            return cust;
        }
    }