def add_class(request): ''' 页面不刷新,提示错误信息 若用form表单提交,这个功能无法完成 form表单提交,页面必刷新 若想完成此功能并且是对话框的方式就不能用form表单提交 若用ajex提交,提交后无法用renturn 进行跳转,只能通过写js进行跳转 在js中使用location.href完成跳转 ''' class_name = request.POST.get('title') if len(class_name) > 0: class_num = sqlhelper.get_list( 'SELECT id FROM class ORDER BY id DESC LIMIT 1;') if class_num == []: class_id = 1 else: class_id = class_num[0][0] + 1 sqlhelper.modify('INSERT IGNORE INTO class (id,title) VALUES (%s,%s);', [ class_id, class_name, ]) return HttpResponse('ok') else: return HttpResponse('班级不能为空')
def add_student(request): ret = { 'status': True, 'message': None, } name = request.POST.get("name") class_name = request.POST.get("class") if name == '': ret['status'] = False ret['message'] = 'None type' return HttpResponse(json.dumps(ret)) stu_num = sqlhelper.get_list( 'SELECT id FROM student ORDER BY id DESC LIMIT 1;') if stu_num == []: stu_num = 1 else: stu_num = stu_num[0][0] + 1 try: class_id = sqlhelper.get_list( 'SELECT id FROM class WHERE title=%s LIMIT 1;', [class_name])[0][0] sqlhelper.modify( 'INSERT INTO student (id,name,class_id) VALUES (%s,%s,%s);', [ stu_num, name, class_id, ]) except Exception as e: ret['status'] = False ret['message'] = str(e) return HttpResponse(json.dumps(ret))
def editStudent(request): if request.method == "GET": nid = request.GET.get('nid') result = sqlhelper.get_one( 'select id,stu_name,class_id from student where id=%s', [ nid, ]) class_list = sqlhelper.get_list("select id,title from class", []) return render(request, 'editStudent.html', { 'result': result, 'class_list': class_list }) else: nid = request.GET.get('nid') id = request.POST.get('id') name = request.POST.get('stu_name') class_id = request.POST.get('class_id') sqlhelper.modify( "update student set id=%s, stu_name=%s, class_id=%s where id = %s", [ id, name, class_id, nid, ]) return redirect('/students/')
def del_teacher(request): teacher_id = request.GET.get('nid') sqlhelper.modify('DELETE FROM link_t_C WHERE teacher_id=%s;', [ teacher_id, ]) sqlhelper.modify('DELETE FROM teacher WHERE id=%s;', [ teacher_id, ]) return redirect('/teacher/')
def modal_add_stu(request): s_name = request.POST.get('s_name') c_id = request.POST.get('c_id') if len(s_name) > 0: sqlhelper.modify("insert into students(name,cid) values(%s,%s)", [s_name, c_id]) return HttpResponse('OK') else: return HttpResponse('姓名不能为空')
def modal_add_class(request): title = request.POST.get('title') if len(title) > 0: sqlhelper.modify('insert into class(title) values(%s) ', [ title, ]) return HttpResponse('ok') else: return HttpResponse('班级名称不能为空')
def del_teacher(request): t_id = request.GET.get('t_id') sqlhelper.modify("delete from teachers where id=%s", [ t_id, ]) sqlhelper.modify("delete from relations where t_id=%s", [ t_id, ]) return redirect('stu:teachers')
def modal_add_class(request): title = request.POST.get('title') if len(title) > 0: sqlhelper.modify('insert into class(cname) values(%s)', [ title, ]) return HttpResponse('ok') else: return HttpResponse('empty class name is unaccepted')
def modal_add_class(request): title = request.POST.get('title') print(" >>> "+title) if len(title) > 0: sqlhelper.modify("insert into class(title) values(%s)", [title, ]) return HttpResponse('ok') #return redirect('/classes/') else: return HttpResponse('班级标题不能为空')
def del_class(request): c_id = request.GET.get('pk') try: sqlhelper.modify("delete from class where id=%s", [ c_id, ]) return redirect('stu:classes') except Exception as e: return HttpResponse('班级有学生不能删除')
def modal_add_class(request): title = request.POST.get('title') if len(title) > 0: sqlhelper.modify('insert into class(title) values(%s)', [ title, ]) return HttpResponse('OK') else: # 页面不刷新,提示错误信息。 return HttpResponse('标题不能为空')
def modal_edit_class(request): ret = {'status': True, 'message': None} try: nid = request.POST.get('nid') content = request.POST.get('content') sqlhelper.modify('update class set title=%s where id=%s', [content, nid]) except Exception as e: ret['status'] = False ret['message'] = "处理异常" return HttpResponse(json.dumps(ret))
def modal_add_class(request): title = request.POST.get('title') if len(title) > 0: sqlhelper.modify('insert into class(title) values (%s)', [ title, ]) # return redirect('/classes/') return HttpResponse('ok') # 刷新的原因是form表单的提交特性。 else: return HttpResponse('班级标题不能为空')
def edit_student(request): if request.method == "GET": nid = request.GET.get('nid') class_list = sqlhelper.get_List("select id,title from class",[]) current_student_info = sqlhelper.get_one("select id,name,class_id from student where id=%s",[nid,]) return render(request,'edit_student.html',{'class_list':class_list,'current_student_info':current_student_info}) else: nid = request.GET.get('nid') name = request.POST.get('name') class_id = request.POST.get('class_id') sqlhelper.modify("update student set name=%s,class_id=%s where id=%s",[name,class_id,nid]) return redirect('/students/')
def modal_add_student(request): ret = {'status': True, 'message': None} try: name = request.POST.get('name') class_id = request.POST.get('class_id') sqlhelper.modify('insert into student(name,class_id) values(%s,%s)', [ name, class_id, ]) except Exception as e: ret['status'] = False ret['message'] = str(e) return HttpResponse(json.dumps(ret))
def modal_edit_student(request): res = {'state': True, 'message': None} try: stu_id = request.POST.get('stu_id') stu_name = request.POST.get('stu_name') stu_class_id = request.POST.get('class_id') sqlhelper.modify( 'update stu_info set stu_name=%s,stu_class_id=%s where stu_id=%s', [stu_name, stu_class_id, stu_id]) except Exception as e: res['state'] = False res['message'] = str(e) return HttpResponse(json.dumps(res))
def modal_edit_class(request): res = {'state': True, 'message': None} try: class_name = request.POST.get('editClassName') class_id = request.POST.get('editClassId') sqlhelper.modify( "update class_info set class_name=%s where class_id=%s", [ class_name, class_id, ]) except Exception as e: res['state'] = False res['message'] = '处理异常' return HttpResponse(json.dumps(res))
def edit_class(request): if request.method == "GET": class_id = request.GET.get("nid") class_title = sqlhelper.get_list( 'SELECT title FROM class WHERE id =%s LIMIT 1;', [class_id]) return render(request, 'edit_class.html', {'result': [class_id, class_title[0][0]]}) if request.method == "POST": class_id = request.GET.get("nid") class_title = request.POST.get("class_title") if class_title == '': return redirect('/del_class/?nid=' + class_id) sqlhelper.modify("UPDATE class SET title=%s WHERE id=%s;", [class_title, class_id]) return redirect('/class/')
def edit_student(request): ret = { 'status': True, 'message': None, } if request.method == "POST": stu_id = request.POST.get("stu_id") new_name = request.POST.get("new_name") new_class = request.POST.get("new_class") if new_name == "": ret['status'] = False ret['message'] = 'new name is empty' return HttpResponse(json.dumps(ret)) class_id = sqlhelper.get_list( 'SELECT id FROM class WHERE title=%s LIMIT 1;', [new_class])[0][0] if sqlhelper.modify( 'UPDATE student SET name=%s ,class_id=%s WHERE id=%s;', [ new_name, class_id, stu_id, ]): return HttpResponse(json.dumps(ret)) ret['status'] = False ret['message'] = 'sql error' return HttpResponse(json.dumps(ret))
def modal_edit_student(request): ret = {'status': True, 'message': None} try: nid = request.POST.get('nid') stuname = request.POST.get('stu_name') classid = request.POST.get('class_id') sqlhelper.modify('update student set sname=%s,classid=%s where sid=%s', [ stuname, classid, nid, ]) except Exception as e: ret['status'] = False ret['message'] = str(e) return HttpResponse(json.dumps(ret))
def edit_student(request): if request.method == 'GET': class_list = sqlhelper.get_list('SELECT * FROM class;') student_id = request.GET.get("nid") student = sqlhelper.get_list( 'SELECT * FROM student WHERE id=%s LIMIT 1;', [ student_id, ])[0] class_name = sqlhelper.get_list( 'SELECT * FROM class WHERE id=%s LIMIT 1;', [ student[2], ])[0][1] return render( request, "edit_student.html", { 'student': student, 'class_name': class_name, 'class_list': class_list, 'class_name': class_name, }) if request.method == 'POST': student_id = request.GET.get("nid") student_name = request.POST.get("student_name") class_id = request.POST.get("class_id") if sqlhelper.modify( 'UPDATE student SET name=%s,class_id=%s WHERE id =%s;', [ student_name, class_id, student_id, ]): return redirect('/student/') else: return redirect('/edit_student/?nid=' + student_id)
def del_student_modal(request): """ 模态框删除学生信息 :param request: :return: """ ret = {'status': True, 'msg': None} try: student_id = request.GET.get('student_id') sqlhelper.modify('delete from student where id=%s', [ student_id, ]) except Exception as e: ret['status'] = False ret['msg'] = str(e) return HttpResponse(json.dumps(ret))
def del_class(request): class_id = request.POST.get("class_id") if sqlhelper.modify('DELETE FROM class WHERE id =%s;', [ class_id, ]): return HttpResponse('200') else: return HttpResponse('404')
def del_class(request): class_id = request.GET.get("nid") if sqlhelper.modify("DELETE FROM class WHERE id =%s;", [ class_id, ]): return redirect('/class/') else: return redirect('/class/')
def edit_student_modal(request): """ 模态框编辑学生信息 :param request: :return: """ ret = {'status': True, 'msg': None} try: student_id = request.POST.get('student_id') class_id = request.POST.get('class_id_edit') student_name = request.POST.get('student_name') sqlhelper.modify('update student set name=%s,class_id=%s where id=%s', [student_name, class_id, student_id]) except Exception as e: ret['status'] = False ret['msg'] = str(e) return HttpResponse(json.dumps(ret))
def add_class(request): if request.method == "GET": return render(request, 'add_class.html') else: class_name = request.POST.get('title') class_num = sqlhelper.get_list( 'SELECT id FROM class ORDER BY id DESC LIMIT 1;') if class_num == []: class_id = 1 else: class_id = class_num[0][0] + 1 sqlhelper.modify('INSERT IGNORE INTO class (id,title) VALUES (%s,%s);', [ class_id, class_name, ]) return redirect('/class/')
def modal_edit_stu(request): ret = {'status': True, 'message': None} edit_s_id = request.POST.get('edit_s_id') edit_s_name = request.POST.get('edit_s_name') edit_c_id = request.POST.get('edit_c_id') if len(edit_s_name) > 0: try: sqlhelper.modify("update students set name=%s, cid=%s where id=%s", [edit_s_name, edit_c_id, edit_s_id]) return HttpResponse(json.dumps(ret)) except Exception as e: ret['status'] = False ret['message'] = '处理异常' return HttpResponse(json.dumps(ret)) else: ret['status'] = False ret['message'] = '姓名不能为空' return HttpResponse(json.dumps(ret))
def edit_student(request): if request.method == "GET": nid = request.GET.get('nid') class_list = sqlhelper.get_list('select cid,cname from class', []) curr_stu = sqlhelper.get_one( 'select sid,sname,classid from student where sid=%s', [ nid, ]) return render(request, 'edit_student.html', { 'class_list': class_list, 'curr_stu': curr_stu }) else: nid = request.GET.get('nid') stuname = request.POST.get('sname') class_id = request.POST.get('class_id') sqlhelper.modify("update student set sname=%s,classid=%s where sid=%s", [stuname, class_id, nid]) return redirect('/students/')
def edit_class(request): if request.method == "GET": class_id = request.GET.get("nid") class_name = sqlhelper.get_list( 'SELECT title FROM class WHERE id =%s LIMIT 1;', [ class_id, ])[0][0] return HttpResponse(class_name) if request.method == "POST": print(request.POST) class_id = request.POST.get('class_id') new_classname = request.POST.get("new_c_name") if new_classname == '': return HttpResponse('ERROR') sqlhelper.modify('UPDATE class SET title=%s WHERE id=%s;', [ new_classname, class_id, ]) return HttpResponse('200')
def edit_students(request): if request.method == 'GET': pk = request.GET.get('pk') class_list = sqlhelper.get_list("select id,title from class", []) current_stuinfo = sqlhelper.get_one( "select id,name,cid from students where id=%s", [ pk, ]) return render(request, 'edit_students.html', { 'class_list': class_list, 'current_stuinfo': current_stuinfo }) else: pk = request.GET.get('pk') edit_name = request.POST.get('edit_name') c_id = request.POST.get('c_id') sqlhelper.modify("update students set name=%s,cid=%s where id=%s", [edit_name, c_id, pk]) return redirect('stu:students')