main函数
# 1. 导入管理系统模块
from managerSystem import *
# 2. 启动管理系统
# 保证是当前文件运行才启动管理系统:if --创建对象并调用run方法
if __name__ == '__main__':
student_manager = StudentManager()
student_manager.run()
程序入口函数
def run(self):
# 1. 加载文件里面的学员数据
#self.load_student()
while True:
# 2. 显示功能菜单
self.show_menu()
# 3. 用户输入目标功能序号
menu_num = int(input('请输入您需要的功能序号:'))
# 4. 根据用户输入的序号执行不同的功能 -- 如果用户输入1,执行添加
if menu_num == 1:
# 添加学员
self.add_student()
elif menu_num == 2:
# 删除学员
self.del_student()
elif menu_num == 3:
# 修改学员信息
self.modify_student()
elif menu_num == 4:
# 查询学员信息
self.search_student()
elif menu_num == 5:
# 显示所有学员信息
self.show_student()
elif menu_num == 6:
# 退出系统 -- 退出循环
break
显示功能菜单 – 打印序号的功能对应关系 – 静态
def show_menu():
print('请选择如下功能:')
print('1:添加学员')
print('2:删除学员')
print('3:修改学员信息')
print('4:查询学员信息')
print('5:显示所有学员信息')
print('6:退出系统')
添加学员
def add_student(self):
# 1. 用户输入姓名、性别、手机号
name = input('请输入您的姓名:')
gender = input('请输入您的性别:')
tel = input('请输入您的手机号:')
db = pymysql.connect(host='localhost', user='root', password='2001Zz.', database='python_mysql')
cur = db.cursor()
#sql = "Insert into stu(name,gender,tel) values(%s,%s,%s)"%(name,gender,tel)
sql = "Insert into stu(name,gender,tel)value (%s,%s,%s)"
value = (name, gender, tel)
#cur.execute(sql, value)
try:
cur.execute(sql,value)
db.commit()
print("添加成功")
except:
print("异常!")
db.rollback()
db.close()
删除学员
def del_student(self):
db = pymysql.connect(host='localhost', user='root', password='2001Zz.', database='python_mysql')
cur = db.cursor()
x = input("请输入你要删除的学生姓名")
sql = "delete FROM stu WHERE name='%s'" % (x)
cur.execute(sql)
try:
cur.execute(sql)
db.commit()
print("删除成功")
except:
print("异常!")
db.rollback()
db.close()
修改学员信息
def modify_student(self):
db = pymysql.connect(host='localhost', user='root', password='2001Zz.', database='python_mysql')
cur = db.cursor()
name = input("请输入你要修改的学生姓名")
gender = input("请输入修改的性别")
tel = input("请输入修改的电话")
sql = "update stu set gender='%s',tel=%s WHERE name='%s'"%(gender,tel,name)
try:
cur.execute(sql)
db.commit()
print("修改成功")
except:
print("异常!")
db.rollback()
db.close()
查询学员信息
def search_student(self):
db = pymysql.connect(host='localhost', user='root', password='2001Zz.', database='python_mysql')
cur = db.cursor()
x=input("请输入你要查询的学生姓名")
sql = "SELECT * FROM stu WHERE name='%s'" % (x)
cur.execute(sql)
results = cur.fetchone()
if results:
print("姓名:%s 性别:%s 手机号:%s " % (results[0], results[1], results[2]))
else:
print("没有您所要查询的学生")
db.close()
显示所有学员信息
def show_student(self):
db = pymysql.connect(host='localhost', user='root', password='2001Zz.', database='python_mysql')
cur = db.cursor()
sql = "SELECT * FROM stu"
cur.execute(sql)
results = cur.fetchall()
for row in results:
name = row[0]
gender = row[1]
tel = row[2]
print("姓名:%s 性别:%s 手机号:%s " % (name, gender, tel))
db.close()