stu_list =['小王','小红','小李']
while True:
print( """
欢迎使用学生管理系统
1-查询学员姓名
2-添加学员姓名
3-修改学员姓名
4-删除学员姓名
0-退出程序
""")
a=int(input('请选择操作:'))
if a == 1:
print('行号\t\t姓名')
print('------------')
for i in range(0,len(stu_list)):
print(i+1,'\t\t',stu_list[i])
elif a==2:
b=input('输入名字')
stu_list.append(b)
print('添加完毕')
elif a==3:
print('行号\t\t姓名')
print('------------')
for n in range(0,len(stu_list)):
print(n+1,'\t\t',stu_list[n])
c = int(input('要修改的学生编号'))
d = input('修改后的名字')
stu_list[c-1]=d
print('修改成功')
elif a==4:
e=input('要删除的学生')
if e in stu_list:
stu_list.remove(e)
print('删除成功')
elif a==0:
print('谢谢使用')
break
学生管理系统-函数封装版
之前的非函数版本 打印学生列表代码重复,如果要修改,需要处处修改。while if 嵌套,代码越来越长,不容易维护。
stu_list =['小王','小红','小李']
def show_students():
print('行号\t\t姓名')
print('------------')
for i in range(0, len(stu_list)):
print(i + 1, '\t\t', stu_list[i])
def add_students():
b = input('输入名字')
stu_list.append(b)
print('添加完毕')
def update_students():
print('行号\t\t姓名')
print('------------')
for n in range(0, len(stu_list)):
print(n + 1, '\t\t', stu_list[n])
c = int(input('要修改的学生编号'))
d = input('修改后的名字')
stu_list[c - 1] = d
print('修改成功')
def delete_students():
e = input('要删除的学生')
if e in stu_list:
stu_list.remove(e)
print('删除成功')
def main ():
while True:
print("""
欢迎使用学生管理系统
1-查询学员姓名
2-添加学员姓名
3-修改学员姓名
4-删除学员姓名
0-退出程序
""")
num = int(input('请输入操作编号:'))
if num == 1:
show_students()
elif num == 2:
add_students()
elif num == 3:
update_students()
elif num == 4:
delete_students()
elif num == 0:
break
if __name__ == '__main__':
main()
学生管理系统-字典封装
student = [{'name': '小明', 'age':10, 'sex':'male'},
{'name':'小红', 'age':12, 'sex':'female'},
{'name':'小李', 'age':12, 'sex':'male'}
]
def show_students():
print('行号\t\t姓名\t\t年龄\t\t性别\t\t')
print('-------------------------------')
for i in range(0,len(student)):
stu_dict = student[i]
name = stu_dict['name']
age = stu_dict['age']
sex = stu_dict['sex']
print('{}\t\t{}\t\t{}\t\t{}\t\t'.format(i+1,name,age,sex))
def add_students():
name=input('输入要添加的姓名')
age=int(input('输入年龄'))
sex=input('输入性别')
student.append({'name':name,'age':age,'sex':sex})
print('保存成功')
def update_students():
show_students()
new=int(input('输入要修改的学生序号'))
no=student[new-1]
no['name']=input('修改后的名字')
no['age'] = int(input('修改后的年龄'))
no['sex'] = input('修改后的性别')
print('修改成功')
def delete_students():
print("""
1、按学生编号删除
2、删除全部学生(谨慎)
""")
ab=int(input('请选择操作类型'))
if ab==1:
show_students()
do = int(input('输入要删除的学生序号'))
no = student[do - 1]
del student[do - 1]
print('删除成功')
else :
student.clear()
while True:
print("""
1-查询学员姓名
2-添加学员姓名
3-修改学员姓名
4-删除学员姓名
0-退出程序
""")
num = int(input('请输入操作编号:'))
if num ==1:
show_students()
elif num==2:
add_students()
elif num==3:
update_students()
elif num==4:
delete_students()
学生管理系统-类封装
student_list = [
{'name': '小明', 'age': 10, 'sex': 'male'},
{'name': '小红', 'age': 12, 'sex': 'female'},
{'name': '小李', 'age': 12, 'sex': 'male'}
]
class Student():
@staticmethod
def show_students():
print('行号\t\t姓名\t\t年龄\t\t性别\t\t')
print('-------------------------------')
for i in range(0, len(student_list)):
print(i + 1, '\t', student_list[i]['name'], '\t', student_list[i]['age'], '\t', student_list[i]['sex'])
def __init__(self,name,age,sex):
self.name = name
self.age = age
self.sex = sex
def print_information(self):
temp = ({'name': self.name, 'age': self.age, 'sex': self.sex})
student_list.append(temp)
print('添加成功')
def update_students(self):
no=new1
student_list[no - 1]['name'] = self.name
student_list[no- 1]['age'] = self.age
student_list[no- 1]['sex'] = self.sex
print('修改成功')
@classmethod
def delete_students(self):
if ab == 1:
Student.show_students()
fo = int(input('输入要删除的学生序号'))
del student_list[fo-1]
print('删除成功')
while True:
print("""
欢迎使用学生管理系统
1-查看学员姓名
2-添加学员姓名
3-修改学员姓名
4-删除学员姓名
0-退出程序
""")
num = int(input('请输入操作编号:'))
if num == 1:
Student.show_students()
elif num == 2:
name = input('新的学生姓名')
age = input('新的学生年龄')
sex =input('新的学生性别')
new_list = Student(name, age,sex)
new_list.print_information()
Student.show_students()
elif num == 3:
Student.show_students()
new1 = int(input('输入要修改的学生序号'))
name = input('修改后的姓名')
age = input('修改后的年龄')
sex = input('修改后的性别')
student1=Student(name,age,sex)
student1.update_students()
elif num == 4:
print("""
1、按学生编号删除
2、删除全部学生(谨慎)
""")
ab = int(input('请选择操作类型'))
Student.delete_students()
elif num == 0:
break
学生管理系统-数据库版
这里的数据没有写入,需要自己创建。
import sqlite3
def show_student():
connect = sqlite3.connect("testsqlite.db")
cursor = connect.cursor()
select_aql = "SELECT * FROM student"
students_list = cursor.execute(select_aql)
print('id\t\t姓名\t\t性别\t\t年龄')
print('--------------------------')
for id, name, sex, age in students_list:
print(id, '\t', name, '\t', sex, '\t\t', age)
connect.commit()
cursor.close()
connect.close()
def add_student():
connect = sqlite3.connect("testsqlite.db")
cursor = connect.cursor()
name = input("输入要添加的姓名")
sex = input("输入要添加的性别")
age = int(input("输入要添加的年龄"))
insert_sql = 'INSERT INTO student(name, sex, age) VALUES ("%s", "%s", "%s" )' % (name, sex, age)
cursor.execute(insert_sql)
connect.commit()
cursor.close()
connect.close()
def update_student():
connect = sqlite3.connect("testsqlite.db")
cursor = connect.cursor()
show_student()
id = int(input("输入要修改的学生序号"))
name = input("输入要修改的姓名")
sex = input("输入要修改的性别")
age = int(input("输入要修改的年龄"))
update_sql = 'UPDATE student SET name="%s", sex="%s", age="%s" WHERE id="%d" ' % (name, sex, age, id)
stu_list = cursor.execute(update_sql)
print(stu_list)
connect.commit()
cursor.close()
connect.close()
def delete_student():
connect = sqlite3.connect("testsqlite.db")
cursor = connect.cursor()
show_student()
print('1> 按序号删除 2> 全部删除 ')
sen = input("请输入你的子选项:")
if sen == "1":
id = input("请输入要删除第几个学生:")
delete_sql = 'DELETE FROM student where id="%s" '%id
student = cursor.execute(delete_sql)
print(student)
elif sen == "2":
cun = input("确认是否全部删除:(N/ Y)")
if cun == 'Y':
delete1 = 'drop table student'
d1 = cursor.execute(delete1)
print("删除成功")
connect.commit()
cursor.close()
connect.close()
while True:
print("""
1-查询学员姓名
2-添加学员姓名
3-修改学员姓名
4-删除学员姓名
0-退出程序
""")
num = input("请选择你的操作")
if num == "1":
show_student()
elif num == "2":
add_student()
elif num == "3":
update_student()
print("修改成功")
elif num == "4":
delete_student()
elif num == "0":
print("谢谢使用")