python Django学生管理

Django 学生管理系统

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

<!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 onclick="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 onclick="modelEdit(this)">编辑</a>
                        <a onclick="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="提交" onclick="AjaxSend();"  /><span id="errormsg"></span>
        <input type="button" value="取消" onclick="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="提交" onclick="editAjaxSend()"><span id="errormsg"></span>
        <input type="button" value="取消" onclick="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

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.一对多学生班级模态增加编辑

<!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="{{ row.cid }}">{{ row.title }}</option>
            {% endfor %}
        </select>
    </p>

    <input id="btnAdd" type="button" value="提交"><span id="addError"></span>
    <input id="btnCancle" type="button" value="取消">

</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="{{ row.cid }}">{{ row.title }}</option>
            {% endfor %}
        </select>
    </p>
    <input id="btnEdit" type="button" value="更新" />
    <span id="editError" style="color: red;"></span>
    <input id="btnCancle" type="button" value="取消" />
</div>

<script src="/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.py

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="{{ row.cid }}">{{ row.title }}</option>
            {% endfor %}
        </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">

    <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="{{ row.cid }}">{{ row.title }}</option>
            {% endfor %}
        </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,#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.py

views.py

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

<!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

<!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

<!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

###网页显示
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.多对多老师班级模态增加编辑

<!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

#显示
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 学生信息

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

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

<!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

<!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

<!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

<!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

<!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

<!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

<!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

<!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

<!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

posted on 2017-09-12 01:41 bigdata_devops 阅读(296) 评论(0) 编辑收藏举报

刷新页面返回顶部

bigdata_devops

python Django学生管理

Django 学生管理系统

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

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

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

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

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

二、Form 学生信息

导航

公告

bigdata_devops

python Django学生管理

Django 学生管理系统

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

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

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

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

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

二、Form 学生信息

导航

公告

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

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

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

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

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