update  pf_product_audio_t
        <trim prefix="set" suffixOverrides=",">
            <if test="title != null">title=#{title},</if>
            <if test="sort != null">sort=#{sort},</if>
            <if test="audio != null">audio=#{audio},</if>
            <if test="prodId != null">prod_id=#{prodId},</if>    
            <if test="prodName != null">prod_name=#{prodName},</if>    
            <if test="isDel != null">is_del=#{isDel},</if>    
            <if test="isAdopt != null">is_adopt=#{isAdopt},</if>
            <if test="createTime != null">create_time=#{createTime},</if>
            <if test="createUser != null">create_user=#{createUser},</if>
            <if test="modifyTime != null">modify_time=#{modifyTime},</if>
            <if test="modifyUser != null">modify_user=#{modifyUser},</if>
        </trim>
        <where>
            id = #{id}
        </where>

 

posted on 2017-10-13 14:46  十七年蝉  阅读(2731)  评论(0编辑  收藏  举报