Python pysqlite不接受我的qmark参数化

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

query = "SELECT * FROM users WHERE name=?"
cursor.execute(query, ('John',))

results = cursor.fetchall()
for row in results:
    print(row)

conn.close()

query = "SELECT * FROM users WHERE name=? AND age=?"
cursor.execute(query, ('John', 30))

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

query = "SELECT * FROM users WHERE name=:name"
cursor.execute(query, {'name': 'John'})

results = cursor.fetchall()
for row in results:
    print(row)

conn.close()

query = "SELECT * FROM users WHERE name=:name AND age=:age"
cursor.execute(query, {'name': 'John', 'age': 30})