Mess Management System

Online Live Project: http://mealndserv.in

---

About the Project

The Mess Management System is a web-based mini-project designed to efficiently handle day-to-day operations in a hostel or institutional mess. Built using Java, JDBC, and Servlets, this system provides both administrative and user-level functionalities to automate processes such as meal booking, monthly billing, inventory tracking, and staff management.

It offers a user-friendly interface for mess administrators to manage students, track attendance, generate bills, and maintain food inventory records. Students or users can register, log in, view menus, and check their meal history and dues.

Purpose of the Project

To digitize and streamline the operations of a hostel or institutional mess by managing student data, meal bookings, attendance, billing, and inventory efficiently. This project aims to reduce manual work, improve transparency, and ensure accurate meal tracking and cost management through an easy-to-use web-based system.

Project Modules

• Employee Module
  • Employee Details Added
  • Employee View
  • Employee Deleted
  • Update Employee
  • Search Employee
• Customer Module
  • Customer Added
  • Customer Viewed
  • Customer Searched
  • Customer Deleted
  • Update Customer
• Category Module
  • Category Added
  • Category Viewed
• Product Module
  • Product Added
  • Product View Page
  • Product Deleted
  • View Product
  • Category List
• Billing Module
  • Create Bill JSP Page
  • Save Orders on View Bill Page
  • View Bill Action

User Roles and Access

• Admin Functionalities
  • Register as Admin
  • Login as Admin
  • Create New Employee Registrations
  • Assign Employee Details Manually
  • View All Customers
  • View All Categories
  • View All Products
  • View All Orders/Bills
• Employee Functionalities
  • Login using Admin-provided credentials
  • Add New Customers
  • Add New Categories
  • Add New Products
  • Add New Orders

Technologies Used

• Java (Servlets)
• JDBC
• MySQL Database
• JSP/HTML/CSS
• JavaScript (for validation – under development)

Software and Tools Required

• Git and GitHub Account
• Java JDK 8+
• Eclipse EE IDE
• Apache Maven
• Tomcat v8.0+
• MySQL Server
• MySQL Workbench (optional)

Dummy Database Initialization

1. Open MySQL Command Prompt or MySQL Workbench
2. Login to the MySQL Workbench (enter username/password)
3. Select all queries in the SQL file and run them

FAQ

Q1: Unable to Connect to Database?

Check MySQL installation and DB credentials in application.properties. Try Maven clean install, update project, and restart.

Q2: Getting 404 (Page Not Found)?

Update Project Facets: Dynamic Web Module: 5.0, Java: 17. Also, apply the runtime as Apache Tomcat 10.0.1.

---

"Suggestions and project improvement ideas are welcomed!"

Thanks a lot,
Project Leader
Dattatray Bodake