Django+MySQL8 简单分页

偏执的太偏执、 2023-10-10 13:12 22阅读 0赞

第一部分：models.py 实体对象定义

from django.db import models
    
    
    # Create your models here.
    class Book(models.Model):
        id = models.BigAutoField(primary_key=True)
        name = models.CharField(max_length=255, null=True)
        cover = models.CharField(max_length=255)
        author = models.CharField(max_length=255)
        price = models.DecimalField(decimal_places=2, max_digits=100000)
        is_delete = models.IntegerField()
    
        class Meta:
            managed = False
            db_table = 'book'

第二部分：views.py 视图层业务逻辑编写

import json
    from userSystem.models import Book
    from django.http import HttpResponse
    from django.core import serializers
    from django.core.paginator import Paginator, EmptyPage, PageNotAnInteger
    
    
    # Create your views here.
    def select(request):
        books = Book.objects.all()
        for i in range(len(books)):
            print("主键：%s   值：%s" % (i + 1, books[i]))
    
        return response_success(message='后台响应成功', data_list=serializers.serialize("json", books))
    
    
    def selectPage(request):
        # 当前页码
        page = request.GET.get('page')
        # 当前分页大小
        page_size = request.GET.get('pageSize')
        book_list = Book.objects.all()
        # django 分页实体对象
        paginator = Paginator(book_list, page_size)
        # 查询总记录数
        total = paginator.count
        try:
            # 执行分页查询
            books = paginator.page(page)
        except PageNotAnInteger:
            # 执行分页查询,默认指定页码
            books = paginator.page(1)
        except EmptyPage:
            # 执行分页查询,默认指定页码
            books = paginator.page(paginator.num_pages)
        return response_page_success(message='后台响应成功', data_list=serializers.serialize("json", books), total=total, page=page, pageSize=page_size)
    
    # 查询普通对象结果集封装
    def response_success(message, data=None, data_list=[]):
        return HttpResponse(json.dumps({
            'code': 200,#code由前后端配合指定
            'message': message,#提示信息
            'data': data,#返回单个对象
            'dataList': data_list#返回对象数组
        }, ensure_ascii=False), 'application/json')
    
    # 查询分页对象结果集封装
    def response_page_success(message, data=None, data_list=[], total=None, page=None, pageSize=None):
        return HttpResponse(json.dumps({
            'code': 200,#code由前后端配合指定
            'message': message,#提示信息
            'data': data,#返回单个对象
            'dataList': data_list,#返回对象数组
            'total':total,#记录总数
            'page':page,#当前页面
            'pageSize':pageSize#当前页面分页大小
        }, ensure_ascii=False), 'application/json')

第三部分：urls.py 请求映射

from django.conf.urls import url
    from . import views
    
    urlpatterns = [
        url(r'^select/', views.select),
        url(r'^selectPage/', views.selectPage)
    ]

重新启动项目：python manage.py runserver

访问分页接口：[http://127.0.0.1:8000/selectPage/?page=1&pageSize=1][http_127.0.0.1_8000_selectPage_page_1_pageSize_1]

![20210810164454941.png][]

[http://127.0.0.1:8000/selectPage/?page=1&pageSize=10][http_127.0.0.1_8000_selectPage_page_1_pageSize_10]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70][]

[http_127.0.0.1_8000_selectPage_page_1_pageSize_1]: http://127.0.0.1:8000/selectPage/?page=1&pageSize=1
[20210810164454941.png]: https://img-blog.csdnimg.cn/20210810164454941.png
[http_127.0.0.1_8000_selectPage_page_1_pageSize_10]: http://127.0.0.1:8000/selectPage/?page=1&pageSize=10
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2021081016453478.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70