📦 Inventory Management System

🚀 About the Project

This project is a robust, desktop-based Inventory Management System developed using the Java programming language. It is designed to automate and simplify inventory control for small to medium-sized businesses, replacing error-prone manual tracking methods. The system provides accurate, real-time information on stock levels to prevent overstocking or stock-outs and generates bills directly in PDF format.

🛠️ Technology Stack

• Programming Language: Java
• IDE: Apache NetBeans (Version 20)
• Database: MySQL (WAMP / MySQL Workbench)
• Connectivity: JDBC Driver
• PDF Generation: iTextPDF Library

✨ Key Features & Modules

The application consists of 9 highly integrated modules:

• Secure Authentication: A Login Form that authenticates personnel using their email and password.
• Interactive Dashboard: A Home Page where users can access features, and easily add, remove, or update data.
• User Management: Admins can seamlessly add new faculty/users and update existing personnel details.
• Category Management: Dynamically create new product categories and update previous ones.
• Product Control: Add detailed product information including Name, Quantity, Price, Description, and Category.
• Customer Directory: Maintain a digital record of customers by adding new clients or updating existing contact details.
• Order Processing & PDF Billing: Manage new orders, calculate real time sub-totals, and instantly generate downloadable Order Bills in PDF format.
• Order History: View comprehensive records of previous orders and access their historical bills.

📸 Application Screenshots

1. Secure Login Interface

(Authentication gateway for personnel access)

---

2. Main Dashboard & Navigation

(Intuitive interface for seamless module access)

---

3. User & Customer Management

(Maintain digital records with full CRUD capabilities)

---

4. Category & Product Control

(Organize and track inventory stock efficiently)

---

5. Order Processing & View History

(Manage new orders, calculate sub-totals, and review past transactions)

---

6. Secure Logout

🗄️ Database Architecture

The backend is structured efficiently using MySQL with the following core tables:

1. appuser (Login & User Info)
2. category
3. product
4. customer
5. orderDetail

🎯 Conclusion

By leveraging the power of Java and the NetBeans IDE, this system effectively optimizes business operations, providing a solid and scalable foundation for any organization aiming to improve its efficiency, accuracy, and overall profitability.