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() {
}
}