K-Merch Inventory Management

K-Merch Inventory is a web-based inventory management application designed for a K-Pop merchandise store. It allows administrators to organize merchandise, monitor stock quantities, update product information, and identify items with low stock.

Managing merchandise inventory manually can make it difficult to maintain accurate stock information and identify products that need to be restocked. Product data may also become inconsistent when it is stored across separate documents or records.

K-Merch Inventory provides a centralized web application for storing merchandise information and managing stock. It supports product management operations and automatically displays notifications when an item's stock falls below the defined threshold.

1. JSP pages provide the user interface
2. Jakarta Servlets process HTTP requests
3. The Item model represents merchandise data
4. The DAO layer handles database operations
5. JDBC connects the application to MySQL
6. MySQL stores merchandise and inventory data
7. Maven manages dependencies and builds the WAR package
8. Apache Tomcat deploys and runs the application

• Integrating Java Servlets and JSP with a MySQL database
• Managing image uploads and product image paths
• Keeping inventory data synchronized after stock updates
• Implementing low-stock detection and notifications
• Deploying the application as a WAR package on Apache Tomcat
• Managing form data across multiple CRUD operations

• Move database credentials to environment variables
• Add administrator authentication and authorization
• Improve server-side input validation
• Prevent stock quantities from becoming negative
• Add search
• filtering
• sorting
• and pagination
• Add product categories and transaction history
• Create a responsive mobile-friendly interface
• Store uploaded images in persistent cloud storage
• Add automated tests
• Deploy the application to a public hosting platform