|-- user
    |-- address
    |-- carList
        |-- car1
        |-- car2

@Data
public class AddressPO {
    private Long id;
    /**
     * 省份
     */
    private String province;
    /**
     * 城市
     */
    private String city;
    /**
     * 街道
     */
    private String street;
}
@Data
public class CarPO {
    private Long id;
    /**
     * 顏色
     */
    private String color;
    /**
     * 品牌
     */
    private String name;
    private Long userId;
}
@Data
public class UserPO extends AbstractPO {
    private Long id;
    private String username;
    private String password;
    private Integer age;
    private GenderEnum gender;
    /**
     * 地址信息，和用戶是一對一的關(guān)系
     */
    private AddressPO address;
    /**
     * 地址id
     */
    private Long addressId;
    /**
     * 用戶擁有的車，和用戶是一對多的關(guān)系
     */
    private List<CarPO> cars;
}

CREATE TABLE IF NOT EXISTS `user`
(
    `id`          int(11)     NOT NULL AUTO_INCREMENT COMMENT '主鍵',
    `username`    varchar(20) NOT NULL UNIQUE COMMENT '用戶名',
    `password`    varchar(50) NOT NULL COMMENT '密碼',
    `age`         int(2)      NOT NULL COMMENT '年齡',
    `gender`      varchar(10) NOT NULL COMMENT '性別',
    `address_id`  int(11)              DEFAULT NULL COMMENT '地址',
    `creater`     varchar(20)          DEFAULT NULL COMMENT '創(chuàng)建人',
    `modifier`    varchar(20)          DEFAULT NULL COMMENT '更新人',
    `create_time` datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
    `modify_time` datetime    NOT NUll DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改時(shí)間',
    PRIMARY KEY (`id`),
    KEY `index_gender` (`gender`) USING BTREE COMMENT '性別'
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_bin;
CREATE TABLE IF NOT EXISTS `address`
(
    `id`       int(11) NOT NULL AUTO_INCREMENT,
    `province` varchar(50) DEFAULT NULL,
    `city`     varchar(50) DEFAULT NULL,
    `street`   varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_bin;
CREATE TABLE IF NOT EXISTS `car`
(
    `id`      int(11) NOT NULL AUTO_INCREMENT,
    `color`   varchar(50) DEFAULT NULL,
    `name`    varchar(50) DEFAULT NULL,
    `user_id` int(11)     DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_bin;
INSERT INTO `user`(username, password, age, gender, address_id)
VALUES ('KimZing', '123456', '25', 'MAN', 1), ('kim', '123456', '25', 'MAN', 2);
INSERT INTO `address`
VALUES ('1', '北京', '北京', '王府井'),
       ('2', '天津', '天津', '周良'),
       ('3', '安徽', '宿州', '涌橋'),
       ('4', '廣東', '廣州', '順德');
INSERT INTO
    `car`
VALUES
('1', 'green', '路虎', '1'),
('2', 'white', '奔馳', '2'),
('3', 'blue', '瑪莎拉蒂', '1'),
('4', 'yellow', '蘭博基尼', '2');

@Mapper
public interface AddressRepository {
    /**
     * 根據(jù)地址id查詢地址
     */
    @Select("SELECT * FROM `address` WHERE id = #{id}")
    AddressPO findAddressById(Long id);
}

@Mapper
public interface MySqlUserRepository {
    @Select("SELECT * FROM `user` WHERE id = #{id}")
    UserPO find(Long id);
}

@Mapper
public interface MySqlUserRepository {
    @Select("SELECT * FROM `user` WHERE id = #{id}")
    @Results({
    @Result(property = "address", column = "address_id",
                    one = @One(select = "com.kimzing.data.repository.AddressRepository.findAddressById"))
    })
    UserPO find(Long id);
}

@Mapper
public interface CarRepository {
    /**
     * 根據(jù)用戶id查詢所有的車
     */
    @Select("SELECT * FROM `car` WHERE user_id = #{userId}")
    List<Car> findCarsByUserId(Long userId);
}

@Mapper
public interface MySqlUserRepository {
    @Select("SELECT * FROM `user` WHERE id = #{id}")
    UserPO find(Long id);

}

package com.kimzing.data.repository.impl;
import com.kimzing.data.domain.po.UserPO;
import org.apache.ibatis.annotations.*;
import java.util.List;
/**
 * 數(shù)據(jù)存儲.
 *
 * @author KimZing - kimzing@163.com
 * @since 2020/1/31 13:12
 */
@Mapper
public interface MySqlUserRepository {
    @Select("SELECT * FROM `user` WHERE id = #{id}")
    @Results({
            @Result(property = "address", column = "address_id",
                    one = @One(select = "com.kimzing.data.repository.AddressRepository.findAddressById")),
            @Result(property = "cars", column = "id",
                    many = @Many(select = "com.kimzing.data.repository.CarRepository.findCarsByUserId"))
    }),
    // 對userId進(jìn)行賦值
    @Result(property = "id", column = "id")
    UserPO find(Long id);
}