在Tkinter GUI中显示SQLite数据

import tkinter as tk
import sqlite3

window = tk.Tk()
window.title("显示SQLite数据")
window.geometry("400x300")

conn = sqlite3.connect("example.db")

cursor = conn.cursor()
cursor.execute("SELECT * FROM students")
rows = cursor.fetchall()

text_box = tk.Text(window)
text_box.pack()

for row in rows:
    text_box.insert(tk.END, row)
    text_box.insert(tk.END, '\n')

conn.close()

import tkinter as tk
import sqlite3

# 创建GUI窗口
window = tk.Tk()
window.title("显示SQLite数据")
window.geometry("400x300")

# 连接到SQLite数据库
conn = sqlite3.connect("example.db")

# 查询数据
cursor = conn.cursor()
cursor.execute("SELECT * FROM students")
rows = cursor.fetchall()

# 显示数据
text_box = tk.Text(window)
text_box.pack()

for row in rows:
    text_box.insert(tk.END, row)
    text_box.insert(tk.END, '\n')

# 关闭数据库连接
conn.close()

# 运行GUI窗口主循环
window.mainloop()