python "format"

urls=[f'https://www.baidu.com/?page={page}' for page in range(1,5)]  #F f大小写都可以
print(urls)
page=10
url='https://www.baidu.com/?page={}'.format(page)
print(url)
url=F'https://www.baidu.com/?page=%s'%page
print(url)
url=f'https://www.baidu.com/?page='+str(page)
print(url)


url=f'https://www.baidu.com/?page={page}'

print(url)

　结果：

['https://www.baidu.com/?page=1', 'https://www.baidu.com/?page=2', 'https://www.baidu.com/?page=3', 'https://www.baidu.com/?page=4']
https://www.baidu.com/?page=10
https://www.baidu.com/?page=10
https://www.baidu.com/?page=10
https://www.baidu.com/?page=10

import re
url="https://www.baidu.com/?page=1"
total=5
for i in range(2,total+1):
    newlink=re.sub('page=\d+','page=%d'%i,url,re.S)  #利用正则表达式替换成一个变量
    print(newlink)

结果：

===================== RESTART: D:/Python/Python37/re5.py =====================
https://www.baidu.com/?page=2
https://www.baidu.com/?page=3
https://www.baidu.com/?page=4
https://www.baidu.com/?page=5
>>>

>>>

for ii in ah["data"]:
    uu=ii["boards"]
    for yy in uu:
        #print(yy["id"],yy["title"])
        bk=str(yy["id"])
        mc=str(yy["title"])
        print(bk,mc)
        sql2="update bkdxy set mc='{0}' where bk='{1}'".format(mc,bk)
        print(sql2)
        values={"mc":mc,"bk":bk}
        con.execute(sql2)
        connect.commit()

 

搜索

复制