全国地址选择器（三级联动）VUE

最新推荐文章于 2024-05-22 18:10:50 发布

莫莫。。。

最新推荐文章于 2024-05-22 18:10:50 发布

阅读量730

点赞数

文章标签： html safari 前端

本文链接：https://blog.csdn.net/qq_46009211/article/details/122328927

版权

附上效果图

地址信息来源于中华人民共和国民政部

http://www.mca.gov.cn/article/sj/xzqh/2020/20201201.html

地址查询查询代码

@Override
    public ResponseModel findProvinceList(Integer id) throws Exception {
        List<Province> provinces = provinceMapper.selectList(new QueryWrapper<Province>()
                .eq(id!=null,"provinceId", id)
                .orderByAsc("provinceId"));
        return ResponseModel.success(ResCode.SUCCESS,provinces);
    }

    @Override
    public ResponseModel findCityListById(Integer id) throws Exception {

        List<City> cities = cityMapper.selectList(new QueryWrapper<City>()
                .eq("provinceId", id)
                .orderByAsc("cityId"));

        return ResponseModel.success(ResCode.SUCCESS,cities);
    }

    @Override
    public ResponseModel findCountyListById(Integer id) throws Exception {
        List<County> counties = countyMapper.selectList(new QueryWrapper<County>()
                .eq("cityId", id)
                .orderByAsc("countyId"));

        return ResponseModel.success(ResCode.SUCCESS,counties);
    }

部分地址信息

----------------------------------------------------------------------------------------------------------------------------------------------河北省
insert into location values(130000,'河北省',0,1,0);
--河北省--石家庄市
insert into location values(130100,'石家庄市',130000,2,0);
--河北省-石家庄市--区
insert into location values(130102,'长安区',130100,3,0);
insert into location values(130104,'桥西区',130100,3,0);
insert into location values(130105,'新华区',130100,3,0);
insert into location values(130107,'井陉矿区',130100,3,0);
insert into location values(130108,'裕华区',130100,3,0);
insert into location values(130109,'藁城区',130100,3,0);
insert into location values(130110,'鹿泉区',130100,3,0);
insert into location values(130111,'栾城区',130100,3,0);
insert into location values(130121,'井陉县',130100,3,0);
insert into location values(130123,'正定县',130100,3,0);
insert into location values(130125,'行唐县',130100,3,0);
insert into location values(130126,'灵寿县',130100,3,0);
insert into location values(130127,'高邑县',130100,3,0);
insert into location values(130128,'深泽县',130100,3,0);
insert into location values(130129,'赞皇县',130100,3,0);
insert into location values(130130,'无极县',130100,3,0);
insert into location values(130131,'平山县',130100,3,0);
insert into location values(130132,'元氏县',130100,3,0);
insert into location values(130133,'赵县',130100,3,0);
insert into location values(130181,'辛集市',130100,3,0);
insert into location values(130183,'晋州市',130100,3,0);
insert into location values(130184,'新乐市',130100,3,0);

--河北省-唐山市
insert into location values(130200,'唐山市',130000,2,0);
--河北省-唐山市--区
insert into location values(130202,'路南区',130200,3,0);
insert into location values(130203,'路北区',130200,3,0);
insert into location values(130204,'古冶区',130200,3,0);
insert into location values(130205,'开平区',130200,3,0);
insert into location values(130207,'丰南区',130200,3,0);
insert into location values(130208,'丰润区',130200,3,0);
insert into location values(130209,'曹妃甸区',130200,3,0);
insert into location values(130224,'滦南县',130200,3,0);
insert into location values(130225,'乐亭县',130200,3,0);
insert into location values(130227,'迁西县',130200,3,0);
insert into location values(130229,'玉田县',130200,3,0);
insert into location values(130281,'遵化市',130200,3,0);
insert into location values(130283,'迁安市',130200,3,0);
insert into location values(130284,'滦州市',130200,3,0);

--河北省-秦皇岛市
insert into location values(130300,'秦皇岛市',130000,2,0);
--河北省-秦皇岛市--区
insert into location values(130302,'海港区',130300,3,0);
insert into location values(130303,'山海关区',130300,3,0);
insert into location values(130304,'北戴河区',130300,3,0);
insert into location values(130306,'抚宁区',130300,3,0);
insert into location values(130321,'青龙满族自治县',130300,3,0);
insert into location values(130322,'昌黎县',130300,3,0);
insert into location values(130324,'卢龙县',130300,3,0);

--河北省-邯郸市
insert into location values(130400,'邯郸市',130000,2,0);
--河北省-邯郸市--区
insert into location values(130402,'邯山区',130400,3,0);
insert into location values(130403,'丛台区',130400,3,0);
insert into location values(130404,'复兴区',130400,3,0);
insert into location values(130406,'峰峰矿区',130400,3,0);
insert into location values(130407,'肥乡区',130400,3,0);
insert into location values(130408,'永年区',130400,3,0);
insert into location values(130423,'临漳县',130400,3,0);
insert into location values(130424,'成安县',130400,3,0);
insert into location values(130425,'大名县',130400,3,0);
insert into location values(130426,'涉县',130400,3,0);
insert into location values(130427,'磁县',130400,3,0);
insert into location values(130430,'邱县',130400,3,0);
insert into location values(130431,'鸡泽县',130400,3,0);
insert into location values(130432,'广平县',130400,3,0);
insert into location values(130433,'馆陶县',130400,3,0);
insert into location values(130434,'魏县',130400,3,0);
insert into location values(130435,'曲周县',130400,3,0);
insert into location values(130481,'武安市',130400,3,0);

--河北省-邢台市
insert into location values(130500,'邢台市',130000,2,0);
--河北省-邢台市--区
insert into location values(130502,'襄都区',130500,3,0);
insert into location values(130503,'信都区',130500,3,0);
insert into location values(130505,'任泽区',130500,3,0);
insert into location values(130506,'南和区',130500,3,0);
insert into location values(130522,'临城县',130500,3,0);
insert into location values(130523,'内丘县',130500,3,0);
insert into location values(130524,'柏乡县',130500,3,0);
insert into location values(130525,'隆尧县',130500,3,0);
insert into location values(130528,'宁晋县',130500,3,0);
insert into location values(130529,'巨鹿县',130500,3,0);
insert into location values(130530,'新河县',130500,3,0);
insert into location values(130531,'广宗县',130500,3,0);
insert into location values(130532,'平乡县',130500,3,0);
insert into location values(130533,'威县',130500,3,0);
insert into location values(130534,'清河县',130500,3,0);
insert into location values(130535,'临西县',130500,3,0);
insert into location values(130581,'南宫市',130500,3,0);
insert into location values(130582,'沙河市',130500,3,0);

--河北省-保定市
insert into location values(130600,'保定市',130000,2,0);
--河北省-保定市--区
insert into location values(130602,'竞秀区', 130600,3,0);
insert into location values(130606,'莲池区', 130600,3,0);
insert into location values(130607,'满城区', 130600,3,0);
insert into location values(130608,'清苑区', 130600,3,0);
insert into location values(130609,'徐水区', 130600,3,0);
insert into location values(130623,'涞水县', 130600,3,0);
insert into location values(130624,'阜平县', 130600,3,0);
insert into location values(130626,'定兴县', 130600,3,0);
insert into location values(130627,'唐县', 130600,3,0);
insert into location values(130628,'高阳县', 130600,3,0);
insert into location values(130629,'容城县', 130600,3,0);
insert into location values(130630,'涞源县', 130600,3,0);
insert into location values(130631,'望都县', 130600,3,0);
insert into location values(130632,'安新县', 130600,3,0);
insert into location values(130633,'易县', 130600,3,0);
insert into location values(130634,'曲阳县', 130600,3,0);
insert into location values(130635,'蠡县', 130600,3,0);
insert into location values(130636,'顺平县', 130600,3,0);
insert into location values(130637,'博野县', 130600,3,0);
insert into location values(130638,'雄县', 130600,3,0);
insert into location values(130681,'涿州市', 130600,3,0);
insert into location values(130682,'定州市', 130600,3,0);
insert into location values(130683,'安国市', 130600,3,0);
insert into location values(130684,'高碑店市', 130600,3,0);

--河北省-张家口市
insert into location values(130700,'张家口市',130000,2,0);
--河北省-张家口市--区
    insert into location values(130702,'桥东区', 130700,3,0);
    insert into location values(130703,'桥西区', 130700,3,0);
    insert into location values(130705,'宣化区', 130700,3,0);
    insert into location values(130706,'下花园区', 130700,3,0);
    insert into location values(130708,'万全区', 130700,3,0);
    insert into location values(130709,'崇礼区', 130700,3,0);
    insert into location values(130722,'张北县', 130700,3,0);
    insert into location values(130723,'康保县', 130700,3,0);
    insert into location values(130724,'沽源县', 130700,3,0);
    insert into location values(130725,'尚义县', 130700,3,0);
    insert into location values(130726,'蔚县', 130700,3,0);
    insert into location values(130727,'阳原县', 130700,3,0);
    insert into location values(130728,'怀安县', 130700,3,0);
    insert into location values(130730,'怀来县', 130700,3,0);
    insert into location values(130731,'涿鹿县', 130700,3,0);
    insert into location values(130732,'赤城县', 130700,3,0);

--河北省-承德市
insert into location values(130800,'承德市',130000,2,0);
--河北省-承德市--区
 insert into location values(130802,'双桥区', 130800,3,0);
    insert into location values(130803,'双滦区', 130800,3,0);
    insert into location values(130804,'鹰手营子矿区', 130800,3,0);
    insert into location values(130821,'承德县', 130800,3,0);
    insert into location values(130822,'兴隆县', 130800,3,0);
    insert into location values(130824,'滦平县', 130800,3,0);
    insert into location values(130825,'隆化县', 130800,3,0);
    insert into location values(130826,'丰宁满族自治县', 130800,3,0);
    insert into location values(130827,'宽城满族自治县', 130800,3,0);
    insert into location values(130828,'围场满族蒙古族自治县', 130800,3,0);
    insert into location values(130881,'平泉市', 130800,3,0);

--河北省-沧州市
insert into location values(130900,'沧州市',130000,2,0);
--河北省-沧州市--区
  insert into location values(130902,'新华区', 130900,3,0);
    insert into location values(130903,'运河区', 130900,3,0);
    insert into location values(130921,'沧县', 130900,3,0);
    insert into location values(130922,'青县', 130900,3,0);
    insert into location values(130923,'东光县', 130900,3,0);
    insert into location values(130924,'海兴县', 130900,3,0);
    insert into location values(130925,'盐山县', 130900,3,0);
    insert into location values(130926,'肃宁县', 130900,3,0);
    insert into location values(130927,'南皮县', 130900,3,0);
    insert into location values(130928,'吴桥县', 130900,3,0);
    insert into location values(130929,'献县', 130900,3,0);
    insert into location values(130930,'孟村回族自治县', 130900,3,0);
    insert into location values(130981,'泊头市', 130900,3,0);
    insert into location values(130982,'任丘市', 130900,3,0);
    insert into location values(130983,'黄骅市', 130900,3,0);
    insert into location values(130984,'河间市', 130900,3,0);


--河北省-廊坊市
insert into location values(131000,'廊坊市',130000,2,0);
--河北省-廊坊市--区
insert into location values(131002,'安次区', 131000,3,0);
    insert into location values(131003,'广阳区', 131000,3,0);
    insert into location values(131022,'固安县', 131000,3,0);
    insert into location values(131023,'永清县', 131000,3,0);
    insert into location values(131024,'香河县', 131000,3,0);
    insert into location values(131025,'大城县', 131000,3,0);
    insert into location values(131026,'文安县', 131000,3,0);
    insert into location values(131028,'大厂回族自治县', 131000,3,0);
    insert into location values(131081,'霸州市', 131000,3,0);
    insert into location values(131082,'三河市', 131000,3,0);

--河北省-衡水市
insert into location values(131100,'衡水',130000,2,0);
--河北省-衡水市--区
    insert into location values(131102,'桃城区', 131100,3,0);
    insert into location values(131103,'冀州区', 131100,3,0);
    insert into location values(131121,'枣强县', 131100,3,0);
    insert into location values(131122,'武邑县', 131100,3,0);
    insert into location values(131123,'武强县', 131100,3,0);
    insert into location values(131124,'饶阳县', 131100,3,0);
    insert into location values(131125,'安平县', 131100,3,0);
    insert into location values(131126,'故城县', 131100,3,0);
    insert into location values(131127,'景县', 131100,3,0);
    insert into location values(131128,'阜城县', 131100,3,0);
    insert into location values(131182,'深州市', 131100,3,0);

下载地址（分为省，市，县三张表）：https://download.csdn.net/download/qq_46009211/74111909

下载地址（不分表）：https://download.csdn.net/download/qq_46009211/74110196