重用copg2.execute中的参数

import psycopg2

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

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

# 定义SQL语句
sql = "SELECT * FROM your_table WHERE column1 = %(value1)s AND column2 = %(value2)s"

# 定义参数字典
params = {'value1': 'some_value', 'value2': 'another_value'}

# 执行SQL语句
cur.execute(sql, params)

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

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