【MyBaPlus】分页查询，条件查询

最新推荐文章于 2024-06-20 00:00:58 发布

Mr_树先森

最新推荐文章于 2024-06-20 00:00:58 发布

阅读量211

点赞数

分类专栏： MyBatis框架文章标签： Java MyBatis 分页查询条件过滤 PageHelper

本文链接：https://blog.csdn.net/m0_46495243/article/details/119058073

版权

MyBatis框架专栏收录该内容

21 篇文章 2 订阅

订阅专栏

在这里插入图片描述

实现：

@Service

public class TeacherServiceImpl extends ServiceImpl<TeacherMapper, Teacher> implements TeacherService {

    @Override

    public void pageQuery(Page<Teacher> pageParam, TeacherQuery teacherQuery) {

        QueryWrapper<Teacher> queryWrapper = new QueryWrapper<>();

        queryWrapper.orderByAsc("sort");


        if (teacherQuery == null){

            baseMapper.selectPage(pageParam, queryWrapper);

            return;

        }

        String name = teacherQuery.getName();

        Integer level = teacherQuery.getLevel();

        String begin = teacherQuery.getBegin();

        String end = teacherQuery.getEnd();

        if (!StringUtils.isEmpty(name)) {

            queryWrapper.like("name", name);

        }

        if (!StringUtils.isEmpty(level) ) {

            queryWrapper.eq("level", level);

        }

        if (!StringUtils.isEmpty(begin)) {

            queryWrapper.ge("gmt_create", begin);

        }

        if (!StringUtils.isEmpty(end)) {

            queryWrapper.le("gmt_create", end);

        }

        baseMapper.selectPage(pageParam, queryWrapper);

    }

}