🏨 Hotel Management System

A streamlined Hotel Management System that allows for efficient handling of hotel reservations and room management. Built using Java (JDBC), MySQL, and IntelliJ IDE, this project provides a clean command line interface for essential hotel operations.

✨ Features

• New Reservation: Easily create new room reservations.
• Check Reservation: Look up existing reservations by guest or room number.
• Get Room Number: Retrieve a specific room number linked to a reservation.
• Update Reservation: Modify reservation details seamlessly.
• Exit: Gracefully close the application.

🛠️ Technologies Used

• Java (JDBC): For backend logic and database connection.
• MySQL: As the database for storing reservation data.
• IntelliJ IDEA: The development environment used to build the project.

📂 Project Structure

📦 HotelManagementSystem
├── 📂 src
     ├── 📄 hotel_db.sql                        # Contains the sql queries required to make the databse.
     ├── 📄 HotelManangementSystem.java         # This is the acutual code file.

🔧 Configure your MySQL database settings in the HotelManagementSystem.java file:

private static final String url = "jdbc:mysql://localhost:3306/hotel_db";
private static final String username = "your_username";
private static final String password = "password";

📖 How to Use

1. Clone the Repository:

   git clone https://github.com/AnuprashGautam/Hotel-Management-System.git

2. Set Up the Database:

   • Create a MySQL database and configure the connection settings in hotel_db.sql.
   • Run the provided SQL script to set up the tables and initial data.

3. Run the Application:

   • Open the project in IntelliJ IDEA.
   • Compile and run HotelManagementSystem.java to start managing hotel reservations.

🚀 Future Enhancements

Consider adding the following features:

• Advanced Room Search: Filter rooms by amenities, availability, etc.
• Billing and Payments: Integrate a payment gateway.
• Customer Feedback: Allow customers to leave feedback.

---