省市县三级联动

三级联动的代码*(心情很差呀,白忙了一上午,说要搞离线的,记录下来呗,已被不时之需)

function hdfsUpload(){
                     cmApi.request.httpGetAsync('/xzqh/getXzqh',JSON.stringify({"province":"province"}),'mainModule.xzqh');
    }
    function xzqh(ret){


           var  province = [];

            var len = ret.length;

            for (var i = 0;i < len;i++){
                             var objPro = {};

                             objPro["p_id"] =  ret[i].ggfwXzqhCjdm;
                             objPro["name"] = ret[i].ggfwXzqhCjmc;
                             province.push(objPro);
            }
            var select = $("#pro");

               select.empty();

            var lenPro = province.length;
           for (var j = 0;j < lenPro;j++){
                   var options = '<option value="'+province[j].p_id+'" >'
                                + province[j].name
                                +'</option>';
                    select.append(options);
            }
  cmApi.request.httpGetAsync('/xzqh/getXzqhsj',JSON.stringify({"proId":province[0].p_id}),'mainModule.xzqhsj');
            $("#pro").change(function(){
                cmApi.request.httpGetAsync('/xzqh/getXzqhsj',JSON.stringify({"proId":$(this).val()}),'mainModule.xzqhsj');

            })

    }
    function xzqhsj(ret){
                    var  sjArr = [];
                    var len = ret.length;
                    for (var i = 0;i < len;i++){
                                        var objPro = {};

                                     objPro["sj_id"] =  ret[i].ggfwXzqhCjdm;
                                     objPro["name"] = ret[i].ggfwXzqhCjmc;
                                     sjArr.push(objPro);
                    }
                    var select = $("#sj");
                    select.empty();
                    var lenPro = sjArr.length;
                   for (var j = 0;j < lenPro;j++){
                           var options = '<option value="'+sjArr[j].sj_id+'" >'
                                        + sjArr[j].name
                                        +'</option>';
                            select.append(options);
                    }
   cmApi.request.httpGetAsync('/xzqh/getXzqhxj',JSON.stringify({"sjId":sjArr[0].sj_id}),'mainModule.xzqhxj');
                     $("#sj").change(function(){
                                 // alert($(this).val());
                                   cmApi.request.httpGetAsync('/xzqh/getXzqhxj',JSON.stringify({"sjId":$(this).val()}),'mainModule.xzqhxj');

                                })

    }
    function xzqhxj(ret){
                                   var  xjArr = [];
                                    var len = ret.length;
                                    for (var i = 0;i < len;i++){
                                                     var objPro = {};
                                                     objPro["xj_id"] =  ret[i].ggfwXzqhCjdm;
                                                     objPro["name"] = ret[i].ggfwXzqhCjmc;
                                                     xjArr.push(objPro);
                                    }
                                    var select = $("#xj");
                                       select.empty();
                                    var lenPro = xjArr.length;
                                   for (var j = 0;j < lenPro;j++){
                                           var options = '<option value="'+xjArr[j].xj_id+'" >'
                                                        + xjArr[j].name
                                                        +'</option>';
                                            select.append(options);
                                    }

    }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
之前从网上找的三级联动都太老了,数据也都是很久之前的数据,所以自己把从国家统计局扒下来的省市三级联动数据做了整理,目前最新的三级联动,童叟无欺。大家看北京市和天津市的几个分区就知道是最新的了。 INSERT INTO `address` VALUES (1, '110000', 0, '北京市', 1); INSERT INTO `address` VALUES (2, '110100', 110000, '市辖区', 2); INSERT INTO `address` VALUES (3, '110101', 110100, '东城区', 3); INSERT INTO `address` VALUES (4, '110102', 110100, '西城区', 3); INSERT INTO `address` VALUES (5, '110105', 110100, '朝阳区', 3); INSERT INTO `address` VALUES (6, '110106', 110100, '丰台区', 3); INSERT INTO `address` VALUES (7, '110107', 110100, '石景山区', 3); INSERT INTO `address` VALUES (8, '110108', 110100, '海淀区', 3); INSERT INTO `address` VALUES (9, '110109', 110100, '门头沟区', 3); INSERT INTO `address` VALUES (10, '110111', 110100, '房山区', 3); INSERT INTO `address` VALUES (11, '110112', 110100, '通州区', 3); INSERT INTO `address` VALUES (12, '110113', 110100, '顺义区', 3); INSERT INTO `address` VALUES (13, '110114', 110100, '昌平区', 3); INSERT INTO `address` VALUES (14, '110115', 110100, '大兴区', 3); INSERT INTO `address` VALUES (15, '110116', 110100, '怀柔区', 3); INSERT INTO `address` VALUES (16, '110117', 110100, '平谷区', 3); INSERT INTO `address` VALUES (17, '110118', 110100, '密云区', 3); INSERT INTO `address` VALUES (18, '110119', 110100, '延庆区', 3); INSERT INTO `address` VALUES (19, '120000', 0, '天津市', 1); INSERT INTO `address` VALUES (20, '120100', 120000, '市辖区', 2); INSERT INTO `address` VALUES (21, '120101', 120100, '和平区', 3); INSERT INTO `address` VALUES (22, '120102', 120100, '河东区', 3); INSERT INTO `address` VALUES (23, '120103', 120100, '河西区', 3); INSERT INTO `address` VALUES (24, '120104', 120100, '南开区', 3); INSERT INTO `address` VALUES (25, '120105', 120100, '河北区', 3); INSERT INTO `address` VALUES (26, '120106', 120100, '红桥区', 3); INSERT INTO `address` VALUES (27, '120110', 120100, '东丽区', 3); INSERT INTO `address` VALUES (28, '120111', 120100, '西青区', 3); INSERT INTO `address` VALUES (29, '120112', 120100, '津南区', 3); INSERT INTO `address` VALUES (30, '120113', 120100, '北辰区', 3); INSERT INTO `address` VALUES (31, '120114', 120100, '武清区', 3); INSERT INTO `address` VALUES (32, '120115', 120100, '宝坻区', 3); INSERT INTO `address` VALUES (33, '120116', 120100, '滨海新区', 3); INSERT INTO `address` VALUES (34, '120117', 120100, '宁河区', 3); INSERT INTO `address` VALUES (35, '120118', 120100, '静海区', 3); INSERT INTO `address` VALUES (36, '120119', 120100, '蓟州区', 3);

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

helloworddm

你的鼓励是我创作最大的动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值