sqlite查询中的python字符串替换

import sqlite3

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

# 定义查询
query = "SELECT * FROM users WHERE name = ?"

# 插入变量值
name = "John"

# 执行查询
cursor.execute(query, (name,))

# 获取查询结果
result = cursor.fetchall()

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

import sqlite3

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

# 定义查询
query = "SELECT * FROM users WHERE name = :name"

# 插入变量值
name = "John"

# 执行查询
cursor.execute(query, {'name': name})

# 获取查询结果
result = cursor.fetchall()

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