I have to write a Attendance Module for a school. I am using Java Swing to design the screens.
When user click on attendance tab of JTabbedPane
, two buttons are there:
1) Add Attendance 2) Display Attendance
Here to add attendance user have to select Class from JCombobox and Date from JDateChooser.
Then JTable will display id and student Names available in that particular class. Following shows columnnames in jtable.
StudentId | NAme | 1stDay | 2nd Day |....... |31stDay | No.Of Present days
I can add daywise attendance successfully.I am using only one table StudentAttendanceTable in Oracle.Here User has to choose class and month,year to see attendance.Now I am getting list of attendance records in particular month bt how to display attendance of particuar day in that particular column of JTable?
I hope you are getting my point.
Just give me a way to sort attendance daywise and display it it JTable
, so that when user must see attendance of all students from class and month he selects.