import mysql.connector
titlelist = []
backCateNamelist = []
phonelist = []
addresslist = []
avgpricelist = []
avgscorelist = []
def readtxt():
txtfile = open(‘D:\picture\myhuoguo.txt’,‘r’,encoding=‘utf-8’)
line = txtfile.readline()
#######
while line:
content = line.split()
title = content[0]
backCateName = content[1]
phone = content[2]
address = content[3]
avgprice = content[4]
avgscore = content[5]
######
titlelist.append(title)
backCateNamelist.append(backCateName)
phonelist.append(phone)
addresslist.append(address)
avgpricelist.append(avgprice)
avgscorelist.append(avgscore)
######
line = txtfile.readline()
txtfile.close()
def writemysql():
mydb = mysql.connector.connect(host=“ip”,port=‘3306’,user=“root”,passwd=“psd”,database=“zaizai”)
##########
mycursor = mydb.cursor()
count = len(open(‘D:\picture\myhuoguo.txt’,‘r’,encoding=‘utf-8’).readlines())
#print(count)
# mycursor.execute(“create table if not exists vivian
(title
text not null, backCateName
text not null, phone
text not null, address
text not null, avgprice
text not null,avgscore
text not null)CHARACTER SET utf8;”)
#######
sqlinsert = “insert into vivian(title,backCateName,phone,address,avgprice,avgscore) values(’%s’,’%s’,’%s’,’%s’,’%s’,’%s’)”
# sqlselect = “select * from demo;”
for i in range(count):
value = (titlelist[i],backCateNamelist[i],phonelist[i],addresslist[i],avgpricelist[i],avgscorelist[i])
mycursor.execute(sqlinsert % value)
mydb.commit()
mydb.close()
readtxt()
writemysql()