文章内容
- 单表查询
- 多表查询
单表查询
多表查询
- 三张表:
<!-- 查询长者请假详情 -->
<select id="selectElderlyLeaveDetail" resultType="ElderlyLeave">
select
a.elderly_leave_id elderlyLeaveId,
a.org_id orgId ,
a.elderly_id elderlyId ,
a.leave_type leaveType ,
a.leave_status leaveStatus ,
a.leave_start_time leaveStartTime ,
a.leave_end_time leaveEndTime ,
a.out_time outTime ,
a.in_time inTime ,
a.has_companion hasCompanion ,
a.leave_reason leaveReason ,
a.file_url fileUrl ,
a.create_time createTime,
e.elderly_name elderlyName,
e.phone,
e.address,
ecir.bed_name bedName,
ecir.room_name roomName
from cr_elderly_leave a
left join eld_elderly e on a.elderly_id = e.elderly_id
left join eld_check_in_record ecir on e.elderly_id = ecir.elderly_id and ecir.status = '1' and ecir.check_in_status = '1'
where a.elderly_leave_id = #{elderlyLeaveId}
</select>
总结:从这里可以看出一般工作中都会取别名,且跟实体类的属性名一样。查询结构可以用resultMapper和resultType封装,注意的是一般resultMapper要写映射,resultType可以不用,但是要保证字段名跟属性名一样 。特殊的是,采用resultMapper。