Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

java program GUI(Formatting is not important!) based program that will Add, Modify and delete information from customer table.(Make sure that table in the database and

java program GUI(Formatting is not important!) based program that will Add, Modify and delete information from customer table.(Make sure that table in the database and attributes of the customer table are CustID(Key field),Cust Name,Cust Categ_ID,Amount Due and Expiry _Date.When the user enters the CustID for modifying data and hits the enter key(or clicks the search button)the program should bring up the current contents of the customer and allow the user to modify the information.if the amount due is above 100 or if the expiry date is past,update the status messages appropriately..A customer can be deleted only after his record is found.A customer cannot be added if the expiry date is prior to todays date and amount due is above 100.The gui shows the customer category description from the customer table in a dropdownlist/combo box.when the customer chooses a category description from the customer table in a drop down list/combo box.When the customer chooses a category description while adding or updating,the corresponding Cust_Categ_ID IS used for populating the customer table.The Category table has two fields Cust_Categ_ID is used for populating the customer table.The Category table has two fields Cust_Categ_ID and Cust_Categ_Description .Only the appropriate buttons should be enabled the rest should be disabled.if the user enters a CustID that does not currently exist in the customer table.the Add button should be enabled the rest should be disabled.if the user enters a CustID that doesnot currently exist in the Customer Table.Add

button should be enabled and all category should be loaded for selection.however if a record exists the delete and update button should be enabled and appropriate actions take place

Step by Step Solution

There are 3 Steps involved in it

Step: 1

1 Libraries Java import javaxswing For GUI components import javaawtevent For event listeners import javautilArrayList For storing category descriptions Import additional libraries for database connec... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems analysis and design

Authors: kenneth e. kendall, julie e. kendall

8th Edition

135094909, 013608916X, 9780135094907, 978-0136089162

More Books

Students also viewed these Programming questions

Question

Describe major criticisms of Freuds system of thought.

Answered: 1 week ago

Question

Develop a decision tree for the situation in Problem 14.

Answered: 1 week ago

Question

List the five steps in interview preparation.

Answered: 1 week ago

Question

Why should questions on similar topics be clustered together?

Answered: 1 week ago