//mybaitis构造条件查询器
QueryWrapper<SysDept> sysDeptQueryWrapper = new QueryWrapper<>();
if (StrUtil.isNotEmpty(sysDeptAll.getRoot())) {
sysDeptQueryWrapper.like("oid_path", "/" + sysDeptAll.getRoot() + "/");
} else if (SecurityUtils.getUser() != null && SecurityUtils.getUser().getDeptId() != null ){
sysDeptQueryWrapper.like("oid_path", "/" + SecurityUtils.getUser().getDeptId() + "/");
}
if (StrUtil.isNotEmpty(sysDeptAll.getType())) {
sysDeptQueryWrapper.eq("type", sysDeptAll.getType());
}
if (StrUtil.isNotEmpty(sysDeptAll.getKeyword())) {
sysDeptQueryWrapper.like("name", sysDeptAll.getKeyword());
}
sysDeptQueryWrapper.orderByAsc("sort");
return deptMapper.selectList(sysDeptQueryWrapper)
mybatis构造条件查询
于 2022-04-22 14:56:17 首次发布