jQuery实现后台异步加载数据的省、市二级联动

最新推荐文章于 2023-07-25 20:38:09 发布
最新推荐文章于 2023-07-25 20:38:09 发布
阅读量2.5k 收藏 3
点赞数
文章标签： jquery hibernate json
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u014298444/article/details/104483557
版权

实现省、市的二级联动，网上的案例大都是死数据，不好和后台交互，于是自己动手写了一个，前台jsp+jquery,后台是spring mvc的controller,用异步来加载数据。废话不多说，上代码！（台湾的市我没有添加，可以自己加一下）

1：SQL文件

/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 5.0.18-nt 
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `bc_area` (
	`ID` int (11),
	`PARENTID` int (11),
	`NAME` varchar (3072),
	`TYPE` int (4),
	`DESCRIPTION` varchar (3072)
); 
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110000','0','北京市','1',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110101','110000','东城区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110102','110000','西城区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110105','110000','朝阳区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110106','110000','丰台区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110107','110000','石景山区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110108','110000','海淀区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110109','110000','门头沟区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110111','110000','房山区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110112','110000','通州区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110113','110000','顺义区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110114','110000','昌平区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110115','110000','大兴区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110116','110000','怀柔区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110117','110000','平谷区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110228','110000','密云县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('110229','110000','延庆县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120000','0','天津市','1',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120101','120000','和平区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120102','120000','河东区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120103','120000','河西区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120104','120000','南开区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120105','120000','河北区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120106','120000','红桥区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120110','120000','东丽区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120111','120000','西青区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120112','120000','津南区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120113','120000','北辰区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120114','120000','武清区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120115','120000','宝坻区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120116','120000','滨海新区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120117','120000','宁河区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120118','120000','静海区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('120225','120000','蓟县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130000','0','河北省','2',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130100','130000','石家庄市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130102','130100','长安区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130104','130100','桥西区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130105','130100','新华区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130107','130100','井陉矿区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130108','130100','裕华区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130109','130100','藁城区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130110','130100','鹿泉区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130111','130100','栾城区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130121','130100','井陉县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130123','130100','正定县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130125','130100','行唐县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130126','130100','灵寿县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130127','130100','高邑县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130128','130100','深泽县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130129','130100','赞皇县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130130','130100','无极县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130131','130100','平山县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130132','130100','元氏县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130133','130100','赵县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130183','130100','晋州市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130184','130100','新乐市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130200','130000','唐山市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130202','130200','路南区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130203','130200','路北区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130204','130200','古冶区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130205','130200','开平区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130207','130200','丰南区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130208','130200','丰润区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130209','130200','曹妃甸区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130223','130200','滦县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130224','130200','滦南县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130225','130200','乐亭县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130227','130200','迁西县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130229','130200','玉田县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130281','130200','遵化市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130283','130200','迁安市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130300','130000','秦皇岛市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130302','130300','海港区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130303','130300','山海关区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130304','130300','北戴河区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130306','130300','抚宁区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130321','130300','青龙满族自治县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130322','130300','昌黎县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130324','130300','卢龙县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130400','130000','邯郸市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130402','130400','邯山区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130403','130400','丛台区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130404','130400','复兴区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130406','130400','峰峰矿区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130421','130400','邯郸县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130423','130400','临漳县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130424','130400','成安县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130425','130400','大名县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130426','130400','涉县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130427','130400','磁县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130428','130400','肥乡县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130429','130400','永年县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130430','130400','邱县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130431','130400','鸡泽县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130432','130400','广平县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130433','130400','馆陶县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130434','130400','魏县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130435','130400','曲周县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130481','130400','武安市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130500','130000','邢台市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130502','130500','桥东区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130503','130500','桥西区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130521','130500','邢台县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130522','130500','临城县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130523','130500','内丘县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130524','130500','柏乡县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130525','130500','隆尧县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130526','130500','任县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130527','130500','南和县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130528','130500','宁晋县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130529','130500','巨鹿县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130530','130500','新河县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130531','130500','广宗县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130532','130500','平乡县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130533','130500','威县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130534','130500','清河县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130535','130500','临西县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130581','130500','南宫市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130582','130500','沙河市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130600','130000','保定市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130602','130600','竞秀区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130606','130600','莲池区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130607','130600','满城区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130608','130600','清苑区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130609','130600','徐水区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130623','130600','涞水县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130624','130600','阜平县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130626','130600','定兴县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130627','130600','唐县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130628','130600','高阳县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130629','130600','容城县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130630','130600','涞源县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130631','130600','望都县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130632','130600','安新县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130633','130600','易县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130634','130600','曲阳县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130635','130600','蠡县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130636','130600','顺平县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130637','130600','博野县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130638','130600','雄县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130681','130600','涿州市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130683','130600','安国市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130684','130600','高碑店市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130700','130000','张家口市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130702','130700','桥东区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130703','130700','桥西区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130705','130700','宣化区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130706','130700','下花园区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130721','130700','宣化县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130722','130700','张北县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130723','130700','康保县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130724','130700','沽源县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130725','130700','尚义县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130726','130700','蔚县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130727','130700','阳原县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130728','130700','怀安县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130729','130700','万全县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130730','130700','怀来县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130731','130700','涿鹿县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130732','130700','赤城县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130733','130700','崇礼县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130800','130000','承德市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130802','130800','双桥区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130803','130800','双滦区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130804','130800','鹰手营子矿区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130821','130800','承德县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130822','130800','兴隆县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130823','130800','平泉县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130824','130800','滦平县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130825','130800','隆化县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130826','130800','丰宁满族自治县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130827','130800','宽城满族自治县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130828','130800','围场满族蒙古族自治县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130900','130000','沧州市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130902','130900','新华区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130903','130900','运河区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130921','130900','沧县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130922','130900','青县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130923','130900','东光县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130924','130900','海兴县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130925','130900','盐山县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130926','130900','肃宁县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130927','130900','南皮县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130928','130900','吴桥县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130929','130900','献县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130930','130900','孟村回族自治县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130981','130900','泊头市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130982','130900','任丘市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130983','130900','黄骅市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('130984','130900','河间市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131000','130000','廊坊市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131002','131000','安次区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131003','131000','广阳区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131022','131000','固安县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131023','131000','永清县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131024','131000','香河县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131025','131000','大城县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131026','131000','文安县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131028','131000','大厂回族自治县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131081','131000','霸州市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131082','131000','三河市','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131100','130000','衡水市','3',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131102','131100','桃城区','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRIPTION`) values('131121','131100','枣强县','4',NULL);
insert into `bc_area` (`ID`, `PARENTID`, `NAME`, `TYPE`, `DESCRI
最低0.47元/天 解锁文章
使徒行者me
关注
jQuery+JSON实现AJAX二级联动实例分析
10-23
在这篇介绍性文章中，我们详细探讨了如何使用jQuery和JSON技术实现AJAX二级联动效果。文章以实例的方式展示了前端使用jQuery框架发送AJAX请求，并且在后端通过C#编写的WebHandler处理数据，将数据库中的信息以JSON...
jquery 省市二级联动
12-05
一段很简单的代码实现的全国二级城市联动选择效果 代码部分很简单，看过即会使用 主要字段内容在city.data.js中，如果需要修改城市名称，到里面找到对应的文字修改，或者添加即可
省市二级联动（jQuery）
藜笙的博客
05-16 510
话不多说，直接上代码。 ​ <!doctype html> <html> <head> <meta charset="utf-8"> <title>无标题文档</title> <script src="js/jquery-3.2.1.js"></script> </head> <body> <select name="" id="selProvince">
jquery ajax实现省市二级联动
07-11
该资源包含了一个使用jquery ajax实现的省市二级联动的简单demo，简单易懂，可以参考博客：http://blog.csdn.net/mockingbirds/article/details/46842327
使用jQuery完成省市二级联动
程序员养成日记
03-09 357
&lt;script&gt; $(function(){ //创建二位数组用于存储省份和城市 var cities=new Array(3); cities[0] = new Array("武汉市","黄冈市","襄阳市","荆州市"); cities[1] = new Array("长沙市","郴州市","株洲市",&qu
JQuery实现省市两级联动
西决987654的博客
12-15 1024
JQuery实现省市两级联动效果
PHP+ajax实现二级联动菜单功能示例
10-18
- 实现二级联动的基本步骤包括：发送异步请求、后台处理请求、返回数据以及前端接收数据并更新页面内容。 2. 掌握HTML与CSS的基本使用： - 在实现二级联动菜单时，需要编写基础的HTML结构来存放下拉菜单，如上面...
Jquery实现的的动态无刷新的二级联动菜单
11-26
在本示例中，我们探讨的是如何利用jQuery实现一个无刷新的二级联动菜单，这涉及到jQuery库、AJAX异步请求以及JSON数据解析等多个关键知识点。 首先，jQuery是一个轻量级的JavaScript库，它简化了DOM操作、事件处理...
SSH结合jquery实现三级联动效果
10-20
SSH结合jquery实现三级联动效果的详细知识点可以分为以下几个部分： 1. 三级联动效果的概念： 三级联动是指在网页上通过用户选择下拉列表中的某一个选项，自动更新其他两个下拉列表的内容，以达到数据联动的目的。...
jquery省市二级联动多选
07-31
NULL 博文链接：https://nkliuliu.iteye.com/blog/983020
jquery插件城市二级联动
10-14
jquery插件城市二级联动 使用简单 数据是以微信地区数据为例
省市二级联动代码与数据库
10-14
省市联动的查询显示页面，查到了省自动将省下面的市显示在页面上！
省市二级联动
weixin_53589418的博客
01-04 155
省市二级联动 <script> // 创建一个二维数组存储城市 var cities=new Array(3); cities[0]=new Array("武汉","黄冈"); cities[1]=new Array("长沙","衡阳"); cities[2]=new Array("郑州","南阳"); cities[3]=new Array("石家
jquery实现中国 省市地址二级联动
qq_32947593的博客
11-03 925
引入本地或线上jquery。
分别使用js和JQuery实现省市二级联动
bigLiu66的博客
09-18 368
1.1html js中this指的是当前操作的对象 &lt;tr&gt; &lt;td&gt;籍贯&lt;/td&gt; &lt;td&gt;&lt;select onchange="changeCity(this.value)" id="province" &gt; &lt;option&gt;--请选择--&l
jQuery省市二级联动实现
二不午的博客
07-15 2826
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>省市联动</title> <script src="../js/jquery-1.11.3.min.js"></script> <script> ...
jQuery实现省、市二级联动
最新发布
07-25 5922
客户端省市二级联动.jsp<html><head>$(function(){/* 指定一个函数，在文档加载完成后被调用。*//* 异步请求 查询省信息 */$.ajax({/* eval() 函数是 JavaScript 中的一个全局函数，它将传入的字符串data作为 JavaScript 代码进行解析和执行。
jQuery之省市二级联动实现
绣花针
07-06 1420
通过jQuery完成对省市二级联动的实现
使用Ajax+jQuery实现二级联动
"该资源主要介绍如何使用Ajax和jQuery实现二级联动效果，即根据选择的省份动态加载对应的城市列表。" 在网页开发中，二级联动通常用于地理信息的选择，如省份和城市，或者类别和子类别等。这种交互方式可以提高用户...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值