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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
@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);
    }
}