如何从csv字符串中提取值并将其插入到SQL Server中的列中

import csv
import pyodbc

# CSV字符串
csv_string = "John,Doe,30\nJane,Smith,25\n"

# 解析CSV字符串
reader = csv.reader(csv_string.splitlines())

# 数据库连接信息
server = 'your_server'
database = 'your_database'
username = 'your_username'
password = 'your_password'

# 连接到SQL Server
conn = pyodbc.connect('DRIVER={SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)

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

# 创建表（如果需要）
create_table_query = "CREATE TABLE IF NOT EXISTS Person (FirstName VARCHAR(50), LastName VARCHAR(50), Age INT)"
cursor.execute(create_table_query)

# 插入数据
insert_query = "INSERT INTO Person (FirstName, LastName, Age) VALUES (?, ?, ?)"
for row in reader:
    cursor.execute(insert_query, row)

# 提交更改并关闭连接
conn.commit()
conn.close()