java后端实现省市区三级联动接口查询及数据库表下

java后端实现省市区三级联动接口查询及数据库表

1、创建数据库

INSERT INTO t_city VALUES ('10003310', '652828', '和硕县', '10000368', '3');INSERT INTO t_city VALUES ('10003311', '652829', '博湖县', '10000368', '3');INSERT INTO t_city VALUES ('10003312', '652901', '阿克苏市', '10000369', '3');INSERT INTO t_city VALUES ('10003313', '652922', '温宿县', '10000369', '3');INSERT INTO t_city VALUES ('10003314', '652923', '库车县', '10000369', '3');INSERT INTO t_city VALUES ('10003315', '652924', '沙雅县', '10000369', '3');INSERT INTO t_city VALUES ('10003316', '652925', '新和县', '10000369', '3');INSERT INTO t_city VALUES ('10003317', '652926', '拜城县', '10000369', '3');INSERT INTO t_city VALUES ('10003318', '652927', '乌什县', '10000369', '3');INSERT INTO t_city VALUES ('10003319', '652928', '阿瓦提县', '10000369', '3');INSERT INTO t_city VALUES ('10003320', '652929', '柯坪县', '10000369', '3');INSERT INTO t_city VALUES ('10003321', '653001', '阿图什市', '10000370', '3');INSERT INTO t_city VALUES ('10003322', '653022', '阿克陶县', '10000370', '3');INSERT INTO t_city VALUES ('10003323', '653023', '阿合奇县', '10000370', '3');INSERT INTO t_city VALUES ('10003324', '653024', '乌恰县', '10000370', '3');INSERT INTO t_city VALUES ('10003325', '653101', '喀什市', '10000371', '3');INSERT INTO t_city VALUES ('10003326', '653121', '疏附县', '10000371', '3');INSERT INTO t_city VALUES ('10003327', '653122', '疏勒县', '10000371', '3');INSERT INTO t_city VALUES ('10003328', '653123', '英吉沙县', '10000371', '3');INSERT INTO t_city VALUES ('10003329', '653124', '泽普县', '10000371', '3');INSERT INTO t_city VALUES ('10003330', '653125', '莎车县', '10000371', '3');INSERT INTO t_city VALUES ('10003331', '653126', '叶城县', '10000371', '3');INSERT INTO t_city VALUES ('10003332', '653127', '麦盖提县', '10000371', '3');INSERT INTO t_city VALUES ('10003333', '653128', '岳普湖县', '10000371', '3');INSERT INTO t_city VALUES ('10003334', '653129', '伽师县', '10000371', '3');INSERT INTO t_city VALUES ('10003335', '653130', '巴楚县', '10000371', '3');INSERT INTO t_city VALUES ('10003336', '653131', '塔什库尔干塔吉克自治县', '10000371', '3');INSERT INTO t_city VALUES ('10003337', '653201', '和田市', '10000372', '3');INSERT INTO t_city VALUES ('10003338', '653221', '和田县', '10000372', '3');INSERT INTO t_city VALUES ('10003339', '653222', '墨玉县', '10000372', '3');INSERT INTO t_city VALUES ('10003340', '653223', '皮山县', '10000372', '3');INSERT INTO t_city VALUES ('10003341', '653224', '洛浦县', '10000372', '3');INSERT INTO t_city VALUES ('10003342', '653225', '策勒县', '10000372', '3');INSERT INTO t_city VALUES ('10003343', '653226', '于田县', '10000372', '3');INSERT INTO t_city VALUES ('10003344', '653227', '民丰县', '10000372', '3');INSERT INTO t_city VALUES ('10003345', '654002', '伊宁市', '10000373', '3');INSERT INTO t_city VALUES ('10003346', '654003', '奎屯市', '10000373', '3');INSERT INTO t_city VALUES ('10003347', '654004', '霍尔果斯市', '10000373', '3');INSERT INTO t_city VALUES ('10003348', '654021', '伊宁县', '10000373', '3');INSERT INTO t_city VALUES ('10003349', '654022', '察布查尔锡伯自治县', '10000373', '3');INSERT INTO t_city VALUES ('10003350', '654023', '霍城县', '10000373', '3');INSERT INTO t_city VALUES ('10003351', '654024', '巩留县', '10000373', '3');INSERT INTO t_city VALUES ('10003352', '654025', '新源县', '10000373', '3');INSERT INTO t_city VALUES ('10003353', '654026', '昭苏县', '10000373', '3');INSERT INTO t_city VALUES ('10003354', '654027', '特克斯县', '10000373', '3');INSERT INTO t_city VALUES ('10003355', '654028', '尼勒克县', '10000373', '3');INSERT INTO t_city VALUES ('10003356', '654201', '塔城市', '10000374', '3');INSERT INTO t_city VALUES ('10003357', '654202', '乌苏市', '10000374', '3');INSERT INTO t_city VALUES ('10003358', '654221', '额敏县', '10000374', '3');INSERT INTO t_city VALUES ('10003359', '654223', '沙湾县', '10000374', '3');INSERT INTO t_city VALUES ('10003360', '654224', '托里县', '10000374', '3');INSERT INTO t_city VALUES ('10003361', '654225', '裕民县', '10000374', '3');INSERT INTO t_city VALUES ('10003362', '654226', '和布克赛尔蒙古自治县', '10000374', '3');INSERT INTO t_city VALUES ('10003363', '654301', '阿勒泰市', '10000375', '3');INSERT INTO t_city VALUES ('10003364', '654321', '布尔津县', '10000375', '3');INSERT INTO t_city VALUES ('10003365', '654322', '富蕴县', '10000375', '3');INSERT INTO t_city VALUES ('10003366', '654323', '福海县', '10000375', '3');INSERT INTO t_city VALUES ('10003367', '654324', '哈巴河县', '10000375', '3');INSERT INTO t_city VALUES ('10003368', '654325', '青河县', '10000375', '3');INSERT INTO t_city VALUES ('10003369', '654326', '吉木乃县', '10000375', '3');INSERT INTO t_city VALUES ('10003370', '659001', '石河子市', '10000376', '3');INSERT INTO t_city VALUES ('10003371', '659002', '阿拉尔市', '10000376', '3');INSERT INTO t_city VALUES ('10003372', '659003', '图木舒克市', '10000376', '3');INSERT INTO t_city VALUES ('10003373', '659004', '五家渠市', '10000376', '3');INSERT INTO t_city VALUES ('10003374', '659005', '北屯市', '10000376', '3');INSERT INTO t_city VALUES ('10003375', '659006', '铁门关市', '10000376', '3');INSERT INTO t_city VALUES ('10003376', '659007', '双河市', '10000376', '3');INSERT INTO t_city VALUES ('10003377', '659008', '可克达拉市', '10000376', '3');INSERT INTO t_city VALUES ('10003378', '659009', '昆玉市', '10000376', '3');INSERT INTO t_city VALUES ('10003379', '710101', '中正区', '10000377', '3');INSERT INTO t_city VALUES ('10003380', '710102', '大同区', '10000377', '3');INSERT INTO t_city VALUES ('10003381', '710103', '中山区', '10000377', '3');INSERT INTO t_city VALUES ('10003382', '710104', '松山区', '10000377', '3');INSERT INTO t_city VALUES ('10003383', '710105', '大安区', '10000377', '3');INSERT INTO t_city VALUES ('10003384', '710106', '万华区', '10000377', '3');INSERT INTO t_city VALUES ('10003385', '710107', '信义区', '10000377', '3');INSERT INTO t_city VALUES ('10003386', '710108', '士林区', '10000377', '3');INSERT INTO t_city VALUES ('10003387', '710109', '北投区', '10000377', '3');INSERT INTO t_city VALUES ('10003388', '710110', '内湖区', '10000377', '3');INSERT INTO t_city VALUES ('10003389', '710111', '南港区', '10000377', '3');INSERT INTO t_city VALUES ('10003390', '710112', '文山区', '10000377', '3');INSERT INTO t_city VALUES ('10003391', '710199', '其它区', '10000377', '3');INSERT INTO t_city VALUES ('10003392', '710201', '新兴区', '10000378', '3');INSERT INTO t_city VALUES ('10003393', '710202', '前金区', '10000378', '3');INSERT INTO t_city VALUES ('10003394', '710203', '芩雅区', '10000378', '3');INSERT INTO t_city VALUES ('10003395', '710204', '盐埕区', '10000378', '3');INSERT INTO t_city VALUES ('10003396', '710205', '鼓山区', '10000378', '3');INSERT INTO t_city VALUES ('10003397', '710206', '旗津区', '10000378', '3');INSERT INTO t_city VALUES ('10003398', '710207', '前镇区', '10000378', '3');INSERT INTO t_city VALUES ('10003399', '710208', '三民区', '10000378', '3');INSERT INTO t_city VALUES ('10003400', '710209', '左营区', '10000378', '3');INSERT INTO t_city VALUES ('10003401', '710210', '楠梓区', '10000378', '3');INSERT INTO t_city VALUES ('10003402', '710211', '小港区', '10000378', '3');INSERT INTO t_city VALUES ('10003403', '710241', '苓雅区', '10000378', '3');INSERT INTO t_city VALUES ('10003404', '710242', '仁武区', '10000378', '3');INSERT INTO t_city VALUES ('10003405', '710243', '大社区', '10000378', '3');INSERT INTO t_city VALUES ('10003406', '710244', '冈山区', '10000378', '3');INSERT INTO t_city VALUES ('10003407', '710245', '路竹区', '10000378', '3');INSERT INTO t_city VALUES ('10003408', '710246', '阿莲区', '10000378', '3');INSERT INTO t_city VALUES ('10003409', '710247', '田寮区', '10000378', '3');INSERT INTO t_city VALUES ('10003410', '710248', '燕巢区', '10000378', '3');INSERT INTO t_city VALUES ('10003411', '710249', '桥头区', '10000378', '3');INSERT INTO t_city VALUES ('10003412', '710250', '梓官区', '10000378', '3');INSERT INTO t_city VALUES ('10003413', '710251', '弥陀区', '10000378', '3');INSERT INTO t_city VALUES ('10003414', '710252', '永安区', '10000378', '3');INSERT INTO t_city VALUES ('10003415', '710253', '湖内区', '10000378', '3');INSERT INTO t_city VALUES ('10003416', '710254', '凤山区', '10000378', '3');INSERT INTO t_city VALUES ('10003417', '710255', '大寮区', '10000378', '3');INSERT INTO t_city VALUES ('10003418', '710256', '林园区', '10000378', '3');INSERT INTO t_city VALUES ('10003419', '710257', '鸟松区', '10000378', '3');INSERT INTO t_city VALUES ('10003420', '710258', '大树区', '10000378', '3');INSERT INTO t_city VALUES ('10003421', '710259', '旗山区', '10000378', '3');INSERT INTO t_city VALUES ('10003422', '710260', '美浓区', '10000378', '3');INSERT INTO t_city VALUES ('10003423', '710261', '六龟区', '10000378', '3');INSERT INTO t_city VALUES ('10003424', '710262', '内门区', '10000378', '3');INSERT INTO t_city VALUES ('10003425', '710263', '杉林区', '10000378', '3');INSERT INTO t_city VALUES ('10003426', '710264', '甲仙区', '10000378', '3');INSERT INTO t_city VALUES ('10003427', '710265', '桃源区', '10000378', '3');INSERT INTO t_city VALUES ('10003428', '710266', '那玛夏区', '10000378', '3');INSERT INTO t_city VALUES ('10003429', '710267', '茂林区', '10000378', '3');INSERT INTO t_city VALUES ('10003430', '710268', '茄萣区', '10000378', '3');INSERT INTO t_city VALUES ('10003431', '710299', '其它区', '10000378', '3');INSERT INTO t_city VALUES ('10003432', '710301', '中西区', '10000379', '3');INSERT INTO t_city VALUES ('10003433', '710302', '东区', '10000379', '3');INSERT INTO t_city VALUES ('10003434', '710303', '南区', '10000379', '3');INSERT INTO t_city VALUES ('10003435', '710304', '北区', '10000379', '3');INSERT INTO t_city VALUES ('10003436', '710305', '安平区', '10000379', '3');INSERT INTO t_city VALUES ('10003437', '710306', '安南区', '10000379', '3');INSERT INTO t_city VALUES ('10003438', '710339', '永康区', '10000379', '3');INSERT INTO t_city VALUES ('10003439', '710340', '归仁区', '10000379', '3');INSERT INTO t_city VALUES ('10003440', '710341', '新化区', '10000379', '3');INSERT INTO t_city VALUES ('10003441', '710342', '左镇区', '10000379', '3');INSERT INTO t_city VALUES ('10003442', '710343', '玉井区', '10000379', '3');INSERT INTO t_city VALUES ('10003443', '710344', '楠西区', '10000379', '3');INSERT INTO t_city VALUES ('10003444', '710345', '南化区', '10000379', '3');INSERT INTO t_city VALUES ('10003445', '710346', '仁德区', '10000379', '3');INSERT INTO t_city VALUES ('10003446', '710347', '关庙区', '10000379', '3');INSERT INTO t_city VALUES ('10003447', '710348', '龙崎区', '10000379', '3');INSERT INTO t_city VALUES ('10003448', '710349', '官田区', '10000379', '3');INSERT INTO t_city VALUES ('10003449', '710350', '麻豆区', '10000379', '3');INSERT INTO t_city VALUES ('10003450', '710351', '佳里区', '10000379', '3');INSERT INTO t_city VALUES ('10003451', '710352', '西港区', '10000379', '3');INSERT INTO t_city VALUES ('10003452', '710353', '七股区', '10000379', '3');INSERT INTO t_city VALUES ('10003453', '710354', '将军区', '10000379', '3');INSERT INTO t_city VALUES ('10003454', '710355', '学甲区', '10000379', '3');INSERT INTO t_city VALUES ('10003455', '710356', '北门区', '10000379', '3');INSERT INTO t_city VALUES ('10003456', '710357', '新营区', '10000379', '3');INSERT INTO t_city VALUES ('10003457', '710358', '后壁区', '10000379', '3');INSERT INTO t_city VALUES ('10003458', '710359', '白河区', '10000379', '3');INSERT INTO t_city VALUES ('10003459', '710360', '东山区', '10000379', '3');INSERT INTO t_city VALUES ('10003460', '710361', '六甲区', '10000379', '3');INSERT INTO t_city VALUES ('10003461', '710362', '下营区', '10000379', '3');INSERT INTO t_city VALUES ('10003462', '710363', '柳营区', '10000379', '3');INSERT INTO t_city VALUES ('10003463', '710364', '盐水区', '10000379', '3');INSERT INTO t_city VALUES ('10003464', '710365', '善化区', '10000379', '3');INSERT INTO t_city VALUES ('10003465', '710366', '大内区', '10000379', '3');INSERT INTO t_city VALUES ('10003466', '710367', '山上区', '10000379', '3');INSERT INTO t_city VALUES ('10003467', '710368', '新市区', '10000379', '3');INSERT INTO t_city VALUES ('10003468', '710369', '安定区', '10000379', '3');INSERT INTO t_city VALUES ('10003469', '710399', '其它区', '10000379', '3');INSERT INTO t_city VALUES ('10003470', '710401', '中区', '10000380', '3');INSERT INTO t_city VALUES ('10003471', '710402', '东区', '10000380', '3');INSERT INTO t_city VALUES ('10003472', '710403', '南区', '10000380', '3');INSERT INTO t_city VALUES ('10003473', '710404', '西区', '10000380', '3');INSERT INTO t_city VALUES ('10003474', '710405', '北区', '10000380', '3');INSERT INTO t_city VALUES ('10003475', '710406', '北屯区', '10000380', '3');INSERT INTO t_city VALUES ('10003476', '710407', '西屯区', '10000380', '3');INSERT INTO t_city VALUES ('10003477', '710408', '南屯区', '10000380', '3');INSERT INTO t_city VALUES ('10003478', '710431', '太平区', '10000380', '3');INSERT INTO t_city VALUES ('10003479', '710432', '大里区', '10000380', '3');INSERT INTO t_city VALUES ('10003480', '710433', '雾峰区', '10000380', '3');INSERT INTO t_city VALUES ('10003481', '710434', '乌日区', '10000380', '3');INSERT INTO t_city VALUES ('10003482', '710435', '丰原区', '10000380', '3');INSERT INTO t_city VALUES ('10003483', '710436', '后里区', '10000380', '3');INSERT INTO t_city VALUES ('10003484', '710437', '石冈区', '10000380', '3');INSERT INTO t_city VALUES ('10003485', '710438', '东势区', '10000380', '3');INSERT INTO t_city VALUES ('10003486', '710439', '和平区', '10000380', '3');INSERT INTO t_city VALUES ('10003487', '710440', '新社区', '10000380', '3');INSERT INTO t_city VALUES ('10003488', '710441', '潭子区', '10000380', '3');INSERT INTO t_city VALUES ('10003489', '710442', '大雅区', '10000380', '3');INSERT INTO t_city VALUES ('10003490', '710443', '神冈区', '10000380', '3');INSERT INTO t_city VALUES ('10003491', '710444', '大肚区', '10000380', '3');INSERT INTO t_city VALUES ('10003492', '710445', '沙鹿区', '10000380', '3');INSERT INTO t_city VALUES ('10003493', '710446', '龙井区', '10000380', '3');INSERT INTO t_city VALUES ('10003494', '710447', '梧栖区', '10000380', '3');INSERT INTO t_city VALUES ('10003495', '710448', '清水区', '10000380', '3');INSERT INTO t_city VALUES ('10003496', '710449', '大甲区', '10000380', '3');INSERT INTO t_city VALUES ('10003497', '710450', '外埔区', '10000380', '3');INSERT INTO t_city VALUES ('10003498', '710451', '大安区', '10000380', '3');INSERT INTO t_city VALUES ('10003499', '710499', '其它区', '10000380', '3');INSERT INTO t_city VALUES ('10003500', '710507', '金沙镇', '10000381', '3');INSERT INTO t_city VALUES ('10003501', '710508', '金湖镇', '10000381', '3');INSERT INTO t_city VALUES ('10003502', '710509', '金宁乡', '10000381', '3');INSERT INTO t_city VALUES ('10003503', '710510', '金城镇', '10000381', '3');INSERT INTO t_city VALUES ('10003504', '710511', '烈屿乡', '10000381', '3');INSERT INTO t_city VALUES ('10003505', '710512', '乌坵乡', '10000381', '3');INSERT INTO t_city VALUES ('10003506', '710614', '南投市', '10000382', '3');INSERT INTO t_city VALUES ('10003507', '710615', '中寮乡', '10000382', '3');INSERT INTO t_city VALUES ('10003508', '710616', '草屯镇', '10000382', '3');INSERT INTO t_city VALUES ('10003509', '710617', '国姓乡', '10000382', '3');INSERT INTO t_city VALUES ('10003510', '710618', '埔里镇', '10000382', '3');INSERT INTO t_city VALUES ('10003511', '710619', '仁爱乡', '10000382', '3');INSERT INTO t_city VALUES ('10003512', '710620', '名间乡', '10000382', '3');INSERT INTO t_city VALUES ('10003513', '710621', '集集镇', '10000382', '3');INSERT INTO t_city VALUES ('10003514', '710622', '水里乡', '10000382', '3');INSERT INTO t_city VALUES ('10003515', '710623', '鱼池乡', '10000382', '3');INSERT INTO t_city VALUES ('10003516', '710624', '信义乡', '10000382', '3');INSERT INTO t_city VALUES ('10003517', '710625', '竹山镇', '10000382', '3');INSERT INTO t_city VALUES ('10003518', '710626', '鹿谷乡', '10000382', '3');INSERT INTO t_city VALUES ('10003519', '710701', '仁爱区', '10000383', '3');INSERT INTO t_city VALUES ('10003520', '710702', '信义区', '10000383', '3');INSERT INTO t_city VALUES ('10003521', '710703', '中正区', '10000383', '3');INSERT INTO t_city VALUES ('10003522', '710704', '中山区', '10000383', '3');INSERT INTO t_city VALUES ('10003523', '710705', '安乐区', '10000383', '3');INSERT INTO t_city VALUES ('10003524', '710706', '暖暖区', '10000383', '3');INSERT INTO t_city VALUES ('10003525', '710707', '七堵区', '10000383', '3');INSERT INTO t_city VALUES ('10003526', '710799', '其它区', '10000383', '3');INSERT INTO t_city VALUES ('10003527', '710801', '东区', '10000384', '3');INSERT INTO t_city VALUES ('10003528', '710802', '北区', '10000384', '3');INSERT INTO t_city VALUES ('10003529', '710803', '香山区', '10000384', '3');INSERT INTO t_city VALUES ('10003530', '710899', '其它区', '10000384', '3');INSERT INTO t_city VALUES ('10003531', '710901', '东区', '10000385', '3');INSERT INTO t_city VALUES ('10003532', '710902', '西区', '10000385', '3');INSERT INTO t_city VALUES ('10003533', '710999', '其它区', '10000385', '3');INSERT INTO t_city VALUES ('10003534', '711130', '万里区', '10000386', '3');INSERT INTO t_city VALUES ('10003535', '711132', '板桥区', '10000386', '3');INSERT INTO t_city VALUES ('10003536', '711133', '汐止区', '10000386', '3');INSERT INTO t_city VALUES ('10003537', '711134', '深坑区', '10000386', '3');INSERT INTO t_city VALUES ('10003538', '711135', '石碇区', '10000386', '3');INSERT INTO t_city VALUES ('10003539', '711136', '瑞芳区', '10000386', '3');INSERT INTO t_city VALUES ('10003540', '711137', '平溪区', '10000386', '3');INSERT INTO t_city VALUES ('10003541', '711138', '双溪区', '10000386', '3');INSERT INTO t_city VALUES ('10003542', '711139', '贡寮区', '10000386', '3');INSERT INTO t_city VALUES ('10003543', '711140', '新店区', '10000386', '3');INSERT INTO t_city VALUES ('10003544', '711141', '坪林区', '10000386', '3');INSERT INTO t_city VALUES ('10003545', '711142', '乌来区', '10000386', '3');INSERT INTO t_city VALUES ('10003546', '711143', '永和区', '10000386', '3');INSERT INTO t_city VALUES ('10003547', '711144', '中和区', '10000386', '3');INSERT INTO t_city VALUES ('10003548', '711145', '土城区', '10000386', '3');INSERT INTO t_city VALUES ('10003549', '711146', '三峡区', '10000386', '3');INSERT INTO t_city VALUES ('10003550', '711147', '树林区', '10000386', '3');INSERT INTO t_city VALUES ('10003551', '711148', '莺歌区', '10000386', '3');INSERT INTO t_city VALUES ('10003552', '711149', '三重区', '10000386', '3');INSERT INTO t_city VALUES ('10003553', '711150', '新庄区', '10000386', '3');INSERT INTO t_city VALUES ('10003554', '711151', '泰山区', '10000386', '3');INSERT INTO t_city VALUES ('10003555', '711152', '林口区', '10000386', '3');INSERT INTO t_city VALUES ('10003556', '711153', '芦洲区', '10000386', '3');INSERT INTO t_city VALUES ('10003557', '711154', '五股区', '10000386', '3');INSERT INTO t_city VALUES ('10003558', '711155', '八里区', '10000386', '3');INSERT INTO t_city VALUES ('10003559', '711156', '淡水区', '10000386', '3');INSERT INTO t_city VALUES ('10003560', '711157', '三芝区', '10000386', '3');INSERT INTO t_city VALUES ('10003561', '711158', '石门区', '10000386', '3');INSERT INTO t_city VALUES ('10003562', '711287', '宜兰市', '10000387', '3');INSERT INTO t_city VALUES ('10003563', '711288', '头城镇', '10000387', '3');INSERT INTO t_city VALUES ('10003564', '711289', '礁溪乡', '10000387', '3');INSERT INTO t_city VALUES ('10003565', '711290', '壮围乡', '10000387', '3');INSERT INTO t_city VALUES ('10003566', '711291', '员山乡', '10000387', '3');INSERT INTO t_city VALUES ('10003567', '711292', '罗东镇', '10000387', '3');INSERT INTO t_city VALUES ('10003568', '711293', '三星乡', '10000387', '3');INSERT INTO t_city VALUES ('10003569', '711294', '大同乡', '10000387', '3');INSERT INTO t_city VALUES ('10003570', '711295', '五结乡', '10000387', '3');INSERT INTO t_city VALUES ('10003571', '711296', '冬山乡', '10000387', '3');INSERT INTO t_city VALUES ('10003572', '711297', '苏澳镇', '10000387', '3');INSERT INTO t_city VALUES ('10003573', '711298', '南澳乡', '10000387', '3');INSERT INTO t_city VALUES ('10003574', '711299', '钓鱼台', '10000387', '3');INSERT INTO t_city VALUES ('10003575', '711387', '竹北市', '10000388', '3');INSERT INTO t_city VALUES ('10003576', '711388', '湖口乡', '10000388', '3');INSERT INTO t_city VALUES ('10003577', '711389', '新丰乡', '10000388', '3');INSERT INTO t_city VALUES ('10003578', '711390', '新埔镇', '10000388', '3');INSERT INTO t_city VALUES ('10003579', '711391', '关西镇', '10000388', '3');INSERT INTO t_city VALUES ('10003580', '711392', '芎林乡', '10000388', '3');INSERT INTO t_city VALUES ('10003581', '711393', '宝山乡', '10000388', '3');INSERT INTO t_city VALUES ('10003582', '711394', '竹东镇', '10000388', '3');INSERT INTO t_city VALUES ('10003583', '711395', '五峰乡', '10000388', '3');INSERT INTO t_city VALUES ('10003584', '711396', '横山乡', '10000388', '3');INSERT INTO t_city VALUES ('10003585', '711397', '尖石乡', '10000388', '3');INSERT INTO t_city VALUES ('10003586', '711398', '北埔乡', '10000388', '3');INSERT INTO t_city VALUES ('10003587', '711399', '峨眉乡', '10000388', '3');INSERT INTO t_city VALUES ('10003588', '711414', '中坜区', '10000389', '3');INSERT INTO t_city VALUES ('10003589', '711415', '平镇区', '10000389', '3');INSERT INTO t_city VALUES ('10003590', '711417', '杨梅区', '10000389', '3');INSERT INTO t_city VALUES ('10003591', '711418', '新屋区', '10000389', '3');INSERT INTO t_city VALUES ('10003592', '711419', '观音区', '10000389', '3');INSERT INTO t_city VALUES ('10003593', '711420', '桃园区', '10000389', '3');INSERT INTO t_city VALUES ('10003594', '711421', '龟山区', '10000389', '3');INSERT INTO t_city VALUES ('10003595', '711422', '八德区', '10000389', '3');INSERT INTO t_city VALUES ('10003596', '711423', '大溪区', '10000389', '3');INSERT INTO t_city VALUES ('10003597', '711425', '大园区', '10000389', '3');INSERT INTO t_city VALUES ('10003598', '711426', '芦竹区', '10000389', '3');INSERT INTO t_city VALUES ('10003599', '711487', '中坜市', '10000389', '3');INSERT INTO t_city VALUES ('10003600', '711488', '平镇市', '10000389', '3');INSERT INTO t_city VALUES ('10003601', '711489', '龙潭乡', '10000389', '3');INSERT INTO t_city VALUES ('10003602', '711490', '杨梅市', '10000389', '3');INSERT INTO t_city VALUES ('10003603', '711491', '新屋乡', '10000389', '3');INSERT INTO t_city VALUES ('10003604', '711492', '观音乡', '10000389', '3');INSERT INTO t_city VALUES ('10003605', '711493', '桃园市', '10000389', '3');INSERT INTO t_city VALUES ('10003606', '711494', '龟山乡', '10000389', '3');INSERT INTO t_city VALUES ('10003607', '711495', '八德市', '10000389', '3');INSERT INTO t_city VALUES ('10003608', '711496', '大溪镇', '10000389', '3');INSERT INTO t_city VALUES ('10003609', '711497', '复兴乡', '10000389', '3');INSERT INTO t_city VALUES ('10003610', '711498', '大园乡', '10000389', '3');INSERT INTO t_city VALUES ('10003611', '711499', '芦竹乡', '10000389', '3');INSERT INTO t_city VALUES ('10003612', '711520', '头份市', '10000390', '3');INSERT INTO t_city VALUES ('10003613', '711582', '竹南镇', '10000390', '3');INSERT INTO t_city VALUES ('10003614', '711583', '头份镇', '10000390', '3');INSERT INTO t_city VALUES ('10003615', '711584', '三湾乡', '10000390', '3');INSERT INTO t_city VALUES ('10003616', '711585', '南庄乡', '10000390', '3');INSERT INTO t_city VALUES ('10003617', '711586', '狮潭乡', '10000390', '3');INSERT INTO t_city VALUES ('10003618', '711587', '后龙镇', '10000390', '3');INSERT INTO t_city VALUES ('10003619', '711588', '通霄镇', '10000390', '3');INSERT INTO t_city VALUES ('10003620', '711589', '苑里镇', '10000390', '3');INSERT INTO t_city VALUES ('10003621', '711590', '苗栗市', '10000390', '3');INSERT INTO t_city VALUES ('10003622', '711591', '造桥乡', '10000390', '3');INSERT INTO t_city VALUES ('10003623', '711592', '头屋乡', '10000390', '3');INSERT INTO t_city VALUES ('10003624', '711593', '公馆乡', '10000390', '3');INSERT INTO t_city VALUES ('10003625', '711594', '大湖乡', '10000390', '3');INSERT INTO t_city VALUES ('10003626', '711595', '泰安乡', '10000390', '3');INSERT INTO t_city VALUES ('10003627', '711596', '铜锣乡', '10000390', '3');INSERT INTO t_city VALUES ('10003628', '711597', '三义乡', '10000390', '3');INSERT INTO t_city VALUES ('10003629', '711598', '西湖乡', '10000390', '3');INSERT INTO t_city VALUES ('10003630', '711599', '卓兰镇', '10000390', '3');INSERT INTO t_city VALUES ('10003631', '711736', '员林市', '10000391', '3');INSERT INTO t_city VALUES ('10003632', '711774', '彰化市', '10000391', '3');INSERT INTO t_city VALUES ('10003633', '711775', '芬园乡', '10000391', '3');INSERT INTO t_city VALUES ('10003634', '711776', '花坛乡', '10000391', '3');INSERT INTO t_city VALUES ('10003635', '711777', '秀水乡', '10000391', '3');INSERT INTO t_city VALUES ('10003636', '711778', '鹿港镇', '10000391', '3');INSERT INTO t_city VALUES ('10003637', '711779', '福兴乡', '10000391', '3');INSERT INTO t_city VALUES ('10003638', '711780', '线西乡', '10000391', '3');INSERT INTO t_city VALUES ('10003639', '711781', '和美镇', '10000391', '3');INSERT INTO t_city VALUES ('10003640', '711782', '伸港乡', '10000391', '3');INSERT INTO t_city VALUES ('10003641', '711783', '员林镇', '10000391', '3');INSERT INTO t_city VALUES ('10003642', '711784', '社头乡', '10000391', '3');INSERT INTO t_city VALUES ('10003643', '711785', '永靖乡', '10000391', '3');INSERT INTO t_city VALUES ('10003644', '711786', '埔心乡', '10000391', '3');INSERT INTO t_city VALUES ('10003645', '711787', '溪湖镇', '10000391', '3');INSERT INTO t_city VALUES ('10003646', '711788', '大村乡', '10000391', '3');INSERT INTO t_city VALUES ('10003647', '711789', '埔盐乡', '10000391', '3');INSERT INTO t_city VALUES ('10003648', '711790', '田中镇', '10000391', '3');INSERT INTO t_city VALUES ('10003649', '711791', '北斗镇', '10000391', '3');INSERT INTO t_city VALUES ('10003650', '711792', '田尾乡', '10000391', '3');INSERT INTO t_city VALUES ('10003651', '711793', '埤头乡', '10000391', '3');INSERT INTO t_city VALUES ('10003652', '711794', '溪州乡', '10000391', '3');INSERT INTO t_city VALUES ('10003653', '711795', '竹塘乡', '10000391', '3');INSERT INTO t_city VALUES ('10003654', '711796', '二林镇', '10000391', '3');INSERT INTO t_city VALUES ('10003655', '711797', '大城乡', '10000391', '3');INSERT INTO t_city VALUES ('10003656', '711798', '芳苑乡', '10000391', '3');INSERT INTO t_city VALUES ('10003657', '711799', '二水乡', '10000391', '3');INSERT INTO t_city VALUES ('10003658', '711982', '番路乡', '10000392', '3');INSERT INTO t_city VALUES ('10003659', '711983', '梅山乡', '10000392', '3');INSERT INTO t_city VALUES ('10003660', '711984', '竹崎乡', '10000392', '3');INSERT INTO t_city VALUES ('10003661', '711985', '阿里山乡', '10000392', '3');INSERT INTO t_city VALUES ('10003662', '711986', '中埔乡', '10000392', '3');INSERT INTO t_city VALUES ('10003663', '711987', '大埔乡', '10000392', '3');INSERT INTO t_city VALUES ('10003664', '711988', '水上乡', '10000392', '3');INSERT INTO t_city VALUES ('10003665', '711989', '鹿草乡', '10000392', '3');INSERT INTO t_city VALUES ('10003666', '711990', '太保市', '10000392', '3');INSERT INTO t_city VALUES ('10003667', '711991', '朴子市', '10000392', '3');INSERT INTO t_city VALUES ('10003668', '711992', '东石乡', '10000392', '3');INSERT INTO t_city VALUES ('10003669', '711993', '六脚乡', '10000392', '3');INSERT INTO t_city VALUES ('10003670', '711994', '新港乡', '10000392', '3');INSERT INTO t_city VALUES ('10003671', '711995', '民雄乡', '10000392', '3');INSERT INTO t_city VALUES ('10003672', '711996', '大林镇', '10000392', '3');INSERT INTO t_city VALUES ('10003673', '711997', '溪口乡', '10000392', '3');INSERT INTO t_city VALUES ('10003674', '711998', '义竹乡', '10000392', '3');INSERT INTO t_city VALUES ('10003675', '711999', '布袋镇', '10000392', '3');INSERT INTO t_city VALUES ('10003676', '712180', '斗南镇', '10000393', '3');INSERT INTO t_city VALUES ('10003677', '712181', '大埤乡', '10000393', '3');INSERT INTO t_city VALUES ('10003678', '712182', '虎尾镇', '10000393', '3');INSERT INTO t_city VALUES ('10003679', '712183', '土库镇', '10000393', '3');INSERT INTO t_city VALUES ('10003680', '712184', '褒忠乡', '10000393', '3');INSERT INTO t_city VALUES ('10003681', '712185', '东势乡', '10000393', '3');INSERT INTO t_city VALUES ('10003682', '712186', '台西乡', '10000393', '3');INSERT INTO t_city VALUES ('10003683', '712187', '仑背乡', '10000393', '3');INSERT INTO t_city VALUES ('10003684', '712188', '麦寮乡', '10000393', '3');INSERT INTO t_city VALUES ('10003685', '712189', '斗六市', '10000393', '3');INSERT INTO t_city VALUES ('10003686', '712190', '林内乡', '10000393', '3');INSERT INTO t_city VALUES ('10003687', '712191', '古坑乡', '10000393', '3');INSERT INTO t_city VALUES ('10003688', '712192', '莿桐乡', '10000393', '3');INSERT INTO t_city VALUES ('10003689', '712193', '西螺镇', '10000393', '3');INSERT INTO t_city VALUES ('10003690', '712194', '二仑乡', '10000393', '3');INSERT INTO t_city VALUES ('10003691', '712195', '北港镇', '10000393', '3');INSERT INTO t_city VALUES ('10003692', '712196', '水林乡', '10000393', '3');INSERT INTO t_city VALUES ('10003693', '712197', '口湖乡', '10000393', '3');INSERT INTO t_city VALUES ('10003694', '712198', '四湖乡', '10000393', '3');INSERT INTO t_city VALUES ('10003695', '712199', '元长乡', '10000393', '3');INSERT INTO t_city VALUES ('10003696', '712451', '崁顶乡', '10000394', '3');INSERT INTO t_city VALUES ('10003697', '712467', '屏东市', '10000394', '3');INSERT INTO t_city VALUES ('10003698', '712468', '三地门乡', '10000394', '3');INSERT INTO t_city VALUES ('10003699', '712469', '雾台乡', '10000394', '3');INSERT INTO t_city VALUES ('10003700', '712470', '玛家乡', '10000394', '3');INSERT INTO t_city VALUES ('10003701', '712471', '九如乡', '10000394', '3');INSERT INTO t_city VALUES ('10003702', '712472', '里港乡', '10000394', '3');INSERT INTO t_city VALUES ('10003703', '712473', '高树乡', '10000394', '3');INSERT INTO t_city VALUES ('10003704', '712474', '盐埔乡', '10000394', '3');INSERT INTO t_city VALUES ('10003705', '712475', '长治乡', '10000394', '3');INSERT INTO t_city VALUES ('10003706', '712476', '麟洛乡', '10000394', '3');INSERT INTO t_city VALUES ('10003707', '712477', '竹田乡', '10000394', '3');INSERT INTO t_city VALUES ('10003708', '712478', '内埔乡', '10000394', '3');INSERT INTO t_city VALUES ('10003709', '712479', '万丹乡', '10000394', '3');INSERT INTO t_city VALUES ('10003710', '712480', '潮州镇', '10000394', '3');INSERT INTO t_city VALUES ('10003711', '712481', '泰武乡', '10000394', '3');INSERT INTO t_city VALUES ('10003712', '712482', '来义乡', '10000394', '3');INSERT INTO t_city VALUES ('10003713', '712483', '万峦乡', '10000394', '3');INSERT INTO t_city VALUES ('10003714', '712484', '莰顶乡', '10000394', '3');INSERT INTO t_city VALUES ('10003715', '712485', '新埤乡', '10000394', '3');INSERT INTO t_city VALUES ('10003716', '712486', '南州乡', '10000394', '3');INSERT INTO t_city VALUES ('10003717', '712487', '林边乡', '10000394', '3');INSERT INTO t_city VALUES ('10003718', '712488', '东港镇', '10000394', '3');INSERT INTO t_city VALUES ('10003719', '712489', '琉球乡', '10000394', '3');INSERT INTO t_city VALUES ('10003720', '712490', '佳冬乡', '10000394', '3');INSERT INTO t_city VALUES ('10003721', '712491', '新园乡', '10000394', '3');INSERT INTO t_city VALUES ('10003722', '712492', '枋寮乡', '10000394', '3');INSERT INTO t_city VALUES ('10003723', '712493', '枋山乡', '10000394', '3');INSERT INTO t_city VALUES ('10003724', '712494', '春日乡', '10000394', '3');INSERT INTO t_city VALUES ('10003725', '712495', '狮子乡', '10000394', '3');INSERT INTO t_city VALUES ('10003726', '712496', '车城乡', '10000394', '3');INSERT INTO t_city VALUES ('10003727', '712497', '牡丹乡', '10000394', '3');INSERT INTO t_city VALUES ('10003728', '712498', '恒春镇', '10000394', '3');INSERT INTO t_city VALUES ('10003729', '712499', '满州乡', '10000394', '3');INSERT INTO t_city VALUES ('10003730', '712584', '台东市', '10000395', '3');INSERT INTO t_city VALUES ('10003731', '712585', '绿岛乡', '10000395', '3');INSERT INTO t_city VALUES ('10003732', '712586', '兰屿乡', '10000395', '3');INSERT INTO t_city VALUES ('10003733', '712587', '延平乡', '10000395', '3');INSERT INTO t_city VALUES ('10003734', '712588', '卑南乡', '10000395', '3');INSERT INTO t_city VALUES ('10003735', '712589', '鹿野乡', '10000395', '3');INSERT INTO t_city VALUES ('10003736', '712590', '关山镇', '10000395', '3');INSERT INTO t_city VALUES ('10003737', '712591', '海端乡', '10000395', '3');INSERT INTO t_city VALUES ('10003738', '712592', '池上乡', '10000395', '3');INSERT INTO t_city VALUES ('10003739', '712593', '东河乡', '10000395', '3');INSERT INTO t_city VALUES ('10003740', '712594', '成功镇', '10000395', '3');INSERT INTO t_city VALUES ('10003741', '712595', '长滨乡', '10000395', '3');INSERT INTO t_city VALUES ('10003742', '712596', '金峰乡', '10000395', '3');INSERT INTO t_city VALUES ('10003743', '712597', '大武乡', '10000395', '3');INSERT INTO t_city VALUES ('10003744', '712598', '达仁乡', '10000395', '3');INSERT INTO t_city VALUES ('10003745', '712599', '太麻里乡', '10000395', '3');INSERT INTO t_city VALUES ('10003746', '712686', '花莲市', '10000396', '3');INSERT INTO t_city VALUES ('10003747', '712687', '新城乡', '10000396', '3');INSERT INTO t_city VALUES ('10003748', '712688', '太鲁阁', '10000396', '3');INSERT INTO t_city VALUES ('10003749', '712689', '秀林乡', '10000396', '3');INSERT INTO t_city VALUES ('10003750', '712690', '吉安乡', '10000396', '3');INSERT INTO t_city VALUES ('10003751', '712691', '寿丰乡', '10000396', '3');INSERT INTO t_city VALUES ('10003752', '712692', '凤林镇', '10000396', '3');INSERT INTO t_city VALUES ('10003753', '712693', '光复乡', '10000396', '3');INSERT INTO t_city VALUES ('10003754', '712694', '丰滨乡', '10000396', '3');INSERT INTO t_city VALUES ('10003755', '712695', '瑞穗乡', '10000396', '3');INSERT INTO t_city VALUES ('10003756', '712696', '万荣乡', '10000396', '3');INSERT INTO t_city VALUES ('10003757', '712697', '玉里镇', '10000396', '3');INSERT INTO t_city VALUES ('10003758', '712698', '卓溪乡', '10000396', '3');INSERT INTO t_city VALUES ('10003759', '712699', '富里乡', '10000396', '3');INSERT INTO t_city VALUES ('10003760', '712794', '马公市', '10000397', '3');INSERT INTO t_city VALUES ('10003761', '712795', '西屿乡', '10000397', '3');INSERT INTO t_city VALUES ('10003762', '712796', '望安乡', '10000397', '3');INSERT INTO t_city VALUES ('10003763', '712797', '七美乡', '10000397', '3');INSERT INTO t_city VALUES ('10003764', '712798', '白沙乡', '10000397', '3');INSERT INTO t_city VALUES ('10003765', '712799', '湖西乡', '10000397', '3');INSERT INTO t_city VALUES ('10003766', '712896', '南竿乡', '10000398', '3');INSERT INTO t_city VALUES ('10003767', '712897', '北竿乡', '10000398', '3');INSERT INTO t_city VALUES ('10003768', '712898', '东引乡', '10000398', '3');INSERT INTO t_city VALUES ('10003769', '712899', '莒光乡', '10000398', '3');INSERT INTO t_city VALUES ('10003770', '810101', '中西区', '10000399', '3');INSERT INTO t_city VALUES ('10003771', '810102', '湾仔区', '10000399', '3');INSERT INTO t_city VALUES ('10003772', '810103', '东区', '10000399', '3');INSERT INTO t_city VALUES ('10003773', '810104', '南区', '10000399', '3');INSERT INTO t_city VALUES ('10003774', '810201', '九龙城区', '10000400', '3');INSERT INTO t_city VALUES ('10003775', '810202', '油尖旺区', '10000400', '3');INSERT INTO t_city VALUES ('10003776', '810203', '深水埗区', '10000400', '3');INSERT INTO t_city VALUES ('10003777', '810204', '黄大仙区', '10000400', '3');INSERT INTO t_city VALUES ('10003778', '810205', '观塘区', '10000400', '3');INSERT INTO t_city VALUES ('10003779', '810301', '北区', '10000401', '3');INSERT INTO t_city VALUES ('10003780', '810302', '大埔区', '10000401', '3');INSERT INTO t_city VALUES ('10003781', '810303', '沙田区', '10000401', '3');INSERT INTO t_city VALUES ('10003782', '810304', '西贡区', '10000401', '3');INSERT INTO t_city VALUES ('10003783', '810305', '元朗区', '10000401', '3');INSERT INTO t_city VALUES ('10003784', '810306', '屯门区', '10000401', '3');INSERT INTO t_city VALUES ('10003785', '810307', '荃湾区', '10000401', '3');INSERT INTO t_city VALUES ('10003786', '810308', '葵青区', '10000401', '3');INSERT INTO t_city VALUES ('10003787', '810309', '离岛区', '10000401', '3');INSERT INTO t_city VALUES ('10003788', '820101', '澳门半岛', '10000402', '3');INSERT INTO t_city VALUES ('10003789', '820201', '离岛', '10000403', '3');

创建实体类

package org.yscz.entity;import com.fasterxml.jackson.annotation.JSONIgnore;import lombok.Data;import lombok.Getter;@Datapublic class City {        private int id;        @Getter(onMethod = @__( @jsonIgnore))    private int code;        private String name;        @Getter(onMethod = @__( @JsonIgnore))    private int pid;        @Getter(onMethod = @__( @JsonIgnore))    private String type;}

创建mapper接口

package org.yscz.mapper;import org.apache.ibatis.annotations.Mapper;import org.yscz.entity.City;import java.util.List;@Mapperpublic interface CityMapper {    List queryCityByPid(Integer pid);}

创建mapper.xml

            select id,name from t_city        where 1=1                    and  pid = #{pid}            

创建service接口以及实现类

package org.yscz.service;import org.yscz.entity.City;import java.util.List;public interface CityService {    List queryCityByPid(Integer pid);}

package org.yscz.service.impl;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import org.yscz.entity.City;import org.yscz.mapper.CityMapper;import org.yscz.service.CityService;import java.util.List;@Servicepublic class CityServiceImpl implements CityService {    @Autowired    private CityMapper cityMapper;    @Override    public List queryCityByPid(Integer pid) {        return cityMapper.queryCityByPid(pid);    }}

Controllerc接口

package org.yscz.controller;import com.xinktech.core.common.api.Result;import com.xinktech.core.common.api.ResultCode;import io.swagger.annotations.Api;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import org.springframework.WEB.bind.annotation.*;import org.yscz.entity.City;import org.yscz.service.CityService;import java.util.ArrayList;import java.util.Date;import java.util.List;import java.util.Map;@Api("地区数据接口")@RestControllerpublic class CityController {    @Autowired    private CityService cityService;    private static Logger logger = LoggerFactory.getLogger(CityController.class);    @RequestMapping(value = "queryCityData", method = RequestMethod.GET)    @ResponseBody    private Result queryCityData(@RequestBody Map param){        logger.info("queryCityData param{}",param);        try {            Integer pid= Integer.valueOf(param.get("id").toString());            List cities = cityService.queryCityByPid(pid);            return Result.data(200,cities,"");        } catch (Exception e) {            logger.info("queryCityData查询数据错误{}",e);            return Result.fail(ResultCode.ERROR);        }    }}

来源地址：https://blog.csdn.net/txwy12/article/details/129030974