在python中通过sqllite查询传递论据

import sqlite3

# 连接到 SQLite 数据库（如果数据库不存在，则会自动创建）
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 创建一个示例表
cursor.execute('''
CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT NOT NULL
)
''')

# 插入一些示例数据
cursor.execute("INSERT INTO users (name, email) VALUES (?, ?)", ('Alice', 'alice@example.com'))
cursor.execute("INSERT INTO users (name, email) VALUES (?, ?)", ('Bob', 'bob@example.com'))
conn.commit()

# 查询数据并传递参数
search_name = 'Alice'
cursor.execute("SELECT * FROM users WHERE name = ?", (search_name,))
results = cursor.fetchall()

# 打印结果
for row in results:
    print(row)

# 关闭连接
cursor.close()
conn.close()

cursor.close()
conn.close()