个回答

• qq_清蒸红烧_03602510

  2018-03-22 12:21:08

  右键点击urls表，选设计表，然后点下面的自动增长，我就是这样可以了

  0

• 放学路上的小学生

  2017-05-04 22:52:08

  pymysql.err.InternalError: (1364, "Field 'id' doesn't have a default value")

  id列没有默认值。试试在mysql的表中，id列设置为自动增长autoincrement。
  

  0

• 孤独的小猪

  2017-03-07 17:56:29

  我能说，我用你的代码执行，是正确的，数据库里已经正常存入了。

  #! /usr/local/bin/python3
  # -*- coding:utf-8 -*-
  
  from urllib.request import urlopen
  from bs4 import BeautifulSoup as bs
  import re
  import pymysql.cursors
  
  resp = urlopen("https://en.wikipedia.org/wiki/Main_Page").read().decode(
      "utf-8")
  
  soup = bs(resp, "html.parser")
  
  listUrls = soup.find_all("a", href=re.compile("^/wiki/"))
  for url in listUrls:
      if not re.search("\.(jpg|JPG)$", url["href"]):
          print(url.get_text("href"), "<---->",
                "https://en.wikipedia.org" + url["href"])
          connection = pymysql.connect(host='localhost',
                                       user='root',
                                       password='123456',
                                       db='wikiurl',
                                       charset='utf8mb4')
          try:
              with connection.cursor() as cursor:
                  sql = "insert into `urls`(`urlname`,`urlhref`)values(%s,%s)"
  
                  cursor.execute(sql, (
                  url.get_text(), "https://en.wikipedia.org" + url["href"]))
  
                  connection.commit()
  
          finally:
              connection.close()

  

  0

• 慕设计6340343

  2017-02-20 14:48:40

  #! /usr/local/bin/python3
  # -*- coding:utf-8 -*-
  
  # 引入开发包
  from urllib.request import urlopen
  from bs4 import BeautifulSoup as bs
  import re
  import pymysql.cursors
  
  # 请求URL并把结果用UTF-8编码
  resp = urlopen("https://en.wikipedia.org/wiki/Main_Page").read().decode("utf-8")
  
  # 使用beautifulsoup去解析
  soup = bs(resp,"html.parser")
  
  # 获取所有以/wiki/开头的a标签的href属性
  listUrls = soup.find_all("a", href=re.compile("^/wiki/"))
  for url in listUrls:
     # 过滤-.jpg或JPG结尾的URL
     if not re.search("\.(jpg|JPG)$",url["href"]):
         # 输出URL的文字和对应的链接
         print(url.get_text("href"),"<---->","https://en.wikipedia.org"+url["href"])
         #获取数据库链接
         connection = pymysql.connect(host = 'localhost',
                                      user = 'root',
                                      password = '123456',
                                      db = 'wikiurl',
                                      charset = 'utf8mb4')
         try:
             # 获取回话指针
             with connection.cursor() as cursor:
                 sql = "insert into `urls`(`urlname`,`urlhref`)values(%s,%s)"
  
                 # 执行sql语句
                 cursor.execute(sql,(url.get_text(),"https://en.wikipedia.org"+ url["href"]))
  
                 # 提交
                 connection.commit()
  
  
         finally:
             connection.close()
  
  

  0