1 helloworld
print("hello")
print('1221312\
12312312\
2312312321312\
21312312')
'''
多行注释
'''
print(123+423)
2 变量和标识符
c = 999999_999999_999999999999
print(c)
3 字符串,数字,时间
a = 'hello'
print(a)
print('a =',a)
b = 'hello %s'%'孙悟空'
b = 'hello %s 和 %s'%('孙悟空','猪八戒')
b = 'hello %3s'%('tomaaaa')
b = 'hello %3.5s'%('tomaaaa')
b = '%.2f'%1234.42222222
print(b)
c = f'hello {a} {b}'
print(c)
name = 'cxl'
print("hi "+name)
print('hi',name)
print('hi %s'%name)
print(f'hi {name}')
a = 'abc'
a = a * 2
print(a)
4 Bool和None
flag1 = True
flag2 = False
print(f'a:{flag1}')
print(f'a:{flag2}')
print(1+True)
print(1+False)
b = None
print(b)
5 类型转换
a = 'hello'
b = 123
print(a + str(b))
6 类型检查
a = 123
b = '123'
print("a:",a,type(a))
print("b:",b,type(b))
7 运算符
print('你好') if False else print('hello')
a = 10
b = 20
print('a big!') if a > b else print('b big!')
max = a if a > b else b
print(max)
8 if条件
if True : print('hello')
num = 2
if num > 5:
print('num>5')
print('mmm')
else:
print('num<5')
print('mmm')
code = input("请输入")
print(code)
if code == '1':
print('你输入的是',code)
elif code == '2':
print('你输入的是',code)
else:
print('你输入的什么?',code)
9 while循环
i = 100
while i < 1000:
a = i // 100
b = (i - a * 100) // 10
c = i % 10
if a**3 + b**3 + c**3 == i:
print(i)
i += 1
print('='*6)
num = int(input("请输入一个任意大于1的整数:"))
i = 2
flag = True
while i<num:
if num % i == 0:
flag = False
i+=1
if flag :
print(num,'是质数')
else:
print(num,"不是质数")
i = 0
if i < 5:
pass
10 运行时间
from time import *
start = time()
i = 1
while i < 100000000:
print(time())
i+=100
end = time()
print('共执行了 > ',end-start)
11 九九乘法表
i = 0
while i < 9:
i += 1
j = 0
while j < i:
j += 1
print(f'{j}*{i}={i*j} ',end="")
print()
12 列表,切片,序列,元组,字典
列表
my_list1 = []
my_list2 = [100,200,'hello',True]
print(my_list2)
print(my_list2[2])
print(len(my_list2))
切片
student = ['cxl','ywk','gql']
print(student[0:2])
print(student[:2])
print(student[0:3:2])
print(student[::-1])
序列
r = range(5)
print(list(r))
a = range(3,100,3)
print(list(a))
for i in range(10):
print(f"打印{i}次")
元祖
e = (1,2,3,4,5,6)
print(e)
字典
d = {1:"我是1",2:"我是2"}
print(d,type(d))
print(d.get(1))
print(type(d.keys()))
for i in d.keys():
print(d[i])
s = d.pop(2)
print("--------",s)
for i in d.keys():
print(d[i])
13 列表常用方法
student = ['cxl','ywk','gql','ywk']
number = [1,2,3]
# + and *
# mylist1 = [1,2,3] + [4,5,6]
# print(mylist1)
#
# mylist2 = [1,2,3] * 10
# print(mylist2)
# in and not in
# in 是否存在列表中南
# print('cxl' in student) #True
# print('cxl' not in student) #False
#min() and max() 获取最大值和最小值
# print(min(number))
# print(max(number))
#index() and count()
#获取第一次出现的位置('str',s,e)
# s:表示查找的起始位置
# e:表示查找的结束位置
print(student.index('cxl'))
print(student.count('ywk')) #数量
14 计算器
print("欢迎使用计算器")
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
flag = True
while flag:
if choose=='1' :
add1 = int(input("请输入加数1:"))
add2 = int(input("请输入加数2:"))
print("结果为:",add1+add2)
flagStr = input("是否继续y/n")
if flagStr == 'y':
flag = True
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
else:
flag = False
elif choose=='2' :
j1 = int(input("请输入减数1:"))
j2 = int(input("请输入减数2:"))
print("结果为:",j1-j2)
flagStr = input("是否继续y/n")
if flagStr == 'y':
flag = True
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
else:
flag = False
elif choose=='3' :
c1 = int(input("请输入因数1:"))
c2 = int(input("请输入因数2:"))
print("结果为:",c1*c2)
flagStr = input("是否继续y/n")
if flagStr == 'y':
flag = True
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
else:
flag = False
elif choose=='4' :
f1 = int(input("请出入除数1:"))
f2 = int(input("请出入除数1:"))
print("结果为:",f1/f2)
flagStr = input("是否继续y/n")
if flagStr == 'y':
flag = True
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
else:
flag = False
15 连接mysql实现增删改查
import pymysql
connection = pymysql.connect(host='127.0.0.1', port=3306, user='root',
password='root', db='test',charset='utf8',
cursorclass=pymysql.cursors.DictCursor)
cur = connection.cursor()
while True :
print("==============================================")
print("1.列表 2.修改 3.添加 4.删除 5.建表 6.关闭连接")
print("7.九九乘法表 8.计算器")
choose = input("请输入您的选择")
if choose == "1":
print("用户列表")
sql = "SELECT * FROM user_py"
cur.execute(sql)
results = cur.fetchall()
print(results)
elif choose == "2":
print("====修改====")
id = input("修改ID:")
sql = "SELECT * FROM user_py WHERE id = "+id
cur.execute(sql)
results = cur.fetchall()
print("你要修改这条数据 > ",results)
userName = input("input UserName > :")
userAge = input("input UserAge > :")
update_sql = f"""UPDATE user_py SET USER_NAME ='{userName}', USER_AGE={userAge} WHERE `ID`= {id}"""
cur.execute(update_sql)
print("更新成功!")
elif choose == "3":
print("====插入====")
id = input("input id > :")
userName = input("input UserName > :")
userAge = input("input UserAge > :")
insert_sql = f"""INSERT INTO USER_PY(`ID`,`USER_NAME`,`USER_AGE`)values({id},"{userName}",{userAge})"""
print(insert_sql)
cur.execute(insert_sql)
print("插入成功")
elif choose == "4":
print("====删除====")
id = input(" input delete id > :")
delete_sql ="DELETE FROM USER_PY WHERE ID = "+ id
cur.execute(delete_sql)
print("删除成功")
elif choose == "5":
print("开始建表")
sql = """CREATE TABLE User_py (
ID INT NOT NULL,
USER_NAME CHAR(20) NOT NULL,
USER_AGE INT)"""
cur.execute(sql)
print("建表成功")
elif choose == "6":
print("开始关闭连接")
connection.close()
print("关闭连接成功!")
elif choose == "7":
print("正在输出九九乘法表")
i = 0
while i < 9:
i += 1
j = 0
while j < i:
j += 1
print(f'{j}*{i}={i * j} ', end="")
print()
elif choose == "8":
print("欢迎使用计算器")
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
flag = True
while flag:
if choose == '1':
add1 = int(input("请输入加数1:"))
add2 = int(input("请输入加数2:"))
print("结果为:", add1 + add2)
flagStr = input("是否继续y/n")
if flagStr == 'y':
flag = True
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
else:
flag = False
elif choose == '2':
j1 = int(input("请输入减数1:"))
j2 = int(input("请输入减数2:"))
print("结果为:", j1 - j2)
flagStr = input("是否继续y/n")
if flagStr == 'y':
flag = True
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
else:
flag = False
elif choose == '3':
c1 = int(input("请输入因数1:"))
c2 = int(input("请输入因数2:"))
print("结果为:", c1 * c2)
flagStr = input("是否继续y/n")
if flagStr == 'y':
flag = True
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
else:
flag = False
elif choose == '4':
f1 = int(input("请出入除数1:"))
f2 = int(input("请出入除数1:"))
print("结果为:", f1 / f2)
flagStr = input("是否继续y/n")
if flagStr == 'y':
flag = True
print("1.加法 2.减法 3.乘法 4.除法")
choose = input("请输入要进行的操作:")
else:
flag = False