import threading
import time
import pymysql
def create(sql, name):
cur.execute(f"drop table if exists {name}")
cur.execute(sql)
print("创建表成功")
def change(sql, args):
cur.executemany(sql, args)
db.commit()
def prints(sql):
cur.execute(sql)
result = cur.fetchall()
for data in result:
print(data)
def close():
cur.close()
db.close()
def show_menu():
print('请选择如下功能:')
print('1:添加学员')
print('2:删除学员')
print('3:修改学员信息')
print('4:查询学员信息')
print('5:显示所有学员信息')
print('6:退出系统')
def add_student():
name = input('请输入您的姓名:')
gender = input('请输入您的性别:')
tel = input('请输入您的手机号:')
sql = "insert into test01 value(%s,%s,%s)"
args = [(name, gender, tel)]
change(sql, args)
print('添加成功!')
def del_student():
del_name = input('请输入要删除的学员姓名:')
sql = "delete from test01 where name=%s"
args = [del_name]
change(sql, args)
print('删除成功!')
def modify_student():
modify_name = input('请输入要修改的学员姓名:')
sql = "delete from test01 where name=%s"
args = [modify_name]
change(sql, args)
name = input('请输入修改的姓名:')
gender = input('请输入修改的性别:')
tel = input('请输入修改的手机号:')
sql = "insert into test01 value(%s,%s,%s)"
args = [(name, gender, tel)]
change(sql, args)
print('修改成功!')
def search_student():
search_name = input('请输入您要搜索的学员姓名:')
sql = "select * from test01 where name=%s"
args = [search_name]
change(sql, args)
print('查询成功!')
sql = "select * from test01 where name='" + search_name + "'"
prints(sql)
def show_student():
sql = "select * from test01 "
prints(sql)
def save_student(self):
pass
if __name__ == '__main__':
try:
db = pymysql.connect(host="localhost", user="root", password="xrhzbz888", db="winter_vacation01")
print("数据库连接成功!")
cur = db.cursor()
while True:
# 2. 显示功能菜单
show_menu()
# 3. 用户输入目标功能序号
menu_num = int(input('请输入您需要的功能序号:'))
# 4. 根据用户输入的序号执行不同的功能 -- 如果用户输入1,执行添加
if menu_num == 1:
# 添加学员
add_student()
elif menu_num == 2:
# 删除学员
del_student()
elif menu_num == 3:
# 修改学员信息
modify_student()
elif menu_num == 4:
# 查询学员信息
search_student()
elif menu_num == 5:
# 显示所有学员信息
show_student()
elif menu_num == 6:
# 退出系统 -- 退出循环
break
t01 = threading.Timer(1, save_student)
close()
except pymysql.Error as e:
print(str(e))
01-16
303
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-16
698
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-16
694
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-12
2014
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交