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 his marks.

1

On the form create a list box that will allow the user to select the student ID populate populate from the text file. Also create a search button when 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.

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 marks result

3

Load the data from the student.txt file and populate the list box with the student numbers

4

Calculate the average result obtained by the student.

5

Determine the highest and lowest result that the student obtained from the three assessments

6

Create a database using SQL/MySql. The database should be named StudentResult only 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

Sample Student Text File: 10111 A verage Result: 72.67 % 10112 students.bt - Notepad 10113 Highest Result: 88.0 % File Edit Format View Help 10111 35 55 75 10112 Lowest Result: 55.0 % 30 30 30 10113 Search Save 75 55 88