Hi
I'm the new guy here and my question is as follows:
I'm currently working on a project to give students grades using a
java application and working with the ModelViewController design
pattern. Right now what I'm facing is a new page where I can manually edit a students grades (based off their studentID in the database). The idea is that I would have a database such as tableStudents(StudentID, Course, Grades(0-20)).
I'd like to get an editable table in the form where I can get the Course field and the Grades field (based on studentID which will be selectable from a list on the top of the page).
My first thought would be to use my database-access-class which has a "executeSelectCommand(
String query )" which returns a "ResultSet rs" that I can loop through. But I don't have the slightest idea of how to get that resultset into a table nor how to add the modified table back into the database.
The problem is I have only started learning java at the beginning of this semester so I'm quite new to Swing and it's components. Could anyone help me figure how to create an editable table in my form that can be written into the database?
Thank you in advance!