Ajax-增删改查实现

一、Ajax-查询全部

简介	查询楼宇，可以根据任何条件进⾏查询（如查询指定的楼宇名称等）。默认是查询所有楼宇。无分页显示
ip	http://112.74.63.8
端口	8081
请求路径	/api/v1/budding/getBuddings
请求类型	GET
参数名	buddingname、address、propertyunit、region
状态码定义	1000：请求正确响应；3000：请求出错；如程序出现异常，参数不正确等

• 正确JSON示例：

{
    "status": 1000,
    "msg": "OK",
    "data": {
        "list": [
            {
                "id": 1,
                "buddingname": 楼宇1,
                "address": "广东省广州市海珠区聚德中路87号",
                "propertyunit": 河南新乡拉斐国际1号楼A梯,
                "region": 广州市,
                "inserttime": null,
                "updatetime": null
            }
        ],
     }
}

• 查询全部-ajax代码段：

<script type="text/javascript">
$(function(){
        $.ajax({
        url:"http://112.74.63.8:8081/api/v1/budding/getBuddings",
        type:"GET",
        dataType:'json',
        contentType:"application/json;charset=utf-8",
        success:function(data){
            //成功连接api接口
            if(data.status == "1000"){  
            //获取api接口传过来的数据
            var list = data.data.list;
            for(var i = 0; i < list.length; i++){
            var ids = list[i].id;
            var buddingname = list[i].buddingname;
            var address = list[i].address;
            var propertyunit = list[i].propertyunit;
            var region = list[i].region;
            var idsddd = ids;
            //输出格式并填充
            //1.复选框；2.数据库里的序号；3.楼宇名称；4.地址；5.产权单位；6.市；7.编辑按钮。
            //ajax里按钮只能用input属性。
            var tr = "<tr>" +
                "<td><input type='checkbox' name='checkbox' value='"+ids+"'/>" + "</td>"+ 
                "<td>" + ids + "</td>"+ 
                "<td>" + buddingname + "</td>"+
                "<td>" + address + "</td>" +
                "<td>" + propertyunit + "</td>" +
                "<td>" + region +"</td>"+
                "<td><input type='button' id='edit' name='edit' value='编辑'>" + "</td>"+
                "</tr>";
            //将查得的数据每一条都插入到表格中  
            $("#tbMain").append(tr); 
            }
        }
    },
    error: function(content) {
        alert("失败");
    }
    }); 
});
</script>

实现效果：图1

二、Ajax-条件查询

简介	根据任何条件进⾏查询（如查询指定的楼宇名称等）。无分页显示
ip	http://112.74.63.8
端口	8081
请求路径	/api/v1/budding/getBuddings
请求类型	GET
参数名	buddingname、address、propertyunit、region
状态码定义	1000：请求正确响应；3000：请求出错；如程序出现异常，参数不正确等
示例1	http://localhost:8082/api/v1/budding/getBuddings?address=yyfffyy 这个表示查询楼宇地址为yyffyy的所有楼宇
示例2	http://localhost:8082/api/v1/budding/getBuddings?address=yyfffyy&buddingname=fff 这个表示查询楼宇地址为yyffyy并且楼宇名为fff的所有楼宇

• 正确JSON示例：

{
    "status": 1000,
    "msg": "OK",
    "data": {
        "list": [
            {
                "id": 1,
                "buddingname": 楼宇1,
                "address": "广东省广州市海珠区聚德中路87号",
                "propertyunit": 河南新乡拉斐国际1号楼A梯,
                "region": 广州市,
                "inserttime": null,
                "updatetime": null
            }
        ],
     }
}

• 条件查询-ajax代码段：

<script type="text/javascript">
//搜查按钮
$("input[id='search']").click(function(){ 
    //清空table界面里的填充数据，但保留css样式及表头
    $("#dataTables tr:not(:first)").empty("");
    //编写url后缀格式
    var string_search;
    var string_search0 = "buddingname=";
    var string_search1 = "address=";
    var string_search2 = "propertyunit=";
    //获取搜索框的值
    var buddingname_ss = $('#buddingname_search').val();
    var address_ss = $('#address_search').val();
    var propertyunit_ss = $('#propertyunit_search').val();
    //判断搜索框的值是否为空
    if (buddingname_ss != '') {
            string_search = string_search0 + buddingname_ss;
    }
    if (address_ss != '') {
            string_search += "&" + string_search1 + address_ss;
    }
    if (propertyunit_ss != '') {
            string_search += "&" + string_search2 + propertyunit_ss;
    }

    $.ajax({ 
                url:"http://112.74.63.8:8081/api/v1/budding/getBuddings?"+string_search,
                type:"GET",
                dataType:'json',
                contentType: "application/json;charset=utf-8",

                success:function(data){
                    console.log(data);
                    console.log(data.msg);
                    if(data.status == "1000"){
                    //获取接口数据
                    var list = data.data.list;
                    for(var i = 0; i < list.length; i++){
                    var ids = list[i].id;
                    var buddingname = list[i].buddingname;
                    var address = list[i].address;
                    var propertyunit = list[i].propertyunit;
                    var region = list[i].region;
                    var idsddd = ids;
                    var tr = "<tr>" +
                        "<td><input type='checkbox' name='checkbox' value='"+ids+"'/>" + "</td>"+
                        "<td>" + ids + "</td>"+
                        "<td>" + buddingname + "</td>"+
                        "<td>" + address + "</td>" +
                        "<td>" + propertyunit + "</td>" +
                        "<td>" + region +"</td>"+
                        "<td><input type='button' id='edit' name='edit' value='编辑'>" + "</td>"+
                        "</tr>";
                    //将查得的数据每一条都插入到表格中 
                    $("#tbMain").append(tr); 
                    }
                    }
                    }, 
                error: function(content) {
                    alert("失败");
                }
    });

});
</script>

实现效果：图2

三、Ajax-删除

简介	根据楼宇id删除楼宇，支持批量删除(也就是可以传入多个楼宇的id,用于删除)。无分页显示
ip	http://112.74.63.8
端口	8081
请求路径	/api/v1/budding/deleteBudding
请求类型	GET
参数名	ids
状态码定义	1000：请求正确响应；3000：请求出错；如程序出现异常，参数不正确等
示例1	http://localhost:8082/api/v1/budding/deleteBudding?ids=12&ids=13&ids=14 这个表述删除id为12，13，14的楼宇

• 正确JSON示例：

{
    "status": 1000,
    "msg": "楼宇删除成功",
    "data": null
}

• 删除功能-ajax代码段：

<script type="text/javascript">
//删除按钮
$("input[id='delete_buildInfor']").click(function(){ 
        // 编辑url后缀格式
        var ids;
        var stringIds_1 = "ids=";
        var stringIds;

        // 获取复选框选定状态
        var checkboxs = document.getElementsByName("checkbox");
        for(i=0;i<checkboxs.length;i++){
            if(checkboxs[i].checked == true){
                ids = checkboxs[i].value;
                if (i == 0) {
                    stringIds =  stringIds_1 + ids;
                }else{
                    stringIds += "&" + stringIds_1 + ids;
                }
            }
        }
            $.ajax({       
                url:"http://112.74.63.8:8081/api/v1/budding/deleteBudding?"+stringIds,
                type:"GET",
                dataType:'json',
                contentType: "application/json;charset=utf-8",
                success:function(data){
                    console.log(data);
                    console.log(data.msg);

                    if(data.status == "1000"){
                        alert("删除成功!");
                        //重新刷新界面
                        window.location.href = "24buildingInformation.html"; 
                    }
                    else{
                        alert("删除失败，请重试!");
                    }
                },
                error: function(content) {
                    alert("失败");
                }
            });
}); 
</script>

实现效果：略

四、Ajax-修改

简介	根据楼宇id，获取楼宇信息。
ip	http://112.74.63.8
端口	8081
请求路径	/api/v1/budding/getBudding/id
请求类型	GET
状态码定义	1000：请求正确响应；3000：请求出错；如程序出现异常，参数不正确等
示例1	http://127.0.0.1:8082/api/v1/budding/getBudding/15 表示查询楼宇id为15的信息

• 正确JSON示例：

{
    "status": 1000,
    "msg": "OK",
    "data": {
        "id": 15,
        "buddingname": "fff",
        "address": "yyfffyy",
        "propertyunit": "sdfaads",
        "region": "hasdfasdfhhh",
        "inserttime": "2018-11-03 16:39:34",
        "updatetime": null
    }
}

简介	根据楼宇id，更新楼宇信息。
ip	http://112.74.63.8
端口	8081
请求路径	/api/v1/budding/updateBudding
请求类型	POST
请求参数	其中id是必传项，表示需要更新的楼宇id，然后其他的参数为非必需传入的参数，也就是需要更新那项就传入更新的项即可
状态码定义	1000：请求正确响应；3000：请求出错；如程序出现异常，参数不正确等

• 正确JSON示例：

{
    "status": 1000,
    "msg": "楼宇更新成功",
    "data": null
}

• 更改功能-ajax代码段：

<script type="text/javascript">
//编辑按钮
$(document).on('click', '#edit', function () {
    //获取该行id，在此序号列为id值。
    var td_get = $(this).parents("tr").find("td");
    var id_get = td_get.eq(1).text();
    
    $.ajax({  
             url:"http://112.74.63.8:8081/api/v1/budding/getBudding/"+id_get,
             type:"GET",
             dataType:'json',
             contentType: "application/json;charset=utf-8",
             success:function(data){
            if(data.status == "1000"){
            
            //获取该id的所有属性值
            var id = data.data.id; 
            var buddingname = data.data.buddingname; 
            var address = data.data.address;
            var propertyunit = data.data.propertyunit;
            var region = data.data.region;
            
            //清空当前界面
            $("#dataTables").empty("");
            $("#jz").empty("");
            $("#ys").empty("");
            
            //将id的所有属性值，赋值到编辑界面，即可编辑的文本框中
            //disabled='disabled' 表示不可更改
            var text = "<form>" +
                "楼宇id："+ "<br>" + "<input type='text' value='"+id+"' id='id_edit' disabled='disabled'>"+ "</br>"+
                "<br>" +"楼宇名称："+ "<br>" + "<input type='text' value='"+buddingname+"' id='buddingname_edit'>"+ "</br>"+ 
                "<br>" + "楼宇地址："+ "<br>" + "<input type='text' value='"+address+"' id='address_edit'>"+ "</br>"+
                "<br>" + "楼宇产权单位："+ "<br>" + "<input type='text' value='"+propertyunit+"' id='propertyunit_edit'>"+ "</br>"+
                "<br>" + "区域："+ "<br>" + "<input type='text' value='"+region+"' id='region_edit'>"+ "</br>"+            
                "<br>" + "<input type='button' id='save_edit' value='保存'><input type='button' id='cancel_edit' value='取消'>"+ "<br>" + 
                "</form>";
           $("#light1").append(text);
            }
            },
            error: function(content) {
                   alert("失败");
            }
    });  

    
});

//在编辑界面，取消editTd编辑按钮
$(document).on('click', '#cancel_edit', function () {
   //此方法是自己写的，局部刷新页面，重新加载数据
   window.location.href="24buildingInformation.html";
});

//在编辑界面，保存editTd编辑按钮
$(document).on('click', '#save_edit', function () {
    //获取编辑界面里，文本框内的值
    var id_save = $("#id_edit").val();
    var buddingname_save = $("#buddingname_edit").val();
    var address_save = $("#address_edit").val();
    var propertyunit_save = $("#propertyunit_edit").val();
    var region_save = $("#region_edit").val();  
    var data= {id:id_save,buddingname:buddingname_save,address:address_save,propertyunit:propertyunit_save,region:region_save};
   //输出当前td值
    $.ajax({
                type:"POST",
                contentType:'application/json;charset=UTF-8',
                url:"http://112.74.63.8:8081/api/v1/budding/updateBudding",
                //将值转换为api可接受的json格式
                dataType:'json',
                data:JSON.stringify(data),

                success:function(data){
                    console.log(data);
                    console.log(data.msg);

                    if(data.status == "1000"){
                        alert("更新成功!");
                        window.location.href = "24buildingInformation.html"; 
                    }
                    else{
                        alert("更新失败，请重试!");
                    }

                },
                error: function(content) {
                    alert("失败");
                }
            });

   
});
</script>

实现效果：图3

五、Ajax-新增

简介	新增一条楼宇信息
ip	http://112.74.63.8
端口	8081
请求路径	/api/v1/budding/insertBudding
请求类型	POST
参数名	buddingname、address、propertyunit、region
状态码定义	1000：请求正确响应；3000：请求出错；如程序出现异常，参数不正确等

• 正确JSON示例：

{
    "status": 1000,
    "msg": "楼宇插入成功",
    "data": null
}

• 新增功能-ajax代码段：

<script type="text/javascript">
//新增按钮
$("input[id='submit_message']").click(function(){
            //获取文本框内输入的值
            var buddingname = $.trim($("#buddingname").val());
            var address = $.trim($("#address").val());
            var propertyunit = $.trim($("#propertyunit").val());
            var region = $.trim($("#city").val());
            var data= {buddingname:buddingname,address:address,propertyunit:propertyunit,region:region};

            $.ajax({
                type:"POST",
                contentType:'application/json;charset=UTF-8',
                url:"http://112.74.63.8:8081/api/v1/budding/insertBudding",
                dataType:'json',
                data:JSON.stringify(data),

                success:function(data){
                    console.log(data);
                    console.log(data.msg);

                    if(data.status == "1000"){
                        alert("新增成功!");
                        window.location.href = "24buildingInformation.html"; 
                    }
                    else{
                        alert("新增失败，请重试!");
                    }

                },
                error: function(content) {
                    alert("失败");
                }
            });
        });
</script>

实现效果：图4

六、前端html主要代码

• 搜查文本框代码&及table代码

<div id="jz">
                            <label>楼宇名称</label>
                            <input id="buddingname_search" name="buddingname_search" type="text" >

                            <label>楼宇地址</label>
                            <input id="address_search" name="address_search"  type="text" >

                            <label>楼宇产权公司</label>
                            <input id="propertyunit_search" name="propertyunit_search"  type="text">

                            <input type="button" id="search"  value="查询">
                            <input type="button" id="increase_buildInfor" value="新增" onclick = "openDialog()">//弹窗函数
                            <input type="button" id="delete_buildInfor" value="删除">
                            
</div>
                       
<div class="panel-body">
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered table-hover" id="dataTables">

                                    <thead id="thead1">
                                        <tr>
                                            <th>选择</th>
                                            <th>序号</th>
                                            <th>楼宇名</th><!-- buddingname -->
                                            <th>地址</th><!-- address -->
                                            <th>产权</th><!-- propertyunit -->
                                            <th>区域</th><!-- region -->
                                            <th>编辑</th> 
                                        </tr>
                                    </thead>
                                    <br>
                                    <tbody id="tbMain"></tbody>
                                </table>
                            </div>
                            <div id="light1"></div> //弹窗
</div>

• 弹窗代码

//前端代码
//注意：放到<body></body>里，不要影响主界面的响应。
<div id="light" class="white_content">
    <form role="form">
                                        <div class="form-group">
                                            <label>楼宇名称</label>
                                            <input class="form-control" id="buddingname" type="text" name="buddingname">
                                        </div>
                                        <div class="form-group">
                                            <label>楼宇地址</label>
                                            <input class="form-control" id="address" type="text" name="address">
                                        </div>                                
                                        <div class="form-group">
                                            <label>产权公司</label>
                                            <input class="form-control" id="propertyunit" type="text" name="propertyunit">
                                        </div>
                                        <div class="form-group">
                                            <label>区域</label>
                                            <select id="province" name="province" onChange = "select()" class="form-control">
                                            </select>
                                            <select id="city" name="city" class="form-control">
                                            </select>
                                        </div>
                                        <div class="submit-w3l">
                                        <input type="button" id="submit_message" value="提交">
                                        <input type="button" value="关闭" onclick = "closeDialog()">
                                        </div>

    </form>
    </div> 

/*弹窗css */
div.white_content { 
            display: none; 
            position: absolute; 
            top: 25%; 
            left: 25%; 
            width: 55%; 
            height: 55%; 
            padding: 20px; 
            border: 10px solid gray; 
            background-color: white; 
            z-index:1002; 
            overflow: auto; 
} 

//弹窗的跳出及关闭函数
<script type="text/javascript">
        $(function(){
        })
        function openDialog(){
            document.getElementById('light').style.display='block';
            //document.getElementById('fade').style.display='block'
        }
        function closeDialog(){
            document.getElementById('light').style.display='none';
            //document.getElementById('fade').style.display='none'
        }
</script>

• 省市下拉菜单

1. 设置初始值

<body onload="initCities('直辖市','北京')"></body>

2. 调用js函数

/*参考‘六，弹窗代码’*/
<select id="province" name="province" onChange = "select()" ></select>
<select id="city" name="city" class="form-control"></select>

3. 引入js文件

<script src=".../../cities.js"></script>

//不能导入文件，这里列出cities.js代码，自行建立cities.js文件。
var where = new Array(32);
 
function comefrom(loca,locacity) { this.loca = loca; this.locacity = locacity; }
 
where[0]= new comefrom("选择省份","选择城市");
where[1] = new comefrom("直辖市","选择城市|北京|上海|天津|重庆"); 
where[2] = new comefrom("特别行政区","选择城市|香港|澳门");  
where[3] = new comefrom("河北","选择城市|石家庄|邯郸|邢台|保定|张家口|承德|廊坊|唐山|秦皇岛|沧州|衡水");
where[4] = new comefrom("山西","选择城市|太原|大同|阳泉|长治|晋城|朔州|吕梁|忻州|晋中|临汾|运城");
where[5] = new comefrom("内蒙古","选择城市|呼和浩特|包头|乌海|赤峰|呼伦贝尔盟|阿拉善盟|哲里木盟|兴安盟|乌兰察布盟|锡林郭勒盟|巴彦淖尔盟|伊克昭盟");
where[6] = new comefrom("辽宁","选择城市|沈阳|大连|鞍山|抚顺|本溪|丹东|锦州|营口|阜新|辽阳|盘锦|铁岭|朝阳|葫芦岛");
where[7] = new comefrom("吉林","选择城市|长春|吉林|四平|辽源|通化|白山|松原|白城|延边");
where[8] = new comefrom("黑龙江","选择城市|哈尔滨|齐齐哈尔|牡丹江|佳木斯|大庆|绥化|鹤岗|鸡西|黑河|双鸭山|伊春|七台河|大兴安岭");
where[9] = new comefrom("江苏","选择城市|南京|镇江|苏州|南通|扬州|盐城|徐州|连云港|常州|无锡|宿迁|泰州|淮安");
where[10] = new comefrom("浙江","选择城市|杭州|宁波|温州|嘉兴|湖州|绍兴|金华|衢州|舟山|台州|丽水");
where[11] = new comefrom("安徽","选择城市|合肥|芜湖|蚌埠|马鞍山|淮北|铜陵|安庆|黄山|滁州|宿州|池州|淮南|巢湖|阜阳|六安|宣城|亳州");
where[12] = new comefrom("福建","选择城市|福州|厦门|莆田|三明|泉州|漳州|南平|龙岩|宁德");
where[13] = new comefrom("江西","选择城市|南昌市|景德镇|九江|鹰潭|萍乡|新馀|赣州|吉安|宜春|抚州|上饶");
where[14] = new comefrom("山东","选择城市|济南|青岛|淄博|枣庄|东营|烟台|潍坊|济宁|泰安|威海|日照|莱芜|临沂|德州|聊城|滨州|菏泽");
where[15] = new comefrom("河南","选择城市|郑州|开封|洛阳|平顶山|安阳|鹤壁|新乡|焦作|濮阳|许昌|漯河|三门峡|南阳|商丘|信阳|周口|驻马店|济源");
where[16] = new comefrom("湖北","选择城市|武汉|宜昌|荆州|襄樊|黄石|荆门|黄冈|十堰|恩施|潜江|天门|仙桃|随州|咸宁|孝感|鄂州");
where[17] = new comefrom("湖南","选择城市|长沙|常德|株洲|湘潭|衡阳|岳阳|邵阳|益阳|娄底|怀化|郴州|永州|湘西|张家界");
where[18] = new comefrom("广东","选择城市|广州|深圳|珠海|汕头|东莞|中山|佛山|韶关|江门|湛江|茂名|肇庆|惠州|梅州|汕尾|河源|阳江|清远|潮州|揭阳|云浮");
where[19] = new comefrom("广西","选择城市|南宁|柳州|桂林|梧州|北海|防城港|钦州|贵港|玉林|南宁地区|柳州地区|贺州|百色|河池");
where[20] = new comefrom("海南","选择城市|海口|三亚");
where[21] = new comefrom("四川","选择城市|成都|绵阳|德阳|自贡|攀枝花|广元|内江|乐山|南充|宜宾|广安|达川|雅安|眉山|甘孜|凉山|泸州");
where[22] = new comefrom("贵州","选择城市|贵阳|六盘水|遵义|安顺|铜仁|黔西南|毕节|黔东南|黔南");
where[23] = new comefrom("云南","选择城市|昆明|大理|曲靖|玉溪|昭通|楚雄|红河|文山|思茅|西双版纳|保山|德宏|丽江|怒江|迪庆|临沧");
where[24] = new comefrom("西藏","选择城市|拉萨|日喀则|山南|林芝|昌都|阿里|那曲");
where[25] = new comefrom("陕西","选择城市|西安|宝鸡|咸阳|铜川|渭南|延安|榆林|汉中|安康|商洛");
where[26] = new comefrom("甘肃","选择城市|兰州|嘉峪关|金昌|白银|天水|酒泉|张掖|武威|定西|陇南|平凉|庆阳|临夏|甘南");
where[27] = new comefrom("宁夏","选择城市|银川|石嘴山|吴忠|固原");
where[28] = new comefrom("青海","选择城市|西宁|海东|海南|海北|黄南|玉树|果洛|海西");
where[29] = new comefrom("新疆","选择城市|乌鲁木齐|石河子|克拉玛依|伊犁|巴音郭勒|昌吉|克孜勒苏柯尔克孜|博尔塔拉|吐鲁番|哈密|喀什|和田|阿克苏");
where[30] = new comefrom("台湾","选择城市|台北|高雄|台中|台南|屏东|南投|云林|新竹|彰化|苗栗|嘉义|花莲|桃园|宜兰|基隆|台东|金门|马祖|澎湖");
where[31] = new comefrom("国外","选择城市|德国|新加坡|美国|加拿大|澳大利亚|日本|英国|巴西|俄罗斯|尼日利亚|马来西亚|爱尔兰|奥地利|挪威|意大利|西班牙|泰国|芬兰|丹麦|荷兰|阿联酋|瑞典|瑞士|比利时|新西兰|法国|韩国|匈牙利|越南|以色列|科威特|希腊|南非|葡萄牙|墨西哥|印尼|其他");
 
function select() {
	with(document.getElementById("province")) { var loca2 = options[selectedIndex].value; }
	for(i = 0;i < where.length;i ++) {
		if (where[i].loca == loca2) {
				loca3 = (where[i].locacity).split("|");
				for(j = 0;j < loca3.length;j++) { 
					with(document.getElementById("city")) { 
						length = loca3.length; 
						options[j].text = loca3[j]; 
						options[j].value = loca3[j]; 
					//	var loca4=options[selectedIndex].value;
					}
				}
				break;
		}
	}
} 
 
 
function initCities(province,city) {
	var flag = 0;
	with(document.getElementById("province")) {
		length = where.length;
		for(k=0;k<where.length;k++) { 
			options[k].text = where[k].loca; 
			options[k].value = where[k].loca; 
			if(province !=null && province == where[k].loca){
				//带有数值的初始化
				options[k].text = "选择省份"; 
				options[k].value = "选择省份";
				flag = 1;
			}
		}
		if(province !=null && province != ""){
			options[selectedIndex].text = province; 
			options[selectedIndex].value = province;
		}else{
			options[selectedIndex].text = where[0].loca; 
			options[selectedIndex].value = where[0].loca;
		}
	}
	with(document.getElementById("city")) {
		//未选择省份
		if(flag == 0){
			var loca3 = (where[0].locacity).split("|");
			length = loca3.length;
			for(var l=0;l<length;l++) { 
				options[l].text = loca3[l]; 
				options[l].value = loca3[l]; 
			}
			options[selectedIndex].text = loca3[0]; 
			options[selectedIndex].value = loca3[0];
		}else{
		//选择了省份,先遍历找出省份的where
			temp= 0;
			for(var p=0;p<where.length;p++){
				if(where[p].loca == province)
					break;
			}
			var loca4 = (where[p].locacity).split("|");
			length = loca4.length;
			for(var c=0; c< length;c++){
				options[c].text = loca4[c];
				options[c].value = loca4[c];
				if(city == loca4[c]){
					options[c].text = "选择城市";
					options[c].value = "选择城市";
					temp = c;
				}
			}
			options[selectedIndex].text = loca4[temp]; 
			options[selectedIndex].value = loca4[temp];
		}
	}
}