Python游标如何在SQL que中替换为字符串并保持引号?是

import sqlite3

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

# 创建表
cursor.execute('''CREATE TABLE IF NOT EXISTS employees
                  (id INTEGER PRIMARY KEY AUTOINCREMENT,
                   name TEXT,
                   age INTEGER,
                   address TEXT)''')

# 插入数据
name = "John Doe"
age = 30
address = "123 Main St"

# 使用参数化查询插入数据
cursor.execute("INSERT INTO employees (name, age, address) VALUES (?, ?, ?)",
               (name, age, address))

# 提交更改
conn.commit()

# 查询数据
search_name = "John Doe"

# 使用参数化查询查询数据
cursor.execute("SELECT * FROM employees WHERE name=?", (search_name,))
result = cursor.fetchall()

# 打印查询结果
for row in result:
    print(row)

# 关闭游标和连接
cursor.close()
conn.close()