Write a Java GUI application that will keep track of student results at a local college and save the process result into a database. The application must contain the result that a student has obtain for a test, assignment and exam.
Question 1
On the form create a
list boxthat will allow the user to select the student ID populate populate from the text file. Also create a
search buttonwhen clicked will display the average , highest and lowest result according to the student number and a
Save button
to save the result to an online data base. Student number should be used as a primary key for your database.
Question 2
Create a sequential file (
student.txt
) that contains data for the following fields
- The student ID number
- The student test result
- The student assignment result
- The student exam result
Question 3
Load the data from the
student.txtfile and populate the list box with the student numbers
Question 4
Calculate the average result obtained by the student.
Question 5
Determine the highest and lowest result that the student obtained from the three assessments
Question 6
Create a database using
SQL/MySql.
The database should be named
StudentResultonly include one table name it
ResultTable
. The result table should have 4 fields(
StudentNumber, HighestResult, LowestResult, and Average
). On your interface include a Save option to save the data in the
Result table.
Sample Output
Extracted text: Sample Student Text File: 10111 A verage Result: 72.67 % 10112 10113 students.bt - Notepad Fle Edit Fomat View Help 20111 35 Highest Result: 88.0 % Lowest Result: 55.0 % 55 75 10112 30 30 30 10113 75 Search Save 55 88