亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定

關于抓取回來的網頁數據保存失敗問題???

獲取保存的頁面數據

content?=?soup.find_all('div',{'class':'single-content'})


pymysqlcon?=?pymysql.connect(
????????host='127.0.0.1',
????????user='root',
????????password='root',
????????db='spider',
????????charset="utf8mb4"
????)
try:
????with?pymysqlcon.cursor()?as?cursor:
????????sql?=?"insert?into?`content`(`content`)?values(%s)"
????????cursor.execute(sql,(content))
????????pymysqlcon.commit()
finally:
????pymysqlcon.close()

報錯以下:

Traceback (most recent call last):

? File "D:/pycharm/index.py", line 33, in <module>

? ? cursor.execute(sql,(content))

? File "D:\Python\lib\site-packages\pymysql\cursors.py", line 168, in execute

? ? query = self.mogrify(query, args)

? File "D:\Python\lib\site-packages\pymysql\cursors.py", line 147, in mogrify

? ? query = query % self._escape_args(args, conn)

? File "D:\Python\lib\site-packages\pymysql\cursors.py", line 122, in _escape_args

? ? return tuple(conn.literal(arg) for arg in args)

? File "D:\Python\lib\site-packages\pymysql\cursors.py", line 122, in <genexpr>

? ? return tuple(conn.literal(arg) for arg in args)

? File "D:\Python\lib\site-packages\pymysql\connections.py", line 846, in literal

? ? return self.escape(obj, self.encoders)

? File "D:\Python\lib\site-packages\pymysql\connections.py", line 839, in escape

? ? return converters.escape_item(obj, self.charset, mapping=mapping)

? File "D:\Python\lib\site-packages\pymysql\converters.py", line 27, in escape_item

? ? val = encoder(val, mapping)

? File "D:\Python\lib\site-packages\pymysql\converters.py", line 118, in escape_unicode

? ? return u"'%s'" % _escape_unicode(value)

? File "D:\Python\lib\site-packages\pymysql\converters.py", line 73, in _escape_unicode

? ? return value.translate(_escape_table)

TypeError: 'NoneType' object is not callable


正在回答

1 回答

我覺得應該是數據類型問題,請問要怎么處理

0 回復 有任何疑惑可以回復我~

舉報

0/150
提交
取消

關于抓取回來的網頁數據保存失敗問題???

我要回答 關注問題
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號