<if test="skuList != null and skuList.length > 1">
and
<foreach collection="skuList" item="sku" index="index" open="(" close=")" separator="or">
t.sku LIKE concat('%',#{sku},'%')
</foreach>
</if>
关键地方标注了,没什么特别的。先支持批量,然后循环里边模糊,注意分隔符用or
<if test="skuList != null and skuList.length > 1">
and
<foreach collection="skuList" item="sku" index="index" open="(" close=")" separator="or">
t.sku LIKE concat('%',#{sku},'%')
</foreach>
</if>
关键地方标注了,没什么特别的。先支持批量,然后循环里边模糊,注意分隔符用or