动态sql if条件拼接时去掉多余逗号避免报错

<update id="updateStock" parameterType="java.util.Map">
        update `t_goods_stock`
        set
        <trim suffixOverrides=",">
        <if test="stockNum !=null and stockNum.size()>0">
            stock_num = #{stockNum},
        </if>
        <if test="stockConsume !=null and stockConsume !=''">
            stock_consume = #{stockConsume},
        </if>
        <if test="alterTime !=null and alterTime != ''">
            alter_time = #{alterTime},
        </if>
        </trim>
        where
        stock_id = #{stockId}
        and stock_valid = "01"
    </update>

使用标签去掉多余逗号

<trim prefixOverrides=","></trim>  //去掉首部多余逗号

<trim suffixOverrides=","></trim> //去掉尾部多余逗号