📦 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.