如何修改使之能夠?qū)⒔Y(jié)果保存在MySQL中
請問，剛剛的是存貯在文件里面的，可要是要存儲在MySQL這種關(guān)系型數(shù)據(jù)庫中的話，要怎么修改呢，最后的代碼~
qq_洞簫長音醉紅塵_0
2016-12-27
3 回答
舉報
0/150
提交
取消
2016-12-28
for?data?in?self.datas: ????connection??=?pymysql.connect(host='localhost', ????????????user='root', ????????????password='********',????????#密碼 ????????????db='*******',????????????????#數(shù)據(jù)庫 ????????????charset='utf8mb4') ????????try: ????????????with?connection.cursor()?as?cursor: ????????????????sql?=?'insert?into?`db`(`url`,`urltitle`,`summary`)?values(%s,%s,%s)' ????????????????cursor.execute(sql,(data['url'],data['title'].encode('utf-8'),data['summary'].encode('utf-8'))) ????????????????connection.commit() ????????finally: ????????????connection.close()2016-12-29
Traceback (most recent call last):?
File "E:\java\python pachong\python pachong\baike_python\main_python.py", line 34, in <module> ? ?
obj_spider.craw(root_url) ?
File "E:\java\python pachong\python pachong\baike_python\main_python.py", line 30, in craw ? ?
self.outputer.output_html() ?
File "E:\java\python pachong\python pachong\baike_python\html_outputer.py", line 34, in output_html ? ?w
ith ?connection.cursor() as cursor:
AttributeError: __exit__
一直出現(xiàn)這種問題，請問怎么解決，還望指教QAQ！
2016-12-29
感激！再請問一句，主調(diào)度程序那里要進行哪些修改呢？能否具體說下，謝謝！