python数据储存mysql

import sysreload(sys)sys.setdefaultencoding( "utf-8" )import requestsimport jsonimport pymysqlconn = pymysql.connect(host='localhost',port=3306,user='root',password='root',db='toutiao',charset='utf8')cursor = conn.cursor()url = 'http://www.toutiao.com/api/pc/focus/'wbdata = requests.get(url).textdata = json.loads(wbdata)news = data['data']['pc_feed_focus']for n in news:    title = n['title']    img_url = n['image_url']    url = n['media_url']    # print(url,title,img_url)    cursor.execute("INSERT INTO data(title,img_url,url)VALUES('{0}','{1}','{2}');".format(title,img_url,url))    conn.commit()cursor.close()conn.close()print 'ok'