java省市区树_java把行政区划放到一个节点树形中

先放数据，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 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 getNodes() {

return nodes;

}

public void setNodes(List nodes) {

this.nodes = nodes;

}

}

2.城市实体类

略。。。看数据库自己建立

3.数据处理----查询出来city信息，装进TreeVo中

@RequestMapping(value = "/findTree", method = { RequestMethod.GET })

public Map findTree() {

Map map = new HashMap();

List citys=cityService.findAll(Sort.by(Direction.ASC, "code"), null);

List baseTreeList=findTree(citys);

map.put("tree", baseTreeList);

return map;

}

public List findTree(List citys) {

//过滤掉顶级中国

List cityList = citys.stream().filter(e->!e.getName().equals("中国") && !e.equals(null)).collect(Collectors.toList());

List baseTreeList = new ArrayList<>();

List secondTreeList = new ArrayList<>();

List 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 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 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 = '

' + results.length + ' 匹配的搜索结果

';

$.each(results, function (index, result) {

output += '

- ' + result.name + '

';

});

$('#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

页面效果：