关联(association)元素处理“有一个”(has a)类型的关系,这里的关联是一对一(one to one),MyBatis 有两种不同的方式加载关联:
- 嵌套select查询:通过执行另外一个 SQL 映射语句来加载期望的复杂类型。
- 嵌套结果映射:使用嵌套的结果映射来处理连接结果的重复子集
一、一对一查询
嵌套select查询(one to one)
user表 和 userInfo表
两次查询,先查user表 再查userInfo表
SELECT * FROM users WHERE user_id=5; //user_id=5
SELECT * FROM userInfo WHERE user_id=5;//使用上面得到的user_id
<resultMap id="user类地址" type="com.gezhi.pojo.User">
<association property="id" column="user_id" javaType="Integer" select="userInfo方法2地址"/>
</resultMap>
<select id="方法1名" resultMap="user">
SELECT * FROM users WHERE ID = #{id}
</select>
<select id="方法2名" resultType="userInfo">
SELECT * FROM userInfo WHERE ID = #{id}
</select>
嵌套结果查询
联表查询 左外联
使用嵌套结果映射来处理重复的联合结果的子集
封装联表查询的数据(去除重复的数据)
SELECT u.user_id, u.user_name, u.user_pwd, u.user_type, info.info_id, info.info_nickname, info.info_phone, info.info_gender, info.info_email, info.info_address, info.user_id
FROM users AS u
LEFT JOIN user_info AS info
ON u.user_id = info.user_id
WHERE u.user_id = 5
<resultMap id="blogResult" type="Blog">
<id property="id" column="blog_id" />
<result property="title" column="blog_title"/>
<association property="author" javaType="Author">
<id property="id" column="author_id"/>
<result property="username" column="author_username"/>
<result property="password" column="author_password"/>
<result property="email" column="author_email"/>
<result property="bio" column="author_bio"/>
</association>
</resultMap>
二、一对多查询(one to many)
<collection property="posts" ofType="domain.blog.Post">
<id property="id" column="post_id"/>
<result property="subject" column="post_subject"/>
<result property="body" column="post_body"/>
</collection>
emmm