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