Using Jcreator and mySQL, with a graphical user interface. The program should make use of either pull down menu or the features defined in the class JTabbedPane() to organize the interface. Add Customer
This panel should allow users to enter all the particulars about a customer. Customer data should be validated before save to the Customer table in the database.Delete Customer
This panel is used to delete a customer record. The user will be asked to enter the cust_no to be deleted. If the cust_no does not exist, the program must display appropriate message. If it exists, then the record will be deleted.Search Customer
This panel allows the user to search for a customer record. If the cust_no does not exist, the program must display appropriate message. If the cust_no exists, then the record will be displayed.Update Customer
This panel should allow users to update the particulars about a customer. A search feature should be in place so that users can view the customer’s data to be modified.
Purchase Product
This panel will allow users to buy products from this company. No payment settlement is required, but the total amount of a purchase must be calculated and updated to the customer table.
Before purchasing, the Product_available in the product table must be checked. After a product is purchased, the field must be updated accordingly.Search Customer
This panel allows the user to search for a customer record. If the cust_no does not exist, the program must display appropriate message. If the cust_no exists, then the record will be displayed.Update Customer
This panel should allow users to update the particulars about a customer. A search feature should be in place so that users can view the customer’s data to be modified.
Purchase Product
This panel will allow users to buy products from this company. No payment settlement is required, but the total amount of a purchase must be calculated and updated to the customer table.
Before purchasing, the Product_available in the product table must be checked. After a product is purchased, the field must be updated accordingly.
Product Table:Field Name Format
Product_no Text
Product_desc Text
Unit_price Text
Product_available Number
Category TextCustomer Table:Field name Format
Cust_name Text
Cust_no Text
Contact_no Text
Total_amt Double
This panel should allow users to enter all the particulars about a customer. Customer data should be validated before save to the Customer table in the database.Delete Customer
This panel is used to delete a customer record. The user will be asked to enter the cust_no to be deleted. If the cust_no does not exist, the program must display appropriate message. If it exists, then the record will be deleted.Search Customer
This panel allows the user to search for a customer record. If the cust_no does not exist, the program must display appropriate message. If the cust_no exists, then the record will be displayed.Update Customer
This panel should allow users to update the particulars about a customer. A search feature should be in place so that users can view the customer’s data to be modified.
Purchase Product
This panel will allow users to buy products from this company. No payment settlement is required, but the total amount of a purchase must be calculated and updated to the customer table.
Before purchasing, the Product_available in the product table must be checked. After a product is purchased, the field must be updated accordingly.Search Customer
This panel allows the user to search for a customer record. If the cust_no does not exist, the program must display appropriate message. If the cust_no exists, then the record will be displayed.Update Customer
This panel should allow users to update the particulars about a customer. A search feature should be in place so that users can view the customer’s data to be modified.
Purchase Product
This panel will allow users to buy products from this company. No payment settlement is required, but the total amount of a purchase must be calculated and updated to the customer table.
Before purchasing, the Product_available in the product table must be checked. After a product is purchased, the field must be updated accordingly.
Product Table:Field Name Format
Product_no Text
Product_desc Text
Unit_price Text
Product_available Number
Category TextCustomer Table:Field name Format
Cust_name Text
Cust_no Text
Contact_no Text
Total_amt Double
If what you want is just asking somebody to do the work which should be done by yourself,please go away.....