public void getStudents(String courseID) throws Exception {
        String sql;
        PreparedStatement st;
        ResultSet rs;

        Connection db = ConnectionUtils.getConnection();
        
        //String student_ID = UserLogin.id;
        
        // get the student information
        sql = "select course.crs_ID, course.crs_name, student.student_ID, "
                + "student.first_name, student.last_name FROM course, student, "
                + "section, enrollment where course.crs_ID =? AND course.crs_ID "
                + "= section.crs_ID AND	section.section_ID = "
                + "enrollment.section_ID AND enrollment.student_ID = "
                + "student.student_ID;";
        
        
        st = db.prepareStatement(sql);
        st.setString(1, courseID);
        rs = st.executeQuery();
        if (!rs.next()) {
            throw new IllegalArgumentException("invalid course id");
        }
        ResultSetMetaData rsmd = rs.getMetaData();
        
        courses = new String[rsmd.getColumnCount()][2];
        
        setColumns(rsmd.getColumnCount());
        
        String tempID = "";
        String tempfirst = "";
        String templast = "";
        
        tempID = rs.getString(3);//student id
            tempfirst = rs.getString(4);
            templast = rs.getString(5);
        
        int i = 0;
        courses[i][0] = tempID;//student id
        courses[i][1] = tempfirst + " " + templast;//name
        i++;
        while(rs.next())
        {
            tempID = rs.getString(3);//student id
            tempfirst = rs.getString(4);
            templast = rs.getString(5);
            
            courses[i][0] = tempID;//student id
            courses[i][1] = tempfirst + " " + templast;//name
            i++;
            //courses[i][2] = rs.getString(5);
        }
        
        rs.close();
        st.close();
        db.close();
    }