如何从mysql数据库和treeview中删除python ttk treeview上选中的项目？

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

# 连接MySQL数据库
conn = mysql.connector.connect(
    host="数据库主机地址",
    user="用户名",
    password="密码",
    database="数据库名"
)

# 创建ttk treeview
root = tk.Tk()
treeview = ttk.Treeview(root)
treeview.pack()

# 查询数据库并在ttk treeview中显示数据
def load_data():
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM 表名")
    rows = cursor.fetchall()
    for row in rows:
        treeview.insert("", "end", values=row)
    cursor.close()

# 删除选中的项目
def delete_selected():
    selected_items = treeview.selection()
    for item_id in selected_items:
        treeview.delete(item_id)
        # 从数据库中删除对应的数据
        cursor = conn.cursor()
        cursor.execute("DELETE FROM 表名 WHERE ID = %s", (item_id,))
        conn.commit()
        cursor.close()

# 加载数据并绑定删除按钮的点击事件
load_data()
delete_button = tk.Button(root, text="删除选中", command=delete_selected)
delete_button.pack()

root.mainloop()