Python将txt文本文件写入Mysql数据库
import pymysqlimport 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:mit()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()
