数资第一次培训

import requests
from lxml import etree
urls = ['https://www.biquwx.la/10_10218/{}.html'.format(i) for i in range(5001505,5001516)]
path = r'C:Users10474Desktopxiaoshuo2爬取'
def get_text(url):
    r = requests.get(url)
    r.encoding = "utf-8"
    selector = etree.HTML(r.text)
    #爬取文章标题
    title = selector.xpath('//*[@id="wrapper"]/div[5]/div/div[2]/h1/text()')
    #爬取文章内容
    txt = selector.xpath('//*[@id="content"]/text()')
    with open(path + title[0]+'.txt', 'w', encoding="utf-8") as f:
        for i in txt:
            f.write(i)

if __name__ == '__main__':
    for url in urls:
        get_text(url)

第一次写爬虫很开心。虽然gbk和utf-8转码出现了问题但是还是很开心。

import pymysql
db = pymysql.connect(host='localhost',port=3306,user='root',password='121101mm.',database='test_mm',charset='utf8')#dfb
print ("数据库连接成功")
cursor = db.cursor()#使用cursor()方法创建一个游标对象

cursor.execute("select *from student") # 显示表格数据，使用execute()方法执行SQL语句，
results = cursor.fetchall()#使用fetall()获取全部数据
print(results)
print("显示所有数据*************************************")
#增
cursor.execute("insert into student (name, age) values('旻旻',18)")
cursor.execute("insert into student (name, age) values('黄馨莹师姐',19)")
id
db.commit()
cursor.execute("select *from student")
results1 = cursor.fetchall()#使用fetall()获取全部数据
print(results1)
print("增加成功*************************************")
#删
cursor.execute("delete from student where name = '旻旻'")
db.commit()#提交才有效
cursor.execute("select *from student")
results2 = cursor.fetchall()#使用fetall()获取全部数据
print(results2)
print("删除成功*************************************")
#改 / 更新数据

cursor.execute("update student set age=999 where age=1")
db.commit()
cursor.execute("select *from student")
results3 = cursor.fetchall()#使用fetall()获取全部数据
print(results3)
print("更新/更改成功*************************************")

#查
cursor.execute("select name,age from student")
db.commit()#提交才有效
#cursor.execute("select *from student")
results4 = cursor.fetchall()#使用fetall()获取全部数据
print(results4)
print("查询成功*************************************")

cursor.close()#关闭游标和数据库的连接
db.close()

第一次用python连接mysql很开心。