python读文件存mysql库

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