ibatis in 参数迭代

最新推荐文章于 2022-09-15 14:55:40 发布

小城南

最新推荐文章于 2022-09-15 14:55:40 发布

阅读量289

点赞数

分类专栏： Java mybatis 文章标签： ibatis iterate 集合迭代

本文链接：https://blog.csdn.net/cainiaobulan/article/details/80943200

版权

Java 同时被 2 个专栏收录

53 篇文章 3 订阅

订阅专栏

mybatis

15 篇文章 0 订阅

订阅专栏

查询时候常常用到in,我们就要把集合当做参数传过去：

java写法

String cm_ids = StringUtil.toString(rtjson.get("cm_ids"));
				List<String> cmIdList = Arrays.asList(cm_ids.split(","));
				paramMap.put("cm_ids", cmIdList);

ibatis写法：

<select id="queryCustomerLocation" resultClass="java.util.HashMap" parameterClass="java.util.Map">
    SELECT id,location_a,location_c from bas_cm_customer where 1=1
    <isNotEmpty  property="ids">
        and id in
        <iterate property="ids" conjunction="," close=")" open="(">
            #ids[]#
        </iterate>
    </isNotEmpty> 
    <isNotEmpty property="cm_ids">
        and source_code in
        <iterate property="cm_ids" conjunction="," close=")" open="(">
            #cm_ids[]#
        </iterate>
    </isNotEmpty>
  <isNotEmpty property="cm_codes">
      and code in
      <iterate property="cm_codes" conjunction="," close=")" open="(">
          #cm_codes[]#
      </iterate>
  </isNotEmpty>
  </select>