mybatis多表查询
1、例子:
实体类:
<select id="findAllMsgByTagId" parameterType="com.yunkuan.entity.ParkClass" resultMap="parkMap" >
select * from parkclass pc join parkclasstag pct on(pc.classtaglevel=pct.id)
join parent p on(pc.parentid=p.id)
where pc.parkid=#{parkid} and pct.id=#{classtaglevel}
</select>
<!-- 指定关联属性加载 -->
<resultMap id="parkMap" type="com.yunkuan.entity.ParkClassParent">
<id property="id" column="id"/>
<result property="parkid" column="parkid"/>
<result property="childname" column="childname"/>
<result property="classtaglevel" column="classtaglevel"/>
<result property="parentid" column="parentid"/>
<result property="timer" column="timer"/>
ParkClassTag类:
<association property="parkClassTag" javaType="com.yunkuan.entity.ParkClassTag">
<id property="id" column="id"/>
<result property="id" column="id"/>
<result property="tagname" column="tagname"/>
<result property="timer" column="timer"/>
</association>
Parent类:
<association property="parent" javaType="com.yunkuan.entity.Parent">
<id property="id" column="id"/>
<result property="parentname" column="parentname"/>
<result property="parentpass" column="parentpass"/>
<result property="phone" column="phone"/>
<result property="address" column="address"/>
<result property="balance" column="balance"/>
<result property="timer" column="timer"/>
</association>
</resultMap>
如果多表查询里有相同的字段:
例子: