sql返回多级嵌套json

ResVO

返回VO实体

@Data
@ToString
public class ResVO {
    private String id;
    private String name;
    private List<ResVO> childs;
}

resultMap

返回Map

    <resultMap id="Base_ResultMap" type="com.entity.vo.ResVO" <!-- autoMapping="true" -->>
        <!-- 父级-->
        <id column="fuId" property="id"/>
        <result column="fuId" property="id"/>
        <result column="fuName" property="name"/>
        <!-- 父级包含的_子级-->
        <collection property="childs" javaType="java.util.ArrayList" ofType="com.entity.vo.ResVO">
            <!-- 子级-->
            <result column="ziId" property="id"/>
            <result column="ziName" property="name"/>
        </collection>
        <!-- <association property="position" javaType="TPosition" columnPrefix="post_">
			<id column="id" property="id"/>
			<result column="name" property="postName"/>
			<result column="note" property="note"/>
		</association> -->
  </resultMap>

Column

返回列

    <sql id="Base_Column_List">
        ${alias}.FU_ID AS fuId,
        ${alias}.FU_NAME AS fuName,
        ${alias}.ZI_ID AS ziId,
        ${alias}.ZI_NAME AS ziName
    </sql>

SQL

select查询

    <select id="getZiListByFu" resultMap="Base_ResultMap">
        SELECT
        <!--/*+parallel(t1 4)*/-->
        <include refid="Base_Column_List">
            <property name="alias" value="t1"/>
        </include>
        FROM 表名 t1
    </select>

Json

返回示例

{
	"data": {
		"id": "1",
		"name": "天津市",
		"childs": [
			{
				"id": "101",
				"name": "和平区"
			},
			{
				"id": "102",
				"name": "河西区"
			}
		]
	}
}