关联查询

mapper接口:
public interface MyAddressMapper {

    /**
     * 关联查询我的所有地址
     * @param phone 用户手机号
     * @return 查询结果
     */
    MyAddress selectAddress(String phone);

}

dto:

@Data
@Component
public class MyAddress {

    private int id;
    private String password;
    private String phone;
    private String username;
    private String bornTime;
    private String sex;
    private String picture;
    private List<Address> addresses;


}

controller:
    /*-------------------  获取用户+地址信息 ---------------*/
    @GetMapping("/selectMap")
    public RespResult<MyAddress> selectMap(String phone){

        MyAddress myAddress=myAddressMapper.selectAddress(phone);
        return returnSuccess(myAddress);
    }

}

mappe.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="com.jj.springshop.mapper.MyAddressMapper">

    <sql id="showAddress">
        select member.id,member.phone,member.username,member.born_time,member.sex,member.picture,
        address.id as aId,address.phone_key,address.phone,address.username,address.province,address.city,
        address.region,address.status
    </sql>

    <resultMap id="addressMap" type="com.jj.springshop.pojo.dto.MyAddress">
        <id property="id" column="id"/>
        <result property="password" column="password"/>
        <result property="phone" column="phone"/>
        <result property="username" column="username"/>
        <result property="bornTime" column="born_time"/>
        <result property="sex" column="sex"/>
        <result property="picture" column="picture"/>

        <collection property="addresses" ofType="com.jj.springshop.pojo.entity.Address" javaType="java.util.List">
            <id property="id" column="aId"/>
            <result property="phoneKey" column="phone_key"/>
            <result property="username" column="username"/>
            <result property="phone" column="phone"/>
            <result property="province" column="province"/>
            <result property="city" column="city"/>
            <result property="region" column="region"/>
            <result property="status" column="status"/>
        </collection>

    </resultMap>

    <select id="selectAddress" resultMap="addressMap">
        <include refid="showAddress"/>
        from member left join address on member.phone=address.phone_key
        where member.phone=#{phone}
    </select>

</mapper>