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
解决方案 »
- swing,JPanel中怎么按指定坐标添加多个矩形图
- 如何把rs,克隆一份放在ds中?
- 多线程访问静态变量 只获得值 不做改变变量操作 是否需要同步
- mail 问题?? 发给163信箱,正常,而发送新浪出现退信
- 请问如何在JPanel的上层Container中捕获JPanel中的事件
- 求jTree中取得子节点的int值,并能将新的node插入到节点下。
- Exception能不能自己定义错误号?
- 哪里有介绍iplanet application server 6.5的书呀
- 这个问题很难吗?我都问了两遍了?没人回答。那位高手帮帮忙?
- 关于JAVA SDK1.3的PATH和CLASSPATH在WIN2000中的设定
- 求助单例双重锁定的验证
- java小技巧共享(单例的惰性初始化)
LZ。f-u-c-k off