1.在pycharm中新建project demo1 添加app01 点击create按钮完成新建
2.在demo项目目录下新建目录static,并在settings.py中追加代码:
STATICFILES_DIRS=(os.path.join(BASE_DIR, 'static'),)
3.在setting.py中添加模板路径:
TEMPLATES = [ { 'BACKEND': '...', 'DIRS': [os.path.join(BASE_DIR, 'templates'),], 'APP_DIRS': ..., 'OPTIONS': { 'context_processors': [ ... ], }, }, ]
4.学员管理系统数据库设计:
在app01/model.py目录下建立 班级、老师、学生 、老师与班级关联表 四张表:
from django.db import models # Create your models here. class Classes(models.Model): ''' 班级表 ''' title=models.CharField(max_length=32) a=models.ManyToManyField('Teachers') class Teachers(models.Model): ''' 老师表 ''' name=models.CharField(max_length=32) class Students(models.Model): username=models.CharField(max_length=32) age=models.IntegerField() gender=models.BooleanField() cs=models.ForeignKey(Classes,on_delete=models.CASCADE)
在终端Terminal 项目目录下执行数据表更新命令:
python manage.py makemigrations python manage.py migrate
至此生成了四张数据表,可以在pycharm中,点开右上角的Database面板,然后将项目中templates目录下边的db.sqlite3鼠标拖拽到Database面板下,对新创建的数据表进行查看。
5.学员管理系统之班级管理:
为了方便分别操作班级、老师、学生相关的业务,将app01目录下的views.py 删掉,在app01目录下新建目录views,并在views目录下 新建classes.py teachers.py students.py。
1.在classes.py 中写 get_classes add_classes del_classes edit_classes四个函数,完成对 班级数据 的增删改查:
from django.shortcuts import render,redirect from app01 import models def get_classes(request): cls_list = models.Classes.objects.all() return render(request,'get_classes.html',{'cls_list':cls_list}) def add_classes(request): if request.method=='GET': return render(request,'add_classes.html') elif request.method=='POST': title=request.POST.get('title','') models.Classes.objects.create(title=title) return redirect('/classes.html') def del_classes(request): nid=request.GET.get('nid','') models.Classes.objects.filter(id=nid).delete() return redirect('/classes.html') def edit_classes(request): if request.method=="GET": nid = request.GET.get('nid', '') obj=models.Classes.objects.get(id=nid) return render(request,'edit_classes.html',{'obj':obj}) elif request.method=="POST": nid=request.POST.get('nid','') title=request.POST.get('xxoo','') models.Classes.objects.filter(id=nid).update(title=title) return redirect('/classes.html')
2.在urls.py 中配置url路由:
from django.contrib import admin from django.urls import path from app01.views import classes,students,teachers urlpatterns = [ path('admin/', admin.site.urls), path('classes.html', classes.get_classes), path('add_classes.html', classes.add_classes), path('del_classes.html', classes.del_classes), path('edit_classes.html', classes.edit_classes), # path('teachers.html', teachers.get_teachers), # path('students.html', students.get_studernts), ]
3.在template目录下建立所需的html页面文件:
get_classes.html
DOCTYPE html> <html lang="en"> <head> <style> tr td{ border:1px solid #000;text-align:center;} </style> <meta charset="UTF-8"> <title>Title</title> </head> <body> <div> <table> <thead> <tr> <th>ID</th> <th>名称</th> <th>操作</th> </tr> </thead> <tbody> {% for row in cls_list %} <tr> <td>{{ row.id }}</td> <td>{{ row.title }}</td> <td><a href="/del_classes.html" rel="external nofollow" rel="external nofollow" >删除</a> |<a href="/edit_classes.html" rel="external nofollow" rel="external nofollow" >编辑</a> </td> </tr> {% endfor %} </tbody> </table> </div> <div><a href="/add_classes.html" rel="external nofollow" rel="external nofollow" >添加</a> </div> </body> </html>
add_classes.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <form action="/add_classes.html" method="post"> {% csrf_token %} <input type="text" name="title"> <input type="submit" value="提交"> </form> </body> </html>
edit_classes.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <form method="post" action="/edit_classes.html"> {% csrf_token %} <input type="hidden" name="nid" value="{{ obj.id }}"> <input type="text" name="xxoo" value="{{ obj.title }}"> <input type="submit" value="提交"> </form> </body> </html>
6.学员管理系统之学员管理: 1.在students.py 中写 get_students add_students del_students edit_students 四个函数,完成对 学生数据 的增删改查:
from django.shortcuts import render,redirect from app01 import models def get_students(request): stu_list=models.Students.objects.all() return render(request,'get_students.html',{'stu_list':stu_list}) def add_students(request): if request.method=='GET': cs_list=models.Classes.objects.all() return render(request,'add_students.html',{'cs_list':cs_list}) elif request.method=='POST': u=request.POST.get('username','') a=request.POST.get('age','') g=request.POST.get('gender','') c=request.POST.get('cs','') models.Students.objects.create( username=u, age=a, gender=g, cs_id=c ) return redirect('/students.html') def del_students(request): nid = request.GET.get('nid', '') models.Students.objects.filter(id=nid).delete() return redirect('/students.html') def edit_students(request): if request.method=="GET": nid = request.GET.get('nid', '') obj=models.Students.objects.get(id=nid) cs_list = models.Classes.objects.all() return render(request,'edit_students.html',{'obj':obj,'cs_list':cs_list}) elif request.method=="POST": nid=request.POST.get('nid','') u = request.POST.get('username', '') a = request.POST.get('age', '') g = request.POST.get('gender', '') c = request.POST.get('cs', '') models.Students.objects.filter(id=nid).update( username=u, age=a, gender=g, cs_id=c) return redirect('/students.html')
2.在urls.py 中配置url路由:
from django.contrib import admin from django.urls import path from app01.views import classes,students,teachers urlpatterns = [ path('admin/', admin.site.urls), path('classes.html', classes.get_classes), path('add_classes.html', classes.add_classes), path('del_classes.html', classes.del_classes), path('edit_classes.html', classes.edit_classes), path('students.html', students.get_students), path('add_students.html', students.add_students), path('del_students.html', students.del_students), path('edit_students.html', students.edit_students), # path('teachers.html', teachers.get_teachers), ]
3.在template目录下建立所需的html页面文件:
get_students.html
<!DOCTYPE html> <html lang="en"> <head> <style> tr td{ border:1px solid #000;text-align:center;} </style> <meta charset="UTF-8"> <title>Title</title> </head> <body> <div> <table> <thead> <tr> <th>ID</th> <th>姓名</th> <th>年龄</th> <th>性别</th> <th>班级</th> <th>操作</th> </tr> </thead> <tbody> {% for row in stu_list %} <tr> <td>{{ row.id }}</td> <td>{{ row.username }}</td> <td>{{ row.age }}</td> <td>{{ row.gender }}</td> <td>{{ row.cs.title }}</td> <td><a href="/del_students.html" rel="external nofollow" rel="external nofollow" >删除</a> |<a href="/edit_students.html" rel="external nofollow" rel="external nofollow" >编辑</a> </td> </tr> {% endfor %} </tbody> </table> </div> <div><a href="/add_students.html" rel="external nofollow" rel="external nofollow" >添加</a> </div> </body> </html>
add_students
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <h1>添加用户</h1> <form method="post" action="/add_students.html"> {% csrf_token %} <p><input type="text" name="username" placeholder="用户名"></p> <p><input type="text" name="age" placeholder="年龄"></p> <p> 男<input type="radio" name="gender" value="1"> 女<input type="radio" name="gender" value="0"> </p> <p> <select name="cs"> {% for row in cs_list %} <option value="{{ row.id }}">{{ row.title }}</option> {% endfor %} </select> </p> <p><input type="submit" value="提交"></p> </form> </body> </html>
edit_students.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <h1>编辑用户</h1> <form method="post" action="/edit_students.html"> {% csrf_token %} <input type="hidden" name="nid" value="{{ obj.id }}"> <p><input type="text" name="username" placeholder="用户名"></p> <p><input type="text" name="age" placeholder="年龄"></p> <p> 男<input type="radio" name="gender" value="1"> 女<input type="radio" name="gender" value="0"> </p> <p> <select name="cs"> {% for row in cs_list %} <option value="{{ row.id }}">{{ row.title }}</option> {% endfor %} </select> </p> <p><input type="submit" value="提交"></p> </form> </body> </html>
7.学员管理系统之给班级分配老师:
在teachers数据表中增加一些老师信息:
在pycharm右上角的Database打开面板,然后将template目录下边的db.splte3鼠标拖入到Database面板中,打开db==》app01_teachers表
点击“+”,然后填入老师信息,然后点击有“DB”标志的向上箭头,进行数据保存。
1.在classes.py中增加set_teachers函数
def set_teachers(request): if request.method=='GET': nid=request.GET.get('nid','') cls_obj=models.Classes.objects.get(id=nid) cls_teacher_list=cls_obj.a.all() all_teacher_list=models.Teachers.objects.all() return render(request,'set_teachers.html',{ 'cls_teacher_list':cls_teacher_list, 'all_teacher_list':all_teacher_list, 'nid':nid, }) elif request.method=='POST': nid = request.POST.get('nid', '') ids_str=request.POST.getlist('teacher_id','') ids_int=[] for i in ids_str: i=int(i) ids_int.append(i) obj=models.Classes.objects.get(id=nid) obj.a.set(ids_int) return redirect('/classes.html')
2.在urls.py 中配置url路由:
from django.contrib import admin from django.urls import path from app01.views import classes,students,teachers urlpatterns = [ path('admin/', admin.site.urls), path('classes.html', classes.get_classes), path('add_classes.html', classes.add_classes), path('del_classes.html', classes.del_classes), path('edit_classes.html', classes.edit_classes), path('students.html', students.get_students), path('add_students.html', students.add_students), path('del_students.html', students.del_students), path('edit_students.html', students.edit_students), path('set_teachers.html', classes.set_teachers), ]
3.在template目录下建立所需的html页面文件:
set_teachers.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <form action="/set_teachers.html" method="post"> <input type="hidden" name="nid" value="{{ nid }}"> {% csrf_token %} <select multiple size="10" name="teacher_id"> {% for item in all_teacher_list %} {% if item in cls_teacher_list %} <option value="{{ item.id }}" selected="selected">{{ item.name }}</option> {% else %} <option value="{{ item.id }}">{{ item.name }}</option> {% endif %} {% endfor %} </select> <input type="submit" value="提交"> </form> </body> </html>
对get_classes.html进行增添修改为:
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <div> <table> <thead> <tr> <th>ID</th> <th>名称</th> <th>任课老师</th> <th>操作</th> </tr> </thead> <tbody> {% for row in cls_list %} <tr> <td>{{ row.id }}</td> <td>{{ row.title }}</td> <td> {% for item in row.a.all %} <span>{{ item.name }}</span> {% endfor %} </td> <td><a href="/del_classes.html" rel="external nofollow" rel="external nofollow" >删除</a> |<a href="/edit_classes.html" rel="external nofollow" rel="external nofollow" >编辑</a> |<a href="/set_teachers.html" rel="external nofollow" >分配老师</a> </td> </tr> {% endfor %} </tbody> </table> </div> <div><a href="/add_classes.html" rel="external nofollow" rel="external nofollow" >添加</a> </div> </body> </html>
8.初识Ajax
Ajax是异步传输方式,偷偷的向后台发请求,不引起页面刷新,下面通过一个小例子来认识Ajax这种数据传输方式。
首先下载jQuery导入项目下的static目录下
1.在app01/Views目录下新建ajax.py
from django.shortcuts import render,redirect,HttpResponse def ajax1(request): return render(request,'ajax1.html') def ajax2(request): u=request.GET.get('username') p=request.GET.get('password') return HttpResponse('我愿意')
2.在urls.py中配置相关路由
from django.contrib import admin from django.urls import path from app01.views import classes,students,teachers,ajax urlpatterns = [ path('admin/', admin.site.urls), path('classes.html', classes.get_classes), path('add_classes.html', classes.add_classes), path('del_classes.html', classes.del_classes), path('edit_classes.html', classes.edit_classes), path('students.html', students.get_students), path('add_students.html', students.add_students), path('del_students.html', students.del_students), path('edit_students.html', students.edit_students), path('set_teachers.html', classes.set_teachers), path('ajax1.html', ajax.ajax1), path('ajax2.html', ajax.ajax2), ]
3.在template目录下新建ajax1.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> <style> .btn{ display: inline-block; padding: 5px 15px; background-color: coral; color: white; cursor: pointer; } </style> </head> <body> <div> <input placeholder="用户名" type="text"> <input placeholder="密码" type="password"> <div class="btn">提交</div> </div> <script src="/UploadFiles/2021-04-08/jquery-3.3.1.js">9.学员管理系统之Ajax删除学员: 1.在ajax.py中增加ajax4函数
from app01 import models def ajax4(request): nid=request.GET.get('nid') msg='成功' try: models.Students.objects.get(id=nid).delete() except Exception as e: msg=str(e) return HttpResponse(msg)2.在urls.py中配置相关路由
from django.contrib import admin from django.urls import path from app01.views import classes,students,teachers,ajax urlpatterns = [ path('admin/', admin.site.urls), path('classes.html', classes.get_classes), path('add_classes.html', classes.add_classes), path('del_classes.html', classes.del_classes), path('edit_classes.html', classes.edit_classes), path('students.html', students.get_students), path('add_students.html', students.add_students), path('del_students.html', students.del_students), path('edit_students.html', students.edit_students), path('set_teachers.html', classes.set_teachers), path('ajax1.html', ajax.ajax1), path('ajax2.html', ajax.ajax2), path('ajax4.html', ajax.ajax4), ]3.对get_students.html进行添加修改:
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <div> <table> <thead> <tr> <th>ID</th> <th>姓名</th> <th>年龄</th> <th>性别</th> <th>班级</th> <th>操作</th> </tr> </thead> <tbody> {% for row in stu_list %} <tr nid="{{ row.id }}"> <td>{{ row.id }}</td> <td>{{ row.username }}</td> <td>{{ row.age }}</td> <td>{{ row.gender }}</td> <td>{{ row.cs.title }}</td> <td><a href="/del_students.html" rel="external nofollow" rel="external nofollow" >删除</a> |<a href="#" rel="external nofollow" >Ajax删除</a> |<a href="/edit_students.html" rel="external nofollow" rel="external nofollow" >编辑</a> </td> </tr> {% endfor %} </tbody> </table> </div> <div><a href="/add_students.html" rel="external nofollow" rel="external nofollow" >添加</a> </div> </body> <script src="/UploadFiles/2021-04-08/jquery-3.3.1.js">
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
稳了!魔兽国服回归的3条重磅消息!官宣时间再确认!
昨天有一位朋友在大神群里分享,自己亚服账号被封号之后居然弹出了国服的封号信息对话框。
这里面让他访问的是一个国服的战网网址,com.cn和后面的zh都非常明白地表明这就是国服战网。
而他在复制这个网址并且进行登录之后,确实是网易的网址,也就是我们熟悉的停服之后国服发布的暴雪游戏产品运营到期开放退款的说明。这是一件比较奇怪的事情,因为以前都没有出现这样的情况,现在突然提示跳转到国服战网的网址,是不是说明了简体中文客户端已经开始进行更新了呢?
更新日志
- 凤飞飞《我们的主题曲》飞跃制作[正版原抓WAV+CUE]
- 刘嘉亮《亮情歌2》[WAV+CUE][1G]
- 红馆40·谭咏麟《歌者恋歌浓情30年演唱会》3CD[低速原抓WAV+CUE][1.8G]
- 刘纬武《睡眠宝宝竖琴童谣 吉卜力工作室 白噪音安抚》[320K/MP3][193.25MB]
- 【轻音乐】曼托凡尼乐团《精选辑》2CD.1998[FLAC+CUE整轨]
- 邝美云《心中有爱》1989年香港DMIJP版1MTO东芝首版[WAV+CUE]
- 群星《情叹-发烧女声DSD》天籁女声发烧碟[WAV+CUE]
- 刘纬武《睡眠宝宝竖琴童谣 吉卜力工作室 白噪音安抚》[FLAC/分轨][748.03MB]
- 理想混蛋《Origin Sessions》[320K/MP3][37.47MB]
- 公馆青少年《我其实一点都不酷》[320K/MP3][78.78MB]
- 群星《情叹-发烧男声DSD》最值得珍藏的完美男声[WAV+CUE]
- 群星《国韵飘香·贵妃醉酒HQCD黑胶王》2CD[WAV]
- 卫兰《DAUGHTER》【低速原抓WAV+CUE】
- 公馆青少年《我其实一点都不酷》[FLAC/分轨][398.22MB]
- ZWEI《迟暮的花 (Explicit)》[320K/MP3][57.16MB]