Python分页搜索

最新推荐文章于 2024-04-15 01:14:07 发布

samll_fish

最新推荐文章于 2024-04-15 01:14:07 发布

阅读量231

点赞数

本文链接：https://blog.csdn.net/samll_fish/article/details/103740959

版权

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

摘要由CSDN通过智能技术生成

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)