MyBatis中一对一表关系查询案例(一)

1 准备两张表employee_basic（员工信息表）,employee_school(员工学历表)


2 在两张表中写入部分测试数据


3 创建pojo实体类

package com.zxf.pojo;

import java.io.Serializable;

public class Employee implements Serializable {
   
    private String emp_no;
    private String emp_name;
    private String dept_id;
    private String emp_gender;
    private String emp_email;
    //员工基本情况表和员工学历表是一对一的关系，每一个员工有且只有一份学历表
    private EmployeeSchool employeeSchool;

    public String getEmp_no() {
   
        return emp_no;
    }

    public void setEmp_no(String emp_no) {
   
        this.emp_no = emp_no;
    }

    public String getEmp_name() {
   
        return emp_name;
    }

    public void setEmp_name(String emp_name) {
   
        this.emp_name = emp_name;
    }

    public String getDept_id() {
   
        return dept_id;
    }

    public void setDept_id(String dept_id) {
   
        this.dept_id = dept_id;
    }

    public String getEmp_gender() {
   
        return emp_gender;
    }

    public void setEmp_gender(String emp_gender) {
   
        this.emp_gender = emp_gender;
    }

    public String getEmp_email() {
   
        return emp_email;
    }

    public void setEmp_email(String emp_email) {
   
        this.emp_email = emp_email;
    }

    public EmployeeSchool getEmployeeSchool() {
   
        return employeeSchool;
    }

    public void setEmployeeSchool(EmployeeSchool employeeSchool) {
   
        this.employeeSchool = employeeSchool;
    }

}

package com.zxf.pojo;