Django 模型操作-分页（七）

我就是我 2024-02-05 14:06 76阅读 0赞

### 一、连接MySql数据库 ###

1、先安装MySQL

2、再安装MySQL驱动  
使用mysqlclient  
pip install mysqlclient

> 如果上面的命令安装失败, 则尝试使用国内豆瓣源安装:  
> pip install -i https://pypi.douban.com/simple mysqlclient

### 二、在settings.py中配置 ###

![ca9f96bac9544a0eb42c526feb0de0ad.png][]

### 三、 book表的数据 ###

![67c92bd912f645b38174a57dfecfeb27.png][]

### 四、手动分页和自动分页 ###

**1、函数视图**

**手动分页**

#手动分页
    def get_pageinfo(request,page=1):
        # 每页显示6条数据
        per_page = 6
    
        # 分页分析
        # 数据[1,2,3,45,..100]
        # 第几页    数据范围   数据下标范围     切片
        #  page=1   1-6        0~5         [0:6]   =>   (1-1)*6  1*6
        #  page=2   7-12       6~11        [6:12]  =>   (2-1)*6  2*6
        #  page=3   13-18      12~17       [12:18] =>   (3-1)*6  3*6
        #   ..................
    
        # 获取所有的数据
        all=Book.objects.all()
        # 数据分页
        books=all[(page-1)*per_page:page*per_page]
        # 总个数
        count=Book.objects.count()
        # 总页数
        total_page=math.ceil(count/per_page)
    
        #数据范围 1,2,3,4..
        list_page=range(1,total_page+1)
    
        return render(request=request, template_name='show.html', context={'books':books,'listpages':list_page})

**2、show.html页面**

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
        <style type="text/css">
            #ul li {
                width: 30%;
                list-style: none;
                padding: 10px 0px;
                border: 1px solid cadetblue;
            }
    
            #pp li {
                display: inline;
    
            }
    
            .ff{
                font-weight: bolder;
            }
        </style>
    </head>
    <body>
    <div>
        <h1>手动分页图书数据</h1>
        <ul id="ul">
            <li class="ff">编号----书名------价格------日期-------出版社编号</li>
            {% for bk in books %}
                <li>{
       { bk.id }} -- {
       { bk.title }} -- {
       { bk.price}}-- {
       { bk.pub_date| date:"Y-m-d" }}-- {
       { bk.publish_id}}</li>
            {% endfor %}
        </ul>
        <div>
            <ul id="pp">
                {% for pa in listpages %}
                    <li><a href="{% url 'pages' pa %}">
                        <button>第{
       { pa }}页</button>
                    </a></li>
                {% endfor %}
            </ul>
        </div>
    </div>
    </body>
    </html>

**3、运行效果**

![4a25af34bc3c418bb1cf6fc82bf26db6.png][]

**（2） 自动分页**

源码：Paginator类

![388dbd352ac94188b9f46204e18b2c21.png][]

**1、函数视图**

#自动分页
    def auto_pageinfo(request,page=1):
        # 每页显示6条数据
        per_page = 6
    
        # 获取所有的数据
        all=Book.objects.all()
    
        #使用分页器分页
        from django.core.paginator import Paginator
        paginator=Paginator(all,per_page)
    
        #获取第几页的数据
        books=paginator.page(page)
    
        # 页码范围
        #数据范围 1,2,3,4..
        list_page=paginator.page_range
    
        return render(request=request, template_name='autoshow.html', context={'books':books,'listpages':list_page})

**2、aushow.html页面**

<div>
        <h1>自动分页图书数据</h1>
        <ul id="ul">
            <li class="ff">编号----书名------价格------日期-------出版社编号</li>
            {% for bk in books %}
                <li>{
       { bk.id }} -- {
       { bk.title }} -- {
       { bk.price}}-- {
       { bk.pub_date| date:"Y-m-d" }}-- {
       { bk.publish_id}}</li>
            {% endfor %}
        </ul>
        <div>
            <ul id="pp">
                {% for pa in listpages %}
                    <li><a href="{% url 'pages2' pa %}">
                        <button>第{
       { pa }}页</button>
                    </a></li>
                {% endfor %}
            </ul>
        </div>
    </div>

**3、配置url路径**

from django.urls import path
    
    from books import views
    
    urlpatterns = [
        path('pages/<int:page>', views.get_pageinfo,name='pages'),  #别名pages
        path('pages2/<int:page>', views.auto_pageinfo,name='pages2'),  #别名pages2
        path('pages3/', views.auto_pageinfo2,name='pages3'),  #别名pages3
    
    ]

**4、运行效果**

![d6900e7cc17e4ec6814113933607e2d9.png][]

### 五、使用分页插件Django-pure-pagination ###

**1、安装**

> pip install django-pure-pagination

![85c0dcbba73e4cb3a9bf00a5c501448a.png][]

**2、在settings.py中注册**

INSTALLED_APPS = [
         .....,
        'pure_pagination',
    ]

**3、在settings.py中配置分页切割方式**

# 分页配置
    PAGINATION_SETTINGS = {
        'PAGE_RANGE_DISPLAYED':2, # 当前页相邻显示几个号码页
        'MARGIN_PAGES_DISPLAYED': 1,  # 首尾各显示几个号码页
        'SHOW_FIRST_PAGE_WHEN_INVALID': True,
    }

**4、函数视图**

#分页插件
    def auto_pageinfo2(request,page=1):
        # 每页显示5条数据
        per_page =3
    
        # 获取所有的数据
        all=Book.objects.all()
    
        #使用分页器分页
        from django.core.paginator import Paginator
        paginator=Paginator(all,per_page)
    
        try:
            page_number = request.GET.get('page', page)
        except PageNotAnInteger:
            page_number = 1
    
        #获取第几页的数据
        books=paginator.page(page_number)
    
        # 页码范围
        # 数据范围 1,2,3,4..
        list_page = paginator.page_range
    
        # books.paginator.pages
    
        return render(request, 'list.html', {'page_obj': books,"pages":list_page})

**5、模板**

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
        <style type="text/css">
            #ul li {
                width: 30%;
                list-style: none;
                padding: 10px 0px;
                border: 1px solid cadetblue;
            }
    
            a {
                padding: 5px 10px;
                color: white;
                background-color: darkgray;
                margin: 1px; /*设置标签 a 之间的间隔*/
                text-decoration: none; /*去除页码数字下面的下划线*/
            }
    
            a:hover {
                color: black;
                background: cyan;
            }
    
            .current {
                color: black;
            }
        </style>
    </head>
    <body>
    <div>
        <h1>插件分页图书数据</h1>
        <ul id="ul">
            <li class="ff">编号----书名------价格------日期-------出版社编号</li>
            {% for bk in page_obj %}
                <li>{
       { bk.id }} -- {
       { bk.title }}
                    -- {
       { bk.price }}-- {
       { bk.pub_date| date:"Y-m-d" }}-- {
       { bk.publish_id }}</li>
            {% endfor %}
        </ul>
    </div>
    
    
    {#Django-pure-pagination基础渲染方法#}
    {#<div id="pagination">#}
    {#    {
       { page_obj.render }}#}
    {#</div>#}
    
    
    <div class="pagination">
        <span class="step-links">
            {% if page_obj.has_previous %}
                <a href="?page={
       { page_obj.previous_page_number }}"> << </a>
            {% else %}
                <a href=""> << </a>
            {% endif %}
    
            <span class="current">
    {#            Page {
       { page_obj.number }} of {
       { page_obj.paginator.num_pages }}.#}
    
                {% for page in pages %}
                    {% if page %}
                        {% if page == page_obj.number %}
                            <a href="?page={
       { page }}"><span class="current">{
       { page }}</span></a>
                        {% else %}
                            <a href="?page={
       { page }}" class="page">{
       { page }}</a>
                        {% endif %}
                    {% else %}
                        <a href="">...</a>
                    {% endif %}
                {% endfor %}
    
            </span>
    
    
            {% if page_obj.has_next %}
                <a href="?page={
       { page_obj.next_page_number }}"> >> </a>
            {% else %}
                <a href=""> >> </a>
            {% endif %}
        </span>
    </div>
    
    </body>
    </html>

**6、运行效果**

![449a30a3b55140d385e6964b658dab8e.png][]

![53b9e661eb6b4636932dfe55df2499b3.png][]

[ca9f96bac9544a0eb42c526feb0de0ad.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/c15e0cdb5ceb4d839e1edb22409e49ef.png
[67c92bd912f645b38174a57dfecfeb27.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/146483f4b6054b4f87dade1e18a64adc.png
[4a25af34bc3c418bb1cf6fc82bf26db6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/48dddd9e9242494493c7d3fc0e387053.png
[388dbd352ac94188b9f46204e18b2c21.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/0077b650f40b443288dcc542c9219290.png
[d6900e7cc17e4ec6814113933607e2d9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/cbce61c24554475fbca62d71341ddf43.png
[85c0dcbba73e4cb3a9bf00a5c501448a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/6387f2aba041485383728992c298fddb.png
[449a30a3b55140d385e6964b658dab8e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/cc924b265b6c4741808043eb98937054.png
[53b9e661eb6b4636932dfe55df2499b3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/e863cf14fb734c14b4e8c7954052f917.png