@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 |分页数量 |