python資料儲存mysql

標籤：tde   exe   default   image   cut   port   def   title   .com   

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‘

python資料儲存mysql