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();
mybatis-plus 动态where条件
最新推荐文章于 2024-08-06 17:28:45 发布