mybatis一对一映射

一对一：一个班主任只属于一个班级，一个班级也只能有一个班主任

两个数据库表：

create table tb_head_teacher(
ht_id int primary key auto_increment,
ht_name varchar(20),
ht_age int);

insert into tb_head_teacher(ht_name,ht_age) values('ZhangSan',40);


create table tb_class(
c_id int primary key auto_increment,
c_name varchar(20),
c_ht_id int unique,
foreign key(c_ht_id) references tb_head_teacher(ht_id));

insert into tb_class(c_name,c_ht_id) values('Class One',1);

两个实体类：

Classes.java

package xyz.fengqing11.hellomybatis.domain;

public class Classes {
    private Integer id;
    private String name;
    private HeadTeacher teacher;

    public Classes() {

    }

    public Classes(Integer id, String name, HeadTeacher teacher) {
        this.id = id;
        this.name = name;
        this.teacher = teacher;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public HeadTeacher getTeacher() {
        return teacher;
    }

    public void setTeacher(HeadTeacher teacher) {
        this.teacher = teacher;
    }

    @Override
    public String toString() {
        return "Classes{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", teacher=" + teacher +
                '}';
    }
}

HeadTeacher.java

package xyz.fengqing11.hellomybatis.domain;

public class HeadTeacher {
    private Integer id;
    private String name;
    private Integer age;

    public HeadTeacher() {

    }

    public HeadTeacher(Integer id, String name, Integer age) {
        this.id = id;
        this.name = name;
        this.age = age;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "HeadTeacher{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                '}';
    }
}

班级持久接口层：
IClasses.java

package xyz.fengqing11.hellomybatis.dao;

import xyz.fengqing11.hellomybatis.domain.Classes;

/**
 * 班级持久层接口
 */
public interface IClasserDao {
    /**
     * 查询班级，根据id查询班级
     * @param id
     * @return
     * @throws Exception
     */
    Classes selectClassById(Integer id) throws Exception;
}

映射文件：
IClasses.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="xyz.fengqing11.hellomybatis.dao.IClasserDao">
    <select id="selectClassById" parameterType="int" resultMap="classmap">
        select * from tb_class c, tb_head_teacher t  where c.c_ht_id = t.ht_id and c.c_id=#{id}
    </select>
    <!--<resultMap id="classmap" type="xyz.fengqing11.hellomybatis.domain.Classes">
        <id property="id" column="c_id"/>
        <result property="name" column="c_name"/>
        <association property="teacher" javaType="xyz.fengqing11.hellomybatis.domain.HeadTeacher">
            <id property="id" column="ht_id"/>
            <result property="name" column="ht_name"/>
            <result property="age" column="ht_age"/>
        </association>
    </resultMap>-->

    <resultMap id="teachermap" type="xyz.fengqing11.hellomybatis.domain.HeadTeacher">
        <id property="id" column="ht_id"/>
        <result property="name" column="ht_name"/>
        <result property="age" column="ht_age"/>
    </resultMap>
    <resultMap id="classmap" type="xyz.fengqing11.hellomybatis.domain.Classes">
        <id property="id" column="c_id"/>
        <result property="name" column="c_name"/>
        <association property="teacher" column="c_ht_id" javaType="xyz.fengqing11.hellomybatis.domain.HeadTeacher"
                     resultMap="teachermap"/>
    </resultMap>
</mapper>

重点在于一对一的映射如何配置：

方法一：使用association 嵌套映射

<resultMap id="classmap" type="xyz.fengqing11.hellomybatis.domain.Classes">
        <id property="id" column="c_id"/>
        <result property="name" column="c_name"/>
        <association property="teacher" javaType="xyz.fengqing11.hellomybatis.domain.HeadTeacher">
            <id property="id" column="ht_id"/>
            <result property="name" column="ht_name"/>
            <result property="age" column="ht_age"/>
        </association>
</resultMap>

方法二：如果需要HeadTeacher的映射重用，则可以将其分离出来

 <resultMap id="teachermap" type="xyz.fengqing11.hellomybatis.domain.HeadTeacher">
        <id property="id" column="ht_id"/>
        <result property="name" column="ht_name"/>
        <result property="age" column="ht_age"/>
</resultMap>
<resultMap id="classmap" type="xyz.fengqing11.hellomybatis.domain.Classes">
        <id property="id" column="c_id"/>
        <result property="name" column="c_name"/>
        <association property="teacher" column="c_ht_id" javaType="xyz.fengqing11.hellomybatis.domain.HeadTeacher"
                     resultMap="teachermap"/>
</resultMap>

---

-end-