"""
定义一个连接mysql的函数
默认端口3306
如果不指定端口号,就使用默认端口 3306
假如,有非默认的端口,旧链接到指定的端口上:3307
"""
def connect_mysql(user,password,host,port=3306):
print(f"用户是:{user}")
print(f"密码是:{password}")
print(f"IP是:{host}")
print(f"端口是:{port}")
connect_mysql("root","123","127.0.0.1")
print("*"*10)
connect_mysql("root","123","127.0.0.1",3307)
print("*"*10)
connect_mysql("root","123","127.0.0.1",port=3307)
有关爬虫的内容
import requests
# url = 'https://www.doutula.com/photo/list/'
#
# r = requests.get(url=url)
#
# print(r.text)
with open('F:\\学习资料\\WeChat Files\\wxid_i3k9to8zj7rf22\\FileStorage\\File\\2019-06\\python_code\\day 1\\DAY 4\\斗图.html', encoding='utf-8') as f:
html = f.read()
# def get_urls():
li = []
# 文件一行行读取,然后以空格分隔开。
for line in html.splitlines():
if len(li) == 20:
break
if 'data-original' in line:
# print(line)
# *_,url, file_name, _, _, _, _ = line.split()
# 这上面和下面的是相等的
url = line.split()[7]
file_name = line.split()[8]
# print(url)
# print(file_name)
url = url.split('"')[1]
file_name = file_name.split('"')[1]
# print(url)
# print(file_name)
if ',' in file_name:
file_name = file_name.replace(',', '_')
if '。' in file_name:
file_name = file_name.replace('。', '')
if '!' in file_name:
file_name = file_name.replace('!', '')
if '?' in file_name:
file_name = file_name.replace('?', '')
li.append({"file_name": file_name, "url":url})
# print(li) 这样输出的任然是乱序,一个接一个
# return li
# 这样资输出,会将字典中的key和value都输出 而且每一个都有回车
for item in li:
# print(item)
# 下面的两个是一个变量的赋值,因为在循环中要逐一来匹配。
file_name = item['file_name']
url = item['url']
# 这是爬虫的固定格式,一会儿我放一个爬虫的固定格式
r = requests.get(url)
# rsplit从右往左
x = url.rsplit('.', 1)[-1]
# 这两个是一样的
# x = url.split(".")[-1]
# print(x)
# file_name = file_name + '.' + x
# {file_name}.{x}这是我修改的名字
with open(f'{file_name}.{x}', 'wb') as f:
f.write(r.content)
还有一个爬虫的应用,固定的写法
import requests
# url_baidu = "https://www.doutula.com/photo/list"
url_img = "http://img.doutula.com/production/uploads/image//2019/07/05/20190705311041_nGMuSe.gif"
r = requests.get(url_img)
# # 响应请求的状态码
# print(r.status.code)
# html = str(r.content, encoding="utf-8")
# r =requests.get(url_img)
# print (html)
with open("你.gif", "wb") as f:
f.write(r.content)
"""
1. 计算 任何两个数字的之和的参数,并且返回结果
def foo(x, y):
if isinstance(x, (int, float)) and isinstance(y, (int, float)):
return x + y
else:
return "类型错误"
2. 把所有字符串转换为 大写的函数,并且返回结果,这里需要加上
判断,是否是字母的组合
def foo(w):
if isinstance(w, str):
if w.isalpha():
return w.upper()
else:
pass
3. 写一段小程序,定义一个验证用户名和密码的函数。
用户名和密码正确就显示 "欢迎登录"
否则,请重新输入用户和密码
# user,pwd = input("[shark 123]").split()
user = input('>:')
pwd = input('>:')
def auth_user(u,p):
if u == 'shark' and pwd == '123':
print("欢迎登录")
else:
pass
# auth_user(user, pwd)
auth_user(p=pwd, u=user)
"""