Question: (20 Marks)
You are required to write a program in java that will have three classes i.e. Person, Student and Driver.
1. Person will be the super / parent class and it will have four data members i.e. CNIC, Name, Date of Birth and Address. Person class will have a parameterized constructor (that will initialize all the data members with the given values) along with getters and setters for each data member that will get and set the values of data members of the class.
2. Student will be the child class and it will be inherited from Person class. It will have three data members i.e. Student ID, Study Program and Email. Student class will also have a parameterized constructor (that will initialize all the data members with the given values), getters and setters for each data member (that will get and set the values of data members of the class).
3. In Driver class, you’ll design a graphical user interface (GUI) that will have various text fields (like CNIC, Name, Date of Birth, Address, Student ID, Study Program and Email) and two buttons i.e. “Save Record” and “Retrieve Record”.
When user clicks “Save Record” button then take all the values entered by user in text fields and initialize an object of Student class with these values. Now, pass this object to “saveRecord” method and store all these values in MS ACCESS database (the name of database must be same as your own VU ID i.e. BC00000000.accdb).
And, when user clicks on “Retrieve Record” button then ask user to enter Student ID or CNIC (using JOptionPane.showInputDialog). Now, search this ID/CNIC in the database. If this ID/CNIC exists in database then display all information against this ID/CNIC (by using JOptionPane.showMessageDialog). Otherwise, show message that no such record exists in database against this ID/CNIC.
You also have to handle exceptions properly in your program.
After completing your code, execute your java file(s) on command prompt and enter students’ records to store them in database (the name of database must be same as your own VU ID i.e. BC00000000.accdb). You must have to provide your own information while entering first student’s record otherwise marks will be deducted accordingly. Your database must contain at least one record (containing your own information i.e. your name, id, study program and etc.). Now, compress your java file(s) and database file using winzip or winrar and upload it on VULMS.