Advertisement
Guest User

Untitled

a guest
May 16th, 2018
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.26 KB | None | 0 0
  1.       public HashMap<String, Staff> loadStaff()
  2.     {
  3.         HashMap<String, Staff> staff = new HashMap<String, Staff>();
  4.        
  5.         try
  6.         {
  7.             Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
  8.             Connection conn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\Ryan\\Desktop\\Graded Unit\\PaRkEaSyPrOjEcT\\ParkEasyAirportParking\\lib\\BookingDB.accdb");
  9.        
  10.             Statement stmt = conn.createStatement();
  11.             ResultSet rs = stmt.executeQuery("SELECT * FROM Staff");
  12.            
  13.             while(rs.next())
  14.             {                
  15.                 String firstName = rs.getString("FirstName");
  16.                 String lastName = rs.getString("LastName");
  17.                 String password = rs.getString("Password");
  18.                 String phoneNumber = rs.getString("PhoneNumber");
  19.                 String mobileNumber = rs.getString("MobileNumber");
  20.                 String email = rs.getString("Email");
  21.                 String postcode = rs.getString("PostCode");
  22.                 String town = rs.getString("Town");
  23.                 String street = rs.getString("Street");
  24.                 String houseNo = rs.getString("HouseNo");
  25.                 int staffID = rs.getInt("StaffID");
  26.                 boolean isStaff = rs.getBoolean("IsStaff");
  27.                
  28.                 Staff s = new Staff(staffID, isStaff, firstName, lastName, password, phoneNumber, mobileNumber, email, postcode, town, street, houseNo);
  29.                 staff.put(email, s);
  30.             }
  31.             return staff;
  32.         }
  33.         catch(Exception ex)
  34.         {
  35.             return staff;
  36.         }      
  37.     }
  38.      
  39.     public HashMap<String, Customer> loadCustomers()
  40.     {
  41.         HashMap<String, Customer> cust = new HashMap<String, Customer>();
  42.        
  43.         try
  44.         {
  45.             Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
  46.             Connection conn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\Ryan\\Desktop\\Graded Unit\\PaRkEaSyPrOjEcT\\ParkEasyAirportParking\\lib\\BookingDB.accdb");
  47.        
  48.             Statement stmt = conn.createStatement();
  49.             ResultSet rs = stmt.executeQuery("SELECT * FROM Customers");
  50.            
  51.             while(rs.next())
  52.             {
  53.                 int customerID = rs.getInt("CustomerID");
  54.                 String firstName = rs.getString("FirstName");
  55.                 String lastName = rs.getString("LastName");
  56.                 String password = rs.getString("Password");
  57.                 String phoneNumber = rs.getString("PhoneNumber");
  58.                 String mobileNumber = rs.getString("MobileNumber");
  59.                 String email = rs.getString("Email");
  60.                 String postcode = rs.getString("PostCode");
  61.                 String town = rs.getString("Town");
  62.                 String street = rs.getString("Street");
  63.                 String houseNo = rs.getString("HouseNo");
  64.                
  65.                 Customer c = new Customer(customerID, firstName, lastName, password, phoneNumber, mobileNumber, email, postcode, town, street, houseNo);
  66.                 cust.put(email, c);
  67.             }
  68.             return cust;
  69.         }
  70.         catch(Exception ex)
  71.         {
  72.             return cust;
  73.         }      
  74.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement