使用cx_Oracle中csv文件中的变量更新数据库

import csv
import cx_Oracle

# 连接到 Oracle 数据库
dsn_tns = cx_Oracle.makedsn('hostname', 'port', service_name='service_name')
conn = cx_Oracle.connect(user='username', password='password', dsn=dsn_tns)

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

# 打开 CSV 文件
with open('data.csv', newline='') as csvfile:
    reader = csv.DictReader(csvfile)
    
    # 遍历 CSV 文件中的每一行数据
    for row in reader:
        # 构建 SQL 更新语句
        update_sql = """
        UPDATE your_table
        SET column1 = :column1,
            column2 = :column2,
            column3 = :column3
        WHERE id = :id
        """
        
        # 执行更新操作
        cursor.execute(update_sql, {
            'column1': row['column1'],
            'column2': row['column2'],
            'column3': row['column3'],
            'id': row['id']
        })

# 提交事务
conn.commit()

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