python读文件存mysql库

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39

# coding:utf-8 import pymysql import xlrd       def dbconnect():     db = pymysql.connect(         host="127.0.0.1",         db="xx",         user="root",         passwd="root",         charset='utf8',         port=3306,         use_unicode=True)     cur = db.cursor()     return db, cur     def save():     db, cur = dbconnect()     file_name = "bug.txt"     with open(file_name,'r',encoding="UTF-8") as f:         data=f.read()         print(data)       data_list=data.split('\n')     n=20007     for nn in data_list:         print(nn)         sql = "insert into table(type,name) values (%s,%s);"         try:             cur.execute(sql, (str(n),nn.strip()))             db.commit()             n+=1         except Exception as e:             print('erro:',e)   save()