Customer data Management System (GUI)

Operation

This application begins by displaying a table of customer data.

If the user clicks the Add button, the application allows the user to add customer data to the table (and the underlying database).

If the user selects a customer row and clicks the Edit button, the application allows the user to update the data for the selected customer row in the table (and the database).

If the user selects a customer row and clicks the Delete button, the application deletes the selected customer row from the table (and the database).

Specifications

Create a tablein the mma database described in chapter 19to store the necessary data. To do that, you can use the SQL script stored in the create_customer_table.sql file thats supplied.

Create a class named Customerthat stores data for the users id, email address,first name, and last nameas instancevariables. Include a constructorfor the Customerclass which takes these four values as parameters to create an object. Create get and set methods for each of the four instance variables.

Create a class named CustomerDBthat contains the methods necessary to get an array list of Customer objects, to get a Customer objectfor the customer with the specified id, and to add, update, or deletethe specified customer. Other classes to support the data layer functions are allowed.

Create a CustomerManagerFrameclass like the one shown above. This frame should display a table of customer data as well as the Add, Edit, and Delete buttons. This class must use the Customer and CustomerDB classes to work with the customer data.

Create a CustomerTableModelclass for the JTablecontrol used in the CustomerManagerFrameclass.

Create a CustomerFormclass that allows the user to add or edit customer data.

Create a GUI Java Customer Management program with NetBeans that satisfies the specifications above.