java把行政区划放到一个节点树形中
作者原创：转载请注明出处。https://www.cnblogs.com/yunqing/p/9486923.html
先放数据，t_city表 //津京冀地区行政区划数据
SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for t_city -- ---------------------------- DROP TABLE IF EXISTS `t_city`; CREATE TABLE `t_city` ( `f_id` bigint(11) NOT NULL COMMENT \'主键id\', `f_code` varchar(20) NOT NULL COMMENT \'城市代码(级别代码)\', `f_name` varchar(50) NOT NULL COMMENT \'城市名称\', `f_map_pack` int(11) NOT NULL COMMENT `f_crossing_pack` int(11) NOT NULL COMMENT `f_region_code` varchar(20) NOT NULL COMMENT \'对应行政区划代码\', `f_descr` varchar(255) DEFAULT NULL COMMENT \'备注\', PRIMARY KEY (`f_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'城市表\'; -- ---------------------------- -- Records of t_city -- ---------------------------- INSERT INTO `t_city` VALUES (\'1\', \'中国\', \'中国\', \'0\', \'0\', \'中国\', \'Zhong Guo\'); INSERT INTO `t_city` VALUES (\'2\', \'110000\', \'北京市\', \'0\', \'0\', \'110000\', \'Beijing Shi\'); INSERT INTO `t_city` VALUES (\'3\', \'120000\', \'天津市\', \'0\', \'0\', \'120000\', \'Tianjin Shi\'); INSERT INTO `t_city` VALUES (\'4\', \'130000\', \'河北省\', \'0\', \'0\', \'130000\', \'Hebei Sheng\'); INSERT INTO `t_city` VALUES (\'33\', \'110100\', \'市辖区\', \'0\', \'0\', \'110100\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'34\', \'110200\', \'县\', \'0\', \'0\', \'110200\', \'Xian\'); INSERT INTO `t_city` VALUES (\'35\', \'120100\', \'市辖区\', \'0\', \'0\', \'120100\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'36\', \'120200\', \'县\', \'0\', \'0\', \'120200\', \'Xian\'); INSERT INTO `t_city` VALUES (\'37\', \'130100\', \'石家庄市\', \'0\', \'0\', \'130100\', \'Shijiazhuang Shi\'); INSERT INTO `t_city` VALUES (\'38\', \'130200\', \'唐山市\', \'0\', \'0\', \'130200\', \'Tangshan Shi\'); INSERT INTO `t_city` VALUES (\'39\', \'130300\', \'秦皇岛市\', \'0\', \'0\', \'130300\', \'Qinhuangdao Shi\'); INSERT INTO `t_city` VALUES (\'40\', \'130400\', \'邯郸市\', \'0\', \'0\', \'130400\', \'Handan Shi\'); INSERT INTO `t_city` VALUES (\'41\', \'130500\', \'邢台市\', \'0\', \'0\', \'130500\', \'Xingtai Shi\'); INSERT INTO `t_city` VALUES (\'42\', \'130600\', \'保定市\', \'0\', \'0\', \'130600\', \'Baoding Shi\'); INSERT INTO `t_city` VALUES (\'43\', \'130700\', \'张家口市\', \'0\', \'0\', \'130700\', \'Zhangjiakou Shi \'); INSERT INTO `t_city` VALUES (\'44\', \'130800\', \'承德市\', \'0\', \'0\', \'130800\', \'Chengde Shi\'); INSERT INTO `t_city` VALUES (\'45\', \'130900\', \'沧州市\', \'0\', \'0\', \'130900\', \'Cangzhou Shi\'); INSERT INTO `t_city` VALUES (\'46\', \'131000\', \'廊坊市\', \'0\', \'0\', \'131000\', \'Langfang Shi\'); INSERT INTO `t_city` VALUES (\'47\', \'131100\', \'衡水市\', \'0\', \'0\', \'131100\', \'Hengshui Shi \'); INSERT INTO `t_city` VALUES (\'378\', \'110101\', \'东城区\', \'0\', \'0\', \'110101\', \'Dongcheng Qu\'); INSERT INTO `t_city` VALUES (\'379\', \'110102\', \'西城区\', \'0\', \'0\', \'110102\', \'Xicheng Qu\'); INSERT INTO `t_city` VALUES (\'382\', \'110105\', \'朝阳区\', \'0\', \'0\', \'110105\', \'Chaoyang Qu\'); INSERT INTO `t_city` VALUES (\'383\', \'110106\', \'丰台区\', \'0\', \'0\', \'110106\', \'Fengtai Qu\'); INSERT INTO `t_city` VALUES (\'384\', \'110107\', \'石景山区\', \'0\', \'0\', \'110107\', \'Shijingshan Qu\'); INSERT INTO `t_city` VALUES (\'385\', \'110108\', \'海淀区\', \'0\', \'0\', \'110108\', \'Haidian Qu\'); INSERT INTO `t_city` VALUES (\'386\', \'110109\', \'门头沟区\', \'0\', \'0\', \'110109\', \'Mentougou Qu\'); INSERT INTO `t_city` VALUES (\'387\', \'110111\', \'房山区\', \'0\', \'0\', \'110111\', \'Fangshan Qu\'); INSERT INTO `t_city` VALUES (\'388\', \'110112\', \'通州区\', \'0\', \'0\', \'110112\', \'Tongzhou Qu\'); INSERT INTO `t_city` VALUES (\'389\', \'110113\', \'顺义区\', \'0\', \'0\', \'110113\', \'Shunyi Qu\'); INSERT INTO `t_city` VALUES (\'390\', \'110114\', \'昌平区\', \'0\', \'0\', \'110114\', \'Changping Qu\'); INSERT INTO `t_city` VALUES (\'391\', \'110115\', \'大兴区\', \'0\', \'0\', \'110115\', \'Daxing Qu\'); INSERT INTO `t_city` VALUES (\'392\', \'110116\', \'怀柔区\', \'0\', \'0\', \'110116\', \'Huairou Qu\'); INSERT INTO `t_city` VALUES (\'393\', \'110117\', \'平谷区\', \'0\', \'0\', \'110117\', \'Pinggu Qu\'); INSERT INTO `t_city` VALUES (\'394\', \'110228\', \'密云县\', \'0\', \'0\', \'110228\', \'Miyun Xian \'); INSERT INTO `t_city` VALUES (\'395\', \'110229\', \'延庆县\', \'0\', \'0\', \'110229\', \'Yanqing Xian\'); INSERT INTO `t_city` VALUES (\'396\', \'120101\', \'和平区\', \'0\', \'0\', \'120101\', \'Heping Qu\'); INSERT INTO `t_city` VALUES (\'397\', \'120102\', \'河东区\', \'0\', \'0\', \'120102\', \'Hedong Qu\'); INSERT INTO `t_city` VALUES (\'398\', \'120103\', \'河西区\', \'0\', \'0\', \'120103\', \'Hexi Qu\'); INSERT INTO `t_city` VALUES (\'399\', \'120104\', \'南开区\', \'0\', \'0\', \'120104\', \'Nankai Qu\'); INSERT INTO `t_city` VALUES (\'400\', \'120105\', \'河北区\', \'0\', \'0\', \'120105\', \'Hebei Qu\'); INSERT INTO `t_city` VALUES (\'401\', \'120106\', \'红桥区\', \'0\', \'0\', \'120106\', \'Hongqiao Qu\'); INSERT INTO `t_city` VALUES (\'404\', \'120116\', \'滨海新区\', \'0\', \'0\', \'120116\', \'Dagang Qu\'); INSERT INTO `t_city` VALUES (\'405\', \'120110\', \'东丽区\', \'0\', \'0\', \'120110\', \'Dongli Qu\'); INSERT INTO `t_city` VALUES (\'406\', \'120111\', \'西青区\', \'0\', \'0\', \'120111\', \'Xiqing Qu\'); INSERT INTO `t_city` VALUES (\'407\', \'120112\', \'津南区\', \'0\', \'0\', \'120112\', \'Jinnan Qu\'); INSERT INTO `t_city` VALUES (\'408\', \'120113\', \'北辰区\', \'0\', \'0\', \'120113\', \'Beichen Qu\'); INSERT INTO `t_city` VALUES (\'409\', \'120114\', \'武清区\', \'0\', \'0\', \'120114\', \'Wuqing Qu\'); INSERT INTO `t_city` VALUES (\'410\', \'120115\', \'宝坻区\', \'0\', \'0\', \'120115\', \'Baodi Qu\'); INSERT INTO `t_city` VALUES (\'411\', \'120221\', \'宁河县\', \'0\', \'0\', \'120221\', \'Ninghe Xian\'); INSERT INTO `t_city` VALUES (\'412\', \'120223\', \'静海县\', \'0\', \'0\', \'120223\', \'Jinghai Xian\'); INSERT INTO `t_city` VALUES (\'413\', \'120225\', \'蓟县\', \'0\', \'0\', \'120225\', \'Ji Xian\'); INSERT INTO `t_city` VALUES (\'414\', \'130101\', \'市辖区\', \'0\', \'0\', \'130101\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'415\', \'130102\', \'长安区\', \'0\', \'0\', \'130102\', \'Chang,an Qu\'); INSERT INTO `t_city` VALUES (\'416\', \'130103\', \'桥东区\', \'0\', \'0\', \'130103\', \'Qiaodong Qu\'); INSERT INTO `t_city` VALUES (\'417\', \'130104\', \'桥西区\', \'0\', \'0\', \'130104\', \'Qiaoxi Qu\'); INSERT INTO `t_city` VALUES (\'418\', \'130105\', \'新华区\', \'0\', \'0\', \'130105\', \'Xinhua Qu\'); INSERT INTO `t_city` VALUES (\'419\', \'130107\', \'井陉矿区\', \'0\', \'0\', \'130107\', \'Jingxing Kuangqu\'); INSERT INTO `t_city` VALUES (\'420\', \'130108\', \'裕华区\', \'0\', \'0\', \'130108\', \'Yuhua Qu\'); INSERT INTO `t_city` VALUES (\'421\', \'130121\', \'井陉县\', \'0\', \'0\', \'130121\', \'Jingxing Xian\'); INSERT INTO `t_city` VALUES (\'422\', \'130123\', \'正定县\', \'0\', \'0\', \'130123\', \'Zhengding Xian\'); INSERT INTO `t_city` VALUES (\'423\', \'130124\', \'栾城县\', \'0\', \'0\', \'130124\', \'Luancheng Xian\'); INSERT INTO `t_city` VALUES (\'424\', \'130125\', \'行唐县\', \'0\', \'0\', \'130125\', \'Xingtang Xian\'); INSERT INTO `t_city` VALUES (\'425\', \'130126\', \'灵寿县\', \'0\', \'0\', \'130126\', \'Lingshou Xian \'); INSERT INTO `t_city` VALUES (\'426\', \'130127\', \'高邑县\', \'0\', \'0\', \'130127\', \'Gaoyi Xian\'); INSERT INTO `t_city` VALUES (\'427\', \'130128\', \'深泽县\', \'0\', \'0\', \'130128\', \'Shenze Xian\'); INSERT INTO `t_city` VALUES (\'428\', \'130129\', \'赞皇县\', \'0\', \'0\', \'130129\', \'Zanhuang Xian\'); INSERT INTO `t_city` VALUES (\'429\', \'130130\', \'无极县\', \'0\', \'0\', \'130130\', \'Wuji Xian\'); INSERT INTO `t_city` VALUES (\'430\', \'130131\', \'平山县\', \'0\', \'0\', \'130131\', \'Pingshan Xian\'); INSERT INTO `t_city` VALUES (\'431\', \'130132\', \'元氏县\', \'0\', \'0\', \'130132\', \'Yuanshi Xian\'); INSERT INTO `t_city` VALUES (\'432\', \'130133\', \'赵县\', \'0\', \'0\', \'130133\', \'Zhao Xian\'); INSERT INTO `t_city` VALUES (\'433\', \'130181\', \'辛集市\', \'0\', \'0\', \'130181\', \'Xinji Shi\'); INSERT INTO `t_city` VALUES (\'434\', \'130182\', \'藁城市\', \'0\', \'0\', \'130182\', \'Gaocheng Shi\'); INSERT INTO `t_city` VALUES (\'435\', \'130183\', \'晋州市\', \'0\', \'0\', \'130183\', \'Jinzhou Shi\'); INSERT INTO `t_city` VALUES (\'436\', \'130184\', \'新乐市\', \'0\', \'0\', \'130184\', \'Xinle Shi\'); INSERT INTO `t_city` VALUES (\'437\', \'130185\', \'鹿泉市\', \'0\', \'0\', \'130185\', \'Luquan Shi\'); INSERT INTO `t_city` VALUES (\'438\', \'130201\', \'市辖区\', \'0\', \'0\', \'130201\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'439\', \'130202\', \'路南区\', \'0\', \'0\', \'130202\', \'Lunan Qu\'); INSERT INTO `t_city` VALUES (\'440\', \'130203\', \'路北区\', \'0\', \'0\', \'130203\', \'Lubei Qu\'); INSERT INTO `t_city` VALUES (\'441\', \'130204\', \'古冶区\', \'0\', \'0\', \'130204\', \'Guye Qu\'); INSERT INTO `t_city` VALUES (\'442\', \'130205\', \'开平区\', \'0\', \'0\', \'130205\', \'Kaiping Qu\'); INSERT INTO `t_city` VALUES (\'443\', \'130207\', \'丰南区\', \'0\', \'0\', \'130207\', \'Fengnan Qu\'); INSERT INTO `t_city` VALUES (\'444\', \'130208\', \'丰润区\', \'0\', \'0\', \'130208\', \'Fengrun Qu\'); INSERT INTO `t_city` VALUES (\'445\', \'130223\', \'滦县\', \'0\', \'0\', \'130223\', \'Luan Xian\'); INSERT INTO `t_city` VALUES (\'446\', \'130224\', \'滦南县\', \'0\', \'0\', \'130224\', \'Luannan Xian\'); INSERT INTO `t_city` VALUES (\'447\', \'130225\', \'乐亭县\', \'0\', \'0\', \'130225\', \'Leting Xian\'); INSERT INTO `t_city` VALUES (\'448\', \'130227\', \'迁西县\', \'0\', \'0\', \'130227\', \'Qianxi Xian\'); INSERT INTO `t_city` VALUES (\'449\', \'130229\', \'玉田县\', \'0\', \'0\', \'130229\', \'Yutian Xian\'); INSERT INTO `t_city` VALUES (\'450\', \'130230\', \'唐海县\', \'0\', \'0\', \'130230\', \'Tanghai Xian \'); INSERT INTO `t_city` VALUES (\'451\', \'130281\', \'遵化市\', \'0\', \'0\', \'130281\', \'Zunhua Shi\'); INSERT INTO `t_city` VALUES (\'452\', \'130283\', \'迁安市\', \'0\', \'0\', \'130283\', \'Qian,an Shi\'); INSERT INTO `t_city` VALUES (\'453\', \'130301\', \'市辖区\', \'0\', \'0\', \'130301\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'454\', \'130302\', \'海港区\', \'0\', \'0\', \'130302\', \'Haigang Qu\'); INSERT INTO `t_city` VALUES (\'455\', \'130303\', \'山海关区\', \'0\', \'0\', \'130303\', \'Shanhaiguan Qu\'); INSERT INTO `t_city` VALUES (\'456\', \'130304\', \'北戴河区\', \'0\', \'0\', \'130304\', \'Beidaihe Qu\'); INSERT INTO `t_city` VALUES (\'457\', \'130321\', \'青龙满族自治县\', \'0\', \'0\', \'130321\', \'Qinglong Manzu Zizhixian\'); INSERT INTO `t_city` VALUES (\'458\', \'130322\', \'昌黎县\', \'0\', \'0\', \'130322\', \'Changli Xian\'); INSERT INTO `t_city` VALUES (\'459\', \'130323\', \'抚宁县\', \'0\', \'0\', \'130323\', \'Funing Xian \'); INSERT INTO `t_city` VALUES (\'460\', \'130324\', \'卢龙县\', \'0\', \'0\', \'130324\', \'Lulong Xian\'); INSERT INTO `t_city` VALUES (\'461\', \'130401\', \'市辖区\', \'0\', \'0\', \'130401\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'462\', \'130402\', \'邯山区\', \'0\', \'0\', \'130402\', \'Hanshan Qu\'); INSERT INTO `t_city` VALUES (\'463\', \'130403\', \'丛台区\', \'0\', \'0\', \'130403\', \'Congtai Qu\'); INSERT INTO `t_city` VALUES (\'464\', \'130404\', \'复兴区\', \'0\', \'0\', \'130404\', \'Fuxing Qu\'); INSERT INTO `t_city` VALUES (\'465\', \'130406\', \'峰峰矿区\', \'0\', \'0\', \'130406\', \'Fengfeng Kuangqu\'); INSERT INTO `t_city` VALUES (\'466\', \'130421\', \'邯郸县\', \'0\', \'0\', \'130421\', \'Handan Xian \'); INSERT INTO `t_city` VALUES (\'467\', \'130423\', \'临漳县\', \'0\', \'0\', \'130423\', \'Linzhang Xian \'); INSERT INTO `t_city` VALUES (\'468\', \'130424\', \'成安县\', \'0\', \'0\', \'130424\', \'Cheng,an Xian\'); INSERT INTO `t_city` VALUES (\'469\', \'130425\', \'大名县\', \'0\', \'0\', \'130425\', \'Daming Xian\'); INSERT INTO `t_city` VALUES (\'470\', \'130426\', \'涉县\', \'0\', \'0\', \'130426\', \'She Xian\'); INSERT INTO `t_city` VALUES (\'471\', \'130427\', \'磁县\', \'0\', \'0\', \'130427\', \'Ci Xian\'); INSERT INTO `t_city` VALUES (\'472\', \'130428\', \'肥乡县\', \'0\', \'0\', \'130428\', \'Feixiang Xian\'); INSERT INTO `t_city` VALUES (\'473\', \'130429\', \'永年县\', \'0\', \'0\', \'130429\', \'Yongnian Xian\'); INSERT INTO `t_city` VALUES (\'474\', \'130430\', \'邱县\', \'0\', \'0\', \'130430\', \'Qiu Xian\'); INSERT INTO `t_city` VALUES (\'475\', \'130431\', \'鸡泽县\', \'0\', \'0\', \'130431\', \'Jize Xian\'); INSERT INTO `t_city` VALUES (\'476\', \'130432\', \'广平县\', \'0\', \'0\', \'130432\', \'Guangping Xian \'); INSERT INTO `t_city` VALUES (\'477\', \'130433\', \'馆陶县\', \'0\', \'0\', \'130433\', \'Guantao Xian\'); INSERT INTO `t_city` VALUES (\'478\', \'130434\', \'魏县\', \'0\', \'0\', \'130434\', \'Wei Xian \'); INSERT INTO `t_city` VALUES (\'479\', \'130435\', \'曲周县\', \'0\', \'0\', \'130435\', \'Quzhou Xian \'); INSERT INTO `t_city` VALUES (\'480\', \'130481\', \'武安市\', \'0\', \'0\', \'130481\', \'Wu,an Shi\'); INSERT INTO `t_city` VALUES (\'481\', \'130501\', \'市辖区\', \'0\', \'0\', \'130501\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'482\', \'130502\', \'桥东区\', \'0\', \'0\', \'130502\', \'Qiaodong Qu\'); INSERT INTO `t_city` VALUES (\'483\', \'130503\', \'桥西区\', \'0\', \'0\', \'130503\', \'Qiaoxi Qu\'); INSERT INTO `t_city` VALUES (\'484\', \'130521\', \'邢台县\', \'0\', \'0\', \'130521\', \'Xingtai Xian\'); INSERT INTO `t_city` VALUES (\'485\', \'130522\', \'临城县\', \'0\', \'0\', \'130522\', \'Lincheng Xian \'); INSERT INTO `t_city` VALUES (\'486\', \'130523\', \'内丘县\', \'0\', \'0\', \'130523\', \'Neiqiu Xian \'); INSERT INTO `t_city` VALUES (\'487\', \'130524\', \'柏乡县\', \'0\', \'0\', \'130524\', \'Baixiang Xian\'); INSERT INTO `t_city` VALUES (\'488\', \'130525\', \'隆尧县\', \'0\', \'0\', \'130525\', \'Longyao Xian\'); INSERT INTO `t_city` VALUES (\'489\', \'130526\', \'任县\', \'0\', \'0\', \'130526\', \'Ren Xian\'); INSERT INTO `t_city` VALUES (\'490\', \'130527\', \'南和县\', \'0\', \'0\', \'130527\', \'Nanhe Xian\'); INSERT INTO `t_city` VALUES (\'491\', \'130528\', \'宁晋县\', \'0\', \'0\', \'130528\', \'Ningjin Xian\'); INSERT INTO `t_city` VALUES (\'492\', \'130529\', \'巨鹿县\', \'0\', \'0\', \'130529\', \'Julu Xian\'); INSERT INTO `t_city` VALUES (\'493\', \'130530\', \'新河县\', \'0\', \'0\', \'130530\', \'Xinhe Xian \'); INSERT INTO `t_city` VALUES (\'494\', \'130531\', \'广宗县\', \'0\', \'0\', \'130531\', \'Guangzong Xian \'); INSERT INTO `t_city` VALUES (\'495\', \'130532\', \'平乡县\', \'0\', \'0\', \'130532\', \'Pingxiang Xian\'); INSERT INTO `t_city` VALUES (\'496\', \'130533\', \'威县\', \'0\', \'0\', \'130533\', \'Wei Xian \'); INSERT INTO `t_city` VALUES (\'497\', \'130534\', \'清河县\', \'0\', \'0\', \'130534\', \'Qinghe Xian\'); INSERT INTO `t_city` VALUES (\'498\', \'130535\', \'临西县\', \'0\', \'0\', \'130535\', \'Linxi Xian\'); INSERT INTO `t_city` VALUES (\'499\', \'130581\', \'南宫市\', \'0\', \'0\', \'130581\', \'Nangong Shi\'); INSERT INTO `t_city` VALUES (\'500\', \'130582\', \'沙河市\', \'0\', \'0\', \'130582\', \'Shahe Shi\'); INSERT INTO `t_city` VALUES (\'501\', \'130601\', \'市辖区\', \'0\', \'0\', \'130601\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'502\', \'130600\', \'新市区\', \'0\', \'0\', \'130600\', \'Xinshi Qu\'); INSERT INTO `t_city` VALUES (\'503\', \'130603\', \'北市区\', \'0\', \'0\', \'130603\', \'Beishi Qu\'); INSERT INTO `t_city` VALUES (\'504\', \'130604\', \'南市区\', \'0\', \'0\', \'130604\', \'Nanshi Qu\'); INSERT INTO `t_city` VALUES (\'505\', \'130621\', \'满城县\', \'0\', \'0\', \'130621\', \'Mancheng Xian \'); INSERT INTO `t_city` VALUES (\'506\', \'130622\', \'清苑县\', \'0\', \'0\', \'130622\', \'Qingyuan Xian\'); INSERT INTO `t_city` VALUES (\'507\', \'130623\', \'涞水县\', \'0\', \'0\', \'130623\', \'Laishui Xian\'); INSERT INTO `t_city` VALUES (\'508\', \'130624\', \'阜平县\', \'0\', \'0\', \'130624\', \'Fuping Xian \'); INSERT INTO `t_city` VALUES (\'509\', \'130625\', \'徐水县\', \'0\', \'0\', \'130625\', \'Xushui Xian \'); INSERT INTO `t_city` VALUES (\'510\', \'130626\', \'定兴县\', \'0\', \'0\', \'130626\', \'Dingxing Xian \'); INSERT INTO `t_city` VALUES (\'511\', \'130627\', \'唐县\', \'0\', \'0\', \'130627\', \'Tang Xian \'); INSERT INTO `t_city` VALUES (\'512\', \'130628\', \'高阳县\', \'0\', \'0\', \'130628\', \'Gaoyang Xian \'); INSERT INTO `t_city` VALUES (\'513\', \'130629\', \'容城县\', \'0\', \'0\', \'130629\', \'Rongcheng Xian \'); INSERT INTO `t_city` VALUES (\'514\', \'130630\', \'涞源县\', \'0\', \'0\', \'130630\', \'Laiyuan Xian \'); INSERT INTO `t_city` VALUES (\'515\', \'130631\', \'望都县\', \'0\', \'0\', \'130631\', \'Wangdu Xian \'); INSERT INTO `t_city` VALUES (\'516\', \'130632\', \'安新县\', \'0\', \'0\', \'130632\', \'Anxin Xian \'); INSERT INTO `t_city` VALUES (\'517\', \'130633\', \'易县\', \'0\', \'0\', \'130633\', \'Yi Xian\'); INSERT INTO `t_city` VALUES (\'518\', \'130634\', \'曲阳县\', \'0\', \'0\', \'130634\', \'Quyang Xian \'); INSERT INTO `t_city` VALUES (\'519\', \'130635\', \'蠡县\', \'0\', \'0\', \'130635\', \'Li Xian\'); INSERT INTO `t_city` VALUES (\'520\', \'130636\', \'顺平县\', \'0\', \'0\', \'130636\', \'Shunping Xian \'); INSERT INTO `t_city` VALUES (\'521\', \'130637\', \'博野县\', \'0\', \'0\', \'130637\', \'Boye Xian \'); INSERT INTO `t_city` VALUES (\'522\', \'130638\', \'雄县\', \'0\', \'0\', \'130638\', \'Xiong Xian\'); INSERT INTO `t_city` VALUES (\'523\', \'130681\', \'涿州市\', \'0\', \'0\', \'130681\', \'Zhuozhou Shi\'); INSERT INTO `t_city` VALUES (\'524\', \'130682\', \'定州市\', \'0\', \'0\', \'130682\', \'Dingzhou Shi \'); INSERT INTO `t_city` VALUES (\'525\', \'130683\', \'安国市\', \'0\', \'0\', \'130683\', \'Anguo Shi \'); INSERT INTO `t_city` VALUES (\'526\', \'130684\', \'高碑店市\', \'0\', \'0\', \'130684\', \'Gaobeidian Shi\'); INSERT INTO `t_city` VALUES (\'527\', \'130701\', \'市辖区\', \'0\', \'0\', \'130701\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'528\', \'130702\', \'桥东区\', \'0\', \'0\', \'130702\', \'Qiaodong Qu\'); INSERT INTO `t_city` VALUES (\'529\', \'130703\', \'桥西区\', \'0\', \'0\', \'130703\', \'Qiaoxi Qu\'); INSERT INTO `t_city` VALUES (\'530\', \'130705\', \'宣化区\', \'0\', \'0\', \'130705\', \'Xuanhua Qu\'); INSERT INTO `t_city` VALUES (\'531\', \'130706\', \'下花园区\', \'0\', \'0\', \'130706\', \'Xiahuayuan Qu \'); INSERT INTO `t_city` VALUES (\'532\', \'130721\', \'宣化县\', \'0\', \'0\', \'130721\', \'Xuanhua Xian \'); INSERT INTO `t_city` VALUES (\'533\', \'130722\', \'张北县\', \'0\', \'0\', \'130722\', \'Zhangbei Xian \'); INSERT INTO `t_city` VALUES (\'534\', \'130723\', \'康保县\', \'0\', \'0\', \'130723\', \'Kangbao Xian\'); INSERT INTO `t_city` VALUES (\'535\', \'130724\', \'沽源县\', \'0\', \'0\', \'130724\', \'Guyuan Xian\'); INSERT INTO `t_city` VALUES (\'536\', \'130725\', \'尚义县\', \'0\', \'0\', \'130725\', \'Shangyi Xian\'); INSERT INTO `t_city` VALUES (\'537\', \'130726\', \'蔚县\', \'0\', \'0\', \'130726\', \'Yu Xian\'); INSERT INTO `t_city` VALUES (\'538\', \'130727\', \'阳原县\', \'0\', \'0\', \'130727\', \'Yangyuan Xian\'); INSERT INTO `t_city` VALUES (\'539\', \'130728\', \'怀安县\', \'0\', \'0\', \'130728\', \'Huai,an Xian\'); INSERT INTO `t_city` VALUES (\'540\', \'130729\', \'万全县\', \'0\', \'0\', \'130729\', \'Wanquan Xian \'); INSERT INTO `t_city` VALUES (\'541\', \'130730\', \'怀来县\', \'0\', \'0\', \'130730\', \'Huailai Xian\'); INSERT INTO `t_city` VALUES (\'542\', \'130731\', \'涿鹿县\', \'0\', \'0\', \'130731\', \'Zhuolu Xian \'); INSERT INTO `t_city` VALUES (\'543\', \'130732\', \'赤城县\', \'0\', \'0\', \'130732\', \'Chicheng Xian\'); INSERT INTO `t_city` VALUES (\'544\', \'130733\', \'崇礼县\', \'0\', \'0\', \'130733\', \'Chongli Xian\'); INSERT INTO `t_city` VALUES (\'545\', \'130801\', \'市辖区\', \'0\', \'0\', \'130801\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'546\', \'130802\', \'双桥区\', \'0\', \'0\', \'130802\', \'Shuangqiao Qu \'); INSERT INTO `t_city` VALUES (\'547\', \'130803\', \'双滦区\', \'0\', \'0\', \'130803\', \'Shuangluan Qu\'); INSERT INTO `t_city` VALUES (\'548\', \'130804\', \'鹰手营子矿区\', \'0\', \'0\', \'130804\', \'Yingshouyingzi Kuangqu\'); INSERT INTO `t_city` VALUES (\'549\', \'130821\', \'承德县\', \'0\', \'0\', \'130821\', \'Chengde Xian\'); INSERT INTO `t_city` VALUES (\'550\', \'130822\', \'兴隆县\', \'0\', \'0\', \'130822\', \'Xinglong Xian\'); INSERT INTO `t_city` VALUES (\'551\', \'130823\', \'平泉县\', \'0\', \'0\', \'130823\', \'Pingquan Xian\'); INSERT INTO `t_city` VALUES (\'552\', \'130824\', \'滦平县\', \'0\', \'0\', \'130824\', \'Luanping Xian \'); INSERT INTO `t_city` VALUES (\'553\', \'130825\', \'隆化县\', \'0\', \'0\', \'130825\', \'Longhua Xian\'); INSERT INTO `t_city` VALUES (\'554\', \'130826\', \'丰宁满族自治县\', \'0\', \'0\', \'130826\', \'Fengning Manzu Zizhixian\'); INSERT INTO `t_city` VALUES (\'555\', \'130827\', \'宽城满族自治县\', \'0\', \'0\', \'130827\', \'Kuancheng Manzu Zizhixian\'); INSERT INTO `t_city` VALUES (\'556\', \'130828\', \'围场满族蒙古族自治县\', \'0\', \'0\', \'130828\', \'Weichang Manzu Menggolzu Zizhixian\'); INSERT INTO `t_city` VALUES (\'557\', \'130901\', \'市辖区\', \'0\', \'0\', \'130901\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'558\', \'130902\', \'新华区\', \'0\', \'0\', \'130902\', \'Xinhua Qu\'); INSERT INTO `t_city` VALUES (\'559\', \'130903\', \'运河区\', \'0\', \'0\', \'130903\', \'Yunhe Qu\'); INSERT INTO `t_city` VALUES (\'560\', \'130921\', \'沧县\', \'0\', \'0\', \'130921\', \'Cang Xian\'); INSERT INTO `t_city` VALUES (\'561\', \'130922\', \'青县\', \'0\', \'0\', \'130922\', \'Qing Xian\'); INSERT INTO `t_city` VALUES (\'562\', \'130923\', \'东光县\', \'0\', \'0\', \'130923\', \'Dongguang Xian \'); INSERT INTO `t_city` VALUES (\'563\', \'130924\', \'海兴县\', \'0\', \'0\', \'130924\', \'Haixing Xian\'); INSERT INTO `t_city` VALUES (\'564\', \'130925\', \'盐山县\', \'0\', \'0\', \'130925\', \'Yanshan Xian\'); INSERT INTO `t_city` VALUES (\'565\', \'130926\', \'肃宁县\', \'0\', \'0\', \'130926\', \'Suning Xian \'); INSERT INTO `t_city` VALUES (\'566\', \'130927\', \'南皮县\', \'0\', \'0\', \'130927\', \'Nanpi Xian\'); INSERT INTO `t_city` VALUES (\'567\', \'130928\', \'吴桥县\', \'0\', \'0\', \'130928\', \'Wuqiao Xian \'); INSERT INTO `t_city` VALUES (\'568\', \'130929\', \'献县\', \'0\', \'0\', \'130929\', \'Xian Xian \'); INSERT INTO `t_city` VALUES (\'569\', \'130930\', \'孟村回族自治县\', \'0\', \'0\', \'130930\', \'Mengcun Huizu Zizhixian\'); INSERT INTO `t_city` VALUES (\'570\', \'130981\', \'泊头市\', \'0\', \'0\', \'130981\', \'Botou Shi \'); INSERT INTO `t_city` VALUES (\'571\', \'130982\', \'任丘市\', \'0\', \'0\', \'130982\', \'Renqiu Shi\'); INSERT INTO `t_city` VALUES (\'572\', \'130983\', \'黄骅市\', \'0\', \'0\', \'130983\', \'Huanghua Shi\'); INSERT INTO `t_city` VALUES (\'573\', \'130984\', \'河间市\', \'0\', \'0\', \'130984\', \'Hejian Shi\'); INSERT INTO `t_city` VALUES (\'574\', \'131001\', \'市辖区\', \'0\', \'0\', \'131001\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'575\', \'131002\', \'安次区\', \'0\', \'0\', \'131002\', \'Anci Qu\'); INSERT INTO `t_city` VALUES (\'576\', \'131003\', \'广阳区\', \'0\', \'0\', \'131003\', \'Guangyang Qu\'); INSERT INTO `t_city` VALUES (\'577\', \'131022\', \'固安县\', \'0\', \'0\', \'131022\', \'Gu,an Xian\'); INSERT INTO `t_city` VALUES (\'578\', \'131023\', \'永清县\', \'0\', \'0\', \'131023\', \'Yongqing Xian \'); INSERT INTO `t_city` VALUES (\'579\', \'131024\', \'香河县\', \'0\', \'0\', \'131024\', \'Xianghe Xian\'); INSERT INTO `t_city` VALUES (\'580\', \'131025\', \'大城县\', \'0\', \'0\', \'131025\', \'Dacheng Xian\'); INSERT INTO `t_city` VALUES (\'581\', \'131026\', \'文安县\', \'0\', \'0\', \'131026\', \'Wen,an Xian\'); INSERT INTO `t_city` VALUES (\'582\', \'131028\', \'大厂回族自治县\', \'0\', \'0\', \'131028\', \'Dachang Huizu Zizhixian\'); INSERT INTO `t_city` VALUES (\'583\', \'131081\', \'霸州市\', \'0\', \'0\', \'131081\', \'Bazhou Shi\'); INSERT INTO `t_city` VALUES (\'584\', \'131082\', \'三河市\', \'0\', \'0\', \'131082\', \'Sanhe Shi\'); INSERT INTO `t_city` VALUES (\'585\', \'131101\', \'市辖区\', \'0\', \'0\', \'131101\', \'Shixiaqu\'); INSERT INTO `t_city` VALUES (\'586\', \'131102\', \'桃城区\', \'0\', \'0\', \'131102\', \'Taocheng Qu\'); INSERT INTO `t_city` VALUES (\'587\', \'131121\', \'枣强县\', \'0\', \'0\', \'131121\', \'Zaoqiang Xian \'); INSERT INTO `t_city` VALUES (\'588\', \'131122\', \'武邑县\', \'0\', \'0\', \'131122\', \'Wuyi Xian\'); INSERT INTO `t_city` VALUES (\'589\', \'131123\', \'武强县\', \'0\', \'0\', \'131123\', \'Wuqiang Xian \'); INSERT INTO `t_city` VALUES (\'590\', \'131124\', \'饶阳县\', \'0\', \'0\', \'131124\', \'Raoyang Xian\'); INSERT INTO `t_city` VALUES (\'591\', \'131125\', \'安平县\', \'0\', \'0\', \'131125\', \'Anping Xian\'); INSERT INTO `t_city` VALUES (\'592\', \'131126\', \'故城县\', \'0\', \'0\', \'131126\', \'Gucheng Xian\'); INSERT INTO `t_city` VALUES (\'593\', \'131127\', \'景县\', \'0\', \'0\', \'131127\', \'Jing Xian \'); INSERT INTO `t_city` VALUES (\'594\', \'131128\', \'阜城县\', \'0\', \'0\', \'131128\', \'Fucheng Xian \'); INSERT INTO `t_city` VALUES (\'595\', \'131181\', \'冀州市\', \'0\', \'0\', \'131181\', \'Jizhou Shi \'); INSERT INTO `t_city` VALUES (\'596\', \'131182\', \'深州市\', \'0\', \'0\', \'131182\', \'Shenzhou Shi\');
1.创建一个树形结构类
public class TreeVo {
private Long id;
private String code;
private String name;
private List<TreeVo> nodes;
@Override
public Long id() {
return id;
}
@Override
public TreeVo id(Long id) {
this.id = id;
return (TreeVo) this;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public List<TreeVo> getNodes() {
return nodes;
}
public void setNodes(List<TreeVo> nodes) {
this.nodes = nodes;
}
}
2.城市实体类
略。。。看数据库自己建立
3.数据处理—-查询出来city信息，装进TreeVo中
@RequestMapping(value = "/findTree", method = { RequestMethod.GET })
public Map<String,Object> findTree() {
Map<String,Object> map = new HashMap<String, Object>();
List<City> citys=cityService.findAll(Sort.by(Direction.ASC, "code"), null);
List<TreeVo> baseTreeList=findTree(citys);
map.put("tree", baseTreeList);
return map;
}
public List<TreeVo> findTree(List<City> citys) {
//过滤掉顶级中国
List<City> cityList = citys.stream().filter(e->!e.getName().equals("中国") && !e.equals(null)).collect(Collectors.toList());
List<TreeVo> baseTreeList = new ArrayList<>();
List<TreeVo> secondTreeList = new ArrayList<>();
List<TreeVo> thirdTreeList = new ArrayList<>();
for (City city : cityList) {
//String codeTmp1 = city.getCode().substring(0, 2);
String codeTmp2 = city.getCode().substring(2, 4);
String codeTmp3 = city.getCode().substring(4, 6);
//找到根节点。
if (codeTmp2.equals("00") && codeTmp3.equals("00")) {
TreeVo baseTree = new TreeVo();
baseTree.setCode(city.getCode());
baseTree.setName(city.getName());
baseTreeList.add(baseTree);
}else if(codeTmp3.equals("00")) {//找到二级节点
TreeVo secondTree = new TreeVo();
secondTree.setCode(city.getCode());
secondTree.setName(city.getName());
secondTreeList.add(secondTree);
}else {//剩下的是三级节点
TreeVo thirdTree = new TreeVo();
thirdTree.setCode(city.getCode());
thirdTree.setName(city.getName());
thirdTreeList.add(thirdTree);
}
}
//遍历二级节点
for(TreeVo secondTree : secondTreeList) {
//获取二级节点前4位
String secondTree0_4 = secondTree.getCode().substring(0, 4);
//遍历3级节点，找出前4位与2级节点相同的
List<TreeVo> tempList = thirdTreeList.stream()
.filter(e->e.getCode().substring(0, 4).equals(secondTree0_4))
.collect(Collectors.toList());
//设置二级节点的三级节点
secondTree.setNodes(tempList);
}
//遍历根节点
for(TreeVo baseTree : baseTreeList) {
//获取根节点的前两位
String baseTree0_2 = baseTree.getCode().substring(0, 2);
//遍历2级节点，找出前两位与根节点相同的
List<TreeVo> tempList = secondTreeList.stream()
.filter(e->e.getCode().substring(0, 2).equals(baseTree0_2))
.collect(Collectors.toList());
//设置根节点的二级节点
baseTree.setNodes(tempList);
}
return baseTreeList;
}
4.最后得到的json数据：https://www.json.cn/ 拷贝到此查看结果
{"tree":[{"id":null,"code":"110000","name":"北京市","nodes":[{"id":null,"code":"110100","name":"市辖区","nodes":[{"id":null,"code":"110101","name":"东城区","nodes":null},{"id":null,"code":"110102","name":"西城区","nodes":null},
{"id":null,"code":"110105","name":"朝阳区","nodes":null},{"id":null,"code":"110106","name":"丰台区","nodes":null},{"id":null,"code":"110107","name":"石景山区","nodes":null},{"id":null,"code":"110108","name":"海淀区","nodes":null},
{"id":null,"code":"110109","name":"门头沟区","nodes":null},{"id":null,"code":"110111","name":"房山区","nodes":null},{"id":null,"code":"110112","name":"通州区","nodes":null},{"id":null,"code":"110113","name":"顺义区","nodes":null},
{"id":null,"code":"110114","name":"昌平区","nodes":null},{"id":null,"code":"110115","name":"大兴区","nodes":null},{"id":null,"code":"110116","name":"怀柔区","nodes":null},{"id":null,"code":"110117","name":"平谷区","nodes":null}]},
{"id":null,"code":"110200","name":"县","nodes":[{"id":null,"code":"110228","name":"密云县","nodes":null},{"id":null,"code":"110229","name":"延庆县","nodes":null}]}]},{"id":null,"code":"120000","name":"天津市",
"nodes":[{"id":null,"code":"120100","name":"市辖区","nodes":[{"id":null,"code":"120101","name":"和平区","nodes":null},{"id":null,"code":"120102","name":"河东区","nodes":null},{"id":null,"code":"120103","name":"河西区","nodes":null},
{"id":null,"code":"120104","name":"南开区","nodes":null},{"id":null,"code":"120105","name":"河北区","nodes":null},{"id":null,"code":"120106","name":"红桥区","nodes":null},{"id":null,"code":"120110","name":"东丽区","nodes":null},
{"id":null,"code":"120111","name":"西青区","nodes":null},{"id":null,"code":"120112","name":"津南区","nodes":null},{"id":null,"code":"120113","name":"北辰区","nodes":null},{"id":null,"code":"120114","name":"武清区","nodes":null},
{"id":null,"code":"120115","name":"宝坻区","nodes":null},{"id":null,"code":"120116","name":"滨海新区","nodes":null}]},{"id":null,"code":"120200","name":"县","nodes":[{"id":null,"code":"120221","name":"宁河县","nodes":null},
{"id":null,"code":"120223","name":"静海县","nodes":null},{"id":null,"code":"120225","name":"蓟县","nodes":null}]}]},{"id":null,"code":"130000","name":"河北省","nodes":[{"id":null,"code":"130100","name":"石家庄市",
"nodes":[{"id":null,"code":"130101","name":"市辖区","nodes":null},{"id":null,"code":"130102","name":"长安区","nodes":null},{"id":null,"code":"130103","name":"桥东区","nodes":null},{"id":null,"code":"130104",
"name":"桥西区","nodes":null},{"id":null,"code":"130105","name":"新华区","nodes":null},{"id":null,"code":"130107","name":"井陉矿区","nodes":null},{"id":null,"code":"130108","name":"裕华区","nodes":null},
{"id":null,"code":"130121","name":"井陉县","nodes":null},{"id":null,"code":"130123","name":"正定县","nodes":null},{"id":null,"code":"130124","name":"栾城县","nodes":null},{"id":null,"code":"130125","name":"行唐县","nodes":null},
{"id":null,"code":"130126","name":"灵寿县","nodes":null},{"id":null,"code":"130127","name":"高邑县","nodes":null},{"id":null,"code":"130128","name":"深泽县","nodes":null},{"id":null,"code":"130129","name":"赞皇县","nodes":null},
{"id":null,"code":"130130","name":"无极县","nodes":null},{"id":null,"code":"130131","name":"平山县","nodes":null},{"id":null,"code":"130132","name":"元氏县","nodes":null},{"id":null,"code":"130133","name":"赵县","nodes":null},
{"id":null,"code":"130181","name":"辛集市","nodes":null},{"id":null,"code":"130182","name":"藁城市","nodes":null},{"id":null,"code":"130183","name":"晋州市","nodes":null},{"id":null,"code":"130184","name":"新乐市","nodes":null},
{"id":null,"code":"130185","name":"鹿泉市","nodes":null}]},{"id":null,"code":"130200","name":"唐山市","nodes":[{"id":null,"code":"130201","name":"市辖区","nodes":null},{"id":null,"code":"130202","name":"路南区","nodes":null},
{"id":null,"code":"130203","name":"路北区","nodes":null},{"id":null,"code":"130204","name":"古冶区","nodes":null},{"id":null,"code":"130205","name":"开平区","nodes":null},{"id":null,"code":"130207","name":"丰南区","nodes":null},
{"id":null,"code":"130208","name":"丰润区","nodes":null},{"id":null,"code":"130223","name":"滦县","nodes":null},{"id":null,"code":"130224","name":"滦南县","nodes":null},{"id":null,"code":"130225","name":"乐亭县","nodes":null},
{"id":null,"code":"130227","name":"迁西县","nodes":null},{"id":null,"code":"130229","name":"玉田县","nodes":null},{"id":null,"code":"130230","name":"唐海县","nodes":null},{"id":null,"code":"130281","name":"遵化市","nodes":null},
{"id":null,"code":"130283","name":"迁安市","nodes":null}]},{"id":null,"code":"130300","name":"秦皇岛市","nodes":[{"id":null,"code":"130301","name":"市辖区","nodes":null},{"id":null,"code":"130302","name":"海港区","nodes":null},
{"id":null,"code":"130303","name":"山海关区","nodes":null},{"id":null,"code":"130304","name":"北戴河区","nodes":null},{"id":null,"code":"130321","name":"青龙满族自治县","nodes":null},{"id":null,"code":"130322","name":"昌黎县",
"nodes":null},{"id":null,"code":"130323","name":"抚宁县","nodes":null},{"id":null,"code":"130324","name":"卢龙县","nodes":null}]},{"id":null,"code":"130400","name":"邯郸市","nodes":[{"id":null,"code":"130401","name":"市辖区",
"nodes":null},{"id":null,"code":"130402","name":"邯山区","nodes":null},{"id":null,"code":"130403","name":"丛台区","nodes":null},{"id":null,"code":"130404","name":"复兴区","nodes":null},{"id":null,"code":"130406","name":"峰峰矿区",
"nodes":null},{"id":null,"code":"130421","name":"邯郸县","nodes":null},{"id":null,"code":"130423","name":"临漳县","nodes":null},{"id":null,"code":"130424","name":"成安县","nodes":null},{"id":null,"code":"130425","name":"大名县",
"nodes":null},{"id":null,"code":"130426","name":"涉县","nodes":null},{"id":null,"code":"130427","name":"磁县","nodes":null},{"id":null,"code":"130428","name":"肥乡县","nodes":null},{"id":null,"code":"130429","name":"永年县",
"nodes":null},{"id":null,"code":"130430","name":"邱县","nodes":null},{"id":null,"code":"130431","name":"鸡泽县","nodes":null},{"id":null,"code":"130432","name":"广平县","nodes":null},{"id":null,"code":"130433","name":"馆陶县",
"nodes":null},{"id":null,"code":"130434","name":"魏县","nodes":null},{"id":null,"code":"130435","name":"曲周县","nodes":null},{"id":null,"code":"130481","name":"武安市","nodes":null}]},{"id":null,"code":"130500","name":"邢台市",
"nodes":[{"id":null,"code":"130501","name":"市辖区","nodes":null},{"id":null,"code":"130502","name":"桥东区","nodes":null},{"id":null,"code":"130503","name":"桥西区","nodes":null},{"id":null,"code":"130521","name":"邢台县",
"nodes":null},{"id":null,"code":"130522","name":"临城县","nodes":null},{"id":null,"code":"130523","name":"内丘县","nodes":null},{"id":null,"code":"130524","name":"柏乡县","nodes":null},{"id":null,"code":"130525","name":"隆尧县",
"nodes":null},{"id":null,"code":"130526","name":"任县","nodes":null},{"id":null,"code":"130527","name":"南和县","nodes":null},{"id":null,"code":"130528","name":"宁晋县","nodes":null},{"id":null,"code":"130529","name":"巨鹿县",
"nodes":null},{"id":null,"code":"130530","name":"新河县","nodes":null},{"id":null,"code":"130531","name":"广宗县","nodes":null},{"id":null,"code":"130532","name":"平乡县","nodes":null},{"id":null,"code":"130533","name":"威县",
"nodes":null},{"id":null,"code":"130534","name":"清河县","nodes":null},{"id":null,"code":"130535","name":"临西县","nodes":null},{"id":null,"code":"130581","name":"南宫市","nodes":null},{"id":null,"code":"130582","name":"沙河市",
"nodes":null}]},{"id":null,"code":"130600","name":"保定市","nodes":[{"id":null,"code":"130601","name":"市辖区","nodes":null},{"id":null,"code":"130603","name":"北市区","nodes":null},{"id":null,"code":"130604","name":"南市区",
"nodes":null},{"id":null,"code":"130621","name":"满城县","nodes":null},{"id":null,"code":"130622","name":"清苑县","nodes":null},{"id":null,"code":"130623","name":"涞水县","nodes":null},{"id":null,"code":"130624","name":"阜平县",
"nodes":null},{"id":null,"code":"130625","name":"徐水县","nodes":null},{"id":null,"code":"130626","name":"定兴县","nodes":null},{"id":null,"code":"130627","name":"唐县","nodes":null},{"id":null,"code":"130628","name":"高阳县",
"nodes":null},{"id":null,"code":"130629","name":"容城县","nodes":null},{"id":null,"code":"130630","name":"涞源县","nodes":null},{"id":null,"code":"130631","name":"望都县","nodes":null},{"id":null,"code":"130632","name":"安新县",
"nodes":null},{"id":null,"code":"130633","name":"易县","nodes":null},{"id":null,"code":"130634","name":"曲阳县","nodes":null},{"id":null,"code":"130635","name":"蠡县","nodes":null},{"id":null,"code":"130636","name":"顺平县",
"nodes":null},{"id":null,"code":"130637","name":"博野县","nodes":null},{"id":null,"code":"130638","name":"雄县","nodes":null},{"id":null,"code":"130681","name":"涿州市","nodes":null},{"id":null,"code":"130682","name":"定州市",
"nodes":null},{"id":null,"code":"130683","name":"安国市","nodes":null},{"id":null,"code":"130684","name":"高碑店市","nodes":null}]},{"id":null,"code":"130600","name":"新市区","nodes":[{"id":null,"code":"130601","name":"市辖区",
"nodes":null},{"id":null,"code":"130603","name":"北市区","nodes":null},{"id":null,"code":"130604","name":"南市区","nodes":null},{"id":null,"code":"130621","name":"满城县","nodes":null},{"id":null,"code":"130622","name":"清苑县",
"nodes":null},{"id":null,"code":"130623","name":"涞水县","nodes":null},{"id":null,"code":"130624","name":"阜平县","nodes":null},{"id":null,"code":"130625","name":"徐水县","nodes":null},{"id":null,"code":"130626","name":"定兴县",
"nodes":null},{"id":null,"code":"130627","name":"唐县","nodes":null},{"id":null,"code":"130628","name":"高阳县","nodes":null},{"id":null,"code":"130629","name":"容城县","nodes":null},{"id":null,"code":"130630","name":"涞源县",
"nodes":null},{"id":null,"code":"130631","name":"望都县","nodes":null},{"id":null,"code":"130632","name":"安新县","nodes":null},{"id":null,"code":"130633","name":"易县","nodes":null},{"id":null,"code":"130634","name":"曲阳县",
"nodes":null},{"id":null,"code":"130635","name":"蠡县","nodes":null},{"id":null,"code":"130636","name":"顺平县","nodes":null},{"id":null,"code":"130637","name":"博野县","nodes":null},{"id":null,"code":"130638","name":"雄县",
"nodes":null},{"id":null,"code":"130681","name":"涿州市","nodes":null},{"id":null,"code":"130682","name":"定州市","nodes":null},{"id":null,"code":"130683","name":"安国市","nodes":null},{"id":null,"code":"130684","name":"高碑店市",
"nodes":null}]},{"id":null,"code":"130700","name":"张家口市","nodes":[{"id":null,"code":"130701","name":"市辖区","nodes":null},{"id":null,"code":"130702","name":"桥东区","nodes":null},{"id":null,"code":"130703","name":"桥西区",
"nodes":null},{"id":null,"code":"130705","name":"宣化区","nodes":null},{"id":null,"code":"130706","name":"下花园区","nodes":null},{"id":null,"code":"130721","name":"宣化县","nodes":null},{"id":null,"code":"130722","name":"张北县",
"nodes":null},{"id":null,"code":"130723","name":"康保县","nodes":null},{"id":null,"code":"130724","name":"沽源县","nodes":null},{"id":null,"code":"130725","name":"尚义县","nodes":null},{"id":null,"code":"130726","name":"蔚县",
"nodes":null},{"id":null,"code":"130727","name":"阳原县","nodes":null},{"id":null,"code":"130728","name":"怀安县","nodes":null},{"id":null,"code":"130729","name":"万全县","nodes":null},{"id":null,"code":"130730","name":"怀来县",
"nodes":null},{"id":null,"code":"130731","name":"涿鹿县","nodes":null},{"id":null,"code":"130732","name":"赤城县","nodes":null},{"id":null,"code":"130733","name":"崇礼县","nodes":null}]},{"id":null,"code":"130800","name":"承德市",
"nodes":[{"id":null,"code":"130801","name":"市辖区","nodes":null},{"id":null,"code":"130802","name":"双桥区","nodes":null},{"id":null,"code":"130803","name":"双滦区","nodes":null},{"id":null,"code":"130804","name":"鹰手营子矿区",
"nodes":null},{"id":null,"code":"130821","name":"承德县","nodes":null},{"id":null,"code":"130822","name":"兴隆县","nodes":null},{"id":null,"code":"130823","name":"平泉县","nodes":null},{"id":null,"code":"130824","name":"滦平县",
"nodes":null},{"id":null,"code":"130825","name":"隆化县","nodes":null},{"id":null,"code":"130826","name":"丰宁满族自治县","nodes":null},{"id":null,"code":"130827","name":"宽城满族自治县","nodes":null},{"id":null,"code":"130828",
"name":"围场满族蒙古族自治县","nodes":null}]},{"id":null,"code":"130900","name":"沧州市","nodes":[{"id":null,"code":"130901","name":"市辖区","nodes":null},{"id":null,"code":"130902","name":"新华区","nodes":null},
{"id":null,"code":"130903","name":"运河区","nodes":null},{"id":null,"code":"130921","name":"沧县","nodes":null},{"id":null,"code":"130922","name":"青县","nodes":null},{"id":null,"code":"130923","name":"东光县","nodes":null},
{"id":null,"code":"130924","name":"海兴县","nodes":null},{"id":null,"code":"130925","name":"盐山县","nodes":null},{"id":null,"code":"130926","name":"肃宁县","nodes":null},{"id":null,"code":"130927","name":"南皮县","nodes":null},
{"id":null,"code":"130928","name":"吴桥县","nodes":null},{"id":null,"code":"130929","name":"献县","nodes":null},{"id":null,"code":"130930","name":"孟村回族自治县","nodes":null},{"id":null,"code":"130981","name":"泊头市","nodes":null},
{"id":null,"code":"130982","name":"任丘市","nodes":null},{"id":null,"code":"130983","name":"黄骅市","nodes":null},{"id":null,"code":"130984","name":"河间市","nodes":null}]},{"id":null,"code":"131000","name":"廊坊市",
"nodes":[{"id":null,"code":"131001","name":"市辖区","nodes":null},{"id":null,"code":"131002","name":"安次区","nodes":null},{"id":null,"code":"131003","name":"广阳区","nodes":null},{"id":null,"code":"131022","name":"固安县",
"nodes":null},{"id":null,"code":"131023","name":"永清县","nodes":null},{"id":null,"code":"131024","name":"香河县","nodes":null},{"id":null,"code":"131025","name":"大城县","nodes":null},{"id":null,"code":"131026","name":"文安县",
"nodes":null},{"id":null,"code":"131028","name":"大厂回族自治县","nodes":null},{"id":null,"code":"131081","name":"霸州市","nodes":null},{"id":null,"code":"131082","name":"三河市","nodes":null}]},{"id":null,"code":"131100",
"name":"衡水市","nodes":[{"id":null,"code":"131101","name":"市辖区","nodes":null},{"id":null,"code":"131102","name":"桃城区","nodes":null},{"id":null,"code":"131121","name":"枣强县","nodes":null},{"id":null,"code":"131122",
"name":"武邑县","nodes":null},{"id":null,"code":"131123","name":"武强县","nodes":null},{"id":null,"code":"131124","name":"饶阳县","nodes":null},{"id":null,"code":"131125","name":"安平县","nodes":null},{"id":null,"code":"131126",
"name":"故城县","nodes":null},{"id":null,"code":"131127","name":"景县","nodes":null},{"id":null,"code":"131128","name":"阜城县","nodes":null},{"id":null,"code":"131181","name":"冀州市","nodes":null},{"id":null,"code":"131182",
"name":"深州市","nodes":null}]}]}]}
显示在页面
var togt=rock.initializeServices("tonsel-togt","../../togt-vehicle-manager/",["trafficInfo"]);
window.onload = function() {
map = new AMap.Map(\'container\', {
resizeEnable : true,
center : [116.397428, 39.90923], // 地图中心点
zoom : 13,
});
}
//获取树形菜单的数据
var service=togt.findService("trafficInfo");
service.addMethod("findTree","GET",true);
service.findTree({},function(jsonResult,status){
if (jsonResult.hasError)
{
alert(jsonResult.errorText);
}else if (jsonResult.notNull)
{
var tableDate = jsonResult.result;
selectMume(tableDate);
}else
{
alert("数据查询失败!");
}
});
var cityCode,timer;
//以树形显示出来，包括模糊查询
function selectMume(tableDate){
var initSearchableTree = function() {
return $(\'#treeview-searchable\').treeview({
data: tableDate,
nodeIcon: \'glyphicon glyphicon-globe\',
emptyIcon: \'\', //没有子节点的节点图标
//collapsed: true,
onNodeSelected:function(event,data) {
cityCode=data.code;
if(timer){
//删除定时器
clearTimeout(timer);
}
if(cityCode!=null){
window.onload();
moveMap(cityCode);
showDrivingRecond();
//定义一个定时器
timer = window.setInterval(showDrivingRecond,10000);
}
}
});
};
var $searchableTree = initSearchableTree();
$(\'#treeview-searchable\').treeview(\'collapseAll\', {
silent : false//设置初始化节点关闭
});
var findSearchableNodes = function() {
return $searchableTree.treeview(\'search\', [ $.trim($(\'#input-search\').val()), { ignoreCase: false, exactMatch: false } ]);
};
var searchableNodes = findSearchableNodes();
// Select/unselect/toggle nodes
$(\'#input-search\').on(\'keyup\', function (e) {
var str = $(\'#input-search\').val();
if($.trim(str).length>0){
searchableNodes = findSearchableNodes();
} else {
$(\'#treeview-searchable\').treeview(\'collapseAll\', {
silent : false //设置初始化节点关闭
});
}
//$(\'.select-node\').prop(\'disabled\', !(searchableNodes.length >= 1));
});
var search = function(e) {
var pattern = $.trim($(\'#input-search\').val());
var options = {
ignoreCase: $(\'#chk-ignore-case\').is(\':checked\'),
exactMatch: $(\'#chk-exact-match\').is(\':checked\'),
revealResults: $(\'#chk-reveal-results\').is(\':checked\')
};
var results = $searchableTree.treeview(\'search\', [ pattern, options ]);
var output = \'<p>\' + results.length + \' 匹配的搜索结果</p>\';
$.each(results, function (index, result) {
output += \'<p>- <span style="color:red;">\' + result.name + \'</span></p>\';
});
$(\'#search-output\').html(output);
}
$(\'#btn-search\').on(\'click\', search);
$(\'#input-search\').on(\'keyup\', search);
$(\'#btn-clear-search\').on(\'click\', function (e) {
$searchableTree.treeview(\'clearSearch\');
$(\'#input-search\').val(\'\');
$(\'#search-output\').html(\'\');
$(\'#treeview-searchable\').treeview(\'collapseAll\', {
silent : false//设置初始化节点关闭
});
});
}
//根据所选的地区移动地图到指定区域
function moveMap(regionName){
//加载行政区划插件
AMap.service(\'AMap.DistrictSearch\', function() {
var opts = {
subdistrict: 1, //返回下一级行政区
extensions: \'all\', //返回行政区边界坐标组等具体信息
level: \'city\' //查询行政级别为 市
};
//实例化DistrictSearch
district = new AMap.DistrictSearch(opts);
district.setLevel(\'district\');
//行政区查询
district.search(regionName, function(status, result) {
var bounds = result.districtList[0].boundaries;
var polygons = [];
if (bounds) {
for (var i = 0, l = bounds.length; i < l; i++) {
//生成行政区划polygon
var polygon = new AMap.Polygon({
map: map,
strokeWeight: 1,
path: bounds[i],
fillOpacity: 0.3,
fillColor: \'#CCF3FF\',
strokeColor: \'#000000\',
});
polygons.push(polygon);
}
map.setFitView();//地图自适应
}
});
});
}
var markerList=[];//定义一个点组
function showDrivingRecond(){
var service=togt.findService("trafficInfo");
service.addMethod("findDrivingRecond","GET",true);
service.findDrivingRecond({cityCode:cityCode},function(jsonResult,status){
if (jsonResult.hasError)
{
alert(jsonResult.errorText);
}else if (jsonResult.notNull)
{
var img;
img = "http://webapi.amap.com/theme/v1.3/markers/n/mark_r.png";
var listLonLat = jsonResult.result;
map.remove(markerList);//删除地图上的所有marker点，即markerList点组
$.each(listLonLat, function(index, value, array) {
addMarker(value.lon, value.lat, img);
});
}else
{
alert("数据查询失败!");
}
});
}
//加点
function addMarker(lng, lat, imgUrl) {
if (imgUrl == null) {
imgUrl = "http://webapi.amap.com/theme/v1.3/markers/n/mark_b.png";
}
marker1 = new AMap.Marker({
icon : imgUrl,
position : [ lng, lat ]
});
marker1.setMap(map);
markerList.push(marker1);
return marker1;
}
html
<div class="row"> <div class=" col-lg-3 col-md-3 col-sm-3" style="margin-top:30px;height:770px;overflow:auto"> <input type="input"class="form-control"id="input-search" placeholder="请输入要查询的节点信息"> <div class="col-lg-12 col-md-12 col-sm-12" style="margin-top:20px"> <div id="treeview-searchable" class=""></div> </div> <div class="col-lg-12 col-md-12 col-sm-12"> <div id="search-output" style="display: none"></div> </div> <!-- <div id="treeview3" class=""></div> --> </div> <div class=" col-lg-9 col-md-9 col-sm-9" style="height:770px"> <div class="row" > <!-- 地图 --> <div id="container"></div> </div> </div> </div>
页面效果：
版权声明：本文为yunqing原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。