取出全球的主要国家城市(只有中国有省市区)

@Override
public List queryArza() {
    List shpLocationList = shpLocationDao.queryContry();//国家
    List shpLocationYSVoList = new ArrayList();
    for (ShpLocation shpLocation : shpLocationList) {
        ShpLocationYSVo shpLocationYSVo = new ShpLocationYSVo();
        shpLocationYSVo.setId(shpLocation.getId());
        shpLocationYSVo.setPid(shpLocation.getPid());
        shpLocationYSVo.setNameEn(shpLocation.getNameEn());
        shpLocationYSVo.setNamePinyin(shpLocation.getNamePinyin());
        shpLocationYSVo.setsName(shpLocation.getsName());
        shpLocationYSVoList.add(shpLocationYSVo);
        /*********以上为国家*************/
        List shpLocationStateList = new ArrayList();
        ShpLocationState shpLocationState = null;
        ShpLocation shpLocationstate = new ShpLocation();
        if (shpLocation.getsName().equals("中国")) {
            shpLocationstate.setId(shpLocation.getId());
            List shpLocationStateLists = shpLocationDao.queryNodes(shpLocationstate);//根据id查省
            for (ShpLocation shpLocation1 : shpLocationStateLists) {
                shpLocationState = new ShpLocationState();
                shpLocationState.setId(shpLocation1.getId());
                shpLocationState.setPid(shpLocation1.getPid());
                shpLocationState.setsName(shpLocation1.getsName());
                shpLocationState.setNamePinyin(shpLocation1.getNamePinyin());
                shpLocationState.setNameEn(shpLocation1.getNameEn());
                shpLocationStateList.add(shpLocationState);
                /*****************以上为省*****************/
                ShpLocation shpLocationCity = new ShpLocation();
                shpLocationCity.setId(shpLocation1.getId());
                System.out.println(shpLocation1.getPid());
                List shpLocationCityLists = shpLocationDao.queryNodes(shpLocationCity);//根据id查市
                ShpLocationCity shpLocationCitys = null;
                List shpLocationCityList = new ArrayList();
                for (ShpLocation shpLocation2 : shpLocationCityLists) {
                    shpLocationCitys = new ShpLocationCity();
                    shpLocationCitys.setId(shpLocation2.getId());
                    shpLocationCitys.setPid(shpLocation2.getPid());
                    shpLocationCitys.setsName(shpLocation2.getsName());
                    shpLocationCitys.setNamePinyin(shpLocation2.getNamePinyin());
                    shpLocationCitys.setNameEn(shpLocation2.getNameEn());
                    shpLocationCityList.add(shpLocationCitys);
                }
                shpLocationState.setCityList(shpLocationCityList);
            }
            shpLocationYSVo.setStateList(shpLocationStateList);
        }
    }
    return shpLocationYSVoList;
}

    SELECT
    
    FROM qsource_shp_location
    
        1=1
        
          AND pid=#{id,jdbcType=INTEGER}
        
        ORDER BY name_en ASC
    

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！