使用Django开发一个选择题系统

　　使用Django+MySQL开发一个选择题系统，选择题有题干，对应选项，对应答案几项内容

　　一,创建Django项目

 

 

 

 

 　　创建成功

 

 

 　　修改配置

 

 

 　　数据库配置

　　数据库需要先创建好

?
1
> create database health;

　　

?
1
2
3
4
5
6
7
8
9
10
11
'default': {
       'ENGINE': 'django.db.backends.mysql',
       'NAME': 'health',
       'USER': 'root',
       'PASSWORD': 'password',
       'HOST': '192.168.1.188',
       'PORT': '3306',
       'OPTIONS': {
           "init_command": "SET sql_mode='STRICT_TRANS_TABLES'",
       }
   }

　　时区配置

 

 　　静态资源配置

 

 　　静态文件夹static需要手动创建和模板templates同路径在项目health之下

 

 　　MySQL模块支持配置

　　配置在app subject之下即题目表下

 

 　　二，数据库模板设计

　　题目表有3个表，分别为题目表，以及题目对应的选项表和答案表，结构如下

　　题目选项表和答案表分别关联题目表的主键id

 

 　　模板设计

 

?
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
from django.db import models
 
Type = (
    (0, '单选'),
    (1, '多选')
)
 
Option = (
    (1, 'A'),
    (2, 'B'),
    (3, 'C'),
    (4, 'D'),
    (5, 'E'),
    (6, 'F'),
    (7, 'G'),
    (8, 'H'),
)
 
# Create your models here.
class Subject(models.Model):
    stem = models.CharField(max_length=1024, verbose_name='题干内容', blank=False, null=False)
    type = models.IntegerField(choices=Type, verbose_name='题目类型,单选还是多选')
    explain = models.CharField(max_length=512, verbose_name='题目答案解析', blank=False, null=False)
 
    class Meta:
        db_table = 'subject'
        verbose_name = '题干表'
 
class Options(models.Model):
    options = models.IntegerField(choices=Option, verbose_name='选项ABCDEFGH')
    content = models.CharField(max_length=256, verbose_name='选项内容')
    subject = models.ForeignKey('Subject')
 
    class Meta:
        db_table = 'options'
        verbose_name = '选项表'
        unique_together = ('subject', 'content')
        ordering = ['options']
 
class Answer(models.Model):
    options = models.IntegerField(choices=Option, verbose_name='选项ABCDEFGH')
    subject = models.ForeignKey('Subject')
 
    class Meta:
        db_table = 'answer'
        verbose_name = '答案表'
        unique_together = ('subject', 'options')
        ordering = ['options']

　　这里题目类型对应的类型为choices即数字0对应单选数字1对应多选

　　选项表也是12345678分别对应选项ABCDEFGH

　　数据迁移

　　注意运行数据迁移命令的路径是在项目文件夹下

?
1
2
D:\health>python manage.py makemigrations subject
D:\health>python manage.py migrate subject

　　登录数据库查看创建的表

 

 

 

 　　插入数据

 　　示例题目内容如下

?
1
2
3
4
5
6
7
8
9
10
11
12
题目
人类心理现象包括
选项
A , 心理活动过程
B , 个性心理特征
C , 认知、情感和意志力
D , 心理活动过程和个性心理特征
E , 感觉功能、运动功能、联络功能系统
解析
人的心理现象包括心理过程和个性心理。 心理过程包括认识教程、情结与情感过程、意志教程三个相互联系的方面。 个性心理特征包括人的能力、气质、性格。具体表现在人的个性倾向性、个性心理特征和自我意识三个方面
答案
答案 D

　　首先插入题目和解析

?
1
mysql> insert into subject values(null,'人类心理现象包括',0,'人的心理现象包括心理过程和个性心理。 心理过程包括认识教程、情结与情感过程、意志教程三个相互联系的方面。 个性心理特征包括人的能力、气质、性格。具 体表现在人的个性倾向性、个性心理特征和自我意识三个方面');

　　id自增，题目为单选题

　　插入选项

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
mysql> insert into options values(null,1,'心理活动过程',1);
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into options values(null,2,'个性心理特征',1);
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into options values(null,3,'认知，情感和意志力',1);
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into options values(null,4,'心理活动过程和个性心理特征',1);
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into options values(null,5,'感觉功能、运动功能、联络功能系统',1);
Query OK, 1 row affected (0.00 sec)

　　插入答案

?
1
2
mysql> insert into answer values(null,4,1);
Query OK, 1 row affected (0.00 sec)

　　查看数据库

 　　三，在web页面展示数据

　　①设置路由

 

 

 

 　　②视图

 

 　　③模板

 

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>健康管理师练习题</title>
</head>
<body>
{#    遍历数据库提取所有题目#}
    {% for one in object_list %}
{#        显示题目题干 forloop.counter为显示序号 #}
        <p>{{ forloop.counter }}, {{ one.stem }}</p>
{#        显示选项以及对应选项的内容get_options_display为把选项1234显示成ABCD#}
        {% for options in one.options_set.all %}
            {{ options.get_options_display }}, {{ options.content }} </br>
        {% endfor %}
{#        显示答案get_options_display为把选项1234显示成ABCD#}
        {% for answer in one.answer_set.all %}
            {{ answer.get_options_display }}
        {% endfor %}
    {% endfor %}
</body>
</html>

　　web页面查看

 

 　　把答案和解析做成隐藏然后使用按键显示

?
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
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>健康管理师练习题</title>
</head>
<body>
{#    遍历数据库提取所有题目#}
    {% for one in object_list %}
{#        显示题目题干 forloop.counter为显示序号 #}
        <p>{{ forloop.counter }}, {{ one.stem }}</p>
{#        显示选项以及对应选项的内容get_options_display为把选项1234显示成ABCD#}
        {% for options in one.options_set.all %}
            {{ options.get_options_display }}, {{ options.content }} </br>
        {% endfor %}
{#        显示答案get_options_display为把选项1234显示成ABCD#}
        <p id="{{ one.id }}id" hidden>
        {% for answer in one.answer_set.all %}
            {{ answer.get_options_display }}
        {% endfor %}
        </p>
        <input type = 'button' onclick=showp("{{ one.id }}id") value='答案'/>
        <p id="{{ one.id }}explain" hidden>{{ one.explain }}</p>
        <input type = 'button' onclick=showp("{{ one.id }}explain") value='解析'>
    {% endfor %}
<script>
    {#隐藏显示函数#}
    function showp(id){
        if (document.getElementById(id).style.display == 'inline') {
            document.getElementById(id).style.display = 'none';
        }
        else {
            document.getElementById(id).style.display='inline';
        }
 
    }
</script>
</body>
</html>

　　把答案和解析先隐藏，添加按钮，如果答案是隐藏的则点击按钮显示答案如果答案是显示的则点击按钮隐藏答案，解析也是如此

　　这里把答案和解析包含在一个p标签内，id分别为使用one.id加字符串id拼接的即类似于1id 1explain的id这样保证每个p标签的id不重复并且在id内不会出现一些特殊字符导致id不可用的问题

　　页面显示

 

 

 　　四，添加数据

　　①路由

 

 

 　　②视图

 

 

 

?
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
class SubjectAddView(TemplateView):
    template_name = 'subject_add.html'
    def post(self, request):
        data = request.POST
        res = {'status': 0, 'msg': '添加成功'}
        try:
            subject = Subject()
            subject.stem = data.get('stem')
            subject.explain = data.get('explain')
            subject.type = data.get('type')
            print(data.getlist('option'))
            print(data.getlist('content'))
            print(data.getlist('explain'))
            print(data.getlist('answer'))
            subject.save()
            for one in data.getlist('option'):
                options = Options()
                options.subject_id = subject.id
 
                options.options = one
                options.content = data.getlist('content')[int(one)-1]
                options.save()
            for one in data.getlist('answer'):
                answer = Answer()
                answer.subject_id = subject.id
                answer.options = one
                answer.save()
        except Exception as e:
            print(e)
            res = {'status': 1, 'msg': '添加失败'}
        return JsonResponse(res)

　　③模板

 

 

 　　注意需要加载css js

?
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
<!DOCTYPE html>
<html lang="ch">
<head>
    <meta charset="UTF-8">
    <title>添加题目</title>
 
{#    <link href="/static/css/bootstrap.min.css" rel="stylesheet">#}
    <link href="/static/font-awesome/css/font-awesome.css" rel="stylesheet">
    <link href="/static/css/plugins/toastr/toastr.min.css" rel="stylesheet">
     <link href="/static/css/plugins/sweetalert/sweetalert.css" rel="stylesheet">
{#    <link href="/static/css/animate.css" rel="stylesheet">#}
{#    <link href="/static/css/style.css" rel="stylesheet">#}
 
</head>
<body>
 <div class="ibox-content">
        <form id="submit_form" class="form-horizontal">
            {% csrf_token %}
            <div ><label class="col-sm-2 control-label">题目内容</label>
                <div class="col-sm-6"><input type="text"  maxlength="512" size="100" name="stem" required></div>
            </div>
 
              <div ><label class="col-sm-2 control-label">题目解析</label>
{#                <div ><input type="text"maxlength="512" size="100" name="explain"></div>#}
                  <div> <textarea name="explain" cols="30" rows="10"> </textarea></div>
            </div>
            题目类型:<input type="radio" name="type" value="0" checked/>  单选 <input type="radio" name="type" value="1" /> 多选 <br/>
            <div class="form-group"><label class="col-sm-2 control-label">选项</label>
                <div ><input type="checkbox"  name="option" value=1 checked > A <input type="text"  name="content" required></div>
                <div ><input type="checkbox"  name="option" value=2 checked > B <input type="text" class="" name="content"></div>
                <div ><input type="checkbox"  name="option" value=3 checked > C <input type="text" class="" name="content"></div>
                <div ><input type="checkbox"  name="option" value=4 checked > D <input type="text" class="" name="content"></div>
                <div ><input type="checkbox"  name="option" value=5> E <input type="text" class="" name="content"> </div>
                <div ><input type="checkbox"  name="option" value=6> F <input type="text" class="" name="content"> </div>
                <div ><input type="checkbox"  name="option" value=7> G <input type="text" class="f" name="content"> </div>
                <div ><input type="checkbox"  name="option" value=8> H <input type="text" class="" name="content"> </div>
                <div ><input type="checkbox"  name="option" value=9> I <input type="text" class="" name="content"> </div>
            </div>
            <div class="form-group"><label class="col-sm-2 control-label">答案</label>
                <div class="col-sm-6"><input type="checkbox" class="" name="answer" value=1> A </div>
                <div class="col-sm-6"><input type="checkbox" class="" name="answer" value=2> B </div>
                <div class="col-sm-6"><input type="checkbox" class="" name="answer" value=3> C </div>
                <div class="col-sm-6"><input type="checkbox" class="" name="answer" value=4> D </div>
                <div class="col-sm-6"><input type="checkbox" class="" name="answer" value=5> E </div>
                <div class="col-sm-6"><input type="checkbox" class="" name="answer" value=6> F </div>
                <div class="col-sm-6"><input type="checkbox" class="" name="answer" value=7> G </div>
                <div class="col-sm-6"><input type="checkbox" class="" name="answer" value=8> H </div>
                <div class="col-sm-6"><input type="checkbox" class="" name="answer" value=9> I </div>
            </div>
 
                <div class="">
{#                    <a class="btn btn-white" type="submit" href="javascript:history.back(-1)">取消</a>#}
                    <button class="btn btn-primary" type="submit">保存更改</button>
                </div>
 
        </form>
    </div>
    <script src="/static/js/jquery-3.1.1.min.js"></script>
    <script src="/static/js/bootstrap.min.js"></script>
    <script src="/static/js/plugins/metisMenu/jquery.metisMenu.js"></script>
    <script src="/static/js/plugins/slimscroll/jquery.slimscroll.min.js"></script>
    <script src="/static/js/plugins/validate/jquery.validate.js"></script>
    <script src="/static/js/plugins/validate/messages_zh.js"></script>
    <script src="/static/js/plugins/sweetalert/sweetalert.min.js"></script>
    <script src="/static/js/inspinia.js"></script>
    <script src="/static/js/plugins/pace/pace.min.js"></script>
 
    <script>
        $(document).ready(function () {
            $("#submit_form").validate({
             submitHandler: function () {
                    var str = $('#submit_form').serialize();
                    $.post('{% url 'subject_add' %}', str, function (res) {
                        if (res.status == 0) {
                            swal({
                                title: res.msg,
                                type: 'success',
                                confirmButtonText: "确定"
                            },
                               function () {
                               window.location.href = '{% url 'index' %}';
                            });
                        } else {
                            swal({
                                title: res.msg,
                                type: 'error',
                                confirmButtonText: "确定"
                            });
                        }
                    });
                }
            });
        });
    </script>
</body>
</html>

　　首页增加一个跳转按钮至添加数据

 

 

 

 

 

 

 

 

 

 

 　代码解析

 

 　　五，更新数据

　　①路由

 

 

?
1
url(r'^update', SubjectUpdateView.as_view(), name='subject_update'),

　　②视图

 

 

?
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
class SubjectUpdateView(View):
    def get(self, request):
        return render(request, 'subject_update.html', {'subject_obj': Subject.objects.get(id=request.GET.get('id'))})
 
    def post(self, request):
        data = request.POST
        res = {'status': 0, 'msg': '修改成功'}
        try:
            subject = Subject.objects.get(id=data.get('uid'))
            print(subject)
            subject.stem = data.get('stem')
            subject.explain = data.get('explain')
            subject.type = data.get('type')
            print(data.getlist('option'))
            print(data.getlist('content'))
            print(data.getlist('answer'))
            subject.save()
            Options.objects.filter(subject_id=data.get('uid')).delete()
            for one in data.getlist('option'):
                options = Options()
                options.subject_id = subject.id
                options.options = one
                options.content = data.getlist('content')[int(one)-1]
                options.save()
            Answer.objects.filter(subject_id=data.get('uid')).delete()
            for one in data.getlist('answer'):
                answer = Answer()
                answer.subject_id = subject.id
                answer.options = one
                answer.save()
        except Exception as e:
            print(e)
            res = {'status': 1, 'msg': '修改失败'}
        return JsonResponse(res)

　　代码解析

　　更新数据和添加数据类似，不过是需要把原来数据库中已经存在的数据传递到页面，只修改需要修改的地方

　　③模板

 

 

?
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
<!DOCTYPE html>
<html lang="ch">
<head>
    <meta charset="UTF-8">
    <title>添加题目</title>
{#    <link href="/static/css/bootstrap.min.css" rel="stylesheet">#}
    <link href="/static/font-awesome/css/font-awesome.css" rel="stylesheet">
    <link href="/static/css/plugins/toastr/toastr.min.css" rel="stylesheet">
      <link href="/static/css/plugins/sweetalert/sweetalert.css" rel="stylesheet">
{#    <link href="/static/css/animate.css" rel="stylesheet">#}
{#    <link href="/static/css/style.css" rel="stylesheet">#}
 
</head>
<body>
 <div class="ibox-content">
        <form id="submit_form" class="form-horizontal">
            {% csrf_token %}
            <h1> 更新题目 {{ subject_obj.id }}</h1>
            <div class="form-group"><label class="col-sm-2 control-label">题目内容</label>
                <div class="col-sm-6"><input type="text" class="form-control" maxlength="512" size="100" name="stem" value="{{ subject_obj.stem }}" required></div>
            </div>
            <div class="hr-line-dashed"></div>
              <div class="form-group"><label class="col-sm-2 control-label">题目解析</label>
{#                <div class="col-sm-6"><input type="text" class="form-control" maxlength="512" size="100" name="explain" value="{{ subject_obj.explain }}"></div>#}
                  <div> <textarea name="explain" cols="30" rows="10" >{{ subject_obj.explain }} </textarea></div>
            </div>
            题目类型:<input type="radio" name="type" value="0" checked/>  单选 <input type="radio" name="type" value="1" /> 多选 <br/>
            <div class="form-group"><label class="col-sm-2 control-label">选项</label>
                {% for options in subject_obj.options_set.all %}
                   {% if options.options == 1 %}
                       <div class="col-sm-6"><input type="checkbox" class="form-control" name="option" value=1 checked > A <input type="text" class="form-control" name="content" value="{{ options.content }}"></div>
                       {% elif options.options == 2 %}
                        <div class="col-sm-6"><input type="checkbox" class="form-control" name="option" value=2 checked > B <input type="text" class="form-control" name="content" value="{{ options.content }}"></div>
                        {% elif options.options == 3 %}
                        <div class="col-sm-6"><input type="checkbox" class="form-control" name="option" value=3 checked > C <input type="text" class="form-control" name="content" value="{{ options.content }}"></div>
                        {% elif options.options == 4 %}
                        <div class="col-sm-6"><input type="checkbox" class="form-control" name="option" value=4 checked > D <input type="text" class="form-control" name="content" value="{{ options.content }}"></div>
                        {% elif options.options == 5 %}
                        <div class="col-sm-6"><input type="checkbox" class="form-control" name="option" value=5 checked > E <input type="text" class="form-control" name="content" value="{{ options.content }}"></div>
                        {% elif options.options == 6 %}
                        <div class="col-sm-6"><input type="checkbox" class="form-control" name="option" value=6 checked > F <input type="text" class="form-control" name="content" value="{{ options.content }}"></div>
                        {% elif options.options == 7 %}
                        <div class="col-sm-6"><input type="checkbox" class="form-control" name="option" value=7 checked > G <input type="text" class="form-control" name="content" value="{{ options.content }}"></div>
                        {% elif options.options == 8 %}
                        <div class="col-sm-6"><input type="checkbox" class="form-control" name="option" value=8 checked > H <input type="text" class="form-control" name="content" value="{{ options.content }}"></div>
                        {% elif options.options == 9 %}
                        <div class="col-sm-6"><input type="checkbox" class="form-control" name="option" value=9 checked > I <input type="text" class="form-control" name="content" value="{{ options.content }}"></div>
                   {% endif %}
                {% endfor%}
 
 
            </div>
            <div class="form-group"><label class="col-sm-2 control-label">答案</label>
                <div class="col-sm-6"><input type="checkbox" class="form-control" name="answer" value=1> A </div>
                <div class="col-sm-6"><input type="checkbox" class="form-control" name="answer" value=2> B </div>
                <div class="col-sm-6"><input type="checkbox" class="form-control" name="answer" value=3> C </div>
                <div class="col-sm-6"><input type="checkbox" class="form-control" name="answer" value=4> D </div>
                <div class="col-sm-6"><input type="checkbox" class="form-control" name="answer" value=5> E </div>
                <div class="col-sm-6"><input type="checkbox" class="form-control" name="answer" value=6> F </div>
                <div class="col-sm-6"><input type="checkbox" class="form-control" name="answer" value=7> G </div>
                <div class="col-sm-6"><input type="checkbox" class="form-control" name="answer" value=8> H </div>
                <div class="col-sm-6"><input type="checkbox" class="form-control" name="answer" value=9> I </div>
            </div>
 
            <div class="hr-line-dashed"></div>
            <div class="form-group">
                <div class="col-sm-4 col-sm-offset-2">
                     <input hidden value="{{ subject_obj.id }}" name="uid">
{#                    <a class="btn btn-white" type="submit" href="javascript:history.back(-1)">取消</a>#}
                    <button class="btn btn-primary" type="submit">保存更改</button>
                </div>
            </div>
        </form>
    </div>
    <script src="/static/js/jquery-3.1.1.min.js"></script>
    <script src="/static/js/bootstrap.min.js"></script>
    <script src="/static/js/plugins/metisMenu/jquery.metisMenu.js"></script>
    <script src="/static/js/plugins/slimscroll/jquery.slimscroll.min.js"></script>
    <script src="/static/js/plugins/validate/jquery.validate.js"></script>
    <script src="/static/js/plugins/validate/messages_zh.js"></script>
    <script src="/static/js/plugins/sweetalert/sweetalert.min.js"></script>
    <script>
        $(document).ready(function () {
            $("#submit_form").validate({
                rules: {
                    name_cn: {
                        required: true
                    },
                    username: {
                        required: true
                    },
                    email: {
                        required: true
                    },
                    password: {
                        required: true
                    },
                    phone: {
                        required: true,
                        minlength:11
                    },
                    wechat: {
                        required: true
                    }
                }, submitHandler: function () {
                    var str = $('#submit_form').serialize();
                    $.post('{% url 'subject_update' %}', str, function (res) {
                        if (res.status == 0) {
                            swal({
                                title: res.msg,
                                type: 'success',
                                confirmButtonText: "确定"
                            }, function () {
                                window.location.href = '{% url 'index' %}';
                            });
                        } else {
                            swal({
                                title: res.msg,
                                type: 'error',
                                confirmButtonText: "确定"
                            });
                        }
                    });
                }
            });
        });
    </script>
</body>
</html>

　　注意：本次有bug 例如更新数据只能更新原有选项一样多的数量选项，不能添加选项，答案没有按原有答案选中，需要重新选

　　在首页添加一个更新数据的按键

 

 　　页面显示

 

 

 

 

 

 

 　　六，删除数据

　　①路由

 

 　　②视图

 

 

?
1
2
3
4
5
6
7
8
9
10
class SubjectDeleteView(View):
    def get(self, request):
        data = request.GET
        res = {'status': 0, 'msg': '删除成功'}
        try:
            Subject.objects.get(id=data.get('id')).delete()
        except Exception as e:
            print(e)
            res = {'status': 1, 'msg': '删除失败'}
        return JsonResponse(res)

　　这里直接删除题目应该会同时清除选修班表和答案表，如果删除是出现外键关联错误导致无法删除可以，修改代码先删除选修表和答案表以后再删除题目表

?
1
2
3
Options.objects.filter(subject_id=data.get('id')).delete()
Answer.objects.filter(subject_id=data.get('id')).delete()
Subject.objects.get(id=data.get('id')).delete()

　　

　　③模板

　　删除数据没有单独的模板，在index页面添加删除函数

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
function subject_delete(id) {
            if (confirm('确认删除吗？')) {
            {#alert(id)#}
                $.get("{% url 'subject_delete' %}?id=" + id,function (data) {
                if(data.status == 0) {
                    swal({
                        title: data.msg,
                        icon: "success",
                        confirmButtonText: '确定',
                    }, function () {
                        window.location.reload()
                    });
                    } else {
                    swal("删除失败", {
                        icon: "error",
                    });
                }
            });
            }
        }

 

 　　在页面增加删除按键

 

 

?
1
<a type = 'button' onclick="subject_delete({{ one.id }})">删除</a>

　　页面显示

 

 

 

 

 

 　　七，随机生成一套试卷

　　首先创建一套试卷表，和题目表类似

　　设计表结构如下

 

 　　模板

 

 

?
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
# 试卷表开始
class Test_Paper_Subject(models.Model):
    stem = models.CharField(max_length=254, verbose_name='题干内容', blank=False, null=False, unique=True)
    type = models.IntegerField(choices=Type, verbose_name='题目类型,单选还是多选')
    explain = models.CharField(max_length=512, verbose_name='题目答案解析', blank=False, null=False)
    test_paper = models.ForeignKey('Test_Paper')
 
    class Meta:
        db_table = 'test_paper_subject'
        verbose_name = '题干表'
 
class Test_Paper_options(models.Model):
    options = models.IntegerField(choices=Option, verbose_name='选项ABCDEFGH')
    content = models.CharField(max_length=256, verbose_name='选项内容')
    subject = models.ForeignKey('Test_Paper_Subject')
 
    class Meta:
        db_table = 'test_paper_options'
        verbose_name = '选项表'
        unique_together = ('subject', 'content')
        ordering = ['options']
 
class Test_Paper_Answer(models.Model):
    options = models.IntegerField(choices=Option, verbose_name='选项ABCDEFGH')
    subject = models.ForeignKey('Test_Paper_Subject')
 
    class Meta:
        db_table = 'test_paper_answer'
        verbose_name = '答案表'
        unique_together = ('subject', 'options')
        ordering = ['options']
 
class Test_Paper(models.Model):
    class Meta:
        db_table = 'test_paper'
 
# 试卷表结束

　　更新数据库

?
1
2
python manage.py makemigrations subject
python manage.py migrate subject

　　

 

 　　查看数据库多出的几张表

 

 

　　在数据库插入一定数据以后随机生成一套试卷其中单选70道多选30道

　　①路由

 

 

?
1
url(r'^test_paper_add', TestPaperAdd.as_view(), name=''),

　　②视图

 

 　　

?
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
class TestPaperAdd(View):
    def get(self, request):
        subject_obj = Subject.objects.filter(type=0).order_by('?')[:70]
        subject_obj2 = Subject.objects.filter(type=1).order_by('?')[:30]
        # subject_obj = Subject.objects.all()
        Test_Paper.objects.all().delete()
        test_paper = Test_Paper()
        test_paper.save()
        test_paper_id = test_paper.id
        print(test_paper_id)
 
        for one in subject_obj:
            test_paper_subject = Test_Paper_Subject()
            test_paper_subject.stem = one.stem
            test_paper_subject.type = one.type
            test_paper_subject.explain = one.explain
            test_paper_subject.test_paper_id = test_paper_id
            test_paper_subject.save()
 
            for options in one.options_set.all():
                test_paper_options = Test_Paper_options()
                print(options.options)
                test_paper_options.options = options.options
                print(options.content)
                test_paper_options.content = options.content
                print(test_paper_subject.id)
                test_paper_options.subject_id = test_paper_subject.id
                test_paper_options.save()
 
            for answer in one.answer_set.all():
                test_paper_answer = Test_Paper_Answer()
                print(answer.options)
                test_paper_answer.options = answer.options
                test_paper_answer.subject_id = test_paper_subject.id
                test_paper_answer.save()
 
        for one in subject_obj2:
            test_paper_subject = Test_Paper_Subject()
            test_paper_subject.stem = one.stem
            test_paper_subject.type = one.type
            test_paper_subject.explain = one.explain
            test_paper_subject.test_paper_id = test_paper_id
            test_paper_subject.save()
 
            for options in one.options_set.all():
                test_paper_options = Test_Paper_options()
                print(options.options)
                test_paper_options.options = options.options
                print(options.content)
                test_paper_options.content = options.content
                print(test_paper_subject.id)
                test_paper_options.subject_id = test_paper_subject.id
                test_paper_options.save()
 
            for answer in one.answer_set.all():
                test_paper_answer = Test_Paper_Answer()
                print(answer.options)
                test_paper_answer.options = answer.options
                test_paper_answer.subject_id = test_paper_subject.id
                test_paper_answer.save()
 
        return HttpResponse('随机生成一套试卷')

　　代码解析

 

 　　页面生成一套试卷

 

 　　显示试卷

　　①路由

 

 

?
1
url(r'^test_paper_show', TestPaperShow.as_view(), name=''),

　　②视图

 

 

?
1
2
3
4
5
6
7
class TestPaperShow(View):
    def get(self, request):
        data = Test_Paper.objects.all()
        # print(data, data.test_paper_subject_set.all())
        for one in data:
            data2 = one.test_paper_subject_set.all()
        return render(request, 'test_paper_show.html', {'object_list': data2})

　　③模板

 

 

?
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
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>试卷</title>
</head>
<body>
    {% for one in object_list  %}
        {% if one.type == 0 %}
            <p>单选</p>
        {% else %}
            <p>多选</p>
        {% endif %}
{#        显示题干#}
        <p>{{ forloop.counter }} , {{ one.stem }}</p>
 
{#        显示选项及内容#}
        <form id="{{ one.id }}">
         {% csrf_token %}
        {% for options in one.test_paper_options_set.all %}
            {% if one.type == 0 %}
                <input type="radio" name={{ one.id }} value="{{ options.options }}"> {{ options.get_options_display }} , {{ options.content }}
                {% else %}
                <input type="checkbox"  name={{ one.id }} value="{{ options.options }}">  {{ options.get_options_display }} , {{ options.content }}
            {% endif %}
            <br/>
        {% endfor %}
{#        <button class="btn btn-primary" type="submit">确定</button>#}
        <form/>
{#        显示答案#}
        <p id="{{ one.id }}id" hidden>
        {% for answer in one.test_paper_answer_set.all %}
           {{ answer.get_options_display }}
        {% endfor %}
        </p>
        <input type = 'button' onclick=showp("{{ one.id }}id") value='答案'/>
 
 
{#        显示解析#}
        <p id="{{ one.id }}explain" hidden >{{ one.explain }} </p>
        <input type = 'button' onclick=showp("{{ one.id }}explain") value='解析'>
        <a type = 'button' href="{% url 'subject_update' %}?id={{ one.id }}">修改</a>
{#        <a type = 'button' onclick="subject_delete({{ one.id }})">删除</a>#}
 
    {% endfor %}
<script src="/static/js/jquery-3.1.1.min.js"></script>
<script src="/static/js/bootstrap.min.js"></script>
<script src="/static/js/plugins/metisMenu/jquery.metisMenu.js"></script>
<script src="/static/js/plugins/slimscroll/jquery.slimscroll.min.js"></script>
<script src="/static/js/plugins/validate/jquery.validate.js"></script>
<script src="/static/js/plugins/validate/messages_zh.js"></script>
<script src="/static/js/plugins/sweetalert/sweetalert.min.js"></script>
<!-- Custom and plugin javascript -->
<script src="/static/js/inspinia.js"></script>
<script src="/static/js/plugins/pace/pace.min.js"></script>
        <script type="text/javascript">
        function showp(id){
                if (document.getElementById(id).style.display == 'inline') {
                    document.getElementById(id).style.display = 'none';
                }
                else {
                     document.getElementById(id).style.display='inline';
                }
 
            }
 
        function subject_delete(id) {
            if (confirm('确认删除吗？')) {
            {#alert(id)#}
                $.get("{% url 'subject_delete' %}?id=" + id,function (data) {
                if(data.status == 0) {
                    swal({
                        title: data.msg,
                        icon: "success",
                        confirmButtonText: '确定',
                    }, function () {
                        window.location.reload()
                    });
                    } else {
                    swal("删除失败", {
                        icon: "error",
                    });
                }
            });
            }
        }
 
        </script>
</body>
</html>

　　web页面查看

 

 

 

 

 

　　

posted @   minseo  阅读(1506)  评论(0)  编辑  收藏  举报
编辑推荐：
· SQL Server 2025 AI相关能力初探
· Linux系列：如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
阅读排行：
· 阿里最新开源QwQ-32B，效果媲美deepseek-r1满血版，部署成本又又又降低了！
· AI编程工具终极对决：字节Trae VS Cursor，谁才是开发者新宠？
· 开源Multi-agent AI智能体框架aevatar.ai，欢迎大家贡献代码
· Manus重磅发布：全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后，我竟然真的恢复了删除的微信聊天记录！
历史上的今天：
2020-04-01 docker删除none的镜像
点击右上角即可分享
微信分享提示
AI IDE Trae