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

最新推荐文章于 2024-07-02 02:54:39 发布

一枚小蜗牛H

最新推荐文章于 2024-07-02 02:54:39 发布

阅读量2.1k

点赞数 1

分类专栏： Java驿站文章标签： lambda MybatisPlus

本文链接：https://blog.csdn.net/Ying_ph/article/details/115921340

版权

Java驿站专栏收录该内容

125 篇文章 8 订阅

订阅专栏

@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);
    }
}