Python和Tkinter GUI -如何在每次提交后自动添加Id和增量1？

import tkinter as tk
import sqlite3

def submit_data():
    # 连接到数据库
    conn = sqlite3.connect('database.db')
    cursor = conn.cursor()

    # 查询数据库中最大的Id值
    cursor.execute('SELECT MAX(Id) FROM table_name')
    max_id = cursor.fetchone()[0]

    # 获取表单数据
    data = {
        'Id': max_id + 1,
        'Field1': entry_field1.get(),
        'Field2': entry_field2.get(),
        # 其他字段...
    }

    # 插入数据到数据库
    cursor.execute('INSERT INTO table_name (Id, Field1, Field2) VALUES (:Id, :Field1, :Field2)', data)

    # 提交数据并关闭数据库连接
    conn.commit()
    conn.close()

# 创建Tkinter窗口
window = tk.Tk()

# 创建表单输入框
label_field1 = tk.Label(window, text='Field 1:')
label_field1.pack()
entry_field1 = tk.Entry(window)
entry_field1.pack()

label_field2 = tk.Label(window, text='Field 2:')
label_field2.pack()
entry_field2 = tk.Entry(window)
entry_field2.pack()

# 创建提交按钮
submit_button = tk.Button(window, text='Submit', command=submit_data)
submit_button.pack()

# 运行Tkinter窗口
window.mainloop()