Hotel Management System | Shyam Sunder Kumar

PROJECT_OVERVIEW

🏨

Full Hotel Operations

Covers end-to-end hotel workflows — from guest check-in to check-out, room assignment, service billing, and final invoice generation. Every major operational task is handled from one unified desktop interface.

🗄️

Oracle RDBMS Backend

All data — customer records, room inventory, booking history, billing — is persisted in Oracle Database via JDBC. Proper relational schema design ensures data integrity and query efficiency.

🖥️

Java Swing GUI

Built entirely with Java Swing and AWT — a native desktop application requiring no web server or browser. Offers familiar form-based UI for hotel staff with structured data entry and display panels.

📋

Report Generation

Generates detailed booking and billing reports on demand. Admins can query reservation history, view room availability, and export structured summaries for record keeping.

SYSTEM_CONSOLE

HotelManagementSystem.java :: Runtime Log

$> javac -cp .;ojdbc8.jar HotelManagementSystem.java

Compilation successful — 0 errors, 0 warnings

$> java -cp .;ojdbc8.jar HotelManagementSystem

// ─── Initializing HMS v1.0 ───────────────────────────────

[ OK ] Loading Oracle JDBC Driver ... oracle.jdbc.OracleDriver

[ OK ] Connecting to DB ... jdbc:oracle:thin:@localhost:1521:XE

[ OK ] Connection established ✔ SUCCESS

[ OK ] Loading Swing UI ... javax.swing.JFrame

[ OK ] Initializing modules:

✔ LoginModule

✔ RoomBookingModule

✔ CustomerRecordModule

✔ BillingModule

✔ ReportGenerationModule

[ INFO ] Hotel HMS System Ready — 8 Panels Loaded

[ INFO ] Active rooms: 42 Occupied: 18 Available: 24

hms>

KEY_FEATURES

USER LOGIN SYSTEM

Secure authentication screen validates credentials against Oracle DB before granting access.

ROOM BOOKING & MANAGEMENT

Assign rooms to guests by type and availability, record check-in/check-out dates, and track occupancy in real time.

CUSTOMER RECORD MANAGEMENT

Maintains a complete database of guest details. Full CRUD operations on all customer records.

AUTOMATED BILLING

Calculates total charges based on room type, duration of stay, and any additional services.

REPORT GENERATION

Produces structured reports on occupancy, revenue, and customer activity for any date range.

ORACLE DB INTEGRATION

All operations use JDBC to interact with Oracle XE — full persistence and data reliability across sessions.

SYSTEM_ARCHITECTURE

PRESENTATION LAYER — Java Swing / AWT

JFrame · JPanel · JTable · JTextField · JButton · JLabel

↕

BUSINESS LOGIC LAYER — Java Classes

LoginController · BookingController · BillingController · ReportController

↕

JDBC LAYER

ojdbc8.jar · Connection Pool

SQL QUERIES

SELECT · INSERT · UPDATE · DELETE

TRANSACTIONS

Commit · Rollback · Constraints

↕

DATA LAYER — Oracle RDBMS (XE)

ROOMS · CUSTOMERS · BOOKINGS · BILLING · REPORTS tables

TECH_STACK

☕ JAVA SE

Core Language

🪟 SWING

GUI Framework

🎨 AWT

UI Components

🗄️ ORACLE XE

RDBMS Database

🔌 JDBC

DB Connectivity

📦 ojdbc8

Oracle JDBC Driver

🏗️ OOP

Design Paradigm

📐 SQL

Query Language

DATABASE_SCHEMA

Oracle SQL :: Schema Design

-- ── HOTEL MANAGEMENT SYSTEM :: ORACLE SCHEMA ──────────────

CREATE TABLE ROOMS (

ROOM_ID NUMBER PRIMARY KEY,

ROOM_NO VARCHAR2(10) NOT NULL UNIQUE,

ROOM_TYPE VARCHAR2(20), -- SINGLE/DOUBLE/SUITE

PRICE NUMBER(8,2),

STATUS VARCHAR2(15) DEFAULT 'AVAILABLE'

);

CREATE TABLE BOOKINGS (

BOOKING_ID NUMBER PRIMARY KEY,

CUST_ID NUMBER REFERENCES CUSTOMERS(CUST_ID),

ROOM_ID NUMBER REFERENCES ROOMS(ROOM_ID),

CHECK_IN DATE NOT NULL,

STATUS VARCHAR2(15) DEFAULT 'ACTIVE'

);

HOW_IT_WORKS

Step 01

STAFF LOGIN

The application opens with a login screen. Staff enter credentials which are validated against the Oracle Users table via JDBC.

Step 02

ROOM ASSIGNMENT

Staff browse available rooms filtered by type. Selecting a room opens the booking form where guest details and dates are entered.

Step 03

CUSTOMER RECORD ENTRY

Guest personal details are captured and stored in the CUSTOMERS table, linked to the booking via foreign key.

Step 04

CHECKOUT & BILLING

On checkout, the system calculates the bill based on room rate × nights stayed. An itemized invoice is generated and saved.

Step 05

REPORT GENERATION

Admin can generate occupancy and revenue reports for any date range with aggregation functions.

PROJECT_GALLERY

⊕

// Control Panel — Main Dashboard

⊕

// Login Screen — Staff Auth

⊕

// Customer Registration Panel

⊕

// Room Management Panel

⊕

// Order Management Panel

⊕

// Item / Menu Panel

⊕

// Payment & Billing Screen

⊕

// Testing UI / QA Screen

PROJECT_DOCUMENTATION

📄

// BCA_PROJECT_REPORT

COMPLETE PROJECT DOCUMENTATION

Full project report — includes system design, ER diagrams, module descriptions, data flow diagrams, Oracle schema design, and implementation details submitted as BCA academic coursework.

📄 VIEW FULL REPORT (PDF) ⌥ GITHUB REPO