LambdaQueryWrapper
if(CollectionUtil.isNotEmpty(request.getTreePathList())){
queryWrapper.and(qw->{
List<String> treePathList = request.getTreePathList();
if(treePathList.size() == 1){
qw.likeRight(xxx::getTreePath,treePathList.get(0));
}else {
qw.likeRight(xxx::getTreePath,treePathList.get(0));
for(int i=1;i<treePathList.size();i++){
qw.or().likeRight(xxx::getTreePath,treePathList.get(i));
}
}
});
}
执行结果
==> Preparing: SELECT 。。。 FROM tb_xxx WHERE deleted=0 AND ((tree_path LIKE ? OR tree_path LIKE ?)) ORDER BY create_date DESC
2022-10-19 16:12:27.383 DEBUG 40020 --- [ault-executor-0] c.xxx.W.selectList : ==> Parameters: 000%(String), 000-270-27%(String)
2022-10-19 16:12:27.854 DEBUG 40020 --- [ault-executor-0] c.xxx.W.selectList : <== Total: 11