Java递归生成省市区数据结构

抚琴于山水间

已于 2024-03-26 14:18:17 修改

阅读量215

点赞数 1

文章标签： java 数据结构开发语言

于 2024-03-26 14:04:26 首次发布

本文链接：https://blog.csdn.net/qq_34229295/article/details/137044167

版权

Java递归生成省市区数据结构

在这里插入图片描述

    @PostMapping("/test")
    public ResultBean<List<SysDistrictOutDTO>> queryDistrictInfo() {
        return ResultBean.returnResponse(true, ResultCode.SERVICE_OK,commonService.test());
    }
    @Override
    public List<SysDistrictOutDTO> test() {
        //获取所有省市区数据
        List<SysDistrictOutDTO> sysDistrictOutDTOList = sdpCommonMapper.queryDistrictInfo();
        List<SysDistrictOutDTO> sysDistrictOutDTOTree = sysDistrictOutDTOList.stream().filter(sysDistrictOutDTO ->{
            //选出省级数据 2：省级 3：市级 4：区县级
            return sysDistrictOutDTO.getFtype().equals("2");
        }).map(sysDistrictOutDTO ->{
            sysDistrictOutDTO.setChildren(getDistrictChildrenInfo(sysDistrictOutDTO,sysDistrictOutDTOList));
            return sysDistrictOutDTO;
        }).sorted(Comparator.comparing(SysDistrictOutDTO::getFid)).collect(Collectors.toList());

        return sysDistrictOutDTOTree;
    }
        /**
     * 递归查找省市区子节点数据
     * @param root
     * @param all
     * @return
     */
    private List<SysDistrictOutDTO> getDistrictChildrenInfo(SysDistrictOutDTO root, List<SysDistrictOutDTO> all) {
        List<SysDistrictOutDTO> children = all.stream().filter(sysDistrictOutDTO -> sysDistrictOutDTO.getFparentid().equals(root.getFid()))
                .map(sysDistrictOutDTO  -> {
            //递归查找子节点
            sysDistrictOutDTO.setChildren(getDistrictChildrenInfo(sysDistrictOutDTO,all));
            return sysDistrictOutDTO;
        }).sorted(Comparator.comparing(SysDistrictOutDTO::getFid)).collect(Collectors.toList());

        return children;
    }
    <select id="queryDistrictInfo" resultType="com.ts.common.dto.SysDistrictOutDTO">
        select fid,fparentid,fname as value,fname as label,ftype from test where ftype in ('2','3','4')  and fisstop = 0 order by fcode asc
    </select>
    
	@Data
	@AllArgsConstructor
	@NoArgsConstructor
	public class SysDistrictOutDTO{
	
	    /**
	     * 前端展示参数
	     */
	    private String label;
	
	    /**
	     * 前端展示参数
	     */
	    private String value;
	
	    /**
	     * id
	     */
	    private String fid;
	
	    /**
	     * 父id
	     */
	    private String fparentid;
	
	    /**
	     * 类型
	     */
	    private String ftype;
	
	    //孩子节点数据
	    private List<SysDistrictOutDTO> children;
	}

/*==============================================================*/
/* Table: test                                          */
/*==============================================================*/
create table test(
   fid                  VARCHAR(255)               not null,
   fparentid            VARCHAR(255)               null,
   fcode                VARCHAR(255)               null,
   fname                VARCHAR(255)               null,
   ffullname            VARCHAR(255)               null,
   ftype                VARCHAR(255)               null,
   fisstop              INT2                       null,
   constraint PK_test primary key (fid)
);

comment on table test is
'省市区';

comment on column test.fid is
'主键id';

comment on column test.fparentid is
'父id';

comment on column test.fcode is
'代码';

comment on column test.fname is
'名称';

comment on column test.ffullname is
'全称';

comment on column test.ftype is
'类型';

comment on column test.fisstop is
'是否停用，0否 1是';

<FormItem label="不动产地址" prop="ssqs">
	<Cascader :disabled="typeCode == '2'" v-model="supplementFormConfigB.ssqs" placeholder="请选择不动产地址" change-on-select :data="CascaderFormatData" filterable transfer />
</FormItem>

formatDatahandle(row){
  queryDistrictInfoList().then((res) => {
    this.CascaderFormatData = res
    console.log(res)
  })
  
},