从csv文件生成插入SQL语句

import csv
import sqlite3

# 连接到SQLite数据库
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 创建目标表（如果不存在）
cursor.execute('''CREATE TABLE IF NOT EXISTS example
                  (column1, column2, column3)''')

# 读取CSV文件并生成插入语句
with open('example.csv', 'r') as csvfile:
    reader = csv.reader(csvfile)
    next(reader)  # 跳过CSV文件的第一行（列名）
    insert_sql = "INSERT INTO example (column1, column2, column3) VALUES (?, ?, ?)"
    
    # 准备批量插入
    batch_insert = []
    
    # 逐行读取CSV文件并生成插入语句
    for row in reader:
        batch_insert.append((row[0], row[1], row[2]))
        
    # 执行批量插入
    cursor.executemany(insert_sql, batch_insert)
    conn.commit()
    
# 关闭数据库连接
cursor.close()
conn.close()