mybatis-plus 分页

 @RequestMapping("/list")
    public R list(@RequestParam HashMap map){
        PageUtils page = deviceService.queryList(map);

        return R.ok(page);
    }
     /**
       * 查询设备列表
       */
    PageUtils queryList(HashMap map);
 @Override
    public PageUtils queryList(HashMap map) {
       IPage<DeviceEntity> page= baseMapper.queryList(new MyPage<DeviceEntity>(map));
        return new PageUtils(page);
    }
     /**
       * 设备列表
       */
     IPage<DeviceEntity> queryList(MyPage<DeviceEntity> deviceEntityMyPage);
  <select id="queryList" parameterType="Map" resultMap="deviceMap2">
          SELECT
            cd.id,
            cd.`name`,
            cd.account,
            cd.passwd,
            cd.`status`,
            cd.play_type,
            cd.display_type,
            cd.version,
            cd.number,
            cd.company_id,
            cd.create_time,
            cd.update_time,
            cd.invalid,
            cda.device_id,
            cda.address,
            cda.admin,
            cda.admin_tel,
            cda.s_startup_time,
            cda.s_heartbeat_time,
            cda.s_isprojection,
            cda.h_screen_size,
            cda.h_screen_resolution,
            cda.id deviceAttrId,
            cda.h_volume,
            cda.h_network_type,
            cda.h_manufacturer,
            cda.h_ram,
            cda.h_rom,
            cda.h_cpu,
            cda.h_system_type,
            cda.h_mac,
            cda.h_system_version,
            cda.h_ip,
            cda.h_model,
            cda.h_report_time
        FROM
            c_device AS cd
            LEFT JOIN c_device_attr AS cda ON cd.id = cda.device_id
            where
             cd.invalid=0
    </select>
 <resultMap type="com.juncdt.mips.device.entity.DeviceEntity" id="deviceMap2">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="account" column="account"/>
        <result property="passwd" column="passwd"/>
        <result property="status" column="status"/>
        <result property="playType" column="play_type"/>
        <result property="displayType" column="display_type"/>
        <result property="version" column="version"/>
        <result property="number" column="number"/>
        <result property="companyId" column="company_id"/>
        <result property="createTime" column="create_time"/>
        <result property="updateTime" column="update_time"/>
        <result property="invalid" column="invalid"/>
        <association property="deviceAttr" resultMap="DeviceAttrResult"/>
    </resultMap>

    <resultMap  type="com.juncdt.mips.device.entity.DeviceAttrEntity" id="DeviceAttrResult">
        <id property="id" column="deviceAttrId"/>
        <result property="companyId" column="company_id"/>
        <result property="deviceId" column="device_id"/>
        <result property="address" column="address"/>
        <result property="admin" column="admin"/>
        <result property="adminTel" column="admin_tel"/>
        <result property="sStartupTime" column="s_startup_time"/>
        <result property="sHeartbeatTime" column="s_heartbeat_time"/>
        <result property="sIsprojection" column="s_isprojection"/>
        <result property="hScreenSize" column="h_screen_size"/>
        <result property="hScreenResolution" column="h_screen_resolution"/>
        <result property="hVolume" column="h_volume"/>
        <result property="hNetworkType" column="h_network_type"/>
        <result property="hManufacturer" column="h_manufacturer"/>
        <result property="hRom" column="h_rom"/>
        <result property="hRam" column="h_ram"/>
        <result property="hCpu" column="h_cpu"/>
        <result property="hMac" column="h_mac"/>
        <result property="hSystemType" column="h_system_type"/>
        <result property="hSystemVersion" column="h_system_version"/>
        <result property="hIp" column="h_ip"/>
        <result property="hModel" column="h_model"/>
        <result property="hReportTime" column="h_report_time"/>
    </resultMap>
|page |是  |Integer |页码   |
|limit |是  |Integer |分页数量   |
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值