python将txt文件写入数据库_将文本写入MySQL数据库,Python,txt,文本文件,Mysql

Python将txt文本文件写入Mysql数据库

import pymysql

import re

#数据库连接

con=pymysql.connect(

host='localhost',

port=3306,

user='root',

passwd='123456',

db='case_data',

charset='utf8',

)

def insert(con,case_ID,case_process):

cue = con.cursor()

#异常处理

try:

cue.execute(

"insert into new_table"

""

" (case_ID,case_process) values(%s,%s)",

[case_ID,case_process,])

#执行sql语句

# print("insert success") # 测试语句

except Exception as e:

print('Insert error:', e)

con.rollback()

else:

con.commit()

def read():

filename=r'E:\数据\筛选过后.txt'

#按行读取txt文本文档

with open(filename, 'r', encoding='UTF-8') as f:

datas = f.readlines()

#遍历文件

for data in datas:

txt=re.split(r'\t|\n',data)

case_ID=txt[0]

case_process=txt[1]

insert(con, case_ID, case_process)

#调用insert方法

print("数据插入完成！")

read()

con.close()