第一种
<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>
<select id="queryById" parameterType="Long" resultMap="deviceMap2">
SELECT
cd.id,
cd.`name`,
cd.account,
cd.passwd,
cd.`status`,
cda.admin_tel,
cda.s_startup_time,
cda.s_heartbeat_time,
cda.s_isprojection,
cda.h_report_time
FROM
c_device AS cd
LEFT JOIN c_device_attr AS cda ON cd.id = cda.device_id
where cd.id=#{id}
and 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" javaType="com.juncdt.mips.device.entity.DeviceAttrEntity">
<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"/>
</association>
</resultMap>
</resultMap>