概念
主要用于多表查询时一对一数据封装的简洁灵活。方式一般为子表包含主表的类,然后用resultMap标签来配置,案例如下面数据库中有user和account两张表,user为主表
mabatis实现两张表的联合查询封装到一个对象account中。
案例
1.实体类代码
user类
package edu.yjsj.domain;
import java.io.Serializable;
public class User implements Serializable {
private Integer id;
private String userName;
private String userPwd;
public int getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUserPwd() {
return userPwd;
}
public void setUserPwd(String userPwd) {
this.userPwd = userPwd;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", userName='" + userName + '\'' +
", userPwd='" + userPwd + '\'' +
'}';
}
}
account类
package edu.yjsj.domain;
import java.io.Serializable;
public class Account implements Serializable {
private Integer aid;
private Integer id