列出pyodbc预准备语句中的参数

import pyodbc

# 创建数据库连接
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=mydb;UID=username;PWD=password')

# 创建游标
cursor = conn.cursor()

# 定义预准备语句
sql = "SELECT * FROM mytable WHERE column1 = ? AND column2 = ?"

# 执行预准备语句
cursor.execute(sql, ('value1', 'value2'))

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

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

import pyodbc

# 创建数据库连接
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=mydb;UID=username;PWD=password')

# 创建游标
cursor = conn.cursor()

# 定义预准备语句
sql = "SELECT * FROM mytable WHERE column1 = :value1 AND column2 = :value2"

# 执行预准备语句
cursor.execute(sql, {'value1': 'value1', 'value2': 'value2'})

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

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