正则表达式
import re
#导正则包
line='han'
match_res=re.match('h',line)
1.#以h开头
if match_res:
print('成功')
else:
print('失败')
2.#.以h开头后面跟着一个字符
#line=h123544这种类型匹配失败
#.可以匹配任意字符
match_res=re.match('h.$',line)
#3.以h开头后面跟任意数量的数字
line='hh1m2829'
\d表示任意的0-9的数字,*前面的那一个匹配的西,0-n次
match_res=res.match('h\d*',line)
#4.以3结尾
match_res=res.match('.*$',line)
#5.以h开头,以3为结尾
match_res=res.match('h.*3$',line)
2.百度翻译改进版
import requests
import json
url='http://fanyi.baidu.com/sug'
def translate(kw):
form={
'kw':kw
}
response=requests.post(url,data=form)
response.encoding='utf-8'
str=response.text
res_dict=json.loads(response.text)
result=res_dict['data'][0]['v']
return result
if __name__=='__main__':
res=translate('驴')
print('res')
3.百思不得其解
import requests
url='http://www.budejie.com/'
response=requests.get(url)
with open('bs.html','wb') as f:
f.write(response.text)
4.雪球网
import json
from urllib import request
headers = {
#'Accept': '*/*',
#'Accept-Encoding': 'gzip, deflate, br',
#'Accept-Language': 'zh-CN,zh;q=0.9,en;q=0.8',
#'Connection': 'keep-alive',
'Cookie': 'aliyungf_tc=AQAAALoQF3p02gsAUhVFebQ3uBBNZn+H; xq_a_token=584d0cf8d5a5a9809761f2244d8d272bac729ed4; xq_a_token.sig=x0gT9jm6qnwd-ddLu66T3A8KiVA; xq_r_token=98f278457fc4e1e5eb0846e36a7296e642b8138a; xq_r_token.sig=2Uxv_DgYTcCjz7qx4j570JpNHIs; _ga=GA1.2.516718356.1534295265; _gid=GA1.2.1050085592.1534295265; u=301534295266356; device_id=f5c21e143ce8060c74a2de7cbcddf0b8; Hm_lvt_1db88642e346389874251b5a1eded6e3=1534295265,1534295722; Hm_lpvt_1db88642e346389874251b5a1eded6e3=1534295722',
#'Host': 'xueqiu.com',
#'Referer': 'https://xueqiu.com/',
'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36',
#'X-Requested-With': 'XMLHttpRequest',
#'User-Agent':'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36'
}
url = 'https://xueqiu.com/v4/statuses/public_timeline_by_category.json?since_id=-1&max_id=-1&count=10&category=111'
req = request.Request(url, headers=headers)
response = request.urlopen(req)
res = response.read()
#print(res)
res_dict = json.loads(res.decode('utf-8'))
list_list = res_dict['list']
#print(list_list)
for list_item_dict in list_list:
data_str = list_item_dict['data']
print(data_str)
print('-'*50)
5.封装pymql
import pymysql
class mysql_connect():
def __init__(self):
self.db=pymysql.connect(host='127.0.0.1',user='username',password='password',port='3306',database='py10')
self.cursor=self.db.cursor()
def execute_modify_mysql(self,sql):
self.cursor.execute(sql)
self.db.commit()
def __del__(self):
self.cursor.close()
self.db.close()
if __name__=='__main__':
sql='insert into xueqiu_test values (3)'
mc=mysql_connect()
mc.execute_modify_mysql(sql)