MyBatis查询返回的实体包含另一个实体,不在mapper.xml的BaseResultMap配置的写法
实体
public class TStudent {
private String id;
private String studentNum;
private TWorker tWorker;
public TWorker gettWorker() {
return tWorker;
}
public void settWorker(TWorker tWorker) {
this.tWorker = tWorker;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getStudentNum() {
return studentNum;
}
public void setWindowNum(String studentNum) {
this.studentNum= studentNum;
}
}
Mapper.xml的写法
<select id="selectNum" resultType="com.th.spring.slientcry.entity.Student">
SELECT
s."ID",
s.STUDENT_NUM,
TW.WORKER_STATE as "tWorker.workerState",
TW.WORKER_NAME as "tWorker.workerName"
FROM
STUDENT S
LEFT JOIN T_WORKER tw ON s.student_NUM = TW.WORK_NUM
<if test="tWorker.workerState