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)