Tkinter Entry与Combobox同步及客户数据实时更新问题

核心思路是给Entry绑定触发事件（比如回车键），获取输入内容后，检查是否已在Combobox的选项中，若不存在则添加并更新Combobox的选项列表。

示例代码：

import tkinter as tk
from tkinter import ttk

root = tk.Tk()

# 输入框
input_entry = ttk.Entry(root, width=30)
input_entry.pack(pady=8)

# 下拉选择框
customer_combo = ttk.Combobox(root, values=["客户A", "客户B", "客户C"], width=28)
customer_combo.pack(pady=8)

def add_input_to_combo(event):
    input_val = input_entry.get().strip()
    # 空内容或已存在则不添加
    if not input_val or input_val in customer_combo["values"]:
        return
    # 更新下拉选项
    current_vals = list(customer_combo["values"])
    current_vals.append(input_val)
    customer_combo["values"] = tuple(current_vals)
    # 清空输入框
    input_entry.delete(0, tk.END)

# 绑定回车键触发添加
input_entry.bind("<Return>", add_input_to_combo)

root.mainloop()

两个核心需求：一是Customer表增改后，Sales表的客户选择组件实时更新；二是Entry输入的客户名既要写入数据库，也要同步到Combobox。

解决方案步骤： #

1. 封装数据库操作函数，用于增改Customer表、查询客户列表。
2. 每次完成Customer表的增/改操作后，立即从数据库重新拉取客户列表，更新Sales表对应的Combobox。
3. Entry输入的客户名先写入数据库，再触发Combobox刷新，确保数据一致性。

示例代码（基于pymysql）：

import tkinter as tk
from tkinter import ttk, messagebox
import pymysql

# 数据库配置，替换为你的实际信息
DB_SETTINGS = {
    "host": "localhost",
    "user": "your_username",
    "password": "your_password",
    "database": "your_database"
}

def get_db_conn():
    """获取数据库连接"""
    return pymysql.connect(**DB_SETTINGS)

def refresh_sales_customer_combo(combo):
    """从Customer表拉取最新客户列表，更新Combobox"""
    conn = get_db_conn()
    cursor = conn.cursor()
    try:
        cursor.execute("SELECT customer_name FROM Customer ORDER BY customer_name")
        customers = [row[0] for row in cursor.fetchall()]
        combo["values"] = tuple(customers)
    except Exception as e:
        messagebox.showerror("错误", f"加载客户列表失败: {str(e)}")
    finally:
        conn.close()

def add_customer(entry, sales_combo):
    """将Entry输入的客户名写入数据库并刷新Combobox"""
    customer_name = entry.get().strip()
    if not customer_name:
        messagebox.showwarning("提示", "请输入有效客户名")
        return
    
    conn = get_db_conn()
    cursor = conn.cursor()
    try:
        # 检查客户是否已存在
        cursor.execute("SELECT COUNT(*) FROM Customer WHERE customer_name = %s", (customer_name,))
        if cursor.fetchone()[0] > 0:
            messagebox.showinfo("提示", "该客户已存在")
            return
        
        # 插入新客户
        cursor.execute("INSERT INTO Customer (customer_name) VALUES (%s)", (customer_name,))
        conn.commit()
        messagebox.showinfo("成功", "客户添加成功")
        entry.delete(0, tk.END)
        # 刷新Sales表的客户选择框
        refresh_sales_customer_combo(sales_combo)
    except Exception as e:
        conn.rollback()
        messagebox.showerror("错误", f"添加客户失败: {str(e)}")
    finally:
        conn.close()

def edit_customer(customer_id, new_name, sales_combo):
    """编辑客户信息后刷新Combobox"""
    conn = get_db_conn()
    cursor = conn.cursor()
    try:
        cursor.execute("UPDATE Customer SET customer_name = %s WHERE id = %s", (new_name, customer_id))
        conn.commit()
        messagebox.showinfo("成功", "客户信息更新成功")
        refresh_sales_customer_combo(sales_combo)
    except Exception as e:
        conn.rollback()
        messagebox.showerror("错误", f"更新客户失败: {str(e)}")
    finally:
        conn.close()

# 主界面示例
root = tk.Tk()
root.title("客户管理与销售同步")

# 添加客户区域
add_frame = ttk.Frame(root, padding="10")
add_frame.pack(fill=tk.X)

ttk.Label(add_frame, text="新增客户:").pack(side=tk.LEFT, padx=5)
add_entry = ttk.Entry(add_frame, width=25)
add_entry.pack(side=tk.LEFT, padx=5)
add_btn = ttk.Button(add_frame, text="添加", command=lambda: add_customer(add_entry, sales_customer_combo))
add_btn.pack(side=tk.LEFT, padx=5)

# 销售单客户选择区域
sales_frame = ttk.Frame(root, padding="10")
sales_frame.pack(fill=tk.X)

ttk.Label(sales_frame, text="销售单客户:").pack(side=tk.LEFT, padx=5)
sales_customer_combo = ttk.Combobox(sales_frame, width=23)
sales_customer_combo.pack(side=tk.LEFT, padx=5)

# 初始化加载客户列表
refresh_sales_customer_combo(sales_customer_combo)

root.mainloop()

关键说明： #

• 每次增/改Customer表后，调用refresh_sales_customer_combo函数从数据库拉取最新数据，确保Sales表的客户选择框实时同步。
• Entry输入的客户名先写入数据库再刷新Combobox，避免仅在界面层添加导致重启后数据丢失，同时保证Sales表能关联到新客户。

内容的提问来源于stack exchange，提问作者Nesar Ahmad