python Django学生管理

电玩女神 2021-12-12 09:13 217阅读 0赞

### Django 学生管理系统 ###

####  1. 一对一 班级  模态增加 编辑 ####

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
        <style>
    
            .hide{
                display: none;
            }
            .shadow{
                position: fixed;
                left: 0;
                top: 0;
                right: 0;
                bottom: 0;
                background-color: black;
                opacity: 0.4;
                z-index: 999;
            }
            .modal{
                z-index: 1000;
                position: fixed;
                left: 50%;
                top: 50%;
                height: 300px;
                width: 400px;
                background-color: white;
                margin-left: -200px;
                margin-top: -150px;
            }
    
            .del_class{
                z-index: 1001;
                position: fixed;
                left: 50%;
                top: 50%;
                height: 150px;
                width: 300px;
                background-color: white;
                margin-left: -150px;
                margin-top: -75px;
            }
    
            .edit_class{
                z-index: 1002;
                position: fixed;
                left: 50%;
                top: 50%;
                height: 150px;
                width: 300px;
                background-color: white;
                margin-left: -150px;
                margin-top: -75px;
            }
        </style>
    </head>
    <body>
    
        <h1>班级列表</h1>
    
        <div>
            <a οnclick="showModal();">模态框增加</a>
        </div>
    
        <table border="1px">
            <thead>
                <tr>
                    <td>ID</td>
                    <td>班级名称</td>
    
                    <td>模态操作</td>
                </tr>
            </thead>
            <tbody>
                {
            % for row in data %}
                    <tr>
                        <td>{
           { row.cid }}</td>
                        <td>{
           { row.title }}</td>
    
                        <td>
                            <a οnclick="modelEdit(this)">编辑</a>
                            <a οnclick="DelClass({
            { row.cid }})">删除</a>
                        </td>
                    </tr>
                {
            % endfor %}
            </tbody>
        </table>
    
        {
            #    遮罩#}
        <div id="shadow" class="shadow hide"></div>
    
        {
            #    增加#}
        <div id="addmodal" class="modal hide">
            <p>班级名称:
                <input id="addtitle" type="text" name="title" />
            </p>
            <input type="button" value="提交" οnclick="AjaxSend();"  /><span id="errormsg"></span>
            <input type="button" value="取消" οnclick="cancleModal();" />
        </div>
    
        {
            #    编辑#}
        <div id="editModal" class="modal hide">
            <h3>编辑</h3>
            <input id="editId" type="text" name="id" style="display: none">
            <p>班级名称<input id="editTitle" type="text" name="title" ></p>
            <input type="button" value="提交" οnclick="editAjaxSend()"><span id="errormsg"></span>
            <input type="button" value="取消" οnclick="cancleModal()">
        </div>
    
    
        <script src="/static/jquery-3.2.1.js"></script>
    
        <script>
    
    
            {
            #        增加#}
            function showModal() {
                $("#addmodal,#shadow").removeClass("hide");
            }
    
            function AjaxSend() {
                title=$("#addtitle").val();
                $.ajax({
                    url: '/motai_add_class/',
                    type: 'POST',
                    data: {
            'title': title},
                    success: function(arg){
                        arg = JSON.parse(arg);
                        if(arg.status){
                            location.reload();
                        }else{
                            alert(arg.message);
                        }
                    }
                })
            }
    
    
            {
            #        编辑#}
            function modelEdit(self) {
                $("#editModal,#shadow").removeClass("hide");
    
                var title=$(self).parent().prevAll().eq(0).text();
                var id=$(self).parent().prevAll().eq(1).text();
                $("#editTitle").val(title);
                $("#editId").val(id);
            }
    
            function editAjaxSend() {
                id = $("#editId").val();
                title = $("#editTitle").val();
                $.ajax({
                    url: '/modal_edit_class/',
                    type: 'POST',
                    data: {
            "id":id,"title": title},
                    success: function(arg){
                        arg = JSON.parse(arg);
                        if(arg.status){
                            location.reload();
                        }else{
                            alert(arg.message);
                        }
                    }
                })
            }
    
    
            {
            #        隐藏#}
            function cancleModal() {
                $("#shadow").addClass("hide");
                $("#addmodal").addClass("hide");
                $("#editModal").addClass("hide")
            }
    
        </script>
    
    
    </body>
    </html>

classes.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

def classes(request):
        data = sqlheper.get_list("select cid,title from class",[])
        return render(request, "classes.html", {
           "data": data})
    
    
    def motai_add_class(request):
        ret = {
           'status': True, 'message': None}
        title = request.POST.get('title')
        try:
            nid = request.POST.get('nid')
            content = request.POST.get('content')
            sqlheper.motify_sql('insert into class(title) values(%s)',[title,])
        except Exception as e:
            ret['status'] = False
            ret['message'] = "处理异常"
    
        return HttpResponse(json.dumps(ret))
    
    def modal_edit_class(request):
        print(request.POST)
        ret = {
           'status': True, 'message':None}
        try:
            id = request.POST.get('id')
            title = request.POST.get('title')
            sqlheper.motify_sql('update class set title=%s where cid=%s',[title,id,])
        except Exception as e:
            ret['status'] = False
            ret['message'] = "处理异常"
    
        return HttpResponse(json.dumps(ret))

views.py

#### 2.一对多 学生班级  模态增加 编辑 ####

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

student.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

def student(request):
        student_list = sqlheper.get_list("select student.sid,student.name,student.class_id,class.title from student left join class on student.class_id=class.cid",[])
    
        class_list = sqlheper.get_list("select cid,title from class",[])
    
        return render(request, "student.html", {
           "student_list":student_list, "class_list":class_list})
    
    
    def motai_add_student(request):
        print(request.POST)
        ret = {
           "status":True,"message":None}
        try:
            name = request.POST.get("add_name")
            age = request.POST.get("add_age")
            classId = request.POST.get("add_classId")
    
            sqlheper.motify_sql("insert into student(name,age,class_id) values(%s,%s,%s)",[name,age,classId,])
        except Exception as e:
            ret["status"] = False
            ret["message"] = str(e)
        return HttpResponse(json.dumps(ret))
    
    def motai_edit_student(request):
        ret = {
           'status': True,'message': None}
        try:
    
            print(request.POST)
            sid = request.POST.get('sid')
            name = request.POST.get('name')
            class_id = request.POST.get('class_id')
            sqlheper.motify_sql('update student set name=%s,class_id=%s where sid=%s',[name,class_id,sid,])
        except Exception as e:
            ret['status'] = False
            ret['message'] = str(e)
        return HttpResponse(json.dumps(ret))
    复制代码

views.py

#### 3.多对多 老师 班级  模态增加 编辑 ####

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

teacher.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

def teacher(request):
    
        teacher_list=sqlheper.get_list("""
        select teacher.tid as tid,teacher.name,class.title from teacher
        left join teacher_class on teacher_class.teacher_id=teacher.tid
        left join class on class.cid=teacher_class.class_id""",[])
        # print(teacher_list)
        result = {}
        for row in teacher_list:
            tid = row["tid"]
            if tid in result:
                result[tid]["titles"].append(row["title"])
            else:
                result[tid] = {
           "tid":row["tid"],"name":row["name"],"titles":[row["title"],]}
    
        class_list = sqlheper.get_list("select cid,title from class",[])
    
        return render(request, "teacher.html_模态增加 老师班级", {
           "teacher_list":result.values(), "class_list":class_list})
    
    ###模态增加
    def new_teacher(request):
        print(request.POST)
        ret = {
           'status': True, 'message': None}
        try:
            class_list=request.POST.getlist("class_list[]")
            tname=request.POST.get("tname")
            print(class_list)
            print(tname)
            teacher_id=sqlheper.get_IncrementId("insert into teacher(name) values(%s)",[tname,])
            for item in class_list:
                sqlheper.motify_sql("insert into teacher_class(teacher_id,class_id) values(%s,%s)",[teacher_id,item,])
        except Exception as e:
            ret['status'] = False
            ret['message'] = str(e)
        return HttpResponse(json.dumps(ret))
    
    views.py

views.py

#### 4.多对多 老师 班级  新url  增加 编辑 ####

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
    
    </head>
    <body>
    
    <h1>老师 班级管理</h1>
    
    <div>
    
        <a href="/add_page_teacher/">增加</a>
    </div>
    
    <table border="solid"  >
        <thead>
            <tr>
                <td>ID</td>
                <td>老师名称</td>
                <td>班级名称</td>
                <td>操作</td>
            </tr>
        </thead>
        <tbody>
            {
            % for row in teacher_list %}
                <tr>
                    <td>{
           { row.tid }}</td>
                    <td>{
           { row.name }}</td>
                    <td>
                        {
            % for item in row.titles %}
                            {
            { item }}
                        {
            % endfor %}
                    </td>
                    <td>
                        <a href="/edit_page_teacher/?tid={
            { row.tid }}">编辑</a>
                        <a >删除</a>
                    </td>
                </tr>
            {
            % endfor %}
        </tbody>
    
    </table>
    
    
    </body>
    </html>

teacher.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
    </head>
    <body>
    
    <h1>增加老师</h1>
    
    <form action="/add_teacher/" method="POST">
        <p>老师名称: <input type="text" name="name"></p>
        <input type="submit">
    </form>
    
    </body>
    </html>

add\_page\_teacher.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
    </head>
    <body>
    
    <h3>编辑老师班级</h3>
    
    
    <form action="/edit_page_teacher/?tnid={
            { tname.tid }}" method="post">
    
        <p>老师名称:<input type="text" name="name" value="{
            { tname.name }}"></p>
    
        <p>班级名称:
        <select name="class_ids" multiple size="7">
            {
            % for item in class_list %}
                {
            % if item.cid in class_ids %}
                    <option selected value="{
            { item.cid }}">{
           { item.title }}</option>
                {
            % else %}
                    <option value="{
            { item.cid }}">{
           { item.title }}</option>
                {
            % endif %}
            {
            % endfor %}
        </select>
    
        <p><input type="submit" value="提交"></p>
        </p>
    
    </form>
    
    
    </body>
    </html>

edit\_page\_teacher.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

###网页显示
    def teacher(request):
    
        teacher_list=sqlheper.get_list("""
        select teacher.tid as tid,teacher.name,class.title from teacher
        left join teacher_class on teacher_class.teacher_id=teacher.tid
        left join class on class.cid=teacher_class.class_id""",[])
        # print(teacher_list)
        result = {}
        for row in teacher_list:
            tid = row["tid"]
            if tid in result:
                result[tid]["titles"].append(row["title"])
            else:
                result[tid] = {
           "tid":row["tid"],"name":row["name"],"titles":[row["title"],]}
    
        class_list = sqlheper.get_list("select cid,title from class",[])
    
        return render(request, "teacher.html", {
           "teacher_list":result.values(), "class_list":class_list})
    
    
    ###网页增加
    def add_page_teacher(request):
        if request.method=="GET":
            obj = sqlheper.SqlHelper()
            class_list = obj.get_list("select cid,title from class",[])
            obj.close()
            return render(request,"add_page_teacher.html",{
           "class_list":class_list})
        else:
    
            name = request.POST.get("name")
            obj = sqlheper.SqlHelper()
            teacher_id = obj.get_lastrowid("insert into teacher(name) values(%s)",[name,])
            obj.close()
    
    
            class_ids = request.POST.getlist("class_ids")
            print(class_ids)
    
            data_list = []
            for cls_id in class_ids:
                temp = (teacher_id, cls_id,)
                data_list.append(temp)
    
            obj = sqlheper.SqlHelper()
            obj.multiple_modify('insert into teacher_class(teacher_id,class_id) values(%s,%s)', data_list)
            obj.close()
            return redirect('/teacher/')
    
    
    ###网页编辑
    def edit_page_teacher(request):
        if request.method=="GET":
            teacher_id = request.GET.get("tid")
            obj = sqlheper.SqlHelper()
            tname = obj.get_one("select tid,name from teacher where tid=%s",[teacher_id,])
    
    
            class_list = obj.get_list("select cid,title from class",[])
    
            class_ids = obj.get_list("select class_id from teacher_class where teacher_id =%s",[teacher_id,])
            obj.close()
    
            temp = []
            for i in class_ids:
                temp.append(i['class_id'])
    
            return render(request,"edit_page_teacher.html",{
                "tname":tname,
                "class_list":class_list,
                "class_ids":temp,
            })
        else:
            tid=request.GET.get("tnid")
            name=request.POST.get("name")
            class_ids=request.POST.getlist("class_ids")
    
            obj = sqlheper.SqlHelper()
            obj.modify("update teacher set name=%s where tid=%s",[name,tid,])
            obj.modify('delete from teacher_class where teacher_id=%s',[tid,])
            data_list = []
            for cls_id in class_ids:
                temp = (tid,cls_id)
                data_list.append(temp)
            obj.multiple_modify('insert into teacher_class(teacher_id,class_id) values(%s,%s)',data_list)
            obj.close()
            return redirect('/teacher/')

views.py

#### 5.多对多 老师 班级 模态  增加 编辑 ####

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
        <style>
            .hide{
                display: none;
            }
            .shadow{
                position: fixed;
                top: 0;
                bottom: 0;
                left: 0;
                right: 0;
                background-color: black;
                z-index: 999;
                opacity: 0.4;
            }
            .loading{
                position: fixed;
                width: 32px;
                height: 32px;
                left: 50%;
                top:50%;
                margin-left: -16px;
                margin-top: -16px;
                background-color: rebeccapurple;
                background-image: url("/static/images/loading.gif") ;
                background-size: 100%;
    
            }
            .Modal{
                position: fixed;
                top: 50%;
                left: 50%;
                width: 400px;
                height: 300px;
                margin-left: -200px;
                margin-top: -150px;
                z-index: 1000;
                background-color: white;
            }
        </style>
        <link rel="stylesheet" href="/static/plugins/bootstrap-3.3.7-dist/css/bootstrap.css">
        <link rel="stylesheet" href="/static/plugins/font-awesome-4.7.0/css/font-awesome.css">
    </head>
    <body>
    
    <h1 >老师 班级管理</h1>
    
    <div class="btn btn-success">
    
        <a id="addModal">模态框增加</a>
    </div>
    
    <table border="solid" class="table table-striped">
        <thead>
            <tr>
                <td>ID</td>
                <td>老师名称</td>
                <td>班级名称</td>
                <td>操作</td>
            </tr>
        </thead>
        <tbody>
            {
            % for row in teacher_list %}
                <tr>
                    <td>{
           { row.tid }}</td>
                    <td>{
           { row.name }}</td>
                    <td>
                        {
            % for item in row.titles %}
                            {
            { item }}
                        {
            % endfor %}
                    </td>
                    <td>
                        <a class="editModal">编辑</a>
                        <a class="delModal">删除</a>
                    </td>
                </tr>
            {
            % endfor %}
        </tbody>
    
    </table>
    
    <div id="shadow" class="shadow hide"></div>
    
    <div id="loading" class="loading hide"></div>
    
    <div id="add_tea_cls" class="Modal hide">
    
        <p>老师名称:
            <input id="add_name" type="text" name="add_name">
        </p>
    
        <p>班级名称:
            <select id="add_classId" name="add_classId" multiple size="10">
    
            </select>
        </p>
        <input id="btnAdd" type="button" value="提交"><span id="addError"></span>
        <input id="btnCancle" type="button" value="取消">
    
    </div>
    
    <div id="edit_tea_cls" class="Modal hide">
        <input type="text" id="hide_id" style="display: none">
    
        <p>老师名称:
            <input id="edit_name" type="text" name="add_name">
        </p>
    
        <p>班级名称:
            <select id="edit_classId" name="edit_classId" multiple size="10">
    
            </select>
        </p>
        <input id="btnEdit" type="button" value="提交"><span id="addError"></span>
        <input id="cacleEdit" type="button" value="取消">
    
    </div>
    
    
    <script src="/static/jquery-3.2.1.js"></script>
    
    <script>
    
        $(function () {
    
    
            {
            #        增加#}
            $("#addModal").click(function () {
                $("#shadow,#loading").removeClass("hide");
                $.ajax({
                    url:"/get_all_class/",
                    type:"GET",
                    dataType:"JSON",
                    success:function (arg) {
                        $.each(arg,function (i,row) {
                            var tag = $("<option>");        /*var tag = document.createElement('option');*/
                            tag.text(row.title);            /*tag.innerHTML = row.title;*/
                            tag.prop("value",row.cid);
                            $("#add_classId").append(tag);  /*tag.setAttribute('value',row.id);*/
                        });
                        $('#loading').addClass('hide');
                        $('#add_tea_cls').removeClass('hide');
                    }
                })
            });
    
            $("#btnCancle").click(function () {
                $("#shadow,#add_tea_cls").addClass("hide");
            });
    
            $("#btnAdd").click(function () {
                var tname=$("#add_name").val();
                var class_list=$("#add_classId").val();
                console.log(class_list);
                $.ajax({
                    url:"/new_teacher/",
                    type:"POST",
                    data:{
            "tname":tname,"class_list":class_list},
                    dataType:"JSON",
                    traditional: true, // 如果提交的数据的值有列表，则需要添加此属性
                    success:function (arg) {
    
                        if (arg.status){
                            location.reload();
                        }else {
                            alert(arg.message);
                        }
                    }
                })
            });
    
    
    
            {
            #        编辑#}
            $(".editModal").click(function () {
                $("#shadow,#loading").removeClass("hide");
                var ids=$(this).parent().prevAll()[2];
                var id=$(ids).text();
                $("#hide_id").val(id);
                $.ajax({
                    url: "/edit_tea_cls/",
                    type: "POST",
                    dataType: "JSON",
                    data:{
            "id":id},
                    success: function (arg) {
    
                        class_list = arg[0];
                        teacher_info = arg[1];
                        class_lds = arg[2];
                        console.log(class_lds);
                        $("#edit_classId").empty();
                        $.each(class_list, function (i, row) {
                            var tag = $("<option>");
                            tag.text(row.title);
                            tag.prop("value", row.cid);
    
                            if(class_lds.indexOf(row.cid) == -1){
                                $("#edit_classId").append(tag);
                            }else {
                                tag.prop("selected","selected");
                                $("#edit_classId").append(tag);
                            }
                        });
                        $("#edit_name").val(teacher_info["name"]);
    
    
    
    
    
    
    
                        $('#loading').addClass('hide');
                        $('#edit_tea_cls').removeClass('hide');
                    }
                });
    
                $("#cacleEdit").click(function () {
                    $("#shadow,#edit_tea_cls").addClass("hide");
                });
            })
    
            {
            #        编辑提交#}
            $("#btnEdit").click(function () {
                var tid= $("#hide_id").val();
                var name = $("#edit_name").val();
                var class_ids = $("#edit_classId").val();
                $.ajax({
                    url:"/modal_edit_teacher/",
                    type:"post",
                    dataType:"JSON",
                    traditional:true,
                    data:{
            "tid":tid,"name":name,"del_class_id":del_class_id},
                    $.ajax({
                    url:"/modal_edit_teacher/",
                    type:"post",
                    dataType:"JSON",
                    traditional:true,
                    data:{
            "tid":tid,"name":name,"class_ids":class_ids},
                    success:function (arg) {
                        if (arg.status){
                            location.reload();
                        }else {
                            alert("111")
                        }
                    }
                })
                })
            })
        })
    
    
    </script>
    
    </body>
    </html>

teacher.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

#显示
    def teacher(request):
    
        tk = request.COOKIES.get("ticket")
        if not tk:
            return redirect("/login/")
    
        teacher_list=sqlheper.get_list("""
        select teacher.tid as tid,teacher.name,class.title from teacher
        left join teacher_class on teacher_class.teacher_id=teacher.tid
        left join class on class.cid=teacher_class.class_id""",[])
        # print(teacher_list)
        result = {}
        for row in teacher_list:
            tid = row["tid"]
            if tid in result:
                result[tid]["titles"].append(row["title"])
            else:
                result[tid] = {
           "tid":row["tid"],"name":row["name"],"titles":[row["title"],]}
    
    
        return render(request, "teacher.html", {
           "teacher_list":result.values()})
    
    #增加
    def get_all_class(request):
        import time
        time.sleep(1)
        obj = sqlheper.SqlHelper()
        class_list = obj.get_list('select cid,title from class',[])
        obj.close()
        return HttpResponse(json.dumps(class_list))
    
    def new_teacher(request):
    
        ret = {
           'status': True, 'message': None}
        try:
            class_list=request.POST.getlist("class_list")
            tname=request.POST.get("tname")
            teacher_id=sqlheper.get_IncrementId("insert into teacher(name) values(%s)",[tname,])
    
            data_list = []
            for cls_id in class_list:
                temp = (teacher_id,cls_id,)
                data_list.append(temp)
    
            obj = sqlheper.SqlHelper()
            obj.multiple_modify('insert into teacher_class(teacher_id,class_id) values(%s,%s)', data_list)
            obj.close()
        except Exception as e:
            ret['status'] = False
            ret['message'] = str(e)
        return HttpResponse(json.dumps(ret))
    
    
    #编辑
    def edit_tea_cls(request):
    
        id = request.POST.get("id")
        obj = sqlheper.SqlHelper()
        class_list = obj.get_list('select cid,title from class',[])
    
        teacher_info = obj.get_one("select tid,name from teacher where tid=%s",[id,])
    
        class_id = obj.get_list("select class_id from teacher_class where teacher_id=%s",[id,])
    
        data_list = []
        for cls_id in class_id:
            data_list.append(cls_id["class_id"])
    
    
    
        print(teacher_info)
        total = []
        total.append(class_list)
        total.append(teacher_info)
        total.append(data_list)
        obj.close()
        return HttpResponse(json.dumps(total))
    
    def modal_edit_teacher(request):
        ret = {
           'status': True, 'message': None}
        try:
            name = request.POST.get("name")
            tid = request.POST.get("tid")
            class_ids = request.POST.getlist("class_ids")
    
    
            obj = sqlheper.SqlHelper()
            obj.modify("update teacher set name=%s where tid=%s", [name, tid, ])
            obj.modify('delete from teacher_class where teacher_id=%s', [tid, ])
            data_list = []
            for cls_id in class_ids:
                temp = (tid, cls_id)
                data_list.append(temp)
            obj.multiple_modify('insert into teacher_class(teacher_id,class_id) values(%s,%s)', data_list)
            obj.close()
        except Exception as e:
            ret['status'] = False
            ret['message'] = str(e)
        return HttpResponse(json.dumps(ret))

views.py

### 二、Form 学生信息 ###

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

urlpatterns = [
        url(r'^admin/', admin.site.urls),
    
        url(r'^class_list/', views.class_list),
        url(r'^add_class/', views.add_class),
        url(r'^edit_class/(\d+)/', views.edit_class),
    
        url(r'^student_list/', views.student_list),
        url(r'^add_student/', views.add_student),
        url(r'^edit_student/(\d+)/', views.edit_student),
    
        url(r'^teacher_list/', views.teacher_list),
        url(r'^add_teacher/', views.add_teacher),
        url(r'^edit_teacher/(\d+)/', views.edit_teacher),
    
    ]

urls.py

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

from django.shortcuts import render,redirect,HttpResponse
    from app01 import models
    from django.forms import Form
    from django.forms import fields
    from django.forms import widgets
    from django.forms import models as form_model
    from django.core.exceptions import ValidationError
    from django.core.validators import RegexValidator
    
    
    
    class ClassForm(Form):
        title = fields.RegexField('全栈\d+')
    
    def class_list(request):
        cls_list = models.Classes.objects.all()
        return render(request,'class_list.html',{
           'cls_list':cls_list})
    
    def add_class(request):
        if request.method == "GET":
            obj = ClassForm()
            return render(request,'add_class.html',{
           'obj': obj})
        else:
            obj = ClassForm(request.POST)
            if obj.is_valid():
                # obj.cleaned_data # 字典
                # 数据库创建一条数据
                # print(obj.cleaned_data)
                # models.Classes.objects.create(title=obj.cleaned_data['tt'])
    
                models.Classes.objects.create(**obj.cleaned_data)
                return redirect('/class_list/')
            return render(request,'add_class.html',{
           'obj': obj})
    
    def edit_class(request,nid):
        if request.method == "GET":
            row = models.Classes.objects.filter(id=nid).first()
            # 让页面显示初始值
            # obj = ClassForm(data={'title': 'asdfasdfasdfas'})
            obj = ClassForm(initial={
           'title': row.title})
            return render(request,'edit_class.html',{
           'nid': nid,'obj':obj})
        else:
            obj = ClassForm(request.POST)
            if obj.is_valid():
                print(obj.cleaned_data)
                models.Classes.objects.filter(id=nid).update(**obj.cleaned_data)
                return redirect('/class_list/')
            return render(request,'edit_class.html',{
           'nid': nid,'obj':obj})
    
    
    
    class StudentForm(Form):
        name = fields.CharField(
            min_length=2,
            max_length=6,
            widget=widgets.TextInput(attrs={
           'class': 'form-control'})
        )
        email = fields.EmailField(widget=widgets.TextInput(attrs={
           'class': 'form-control'}))
        age = fields.IntegerField(min_value=18,max_value=25,widget=widgets.TextInput(attrs={
           'class': 'form-control'}))
        cls_id = fields.IntegerField(
            # widget=widgets.Select(choices=[(1,'上海'),(2,'北京')])
            widget=widgets.Select(choices=models.Classes.objects.values_list('id','title'),attrs={
           'class': 'form-control'})
        )
    
    
    def student_list(request):
    
        stu_list = models.Student.objects.all()
        return render(request,'student_list.html',{
           'stu_list':stu_list})
    
    def add_student(request):
        if request.method == "GET":
            obj = StudentForm()
            return render(request,'add_student.html',{
           'obj':obj})
        else:
            obj = StudentForm(request.POST)
            if obj.is_valid():
                models.Student.objects.create(**obj.cleaned_data)
                return redirect('/student_list/')
            return render(request,'add_student.html',{
           'obj':obj})
    
    def edit_student(request,nid):
        if request.method == "GET":
            row = models.Student.objects.filter(id=nid).values('name','email','age','cls_id').first()
            obj = StudentForm(initial=row)
            return render(request,'edit_student.html',{
           'nid':nid,'obj': obj})
        else:
            obj = StudentForm(request.POST)
            if obj.is_valid():
                models.Student.objects.filter(id=nid).update(**obj.cleaned_data)
                return redirect('/student_list/')
            return render(request,'edit_student.html',{
           'nid':nid,'obj': obj})
    
    
    class TeacherForm(Form):
        tname = fields.CharField(min_length=2)
        xx = fields.MultipleChoiceField(
            # choices=models.Classes.objects.values_list("id","title"),
            widget=widgets.SelectMultiple
        )
        def __init__(self,*args,**kwargs):
            super(TeacherForm,self).__init__(*args,**kwargs)
            self.fields["xx"].choices =models.Classes.objects.values_list("id","title")
    
    
    
    
    def teacher_list(request):
        tea_list = models.Teacher.objects.all()
        # tea_class = tea_list.c2t.all()
        # print(tea_class)
        return render(request,"teacher_list.html",{
           "tea_list":tea_list})
    
    def add_teacher(request):
        if request.method == "GET":
            obj = TeacherForm()
            # # print(obj.xx)
            # print(obj.tname)
            return render(request,"add_teacher.html",{
           "obj":obj})
        else:
            obj = TeacherForm(request.POST)
            if obj.is_valid():
                print(obj.cleaned_data)
                xx = obj.cleaned_data.pop("xx")
                row = models.Teacher.objects.create(**obj.cleaned_data)
                row.c2t.add(*xx)
                return redirect("/teacher_list/")
            return render(request,"add_teacher.html",{
           "obj":obj})
    
    def edit_teacher(request,tid):
        if request.method == "GET":
            row = models.Teacher.objects.filter(id=tid).first()
            class_ids = row.c2t.values_list("id")
            print(class_ids)
            print(list(zip(*class_ids)))
            id_list = list(zip(*class_ids))[0] if list(zip(*class_ids)) else []
    
            obj = TeacherForm(initial={
           'tname':row.tname,'xx':id_list})
            return render(request,'edit_teacher.html',{
           'obj':obj,"tid":tid})
        else:
    
            obj = TeacherForm(request.POST)
            if obj.is_valid():
                print(obj.cleaned_data)
    
                xx = obj.cleaned_data.pop("xx")
                row = models.Teacher.objects.create(**obj.cleaned_data)
                row.c2t.add(*xx)
                return redirect("/teacher_list/")
            else:
                print("111")
                return render(request, 'edit_teacher.html', {
           'obj': obj, "tid": tid})

View.py

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <h1>班级列表</h1>
        <div>
            <a href="/add_class/">添加</a>
        </div>
        <ul>
            {
            % for row in cls_list %}
                <li>{
           { row.title }} <a href="/edit_class/{
            { row.id }}/">编辑</a>  </li>
            {
            % endfor %}
        </ul>
    </body>
    </html>

class\_list.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <h1>添加班级</h1>
        <form method="POST" action="/add_class/" novalidate>
            {
            % csrf_token %}
            {
            { obj.title }} {
            { obj.errors.title.0 }}
            <input type="submit" value="提交" />
        </form>
    </body>
    </html>

add\_class.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <h1>编辑班级</h1>
        <form method="POST" action="/edit_class/{
            { nid }}/">
            {
            % csrf_token %}
            <p>
                {
            { obj.title }} {
            { obj.errors.title.0 }}
            </p>
            <input type='submit' value="提交" />
        </form>
    </body>
    </html>

edit\_class.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <h1>学生列表</h1>
        <a href="/add_student/">添加</a>
        <ul>
            {
            % for row in stu_list %}
                <li>{
           { row.name }}-{
           { row.email }}-{
           { row.age }}-{
           { row.cls_id }}-{
           { row.cls.title }}   <a href="/edit_student/{
            { row.id }}/">编辑</a></li>
            {
            % endfor %}
        </ul>
    </body>
    </html>

student\_list.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <h1>添加学生</h1>
        <form action="/add_student/" method="POST">
            {
            % csrf_token %}
            <p>
                学生名称:{
            { obj.name }}
            </p>
            <p>
                学生邮箱:{
            { obj.email }}
            </p>
            <p>
                学生年龄:{
            { obj.age }}
            </p>
            <p>
                班级:{
            { obj.cls_id }}
            </p>
            <input type="submit" value="提交" />
        </form>
    </body>
    </html>

add\_student.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title></title>
        <link rel="stylesheet" href="/static/bootstrap-3.3.7-dist/css/bootstrap.css"/>
    </head>
    <body>
    
    
        <div style="width: 500px;margin: 0 auto;">
            <form class="form-horizontal" method="POST" action="/edit_student/{
            { nid }}/">
                {
            % csrf_token %}
                <div class="form-group">
                    <label class="col-sm-2 control-label">姓名：</label>
    
                    <div class="col-sm-10">
                        {
            { obj.name }}
                    </div>
                </div>
                <div class="form-group">
                    <label class="col-sm-2 control-label">邮箱：</label>
    
                    <div class="col-sm-10">
                        {
            { obj.email }}
                    </div>
                </div>
                 <div class="form-group">
                    <label class="col-sm-2 control-label">年龄：</label>
    
                    <div class="col-sm-10">
                        {
            { obj.age }}
                    </div>
                </div>
                 <div class="form-group">
                    <label class="col-sm-2 control-label">班级：</label>
    
                    <div class="col-sm-10">
                        {
            { obj.cls_id }}
                    </div>
                </div>
                <div class="form-group">
                    <div class="col-sm-offset-2 col-sm-10">
                        <input type="submit" class="btn btn-default" value="提交" />
                    </div>
                </div>
            </form>
        </div>
    </body>
    </html>

edit\_student.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
    </head>
    <body>
        <h1>老师列表</h1>
        <div>
            <a href="/add_teacher/">增加</a>
        </div>
    <table border="1">
        <thead>
            <tr>
                <th>ID</th>
                <th>老师名称</th>
                <th>任教老师</th>
                <th>操作</th>
            </tr>
        </thead>
        <tbody>
            {
            % for row in tea_list %}
                <tr>
                    <td>{
           { row.id }}</td>
                    <td>{
           { row.tname }}</td>
                    <td>
                        {
            % for row in row.c2t.all %}
                            {
            { row.title }}
                        {
            % endfor %}
    
                    </td>
                    <td>
                        <a href="/edit_teacher/{
            { row.id }}">编辑</a>
                    </td>
                </tr>
            {
            % endfor %}
        </tbody>
    </table>
    </body>
    </html>

teacher.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
    </head>
    <body>
    
        <form action="/add_teacher/" method="POST">
            {
            % csrf_token %}
            <p>
                姓名: {
            { obj.tname }}
            </p>
            <p>
                班级 {
            { obj.xx }}
            </p>
            <input type="submit" value="提交">
        </form>
    
    
    </body>
    </html>

add\_teacher.html

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
    </head>
    <body>
        <h3>编辑老师</h3>
    
        <form action="/edit_teacher/{
            { tid }}/" novalidate method="POST">
            {
            % csrf_token %}
            <p>
                {
            { obj.tname }}
            </p>
            <p>
                {
            { obj.xx }}
            </p>
            <input type="submit" value="提交">
        </form>
    </body>
    </html>

edit\_teacheer.html

转载于:https://www.cnblogs.com/guobaoyuan/p/7235150.html

[ContractedBlock.gif]: https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211211/483878e61318419d93e1bc32fbc53135.png