this is my W6 lab, I need this to be done with NetBeans please.
this is my W6 lab, I need this to be done with NetBeans please. thank you in advance.
CIS355A Week 6 Lab—Database ConnectivityOBJECTIVESProgrammatic access to a MySQL database to add and display recordsPROBLEM:Student Management SystemA teacher needs the ability to store and retrieve student data. This includesstudent name;three test scores;average; andletter grade.FUNCTIONAL REQUIREMENTSYou can code the GUI by hand or use NetBeans GUI builder interface.Create a GUI which allows for input and display of student data.It should include buttons to save a record, display all records.Create a database and table to store student name and three test scores. (Note thataverage and grade are calculated by app.)Student classCreate a Student class to manage the student data. It should have private instancevariables ofstudent name; andthree test scores.The class must have the following methods.A default and parameterized constructorSets/gets for all instance variablesA get method to calculate and return the averageA get method to calculate and return the letter gradetoString to display the name of the studentStudentDB classCreate a StudentDB class that is used to create a connection and interface with thedatabase.This class should have two methods.getAll—reads data from database, returns data in an arraylist ofstudent objectsadd—writes a record to the databaseGUI classInsert button will take the info from the GUI (student name and three test scores)and insert a record into the table.Input should be cleared from the textboxes.CIS355A Week 6 Lab InstrucTonsPage 1
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
