分页实例

{% block content %}
    {{ super() }}
    <div class="container" id="goodid">
        <table class="table table-condensed">
            <tr>
                <td>商品id</td>
                <td>商品图片</td>
                <td>商品名称</td>
                <td>商品价格</td>
                <td>商品规则</td>
                <td>操作</td>
            </tr>
            {% for foo in apaganition.items %}
                <tr>
                    <td>{{ foo.id }}</td>
                    <td><img src="{{ foo.productimg }}"></td>
                    <td>{{ foo.productlongname }}</td>
                    <td>{{ foo.price }}</td>
                    <td>{{ foo.specifics }}</td>
                    <td>
                        <button type="button" class="btn btn-info">修改</button>
                        <p></p>
                        <button type="button" class="btn btn-warning">删除</button>
                    </td>
                </tr>
            {% endfor %}

        </table>
        <nav aria-label="Page navigation">
            <ul class="pagination">
                    <li>
                        {% if apaganition.has_prev %}
                            <a href="{{ url_for('axf_bg.shopmanager') }}?page={{ apaganition.prev_num }}" aria-label="Previous">
                                <span aria-hidden="true"><<</span>
                            </a>
                        {% else %}
                            <a href="{{ url_for('axf_bg.shopmanager') }}?page=1" aria-label="Previous">
                                <span aria-hidden="true"><<</span>
                            </a>
                        {% endif %}
                    </li>
                    {% for page in apaganition.iter_pages() %}
                        {% if page %}
                            <li><a href="{{ url_for('axf_bg.shopmanager') }}?page={{ page }}">{{ page }}</a></li>
                        {% else %}
                            <li class=ellipsis><a href="">…</a></li>
                        {% endif %}
                    {% endfor %}

{#            判断是否有下一页#}

                    <li>
                         {% if apaganition.has_next %}
    {#                    如果有则返回page=下一页的页码#}
                            <a href="{{ url_for('axf_bg.shopmanager') }}?page={{ apaganition.next_num }}" aria-label="Next">
                                <span aria-hidden="true">>></span>
                            </a>
                         {% else %}
                             <a href="{{ url_for('axf_bg.shopmanager') }}?page={{ apaganition.pages }}" aria-label="Next">
                                <span aria-hidden="true">>></span>
                             </a>
                         {% endif %}
                    </li>
            </ul>
        </nav>
    </div>
{% endblock %}

@blue.route("/shop/")
def shopmanager():
    #获取前端传递过来的page的值
    page = int(request.args.get("page",1))
    # 查数据，获得分页对象
    apaganition = AxfGoods.query.paginate(page,15,error_out=False)

    #判断是否有前一页
    has_prev = apaganition.has_prev
    prev_num = 1
    if has_prev:
        prev_num = apaganition.prev_num#获得前一页的页码
    #判断是否有下一页
    has_next = apaganition.has_next

    next_num = apaganition.pages
    if has_next:
        next_num = apaganition.next_num
    #页码数值的范围
    page_range = range(1,apaganition.pages+1)


    return render_template("shopmanager/goodsmanager.html",apaganition=apaganition,page_range=list(page_range),has_next=has_next,has_prev=has_prev,prev_num=prev_num,next_num=next_num,)