mybaits级联查询

最新推荐文章于 2024-03-01 17:36:05 发布

fsh430623

最新推荐文章于 2024-03-01 17:36:05 发布

阅读量350

点赞数

分类专栏： spring+hibernate+ibatis框架

本文链接：https://blog.csdn.net/fsh430623/article/details/84481761

版权

spring+hibernate+ibatis框架专栏收录该内容

23 篇文章 0 订阅

订阅专栏

mybaits级联查询

1对1的级联或关联查询如下：用association，配置好对应的select子查询就行。
<resultMap id="usersResult" type="com.zlwh.member.model.Users">
<result property="id" column="id"/>
<result property="loginName" column="login_name"/>
<result property="schoolId" column="school_id"/>

<association column="school_id" property="school"
javaType="com.zlwh.member.model.School" select="getSchoolById" />
</resultMap>

<resultMap id="schoolResult" type="com.zlwh.member.model.School">
<result property="id" column="id"/>
<result property="schoolName" column="school_name"/>
<result property="schoolCode" column="school_code"/>
</resultMap>

<select id="getSchoolById" resultMap="schoolResult">
SELECT * FROM school WHERE id = #{id}
</select>

1对多的时候用collection,配置略