MybatisPlus中lambda.like作用&分页条件查询

43 阅读 0 评论 29 点赞

我是靠谱客的博主知性电脑，最近开发中收集的这篇文章主要介绍MybatisPlus中lambda.like作用&分页条件查询，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

@Service
@Transactional
public class AdminServiceImpl extends BaseServiceImpl<Admin> implements AdminService {
    @Resource
    private AdminMapper adminMapper;
    @Resource
    private AdminTransfer adminTransfer;

    /**
     * 分页条件查询
     */
    @Override
    public PageResult<AdminVo> searchPage(AdminCriteria adminCriteria) {
        PageHelper.startPage(adminCriteria.getCurrentPage(),adminCriteria.getPageSize());
        LambdaQueryWrapper<Admin> lambda = new QueryWrapper<Admin>().lambda();
        if (!StringUtils.isEmpty(adminCriteria.getAdminName())){
            /*不等于null进行拼接*/
            /*搜索getAdminName值,进行模糊查询*/
            lambda.like(Admin::getAdminName,adminCriteria.getAdminName());
        }
        if (!StringUtils.isEmpty(adminCriteria.getAdminPhone())){
            /*下面就对比是否相等*/
            lambda.eq(Admin::getAdminPhone,adminCriteria.getAdminPhone());
        }
        if (adminCriteria.getDeptId()!=null && adminCriteria.getDeptId()!=0){
            /*判断值是否相等*/
            lambda.eq(Admin::getDeptId,adminCriteria.getDeptId());
        }
        if (!StringUtils.isEmpty(adminCriteria.getStartTime())){
            /*判断是否在这个区间*/
            lambda.between(Admin::getCreateTime,adminCriteria.getStartTime(),adminCriteria.getEndTime());
        }
        /*查询结果*/
        List<Admin> admins = adminMapper.selectList(lambda);
        /*分页查询 */
        PageInfo<Admin> pageInfo = new PageInfo<>(admins);
        /*获取总条数*/
        long total = pageInfo.getTotal();
        /*查询结果转换为Vo输出*/
        List<AdminVo> adminVos = adminTransfer.toVO(admins);
        /*返回分页查询前端数据*/
        return new PageResult<AdminVo>(total, adminVos);
    }
}