0% found this document useful (1 vote)

540 views

Hotel Management System (Python Code)

The document shows sample Python source code for a hotel management system that connects to a MySQL database and allows users to add rooms, make reservations, and view available rooms and existing reservations through a menu-driven interface.

Uploaded by

Mayank Verma

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

0% found this document useful (1 vote)

540 views

Hotel Management System (Python Code)

Uploaded by

Mayank Verma

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

You are on page 1/ 9

Python Source Code

import mysql.connector

import pandas as pd

# Connect to the MySQL database

db = mysql.connector.connect(

host="localhost",

user="your_username",

password="your_password",

database="hotel_management"

# Create a cursor object to interact with the database

cursor = db.cursor()

# Create the tables for rooms and reservations

create_rooms_table = """

CREATE TABLE IF NOT EXISTS rooms (

room_id INT AUTO_INCREMENT PRIMARY KEY,

room_number INT NOT NULL,

room_type VARCHAR(255),

price DECIMAL(10, 2)
)

"""

create_reservations_table = """

CREATE TABLE IF NOT EXISTS reservations (

reservation_id INT AUTO_INCREMENT PRIMARY KEY,

room_id INT,

guest_name VARCHAR(255),

check_in DATE,

check_out DATE,

FOREIGN KEY (room_id) REFERENCES rooms(room_id)

"""

cursor.execute(create_rooms_table)

cursor.execute(create_reservations_table)

# Function to add a room to the database

def add_room(room_number, room_type, price):

insert_query = "INSERT INTO rooms (room_number, room_type, price) VALUES (%s, %s, %s)"

cursor.execute(insert_query, (room_number, room_type, price))

db.commit()

print(f"Room {room_number} added successfully.")

# Function to make a reservation

def make_reservation(room_id, guest_name, check_in, check_out):

insert_query = "INSERT INTO reservations (room_id, guest_name, check_in, check_out) VALUES (%s,
%s, %s, %s)"

cursor.execute(insert_query, (room_id, guest_name, check_in, check_out))

db.commit()

print(f"Reservation for Room {room_id} made successfully.")

# Function to display available rooms

def display_available_rooms():

select_query = "SELECT * FROM rooms WHERE room_id NOT IN (SELECT room_id FROM reservations
WHERE check_out >= CURDATE())"

cursor.execute(select_query)

rooms_data = cursor.fetchall()

if rooms_data:

rooms_df = pd.DataFrame(rooms_data, columns=["Room ID", "Room Number", "Room Type",

"Price"])

print(rooms_df)

else:

print("No available rooms.")

# Function to display reservations

def display_reservations():

select_query = "SELECT * FROM reservations"

cursor.execute(select_query)

reservations_data = cursor.fetchall()

if reservations_data:
reservations_df = pd.DataFrame(reservations_data, columns=["Reservation ID", "Room ID", "Guest
Name", "Check-in", "Check-out"])

print(reservations_df)

else:

print("No reservations found.")

# Main menu

while True:

print("\nHotel Management System")

print("1. Add Room")

print("2. Make Reservation")

print("3. Display Available Rooms")

print("4. Display Reservations")

print("5. Exit")

choice = input("Enter your choice: ")

if choice == "1":

room_number = int(input("Enter room number: "))

room_type = input("Enter room type: ")

price = float(input("Enter price per night: "))

add_room(room_number, room_type, price)

elif choice == "2":

display_available_rooms()

room_id = int(input("Enter the room ID you want to reserve: "))

guest_name = input("Enter guest name: ")

check_in = input("Enter check-in date (YYYY-MM-DD): ")

check_out = input("Enter check-out date (YYYY-MM-DD): ")

make_reservation(room_id, guest_name, check_in, check_out)

elif choice == "3":

display_available_rooms()

elif choice == "4":

display_reservations()

elif choice == "5":

print("Exiting the system.")

break

else:

print("Invalid choice. Please try again.")

# Close the database connection

db.close()

----------------------------------Completed----------completed-------------completed--------------------------------------
Output
Hotel management system
1. Add Room

2. Make Reservation

3. Display Available Rooms

4. Display Reservations

5. Exit

Enter your choice: 1

Enter room number: 101

Enter room type: Single

Enter price per night: 100.00

Room 101 added successfully.