python flask 的分页使用
1、views 如下示例代码:
@admin.route("/account/list/<int:page>/", methods=["GET"])@admin_login_reqdef account_list(page=None): if page is None: page = 1 page_data = Account.query.order_by( Account.name.desc() ).paginate(page=page, per_page=10) return render_template('admin/account_list.html', page_data=page_data)
2、模板 account_list.html
{% extends 'admin/base.html' %}{% import "admin/ui/admin_page.html" as pg %}{% block css %}{% endblock %}{% block content %}<div class="panel panel-default"> <div class="panel-heading"> 查询条件 </div> <div class='panel-body'> <div class="row"> <form role="form"> <div class="col-sm-6 col-md-6 col-lg-4"> <div class="form-group"> <div class="input-group"> <div class="input-group-addon">查找</div> <input class="form-control" type="email"> </div> </div> </div> <div class="col-lg-12"> <hr class="mt5 mb15"> <button type="submit" class="king-btn king-info">查询</button> <a class="king-btn king-success" href="{{ url_for('admin.account_add') }}">添加账号</a> </div> </form> </div> </div></div><!----><div class="panel panel-default"> <div class="panel-heading"> 带边框的表格 </div> {% for msg in get_flashed_messages(category_filter=["ok"]) %} <div class="king-notice2 king-notice-success notice-borders"> <i class="fa fa-check-circle"></i> <div class="notice-text"> <p>{{ msg }}</p> </div> </div> {% endfor %} <div class='panel-body'> <div class="table-responsive"> <table class="table table-bordered table-hover table-striped"> <thead> <tr> <th>名称</th> <th>网站/IP</th> <th>用户名</th> <th>密码</th> <th>备注</th> <th>操作</th> </tr> </thead> <tbody> {% for v in page_data.items %} <tr> <td>{{ v.name }}</td> <td>{{ v.website }}</td> <td>{{ v.username }}</td> <td>{{ v.pwd }}</td> <td>{{ v.comment }}</td> <td> <button type="submit" class="king-btn king-warning">编辑</button> <a href="{{ url_for('admin.account_del', id=v.id) }}" type="submit" class="king-btn king-danger">删除</a> </td> </tr> {% endfor %} <tfoot> <tr> <td colspan="6"> <div class="pagination-info pull-left">共有{{ page_data.total }}条,每页显示:{{ page_data.per_page }}条 </div> <div class="pull-right king-page-box"> {{ pg.page(page_data, 'admin.account_list') }} </div> </td> </tr> </tfoot> </tbody> </table> </div> </div></div></div>{% endblock %}{% block js %}{% endblock %}
3、admin_page.html 为分页的模板
{% macro page(data, url) -%}{% if data %}<ul class="pagination pagination-small pull-right"> <li><a href="{{ url_for(url, page=1) }}">首页</a></li> {% if data.has_prev %} <li class="active"><a href="{{ url_for(url, page=data.prev_num) }}">上一页</a></li> {% else %} <li class="disabled"><a href="#">上一页</a></li> {% endif %} {% for v in data.iter_pages() %} {% if v == data.page %} <li class="active"><a>{{ v }}</a></li> {% else %} <li><a href="{{ url_for(url, page=v) }}">{{ v }}</a></li> {% endif %} {% endfor %} {% if data.has_next %} <li class="active"><a href="{{ url_for(url, page=data.next_num) }}">下一页</a></li> {% else %} <li class="disabled"><a href="#">下一页</a></li> {% endif %} <li><a href="{{ url_for(url, page=data.pages) }}">尾页</a></li></ul>{% endif %}{%- endmacro %}
flask-sqlalchemy 的分页参考文档 http://www.pythondoc.com/flask-sqlalchemy/api.html#id1
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。