updatePlustar.md 3.16 KB

编辑plustar分类接口

接口名: '/guang/plustar/updatePlustar'

方法

POST JSONRAW

入参


属性名称 类型 例子 说明 是否必填 范围
id String 450 plustar ID 1-10
brandId String 30 品牌id 1-10
brandType String 1 频道id 1-1
coverImg String http://img12.static.yhbimg.com/yhb-img01/2016/03/28/08/02a4da74a108380e93a33dc5eb91b42f2f.jpg 封面图 1-85
bannerImg String[] ["http://img12.static.yhbimg.com/yhb-img01/2016/03/28/08/02a4da74a108380e93a33dc5eb91b42f2f.jpg?imageView/2/w/300/h/300"] banner图 -
bannerTitle String 广泛丰厚的 banner标签 0-85
orderBy String 23 排序 0-6
gender String 1 性别 0-1
status String 1 是否可用 0-1

对应SQL的操作库表

  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from brand_relation
    where id = #{id,jdbcType=INTEGER}
  </select>

  <update id="updateByPrimaryKeySelective" parameterType="com.yohobuy.platform.dal.guang.model.BrandRelation" >
    update brand_relation
    <set >
      <if test="brandId != null" >
        brand_id = #{brandId,jdbcType=INTEGER},
      </if>
      <if test="brandType != null" >
        brand_type = #{brandType,jdbcType=TINYINT},
      </if>
      <if test="coverImg != null" >
        cover_img = #{coverImg,jdbcType=VARCHAR},
      </if>
      <if test="bannerTitle != null" >
        banner_title = #{bannerTitle,jdbcType=VARCHAR},
      </if>
      <if test="isRecommend != null" >
        is_recommend = #{isRecommend,jdbcType=TINYINT},
      </if>
      <if test="orderBy != null" >
        order_by = #{orderBy,jdbcType=SMALLINT},
      </if>
      <if test="isDifferent != null" >
        is_different = #{isDifferent,jdbcType=BIT},
      </if>
       <if test="gender != null" >
        gender = #{gender,jdbcType=CHAR},
      </if>
      <if test="status != null" >
        status = #{status,jdbcType=BIT},
      </if>
      <if test="createTime != null" >
        create_time = #{createTime,jdbcType=INTEGER},
      </if>
      <if test="updateTime != null" >
        update_time = #{updateTime,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>

  <delete id="deleteByRelationId" parameterType="java.lang.Integer" >
    delete from brand_img
    where relation_id = #{relationId,jdbcType=INTEGER}
  </delete>

  <insert id="insertBatch" parameterType="java.util.List" >
    insert into brand_img (relation_id, banner_img)
    values
    <foreach collection="list" item="item" separator=",">
        (#{item.relationId}, #{item.bannerImg})
    </foreach>
  </insert>

错误编码


错误码code 消息 说明
400 plustar is null
400 没有找到该品牌关系
500 插入banner图片失败
200 修改成功!
400 修改失败!

返回

{
    "code":200,
    "message":"修改成功!"
}