第13章节-Python3.5-DjangoORM基本增删查该

  • Django操作数据库,操作数据表如下效果图:

  • 刷新浏览器:


    image.png

  • 刷新Navicat数据库:


    image.png
  • image.png

  • 修改app01\urls.py:

from django.conf.urls import url,include
from django.contrib import admin
from app01 import views


urlpatterns = [
    url(r'^login/', views.login),
    url(r'orm/', views.orm),
]
image.png
  • 修改app01\views.py:
from django.shortcuts import render,HttpResponse,redirect

USER_DICT = {
    '1': {'name': 'root1', 'email': 'root@live.com'},
    '2': {'name': 'root2', 'email': 'root@live.com'},
    '3': {'name': 'root3', 'email': 'root@live.com'},
    '4': {'name': 'root4', 'email': 'root@live.com'},
    '5': {'name': 'root5', 'email': 'root@live.com'},
}


def index(request,nid,uid):
    # indexx
    print(request.path_info)
    # /asdfasdfasdf/13/
    # reverse 能反转
    from django.urls import reverse
    # v = reverse('indexx', args=(90,88,))
    v = reverse('indexx', kwargs={'nid':'1','uid':'99'})
    print(v)

    return render(request, 'index.html', {'user_dict': USER_DICT})


def detail(request, nid):
    # print(nid, uid)
    # return HttpResponse(nid)
    detail_info = USER_DICT[nid]
    return render(request, 'detail.html', {'detail_info': detail_info})


def login(request):
    # 判断用户获取数据方式是GET,就返回什么数据
    if request.method == "GET":
        return render(request, 'login.html')
    # 判断用户获取数据方式是POST,就判断用户提交的数据是否正确
    elif request.method == "POST":
        # 数据表中执行 select * from user where username='x' and password='x'
        return render(request, 'login.html')
    else:
        # PUT,DELETE,HEAD,OPTION...
        return redirect("/index/")

from app01 import models
def orm(request):
    # 操作数据操作表
    models.UserInfo.objects.create(
        username='root',
        password='123'
    )
    return HttpResponse('orm')


from django.views import View


class Home(View):

    # 调用父类中的dispatch(相当于助理,)
    def dispatch(self, request, *args, **kwargs):
        print('before')
        result = super(Home,self).dispatch(request, *args, **kwargs)
        print('after')
        return result

    def get(self,request):
        print(request.method)
        return render(request, 'home.html')

    def post(self,request):
        print(request.method, 'POST')
        return render(request, 'home.html')

  • $@进一步数据库查的操作(Django访问数据库查的操作)

  • $ 效果图:

  • 刷新一下浏览器:


    image.png

  • 重启一下程序(在浏览器刷新一下):


    image.png
image.png
  • urls.py
from django.conf.urls import url,include
from django.contrib import admin
from app01 import views


urlpatterns = [
    url(r'^login/', views.login),
    url(r'orm/', views.orm),
]
  • image.png
  • views.py:
from django.shortcuts import render,HttpResponse,redirect

USER_DICT = {
    '1': {'name': 'root1', 'email': 'root@live.com'},
    '2': {'name': 'root2', 'email': 'root@live.com'},
    '3': {'name': 'root3', 'email': 'root@live.com'},
    '4': {'name': 'root4', 'email': 'root@live.com'},
    '5': {'name': 'root5', 'email': 'root@live.com'},
}


def index(request,nid,uid):
    # indexx
    print(request.path_info)
    # /asdfasdfasdf/13/
    # reverse 能反转
    from django.urls import reverse
    # v = reverse('indexx', args=(90,88,))
    v = reverse('indexx', kwargs={'nid':'1','uid':'99'})
    print(v)

    return render(request, 'index.html', {'user_dict': USER_DICT})


def detail(request, nid):
    # print(nid, uid)
    # return HttpResponse(nid)
    detail_info = USER_DICT[nid]
    return render(request, 'detail.html', {'detail_info': detail_info})


def login(request):
    # 判断用户获取数据方式是GET,就返回什么数据
    if request.method == "GET":
        return render(request, 'login.html')
    # 判断用户获取数据方式是POST,就判断用户提交的数据是否正确
    elif request.method == "POST":
        # 数据表中执行 select * from user where username='x' and password='x'
        return render(request, 'login.html')
    else:
        # PUT,DELETE,HEAD,OPTION...
        return redirect("/index/")

from app01 import models
def orm(request):
    # 创建  操作数据操作表(推荐)*****************
    # models.UserInfo.objects.create(username='root',password='123')

    # 效果同上
    # dic = {'username': 'eric', 'password':'666'}
    # models.UserInfo.objects.create(**dic)

    # 效果(作用)同上
    # obj = models.UserInfo(username='root',password='123')
    # obj.save()

    # 查   ******************
    result = models.UserInfo.objects.all()
    # result,QuerySet => Django => []
    # [obj(id,username,password), obj(id,username,password), obj(id,username,password)]
    for row in result:
        print(row.id,row.username,row.password)
    print(result)

    return HttpResponse('orm')


from django.views import View


class Home(View):

    # 调用父类中的dispatch(相当于助理,)
    def dispatch(self, request, *args, **kwargs):
        print('before')
        result = super(Home,self).dispatch(request, *args, **kwargs)
        print('after')
        return result

    def get(self,request):
        print(request.method)
        return render(request, 'home.html')

    def post(self,request):
        print(request.method, 'POST')
        return render(request, 'home.html')

  • 基本增删改查:

from app01 import models
def orm(request):
    # 创建  操作数据操作表(推荐)*****************
    # models.UserInfo.objects.create(username='root',password='123')

    # 效果同上
    # dic = {'username': 'eric', 'password':'666'}
    # models.UserInfo.objects.create(**dic)

    # 效果(作用)同上
    # obj = models.UserInfo(username='root',password='123')
    # obj.save()

    # 查   ******************
    # result = models.UserInfo.objects.all()
    # filter查找哪一个
    # result = models.UserInfo.objects.filter(username='root')
    # result,QuerySet => Django => []
    # [obj(id,username,password), obj(id,username,password), obj(id,username,password)]
    # for row in result:
    #     print(row.id,row.username,row.password)
    # print(result)

    # 删除*********************all(), filter()
    # models.UserInfo.objects.filter(username="root").delete()

    # 更新**********************update(),all(), filter()
    models.UserInfo.objects.filter(id=3).update(password='889')

    return HttpResponse('orm')
image.png
image.png
©著作权归作者所有,转载或内容合作请联系作者
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

推荐阅读更多精彩内容

  • Django基础笔记
    切换到创建项目的目录 cd C:\Users\admin\Desktop\DjangoProject创建名为pr...
    在努力中阅读 3,321评论 2赞 3
  • iOS工具和框架1
    1、通过CocoaPods安装项目名称项目信息 AFNetworking网络请求组件 FMDB本地数据库组件 SD...
    阳明AGI阅读 16,018评论 3赞 119
  • django养生
    模块间联系越多，其耦合性越强，同时表明其独立性越差( 降低耦合性，可以提高其独立性)。软件设计中通常用耦合度和内聚...
    riverstation阅读 2,097评论 0赞 8
  • 爱情的山高水长
    或许我们所经历的 我应该遗忘 让以后的时光去镀金过去的时光 让以后的记忆去回忆过去的记忆 让现在的痛苦变得历久弥香...
    谭小虎nn阅读 607评论 9赞 6
  • 爱情的颜色
    文/简小淇 年轻人的爱情是粉红色的！ 我想是的。 粉嫩的面庞带着纯真的微笑， 不言语，堪比那 灼灼桃花发。 中年人...
    简小淇阅读 478评论 9赞 8