def addclass(request):
sqlhepr = SqlHeper()
if request.method == 'POST':
data = request.POST.get('addclass')
sqlhepr.insert_data("insert into classes (title) value(%s)", [data])
sqlhepr.commit_data()
sqlhepr.close_data()
return redirect('/classes/')
else:
context = {}
return render(request, 'addclass.html', context)
def modal_addclass(request):
sqlhepr = SqlHeper()
data = {}
if request.method == 'POST':
new_class = request.POST.get('modal_addclass')
if new_class.strip() == '':
data["status"] = 'error'
data['message'] = '输入错误，请重新输入'
return JsonResponse(data)
else:
sqlhepr.insert_data("insert into classes (title) value(%s)",
[new_class])
sqlhepr.commit_data()
sqlhepr.close_data()
data["status"] = 'ok'
return JsonResponse(data)
def addstudent(request):
sqlhepr = SqlHeper()
if request.method == 'POST':
student_name = request.POST.get('addstudent')
class_id = request.POST.get('class_name')
sqlhepr.insert_data(
"insert into students (name,class_id) value(%s,%s)",
[student_name, class_id])
sqlhepr.commit_data()
sqlhepr.close_data()
return redirect('/students/')
else:
class_list = sqlhepr.select_all_data("select * from classes", [])
context = {}
context['class_list'] = class_list
sqlhepr.close_data()
return render(request, 'addstudent.html', context)
def modal_addstudent(request):
sqlhepr = SqlHeper()
context = {}
try:
studentname = request.POST.get('studentname')
if studentname.strip() == '':
context['status'] = 'error'
context['message'] = '输入的学生姓名不能为空'
return JsonResponse(context)
class_id = request.POST.get('class_id')
sqlhepr.insert_data("insert into students(name,class_id) value(%s,%s)",
[
studentname,
class_id,
])
sqlhepr.commit_data()
sqlhepr.close_data()
context['status'] = 'success'
except Exception as e:
context['status'] = 'error'
context['message'] = str(e)
return JsonResponse(context)
