mybatis一对多映射

关联表

被关联表(id对应关联表的child_id)

项目结构

分别生成两个实体对象且生成get、set方法及有(无)参构造, 对应各自dao层映射

mybatis.xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

    <!--设置别名-->
    <typeAliases>
        <typeAlias type="com.java.entity.One" alias="One"></typeAlias>
        <typeAlias type="com.java.entity.Two" alias="Two"></typeAlias>
    </typeAliases>

    <environments default="mysql">
        <environment id="mysql">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"></property>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/my_database"></property>
                <property name="username" value="root"></property>
                <property name="password" value="123456"></property>
            </dataSource>
        </environment>

    </environments>

    <!--关联局部配置文件-->
    <mappers>
        <mapper resource="com/java/dao/One/OneDao.xml"></mapper>
        <mapper resource="com/java/dao/Two/TwoDao.xml"></mapper>
    </mappers>

</configuration>

个体配置文件(.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">

<!--
    namespace: 命名空间, 其值为某一个dao层类的具体路径
-->
<mapper namespace="com.java.dao.One.OneDao">

    <!--
        resultMap: 返回值结果映射
            type: 数据返回的结果类型
            id: 别名
    -->
    <resultMap id="one_map" type="One">
        <!--
            property: 代表实体类中的属性名
            javaType: 代表实体类中的属性的具体类型
            column: 数据库中查询语句的字段名
        -->
        <result property="id" javaType="Integer" column="id"></result>
        <result property="name" javaType="String" column="name"></result>
        <result property="desc" javaType="String" column="desc"></result>
        <result property="child_id" javaType="Integer" column="child_id"></result>
        <association property="two" javaType="com.java.entity.Two">
            <result property="name" javaType="String" column="two_name"></result>
            <result property="desc" javaType="String" column="two_desc"></result>
        </association>
    </resultMap>

    <select id="oneToOne" parameterType="One" resultMap="one_map">
        SELECT o.*, t.name as 'two_name', t.desc as 'two_desc' FROM one_to_one_one o INNER JOIN one_to_one_two t ON o.child_id = t.id;
    </select>
</mapper>

测试类

package com.java.dao.One;

import com.java.entity.One;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class OneDao {
    private SqlSession sqlSession = null;

    @Before
    public void init() throws IOException {
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        InputStream resourceAsStream = Resources.getResourceAsStream("mybatis.xml");
        SqlSessionFactory build = sqlSessionFactoryBuilder.build(resourceAsStream);
        sqlSession = build.openSession();
    }

    @Test
    public void oneToOne() {
        List<One> objects = sqlSession.selectList("com.java.dao.One.OneDao.oneToOne");
        System.out.println(objects);
    }
}