Java Hotel Reservation System (JavaFX)

This project is a desktop hotel reservation system built with JavaFX and backed by a MySQL database accessed via JDBC. Front-desk staff can search for available rooms by date range and room type, check guests in, and generate a bill on check-out.

The application uses JavaFX FXML for the UI layout (room grid, booking form, billing screen) and a DAO (Data Access Object) pattern to separate database logic from the UI controllers, making the code easier to test and maintain.

Room status (Available, Occupied, Under Maintenance) is reflected live on a colour-coded room grid, and a simple reporting screen shows daily occupancy and revenue using JDBC aggregate queries.

Detailed Project Description

Java Hotel Reservation System (JavaFX) digitises the day-to-day records and workflows of an organisation so data is stored once, retrieved instantly and reported accurately.

How It Works
1. Role-based login separates admin, staff and end users.
2. Each module (records, bookings, transactions, reports) provides full CRUD operations with validation.
3. Data lives in a relational database with proper relationships between entities.
4. Reports and search views summarise the stored information.

Technology Roles
- Java
- JavaFX
- JDBC
- MySQL
- FXML

Implementation Steps
1. Define requirements and draw the ER / class diagram and screen flow.
2. Set up the environment (JDK, JavaFX SDK, MySQL Connector/J) and create the project skeleton.
3. Design the database schema / data model and seed it with sample data.
4. Implement the core modules with validation and role-based access where needed.
5. Build the user interface and connect it to the backend / data layer.
6. Test each module (unit + manual), fix edge cases and secure inputs (SQL injection, XSS, auth).
7. Prepare documentation, screenshots and a demo build.

Key Features
- Role-based access
- CRUD modules
- Search and filters
- Reports / export
- Validation and error handling

Expected Output
On completion the student will have a multi-user application with organised records and printable/exportable reports.

Deliverables
- Complete source code with comments
- Database schema / data model and screen flow
- Project report with screenshots and results
- Demonstration-ready build