mybatis-plus 动态where条件

QueryWrapper wrapper = new QueryWrapper();
wrapper.eq(“sbh”,sbh);
//SQL效果 where sbh=? and (spmc like ? and spbm like ? and spbm like ?)
if (!StrUtil.isEmpty(spbm)){
wrapper.and(wr-> wr.like(“spbm”, spbm));
}
if (!StrUtil.isEmpty(spmc)){
wrapper.and(wr-> wr.like(“spmc”, spmc));
}
if (!StrUtil.isEmpty(spbm)){
wrapper.and(wr-> wr.like(“spbm”, spbm));
}
wrapper.orderByDesc(“mrkpsp”);//把默认商品调整为结果集首行
Page page = new Page<>(pageIndex, pageSize);
IPage iPage = iXtDmSpbmService.page(page,wrapper);
List list =iPage.getRecords();