python Django项目学生管理系统_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 = '年级总人数'


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137

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 = '年级主任'

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74