def load_stu_info(): """ 加载学生信息 从stu_infos.csv文件中加载数据 :return: 无 """ with open(r"stu_infos.csv", encoding='utf-8-sig') as file: f_csv = csv.reader(file) header = next(f_csv) for row in f_csv: student_info = {} for index in range(3): student_info[header[index]] = row[index] student_infos.append(student_info)
登录
def login(): """ 用户使用学号和密码进行登录 最多让用户登录三次,如果连续三次都登录失败(用户名或者密码错误),只要密码和用户都正确表示登录成功 :return:登录成功返回True和学号,三次都登录失败返回False和None """ retry_time = 0 while retry_time < 3: user_no = input('请输入登录账号:') password = input('请输入密码:') for i in student_infos: if i['no']==user_no and i['password']==password: return True,user_no print('用户名或者密码错误!!!请重新输入。') retry_time += 1 else: return False, None
考勤记录写入
def add(user_no): for x in student_infos: if user_no==x['no']: name=x['name'] break times=time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) choices=['出勤','迟到','请假','缺勤'] a=int(input("/t该学生出勤情况:1-出勤/t2-迟到/t3-请假/t4-缺勤:")) if a==1: data=choices[0] elif a==2: data=choices[1] elif a==3: data=choices[2] else: data=choices[3] with open(r"attendance.csv",'a+',newline='', encoding='utf-8') as f: wf = csv.writer(f) wf.writerow([user_no,name,times,data])#写入一行数据 print("{}同学{}数据已经写入成功!操作时间是{}".format(name,data,times))
查询考勤记录
def select(): student = [] with open(r"attendance.csv", encoding='utf-8-sig') as file: f_csv = csv.reader(file) header = next(f_csv) for row in f_csv: students = {} for index in range(4): students[header[index]] = row[index] student.append(students) name=input("请输入你需要查找的姓名:") print(" 学号/t/t姓名/t/t操作时间/t/t出勤状态") for a in student: if a['name']==name: print(a['no']+'/t'+a['name']+'/t'+a['time']+'/t/t'+a['state']) else: print("无此人!!!") break