mybatis级联操作

一对一关联查询

1、嵌套结果

使用嵌套结果映射来处理重复的联合结果的子集

1. resultMap可以通过使用extends实现继承关系，简化很多配置工作量；
2. 关联的表查询的类添加前缀是编程的好习惯；
3. 通过添加完整的命名空间，可以引用其他xml文件的resultMap；

实例：

映射文件：

<select id="selectUserPosition1" resultMap="userAndPosition1">
	select
	    a.id, 
	    user_name,
	    real_name,
	    sex,
	    mobile,
	    email,
	    a.note,
	    b.id  post_id,
	    b.post_name,
	    b.note post_note
	    from t_user a,
	    t_position b
	where a.position_id = b.id
</select>

<resultMap id="userAndPosition1" extends="BaseResultMap" type="TUser">
	<association property="position" javaType="TPosition" columnPrefix="post_">
		<id column="id" property="id"/>
		<result column="name" property="postName"/>
		<result column="note" property="note"/>
	</association>
</resultMap>

<resultMap id="BaseResultMap" type="TUser">

	<id column="id" property="id" />
	<result column="user_name" property="userName" />
	<result column="real_name" property="realName" />
	<result column="sex" property="sex" />
	<result column="mobile" property="mobile" />
	<result column="email" property="email" />
	<result column="note" property="note" />
</resultMap>

映射的实体类中有TPosition属性：

public class TUser implements Serializable{
    private Integer id;

    private String userName;

    private String realName;

    private Byte sex;

    private String mobile;

    private String email;

    private String note;

    private TPosition position;
    
    private L