mybatis foreach

 

参考： 

http://www.mybatis.org/mybatis-3/zh/dynamic-sql.html

https://www.jianshu.com/p/a45908678a52

 

<select id="selectPostIn" resultType="domain.blog.Post">
  SELECT *
  FROM POST P
  <if test="list != null and list.size != 0">
      WHERE ID in
      <foreach item="item" index="index" collection="list" open="(" separator="," close=")">
            #{item}
      </foreach>
    </if>
</select>

 

<insert id="batchInsert" useGeneratedKeys="true" keyProperty="id">  
    insert into  
    tb_hello(  
    id, `type`,name, description, job_config  
    ) values  
    <foreach item="item" collection="list" separator=",">  
        (#{item.id}, #{item.type},#{item.name}, #{item.description})  
    </foreach>  
</insert>