Python下载图片

import requests
import time
import os
import MySQLdb

def save_pics(urls):
    # 根据图片的URL地址进行循环下载
    headers = {
        'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) \
        Chrome/76.0.3809.100 Safari/537.36'}

    # filename = './{}/'.format(search_words) + i.split('/')[-1]
    filename = os.path.basename(urls)
    # exit(print(filename))
    try:
        saveImagePath=r'E:\sciimg'
        # newSaveImagePath = saveImagePath+filename
        newSaveImagePath = os.path.splitext(saveImagePath)[0]+'\\' +filename
        # exit(print(newSaveImagePath))
        with open(newSaveImagePath, 'wb+') as f:
            f.write(requests.get(urls, headers=headers).content)  # 将请求响应的二进制文件写入文件
        print("图片下载成功")
    except:
        print("图片下载失败"+urls)
    # time.sleep(5)


db = MySQLdb.connect(host='127.0.0.1', port=3306, user='root', passwd='mysoul928', db='dedecmsv57utf8sp2',charset='utf8')
cursor = db.cursor()
pub_exit = "select cover from sci where cover like '%h%' order by id desc"
try:
    cursor.execute(pub_exit)
    results = cursor.fetchall()
    for row in results:
        # print(row[0])
        save_pics(row[0])
except:
    print('error')