如何在pyodbc中使用executemany运行多个SELECT查询

import pyodbc

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

# 创建多个SELECT查询语句列表
sql_queries = [
    "SELECT * FROM table1 WHERE column1 = ?",
    "SELECT * FROM table2 WHERE column2 = ?",
    "SELECT * FROM table3 WHERE column3 = ?"
]

# 创建参数列表
params = [
    ('value1',),
    ('value2',),
    ('value3',)
]

# 执行多个SELECT查询
cursor = conn.cursor()
cursor.executemany(';'.join(sql_queries), params)

# 获取每个查询的结果集
results = []
for query in sql_queries:
    result = cursor.fetchall()
    results.append(result)

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

# 打印每个查询的结果集
for i, result in enumerate(results):
    print(f"Result for query {i+1}:")
    for row in result:
        print(row)
    print()