mybatis 传入多个参数

List<BoReview> check(@Param("flows") String[] flows, @Param("id") long id);
<select id="check" resultMap="BaseResultMap" >
  select * from
      (
          select
            <include refid="Base_Column_List" />
          from abc
          where 1=2
          <foreach item="item" index="index" collection="flows" >
            or FIELD_VALUE like '%'||#{item}||'%'
          </foreach>
      )
  WHERE ID != #{id} 
</select>

 

posted @ 2018-10-19 14:02  扶不起的刘阿斗  阅读(94)  评论(0编辑  收藏  举报