Tkinter应用中按Enter键执行SQL命令的故障求助

错误原因总结 #

• 事件回调参数缺失：tkinter绑定<Return>事件时，会自动传入一个event对象作为参数，你的entryBinding方法没有接收这个参数，触发类型错误。
• 组件布局冲突：自定义Entry和Label类中同时混用pack与grid布局，tkinter不允许同一组件使用两种布局方式，引发布局异常。
• Button命令绑定错误：command=self.executeCmds()是直接调用函数并返回结果，而非传递函数引用，应该传递函数本身（不带括号）。
• 重复布局调用：Label类的__init__里已调用grid，App中又重复调用，导致组件布局冲突。
• 未实现资源释放：Connection类的closeConnection方法为空，执行完SQL后未关闭游标和连接，造成资源泄漏。

修正后的完整代码 #

import mysql.connector
import customtkinter as ctk
from settings import *

class Connection:
    def __init__(self, username, password, host, database) -> None:
        self.host = host
        self.username = username
        self.password = password
        self.database = database
        self.myCon = None
        self.cursor = None

    def connectDb(self):
        try:
            self.myCon = mysql.connector.connect(
                user=self.username,
                host=self.host,
                password=self.password,
                database=self.database
            )
        except Exception as e:
            print(f"连接失败: {e}")

    def executeCmds(self, commands):
        if not self.myCon or not self.myCon.is_connected():
            print("数据库未连接，请先建立连接")
            return
        try:
            self.cursor = self.myCon.cursor()
            self.cursor.execute(commands)
            if commands.strip().lower().startswith('select'):
                for row in self.cursor.fetchall():
                    print(row)
            else:
                self.myCon.commit()
                print("命令执行成功")
        except Exception as e:
            print(f"执行失败: {e}")
        finally:
            if self.cursor:
                self.cursor.close()

    def closeConnection(self):
        if self.myCon and self.myCon.is_connected():
            self.myCon.close()

class App(ctk.CTk):
    def __init__(self):
        super().__init__(fg_color=WHITE)
        self.title('SQL Connector')
        self._set_appearance_mode('dark')
        self.geometry('600x400')
        self.minsize(400, 300)
        self.columnconfigure(index=(0, 1, 2, 3, 4), weight=1, uniform='a')
        self.rowconfigure(index=(0, 1, 2, 3, 4), weight=1, uniform='b')

        # Data
        self.entryVar = ctk.StringVar()
        self.labelVar = ctk.StringVar(value='SQL Connector')

        # widgets
        self.entry = Entry(self, entryVar=self.entryVar)
        self.entry.grid(row=2, column=1, columnspan=3, sticky='nsew', padx=10, pady=5)
        
        self.button = Button(self, '执行SQL命令')
        self.button.grid(row=3, column=1, columnspan=3, sticky='nsew', padx=10, pady=5)
        
        self.label = Label(self, self.labelVar)
        self.label.grid(row=4, column=1, columnspan=3, sticky='nsew', padx=10, pady=5)
        
        self.slide_btn = SlidePanelButton(self)
        self.slide_btn.grid(row=4, column=3, sticky='nsew')

        self.slider = SlidePanel(parent=self, startPos=0, endPos=-0.3)
        self.slider.place()

        # event binding
        self.entry.bind('<Return>', self.entryBinding)
        self.mainloop()

    def entryBinding(self, event):
        self.button.executeCmds()
        self.entryVar.set("")

class Entry(ctk.CTkEntry):
    def __init__(self, parent, entryVar):
        super().__init__(
            master=parent, 
            corner_radius=0, 
            textvariable=entryVar, 
            fg_color=WHITE, 
            bg_color=BLACK, 
            text_color=BLACK
        )

class Label(ctk.CTkLabel):
    def __init__(self, parent, labelVar):
        super().__init__(
            master=parent, 
            text='操作提示', 
            bg_color=BLACK, 
            text_color=WHITE, 
            textvariable=labelVar
        )

class Button(ctk.CTkButton):
    def __init__(self, parent, text):
        super().__init__(
            master=parent,
            corner_radius=0,
            text=text,
            command=self.executeCmds,
            fg_color=GREEN,
            hover=True,
            hover_color=DARK_GREEN
        )
        self.parent = parent

    def executeCmds(self):
        command = self.parent.entryVar.get().strip()
        if not command:
            print("请输入SQL命令")
            return
        # 替换为你的数据库连接信息
        connection = Connection(
            username='your_username', 
            host='your_host', 
            database='your_db', 
            password='your_password'
        )
        connection.connectDb()
        connection.executeCmds(commands=command)
        connection.closeConnection()

class SlidePanelButton(ctk.CTkButton):
    def __init__(self, parent):
        super().__init__(
            master=parent, 
            text='打开侧边栏', 
            fg_color=GREEN, 
            hover_color=DARK_GREEN,
            command=self.moveSlider, 
            corner_radius=0
        )
        self.parent = parent

    def moveSlider(self):
        self.parent.slider.animate()

# 补充SlidePanel基础实现（原代码未提供）
class SlidePanel(ctk.CTkFrame):
    def __init__(self, parent, startPos, endPos):
        super().__init__(master=parent, fg_color=GREEN)
        self.parent = parent
        self.startPos = startPos
        self.endPos = endPos
        self.width = parent.winfo_width() * abs(endPos)

    def place(self):
        self.place(relx=self.startPos, rely=0, relwidth=abs(self.endPos), relheight=1)

    def animate(self):
        current_relx = self.winfo_x() / self.parent.winfo_width()
        if current_relx == self.startPos:
            self.place(relx=self.endPos, rely=0, relwidth=abs(self.endPos), relheight=1)
        else:
            self.place(relx=self.startPos, rely=0, relwidth=abs(self.endPos), relheight=1)

关键修正点说明 #

1. 事件回调参数：entryBinding方法添加event参数，接收tkinter传递的事件对象。
2. 布局统一：移除自定义组件内部的pack/place调用，由App类统一使用grid管理布局，避免冲突。
3. Button命令绑定：command=self.executeCmds改为传递函数引用，而非直接调用。
4. 清空输入框：在entryBinding中执行完命令后，通过self.entryVar.set("")清空输入内容。
5. 资源管理：完善Connection类的closeConnection方法，执行完SQL后关闭游标和连接，避免资源泄漏。
6. 输入校验：添加空命令检查，避免执行空SQL语句。

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