Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement