将windows C:驱动器中.csv文件中的数据插入到oracle11g数据库中

import csv
import cx_Oracle

# 数据库连接信息
host = 'localhost'
port = 1521
sid = 'ORCL'
user = 'username'
password = 'password'

# 连接到Oracle数据库
dsn = cx_Oracle.makedsn(host, port, sid)
connection = cx_Oracle.connect(user, password, dsn)

# 创建表
create_table_sql = '''
    CREATE TABLE csv_data (
        column1 VARCHAR2(100),
        column2 NUMBER,
        column3 DATE
    )
'''
cursor = connection.cursor()
cursor.execute(create_table_sql)

# 读取.csv文件并插入数据
with open('C:/data.csv', 'r') as file:
    csv_data = csv.reader(file)
    next(csv_data)  # 跳过标题行
    for row in csv_data:
        insert_sql = '''
            INSERT INTO csv_data (column1, column2, column3)
            VALUES (:1, :2, TO_DATE(:3, 'YYYY-MM-DD'))
        '''
        cursor.execute(insert_sql, row)

# 提交事务并关闭连接
connection.commit()
cursor.close()
connection.close()