在DT表中传递特殊字符

import sqlite3

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

# 用户输入
user_input = "O'Reilly"

# 使用参数化查询
cursor.execute("SELECT * FROM DT WHERE name = ?", (user_input,))
results = cursor.fetchall()

for row in results:
    print(row)

# 关闭连接
conn.close()

SELECT * FROM DT WHERE name = REPLACE(REPLACE(name, '\\', '\\\\'), '''', '''''');

from sqlalchemy import create_engine, Table, Column, String, MetaData
from sqlalchemy.orm import sessionmaker

engine = create_engine('sqlite:///example.db')
metadata = MetaData()
DT = Table('DT', metadata,
           Column('name', String),
           Column('age', Integer))

Session = sessionmaker(bind=engine)
session = Session()

# 用户输入
user_input = "O'Reilly"

# 查询
result = session.query(DT).filter(DT.c.name == user_input).all()
for row in result:
    print(row)

session.close()