增删改查

def index(request):

user = request.session.get('user')   # 获取老师的登录用户名
if user:
    teacher = Teacher.objects.all()
else:
    return redirect('/login/')

return render(request,'index.html',locals())

def add_stu(request):

if request.method == 'POST':
    user = request.session.get('user')
    if user:
        name = request.POST.get('name')
        age = request.POST.get('age')
        teacher = Teacher.objects.filter(name=user).first()   # 查询登录的老师的信息
        if not all([name,age]):
            error = '输入框不能为空！'
            return render(request,'add_stu.html',locals())
        else:
            Student.objects.create(name=name,age=age,teacher=teacher)   # 将学生信息添加进数据库
            return redirect('/')
    else:
        return redirect('/login/')
return render(request,'add_stu.html')

def add_teacher(request):

user = request.session.get('user')
if user:
    id = request.GET.get('id')
    if id:
        teacher = Teacher.objects.filter(name=user).first()
        Student.objects.filter(pk=id).update(teacher=teacher)   # 将学生关联老师的外键字段设为当前的老师
        return redirect('/')
else:
    return redirect('/login/')

def show_stu(request):

user = request.session.get('user')
if user:
    teacher = Teacher.objects.filter(name=user).first()
    student = Student.objects.filter(teacher=teacher).all()   # 查询当前登录的老师下的所有学生
else:
        return redirect('/login/')

return render(request,'show_stu.html',locals())

def show_no_stu(request):

user = request.session.get('user')
if user:
    teacher = Teacher.objects.all()
    student = Student.objects.exclude(teacher__in=teacher).all()   # 查询所有没有关联到老师表的学生信息
else:
        return redirect('/login/')

return render(request,'show_no_stu.html',locals())

def delete_stu(request):

user = request.session.get('user')
if user:
    id = request.GET.get('id')
    if id:
        Student.objects.filter(pk=id).update(teacher='')   # 删除与老师的关联外键
        return redirect('/show_stu/')
return render(request,'show_stu.html',locals())