django mysql分页_Django基础之django分页

一、Django的内置分页器(paginator)

view

[

](javascript:void(0)😉

from django.shortcuts import render,HttpResponse

# Create your views here.

from app01.models import *

from django.core.paginator import Paginator, EmptyPage, PageNotAnInteger

def index(request):

'''

批量导入数据:

Booklist=[]

for i in range(100):

Booklist.append(Book(title="book"+str(i),price=30+i*i))

Book.objects.bulk_create(Booklist)

'''

'''

分页器的使用:

book_list=Book.objects.all()

paginator = Paginator(book_list, 10)

print("count:",paginator.count) #数据总数

print("num_pages",paginator.num_pages) #总页数

print("page_range",paginator.page_range) #页码的列表

page1=paginator.page(1) #第1页的page对象

for i in page1: #遍历第1页的所有数据对象

print(i)

print(page1.object_list) #第1页的所有数据

page2=paginator.page(2)

print(page2.has_next()) #是否有下一页

print(page2.next_page_number()) #下一页的页码

print(page2.has_previous()) #是否有上一页

print(page2.previous_page_number()) #上一页的页码

# 抛错

#page=paginator.page(12) # error:EmptyPage 超过页码范围

#page=paginator.page("z") # error:PageNotAnInteger 非法页码值

#page = page_obj.page(-1) #That page number is less than 1 ，也是EmptyPage的错误，页码不能为负数，最少也是1

'''

book_list=Book.objects.all()

paginator = Paginator(book_list, 10) #按照每页显示10条来计算

page = request.GET.get('page',1) #将来访问的url是这样的 http://127.0.0.1:8000/路径/?page=1

currentPage=int(page)

try:

print(page)

book_list = paginator.page(page)

except PageNotAnInteger:

book_list = paginator.page(1)

except EmptyPage:

book_list = paginator.page(paginator.num_pages)

return render(request,"index.html",{"book_list":book_list,"paginator":paginator,"currentPage":currentPage})

[

](javascript:void(0)😉

index.html:

[

](javascript:void(0)😉

Title

integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

分页器

{% for book in book_list %}

{ { book.title }} -----{ { book.price }}

{% endfor %}

{% if book_list.has_previous %}

上一页

{% else %}

上一页

{% endif %}

{% for num in paginator.page_range %}

{% if num == currentPage %}

{ { num }}

{% else %}

{ { num }}

{% endif %}

{% endfor %}

{% if book_list.has_next %}

下一页

{% else %}

下一页

{% endif %}

[

](javascrip