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))
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%; 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>
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))
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%; 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>
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))
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>
<!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>
<!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>
###网页显示 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/')
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; 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%; 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>
#显示 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))