# -*- coding:utf-8 -*-
import json
import pymysql
file = 'F:\\pins_two\\user_xinxi\\pins_two_1.json'
fp =open(file, 'r')
str=fp.read()
ls=eval(str)
#print(ls[0])
connent=pymysql.connect(host='localhost',user='root',passwd='123',db='user',charset='utf8')
cursor=connent.cursor()
sql="insert into student(age,name) values(55,'limei')"
try:
cursor.execute(sql)
connent.commit()
except:
print("Error")
