ORM之老师管理
url部分
#老师管理
url(r'^teacher_list/', views.teacher_list,name="teacher_list"),
url(r'^add_teacher/', views.add_teacher,name="add_teacher"),
url(r'^edit_teacher/(\d+)', views.edit_teacher,name="edit_teacher"),
url(r'^delete_teacher/(\d+)', views.delete_teacher,name="delete_teacher"),
modls部分
from django.db import models
# Create your models here.
"""
班级表
"""
class Class(models.Model):
id = models.AutoField(primary_key=True)
cname = models.CharField(max_length=32, null=True)
first_day = models.DateField()
def __str__(self):
return self.cname
"""
老师表
"""
class Teacher(models.Model):
id=models.AutoField(primary_key=True)
tname=models.CharField(max_length=32)
cid=models.ManyToManyField("Class",null=False)
views部分
from django.shortcuts import render, redirect, HttpResponse
from django.urls import reverse
from . import models
# Create your views here.
# 展示老师
def teacher_list(request):
teacher_list = models.Teacher.objects.all()
return render(request, "teacher_list.html", {"teacher_list": teacher_list})
# 添加老师
def add_teacher(request):
if request.method == "POST":
tname = request.POST.get("tname")
class_ids = request.POST.getlist("class_id")
new_teacher = models.Teacher.objects.create(tname=tname)
# 查询所有被选中的班级
class_objs = models.Class.objects.filter(id__in=class_ids)
# 四种添加方式
new_teacher.cid.set(class_objs)
# new_teacher.cid.add(*class_objs)
# new_teacher.cid.add(*class_ids)
# new_teacher.cidd.set(class_ids)
new_teacher.save()
return redirect(reverse("teacher_list"))
class_list = models.Class.objects.all()
return render(request, "add_teacher.html", {"class_list": class_list})
# 编辑老师
def edit_teacher(request, tid):
teacher_obj = models.Teacher.objects.get(id=tid)
class_list = models.Class.objects.all()
if request.method == "POST":
tname = request.POST.get("tname")
class_ids = request.POST.getlist("class_id")
teacher_obj.tname = tname
teacher_obj.cid.set(class_ids)
teacher_obj.save() # 一定记得更新完要保存
return redirect(reverse("teacher_list"))
return render(request, "edit_teacher.html", {"class_list": class_list, "teacher": teacher_obj})
#删除老师
def delete_teacher(request,tid):
models.Teacher.objects.filter(id=tid).delete()
return redirect(reverse("teacher_list"))
前端部分
#teacher_list部分
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Title</title>
</head>
<body>
<a href="{% url "add_teacher" %}">添加老师</a>
<table border="1">
<thead>
<tr>
<th>#</th>
<th>id</th>
<th>姓名</th>
<th>授课班级</th>
<th>操作</th>
</tr>
</thead>
<tbody>
{% for teacher in teacher_list %}
<tr>
<td>{{ forloop.counter }}</td>
<td>{{ teacher.id }}</td>
<td>{{ teacher.tname }}</td>
<td>
{% for class in teacher.cid.all %}
{% if forloop.last %}
{{ class.cname }}
{% else %}
{{ class.cname }}
{% endif %}
{% endfor %}
</td>
<td>
<a href="{% url "edit_teacher" teacher.id %}">编辑</a>
<a href="{% url "delete_teacher" teacher.id %}">删除</a>
</td>
</tr>
{% endfor %}
</tbody>
</table>
</body>
</html>
#add_teacher部分
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Title</title>
</head>
<body>
<form action="{% url "add_teacher" %}" method="post">
{% csrf_token %}
<p>老师姓名<input type="text" name="tname"></p>
<label for="class_id">授课班级</label>
<select name="class_id" id="class_id" multiple>授课班级
{% for class in class_list %}
<option value="{{ class.id }}">{{class.cname}}</option>
{% endfor %}
</select>
<p><input type="submit" value="提交"></p>
</form>
</body>
</html>
#edit_teacher部分
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Title</title>
</head>
<body>
<form action="{% url "edit_teacher" teacher.id %}" method="post">
{% csrf_token %}
<p>老师姓名<input type="text" name="tname" value="{{ teacher.tname }}"></p>
<label for="class_id">授课班级</label>
<select name="class_id" id="class_id" multiple>
{% for class in class_list %}
{% if class in teacher.cid.all %}
<option value="{{ class.id }}" selected>{{ class.cname }}</option>
{% else %}
<option value="{{ class.id }}" >{{ class.cname }}</option>
{% endif %}
{% endfor %}
</select>
<p><input type="submit" value="提交"></p>
</form>
</body>
</html>