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

最新推荐文章于 2024-04-23 10:00:00 发布
最新推荐文章于 2024-04-23 10:00:00 发布
阅读量3.2k 收藏 13
点赞数 6
分类专栏： 笔记 文章标签： 数据库 mysql sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/txwy12/article/details/129030974
版权

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');

2、创建实体类

package org.yscz.entity;

import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Data;
import lombok.Getter;

/**
 * @ClassName: TCity
 * @Description:地区表
 * @Author: 
 * @Date: 2023/2/14 13:36
 **/
@Data
public class City {
    /**
     * 主键
     */
    private int id;
    /**
     * 行政区划代码
     */
    @Getter(onMethod = @__( @JsonIgnore))
    private int code;
    /**
     * 名称
     */
    private String name;
    /**
     * 上级id
     */
    @Getter(onMethod = @__( @JsonIgnore))
    private int pid;
    /**
     * 类型:0=全部,1=省,2=市,3=地级市/区/县
     */
    @Getter(onMethod = @__( @JsonIgnore))
    private String type;
}

3、创建mapper接口

package org.yscz.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.yscz.entity.City;

import java.util.List;

/**
 * @ClassName: CityMapper
 * @Description:
 * @Author: 
 * @Date: 2023/2/14 14:28
 **/
@Mapper
public interface CityMapper {

    List<City> queryCityByPid(Integer pid);
}

4、创建mapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.yscz.mapper.CityMapper">

    <select id="queryCityByPid" parameterType="integer" resultType="org.yscz.entity.City">
        select id,name from t_city
        where 1=1
        <if test = "pid != null">
            and  pid = #{pid}
        </if>
    </select>

</mapper>

5、创建service接口以及实现类

package org.yscz.service;

import org.yscz.entity.City;

import java.util.List;

/**
 * @ClassName: TCityService
 * @Description:
 * @Author: 
 * @Date: 2023/2/14 14:42
 **/
public interface CityService {

    List<City> 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;

/**
 * @ClassName: TCityServiceImpl
 * @Description:
 * @Author: 
 * @Date: 2023/2/14 14:43
 **/
@Service
public class CityServiceImpl implements CityService {
    @Autowired
    private CityMapper cityMapper;

    @Override
    public List<City> queryCityByPid(Integer pid) {
        return cityMapper.queryCityByPid(pid);
    }
}

6、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;

/**
 * @ClassName: CityController
 * @Description:
 * @Author:
 * @Date: 2023/2/14 14:49
 **/
@Api("地区数据接口")
@RestController
public 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<String, Object> param){
        logger.info("queryCityData param{}",param);
        try {
            Integer pid= Integer.valueOf(param.get("id").toString());
            List<City> cities = cityService.queryCityByPid(pid);
            return Result.data(200,cities,"");
        } catch (Exception e) {
            logger.info("queryCityData查询数据错误{}",e);
            return Result.fail(ResultCode.ERROR);
        }
    }

}
txwy12
关注
  • 6
    点赞
  • 踩
  • 13
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
java省市_关于省，市，区联动 java 实现方式
weixin_34457338的博客
02-12 2053
关于省，市，区的三级联动后台的实现有两种方式：1：分三次请求各自取出 省 市 区 的数据；2：一次请求获得所有的数据，并且组装成相依的数据结构到前端；其中第一种方式：会导致数据的延迟加载，出现的情况是 省 有数据了，市和区一级还没有数据，导致用户的体验不好；这种方式只有省一级的数据可以提前加载好，市和区一级的数据只用等到选中后才开始请求；第二种实现方式：1):查出省--->遍历省，查出省下面...
JAVA——三级联动 省 市 区
z1427094386的博客
06-19 2951
JAVA 分页效果实现 整体架构为 后端代码 dao层 的接口 省份 的dao的接口 package src.cn.hp.dao; import src.cn.hp.model.Provice; import java.util.List; public interface ProviceInfoDao { /** * 查询所有的省份信息 * @return 省份数据 */ public List<Provice> findAll(); }
java后端实现省市区三级联动接口查询及数据库表上
txwy12的博客
02-14 1243
【代码】java后端实现省市区三级联动接口查询及数据库表上。
省市区地址查询接口：方便获取地址相关信息
最新发布
m0_57991918的博客
04-23 563
接口返回的结果中，`status`字段表示接口调用的状态，如果为1，则表示查询成功；无论是在地图应用中查找目的地，还是在电商平台中填写收货地址，亦或是在物流系统中进行路线规划，我们都可以通过省市区地址查询接口来获取所需的地址信息，提供更好的用户体验和服务质量。在调用接口时，需要传入参数`address`，即需要查询的地址，还需要传入参数`key`，该参数为接口的访问密钥，用于验证调用者的身份。需要注意的是，为了能够正常使用省市区地址查询接口，我们需要在调用时传入正确的地址信息，并确保使用有效的访问密钥。
若依前后端分离版实现省市区三级联动
qq_55005912的博客
12-05 2376
若依前后端分离版实现省市区三级联动。
java实现省市区三级联动
百创科技
07-11 2820
我的想法很简单 ，可能想的有点少，首先遍历省份，当数据发生改变调用方法请求根据省的id去查询市区的信息，当市区信息发生改变调用另一个方法去查询县区的信息。，（个人觉得两个接口层公用一个也行，就像那种公用一个的改为mapper接口层那种的也很方便，可能这样比较不规范吧）6、最后映射页面：jsp。
java省市区三级联动
Ansee
10-06 612
省市区三级联动，树形结构children嵌套
JAVA查询城市地区接口方法,JAVA 获取省市区(根据字符或者根据百度API经纬度获取)...
weixin_31829293的博客
03-11 2625
.*)";Matcher m=Pattern.compile(regex).matcher(address);String[] citys=SpecialCounty.split(",");ListspecialCountyList = Arrays.asList(citys);String province,city,county=null;CityInfo info=new CityInfo(...
获取中国省、市、区数据（调用高德API）
热门推荐
qq_41634323的博客
07-26 1万+
获取省市区数据
2018最新版省市区三级联动下拉框+所有源代码以及数据库
liulan93的博客
12-13 5741
2018年国家统计局最新数据，JSP+Servlet+Dao实现省市区三级联动下拉框的效果 DropdownDAO.java —–Dao层  package com; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; i...
java三级联动
01-15
Java实现省县市三级联动。。。。。。。。。。。。。。。。。。。。。。
java获取省市县数据
08-03
NULL 博文链接：https://jie-bosshr.iteye.com/blog/1995816
全国省市县行政区划数据(地区名称数据)
07-16
全国的省、市、县行政区划数据，省市县三级之间的关系通过编码及编码位数来区分，两位编码的是省级数据，四位编码的市级数据，六位的县区数据，比较适合用于PowerDesigner中去建立行政区划信息表时做初始数据导入使用。 注意这个资源是针对sql server的建库及插入数据脚本，不是access格式的数据库，是sql脚本。
java web省市县级联操作
07-05
里面有数据库，通过数据库读取省市县，进行级联操作。
中国省份城市联动下拉列表（省市联动菜单）
03-28
版本：v1.2 ----------------------------------------------- (C) Oran Day(likecode#gmail.com) ----------------------------------------------- ----------------------------------------------- 文件夹说明： - ChinaRegions_Complained 已编译后的dll - ChinaRegions_Source - 服务器控件源码项目 - html - 演示代码级源测试代码 ----------------------------------------------- ----------------------------------------------- ChinaRegion 文件名：OranChinaRegion.dll 自我说明XML：OranChinaRegion.XML 描述： 中国行政区域二级联系菜单，根据上级行政区加载下级行政区列表 XML数据驱动，可自定义添加、删除，简易更新 支持回发恢复状态，已正确设定行政区可自动选定和加载各级行政区数据 其它说明： 应用网站必须存在行政区域的数据XML文件，默认放于应用页面同级目录的oran/regions下，其中regions.xml为一级行政区数据，其它均为二级行政区数据 可自定义修改XML目录，在web.config/appSettings/ChinaRegionXmlFolderPath 配置，e.g.:/oran/regions 创建实例至少指定 runat 和 ID 属性。 应用： 1.为网站添加DLL引用 引用OranChinaRegion.dll 2.复制XML文件至网站 3.注册控件 e.g.: 4.在您期望的位置插入该控件, e.g.: 5.获取值 ParentRegion 获取或设置一级行政区 ChildRegion 获取或设置二级行政区 e.g: string parRgn = region1.ParentRegion; if (parRgn.Length > 0) Response.Write("您选择的是：" + parRgn); string chdRgn = region1.ChildRegion; if (chdRgn.Length > 0) Response.Write(" - " + chdRgn); 6.减少网络传输量，提高网络传输效率，您可以将XML压缩再应用于实际网站。 7.更多参数请参考自我说明XML。 8.期待您报告BUG:)。 -----------------------------------------------
前端jquery+后端servlet实现三级联动项目省市区
04-25
这个项目“前端jquery+后端servlet实现三级联动项目省市区”就是一个典型的案例，它展示了如何利用jQuery在前端处理用户交互，以及如何通过Servlet在后端进行数据处理和传输。下面我们将详细探讨这个项目中的关键...
java 省市区三级联动
08-16
总的来说，"java 省市区三级联动"是一个结合了前后端技术的问题，涉及到Java后端服务的开发、数据库设计、JavaScript前端交互以及浏览器兼容性处理等多个方面。理解并熟练掌握这些知识点对于一个全栈开发者来说至关...
region_3级_省市区三级联动数据库_
10-01
"region_3级_省市区三级联动数据库_" 提供了一个专门针对中国省市区三级联动的数据结构，这种设计通常用于用户选择地址时提供流畅的交互体验。在网页或应用程序中，用户可以依次选择省份、城市和区县，确保输入的...
java省市区街道数据
05-15
Java省市区街道数据是指在Java编程语言中，提供了一个完整的、规范的、包含省份、城市、区、街道等级别的区域划分信息库。这个数据库可以使用Java进行操作，查询、处理等。这个数据库的优势主要包括以下几个方面： 1. 数据准确性高: 数据库的信息源来自权威渠道并经过维护和更新，数据的准确性得到保证。 2. 数据规范性高: 数据库遵从国家《行政区划代码》标准，拥有完整的行政区域名称及对应的区划代码。 3. 数据操作性强: 数据库架构完整，可以通过Java语言进行数据的查询、筛选、过滤、排序等各种数据处理操作。 4. 数据应用范围广泛: 数据库可以用于多种应用场合，例如：数据挖掘、分析、统计、智慧城市建设等。 Java省市区街道数据的适用场景包括但不限于以下情况： 1. 地址解析: 可以根据用户输入的地址信息，通过数据库匹配得到正确的行政区划信息。 2. 配送物流: 可以通过数据表按照省市区划分发货和管理货物。 3. 数据统计: 可以进行数据分析及大数据挖掘等业务场景。 4. 业务筛选: 可以根据业务需求筛选特定行政区域内的数据信息。 总之，Java省市区街道数据是Java编程语言中一个很重要的数据源，可以为开发者提供快速的区域信息查询及处理功能。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值