1、路由urls.py
from django.contrib import admin from django.urls import path from app01.views import index urlpatterns = [ path(‘admin/‘, admin.site.urls), path(‘index/‘,index) ]
2、数据库表模型models.py
from django.db import models # Create your models here. class Book(models.Model): name = models.CharField(max_length=100) author = models.CharField(max_length=20) price = models.IntegerField() dsp = models.CharField(max_length=100)
3、数据库配置settings.py
DATABASES = { ‘default‘: { ‘ENGINE‘: ‘django.db.backends.mysql‘, ‘HOST‘: ‘127.0.0.1‘, ‘PORT‘: 3306, ‘USER‘: ‘root‘, ‘PASSWORD‘: ‘1‘, ‘NAME‘: ‘demo‘ } }
4、视图函数views.py
from django.shortcuts import render from app01.models import Book from django.core.paginator import Paginator #导入Paginator分页器 def index(request): book_all_list = Book.objects.all() #获取所有的书籍数据 p = Paginator(book_all_list,15) #实例化分页对象 page = request.GET.get(‘page‘,1) #获取GET方法传递过来的页码数,没有则默认为 1 current_page = int(page) #传过来的page是一个字符串,需要转换成int类型 book_object = p.page(current_page) #获取第current_page页的对象 book_list = book_object.object_list #获取第current_page页的对象的元素列表 return render(request,‘index.html‘,{‘book_list‘: book_list,‘p‘: p,‘book_object‘: book_object})
5、前端页面index.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>测试</title> <style> .content{ width: 100%; } .tb1{ width: 80%; margin-left: 100px; } </style> </head> <body> <div class="content"> <table border="1px" class="tb1"> <tr> <th>序号</th> <th>书名</th> <th>作者</th> <th>价格</th> <th>描述</th> </tr> {# 遍历展示当前页的数据 #} {% for book in book_list %} <tr> <td>{{ book.id }}</td> <td>{{ book.name }}</td> <td>{{ book.author }}</td> <td>{{ book.price }}</td> <td>{{ book.dsp }}</td> </tr> {% endfor %} </table> </div> <div style="margin-left: 100px;margin-top: 20px;"> {# 如果当前页有上一页,则可以通过上一页发送GET请求传递page参数,需要从views中传入当前页的对象book_object #} {% if book_object.has_previous %} <a href="/index/?page={{ book_object.previous_page_number }}">上一页</a> {% endif %} {# 获取分页对象的页码列表并遍历,需要从views中传入分页对象p #} {% for num in p.page_range %} <a href="/index/?page={{ num }}">{{ num }}</a> {% endfor %} {# 如果当前页有下一页,则可以通过下一页发送GET请求传递page参数,需要从views中传入当前页的对象book_object #} {% if book_object.has_next %} <a href="/index/?page={{ book_object.next_page_number }}">下一页</a> {% endif %} </div> </body> </html>
6、效果(没有添加样式,只是实现功能,所以页面比较丑!!!)