mysql mybatis 批量更新

void updateCoinDevices(@Param("coinDevices") List<CoinDevice> coinDevices);

    <update id="updateCoinDevices">
        update t_coin_device
        set last_modified_time=current_timestamp
            <trim prefix=",agent_id =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    when id=#{item.id} then #{item.agentId}
                </foreach>
            </trim>
            <trim prefix=",sn_code =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    when id=#{item.id} then #{item.snCode}
                </foreach>
            </trim>
            <trim prefix=",producer =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    when id=#{item.id} then #{item.producer}
                </foreach>
            </trim>
            <trim prefix=",qr_code_url =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    when id=#{item.id} then #{item.qrCodeUrl}
                </foreach>
            </trim>
            <trim prefix=",start_cost =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    when id=#{item.id} then #{item.startCost}
                </foreach>
            </trim>
            <trim prefix=",status =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    when id=#{item.id} then #{item.status}
                </foreach>
            </trim>
            <trim prefix=",last_modified_by =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    when id=#{item.id} then #{item.lastModifiedBy}
                </foreach>
            </trim>
            <trim prefix=",last_modified_by =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    when id=#{item.id} then #{item.createdBy}
                </foreach>
            </trim>
        where id in
        <foreach collection="coinDevices" item="item" separator="," open="(" close=")">
            #{item.id}
        </foreach>
    </update>