if(e.getSource() == logOut){
            frame.setVisible(false);
            GUI g = new GUI();
        }

        else if(e.getSource() == requestUserList){
            userManagement.userList();

            String[] userColumnNames = {"User ID", "Username", "Password", "RoleID"};
            Object[][] object = (Object[][]) userManagement.getUserList();

            table = new JTable(object, userColumnNames);
            panel6.add(table);
            panel6.remove(requestUserList);
            panel6.add(refreshUserList);
            refreshUserList.addActionListener(this);
            frame.repaint();
        }

        else if(e.getSource() == refreshUserList){
            panel6.remove(table);
            userManagement.userList();

            String[] userColumnNames = {"User ID", "Username", "Password", "RoleID"};
            Object[][] object = (Object[][]) userManagement.getUserList();
            table = new JTable(object, userColumnNames);

            panel6();

            panel6.add(table);
            panel6.add(refreshUserList);
            refreshUserList.addActionListener(this);
            frame.repaint();
        }

        else if(e.getSource() == addUser){
            String username = jtfAddUsername.getText();
            String password = jtfAddPassword.getText();
            int admin = 0;
            if(isAdmin.getSelectedItem().equals("Admin")){
                admin = 1;
            }
            boolean userConfirmed = false;

            userManagement.addUser(username, password, userConfirmed, admin);
            userDropdown.addItem(userData);
            userDropdown.repaint();
        }

        else if(e.getSource() == deleteUser){
            userManagement.deleteUser();
            userDropdown.repaint();
        }

        else if(e.getSource() == deleteQuery){
            informationManagement.deleteQuery();
            queryDropdown.repaint();
            queryDropdown2.repaint();
        }

        else if(e.getSource() == editUser){
            panel6.removeAll();
            panel6.add(jlEditUsername);
            panel6.add(jtfEditUsername);
            panel6.add(jlEditPassword);
            panel6.add(jtfEditPassword);
            panel6.add(jlEditTypeAccount);
            panel6.add(isAdmin);
            panel6.add(updateUser);
            updateUser.addActionListener(this);
            panel6.add(back);
            back.addActionListener(this);
            for(int s=0;s<userData.length;s++){
                if(userData[s][1] == userDropdown2.getSelectedItem()){
                    jtfEditUsername.setText(userData[s][1].toString());
                    jtfEditPassword.setText(userData[s][2].toString());
                    if(Integer.parseInt(userData[s][0].toString()) == 0){
                        isAdmin.setSelectedItem("Gebruiker");
                    }
                }
            }
//          editIsAdmin.setSelectedIndex(userData[]);
            if(isAdmin.getSelectedItem().equals("Admin")){
                roleID = 1;
            }
            panel6.repaint();
        }
        else if(e.getSource() == editQuery){
            panel3.removeAll();
            panel3.add(jlEditQueryName);
            panel3.add(jtfEditQueryName);
            panel3.add(jlEditQuery);
            panel3.add(jtfEditQuery);
            panel3.add(updateQuery);
            updateQuery.addActionListener(this);
            panel3.add(back);
            back.addActionListener(this);
            for(int s=0;s<queryData.length;s++){
                if(queryData[s][2] == queryDropdown2.getSelectedItem()){
                    jtfEditQueryName.setText(queryData[s][2].toString());
                    jtfEditQuery.setText(queryData[s][1].toString());
                }
            }
            panel3.repaint();
        }
        else if(e.getSource() == updateQuery){
            informationManagement.editQuery(jtfEditQueryName.getText(), jtfEditQuery.getText());
        }
        else if(e.getSource() == updateUser){
            userManagement.editUser(jtfEditUsername.getText(), jtfEditPassword.getText(), roleID);
        }
        else if(e.getSource() == back){
            panel6.removeAll();
            panel3.removeAll();

            panel3();
            panel3.add(requestQuery);
            requestQuery.addActionListener(this);

            panel6();
            panel6.add(requestUserList);
            requestUserList.addActionListener(this);
            panel6.add(userDropdown);
            panel6.add(deleteUser);
            deleteUser.addActionListener(this);
            panel6.add(userDropdown2);
            editUser.addActionListener(this);
            panel6.add(editUser);

            userDropdown.repaint();
            userDropdown2.repaint();
            panel3.repaint();
            panel6.repaint();
        }

        // Actionlisteners voor de query's
        else if(e.getSource() == addQuery){
            informationManagement.addQuery();
        }
        else if(e.getSource() == runQuery){
            informationManagement.runQueryFunction();
        }
        else if(e.getSource() == requestQuery){
            informationManagement.requestQuery();

            String[] queryColumnNames = {"Query ID", "QueryName", "Query"};
            Object[][] object = (Object[][]) informationManagement.getQueryData();
            JTable table1 = new JTable(object, queryColumnNames);

            panel3.add(table1);
            panel3.remove(requestQuery);
            panel3.add(refreshQuery);
            refreshQuery.addActionListener(this);
            frame.repaint();
        }

        else if(e.getSource() == refreshQuery){
            informationManagement.requestQuery();

            String[] queryColumnNames = {"Query ID", "QueryName", "Query"};
            Object[][] object = (Object[][]) informationManagement.getQueryData();
            JTable table1 = new JTable(object, queryColumnNames);
            frame.repaint();
        }
            else if(e.getSource() == Backup){
            try {
                backup.setBackup();
            } catch (UnknownHostException ex) {
                Logger.getLogger(Beheerder.class.getName()).log(Level.SEVERE, null, ex);
            } catch (IOException ex) {
                Logger.getLogger(Beheerder.class.getName()).log(Level.SEVERE, null, ex);
            }
            }

        else if(e.getSource() == Restore){

        }
    }