使用psycopg2执行多组参数的查询

import psycopg2

# 连接到数据库
conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")

# 创建游标对象
cur = conn.cursor()

# 定义SQL查询语句
sql = "SELECT * FROM your_table WHERE column1 = %s AND column2 = %s"

# 定义多组参数
params = [
    (value1_1, value1_2),
    (value2_1, value2_2),
    (value3_1, value3_2)
]

# 执行多组参数的查询
for param in params:
    cur.execute(sql, param)
    rows = cur.fetchall()
    for row in rows:
        # 处理查询结果
        print(row)

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