mybatis里的mapper文件的多表查询

mapper文件

<resultMap type="com.zcc.mybatis.user.entity.UserInfo" id="userInfo">
	<id property="id" column="user_info_id"></id>
	<result property="userName" column="user_name" />
	<result property="realName" column="real_name" />
	<result property="password" column="password" />
	<result property="age" column="age" />
	<result property="realName" column="real_name"/>
	<association property="address" javaType="com.zcc.mybatis.user.entity.Address">
		<result property="id" column="addr_id" />
		<result property="realName" column="addr_real_name"/>
		<result property="mobile" column="mobile"/>
		<result property="address" column="address"/>
	</association>
		

</resultMap>

	<select id="get" resultMap="userInfo">
		select ui.id user_info_id,ui.user_name,ui.password,ui.real_name,ui.age,
		addr.id addr_id,addr.real_name addr_real_name,addr.mobile,addr.address
		from user_info ui
		left join address addr on addr.user_id = ui.id
		where ui.id=#{id}
	</select>

类

Address 
@Data
public class Address {
	private int id;
	private int userId;
	private String realName;
	private String mobile;
	private String address;
	
}
UserInfo 类
@Data
public class UserInfo {

	private int id;
	private String userName;
	private String password;
	private String realName;
	private int age;
	private Address address;
	public UserInfo() {
		
	}
}