2022/5/2 23:40 Course Schedule - CSCV 335 SP22 101-102 201 http61/2 CSCV 335 SP22 101-102 201 Next 14 days A-12 MVC & JDBC Final Project - 

Due Tasks Add a task... A-12 MVC & JDBC Final Project - Due May

 7, 2022 11:59 PM CSCV 335 SP22 101-102 201 CSCV 335 Final Project - MVC & JDBC 300 points: The program Contact_Book_JDBC.java is mostly complete, but you need to help finish it. Please make the following changes to it: 1. Combine the updatePhone and updateEmail methods in the Model class into one generic method. You can easily accomplish this because the only difference between them is the value of their procedureCallString variables. You will need to change the View and Controller classes to replace references to updatePhone and updateEmail with references to the new method. 2. Add a method to the Model class for finding all contacts. I've added stubs named findAllContacts to the View and Controller classes and provided a stored procedure named sp_select_all_contacts. Make sure that the stubs are complete. 3. Add a method to the Model class for finding all contacts by s://d2l.arizona.edu/d2l/le/calendar/1108379/event/5377166/detailsview#53771 6 202 CSCV 335 SP22 101-102 201 https://d2l.arizona.edu/d2l/le/calendar/1108379/event/5377166/detailsview#5377166 2/2 2/5/2 23:40 Course Schedule - contact type. I've added stubs named findContactsByType to the View and Controller classes and provided a stored procedure named sp_select_contacts_for_type. Make sure that these stubs are complete. The View method will need more work to obtain the value of the contactType. 4. Add a method to the Model class for deleting a contact using its contact_no as a search criterion. I've added stubs named deleteContact to the View and Controller classes. Make sure that these stubs are complete. I've provided a stored procedure named sp_delete_contact. It accepts a contact_no as a parameter. The View class method will need to display the contact_no to the user so she can select the one to delete. The updatePhone and Email methods demonstrate how to do this. 5. Create an addNewContact method that uses JDBC to insert a row for a new contact. I've provided a stored procedure named sp_add_new_contact. The sample program JdbcDemo2.java actually has the code for using this procedure. The sample programs JdbcDemo1.java and JdbcDemo2.java should help with this. A-12 MVC & JDBC Final Project Due May 7 at 11:59 PM