Best Perfume Shop Management Using Java & JSP

Project Overview

Key Features of the System

Guest / User Features

1. 1. Register and login with email

   2. Browse perfume products by category

   3. Add, update, or remove items in cart

   4. Checkout and complete orders

   5. View order history and order details

   6. Search products and view product ratings

   7. Subscribe to newsletters for updates

Admin Panel Features

1. 1. Add or update perfume products

   2. Manage product categories

   3. View and manage customer accounts

   4. Order management with status updates

   5. Send promotional emails

   6. View sales statistics

Technologies Used

Frontend

• • JSP pages for UI

  • HTML, CSS, JavaScript for interactive features

  • Bootstrap for responsive design

  • jQuery and Ajax for dynamic updates

Backend

• • Java Servlets for request handling

  • JDBC to connect with SQL Server

  • MVC2 architecture for clean separation of code

Database

• • SQL Server for storing products, users, orders, and more

Step-by-Step Installation Guide

1. Set Up Development Tools

Install:

• 1. Java JDK 8 or later

  2. Apache Tomcat Server

  3. SQL Server Management Studio

  4. NetBeans or VS Code

2. Import Project

• 1. Open the project in NetBeans or your preferred Java IDE.

3. Database Configuration

1. 1. Open SQL Server

   2. Create the database using the provided script

   3. Update database connection settings in your Servlet configuration

      String url = "jdbc:sqlserver://localhost;databaseName=PerfumeDB";
      String user = "your_username";
      String pass = "your_password";
      

4. Run with Tomcat

1. http://localhost:8080/perfume-shop

A Perfume Shop Management System is more than an assignment — it’s a project that teaches you real web application principles. When you explain this in your viva or interview, it instantly shows depth of understanding. Take the time to structure your documentation clearly and highlight the user journeys.