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