public AssistantPromotion() {
        
        initComponents();
        DatabaseConnection db = new DatabaseConnection();
        Connection conn = db.connectToDB();

        String[] studentList = null;
        String[] assistantList = null;
        
        String sql = "Select COUNT(Username) as totalCount From `HD_Accounts` where Permission = 0";
        ResultSet resultCount = db.getResults(conn, sql);
        try {
            if(resultCount.next())
            {
                int count = resultCount.getInt("totalCount");
                studentList = new String[count];
                try {
                    int i=0;

                    sql = "Select Username From `HD_Accounts` where Permission = 0";
                    ResultSet rs = db.getResults(conn, sql);
                    while(rs.next())
                    {
                        studentList[i] = rs.getString("Username");
                        i++;
                    }
                } catch (SQLException ex) {
                    Logger.getLogger(AssistantPromotion.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        } catch (SQLException ex) {
            Logger.getLogger(AssistantPromotion.class.getName()).log(Level.SEVERE, null, ex);
        }
        
        
        sql = "Select COUNT(Username) as totalCount From `HD_Accounts` where Permission = 1";
        resultCount = db.getResults(conn, sql);
        try {
            if(resultCount.next())
            {
                int count = resultCount.getInt("totalCount");
                assistantList = new String[count];
                try {
                    int i=0;
                    
                    sql = "Select Username From `HD_Accounts` where Permission = 1";
                    ResultSet rs = db.getResults(conn, sql);
                    
                    while(rs.next())
                    {
                        assistantList[i] = rs.getString("Username");
                        i++;
                    }
                } catch (SQLException ex) {
                    Logger.getLogger(AssistantPromotion.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        } catch (SQLException ex) {
            Logger.getLogger(AssistantPromotion.class.getName()).log(Level.SEVERE, null, ex);
        }
        
        
        allStudentList.setListData(studentList);
        allAssistantsList.setListData(assistantList);
        
    }