记录下foreach的用法

第一种用法

	<update id="updateMessagebyUni">
		UPDATE task set status=2,count=count+1,nextSendTime=NOW() where 1=1
		and
		id in(
		<foreach collection="ids" item="item" separator=",">
			#{item,jdbcType=VARCHAR}
		</foreach>
		)
	</update>

第二种用法

<!-- collection="要遍历的集合" 
item = "可以在元素体内使用的集合项"
index = "索引"
open = "开始字符串"
separator = "分隔符"
close = "结束字符串" -->

<select id="selectUser" resultType="User">
  SELECT * FROM User WHERE ID in
  <foreach item="item" index="index" collection="list"
      open="(" separator="," close=")">
        #{item}
  </foreach>
</select>

第三种用法（批量插入）

	<insert id="insertForeach" parameterType="java.util.List" useGeneratedKeys="false">
    			insert into fund
    			( id,fund_name,fund_code,date_x,data_y,create_by,create_date,update_by,update_date,remarks,del_flag)
    			values
    			<foreach collection="list" item="item" index="index" separator=",">
    				(
    					#{item.id},
    					#{item.fundName},
    					#{item.fundCode},
    					#{item.dateX},
    					#{item.dataY},
    					#{item.createBy},
    					#{item.createDate},
    					#{item.updateBy},
    					#{item.updateDate},
    					#{item.remarks},
    					#{item.delFlag}
    				)
    		     </foreach>		
    </insert>