Python网页版如何实现分页功能_Python网页版分页功能代码实现与优化

from flask import Flask, render_template, request
from flask_sqlalchemy import SQLAlchemy
<p>app = Flask(<strong>name</strong>)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///posts.db'
db = SQLAlchemy(app)</p><p>class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
content = db.Column(db.Text, nullable=False)</p><p>@app.route('/posts')
def posts():
page = request.args.get('page', 1, type=int)
per_page = 5  # 每页显示5条
pagination = Post.query.paginate(page=page, per_page=per_page, error_out=False)
return render_template('posts.html', pagination=pagination)</p>

<!-- posts.html -->
<ul>
{% for post in pagination.items %}
  <li><h3>{{ post.title }}</h3><p>{{ post.content|truncate(100) }}</p></li>
{% endfor %}
</ul>
<p><div class="pagination">
{% if pagination.has_prev %}
<a href="?page={{ pagination.prev_num }}">上一页</a>
{% endif %}</p><p>{% for p in pagination.iter_pages(left_edge=1, right_edge=1, left_current=2, right_current=3) %}
{% if p %}
{% if p == pagination.page %}
<span class="current">{{ p }}</span>
{% else %}
<a href="?page={{ p }}">{{ p }}</a>
{% endif %}
{% else %}
<span class="ellipsis">...</span>
{% endif %}
{% endfor %}</p><p>{% if pagination.has_next %}
<a href="?page={{ pagination.next_num }}">下一页</a>
{% endif %}
</div></p>

@app.route('/posts/latest')
def latest_posts():
    after_id = request.args.get('after', None, type=int)
    query = Post.query.order_by(Post.id.desc())
    if after_id:
        query = query.filter(Post.id < after_id)
    posts = query.limit(6).all()  # 多取一条判断是否有下一页
    has_next = len(posts) > 5
    posts = posts[:5]
    return render_template('latest_posts.html', posts=posts, has_next=has_next)