private void loadAllStaff(){//COMPLETE
        try {               
            ResultSet dbAllStaff = null;
            Statement statement;
            statement = connection.createStatement();
            dbAllStaff = statement.executeQuery( "SELECT Staff.staffID, Staff.role FROM Staff;");
            
            while(dbAllStaff.next())
            {
                User tempUser = null;
                for (int i=0; i<allUsers.size();i++){
                        if(allUsers.get(i).getUserID()==(dbAllStaff.getInt("staffID")))
                        {
                            tempUser = (allUsers.get(i));
                        }
                    }
                Staff newStaff = new Staff(tempUser, dbAllStaff.getString("role"));
                allStaff.addStaff(newStaff);
            }
            
            
        } catch (SQLException ex) {
            Logger.getLogger(testFrame3Tim.class.getName()).log(Level.SEVERE, null, ex);
        }
    }