springboot整合Mybatis的一对多

1. 第一步yml配置

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/dev?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    password: 123456
    username: root
    driver-class-name: com.mysql.jdbc.Driver


mybatis:
  mapper-locations: classpath*:mapper/*.xml  # 扫描resources下mapper中的xml文件

注意事项：建议mysql版本和mysql-connector-java版本保持一致。

2. 数据库结构（一个user对应多个address）
   
3. 构建实体和配置xml文件

//需要查询的字段是用户的name，age，和多个AddressDto对象
public class UserAndAddress {
    private String name;
    private Integer age;
    private List<AddressDto> addressDto;

    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;
    }

    public List<AddressDto> getAddressDto() {
        return addressDto;
    }

    public void setAddressDto(List<AddressDto> addressDto) {
        this.addressDto = addressDto;
    }
}

public class AddressDto {

    private String address;
    private String color;

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getColor() {
        return color;
    }

    public void setColor(String color) {
        this.color = color;
    }
}

<?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="com.example.zookeeper.mapper.UserAddressMapper">

    <select id="userDto" resultMap="userResult">
        SELECT u.`name`,u.age,ua.address,ua.color FROM `user` u LEFT JOIN user_address ua ON u.id = ua.user_id WHERE u.id = 2
    </select>

    <resultMap id="userResult"  type="com.example.zookeeper.entity.UserAndAddress">
        <result column="name" property="name"></result>
        <result column="age" property="age"></result>
        <collection property="addressDto" ofType="com.example.zookeeper.entity.AddressDto">
            <result column="address" property="address"></result>
            <result column="color" property="color"></result>
        </collection>
    </resultMap>

</mapper>

< select>标签就是我们左连接查询出来的数据，但返回给我们的UserAndAddress对象的时候就需要用resultMap标签来重新进行映射，查询结果如下：

< resultMap>标签中的的typt表示最终要返回的UserAndAddress对象的全路径类名。
< collection>标签中的property表示一对多中多的变量名，ofType表示一对多中多的对象全路径类名。

查询到的结果

{
	name: "张三",
	age: 19,
	addressDto: [
		{
			address: "木星",
			color: "棕色"
		},
		{
			address: "水星",
			color: "蓝色"
		}
	]
}

@ 一名互联网的吊车尾