Question
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started