All Projects and their specifications
Important Note:
All projects should include input validation, styling for better look and feel, and comprehensive
demonstration with queries of modules during the demo session. The code implementation
should follow best practices, including using prepared statements, exception handling, and MVC
architecture principles.
• Validation of all input fields should be incorporated
• Look and feel should be good
• All modules should be demonstrated with response to the queries and explained by
individual student in the demo session
• Use Dynamic web project to perform these operations with HTML and JSP along with
JDBC connectivity with MySQL as backend.
Employee Salary Management
Develop a Project in Java for Employee database with Employee table ( Empno,EmpName,DoJ,
Gender, Bsalary) to generate the modules namely EmpAdd, EmpUpdate, EmpDelete and
EmpDisplay along with Main module performing the operations of adding record, updating the
record, deleting the record and display the record based on the primary key Empno. Use
Dynamic web project to perform these operations with HTML and JSP along with JDBC
connectivity with MySQL as backend. Define complete structure of the project with modules and
packages.
Reports: The following reports have to be incorporated in the project
Employees whose names start with a specific letter
Employees with N or more years of service
Employees earning more than a specified salary
Project Specification and its structure
CREATE TABLE Employee (
Empno INT PRIMARY KEY,
EmpName VARCHAR(100),
DoJ DATE,
Gender VARCHAR(10),
Bsalary DECIMAL(10,2)
);
Project Structure
EmployeeWebApp/
├── WebContent/
│ ├── index.jsp
│ ├── empadd.jsp
│ ├── empupdate.jsp
│ ├── empdelete.jsp
│ ├── empdisplay.jsp
│ ├── reports.jsp <-- New page for reports
│ ├── report_form.jsp <-- Form to select report criteria
│ └── report_result.jsp <-- Display report results
├── src/
│ ├── com/
│ ├── dao/
│ │ └── EmployeeDAO.java
│ ├── model/
│ │ └── Employee.java
│ └── servlet/
│ ├── AddEmployeeServlet.java
│ ├── UpdateEmployeeServlet.java
│ ├── DeleteEmployeeServlet.java
│ ├── DisplayEmployeeServlet.java
│ ├── ReportServlet.java <-- servlet for reports
│ └── ReportCriteriaServlet.java <-- To handle report form submissions
└── WEB-INF/
└── web.xml
Mark Management System
Project Purpose:
To manage student examination marks, including adding, updating, deleting, and displaying student
marks, along with generating reports such as students with marks above a certain threshold, students
scoring in a specific subject, and top scorers.
Database Structure:
CREATE TABLE StudentMarks (
StudentID INT PRIMARY KEY,
StudentName VARCHAR(100),
Subject VARCHAR(50),
Marks INT,
ExamDate DATE
);
Modules & Functionalities:
MarkAdd: Add new student marks
MarkUpdate: Update existing marks
MarkDelete: Remove student records
MarkDisplay: Show all records or search by StudentID
Reports:
Students with marks above a specified value
Students who scored in a specific subject
Top N students based on marks
Project Structure:
MarkWebApp/
├── WebContent/
│ ├── index.jsp
│ ├── markadd.jsp
│ ├── markupdate.jsp
│ ├── markdelete.jsp
│ ├── markdisplay.jsp
│ ├── reports.jsp
│ ├── report_form.jsp
│ └── report_result.jsp
├── src/
│ ├── com/
│ ├── dao/
│ │ └── MarkDAO.java
│ ├── model/
│ │ └── StudentMark.java
│ └── servlet/
│ ├── AddMarkServlet.java
│ ├── UpdateMarkServlet.java
│ ├── DeleteMarkServlet.java
│ ├── DisplayMarksServlet.java
│ ├── ReportServlet.java
│ └── ReportCriteriaServlet.java
└── WEB-INF/web.xml
Product Management System
Project Purpose:
To manage product inventory, including adding new products, updating details, deleting obsolete
products, and viewing product lists. Reports include products with price above a certain amount,
products in a specific category, and top-selling products.
Database Structure:
CREATE TABLE Products (
ProductID INT PRIMARY KEY,
ProductName VARCHAR(100),
Category VARCHAR(50),
Price DECIMAL(10,2),
Quantity INT
);
Modules & Functionalities:
ProductAdd: Add new products
ProductUpdate: Update product details
ProductDelete: Remove products
ProductDisplay: List all products
Reports:
Products with price greater than a value
Products in a specific category
Top N products by sales or quantity
Project Structure:
ProductWebApp/
├── WebContent/
│ ├── index.jsp
│ ├── productadd.jsp
│ ├── productupdate.jsp
│ ├── productdelete.jsp
│ ├── productdisplay.jsp
│ ├── reports.jsp
│ ├── report_form.jsp
│ └── report_result.jsp
├── src/
│ ├── com/
│ ├── dao/
│ │ └── ProductDAO.java
│ ├── model/
│ │ └── Product.java
│ └── servlet/
│ ├── AddProductServlet.java
│ ├── UpdateProductServlet.java
│ ├── DeleteProductServlet.java
│ ├── DisplayProductsServlet.java
│ ├── ReportServlet.java
│ └── ReportCriteriaServlet.java
└── WEB-INF/web.xml
Hostel Management System
Project Purpose:
To manage hostel student admissions, room allocations, and fee payments. Functional modules include
adding student details, updating records, deleting students, and viewing current occupancy. Reports
include students with pending fees, students in a particular room, and students admitted in a specific
period.
Database Structure:
CREATE TABLE HostelStudents (
StudentID INT PRIMARY KEY,
StudentName VARCHAR(100),
RoomNumber VARCHAR(10),
AdmissionDate DATE,
FeesPaid DECIMAL(10,2),
PendingFees DECIMAL(10,2)
);
Modules & Functionalities:
StudentAdd: Register new students
StudentUpdate: Update student info
StudentDelete: Remove students
StudentDisplay: View all or individual student info
Reports:
Students with pending fees
Students in a particular room
Students admitted in a date range
Project Structure:
HostelWebApp/
├── WebContent/
│ ├── index.jsp
│ ├── studentadd.jsp
│ ├── studentupdate.jsp
│ ├── studentdelete.jsp
│ ├── studentdisplay.jsp
│ ├── reports.jsp
│ ├── report_form.jsp
│ └── report_result.jsp
├── src/
│ ├── com/
│ ├── dao/
│ │ └── HostelDAO.java
│ ├── model/
│ │ └── Student.java
│ └── servlet/
│ ├── AddStudentServlet.java
│ ├── UpdateStudentServlet.java
│ ├── DeleteStudentServlet.java
│ ├── DisplayStudentsServlet.java
│ ├── ReportServlet.java
│ └── ReportCriteriaServlet.java
└── WEB-INF/web.xml
Hotel Management System
Project Purpose:
To manage hotel reservations, room availability, and billing. Modules include adding reservations,
updating bookings, cancelling reservations, and viewing current occupancy. Reports include rooms
booked in a date range, revenue generated, and reservations by customer.
Database Structure:
CREATE TABLE Reservations (
ReservationID INT PRIMARY KEY,
CustomerName VARCHAR(100),
RoomNumber VARCHAR(10),
CheckIn DATE,
CheckOut DATE,
TotalAmount DECIMAL(10,2)
);
Modules & Functionalities:
ReservationAdd: Book new reservations
ReservationUpdate: Change reservation details
ReservationDelete: Cancel reservations
ReservationDisplay: View all reservations
Reports:
Reservations in a date range
Rooms booked most frequently
Total revenue over a period
Project Structure:
HotelWebApp/
├── WebContent/
│ ├── index.jsp
│ ├── reservationadd.jsp
│ ├── reservationupdate.jsp
│ ├── reservationdelete.jsp
│ ├── reservationdisplay.jsp
│ ├── reports.jsp
│ ├── report_form.jsp
│ └── report_result.jsp
├── src/
│ ├── com/
│ ├── dao/
│ │ └── ReservationDAO.java
│ ├── model/
│ │ └── Reservation.java
│ └── servlet/
│ ├── AddReservationServlet.java
│ ├── UpdateReservationServlet.java
│ ├── DeleteReservationServlet.java
│ ├── DisplayReservationsServlet.java
│ ├── ReportServlet.java
│ └── ReportCriteriaServlet.java
└── WEB-INF/web.xml
Hospital Management System
Project Purpose:
To administer patient records, doctor assignments, and appointment scheduling. Modules include
adding patient info, updating records, deleting records, and viewing patient details. Reports include
patients admitted in a date range, patients with specific ailments, and patients assigned to specific
doctors.
Database Structure:
CREATE TABLE Patients (
PatientID INT PRIMARY KEY,
PatientName VARCHAR(100),
Age INT,
Gender VARCHAR(10),
AdmissionDate DATE,
Ailment VARCHAR(255),
AssignedDoctor VARCHAR(100)
);
Modules & Functionalities:
PatientAdd: Register new patients
PatientUpdate: Update patient info
PatientDelete: Remove patient records
PatientDisplay: View all patient data
Reports:
Patients admitted in a date range
Patients with a specific ailment
Patients assigned to a specific doctor
Project Structure:
HospitalWebApp/
├── WebContent/
│ ├── index.jsp
│ ├── patientadd.jsp
│ ├── patientupdate.jsp
│ ├── patientdelete.jsp
│ ├── patientdisplay.jsp
│ ├── reports.jsp
│ ├── report_form.jsp
│ └── report_result.jsp
├── src/
│ ├── com/
│ ├── dao/
│ │ └── HospitalDAO.java
│ ├── model/
│ │ └── Patient.java
│ └── servlet/
│ ├── AddPatientServlet.java
│ ├── UpdatePatientServlet.java
│ ├── DeletePatientServlet.java
│ ├── DisplayPatientsServlet.java
│ ├── ReportServlet.java
│ └── ReportCriteriaServlet.java
└── WEB-INF/web.xml
College Fee Payment System
Project Purpose:
To manage student fee payments, including fee collection, updates, and payment history. Modules
include adding fee payments, updating payments, deleting records, and viewing payment history.
Reports include students who haven't paid, students with overdue payments, and total collections in a
period.
Database Structure:
CREATE TABLE FeePayments (
PaymentID INT PRIMARY KEY AUTO_INCREMENT,
StudentID INT,
StudentName VARCHAR(100),
PaymentDate DATE,
Amount DECIMAL(10,2),
Status VARCHAR(20) -- e.g., Paid, Overdue
);
Modules & Functionalities:
FeeAdd: Record new fee payment
FeeUpdate: Update payment info
FeeDelete: Remove payment records
FeeDisplay: View all payment records
Reports:
Students with overdue payments
Students who haven't paid in a period
Total fee collection over a date range
Project Structure:
CollegeFeeWebApp/
├── WebContent/
│ ├── index.jsp
│ ├── feepaymentadd.jsp
│ ├── feepaymentupdate.jsp
│ ├── feepaymentdelete.jsp
│ ├── feepaymentdisplay.jsp
│ ├── reports.jsp
│ ├── report_form.jsp
│ └── report_result.jsp
├── src/
│ ├── com/
│ ├── dao/
│ │ └── FeePaymentDAO.java
│ ├── model/
│ │ └── FeePayment.java
│ └── servlet/
│ ├── AddFeePaymentServlet.java
│ ├── UpdateFeePaymentServlet.java
│ ├── DeleteFeePaymentServlet.java
│ ├── DisplayFeePaymentsServlet.java
│ ├── ReportServlet.java
│ └── ReportCriteriaServlet.java
└── WEB-INF/web.xml
