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">
                    <if test="item.agentId!=null and item.id!=null">
                        when id=#{item.id} then #{item.agentId}
                    </if>
                </foreach>
            </trim>
            <trim prefix=",sn_code =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    <if test="item.snCode!=null and item.id!=null">
                        when id=#{item.id} then #{item.snCode}
                    </if>
                </foreach>
            </trim>
            <trim prefix=",producer =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    <if test="item.producer!=null and item.id!=null">
                        when id=#{item.id} then #{item.producer}
                    </if>
                </foreach>
            </trim>
            <trim prefix=",qr_code_url =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    <if test="item.qrCodeUrl!=null and item.id!=null">
                        when id=#{item.id} then #{item.qrCodeUrl}
                    </if>
                </foreach>
            </trim>
            <trim prefix=",start_cost =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    <if test="item.startCost!=null and item.id!=null">
                        when id=#{item.id} then #{item.startCost}
                    </if>
                </foreach>
            </trim>
            <trim prefix=",status =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    <if test="item.status!=null and item.id!=null">
                        when id=#{item.id} then #{item.status}
                    </if>
                </foreach>
            </trim>
            <trim prefix=",last_modified_by =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    <if test="item.lastModifiedBy!=null and item.id!=null">
                        when id=#{item.id} then #{item.lastModifiedBy}
                    </if>
                </foreach>
            </trim>
            <trim prefix=",last_modified_by =case" suffix="end">
                <foreach collection="coinDevices" item="item" index="index">
                    <if test="item.createdBy!=null and item.id!=null">
                        when id=#{item.id} then #{item.createdBy}
                    </if>
                </foreach>
            </trim>
        where id in
        <foreach collection="coinDevices" item="item" separator="," open="(" close=")">
            #{item.id}
        </foreach>
    </update>