The Arcade Exchange

Overview

The Arcade Exchange is a dynamic arcade game purchasing system built with Java, MySQL, and JDBC. It features real-time price updates, automated triggers for game price calculations, and a customer purchase history.

Features

1.Customer & Game Management: Add and view customers and games.
2.Real-Time Price Updates: Game prices change based on total purchases.
3.Purchase & Transaction History: Records of all transactions.
4.Stored Procedures & Triggers: Automate actions like updating prices and purchase counts.

Technologies Used

1.Java (Swing for GUI)
2.MySQL (Database management)
3.JDBC (Database connectivity)

Example Queries

Get All Customers:
SELECT * FROM Customer;

Generate Bill for a Customer:
CALL GenerateBill(<customer_id>, @total_bill);
SELECT @total_bill;

Future Enhancements

Customer Feedback
Game Categories
Discounts and Offers

License

MIT License