在 Python 中，反斜杠 `\` 是转义字符，在字符串里如 `\U` 会被当作 Unicode 转义字符的起始部分，可能导致路径解析出错。为解决代码中因转义字符导致设置图标路径出错及图片无法正常显示的问题，可使用原始字符串或对反斜杠进行转义。 原始字符串是以 `r` 开头的字符串，其中的反斜杠不会被当作转义字符处理。以下是修改后的代码： ```python import tkinter as tk from tkinter import ttk from tkinter import messagebox import MySQLdb # 数据库连接配置 db_config = { 'host': '192.168.2.150', 'port': 3305, 'user': 'root', 'passwd': '300820', 'db': 'testdb' } # 创建数据库连接 def create_connection(): return MySQLdb.connect(**db_config) # 查询数据 def query_data(): keyword = query_entry.get() try: conn = create_connection() cur = conn.cursor() query_sql = f"SELECT * FROM user_test WHERE id = '{keyword}' OR name = '{keyword}' OR age = '{keyword}'" cur.execute(query_sql) rows = cur.fetchall() result_text.delete(1.0, tk.END) for row in rows: result_text.insert(tk.END, str(row) + '\n') cur.close() conn.close() except Exception as e: messagebox.showerror("错误提示", str(e)) # 插入数据 def insert_data(): id_num = id_entry.get() name = name_entry.get() age = age_entry.get() try: conn = create_connection() cur = conn.cursor() insert_sql = f"INSERT INTO user_test (id, name, age) VALUES ({id_num}, '{name}', {age})" cur.execute(insert_sql) conn.commit() cur.close() conn.close() messagebox.showinfo("提示信息", "数据插入成功!") query_data() except Exception as e: messagebox.showerror("错误提示", str(e)) # 更新数据 def update_data(): id_num = id_entry.get() name = name_entry.get() age = age_entry.get() try: conn = create_connection() cur = conn.cursor() update_sql = f"UPDATE user_test SET name = '{name}', age = {age} WHERE id = {id_num}" cur.execute(update_sql) conn.commit() cur.close() conn.close() messagebox.showinfo("提示信息", "数据更新成功!") query_data() except Exception as e: messagebox.showerror("错误提示", str(e)) # 删除数据 def delete_data(): id_num = id_entry.get() try: conn = create_connection() cur = conn.cursor() delete_sql = f"DELETE FROM user_test WHERE id = {id_num}" cur.execute(delete_sql) conn.commit() cur.close() conn.close() messagebox.showinfo("提示信息", "数据删除成功!") query_data() except Exception as e: messagebox.showerror("错误提示", str(e)) # 创建主窗口 root = tk.Tk() root.title("数据管理") # 标签和输入框 tk.Label(root, text="编号:").grid(row=0, column=0) id_entry = tk.Entry(root) id_entry.grid(row=0, column=1) tk.Label(root, text="姓名:").grid(row=1, column=0) name_entry = tk.Entry(root) name_entry.grid(row=1, column=1) tk.Label(root, text="年龄:").grid(row=2, column=0) age_entry = tk.Entry(root) age_entry.grid(row=2, column=1) # 查询输入框 tk.Label(root, text="查询关键字:").grid(row=3, column=0) query_entry = tk.Entry(root) query_entry.grid(row=3, column=1) # 按钮 query_button = tk.Button(root, text="查询", command=query_data) query_button.grid(row=4, column=0) insert_button = tk.Button(root, text="插入", command=insert_data) insert_button.grid(row=4, column=1) update_button = tk.Button(root, text="更新", command=update_data) update_button.grid(row=5, column=0) delete_button = tk.Button(root, text="删除", command=delete_data) delete_button.grid(row=5, column=1) # 结果显示框 result_text = tk.Text(root, height=10, width=50) result_text.grid(row=6, column=0, columnspan=2, sticky="nsew") root.grid_rowconfigure(6, weight=1) root.grid_columnconfigure(0, weight=1) root.grid_columnconfigure(1, weight=1) # 窗体左上角 logo 修改，使用原始字符串 root.iconbitmap(r"C:\Users\Administrator\Desktop\照片.png") # 添加 Sizegrip 小部件 sizegrip = ttk.Sizegrip(root) sizegrip.grid(row=7, column=1, sticky="se") # 运行主循环 root.mainloop() ```