Mybatils之foreach标签

查询

<select id="querySamplesGroupByShopIdByIds" parameterType="java.util.List" resultMap="BaseDomainMap">
        SELECT 
        GROUP_CONCAT(sc.ID) as Value,
        sa.ShopId as KeyId
        FROM shoppingcart sc 
        LEFT JOIN sample sa on sa.ID=sc.SampleId
        LEFT JOIN shop sh on sh.ID=sa.ShopId
        WHERE sc.ID in 
        <foreach collection="list" item="item" open="(" close=")" separator=",">
            #{item}
        </foreach>
        GROUP BY sa.ShopId
    </select>  

批量插入表数据

<insert id="batchInsertFavorite" parameterType="java.util.List" useGeneratedKeys="true" keyProperty="ID">
        insert into favorite (
        UserId, 
        TargetId, 
        Type, 
        Status, 
        CreateTime, 
        ModifyTime
        ) values <foreach collection="list" item="item" separator=",">
            (#{item.UserId},#{item.TargetId},#{item.Type},0,now(),now())
        </foreach>
        <selectKey resultType="int" order="AFTER" keyProperty="ID">
            select LAST_INSERT_ID() as ID
        </selectKey>
    </insert>

生成uuid

<insert id="batchInsertDraftSamplePropertyDetail" parameterType="java.util.List">
         <selectKey resultType="java.lang.String" order="BEFORE" keyProperty="ID"> 
            SELECT uuid()
        </selectKey>
        insert into samplepropertydetail_sync_draft (
               ID,
            SampleId,
            ProName,
            ProValue,
            Ordering,
            Status,
            CreateTime,
            ModifyTime
        ) values <foreach collection="list" item="item" separator=",">
            (UUID(),#{item.SampleId},#{item.ProName},#{item.ProValue},#{item.Ordering},0,now(),now())
        </foreach>
    </insert>