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

最新推荐文章于 2024-09-03 18:32:54 发布
最新推荐文章于 2024-09-03 18:32:54 发布
阅读量1.3k 收藏
点赞数 1
文章标签： java 数据库 移动开发

现在有这样一个需求：

　　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

 

weixin_34032792
关注
mybatis一对多结果集,主表分页查询,子表条件查询
学海无涯,我用JAVA
07-28 2015
一对多查询嵌套查询: 主表查询过程中,再次调用一个查询,取查询子表数据嵌套结果集查询: 一次性查询主表关联出子表,通过结果集封装,将自己封装为一个集合,返回一个一对多的结果今天要说的是当: 做了一对多查询后,还要对多的子表,进行条件过滤,然后在反过来应用到主表上,继续分页查询~~丧心病狂的产品汪~~至此,一个一对多,然后用子表的过滤条件,作用到主表上的 分页…已经实现了~~
用MyBatis实现表的一对多关联查询
12-05
使用MyBatis写的一对多关联映射查询的web，在eclipse上写的，使用的Mysql进行数据连接，内含数据库脚本，直接导入数据库即可建数据库和建表，不用再编写，非常方便
day2021/9/28mybatis多对多，分页查询，通用mapper
TIM_Zhang1122的博客
09-28 660
第三天课程结束，多对多，通用mapper让我体会到代码不断的被简化，感谢前辈的贡献。 多对多符合现实场景，万物之间都是有关联的，都是多个对多个的关系。 6.关联查询：多对多 6.1 学生和老师数据模型 6.1.1 表间关系 [外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-rsaQAZGk-1632788039797)(assets/image-20210721145256539.png)] #老师表 CREATE TABLE teacher( tid INT PRIMARY
Mybatis分页查询主从表
最新发布
MyFreeIT
09-03 269
主查询的结果是List，以及每一条记录的内涵List，性能是N+1次查询。先主查询，再关联子查询，不影响分页效果，否则子查询也会参与分页。不过如果主查询包括SUM和Group语句，这种方式就不可以。只有在平铺所有主从表的时候可用。
Mybatis分页多表多条件查询
焱敦的博客
08-12 746
分析上述三种方式，就开发效率而言，方式三最快且好用，当然如果遇到业务逻辑复杂的，则可以通过xml中sql的方式来查。where ui.id=us.user_id and us.user_type like '%钢%' and ui.user_name like ‘%james%’ and ui.user_coding like ‘%123%’//这里注意区分是哪张表的字段，根xml里面别名对应，不然如果两张表里面有相同字段，//且出现在查询条件里面时，会分不清是具体哪张表的字段，所以一定得注明别名。
mybatis处理有关联关系（多对多）的分页查询
LJWWD的博客
03-09 2964
一、业务场景 需要给前端返回下图所示格式的数据，其中user和role是多对多关系。 MyBatis-Plus如何自定义分页 在xml中写完代码，使用MyBatis-Plus自定义分页之后发现下面的一些参数对不上。 发生这个情况的主要原因是使用了join，导致数据库返回的数据有重复。而MyBatis-Plus中是根据返回的记录做分页。 如果下图中size=3，current=1，则只会返回前三条记录，即只会返回admin这一个用户。 二、解决方案 1. 针对sql解决问题 首先是最开始有问题的sql代
SSM框架 Mybatis联合查询 多表查询 分页
amoxu
12-03 4789
Java的MyBatis框架中实现多表连接查询和查询结果分页 实现多表联合查询 还是在david.mybatis.model包下面新建一个Website类，用来持久化数据之用，重写下相应toString()方法，方便测试程序之用。 package david.mybatis.model;import java.text.SimpleDateFormat; import java.util.Date
在mybatis分页查询时，主表对关联表 一对多 分页查询怎么实现
qq_18932003的博客
11-02 3932
【mybatis】在mybatis分页查询时，主表对关联表 一对多 分页查询怎么实现 - Angel挤一挤 - 博客园【mysql】 mybatis实现 主从表 left join 1:n 一对多 分页查询 主表从表都有查询条件 【mybatis】count 统计+JSON查询 - Angel挤一挤 - 博客园Mybatis如何多表之间的分页查询 - 灰信网（软件开发博客聚合） 关于mybatis+sqlserver 的多表关联的分页（注意要先分页在多表关联） - ForYouForMe - 博客园My.
MyBatis-Plus多表联合查询并且分页(3表联合)
08-24
MyBatis-Plus 是一个基于 MyBatis 的增强型 ORM 框架，提供了很多实用的功能，例如多表联合查询和分页等。下面我们将详细介绍如何使用 MyBatis-Plus 实现多表联合查询并且分页（3 表联合）。 首先，让我们看一下...
Java的MyBatis框架中实现多表连接查询和查询结果分页
09-02
在处理多表连接查询和查询结果分页时，MyBatis提供了强大的动态SQL功能，使得这些复杂的操作变得简单易行。 1. **多表连接查询**： 在MyBatis中，可以通过`<join>`、`<association>`等标签来实现多表连接查询。以...
Mybatis--分页查询
m0_63600788的博客
07-18 3916
分页查询则是在页面上将本来很多的数据分段显示，每页显示用户自定义的行数。为了能在页面上显示上述的分页效果，那么我们就得在把页面上的每一个数据封装成到某个对象共享给。：把多个需要共享的数据，封装到一个对象，往后就只需要把数据封装到该对象，再共享该对象即可。，获取页面传递的分页参数，执行查询，将结果共享到请求作用域，请求转发回到。，表示要显示某一页数据的页码，在程序中表示翻页要去往的页面，比如。：数据太分散，需要共享多个数据，不方便统一管理多个数据。增加两个方法，一个查询数据总量，一个查询当前页的数据。
mybatis一对多关联查询分页解决方案
aiyongbo123456的博客
01-08 2749
1、sql：分页查询 先分页查询获取id,再根据这些id 查询数据 select a.id, a.xm, a.xb, a.ksno, a.zkzh, a.bmxh, a.zjlx, a.zjno, a.xp, a.status, a.dizhi, a.xuexiao, a.banji, a.cscode, a. fenpei_cscode, a.fenzu_code, a.fenz...
MyBatisPlus一对多分页查询处理主表子表查询条件
Waruler的博客
09-08 4824
MyBatisPlus 一对多分页查询,处理主表分表的查询条件
Mybatis一对多查询，分页显示问题解决方案
Saberman
10-27 2653
Mybatis一对多查询，分页显示问题解决方案
MyBatis Plus 实现多表分页查询功能的示例代码
09-07
在MyBatis Plus中，实现多表分页查询功能是一项常见的需求，特别是在处理大量数据时，物理分页显得尤为重要，因为它能有效地降低内存消耗并提高系统性能。下面将详细介绍如何利用MyBatis Plus来实现这一功能。 首先...
mysql关联表分页查询_MySQL一对多分页查询-主表关联表条件查询问题
weixin_34517745的博客
02-10 2688
文章目录1 摘要2 情景复现2.1 数据模型2.2 核心代码2.3 测试数据2.4 拓展一点1 摘要分页查询是后台项目中最常见的一种操作，在一对多(one to many)的关系表中，如何根据主表进行分页是一个较为棘手的问题，尤其是查询条件既包含主表又包含从表/关联表的。一般情况下，不是查询结果条数不正确，就是一对多中的多的一方只能显示一条信息。本文将记录作者自己在项目中针对一对多分页查询主表和关...
oracle 一对多数据分页查询筛选
weixin_33854644的博客
11-02 498
今天项目测试运行的时候，遇到了一个奇怪的问题，这个问题说起来按sql语法的话是没有错误的 但是呢按照我们的业务来做区分就有些逻辑上的错误了， 下面请听我慢慢道来，在数据库中有两个数据， 先来看下第一次sql是如何写的 查询之后在外面做分页，很正常的逻辑，但是大家都发现了，这是一个多表查询，而且是一对多关系，这就有点问题了 先来看一个图 问题出现在哪呢？ 1...
无限级树形结构，sql带条件带分页查询
择一城终老，遇一人白首。
12-08 895
无限级树形结构，sql带条件带分页查询
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值