【mybatis】在mybatis分页查询时，主表对关联表 一对多 分页查询怎么实现

最新推荐文章于 2024-01-30 09:34:32 发布
最新推荐文章于 2024-01-30 09:34:32 发布
阅读量465 收藏
点赞数
文章标签： java 移动开发
原文链接：http://www.cnblogs.com/sxdcgaq8080/p/9706845.html
版权

 

有一个更好的解决方案：https://www.cnblogs.com/sxdcgaq8080/p/10876088.html

实现主从表 left join  1：n   关联查询并分页   支持主表从表字段都可查

=========================================================

现在有这样一个需求：

　　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

 

转载于:https://www.cnblogs.com/sxdcgaq8080/p/9706845.html

weixin_34247155
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MyBatis-Plus多表联合查询并且分页(3表联合)
08-24
主要介绍了MyBatis-Plus多表联合查询并且分页(3表联合)，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
MyBatis Plus 的多表联接、分页查询实现方法，源码加sql
11-30
MyBatis Plus 的多表联接、分页查询实现方法 http://localhost/common/getAllQuestionByPage/1/10 多表关联、分页查询接口 http://localhost/common/getAllQuestionWithStudentByPage/1/10
MyBatis分页一对多的处理方法
最新发布
cjy1575944940的博客
01-30 307
mybatis如何较为完美的执行分页一对多的方式呢？本文列举了反例也列举了正例，欢迎在评论区继续探讨
MyBatis Plus 实现多表分页查询功能的示例代码
09-07
主要介绍了MyBatis Plus 实现多表分页查询功能，本文给大家介绍的非常详细，对大家的学习或工作具有一定的参考借鉴价值,需要的朋友可以参考下
Java的MyBatis框架中实现多表连接查询和查询结果分页
09-02
主要介绍了Java的MyBatis框架中实现多表连接查询和查询结果分页,借助MyBatis框架中带有的动态SQL查询功能可以比普通SQL查询做到更多,需要的朋友可以参考下
在mybatis分页查询时，主表对关联表 一对多 分页查询怎么实现
drnrrwfs的博客
04-12 735
【mybatis】在mybatis分页查询时，主表对关联表 一对多 分页查询怎么实现 - Angel挤一挤 - 博客园【mysql】 mybatis实现 主从表 left join 1:n 一对多 分页查询 主表从表都有查询条件 【mybatis】count 统计+JSON查询 - Angel挤一挤 - 博客园 ?Mybatis如何多表之间的分页查询 - 灰信网（软件开发博客聚合） 关于mybatis+sqlserver 的多表关联的分页（注意要先分页在多表关联） - ForYouForMe - 博客园 M
MybatisPlus使用Left Join...on...一对多多表联查和Ipage分页返回数据问题
xiaomingboke的博客
04-04 4247
MybatisPlus一对多关联表分页查询，bug点
MyBatisPlus一对多分页查询处理主表子表查询条件
Waruler的博客
09-08 4258
MyBatisPlus 一对多分页查询,处理主表分表的查询条件
Mybatis Plus一对多联表查询及分页解决方案
热门推荐
抓娃攻城师
11-19 1万+
Mybatis-Plus一对多联表查询及分页问题解决和优化方案, 查询用户信息列表，其中包含用户对应角色信息，页面检索条件有根据角色名称查询用户列表； 一个用户对应多个角色，用户信息和角色信息分表根据用户id关联存储，用户和角色一对多进行表连接查询，
【mysql】 mybatis实现 主从表 left join 1:n 一对多 分页查询 主表从表都有查询条件 【mybatis】count 统计+JSON查询...
weixin_33814685的博客
05-16 1079
mybatis实现 主从表 left join 1:n 一对多 分页查询 主表从表都有查询条件+count 需求： ======================================== 1.主从表数据是 1：m 2.主从表各自都有查询条件 3.最后查询结果需要分页，并统计总数 注意： ==============================...
mybatis一对多查询功能
08-31
主要介绍了mybatis一对多查询功能,非常不错，具有参考借鉴价值，需要的朋友可以参考下
MySQL一对多分页查询-主表关联表条件查询问题
Mrqiang9001
11-06 8404
文章目录1 摘要2 情景复现2.1 数据模型2.2 核心代码2.3 测试数据2.4 拓展一点 1 摘要 分页查询是后台项目中最常见的一种操作，在一对多(one to many)的关系表中，如何根据主表进行分页是一个较为棘手的问题，尤其是查询条件既包含主表又包含从表/关联表的。一般情况下，不是查询结果条数不正确，就是一对多中的多的一方只能显示一条信息。本文将记录作者自己在项目中针对一对多分页查询主表...
MP之自定义分页，多表查询带分页带条件（Error evaluating expression ‘ew.customSqlSegment‘.或 Invalid bound statement）
IT学习小镇
01-01 6162
一、问题 前端所需数据： 但成绩表中只有考生的id及试卷的id，此时就需要进行多表查询，通过考生的id获取姓名字段，通过试卷的id获取试卷名称。分别需要使用到三张表，成绩表，试卷表，考生表。同时需要做到可以多条件查询，且带分页。 以前遇到的分页基本都是多条件单表分页，实现起来相对比较容易。现在使用多表带分页带多条件就需要自行进行编写了。 二、具体解决及参考博客 具体参考：https://blog.csdn.net/weixin_38111957/article/details/9155410
Mybatis一对多查询，分页显示问题解决方案
Saberman
10-27 1595
Mybatis一对多查询，分页显示问题解决方案
Mybatis(四)——多表级联查询
三毛村滴雪鱼粉的博客
08-03 1122
MyBatis多表级联查询
Java基础知识——mybatis（多表连接，懒加载，缓存，注解）
weixin_45680007的博客
02-03 571
多表查询 表的关系： 一对一：一一对应 多对一：主从表关系。多个从表的记录对应一个主表的记录 一对多：主从表关系。一个主表的记录对应多个从表的记录 多对多：利用中间表记录关系。 注意：使用内连接或者左右外连接查询，不影响实现思路，只影响实现结果 一对一/多对一 实现： 用户和账户：一个用户对应多个账户，多个账户对应一个用户。 现在重点放在账户上 select A.*,B.username,B.ad...
mybatis 多层（二层）级联查询
u010342038的博客
12-11 1137
mybatis 多层（二层）级联查询
mysql关联表分页查询_MySQL一对多分页查询-主表关联表条件查询问题
weixin_34517745的博客
02-10 2541
文章目录1 摘要2 情景复现2.1 数据模型2.2 核心代码2.3 测试数据2.4 拓展一点1 摘要分页查询是后台项目中最常见的一种操作，在一对多(one to many)的关系表中，如何根据主表进行分页是一个较为棘手的问题，尤其是查询条件既包含主表又包含从表/关联表的。一般情况下，不是查询结果条数不正确，就是一对多中的多的一方只能显示一条信息。本文将记录作者自己在项目中针对一对多分页查询主表和关...
mybatis一对多分页查询
06-10
MyBatis支持一对多分页查询，可以通过嵌套查询实现。以下是一个示例，假设我们有两个表：`orders`和`order_items`，一个订单可以对应多个订单项。 ```xml <!-- 定义订单查询SQL --> select * from orders where ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值