从MySQL获取数据库以输出标签Tkinter Python

import tkinter as tk
from tkinter import ttk
import mysql.connector

# 连接到MySQL数据库
def fetch_data():
    try:
        conn = mysql.connector.connect(
            host="your_host",
            user="your_user",
            password="your_password",
            database="your_database"
        )
        cursor = conn.cursor()
        cursor.execute("SELECT column_name FROM table_name")
        data = cursor.fetchall()
        return data
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        if conn.is_connected():
            cursor.close()
            conn.close()

# 创建Tkinter窗口
def create_gui(data):
    root = tk.Tk()
    root.title("MySQL Data in Tkinter")

    for item in data:
        label = ttk.Label(root, text=item[0])
        label.pack(padx=10, pady=5)

    root.mainloop()

# 主程序
if __name__ == "__main__":
    data = fetch_data()
    create_gui(data)