🏨 Hotel Management System

A robust desktop-based application designed to streamline daily hotel operations, from guest management to billing and staff administration.

---

📖 Description

This Hotel Management System is a desktop application developed using Java (Swing) and MySQL. It provides an intuitive interface for hotel staff to manage room records, customer details, and employee data efficiently. The system automates the checkout process, handles billing calculations, and ensures secure access through role-based logins.

✨ Key Features

🔐 Security & Access

• Role-Based Login: Secure authentication with distinct portals for Admin and Regular Users.

🏨 Operations Management

• Room Management: Add new rooms, update status (Cleaned/Occupied), and search availability.
• Customer Management: seamless check-in process to add customer details and allocate rooms.
• Checkout & Billing:
  • Automatic calculation of pending amounts.
  • Support for extra service charges (Mini-bar, Laundry, etc.).
  • Updates room status instantly upon checkout.

👥 Staff Administration

• Employee Records: View, search, and manage details for all hotel staff.
• Driver Management: dedicated module to track and manage hotel driver information.

---

🛠️ Tech Stack & Prerequisites

Before running the application, ensure you have the following installed:

• Java Development Kit (JDK): Version 8 or higher.
• Database: MySQL Server.
• Libraries (Jars):
  • mysql-connector-java-8.0.28.jar (For Database Connectivity)
  • rs2xml.jar (For rendering DB tables in Java Swing)

---

🚀 Setup & Installation

Follow these steps to get the project running on your local machine.

1. Database Setup

1. Open your MySQL Command Line or MySQL Workbench.
2. Copy the content of the database.sql file provided in this repository.
3. Execute the script to create the database and tables.

2. Project ConfigurationClone the Repository:

1. Clone the Repository

Bashgit clone [https://github.com/your-username/hotel-management-system.git](https://github.com/your-username/hotel-management-system.git)

2. Open the project in your preferred IDE (IntelliJ, Eclipse, or NetBeans)
3. Add Libraries:

• Add mysql-connector-java and rs2xml to your project's Build Path / External Libraries.

3. Database Connection

Open src/hotel/management/system/connects.java (or your specific connection file) and update the credentials:

c = DriverManager.getConnection("jdbc:mysql:///hotelmanagementsystem", "YOUR_USERNAME", "YOUR_PASSWORD");

🎮 How to Run

1. Navigate to the main class file.
2. Run the application.
3. Use the Default Credentials below to test the role-based access:RoleUsernamePasswordAdminTomTomUserJerryJerry

🤝 Contributions

Contributions, https://www.google.com/search?q=issues, and feature requests are welcome!Feel free to check the issues page if you want to contribute.

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/NewFeature)
3. Commit your Changes (git commit -m 'Add some NewFeature')
4. Push to the Branch (git push origin feature/NewFeature)
5. Open a Pull Request