Java Programming

Exercise Four:

10.In the controller package, create a class named Controller.

11. In the Controller class, create a static method named insertRecord, that accepts an Employee object as argument and insert the data in the object, into the employees table of the jdbclabtest database.

12. In the Controller class create another method named retrieveRecord which accepts an employees ID number as argument. The ID number is to be used to query the employees table of the jdbclabtest database. If a record is found in the database, the data is to be displayed at the console. If a record is not found, the method is to display Record not found, at the console.

13. In the Controller class create another method named updateRecord which accepts an employees ID number, and a String representing an employees street address as arguments. The arguments are to be used to locate and update an employees record in the employees table in the jdbclabtest database.

14. In the Controller class create another method named deleteRecord which accepts an employees ID number as argument. The ID number is to be used to query the employees table of the jdbclabtest database. If a record is found with a matching employee ID number, that record is to be deleted from the database.