<update id="updateDataKetState">

        update ${tablespace}.IDEA_DATAKEY_STATE

        <trim prefix="set" suffixOverrides=",">

            <trim prefix="STATENAME = case" suffix="end,">

                <foreach collection="datas"  item="data" >

                <if test="data.stateName !=null and data.stateName !=''">

                    when UUID=#{data.uuid} then #{data.stateName}

                </if>

                </foreach>

            </trim>

            <trim prefix="STATEINFO = case" suffix="end,">

                <foreach collection="datas"  item="data" >

                <if test="data.stateInfo !=null">

                    when UUID=#{data.uuid} then #{data.stateInfo}

                </if>

                </foreach>

            </trim>

            <trim prefix="STATENO = case" suffix="end,">

                <foreach collection="datas"  item="data" >

                <if test="data.stateNo !=null and data.stateNo !=''">

                    when UUID=#{data.uuid} then #{data.stateNo}

                </if>

                </foreach>

            </trim>

        </trim>

        where UUID in

        <foreach collection="datas" item="data" open="(" close=")" separator=",">

                #{data.uuid}

        </foreach>

    </update>