从QComboBox中选择字符串并将ID插入到SQLite数据库中

combo_box = QComboBox()
combo_box.addItem("选项1")
combo_box.addItem("选项2")
combo_box.addItem("选项3")

import sqlite3

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

# 创建表
cursor.execute('''CREATE TABLE IF NOT EXISTS data
                  (id INTEGER PRIMARY KEY AUTOINCREMENT,
                   string TEXT)''')

# 获取选择的字符串和对应的ID
selected_string = combo_box.currentText()
selected_id = combo_box.currentIndex()

# 插入数据到数据库
cursor.execute("INSERT INTO data (id, string) VALUES (?, ?)", (selected_id, selected_string))
conn.commit()

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