Create a Super Market Billing Console Application using Java, JDBC, and MySQL that handles multiple customers and products, generates bills for purchases, creates or logs in customer profiles, and updates customer profiles and product information after purchases.
The Supermarket Billing Application is designed to manage
- Customer Billing
- Tracking Products
- Customer Information
- Billing Details.
- Updating Products
- Billing Section (Customer)
- Display All Bills of a Particular Customer (Admin)
- Display Product Availability (Admin)
- Display All Bills on a Particular Date (Admin)
- Insert / Update Product (Admin)
Purpose:
- This module manages the interaction with customers during the billing process.
Functionality:
- Prompts the user to either log into an existing account or create a new account if the user is new.
- Allows the customer to select products and specify quantities.
- Generates a bill based on the selected products and quantities and displays the final bill to the customer.
Purpose:
- This module retrieves and displays the billing history of a specific customer.
Functionality:
- Prompts for the customer's credentials.
- Fetches and displays all past bills associated with the customer from the database.
Purpose:
- This module provides the DB admin with information about the current stock of products.
Functionality:
- Shows the list of products available in the store, along with their remaining quantities and prices.
Purpose:
- This module retrieves and displays all bills generated on a specific date.
Functionality:
- Prompts for a specific date.
- Fetches and displays all bills generated on that date from the database.
Purpose:
- This module allows the DB admin to manage the products in the store.
Functionality:
- Allows the admin to add new products to the 'Product' table.
- Allows the admin to update details of existing products in the 'Product' table, such as price and quantity.
