通过城市联动实时将地址显示到text中

<div class="form-group field-supplier-sort <?php if($model->getErrors('province_id') || $model->getErrors('city_id') || $model->getErrors('district_id')):?>has-error<?php else:?>has-success<?php endif;?>">
    <label class="control-label col-sm-2" for="supplier-sort">配电室所在地区</label>
    <div class="col-sm-10">
        <div class="form-inline citylist">
            <?=Html::activeDropDownList($model, 'province_id', ArrayHelper::merge([0=>'请选择省份'], Area::getArrayForInput(0)), ['class'=>'input-sm form-control', 'tabindex'=>5]);?>
            <?=Html::activeDropDownList($model, 'city_id', ArrayHelper::merge([0=>'请选择城市'], Area::getArrayForInput($model->province_id)), ['class'=>'input-sm form-control', 'tabindex'=>5])?>
            <?=Html::activeDropDownList($model, 'district_id', ArrayHelper::merge([0=>'请选择区域'], Area::getArrayForInput($model->city_id)), ['class'=>'input-sm form-control', 'tabindex'=>5])?>
        </div>
        <div class="help-block help-block-error "><?=$model->getFirstError('province_id') . $model->getFirstError('city_id') . $model->getFirstError('district_id')?></div>
    </div>
</div>
<div class="form-group field-concentrator-voltage has-success">
    <label class="control-label col-sm-2" for="concentrator-voltage">地址</label>
    <div class="col-sm-2">
        <input type="text" id="concentrator-address" class="form-control input-sm cityName" name="Concentrator[address]" value="<?=$model->address;?>" >
        <div class="help-block help-block-error "></div>
    </div>
</div>
<input type="text" id="alladdress" class="form-control input-sm" name="Concentrator[add]" value="<?=$model->addressText?>">
<script type="text/javascript">
    function getcitytext(){//城市联动实时显示
        citytext = '';
        $(".citylist select").each(function(){
            if($(this).val()>0){
                citytext += $(this).find('option:selected').text();
            }else{
                citytext += '';
            }
        });
        $("#alladdress").val(citytext);
    }
    $(function(){
        getcitytext();
        $('#concentrator-province_id').change(function(){
            var parent_id = parseInt($(this).val());
            $.post('<?=Url::to(['/ajax/areaoption'])?>', {parent_id:parent_id, d:'请选择城市'}, function(data){
                if(data) {
                    $('#concentrator-city_id').html(data);
                    $('#concentrator-district_id').html('<option>请选择区域</option>');
                    getcitytext();
                }
            });
        });
        $('#concentrator-city_id').change(function(){
            var parent_id = parseInt($(this).val());
            $.post('<?=Url::to(['/ajax/areaoption'])?>', {parent_id:parent_id, d:'请选择区域'}, function(data){
                if(data) {
                    $('#concentrator-district_id').html(data);
                    getcitytext();
                }
            });
        });
        $(document).on("change", "#concentrator-district_id", function () {
            getcitytext();
        });
    });
</script>

class AjaxController extends Controller {
  public function actionAreaoption(){
     $parentId = intval($_POST['parent_id']);
     $default = $_POST['d'];
     $html = '';
     if ($default) {
        $html .= '<option value="0">' . $default . '</option>';
     }
     if ($parentId > 0) {
     $array = Area::getArrayForInput($parentId);
     foreach ($array as $key=>$value) {
        $html .= '<option value="' . $key . '">' . $value . '</option>';
     }
     }
     echo $html;
  }
}

 

转载于:https://www.cnblogs.com/l-zl/p/6514580.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
以下是一个简单的 Java Web 项目,实现了省份城市二级联动功能。该项目使用了 MySQL 数据库,通过 AJAX 求获取 JSON 格式的省份和城市数据,然后通过 JavaScript 实现了省份和城市的二级联动。 1. 数据库部分: 创建两个表,一个用于存储省份数据,一个用于存储城市数据。在省份表,包含省份的 id、名称和编码;在城市,包含城市的 id、名称、编码和所属省份的 id。 省份表 SQL 语句: ``` CREATE TABLE `province` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; ``` 城市表 SQL 语句: ``` CREATE TABLE `city` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `province_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `idx_province_id` (`province_id`), CONSTRAINT `fk_province_id` FOREIGN KEY (`province_id`) REFERENCES `province` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; ``` 2. 后端部分: 创建一个 Java Servlet,用于处理 ajax 求,并从数据库获取省份和城市的数据。在 doGet() 方法,根据求参数获取对应的省份和城市数据,并将数据以 JSON 格式返回给前端。 ProvinceServlet.java 代码: ```java import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.json.JSONArray; import org.json.JSONObject; public class ProvinceServlet extends HttpServlet { private static final long serialVersionUID = 1L; private static final String DB_DRIVER = "com.mysql.jdbc.Driver"; private static final String DB_URL = "jdbc:mysql://localhost:3306/test"; private static final String DB_USER = "root"; private static final String DB_PASSWORD = "root"; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("application/json"); response.setCharacterEncoding("UTF-8"); String type = request.getParameter("type"); if ("province".equals(type)) { getProvinces(response); } else if ("city".equals(type)) { String provinceCode = request.getParameter("provinceCode"); getCities(response, provinceCode); } } private void getProvinces(HttpServletResponse response) throws IOException { Connection conn = null; PreparedStatement stmt = null; ResultSet rs = null; try { Class.forName(DB_DRIVER); conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD); String sql = "SELECT * FROM province"; stmt = conn.prepareStatement(sql); rs = stmt.executeQuery(); JSONArray provinces = new JSONArray(); while (rs.next()) { JSONObject province = new JSONObject(); province.put("id", rs.getInt("id")); province.put("name", rs.getString("name")); province.put("code", rs.getString("code")); provinces.put(province); } PrintWriter out = response.getWriter(); out.print(provinces); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } finally { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (stmt != null) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } } private void getCities(HttpServletResponse response, String provinceCode) throws IOException { Connection conn = null; PreparedStatement stmt = null; ResultSet rs = null; try { Class.forName(DB_DRIVER); conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD); String sql = "SELECT c.id, c.name, c.code FROM city c JOIN province p ON c.province_id = p.id WHERE p.code = ?"; stmt = conn.prepareStatement(sql); stmt.setString(1, provinceCode); rs = stmt.executeQuery(); JSONArray cities = new JSONArray(); while (rs.next()) { JSONObject city = new JSONObject(); city.put("id", rs.getInt("id")); city.put("name", rs.getString("name")); city.put("code", rs.getString("code")); cities.put(city); } PrintWriter out = response.getWriter(); out.print(cities); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } finally { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (stmt != null) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } } } ``` 3. 前端部分: 在 HTML 页面添加两个 select 标签,一个用于选择省份,一个用于选择城市。给这两个 select 标签分别添加 id,例如:province 和 city。 然后,在 JavaScript ,通过 ajax 发送求,获取省份和城市的数据。在省份 select 标签添加 option 标签,显示所有省份的名称。当用户选择某个省份时,再次发送 ajax 求,获取该省份下的所有城市,并在城市 select 标签添加 option 标签,显示所有城市的名称。 index.html 代码: ```html <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>省份城市二级联动</title> </head> <body> <select id="province"></select> <select id="city"></select> <script src="https://cdn.bootcss.com/jquery/3.4.1/jquery.min.js"></script> <script> $(function() { // 获取所有省份 $.ajax({ url: "ProvinceServlet", type: "GET", data: { type: "province" }, success: function(data) { // 在省份 select 标签添加 option 标签 for (var i = 0; i < data.length; i++) { var option = $("<option>").val(data[i].code).text(data[i].name); $("#province").append(option); } // 触发省份 select 标签的 change 事件 $("#province").trigger("change"); } }); // 当省份 select 标签的值发生变化时,获取该省份下的所有城市 $("#province").on("change", function() { var provinceCode = $(this).val(); $.ajax({ url: "ProvinceServlet", type: "GET", data: { type: "city", provinceCode: provinceCode }, success: function(data) { // 清空城市 select 标签的 option 标签 $("#city").empty(); // 在城市 select 标签添加 option 标签 for (var i = 0; i < data.length; i++) { var option = $("<option>").val(data[i].code).text(data[i].name); $("#city").append(option); } } }); }); }); </script> </body> </html> ``` 4. 部署和运行: 将上述代码保存在一个 Java Web 项目,将 MySQL 驱动程序添加到项目的 classpath ,然后部署到 Tomcat 服务器运行。在浏览器访问该项目的 index.html 页面,即可实现省份城市二级联动功能。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值