4399游戏名称爬取

import requests
import pymysql
from bs4 import BeautifulSoup
headers={
    'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36'
    }
url='https://www.4399.com/'

db=pymysql.connect(host='localhost',port=3306,user='root',password='root',database='4399')
cur=db.cursor()
sql='CREATE TABLE 游戏 (名称 VARCHAR(255));'
cur.execute(sql)
db.commit()
response=BeautifulSoup(requests.get(url,headers=headers,timeout=10).text,'lxml')
res=response.find(class_="middle_2")
for i in res.find_all('a'):
    t3=i.text #gb2312
    t5=t3.encode('ISO-8859-1').decode('gb2312') #str.encode('ISO-8859-1').decode('网页编码')
    #print(t5)
    sql=f"INSERT INTO 游戏 (名称) VALUES (%s);"
    cur.execute(sql,t5)
    db.commit()

cur.close()
db.commit()