getList.md 1.94 KB

查询品牌关注

接口名: /guang/relationship/getList

方法

POST JSONRAW

入参


属性名称 类型 例子 说明 是否必填 长度
brandId Integer 232 品牌ID 0-11

请求示例 http://172.16.6.157:8080/yohobuy-platform-web/guang/relationship/getList?brandId=232

对应SQL的操作库表

    <select id="selectCountByBrandId" resultType="java.lang.Integer" >
        select 
        IFNULL(count(1),0)
        from brand_relationship
        <where>
            <if test="brandId != null">
                brand_id = #{brandId,jdbcType=INTEGER}
            </if>
        </where>
    </select>

    <select id="selectListByBrandId" resultMap="BaseResultMap" >
        select 
        <include refid="Base_Column_List" />
        from brand_relationship
        <where>
            <if test="brandId != null">
                brand_id = #{brandId,jdbcType=INTEGER}
            </if>
        </where>
        order by create_time DESC limit #{offset},#{size}
    </select>

错误编码


错误码code 消息 说明
200 操作成功

返回


    {
        "code": 200,
        "data": [
            {
                "brandId": "1",
                "brandType":"2",
                "brandName":"addicc",
                "activityName":"双11",
                "discount":"3"
            },
            {
                "brandId": "2",
                "brandType":"2",
                "brandName":"addicc",
                "activityName":"双11",
                "discount":"3"
            },
           {
                "brandId": "3",
                "brandType":"2",
                "brandName":"addicc",
                "activityName":"双11",
                "discount":"3"
            }
        ]
    }