def student(request): #登录功能用装饰器实现一下 obj = SqlHeper() sql = 'select student.id,student.name,student.class_id,classes.title from student left join classes on student.class_id=classes.id' student_list = obj.get_list(sql) class_list = obj.get_list('select id,title from classes') return render(request, "student.html", { 'student_list': student_list, 'class_list': class_list })
def classes(request): #从cookies中获取凭证 #tk=request.COOKIES.get('ticket') tk = request.get_signed_cookie('ticket', salt='9999') if not tk: return redirect('/login/') obj = SqlHeper() class_list = obj.get_list("select id,title from classes") return render(request, 'classes.html', {'class_list': class_list})
def add_student(request): obj = SqlHeper() if request.method == 'GET': class_list = obj.get_list("select id,title from classes") return render(request, 'add_student.html', {'class_list': class_list}) else: name = request.POST.get('name') title = request.POST.get('class_id') obj.modify("insert into student(name,class_id) value(%s,%s)", [name, title]) return redirect('/student/')
def edit_student(request): obj = SqlHeper() if request.method == 'GET': nid = request.GET.get('nid') sql = 'select id,title from classes' class_list = obj.get_list(sql) sql = 'select id,name,class_id from student where id=%s' result = obj.get_list(sql, [ nid, ], all=False) return render(request, "edit_student.html", { 'class_list': class_list, 'student_info': result }) else: nid = request.GET.get('nid') name = request.POST.get('name') class_id = request.POST.get('class_id') sql = 'update student set name=%s,class_Id=%s where id=%s' obj.modify(sql, [name, class_id, nid]) return redirect('/student/')
def get_all_class(request): obj = SqlHeper() class_list = obj.get_list('select id,title from classes') obj.close() import json return HttpResponse(json.dumps(class_list))