通用mapper条件构造

通用mapper条件构造

/*sql*/
select * from User  where busiunitId=#{busiunitId}  and (settleRule like "%split[0]%"  or settleRule like "%split[0]%")

Example example = new Example(SeUnitAttachedConfig.class);
         Example.Criteria criteria = example.createCriteria();
         if (!ObjectUtils.isEmpty(params.getBusiunitIds())) {//结算单元id
             criteria.andIn("busiunitId", params.getBusiunitIds());
         }


 if (!ObjectUtils.isEmpty(params.getSettleRule())) {//1,3 结算规则分类like ("%1%" or settle_rule like "%3%")
             String settleRule = params.getSettleRule();
             String[] split = settleRule.split(",");
             Example.Criteria criteria2 = example.createCriteria();
             for(int i=0;i<split.length;i++){
                 criteria2.orLike("settleRule", "%"+split[i]+"%");
             }
             example.and(criteria2);
         }