Python分页搜索

最新推荐文章于 2024-08-13 23:58:12 发布

原创

最新推荐文章于 2024-08-13 23:58:12 发布 · 279 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了如何使用Python进行数据库查询并实现分页显示。通过示例代码详细讲解了如何处理查询逻辑，确保高效地获取和展示大量数据。

Python人工智能之Python分页搜索

views.py

# 展示所有的学生
@blue.route('/studentlist/')
def student_list():
    # students = Student.query.all()
    # students = Student.query.filter(Student.studentname.like("%小华%"))
    # students = Student.query.filter(Student.id.__lt__(10))
    # students = Student.query.filter(Student.studentname.__le__(10))
    # students = Student.query.filter(Student.studentname.__gt__(10))
    # students = Student.query.filter(Student.studentname.__ge__(10))
    # students = Student.query.filter(Student.studentname.contains('44'))
    students = Student.query.filter(Student.studentname == '小张10')
    # students = Student.query.all()
    students = Student.query.filter(Student.studentname.startswith('小华'))
    students = Student.query.filter(Student.studentname.endswith('0'))
    #
    students = Student.query.filter_by(id=1)  # 常用在级联数据上
    students = Student.query.limit(3)  # 限制
    students = Student.query.offset(1)  # 偏移
    # students = Student.query.offset(1).order_by("id")  # 错误组合
    students = Student.query.order_by("id").limit(11).offset(1)  # 正确组合