很高兴回答你的问题！以下是一个基于 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()
```
以上是一个简单的订房信息管理系统的实例代码，你可以根据自己的需求进行修改和扩展。
最低0.47元/天 解锁文章
1192
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
