SQL查询Python变量

import sqlite3

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

# 创建一个表
cursor.execute('''CREATE TABLE IF NOT EXISTS employees
                  (id INT PRIMARY KEY     NOT NULL,
                  name           TEXT    NOT NULL,
                  age            INT     NOT NULL,
                  salary         REAL);''')

# 插入数据
cursor.execute("INSERT INTO employees (id, name, age, salary) VALUES (1, 'John Doe', 30, 5000)")
cursor.execute("INSERT INTO employees (id, name, age, salary) VALUES (2, 'Jane Smith', 35, 6000)")

# 查询年龄大于指定值的员工
min_age = 32
cursor.execute("SELECT * FROM employees WHERE age > ?", (min_age,))
result = cursor.fetchall()
for row in result:
    print(row)

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