python tkinter mysql实现订房信息管理:该功能可以让用户管理酒店客房的订房信息,包括订房管理、退房管理和订房情况查询等实例代码
时间: 2024-03-25 11:36:40 浏览: 11
很高兴回答你的问题!以下是一个基于 Python tkinter 和 MySQL 的订房信息管理系统的实例代码。
首先,需要安装 tkinter 和 mysql-connector-python 库。
订房管理:
```python
import tkinter as tk
import mysql.connector as mysql
# 连接 MySQL 数据库
db = mysql.connect(
host="localhost",
user="root",
password="password",
database="hotel"
)
# 创建 tkinter 窗口
window = tk.Tk()
window.title("订房管理")
# 创建标签和输入框
tk.Label(window, text="客房号:").grid(row=0, column=0)
room_number = tk.Entry(window)
room_number.grid(row=0, column=1)
tk.Label(window, text="入住日期:").grid(row=1, column=0)
checkin_date = tk.Entry(window)
checkin_date.grid(row=1, column=1)
tk.Label(window, text="离店日期:").grid(row=2, column=0)
checkout_date = tk.Entry(window)
checkout_date.grid(row=2, column=1)
# 创建函数,将订房信息插入数据库
def book_room():
cursor = db.cursor()
query = "INSERT INTO bookings (room_number, checkin_date, checkout_date) VALUES (%s, %s, %s)"
values = (room_number.get(), checkin_date.get(), checkout_date.get())
cursor.execute(query, values)
db.commit()
cursor.close()
tk.messagebox.showinfo("订房成功", "订房信息已保存!")
# 创建按钮,点击后调用 book_room 函数
tk.Button(window, text="订房", command=book_room).grid(row=3, column=0, columnspan=2)
# 运行 tkinter 窗口
window.mainloop()
```
退房管理:
```python
import tkinter as tk
import mysql.connector as mysql
# 连接 MySQL 数据库
db = mysql.connect(
host="localhost",
user="root",
password="password",
database="hotel"
)
# 创建 tkinter 窗口
window = tk.Tk()
window.title("退房管理")
# 创建标签和输入框
tk.Label(window, text="客房号:").grid(row=0, column=0)
room_number = tk.Entry(window)
room_number.grid(row=0, column=1)
# 创建函数,将退房信息从数据库中删除
def checkout():
cursor = db.cursor()
query = "DELETE FROM bookings WHERE room_number = %s"
values = (room_number.get(),)
cursor.execute(query, values)
db.commit()
cursor.close()
tk.messagebox.showinfo("退房成功", "退房信息已删除!")
# 创建按钮,点击后调用 checkout 函数
tk.Button(window, text="退房", command=checkout).grid(row=1, column=0, columnspan=2)
# 运行 tkinter 窗口
window.mainloop()
```
订房情况查询:
```python
import tkinter as tk
import mysql.connector as mysql
# 连接 MySQL 数据库
db = mysql.connect(
host="localhost",
user="root",
password="password",
database="hotel"
)
# 创建 tkinter 窗口
window = tk.Tk()
window.title("订房情况查询")
# 创建标签和输入框
tk.Label(window, text="客房号:").grid(row=0, column=0)
room_number = tk.Entry(window)
room_number.grid(row=0, column=1)
# 创建函数,查询指定客房号的订房信息
def search():
cursor = db.cursor()
query = "SELECT * FROM bookings WHERE room_number = %s"
values = (room_number.get(),)
cursor.execute(query, values)
result = cursor.fetchall()
cursor.close()
if len(result) > 0:
# 如果有订房信息,显示在窗口中
for i, row in enumerate(result):
tk.Label(window, text=row).grid(row=i+1, column=0, columnspan=2)
else:
tk.messagebox.showinfo("查询结果", "没有找到订房信息!")
# 创建按钮,点击后调用 search 函数
tk.Button(window, text="查询", command=search).grid(row=1, column=0, columnspan=2)
# 运行 tkinter 窗口
window.mainloop()
```
以上是一个简单的订房信息管理系统的实例代码,你可以根据自己的需求进行修改和扩展。