分页

分页

from flask import *
from flask_sqlalchemy import SQLAlchemy

app = Flask(name)
app.config[‘SQLALCHEMY_DATABASE_URI’] = ‘mysql+pymysql://root:12345678@127.0.0.1:3306/KaoShi’
db = SQLAlchemy(app)

用户表

class User(db.Model):
tablename = ‘user’
id = db.Column(db.Integer, primary_key=True)
user_name = db.Column(db.String(200))
pwd = db.Column(db.String(200))
tel = db.Column(db.String(20))

@app.route(’/’)
def index():

word = request.args.get('word', '')

current_page = request.args.get('page', 1, type=int)    # 当前页
per_page = 2        # 每页条数

result = User.query.filter(User.user_name.like('%'+ word +'%')).paginate(current_page, per_page)

# 组织数据
d = {}
d['user_list'] = result.items       # 数据集
d['current_page'] = result.page     # 当前页
d['total_page'] = result.pages      # 总页数
d['word'] = word
return render_template('paginate.html', data=d)

if name == ‘main’:
app.run()