mybatis批量插入和批量更新

 

批量插入

<insert id="batchInsertList" parameterType="java.util.List">
             INSERT INTO t_client_device_list
             ( order_no, mac_id,client_code,son_client_code,status,order_time)
             values
        <foreach collection="list" item="item" index="index" separator=",">
                ( #{item.orderNo, jdbcType=VARCHAR},
                #{item.macId, jdbcType=VARCHAR},
                #{item.clientCode, jdbcType=VARCHAR},
                #{item.sonClientCode, jdbcType=VARCHAR},
                'Y',
                now() )
        </foreach>
</insert>

批量更新
<update id="batchUpdateList" parameterType="java.util.List">
        update t_client_device_list set
        client_code =
        <foreach collection="list" item="item" index="index" separator=" " open="case mac_id" close="end">
            when #{item.macId} then #{item.clientCode}
        </foreach>
        ,son_client_code =
        <foreach collection="list" item="item" index="index" separator=" " open="case mac_id" close="end">
            when #{item.macId} then #{item.sonClientCode}
        </foreach>        
        where mac_id in
        <foreach collection="list" item="item" index="index" separator="," open="(" close=")">
            #{item.macId,jdbcType=VARCHAR}
        </foreach>
 </update>