Inventory Management System (Java Web Application)

Overview

The Inventory Management System is a web-based application developed using Java, JSP, Servlets, and MySQL. The system helps administrators manage products, suppliers, purchases, and sales through a structured and user-friendly interface.

This project demonstrates full-stack Java web development using NetBeans and Apache Tomcat, including database connectivity, CRUD operations, and dashboard-based data management.

The system is designed to simulate a real-world business inventory environment with organized product tracking and transaction management.

Technologies Used

| Technology | Purpose | | -| | | Java | Backend Development | | JSP | Dynamic Web Pages | | Servlets | Request Handling | | MySQL | Database | | JDBC | Database Connectivity | | HTML | Page Structure | | CSS | Styling | | Apache Tomcat | Application Server | | NetBeans IDE | Development Environment |

Key Features

• Admin Login System
• Product Management
• Supplier Management
• Purchase Management
• Sales Management
• Dashboard Overview
• Profit Calculation
• Database Integration
• Full CRUD Operations
• Structured Data Management

System Modules

1. Authentication Module

• Secure Login System
• MySQL Database Verification
• Session Management

2. Product Management

Features:

• Add Products
• Update Products
• Delete Products
• View Product List

Each product record contains:

• Product Name
• Category
• Price
• Quantity
• Supplier

3. Supplier Management

Features:

• Add Suppliers
• Update Supplier Information
• Delete Suppliers
• View Suppliers

Supplier data includes:

• Supplier Name
• Contact Details
• Address

4. Purchase Management

Features:

• Record Purchases
• Update Stock Automatically
• Track Purchase History

5. Sales Management

Features:

• Record Sales
• Update Inventory
• Calculate Profit

6. Dashboard

Dashboard displays:

• Total Products
• Total Suppliers
• Total Purchases
• Total Sales
• Profit Summary

System Architecture

The system follows a three-tier architecture:

Client Browser → JSP Pages → Servlets → MySQL Database

• JSP handles frontend display
• Servlets handle business logic
• MySQL stores data

Project Structure

JAVA_PROJECT
│
├── src
│   ├── database
│   ├── servlets
│   └── models
│
├── web
│   ├── css
│   ├── images
│   ├── login.jsp
│   ├── dashboard.jsp
│   ├── products.jsp
│   ├── suppliers.jsp
│   ├── purchases.jsp
│   └── sales.jsp
│
├── nbproject
├── build.xml
└── README.md

Database Design

Users Table

| Column | Type | | -| | | id | INT | | username | VARCHAR(50) | | password | VARCHAR(100) |

Products Table

| Column | Type | | -| | | id | INT | | name | VARCHAR(100) | | category | VARCHAR(50) | | price | DOUBLE | | quantity | INT | | supplier_id | INT |

Suppliers Table

| Column | Type | | -| | | id | INT | | name | VARCHAR(100) | | contact | VARCHAR(50) | | address | VARCHAR(200) |

Purchases Table

| Column | Type | | -| | | id | INT | | product_id | INT | | quantity | INT | | price | DOUBLE | | date | DATE |

Sales Table

| Column | Type | | -| | | id | INT | | product_id | INT | | quantity | INT | | price | DOUBLE | | date | DATE |

Installation and Setup

Step 1 — Requirements

Install:

• Java JDK 8 or later
• NetBeans IDE
• MySQL Server
• Apache Tomcat

Step 2 — Create Database

Create database:

inventory_db

Import tables using SQL scripts.

Step 3 — Configure Database Connection

Update database connection settings inside the project:

Example:

Database: inventory_db
Username: root
Password: yourpassword

Step 4 — Run Project

1 Open NetBeans
2 Open Project
3 Configure Tomcat Server
4 Run Project

Testing

The system was tested for:

• Login authentication
• Product operations
• Supplier operations
• Purchase records
• Sales records
• Profit calculation
• Database connectivity

All modules function correctly with proper database integration.

Skills Demonstrated

• Java Web Development
• JSP Programming
• Servlets Development
• JDBC Connectivity
• MySQL Database Design
• CRUD Operations
• MVC Architecture
• Session Management
• Backend Development

Software Used

• NetBeans IDE
• MySQL Server
• Apache Tomcat
• Java JDK

Future Improvements

• Role-based login
• Advanced reporting
• Export reports to PDF
• REST API support
• Improved UI design

Author

Yash Surve
Computer Science Student
Network Engineer & Software Developer