wordpress增加移动端,酒泉网站建设优化,wordpress用户头像插件,望野古诗诵读数据的增删改查(insert update delete select) # 用户列表的展示#xff1a; # 把数据表中得用户数据都给查询出来展示在页面上 1. 查询 from app01 import models
models.UserInfo.objects.all() # 查询所有的字段信息和数据
resmodels.UserInfo.objects.first() # 查询…数据的增删改查(insert update delete select) # 用户列表的展示 # 把数据表中得用户数据都给查询出来展示在页面上 1. 查询 from app01 import models
models.UserInfo.objects.all() # 查询所有的字段信息和数据
resmodels.UserInfo.objects.first() # 查询一条而且是第一条queryset对象列表套对象的形式
if res:res[0]
try:res[0]
# 它是支持索引取值的如果是第一条就直接first()
select * from userinfo where username and password ;
resmodels.UserInfo.objects.filter(username, password).first() # and
resmodels.UserInfo.objects.filter(username).filter(password).filter().first() # and
链式表达式的思想jQuery中也有这样的写法
models.UserInfo.objects.all()[0]
models.UserInfo.objects.all()[0:2] # 支持切片 2. 增加 models.UserInfo.objects.create(username, password)
resmodels.UserInfo(username, password)
res.save() # 真正的操作数据库 3、修改数据的逻辑分析 # 1. 先确定修改哪条记录------怎么样确定修改哪条记录? # 2. 通过什么字段可以确定唯一一条记录? 主键id要携带主键id到后端. # 3. 在后端接收主键id值然后根据这个id值再去表中查询数据查询一条 # 4. 然后把查询的数据在渲染到页面中然后在修改 models.UserInfo.objects.filter(pk1).update(username, password)
resmodels.UserInfo.objects.first()
res.username;
res.password
res.save() # 真正的操作数据库 4、删除功能的分析 # 1. 给删除按钮加一个链接携带当前记录的id值 # 2. 后端要接收这个主键id值 # 3. 后端直接执行删除操作 models.UserInfo.objects.filter(pk1).delete()
res.delete() 数据的增删改查汇总 views.py from django.shortcuts import render,HttpResponse,reverse,redirect# Create your views here.def home(request):print(request)return HttpResponse(/home/)from app01 import modelsdef login(request):print(request.method,type(request.method))if request.method POST:username request.POST.get(username)password request.POST.get(password)print(request.POST.getList(hobby))res models.UserInfo.objects.filter(username123,password123).all()print(res)res.usernameres.passwordif username kevin and password 123:print(登录成功)models.UserInfo.objects.create(usernamekevin,password123)return redirect(/index/)else:return HttpResponse(用户名或密码错误)print(request.GET)print(request.GET.get(a))print(request.GET.get(b))print(request.GET.get(c))print(request.GET.get(c))print(request.GET.getlist(c))return render(request,login.html)def userlist(request):user_listmodels.UserInfo.objects.all()#查询所有信息这里不之处负数切片# user_listmodels.UserInfo.objects.all()[0:2] # 查询所有的数据支持for循环# for i in user_list:# print(i.gender)## queryset对象就是一个列表套对象的形式# QuerySet [UserInfo: UserInfo object, UserInfo: UserInfo object, UserInfo: UserInfo object]# print(user_list[0])print(user_list[0].username)return render(request,userlist.html,locals())def edit(request):edit_id request.GET.get(id)edit_ibj models.UserInfo.objects.filter(idedit_id).first()if request.method POST:hidden_id request.POST.get(hidden_id)username request.POST.get(username)password request.POST.get(password)gender request.POST.get(gender)# 修改affect_rows models.UserInfo.objects.filter(pkhidden_id).update(usernameusername,passwordpassword,gendergender)return redirect(/userlist/)return render(request,edit.html,locals())def delete(request):delete_id request(/userlist/)return redirect(/userlist/)def add(request):if request.method POST:username request.POST.get(username)password request.POST.get(password)gender request.POST.get(gender)user_obj models.UserInfo(usernameusername,passwordpassword,gendergender)user_obj.save()return redirect(/userlist/)return render(request,add.html)def ab_render(request):user_dict1 {username:kevin,password:123}user_dict1 {a:1}print(locals())return render(request,)urls.py
from django.contrib import admin
from django.urls import path
from app01 import viewsurlpatterns [path(admin/, admin.site.urls),path(login/, views.login),path(home/, views.home),path(userlist/, views.userlist),path(edit/, views.edit),path(delete/, views.delete),path(add/, views.add),path(ab_render/, views.ab_render),]models.py from django.db import models# Create your models here.class UserInfo(models.Model):username models.CharField(max_length32,verbose_name用户名)password models.CharField(max_length64,verbose_name密码)gender models.CharField(max_length32)def __str__(self):return self.username __init__.py import pymysql
pymysql.install_as_MySQLdb() 前端ab_render.html !DOCTYPE html
html langen
headmeta charsetUTF-8titleTitle/titlescript srchttps://cdn.bootcdn.net/ajax/libs/jquery/3.7.1/jquery.min.js/scriptlink hrefhttps://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css relstylesheetscript srchttps://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.3.7/js/bootstrap.min.js/script
/head
body{{ user_dict.username }}
{{ user_dict.password }}
{{ user_dict1 }}
{{ user_dict1.a }}
/body
/html add.html !DOCTYPE html
html langen
headmeta charsetUTF-8titleTitle/titlescript srchttps://cdn.bootcdn.net/ajax/libs/jquery/3.7.1/jquery.min.js/scriptlink relstylesheet hrefbootstrap-3.4.1-dist/css/bootstrap.min.cssscript srcbootstrap-3.4.1-dist/js/bootstrap.min.js/script
/head
body
div classcontainerdiv classrowh1 classtext-center添加页面/h1form action methodpostdiv classform-group用户名input typetext classform-control nameusername/divdiv classform-group密码input typepassword classform-control namepassword/divdiv classform-group性别input typetext classform-control namegender/div/form/div
/div
/body
/html edit.html !DOCTYPE html
html langen
headmeta charsetUTF-8titleTitle/titlescript srchttps://cdn.bootcdn.net/ajax/libs/jquery/3.7.1/jquery.min.js/scriptlink hrefhttps://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css relstylesheetscript srchttps://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.3.7/js/bootstrap.min.js/script
/head
body
div classcontainerdiv classrowh1 classtext-center修改页面/h1form action methodpostinput typehidden value{{ edit_obj.pk }} namehidden_iddiv classform-group用户名 input typetext classform-control nameusername value{{ edit_obj.username }}/divdiv classform-group密码 input typepassword classform-control namepassword value{{ edit_obj.password }}/divdiv classform-group性别 input typetext classform-control namegender value{{ edit_obj.gender }}/divdiv classform-groupinput typesubmit classbtn btn-info btn-block value提交/div/form/div
/div
/body
/html index.html !DOCTYPE html
html langen
headmeta charsetUTF-8titleTitle/titlescript srchttps://cdn.bootcdn.net/ajax/libs/jquery/3.7.1/jquery.min.js/scriptlink relstylesheet hrefbootstrap-3.4.1-dist/css/bootstrap.min.cssstyleh1{color: hotpink;}/style
/head
body
h1第一个模板文件/h1
/body
/html login.html !DOCTYPE html
html langen
headmeta charsetUTF-8titleTitle/titlescript srchttps://cdn.bootcdn.net/ajax/libs/jquery/3.7.1/jquery.min.js/scriptlink relstylesheet hrefbootstrap-3.4.1-dist/css/bootstrap.min.cssscript srcbootstrap-3.4.1-dist/js/bootstrap.min.js/script
/head
body
div classcontainerdiv classrowh1 classtext-center登录页面/h1form action methodpostdiv classform-group用户名input typetext classform-control nameusername/divdiv classform-group密码input typepassword classform-control namepassword/divdiv classform-groupinput typecheckbox namehobby valueainput typecheckbox namehobby valuebinput typecheckbox namehobby valuec/divdiv classform-groupinput typesubmit classbtn btn-success btn-block value登录/div/form/div
/div
/body
/html userlist.html !DOCTYPE html
html langen
headmeta charsetUTF-8titleTitle/titlescript srchttps://cdn.bootcdn.net/ajax/libs/jquery/3.7.1/jquery.min.js/scriptlink hrefhttps://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css relstylesheetscript srchttps://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.3.7/js/bootstrap.min.js/script
/head
body
div classcontainerdiv classrowh1 classtext-center用户列表/h1a href/add/ classbtn btn-success添加用户/atable classtable table-striped table-hover table-borderedtheadtrthID/ththusername/ththpassword/ththgender/ththaction/th/tr/theadtbody{% for user in user_list %}trtd{{ user.id }}/tdtd{{ user.username }}/tdtd{{ user.password }}/tdtd{{ user.gender }}/tdtda href/edit/?id{{ user.id }} classbtn btn-success修改/anbsp;nbsp;nbsp;a href/del/?id{{ user.pk }} classbtn btn-danger删除/a/td/tr{% endfor %}/tbody/table/div
/div
/body
/html 如何创建表关系(一对一 一对多 多对多) ### 换位思考法判断表关系 图书表和出版社表 一对多 图书表是多出版社是一 建在多的一方 图书表和作者表 多对多 需要第三张表 作者表和作者详情表 一对一 外键字段一般建在查询频率较高的 ### 在Django中如何创建表关系 回头复习表关系 class Book(models.Model):title models.CharField(max_length64)max_digitsNone,:总位数decimal_placesNone小数位数# price decimal(8,2)price models.DecimalField(max_digits8, decimal_places2)# publish_id models.ForeignKey(toPublish, to_fieldid)对于外键字段关系会自动帮我们拼接_idpublish models.ForeignKey(toPublish)authors它是一个虚拟字段它不会实际在表中创建出来这个字段这一句可以自动帮助我们创建出来第三张表authors models.ManyToManyField(toAuthor)出版社表 class Publish(models.Model):name models.CharField(max_length64)addr models.CharField(max_length64) 作者表 class Author(models.Model):name models.CharField(max_length64)author_detail models.OneToOneField(toAuthorDetail) 作者详情表 class AuthorDetail(models.Model):phone models.CharField(max_length64)email models.CharField(max_length64) Django的请求生命周期流程图 它可以帮助你们熟练django的一个完整执行流程 今日思维导图
