Solved–Exercise 5 –Solution

Description

Problem
Refer to the [AddressBook] database and related programs in Chapter 24 of the textbook, [Java How to Program, 10th Edition]. Modify the database and programs in the Chapter to:

1. Provide a JButton that allows the user to call a method updatePerson in PersonQueries class to update the current entry in the database;
2. Provide a JButton that allows the user to call a mehod deletePerson in PersonQueries class to delete the current entry in the database
3. Add State as an attribute to the database and fill-in the new column using appropriate data;
4. Provide a JLabel and JtextField allow display of the State information;
5. Provide a SQL query and appropriate GUI component to search the database by State.