python Django项目学生管理系统

涉及技术：
后台：Django mysql
前端：Html css js Ajax boostrap
数据库：MySQL5.7

功能简介：

管理系统使用Xadmin框架，内置Bootstrap3、插件库

• 登录注册：普通用户与管理人员入口不同，老师及学生通过状态选择验证。
• 权限管理：权限组管理及个人权限管理。
• 基本信息管理：针对用户（学生，老师，年级主任，管理人员）基本信息的增删改查。
• 年级管理：年级与年级主任，该年级下属的班级关联。
• 班级管理：班级与班级主任，授课老师，该班级所有的学生，统计学生数，按老师筛选班级。
• 宿舍管理：宿舍责任老师，宿舍长，以及当前宿舍学生。
• 考试管理：考试记录的建立。
• 成绩管理：成绩排名，单条成绩记录的增加修改以及删除时同此考试，年级或班级的相应个人成绩重新排序。
• 增删改查，异步处理，唯一性判断，缓存清楚功能，重要数据加密功能，正则表达式判断功能

部署效果截图

学生信息表

管理人员表

学生基本信息

登陆界面

部分代码

class Administrator(AbstractUser):
    """管理人员"""

    id = models.AutoField(verbose_name='管理人员编号', db_column='管理员编号', primary_key=True)
    username = models.CharField(max_length=150, verbose_name='用户名', db_column='用户名', unique=True)
    password = models.CharField(max_length=128, verbose_name='密码', db_column='密码')
    email = models.EmailField(verbose_name='邮箱', db_column='邮箱', null=True, blank=True)
    add_time = models.DateTimeField(default=datetime.now, db_column='添加时间', verbose_name="添加时间")
    remark = models.TextField(max_length=100, verbose_name='备注', db_column='备注', default='',
                              null=True , blank=True,
                              help_text='备注不超过一百个汉字',
                              error_messages={
                                  'max_length': '备注不超过一百个字'
                              })

    class Meta:
        verbose_name = '管理人员'
        verbose_name_plural = verbose_name
        db_table = '管理人员表'

    def __str__(self):
        return self.username


class EmailVerifyRecord(models.Model):
    """邮箱验证码"""

    SEND_CHOICES = (
        ("register", "注册"),
        ("forget", "找回密码"),
        ("update_email", "修改邮箱")
    )
    code = models.CharField(max_length=50, verbose_name="验证码", db_column='验证码')
    email = models.EmailField(max_length=50, verbose_name="邮箱", db_column='邮箱')
    send_type = models.CharField(choices=SEND_CHOICES, max_length=20, verbose_name="发送类型", db_column='验证码类型')
    send_time = models.DateTimeField(default=datetime.now, verbose_name="发送时间", db_column='发送时间')
    # 将now()中的括号去掉保证默认时间是models实例化的时间，而不是编译时间

    class Meta:
        verbose_name = "邮箱验证码"
        verbose_name_plural = verbose_name
        db_table = '验证码表'

    def __str__(self):
        return self.code


class DormitoryInfo(models.Model):
    """宿舍信息"""

    dormitory_number = models.CharField(max_length=5, db_column='寝室号', verbose_name='寝室号', default='001')
    year = models.CharField(max_length=10, db_column='年份', default='2018', verbose_name='年份',)
    teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL,
                                null=True, verbose_name='老师档案号', db_column='老师档案号')
    remark = models.TextField(max_length=100, verbose_name='备注', db_column='备注',
                              help_text='备注不超过一百个汉字',
                              null=True, blank=True,
                              error_messages={
                                  'max_length': '备注不超过一百个字'
                              })

    class Meta:
        verbose_name = '宿舍'
        verbose_name_plural = verbose_name
        # ordering = ['year', 'dormitory_number']
        db_table = '宿舍信息表'
        # unique_together = ['dormitory_number', 'year']

    def __str__(self):
        return "{0}年入住,宿舍号：{1}".format(self.year, self.dormitory_number)

    def get_dormitory_students(self):
        students_list = self.studentinfo_set.all()
        students_list = ','.join([i.student_name for i in students_list])
        return students_list
    get_dormitory_students.short_description = '宿舍学生'

    def get_student_number(self):
        num = self.studentinfo_set.all().count()
        return num
    get_student_number.short_description = '宿舍当前人数'


class GradeInfo(models.Model):
    """年级信息"""

    grade_number = models.CharField(max_length=2, db_column='年级', verbose_name='年级', default='1')
    year = models.CharField(max_length=10, db_column='届', verbose_name='届', default='2018', unique=True,
                            help_text='学生入学年份')
    header = models.CharField(max_length=10, db_column='年级主任', verbose_name='年级主任', default='', null=True, blank=True)
    remark = models.TextField(max_length=100, verbose_name='备注', db_column='备注',
                              default='', null=True, blank=True,
                              help_text='备注不超过一百个汉字',
                              error_messages={
                                  'max_length': '备注不超过一百个字'
                              })

    class Meta:
        verbose_name = '年级信息'
        verbose_name_plural = verbose_name
        db_table = '年级信息表'
        # unique_together = ['grade_number', 'year']
        # ordering = ['-year', 'grade_number']  # datetime.time 对象不可序列化

    def __str__(self):

        year_now = date.today().year
        month_now = date.today().month

        #  计算出年级，但是为防止转校生，没有动态的加载到数据库
        if month_now >= 9 and year_now >= int(self.year):
            grade = year_now - int(self.year) + 1
        elif month_now < 9 and year_now >= int(self.year):
            grade = year_now - int(self.year)
        else:
            grade = int(self.grade_number)

        # 如果学生的年级大于三年级，则显示已经毕业
        if grade > 3:
            return '{0}届入学, 目前已毕业'.format(self.year)
        else:
            return '{0}届入学, 目前{1}年级'.format(self.year, grade)

    def save(self, *args, **kwargs):
        super(GradeInfo, self).save(*args, **kwargs)

    def get_class_number(self):
        # 通过关联查询该年级的所有班级数
        num = self.classinfo_set.count()
        return num
    get_class_number.short_description = '班级数'

    def get_grade_students_number(self):
        return self.studentinfo_set.all().count()
    get_grade_students_number.short_description = '年级总人数'

class ClassInfo(models.Model):
    """班级信息"""

    class_number = models.CharField(max_length=5, db_column='班级', verbose_name='班级', default='1')
    header = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, null=True,
                               limit_choices_to={'is_class_leader': True},
                               verbose_name='班主任档案号', db_column='班主任档案号')
    grade = models.ForeignKey(GradeInfo, on_delete=models.SET_NULL, null=True, verbose_name='年级', db_column='年级')

    # 各科老师
    chinese_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, related_name='chinese_teacher_class',
                                        limit_choices_to={'subject': '语文'}, blank=True,
                                        null=True, verbose_name='语文老师', db_column='语文老师')
    math_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, related_name='math_teacher_class',
                                     limit_choices_to={'subject': '数学'}, blank=True,
                                     null=True, verbose_name='数学老师', db_column='数学老师')
    english_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, related_name='english_teacher_class',
                                        limit_choices_to={'subject': '英语'}, blank=True,
                                        null=True, verbose_name='英语老师', db_column='英语老师')
    physical_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, related_name='physical_teacher_class',
                                         limit_choices_to={'subject': '物理'}, blank=True,
                                         null=True, verbose_name='物理老师', db_column='物理老师')
    chemistry_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL,
                                          related_name='chemistry_teacher_class',
                                          limit_choices_to={'subject': '化学'}, blank=True,
                                          null=True, verbose_name='化学老师', db_column='化学老师')
    biology_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, related_name='biology_teacher_class',
                                        limit_choices_to={'subject': '生物'}, blank=True,
                                        null=True, verbose_name='生物老师', db_column='生物老师')
    politics_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, related_name='politics_teacher_class',
                                         limit_choices_to={'subject': '政治'}, blank=True,
                                         null=True, verbose_name='政治老师', db_column='政治老师')
    geography_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL,
                                          related_name='geography_teacher_class',
                                          limit_choices_to={'subject': '地理'}, blank=True,
                                          null=True, verbose_name='地理老师', db_column='地理老师')
    history_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, related_name='history_teacher_class',
                                        limit_choices_to={'subject': '历史'}, blank=True,
                                        null=True, verbose_name='历史老师', db_column='历史老师')
    sport_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, related_name='sport_teacher_class',
                                      limit_choices_to={'subject': '体育'}, blank=True,
                                      null=True, verbose_name='体育老师', db_column='体育老师')
    music_teacher = models.ForeignKey(TeacherInfo, on_delete=models.SET_NULL, related_name='music_teacher_class',
                                      limit_choices_to={'subject': '音乐'}, blank=True,
                                      null=True, verbose_name='音乐老师', db_column='音乐老师')

    remark = models.TextField(max_length=100, verbose_name='备注', db_column='备注',
                              default='', null=True, blank=True,
                              help_text='备注不超过一百个汉字',
                              error_messages={
                                  'max_length': '备注不超过一百个字'
                              })

    class Meta:
        verbose_name = '班级信息'
        verbose_name_plural = verbose_name
        # ordering = ['grade', 'class_number']
        db_table = '班级信息表'
        # unique_together = ['grade', 'class_number', 'header']

    def __str__(self):
        return '班级：{}'.format(self.class_number)

    def get_class_student_number(self):
        # 根据班主任还有入学年份筛选
        num = self.studentinfo_set.all().count()
        return num
    get_class_student_number.short_description = '班级人数'

    def get_grade_leader(self):
        grade_leader = GradeInfo.objects.get(pk=self.grade.id).header
        return grade_leader
    get_grade_leader.short_description = '年级主任'