SpringBoot集成Mybatis实现省市县三级联查_springboot mybatis 省市县-CSDN博客

本文链接：https://blog.csdn.net/YingRao_/article/details/122365728

XML文件

<resultMap id="ssx" type="CityEntity">
        <result property="RegionName" column="aRegionName"/>
                <collection property="citytwo" ofType="CityTwoEntity">
                    <result property="RegionName" column="bRegionName"/>
                    <collection property="citythree" ofType="CityThreeEntity">
                        <result property="RegionName" column="cRegionName"/>
                    </collection>
                </collection>
    </resultMap>

    <select id="selectCity" resultMap="ssx">
        SELECT
            a.RegionName aRegionName,
            b.RegionName bRegionName,
            c.RegionName cRegionName
        FROM
            tb_region AS a
                INNER JOIN tb_region AS b ON b.ParentId = a.RegionId
                INNER JOIN tb_region AS c ON c.ParentId = b.RegionId
        HAVING
            a.RegionName = #{RegionName};
    </select>

难点主要是嵌套查询结果，如果不理解可以复习一下Mybatis一对多多对一查询

实体类

package com.YLD.C.entity;

import lombok.Data;
import java.util.List;

@Data
public class CityEntity {
    private Integer RegionId;
    private Integer ParentId;
    private String RegionName;
    private List<CityTwoEntity> citytwo;
}