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>
页面效果: