setting.py
INSTALLED_APPS = [ ... 'django.contrib.staticfiles', 'stuapp', ] DATABASES = { 'default': { # 'ENGINE': 'django.db.backends.sqlite3', # 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), 'ENGINE': 'django.db.backends.mysql', 'NAME': 'django20190909', 'USER': 'root', 'PASSWORD': '123456', 'HOST': '127.0.0.1', 'PORT': '3306', } }demo6/urls.py
from django.contrib import admin from django.urls import path, include urlpatterns = [ path('admin/', admin.site.urls), path('student/', include('stuapp.urls')), ]stuapp/urls.py
from django.urls import path from . import views urlpatterns = [ path('', views.register), path('showall/', views.showall), path('getstu/', views.getstu), ]stuapp/models.py
from django.db import models # Create your models here. class Clazz(models.Model): # 班级模型 cno = models.AutoField(primary_key=True) cname = models.CharField(max_length=30, unique=True) def __str__(self): return self.cname class Course(models.Model): # 课程模型 courseid = models.AutoField(primary_key=True) coursename = models.CharField(max_length=30) def __str__(self): return self.coursename class Student(models.Model): # 学生模型 sno = models.AutoField(primary_key=True) sname = models.CharField(max_length=30) cls = models.ForeignKey(Clazz, on_delete=models.CASCADE, related_name="student") course = models.ManyToManyField(Course) def __str__(self): return self.sname # 将数据保存到数据库中的方法 def registerOper(sname, cname, *coursename): try: # 1.班级表插入操作 try: cls = Clazz.objects.get(cname=cname) except Clazz.DoesNotExist: cls = Clazz.objects.create(cname=cname) # 2.课程表插入操作 courseList = [] for cn in coursename: couseObj = Course.objects.create(coursename=cn) courseList.append(couseObj) # 3.学生表插入操作 stu = Student.objects.create(sname=sname, cls=cls) # 4.中间表插入操作 stu.course.add(*courseList) return True except Exception: return Falsestuapp/views.py
from django.http import HttpResponse from django.shortcuts import render # Create your views here. from stuapp.models import registerOper, Clazz, Student def register(request): """ 1.注册页面的展示 2.处理注册功能 """ if request.method == "GET": return render(request, "register.html") elif request.method == "POST": # 1.获取请求参数 sname = request.POST.get('sname') clazz = request.POST.get('clazz') coursenames = request.POST.getlist('coursename') # 2.将数据入库 flage = registerOper(sname, clazz, *coursenames) # 3.处理页面响应 if flage: return HttpResponse("注册成功！") return HttpResponse('注册失败！') else: return HttpResponse("无法处理当前请求！") def showall(request): """获取所有的班级信息""" # 查询班级信息 claList = Clazz.objects.all() return render(request, "show.html", {"claList": claList}) def getstu(request): """获取当恰班级下的学生详情信息""" # 获取请求参数 cno = request.GET.get("cno", -1) # 根据班级编号查询学生信息 # Clazz.objects.get(cno=cno).student.all() # 还可以这样写 stuList = Student.objects.filter(cls_id=cno) context = {"stuList": stuList} return render(request, 'stuInfo.html', context)templates/register.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>register</title> </head> <body> <form action="/student/" method="post"> {% csrf_token %} <p>姓名：<input type="text" name="sname"></p> <p>班级： <select name="clazz"> <option value="B201_Python班">Python班</option> <option value="B202_Java班">Java班</option> <option value="B203_前端班">前端班</option> <option value="B204_大数据班">大数据班</option> </select> </p> <p>课程名称: <input type="checkbox" name="coursename" value="HTML5">HTML5 <input type="checkbox" name="coursename" value="Java">Java <input type="checkbox" name="coursename" value="Python">Python <input type="checkbox" name="coursename" value="Spark">Spark </p> <p>   <input type="submit" value="注册"></p> </form> </body> </html>templates/show.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <table border="1" cellspacing="0" width="500px"> <tr> <th>编号</th> <th>班级名称</th> <th>操作</th> </tr> {% for cls in claList %} <tr> <td>{{ forloop.counter }}</td> <td>{{ cls.cname }}</td> <td><a href="/student/getstu/?cno={{ cls.cno }}">详情</a></td> </tr> {% endfor %} </table> </body> </html>templates/stuInfo.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <table border="1" cellspacing="0" width="500px"> <tr> <th>编号</th> <th>姓名</th> <th>班级名称</th> <th>课程名称</th> </tr> {% for stu in stuList %} <tr> <td>{{ forloop.counter }}</td> <td>{{ stu.sname }}</td> <td>{{ stu.cls.cname }}</td> <td> {% for course in stu.course.all %} {#   都是空格的意思 #} {{ course.coursename }}  {% endfor %} </td> </tr> {% endfor %} </table> </body> </html>
