def deleteTearcher(request): tid = request.GET.get('tid') obj = SQLHelper() obj.modify('delete from tearcher where tid = %s', tid) obj.modify('delete from tearch2class where tid = %s', tid) obj.close() return redirect('/tearchers/')
def edit_student(request): if request.method == "GET": id = request.GET.get("id") obj = SQLHelper() class_list = obj.get_list("select id,name from class", []) student = obj.get_one( "select student.id,student.sname,student.cid,class.name from student left join class on student.cid = class.id where student.id = %s", id) obj.close() return render(request, "edit_student.html", { "student": student, "class_list": class_list }) else: id = request.POST.get("id") sname = request.POST.get("sname") cid = request.POST.get("class_id") obj = SQLHelper() obj.modify("update student set sname = %s,cid = %s where id = %s", [ sname, cid, id, ]) obj.close() return redirect("/students/")
def delete_class(request): id = request.GET.get('id') # ###删除班级老师对应表 # cursor.execute('delete from tearch2class where cid = %s', id) obj = SQLHelper() obj.modify("delete from class where id=%s", id) obj.close() return redirect('/class/')
def deleteStudent(request): id = request.GET.get("id") obj = SQLHelper() obj.modify("delete from student where id = %s", id) obj.close() return redirect("/students/")
def add_class(request): if request.method == 'GET': return render(request, 'addclass.html') else: v = request.POST.get('name') if len(v) > 0: obj = SQLHelper() obj.modify("insert into class(name) values(%s)", [ v, ]) obj.close() return redirect('/class/') else: return render(request, 'addclass.html', {"msg": "班级名称不能为空"})
def addStudent(request): if request.method == "GET": obj = SQLHelper() classes = obj.get_list("select id,name from class") obj.close() return render(request, "addStudent.html", {'classes': classes}) else: class_id = request.POST.get("class_id") sname = request.POST.get("sname") obj = SQLHelper() obj.modify("insert into student( sname, cid) value (%s,%s)", [sname, class_id]) obj.close() return redirect("/students/")
def edit_class(request): if request.method == "GET": id = request.GET.get("id") obj = SQLHelper() result = obj.get_one("select id,name from class where id = %s", id) obj.close() return render(request, 'edit_class.html', {"result": result}) else: id = request.GET.get("id") # id = request.POST.get("id") name = request.POST.get("name") obj = SQLHelper() obj.modify("update class set name = %s where id = %s", [ name, id, ]) obj.close() return redirect("/class/")
def editTearcher(request): if request.method == 'GET': tid = request.GET.get('tid') obj = SQLHelper() tearcher_info = obj.get_one( 'select tid,tname from tearcher where tid = %s', [tid]) tearcher_class_list = obj.get_list( 'select cid from tearch2class where tearch2class.tid = %s', [ tid, ]) class_list = obj.get_list('select id,name from class') obj.close() temp = [] for i in tearcher_class_list: temp.append(i['cid']) return render( request, 'edit_tearcher.html', { 'info': tearcher_info, 'tearcher_class_list': temp, 'class_list': class_list }) else: tid = request.GET.get('tid') class_ids = request.POST.getlist('class_ids') tname = request.POST.get('tname') #更新老师表 obj = SQLHelper() obj.modify('update tearcher set tname=%s where tid = %s', [tname, tid]) #更细老师班级关系表 # 方案一:先删除老师和班级的对应关系删除,之后再做添加 obj.modify('delete from tearch2class where tid = %s', [tid]) sql_args = [] for cid in class_ids: temp = (tid, cid) sql_args.append(temp) obj.multiple_modify( 'insert into tearch2class(tid, cid) values (%s,%s)', sql_args) obj.close() # 方案二:把新的班级数据和老的数据做对比进行删除和增加 return redirect('/tearchers/')