ou need to use Java to connect with the mysql and create a simple mysql system. Databases "POS" have 4 tables 1. Staff_Info Staff_ID Staff_Name Staff_Pw Staff_Title 001 AA 1111 Manager 002 BB 2222 General Once the pos system opened, you need to ask the staff to enter the password. The manager can see the payment record if needed, which the general staff cannot. Food_Info Food_ID Food_Cat Food_Name Price 001 burger Classic burger 32 002 burger Chicken burger 38 003 side Fires 10 004 side Salad 15 005 beverage Coke 5 006 beverage Lemon Tea 8 There are only three categories of food, and 6 in total. Order_Info Order_ID Payment_ID Order_Item Order_Quantity Order_ID and Payment_ID should be automatically generated from 0001. Payment_Info Payment_ID Payment_Amount Payment_Date Payment_Time Payment_Method There are two types of Payment_Method which is Cash and Credit Card. Payment_Date and Payment_Time should be record automatically. Payment_Amount should automatically aggregate the entire order. Only need the java code, no need to show the mysql code, thanks.
You need to use Java to connect with the mysql and create a simple mysql system.
1. Staff_Info
|
Staff_ID |
Staff_Name |
Staff_Pw |
Staff_Title |
|
|
001 |
AA |
1111 |
Manager |
|
|
002 |
BB |
2222 |
General |
Once the pos system opened, you need to ask the staff to enter the password. The manager can see the payment record if needed, which the general staff cannot.
Food_Info
|
Food_ID |
Food_Cat |
Food_Name |
Price |
|
001 |
burger |
Classic burger |
32 |
|
002 |
burger |
Chicken burger |
38 |
|
003 |
side |
Fires |
10 |
|
004 |
side |
Salad |
15 |
|
005 |
beverage |
Coke |
5 |
|
006 |
beverage |
Lemon Tea |
8 |
There are only three categories of food, and 6 in total.
Order_Info
|
Order_ID |
Payment_ID |
Order_Item |
Order_Quantity |
Order_ID and Payment_ID should be automatically generated from 0001.
Payment_Info
|
Payment_ID |
Payment_Amount |
Payment_Date |
Payment_Time |
Payment_Method |
There are two types of Payment_Method which is Cash and Credit Card.
Payment_Date and Payment_Time should be record automatically.
Payment_Amount should automatically aggregate the entire order.
Only need the java code, no need to show the mysql code, thanks.
Step by step
Solved in 2 steps with 1 images
