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()