python爬取阿里云漏洞库完整版

啦啦啦，来交差了！！！

# -*- coding: utf-8 -*-
import re
import time
import requests
from random import randint
import  threading
import pymysql


# thread_lock = threading.BoundedSemaphore(value=10)

print('正在连接到mysql服务器...')
# 给定要连接的数据库IP地址、用户名、密码、数据库名
db = pymysql.connect(host="127.0.0.1",user="root",password="root",database="ali_cve" )
print('连接成功!')
# 创建一个游标对象 cursor
cursor = db.cursor()
# 执行SQL语句
cursor.execute("SHOW TABLES")
# 获取所有记录列表
result = cursor.fetchall()
print("当前的表为：%s" %result)


# 获取网页内容
def get_onepage_content(url):
    user_agent = ['Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.7113.93 Safari/537.36',
                  'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Firefox/91.0',
                  'Mozilla/5.0 (Windows NT 1