cursor.execute報錯，代碼和老師的一樣
MySQL版本5.7.17，Python版本3.6.0，鼓搗一下午都沒弄出來
Mr_Blue_001
2017-03-20
4 回答
舉報
0/150
提交
取消
2017-03-21
import?io import?sys import?re import?pymysql.cursors from?urllib.request?import?urlopen from?bs4?import?BeautifulSoup?as?bs sys.stdout?=?io.TextIOWrapper(sys.stdout.buffer,?encoding='utf8') #?請求URL，并把結(jié)果用UTF-8編碼 resp?=?urlopen("https://en.wikipedia.org/wiki/Wiki").read().decode('utf-8') #?使用BeautifulSoup去解析 soup?=?bs(resp,?"html.parser") #?獲取所有以/wiki/開頭的a標(biāo)簽的href屬性 listurls?=?soup.find_all('a',?href=re.compile("^/wiki/")) #?輸出所有的詞條對應(yīng)的名稱和URL for?url?in?listurls: ????#?過濾以.jpg或.JPG結(jié)尾的URL ????if?not?re.search("\.(jpg|JPG)$",?url["href"]): ????????#?輸出URL的文字對應(yīng)的鏈接 ????????#?string只能獲取一個?get_text()獲取標(biāo)簽下所有的文字 ????????print(url.get_text(),"<---->","https://en.wikipedia.org"?+?url["href"]) ????????#?獲取數(shù)據(jù)庫鏈接 ????????connection?=?pymysql.connect(host="localhost",user="root",password="123456",db="wikiurl",charset="utf8mb4") ????????try: ????????????#?獲取會話指針 ????????????with?connection.cursor()?as?cursor: ????????????????#?創(chuàng)建sql語句 ????????????????sql?=?'INSERT?INTO?`urls`(`urlname`,`urlhref`)VALUES(%s,%s)' ????????????????#?執(zhí)行sql語句 ????????????????cursor.execute(sql,(url.get_text(),"https://en.wikipedia.org"?+?url["href"])) ????????????????#?提交 ????????????????connection.commit() ????????finally: ????????????connection.close()2017-03-29
是什么原因呢？我也出現(xiàn)了相同的問題~
2017-03-21
#?引入開發(fā)包 from?urllib.request?import?urlopen from?bs4?import?BeautifulSoup?as?bs import?re import?pymysql.cursors #?請求URL，并把結(jié)果用UTF-8編碼 resp?=?urlopen("https://zh.wikipedia.org/wiki/Wikipedia:%E9%A6%96%E9%A1%B5").read().decode("utf-8") #?使用BeautifulSoup去解析 soup?=?bs(resp,?"html.parser") #?獲取所有以/wiki/開頭的a標(biāo)簽的href屬性 listUrls?=?soup.findAll("a",?href=re.compile("^/wiki/")) #?輸出所有的詞條對應(yīng)的名稱和URL for?url?in?listUrls: ????#?過濾以.jpg或.JPG結(jié)尾的URL ????if?not?re.search("\.(jpg|JPG)$",?url["href"]): ????????#?輸出URL的文字對應(yīng)的鏈接 ????????#?string只能獲取一個?get_text()獲取標(biāo)簽下所有的文字 ????????print(url.get_text(),?"<---->",?"https://zh.wikipedia.org"?+?url["href"]) ????????#?獲取數(shù)據(jù)庫鏈接 ????????connection?=?pymysql.connect(host='localhost', ?????????????????????????????????????user='root', ?????????????????????????????????????password='root', ?????????????????????????????????????db='wikiurl', ?????????????????????????????????????charset='utf8mb4') ????????try: ????????????#?獲取會話指針 ????????????with?connection.cursor()?as?cursor: ????????????????#?創(chuàng)建sql語句 ????????????????sql?=?"inset?into?`urls`?(`urlname`,?`urlhref`)?values(%s,?%s)" ????????????????#?執(zhí)行sql語句 ????????????????cursor.execute(sql,?(url.get_text(),?"https://zh.wikipedia.org"?+?url["href"])) ????????????????#?提交 ????????????????connection.commit() ????????finally: ????????????connection.close()2017-03-20