因为mysql报错10045,不能修复,所以用txt写
import os
def jin():
print('学生信息管理程序')
print('1.进入')
print('2.退出')
jin_ru = int(input('输入菜单号:'))
if jin_ru == 1:
print('已进入')
denglu()
jin()
else:
print('谢谢使用')
def denglu():
while True:
print('1.增加学生记录')
print('2.删除学生记录')
print('3.修改学生记录')
print('4.查询学生记录')
print('5.返回上一级')
cha1 = int(input('输入菜单号:'))
if cha1 == 1:
zeng()
if cha1 == 2:
shan()
if cha1 == 3:
gai()
if cha1 == 4:
cha()
if cha1 == 5:
break
def zeng():
xue_hao = input('学号:')
xin_min = input('姓名:')
xin_bie = input('性别:')
nian_ling = input('年龄:')
ban_ji = input('班级:')
zhuan_ye = input('专业:')
xi_bu = input('系部:')
dian_hua = input('电话:')
message = [xue_hao, xin_min, xin_bie, nian_ling, ban_ji, zhuan_ye, xi_bu, dian_hua]
with open('学生.txt', 'a', encoding='utf-8') as a:
for i in message:
a.write(i + '|')
a.write('\n')
def shan():
students = []
f = open('学生.txt', encoding='utf-8')
for line in f:
students.append(line)
xue_hao = input('要删除的学生的学号:')
for student in students:
if student[0] == xue_hao:
students.remove(student)
print('已删除')
else:
print('没有这个人')
def gai():
students = []
f = open('学生.txt', encoding='utf-8')
for line in f:
students.append(line)
xue_hao = input('要修改的学生的学号:')
for student in students:
if student[0] == xue_hao:
print('1.修改学号')
print('2.修改姓名')
print('3.修改性别')
print('4.修改年龄')
print('5.修改班级')
print('6.修改专业')
print('7.修改系部')
print('8.修改电话')
print('9.返回上一级')
xiu_gai = int(input('输入菜单号:'))
student = list(student)
if xiu_gai == 1:
a = input('修改内容:')
student[0] = a
elif xiu_gai == 2:
a = input('修改内容:')
student[1] = a
elif xiu_gai == 3:
a = input('修改内容:')
student[2] = a
elif xiu_gai == 4:
a = input('修改内容:')
student[3] = a
elif xiu_gai == 5:
a = input('修改内容:')
student[4] = a
elif xiu_gai == 6:
a = input('修改内容:')
student[5] = a
elif xiu_gai == 7:
a = input('修改内容:')
student[6] = a
elif xiu_gai == 8:
a = input('修改内容:')
student[7] = a
def cha():
students = []
f = open('学生.txt', encoding='utf-8')
for line in f:
students.append(line)
xue_hao = input('要查询的学生的学号:')
for student in students:
if student[0] == xue_hao:
print(student)
jin()