首页 > 代码库 > Django 学生管理系统

Django 学生管理系统

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

技术分享
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))
classes.html

 

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

技术分享
<!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;
        }
        .Modal{
            position: fixed;
            top: 50%;
            left: 50%;
            width: 400px;
            height: 300px;
            margin-left: -200px;
            margin-top: -150px;
            z-index: 1000;
            background-color: white;
        }
    </style>
</head>
<body>

<h1>班级学员</h1>

<div>
    <a id="addStudent">模态框增加</a>
</div>

<table border="1px">
    <thead>
        <tr>
            <td>学员名称</td>
            <td>学生名称</td>
            <td>班级名称</td>
            <td>模态操作</td>
        </tr>
    </thead>
    <tbody>
        {% for row in student_list %}
            <tr>
                <td>{{ row.sid }}</td>
                <td>{{ row.name }}</td>
                <td clsId="{{ row.class_id }}">{{ row.title }}</td>
                <td>
                    <a class="btn-edit">编辑</a>
                    <a >删除</a>
                </td>
            </tr>
        {% endfor %}
    </tbody>
</table>

<div id="shadow" class="shadow hide"></div>


{#增加#}
<div id="addModal" class="Modal hide">


    <p>学生名称:
        <input id="add_name" type="text" name="add_name">
    </p>
    <p>学生性别:
        <input id="add_sex" type="text" name="add_sex">
    </p>
    <p>班级名称:
        <select id="add_classId" name="add_classId">
            {% for row in class_list %}
                <option value=http://www.mamicode.com/"{{ row.cid }}">{{ row.title }}</option>
            {% endfor %}
        </select>
    </p>

    <input id="btnAdd" type="button" value=http://www.mamicode.com/"提交"><span id="addError"></span>
    <input id="btnCancle" type="button" value=http://www.mamicode.com/"取消">

</div>

{#编辑#}
<div id="editModal" class="Modal hide">
    <h3>编辑学生信息</h3>
    <p>
        姓名:<input id="editName" type="text" name="name" placeholder="姓名" />
        <input type="text" id="editId" style="display: none" />
    </p>
    <p>
        班级:
        <select id="editClassId" name="classId">
            {% for row in class_list %}
                <option value=http://www.mamicode.com/"{{ row.cid }}">{{ row.title }}</option>
            {% endfor %}
        </select>
    </p>
    <input id="btnEdit" type="button" value=http://www.mamicode.com/"更新" />
    <span id="editError" style="color: red;"></span>
    <input id="btnCancle" type="button" value=http://www.mamicode.com/"取消" />
</div>

<script src=http://www.mamicode.com/"/static/jquery-3.2.1.js"></script>

<script>

    $(function () {

        {#            增加#}

        $("#addStudent").click(function () {
            $("#shadow,#addModal").removeClass("hide");
        });

        $("#btnCancle").click(function () {
            $("#shadow,#addModal").addClass("hide");
            $("#editModal").addClass("hide");
        });

        $("#btnAdd").click(function () {
            var add_name=$("#add_name").val();
            var add_age=$("#add_sex").val();
            var add_classId=$("#add_classId").val();
            $.ajax({
                url:"/motai_add_student/",
                type:"POST",
                data:{"add_name":add_name,"add_age":add_age,"add_classId":add_classId},
                success:function (arg) {
                    arg = JSON.parse(arg);
                    if (arg.status){
                        location.reload();
                    }else {
                        $("#addError").text(arg.message);
                    }
                }
            })

        });


        {#        编辑 #}
        $(.btn-edit).click(function(){
            $(#shadow,#editModal).removeClass(hide);

            var tds = $(this).parent().prevAll();
            var studentId = $(tds[2]).text();
            var studentName = $(tds[1]).text();
            var classId = $(tds[0]).attr(clsid);

            console.log(studentId,studentName,classId);

            $(#editId).val(studentId);
            $(#editName).val(studentName);
            $(#editClassId).val(classId);
        });

        $(#btnEdit).click(function(){
            $.ajax({
                url:/motai_edit_student/,
                type: POST,
                data: {sid: $(#editId).val(), name:$(#editName).val(),class_id: $(#editClassId).val()},
                dataType: JSON, //JSON.parse(arg)
                success:function(arg){
                    if(arg.status){
                        location.reload();
                    }else{
                        $(#editError).text(arg.message);
                    }
                }
            })
        });
    })

</script>

</body>
</html>
student.html
技术分享
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

 

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

技术分享
<!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;
        }
        .Modal{
            position: fixed;
            top: 50%;
            left: 50%;
            width: 400px;
            height: 300px;
            margin-left: -200px;
            margin-top: -150px;
            z-index: 1000;
            background-color: white;
        }
    </style>
</head>
<body>

<h1>老师 班级管理</h1>

<div>
    
    <a id="addModal">模态框增加</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 class="editModal">编辑</a>
                    <a class="delModal">删除</a>
                </td>
            </tr>
        {% endfor %}
    </tbody>

</table>

<div id="shadow" class="shadow 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>
            {% for row in class_list %}
                <option value=http://www.mamicode.com/"{{ row.cid }}">{{ row.title }}</option>
            {% endfor %}
        </select>
    </p>
    <input id="btnAdd" type="button" value=http://www.mamicode.com/"提交"><span id="addError"></span>
    <input id="btnCancle" type="button" value=http://www.mamicode.com/"取消">

</div>

<div id="edit_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>
            {% for row in class_list %}
                <option value=http://www.mamicode.com/"{{ row.cid }}">{{ row.title }}</option>
            {% endfor %}
        </select>
    </p>
    <input id="btnEdit" type="button" value=http://www.mamicode.com/"提交"><span id="addError"></span>
    <input id="cacleEdit" type="button" value=http://www.mamicode.com/"取消">

</div>


<script src=http://www.mamicode.com/"/static/jquery-3.2.1.js"></script>

<script>

    $(function () {


        {#        增加#}
        $("#addModal").click(function () {
            $("#shadow,#add_tea_cls").removeClass("hide");
        });

        $("#btnCancle").click(function () {
            $("#shadow,#add_tea_cls").addClass("hide");
        });


        $("#btnAdd").click(function () {
            tname=$("#add_name").val();
            class_list=$("#add_classId").val();
            console.log(class_list)
            $.ajax({
                url:"/new_teacher/",
                type:"POST",
                data:{"tname":tname,"class_list":class_list},
                success:function (arg) {
                    arg = JSON.parse(arg);
                    if (arg.status){
                        location.reload();
                    }else {
                        $("#addError").text(arg.message);
                    }
                }
            })
        });



        {#        编辑#}
        $(".editModal").click(function () {
            $("#shadow").removeClass("hide");
            $("#edit_tea_cls").removeClass("hide");
        });

        $("#cacleEdit").click(function () {
            $("#shadow,#edit_tea_cls").addClass("hide");
        });


    })



</script>



</body>
</html>
teacher.html
技术分享
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

 

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

技术分享
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>

</head>
<body>

<h1>老师 班级管理</h1>

<div>

    <a href=http://www.mamicode.com/"/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=http://www.mamicode.com/"/edit_page_teacher/?tid={{ row.tid }}">编辑</a>
                    <a >删除</a>
                </td>
            </tr>
        {% endfor %}
    </tbody>

</table>


</body>
</html>
teacher.html
技术分享
<!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
技术分享
<!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=http://www.mamicode.com/"{{ 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=http://www.mamicode.com/"{{ item.cid }}">{{ item.title }}</option>
            {% else %}
                <option value=http://www.mamicode.com/"{{ item.cid }}">{{ item.title }}</option>
            {% endif %}
        {% endfor %}
    </select>

    <p><input type="submit" value=http://www.mamicode.com/"提交"></p>
    </p>

</form>


</body>
</html>
edit_teacher
技术分享
###网页显示
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

 

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

技术分享
<!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=http://www.mamicode.com/"/static/plugins/bootstrap-3.3.7-dist/css/bootstrap.css">
    <link rel="stylesheet" href=http://www.mamicode.com/"/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=http://www.mamicode.com/"提交"><span id="addError"></span>
    <input id="btnCancle" type="button" value=http://www.mamicode.com/"取消">

</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=http://www.mamicode.com/"提交"><span id="addError"></span>
    <input id="cacleEdit" type="button" value=http://www.mamicode.com/"取消">

</div>


<script src=http://www.mamicode.com/"/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
技术分享
#显示
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

 

Django 学生管理系统