Write a Java GUI application that will keep track of student results at a local college and
Question:
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.
Expert Answer:
CODE FOR MYSQL DATABASE create database StudentResult use StudentResult create table ResultTable StudentNumber int primary key HighestResult float LowestResult float Average float Now our mysql databa... View the full answer
