Python 代码片段

从文件获得cookies

cookies={}
with open(r'cookies.txt','r') as f:
    for line in f.read().split(';'): 
    #其设置为1就会把字符串拆分成2份 
        name,value = line.strip().split('=', 1) 
        cookies[name] = value

爬取网页上的图片

import urllib.request
import re
def getHtml(url):
    page = urllib.request.urlopen(url)
    html = page.read().decode('utf-8')
    return html
def getImg(html):
    reg = r'src="(.+?\.jpg)" width'
    imgre = re.compile(reg)
    imglist = re.findall(imgre,html)
    x = 0
    for imgurl in imglist:
        urllib.request.urlretrieve(imgurl,'images/%s.jpg' % x)
        x+=1
html = getHtml('http://tieba.baidu.com/p/741081023')
getImg(html)

使用pymysql操纵MySQL

import pymysql
try:
    conn= pymysql.connect(host='localhost', port=3306, user='DBSAdmin', passwd='admin', charset='UTF8', db='dbs')
    cur=conn.cursor()                              #获取一个游标对象
    cur.execute("INSERT INTO nameage VALUES('小明', 15),('小洪', 17),('小高', 16),('小刚', 15)")#插入数据
    cur.execute("SELECT * FROM nameage")
    data=cur.fetchall()
    for row in data:
        print('%s\t%s' %row)
except Exception as e:
    print("发生异常")
finally:
    cur.close()                                    #关闭游标
    conn.commit()                                  #向数据库中提交任何未解决的事务，对不支持事务的数据库不进行任何操作
    conn.close()                                   #关闭到数据库的连接，释放数据库资源