使用Python Treeview修改sqlite中的单个整数值

import sqlite3
from tkinter import *
from tkinter import ttk

conn = sqlite3.connect('your_database.db')
cursor = conn.cursor()

root = Tk()
root.title("修改整数值")

tree = ttk.Treeview(root)
tree['columns'] = ('value')
tree.heading('#0', text='ID')
tree.column('#0', width=50)
tree.heading('value', text='Value')
tree.column('value', width=100)

cursor.execute("SELECT id, value FROM your_table")
rows = cursor.fetchall()
for row in rows:
    tree.insert('', 'end', text=row[0], values=(row[1],))

def update_value():
    selected_item = tree.selection()[0]
    new_value = int(entry.get())
    tree.set(selected_item, 'value', new_value)
    cursor.execute("UPDATE your_table SET value = ? WHERE id = ?", (new_value, selected_item))
    conn.commit()

entry = Entry(root)
entry.pack()

button = Button(root, text="更新", command=update_value)
button.pack()

tree.pack()
root.mainloop()