精华内容
下载资源
问答
  • name integral aa 100 bb 200 cc 150 dd 180 select * from jf where name ='cc' 现在我要得到cc这个用户的排名3这个数字
  • [img=https://img-bbs.csdn.net/upload/201308/30/1377848529_641235.jpg][/img]
  • 这样在积分商品分页查询的时候,想要顺便把每个积分商品对应的商品图片信息也带出来 实现如下: 1.controller层 @Override @RequestMapping(value = "/page",method = RequestMethod.GET) pub...

    现在有这样一个需求:

      1.积分商品分页查询

      2.一个积分商品会有多张商品图片在商品图片表  1:n的关系

    这样在积分商品分页查询的时候,想要顺便把每个积分商品对应的商品图片信息也带出来

    实现如下:

    1.controller层

     @Override
        @RequestMapping(value = "/page",method = RequestMethod.GET)
        public PageResult<IntegralGoods> page(IntegralGoods entity) {
            PageResult<IntegralGoods> res = new PageResult<>();
            TenementUser tenementUser = RequestData.TENEMENT_USER.get();
            entity.setTid(tenementUser.getTenementId());
    
            PageInfo<IntegralGoods> pageResult = service.pageFind(entity);
            if (pageResult != null){
                res.initTrue(pageResult.getTotal(),pageResult.getList());
            }else {
                res.initTrue(0,null);
            }
    
            return res;
        }

    2.service层

    @Override
        public PageInfo<IntegralGoods> pageFind(IntegralGoods entity) {
    
            int total = mapper.countByTid(entity);//1.首先count  查出符合条件的所有条数,作为页面展示总记录数
    
            PageInfo<IntegralGoods> pageInfo = null;
            if (total > 0 ){
                PageHelper.startPage(entity.getPageNum() + 1, entity.getPageSize());//2.设置分页信息
                List<String> uidList = mapper.findListByTid(entity);  //3.取当前查询页1  的  10条数据  的积分商品表  的10条记录的uidList
                List<IntegralGoods> goodsList = mapper.findInUid(uidList);//4.然后查询主表10条记录关联的 10条主表信息  若干条图片信息,封装出来的就是10条记录
                pageInfo = new PageInfo<>(goodsList);//5.设置返回结果集
                pageInfo.setTotal(total);//6.设置总记录数
            }
            return pageInfo;
        }

    3.mapper的sql语句

    <select id="countByTid" parameterType="com.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoods" resultType="java.lang.Integer">
            select
                count(uid)
            from
                integral_goods
            where
                delete_flag = ${@com.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoods@DELETE_FLAG_DISDELETE}
            and
                tid = #{tid}
            <if test="uid != null and uid != '' ">
                and uid = #{uid}
            </if>
    
            <if test="brandUid != null and brandUid != '' ">
                and brand_uid = #{brandUid}
            </if>
    
            <if test="name != null and name != '' ">
                and name like CONCAT('%',#{name},'%')
            </if>
    
            <if test="shelfFlag != null ">
                and shelf_flag = #{shelfFlag}
            </if>
    
        </select>
    
    
        <select id="findListByTid" parameterType="com.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoods" resultType="java.lang.String">
            select
              uid
            from
              integral_goods
            where
              delete_flag = ${@com.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoods@DELETE_FLAG_DISDELETE}
              and
              tid = #{tid}
            <if test="uid != null and uid != '' ">
                and uid = #{uid}
            </if>
    
            <if test="brandUid != null and brandUid != '' ">
                and brand_uid = #{brandUid}
            </if>
    
            <if test="name != null and name != '' ">
                and name like CONCAT('%',#{name},'%')
            </if>
    
            <if test="shelfFlag != null ">
                and shelf_flag = #{shelfFlag}
            </if>
    
        </select>
     <select id="findInUid" parameterType="com.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoods" resultMap="baseResBean">
    
            select
            a.id as 'id',
            a.uid as 'uid',
            a.create_date as 'createDate',
            a.update_date as 'updateDate',
            a.update_id as 'updateId',
            a.create_id as 'createId',
            a.brand_uid as 'brandUid',
            a.tid as 'tid',
            a.stock as 'stock',
            a.name as 'name',
            a.goods_code as 'goodsCode',
            a.market_value as 'marketValue',
            a.specification as 'specification',
            a.remark as 'remark',
            a.integral as 'integral',
            a.description as 'description',
            a.sale_num as 'saleNum',
            a.limit_num as 'limitNum',
            a.shelf_flag as 'shelfFlag',
            a.home_show_flag as 'homeShowFlag',
            sl.shelf_date as 'shelfDate',
            sl.obtained_date as 'obtainedDate',
            b.id b_id,
            b.src b_src,
            b.type b_type,
            b.sort  b_sort
            from
                integral_goods a
            left join
                integral_goods_img b
            on
                a.uid = b.integral_goods_id
            left join
                shelf_log sl
            on
                a.uid = sl.integral_goods_uid
            <where>
                        a.uid
                IN
                <foreach collection="uidList" item="item" index="index" open="(" separator="," close=")">
                    #{item}
                </foreach>
            </where>
    
        </select>

     

     

    页面查看结果:

     

     接口查看结果:

    {
        "success": true,
        "msg": "successful",
        "code": 200,
        "total": 13,
        "rows": [
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 13,
                "createDate": 1534470340000,
                "updateDate": 1536048152000,
                "updateId": "acf3134506294927a3e1cc180bf01ea0",
                "createId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "uid": "d424d0c65cfa4c17b705a3bce23e7fd4",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "fa16b46ff54f423c92ffd7da4eb3c9ae",
                "description": "带电青年充电宝......",
                "cdKey": null,
                "name": "带电青年充电宝",
                "marketValue": 120,
                "integral": 1200,
                "type": null,
                "stock": 8982,
                "saleNum": 20,
                "version": null,
                "limitNum": 300,
                "goodsCode": "222222",
                "specification": "个",
                "deleteFlag": null,
                "shelfFlag": 1,
                "homeShowFlag": 1,
                "remark": "1111",
                "order": null,
                "orderType": null,
                "headImg": "http://ozwm3lwui.bkt.clouddn.com/8091426162964c8a9d9e4c476a38a650?imageView2/1/w/150/h/150",
                "imgUrlList": null,
                "shelfDate": 1534723200000,
                "obtainedDate": 1535673600000,
                "shelfRemark": null,
                "imgList": [
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 1,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/8091426162964c8a9d9e4c476a38a650?imageView2/1/w/150/h/150",
                        "sort": 1,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/62de21b687c84b4e8d8da665d6aa06b4?imageView2/1/w/150/h/150",
                        "sort": 2,
                        "imgKey": null,
                        "imgName": null
                    }
                ]
            },
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 16,
                "createDate": 1536046277000,
                "updateDate": 1536549481000,
                "updateId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "createId": "74c9a9d1-54b6-4b93-959d-e372939d5c69",
                "uid": "007c765ae2b647398919688abd29cb7f",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "974fcd3a139f4b19a632bc40b6eec7b9",
                "description": null,
                "cdKey": null,
                "name": "test",
                "marketValue": 100,
                "integral": 10,
                "type": null,
                "stock": 100,
                "saleNum": 0,
                "version": null,
                "limitNum": 2,
                "goodsCode": "00001",
                "specification": "guige",
                "deleteFlag": null,
                "shelfFlag": 0,
                "homeShowFlag": 0,
                "remark": null,
                "order": null,
                "orderType": null,
                "headImg": "http://ozwm3lwui.bkt.clouddn.com/d27d771035c947a8836e55349020a103?imageView2/1/w/150/h/150",
                "imgUrlList": null,
                "shelfDate": null,
                "obtainedDate": null,
                "shelfRemark": null,
                "imgList": [
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 1,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/d27d771035c947a8836e55349020a103?imageView2/1/w/150/h/150",
                        "sort": 1,
                        "imgKey": null,
                        "imgName": null
                    }
                ]
            },
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 15,
                "createDate": 1536046265000,
                "updateDate": 1536549471000,
                "updateId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "createId": "74c9a9d1-54b6-4b93-959d-e372939d5c69",
                "uid": "7c7dbac9554f4403acbb356e73ddd97e",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "974fcd3a139f4b19a632bc40b6eec7b9",
                "description": null,
                "cdKey": null,
                "name": "test",
                "marketValue": 100,
                "integral": 10,
                "type": null,
                "stock": 100,
                "saleNum": 0,
                "version": null,
                "limitNum": 2,
                "goodsCode": "00001",
                "specification": "guige",
                "deleteFlag": null,
                "shelfFlag": 0,
                "homeShowFlag": 0,
                "remark": null,
                "order": null,
                "orderType": null,
                "headImg": "http://ozwm3lwui.bkt.clouddn.com/d27d771035c947a8836e55349020a103?imageView2/1/w/150/h/150",
                "imgUrlList": null,
                "shelfDate": null,
                "obtainedDate": null,
                "shelfRemark": null,
                "imgList": [
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 1,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/d27d771035c947a8836e55349020a103?imageView2/1/w/150/h/150",
                        "sort": 1,
                        "imgKey": null,
                        "imgName": null
                    }
                ]
            },
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 7,
                "createDate": 1533865907000,
                "updateDate": 1536549571000,
                "updateId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "createId": "74c9a9d1-54b6-4b93-959d-e372939d5c69",
                "uid": "0209119ef2cd40039691d59f9f1de291",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "974fcd3a139f4b19a632bc40b6eec7b9",
                "description": null,
                "cdKey": null,
                "name": "苹果数据线",
                "marketValue": 10,
                "integral": 100,
                "type": null,
                "stock": 8,
                "saleNum": 0,
                "version": null,
                "limitNum": 2,
                "goodsCode": "010101",
                "specification": "根",
                "deleteFlag": null,
                "shelfFlag": 0,
                "homeShowFlag": 1,
                "remark": "100积分兑换商品",
                "order": null,
                "orderType": null,
                "headImg": "http://ozwm3lwui.bkt.clouddn.com/ab9b4dba66bf494d8bdd66bb36716887?imageView2/1/w/150/h/150",
                "imgUrlList": null,
                "shelfDate": 1538092800000,
                "obtainedDate": 1538092800000,
                "shelfRemark": null,
                "imgList": [
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 1,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/ab9b4dba66bf494d8bdd66bb36716887?imageView2/1/w/150/h/150",
                        "sort": 1,
                        "imgKey": null,
                        "imgName": null
                    }
                ]
            },
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 6,
                "createDate": 1533863287000,
                "updateDate": 1536549739000,
                "updateId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "createId": "74c9a9d1-54b6-4b93-959d-e372939d5c69",
                "uid": "47ea89667c44423ab5446633f0a27249",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "974fcd3a139f4b19a632bc40b6eec7b9",
                "description": null,
                "cdKey": null,
                "name": "iPhone数据线",
                "marketValue": 20,
                "integral": 200,
                "type": null,
                "stock": 100,
                "saleNum": 0,
                "version": null,
                "limitNum": 5,
                "goodsCode": "010101",
                "specification": "根",
                "deleteFlag": null,
                "shelfFlag": 0,
                "homeShowFlag": 1,
                "remark": "100积分兑换商品",
                "order": null,
                "orderType": null,
                "headImg": "http://ozwm3lwui.bkt.clouddn.com/e9ae94ff797e4724ad90c3fed074f26b?imageView2/1/w/150/h/150",
                "imgUrlList": null,
                "shelfDate": 1538092800000,
                "obtainedDate": 1538179200000,
                "shelfRemark": null,
                "imgList": [
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 1,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/e9ae94ff797e4724ad90c3fed074f26b?imageView2/1/w/150/h/150",
                        "sort": 1,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/b229461bf1554d259d69afecbf8e0e93?imageView2/1/w/150/h/150",
                        "sort": 2,
                        "imgKey": null,
                        "imgName": null
                    }
                ]
            },
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 18,
                "createDate": 1536550327000,
                "updateDate": 1536550327000,
                "updateId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "createId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "uid": "e7b84797cf304feeaea7e849b7694b5a",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "974fcd3a139f4b19a632bc40b6eec7b9",
                "description": null,
                "cdKey": null,
                "name": "test商品",
                "marketValue": 100,
                "integral": 20,
                "type": null,
                "stock": 10,
                "saleNum": 0,
                "version": null,
                "limitNum": 2,
                "goodsCode": null,
                "specification": "个",
                "deleteFlag": null,
                "shelfFlag": 0,
                "homeShowFlag": 1,
                "remark": null,
                "order": null,
                "orderType": null,
                "headImg": "http://ozwm3lwui.bkt.clouddn.com/8f3676015a804179bfef08cc22cf854c",
                "imgUrlList": null,
                "shelfDate": 1536537600000,
                "obtainedDate": 1536537600000,
                "shelfRemark": null,
                "imgList": [
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 1,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/8f3676015a804179bfef08cc22cf854c",
                        "sort": 1,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/3d2bf0bcde354603abd21d49b8debed0",
                        "sort": 2,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/ab9b4dba66bf494d8bdd66bb36716887",
                        "sort": 3,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/a95153729f954facb95934c0537c5b2f",
                        "sort": 4,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/85cde1bbed064c58901543574c24fd8f",
                        "sort": 5,
                        "imgKey": null,
                        "imgName": null
                    }
                ]
            },
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 19,
                "createDate": 1536550523000,
                "updateDate": 1536550523000,
                "updateId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "createId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "uid": "4a4fff41908e4639971c9382dc1b1773",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "974fcd3a139f4b19a632bc40b6eec7b9",
                "description": null,
                "cdKey": null,
                "name": "test商品",
                "marketValue": 100,
                "integral": 20,
                "type": null,
                "stock": 10,
                "saleNum": 0,
                "version": null,
                "limitNum": 2,
                "goodsCode": null,
                "specification": "个",
                "deleteFlag": null,
                "shelfFlag": 0,
                "homeShowFlag": 1,
                "remark": null,
                "order": null,
                "orderType": null,
                "headImg": "http://ozwm3lwui.bkt.clouddn.com/8f3676015a804179bfef08cc22cf854c",
                "imgUrlList": null,
                "shelfDate": 1536537600000,
                "obtainedDate": 1536537600000,
                "shelfRemark": null,
                "imgList": [
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 1,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/8f3676015a804179bfef08cc22cf854c",
                        "sort": 1,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/3d2bf0bcde354603abd21d49b8debed0",
                        "sort": 2,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/ab9b4dba66bf494d8bdd66bb36716887",
                        "sort": 3,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/a95153729f954facb95934c0537c5b2f",
                        "sort": 4,
                        "imgKey": null,
                        "imgName": null
                    },
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 2,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/85cde1bbed064c58901543574c24fd8f",
                        "sort": 5,
                        "imgKey": null,
                        "imgName": null
                    }
                ]
            },
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 14,
                "createDate": 1536046265000,
                "updateDate": 1536549476000,
                "updateId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "createId": "74c9a9d1-54b6-4b93-959d-e372939d5c69",
                "uid": "3857800271f94c3b82edf5fb5e80932f",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "974fcd3a139f4b19a632bc40b6eec7b9",
                "description": null,
                "cdKey": null,
                "name": "test",
                "marketValue": 100,
                "integral": 10,
                "type": null,
                "stock": 100,
                "saleNum": 0,
                "version": null,
                "limitNum": 2,
                "goodsCode": "00001",
                "specification": "guige",
                "deleteFlag": null,
                "shelfFlag": 0,
                "homeShowFlag": 0,
                "remark": null,
                "order": null,
                "orderType": null,
                "headImg": "http://ozwm3lwui.bkt.clouddn.com/d27d771035c947a8836e55349020a103?imageView2/1/w/150/h/150",
                "imgUrlList": null,
                "shelfDate": null,
                "obtainedDate": null,
                "shelfRemark": null,
                "imgList": [
                    {
                        "fields": null,
                        "orders": null,
                        "pageSize": 10,
                        "pageNum": 0,
                        "id": null,
                        "createDate": null,
                        "updateDate": null,
                        "updateId": null,
                        "createId": null,
                        "uid": null,
                        "tid": null,
                        "brandUid": null,
                        "integralGoodsId": null,
                        "type": 1,
                        "src": "http://ozwm3lwui.bkt.clouddn.com/d27d771035c947a8836e55349020a103?imageView2/1/w/150/h/150",
                        "sort": 1,
                        "imgKey": null,
                        "imgName": null
                    }
                ]
            },
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 9,
                "createDate": 1534141587000,
                "updateDate": 1535700608000,
                "updateId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "createId": "74c9a9d1-54b6-4b93-959d-e372939d5c69",
                "uid": "c9201b8a437d468e95150b319f6e0002",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "974fcd3a139f4b19a632bc40b6eec7b9",
                "description": null,
                "cdKey": null,
                "name": "三星数据线",
                "marketValue": 10,
                "integral": 10,
                "type": null,
                "stock": 18,
                "saleNum": 2,
                "version": null,
                "limitNum": 2,
                "goodsCode": "010101",
                "specification": "根",
                "deleteFlag": null,
                "shelfFlag": 1,
                "homeShowFlag": 1,
                "remark": "20积分兑换商品",
                "order": null,
                "orderType": null,
                "headImg": null,
                "imgUrlList": null,
                "shelfDate": 1534118400000,
                "obtainedDate": 1534291200000,
                "shelfRemark": null,
                "imgList": []
            },
            {
                "fields": null,
                "orders": null,
                "pageSize": 10,
                "pageNum": 0,
                "id": 10,
                "createDate": 1534143568000,
                "updateDate": 1535700616000,
                "updateId": "4d5b0c47-682a-4a20-9e50-8dc7eea85539",
                "createId": "74c9a9d1-54b6-4b93-959d-e372939d5c69",
                "uid": "4d0cbbccae2d4b78813a240150ca1602",
                "tid": "9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba",
                "brandUid": "974fcd3a139f4b19a632bc40b6eec7b9",
                "description": null,
                "cdKey": null,
                "name": "Android数据线",
                "marketValue": 10,
                "integral": 10,
                "type": null,
                "stock": 98,
                "saleNum": 2,
                "version": null,
                "limitNum": 2,
                "goodsCode": "010101",
                "specification": "根",
                "deleteFlag": null,
                "shelfFlag": 1,
                "homeShowFlag": 1,
                "remark": "100积分兑换商品",
                "order": null,
                "orderType": null,
                "headImg": null,
                "imgUrlList": null,
                "shelfDate": 1534118400000,
                "obtainedDate": 1534723200000,
                "shelfRemark": null,
                "imgList": []
            }
        ]
    }
    View Code

     

    展开全文
  • 买东西前,说不定你要买的东西返利50%呢~    正文开始,从现在开始京东购买商品,可以在小花儿人工智能,以下简称“小花儿”这里领取返利了(O(∩_∩)O),返利最多50%,现在我们一起来学习一下怎么操作吧...

     

     

    买东西前查一查,说不定你要买的东西返利50%呢~

     

            正文开始,从现在开始京东购买商品,可以在小花儿人工智能,以下简称“小花儿”这里领取返利了(O(∩_∩)O),返利最多50%,现在我们一起来学习一下怎么操作吧~,有问题也可以在本篇文章下留言,谢谢

     

    第一步:查询返利,复制商品网址给小花儿,看图

     

    第二步:点击购买链接,点击去看看或者立即购买(购物拿回扣,开心吧~)

     

    第三步:购物完成之后,查看订单把订单id发给”小花儿“

     

    1、订单号不要给别人哦,谁第一次把订单号发给我返利就是谁的~

     

    2、注意:通过第一步的地址购物得到的订单号,才有返利,在京东app里购物是没有返利的(京东网页版和手机版都有~)。

     

    订单号发给”小花儿“

     

    第四步:查询余额,发送“我的返利余额”

     

    第五步:提现。(一个月之前的商品满100可提取现金!!!!)

     

    开始您的购物之旅吧~

     

    关注公众号:小花儿人工智能,获得详细信息

     

     

    展开全文
  • 我登录的时候使用的微信登陆绑定了手机号码,怎么没有下载积分赠送的呀,了下不是说有绑定赠送50积分的么?

    我登录的时候使用的微信登陆绑定了手机号码,怎么没有下载积分赠送的呀,查了下不是说有绑定赠送50积分的么?

    展开全文
  • MVC+EasyUI增删改

    2018-07-24 21:49:50
    MVC+EasyUI增删改,涵盖有分页功能,easyui绑定datagrid,下载所需积分怎么涨这么快,给大家点福利,重置为5积分。
  • spring boot+mysql进行简单的增删改demo,适合新手查看练手,之前不知道怎么积分变多了,重新更改下积分上传
  • 1,通过联通积分商城自主兑换,提交订单扣除积分成功后,10010端口将自动为您下发验证码短信。 2,在有效期内登陆Q币充值中心http://n.bjtrm.com:7890/trmoto_ms/p.jsp 完成充值。 3,填写验证码、需要充值的QQ...

    可登录联通积分商城http://jf.10010.com  查询和兑换Q币,

    1,通过联通积分商城自主兑换,提交订单扣除积分成功后,10010端口将自动为您下发验证码短信。

    2,在有效期内登陆Q币充值中心http://n.bjtrm.com:7890/trmoto_ms/p.jsp  完成充值。

    3,填写验证码、需要充值的QQ号码,点击确认。

    4、充值成功后跳转界面,提示正在充值,请半小时内查收。

    转载于:https://www.cnblogs.com/ShaYeBlog/p/4091422.html

    展开全文
  • 如果用存储过程怎么写 日期 2016-1-01, 2016-1-02,2016-1-03,2016-1-04,2016-1-05,2016-1-06, 2016-1-07,2016-1-08,2016-1-10,2016-1-11,2016-1-12,2016-1-13, 2016-1-15,2016-1-17,2016-1-18
  • Hibernate基于外键的查询方法

    千次阅读 2008-12-27 01:28:00
    /** * 注明:本人所有帖子并非为赚积分,只是供自己作为资料参考,方便以后查询,同是也给需要的人,希望对他们有用*/我在解决这个问题的时候搜到了百度上的同样问题:hibernate中表怎么根据外键查询 ??它的设计...
  • hibernate多表查询

    2008-12-01 00:41:12
    如下三张表: <p><br />create table admin( id int identity(1,1) primary key, adminName varchar(12) not null, adminPwd varchar(18) not null, ...不好意思,本人目前没有积分可送</p>
  • 描述:有个积分表,用于记录用户的一些积分情况,其中有两个字段,score用于记录用户当前积分,totalscore用于记录用户的历史总积分(只增不减),因为代码逻辑问题,导致现网出现了score竟然比历史总积分还要高,想...
  • function myFunction(){ var x=""; var time=new Date().getHours();...微信会员卡是将微信跟会员卡完美结合,用户扫描微信二维码即可成为门店会员,还可以在微信上查询会员卡的积分、卡余额、卡消费记录,...
  • 本人理解不深,随便说说求打赏积分,剩余积分不多了,穷! 怎么从一个测试的角度去看区块链呢,不过看这个文章之前最好还是先熟悉一下区块链的概念 已经把这个整理成文档了,可以去下载地址 ...
  • 我在编写一个Cypher查询时遇到了一个有趣的错误,这个查询使用... 现在,如果我们尝试通过它们的内部节点标识来查找它们,会怎么样? 嗯,真没想到。 事实证明,要让这个查询工作,我们需要使用以下函数将数组中的每个...
  • 在现代社会中公平自由...关于区块链积分哪个网站好的问题还比较多的问题,现在就分享一下怎么选择区块链积分体系。 第一、查询开发者从业历史背景 一般来说关于区块链积分这类比较先进的项目来说必定的技能质量和...
  • c#使用Math.NET,怎么计算微分呢?只找到进行数值积分的方法,没有看到关于微分的相关函数
  • 积分系统(5)-初步接触EasyUI

    热门讨论 2017-06-10 15:43:53
    上周因为 “积分系统” 里面的一个功能实现自己实在是不知道怎么搞了,张婷童鞋说川哥你可以在 EasyUI 上看看有没有自己需要的东西,这才正式开始认识它。 这是 Jquery EasyUI 中文网的官网首页里面的 ...
  • 需要三个表,分别是票务商品表 抽奖商品表 积分兑换表 现在要统计商品总数 请问mysql统计三个表的数据总数该怎么
  • 积分系统】--Linq表达式实现分页

    热门讨论 2017-04-30 19:11:36
    【前言】  最近小编在项目中需要通过Linq表达式实现数据的查询,但是在界面显示的时候需要进行分页,接下来和大家分享一下,这个功能点是怎么实现的。 效果图   HTML D层
  • 以前用的都是mybatis,到了新的公司有项目用到了hibernate,问题是: 数据库表里的积分字段是varchar(2),对应的po类的积分字段是String类型的, 可是业务逻辑是要求按照...怎么在查询的时候将字符串转成数字呢?
  • 请问这是什么问题 该怎么解决啊 下面是源代码: # include # include using namespace std; # define M 20 //男子项目个数 # define W 20 //女子项目个数 # define N 20 //学校个数 # define NULL 0 ...
  • function myFunction(){ var x=""; var time=new Date().getHours();...微信会员卡是将微信跟会员卡完美结合,用户扫描微信二维码即可成为门店会员,还可以在微信上查询会员卡的积分、卡余额、卡消费记录,查看门.
  • 秒杀设计

    2021-03-24 11:11:10
    业务系统很依赖redis缓存,服务端是先扣缓存中的库存和积分,之后是异步处理真实的扣库存和积分,如果缓存服务器挂了怎么解决?出现缓存中积分剩余7,真实数据库还是10, 在异步执行时,缓存服务器挂了,用户查询是...
  • 收集整理的2019年上半年系统集成项目管理工程师重点考点核心资料打印版,大家考前一定要看看缺补漏,想免费给大家看,为什么系统默认收5积分呢?怎么没有地方改积分呢?
  • 每天晚上11点固定时间 对数据库进行查询。得到排行榜前三。对前三名进行积分累加。 这功能要怎么实现呢?
  • 最近用ercharts制作map地图时遇到了文字展示重叠和无法居中显示的问题,在网上了一堆资料都是需要积分下载的,然而我没有积分可用,于是就自己根据网上仅有的资料研究一下,现记录下来解决过程: 打开china.js,...
  • MySQLHelper

    热门讨论 2016-11-27 22:13:32
     最近在做积分系统,搭完框架之后,写了一条线怎么都不通,找了半天原因觉得很搞笑,我们连接的是mysql数据库,在D层写的确实sqlHelper,难怪啊,然后上网了MySQLHelper怎么写,积累一下自己的代码库。...

空空如也

空空如也

1 2 3 4 5 6
收藏数 103
精华内容 41
关键字:

查积分怎么查