Python+mysql实现简单客房系统管理系统

import tkinter as tk
from tkinter import ttk
import pymssql

# 连接数据库
connect = pymssql.connect('LAPTOP-CIMJ8GTB', 'sa', '123456', 'hotel', charset='utf8', as_dict=True)
if connect:
print("连接成功!")

# 创建游标对象
cursor = connect.cursor()

# 创建主窗口
root = tk.Tk()
root.title("客房查询")

# 创建输入框和按钮
id_label = tk.Label(root, text="身份证：")
id_entry = tk.Entry(root)
name_label = tk.Label(root, text="姓名：")
name_entry = tk.Entry(root)
room_label = tk.Label(root, text="房间号：")
room_entry = tk.Entry(root)
insert_button = tk.Button(root, text="办理入住")

# 创建列表展示查询结果
treeview = tk.ttk.Treeview(root, columns=("room_no", "type", "price", "status", "