快捷導(dǎo)航

layui實(shí)現(xiàn)下拉框三級聯(lián)動

更新時(shí)間：2019年07月26日 15:01:42 作者：linanqi_java

這篇文章主要為大家詳細(xì)介紹了layui實(shí)現(xiàn)下拉框三級聯(lián)動，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下

項(xiàng)目需要用layui的三級聯(lián)動，自己整理了一下，做個(gè)記錄

1.表結(jié)構(gòu)設(shè)計(jì)

CREATE TABLE `dt_area` (
 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '區(qū)域主鍵',
 `area_name` varchar(16) DEFAULT NULL COMMENT '區(qū)域名稱',
 `area_code` varchar(128) DEFAULT NULL COMMENT '區(qū)域代碼',
 `area_short` varchar(32) DEFAULT NULL COMMENT '區(qū)域簡稱',
 `area_is_hot` varchar(1) DEFAULT NULL COMMENT '是否熱門(0:否、1:是)',
 `area_sequence` int(11) DEFAULT NULL COMMENT '區(qū)域序列',
 `area_parent_id` int(11) DEFAULT NULL COMMENT '上級主鍵',
 `init_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '初始時(shí)間',
 PRIMARY KEY (`id`),
 KEY `parent_id` (`area_parent_id`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=900001 DEFAULT CHARSET=utf8 COMMENT='區(qū)域字典';

2.mybatis xml

<select id="queryByParentId" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
 select
 <include refid="Base_Column_List" />
 from dt_area
 where area_parent_id = #{id,jdbcType=INTEGER}
</select>

根據(jù)上級主鍵查詢

3.頁面元素

<div class="layui-form-item">
  <label class="layui-form-label">地址</label>
  <div class="layui-input-inline">
   <select id="province" lay-filter="province" lay-verify="required" lay-search="">
     <option value="">請選擇或搜索省</option>
   </select>
  </div>
  <div class="layui-input-inline">
   <select id="city" lay-filter="city" lay-verify="required" lay-search="">
     <option value="">請選擇或搜索市</option>
   </select>
  </div>
  <div class="layui-input-inline">
   <select id="area" lay-filter="area" lay-verify="required" lay-search="">
     <option value="">請選擇或搜索縣/區(qū)</option>
   </select>
  </div>
 
  <div class="layui-input-inline" style="width: 45%;">
   <input class="layui-input" id="" lay-verify="required" placeholder="請輸入詳細(xì)地址：城鎮(zhèn)＋鄉(xiāng)村＋街道＋門牌號碼"></input>
  </div>
</div>

4.js

layui.use(['form','layer','jquery'],function(){
  var form = layui.form,
   layer = parent.layer === undefined ? layui.layer : parent.layer,
   $ = layui.jquery;
 
  var provinceText = "";
  var cityText = "";
  var areaText = "";
  //異步加載下拉框數(shù)據(jù)
  $.post(WEB_ROOT+"dtArea/queryByParentId",{"id":0},function (data) {
    if(!data.success){
      layer.msg(data.msg)
    }else{
      var $html = "";
      if(data.data != null) {
        $.each(data.data, function (index, item) {
          $html += "<option value='" + item.id + "'>" + item.areaName + "</option>";
        });
        $("#province").append($html);
        //append后必須從新渲染
        form.render('select');
      }
    }
 
  });
 
  //監(jiān)聽省下拉框
  form.on('select(province)', function(dataObj){
    //移除城市下拉框所有選項(xiàng)
    $("#city").empty();
    var cityHtml = '<option value="">請選擇或搜索市</option>';
    $("#city").html(cityHtml);
    var areaHtml = '<option value="">請選擇或搜索縣/區(qū)</option>';
    $("#area").html(areaHtml);
    provinceText = $("#province").find("option:selected").text();
    var value = $("#province").val();
    //異步加載下拉框數(shù)據(jù)
    $.post(WEB_ROOT+"dtArea/queryByParentId",{"id":value},function (data) {
      if(!data.success){
        layer.msg(data.msg)
      }else{
        var $html = "";
        if(data.data != null) {
          $.each(data.data, function (index, item) {
            $html += "<option value='" + item.id + "'>" + item.areaName + "</option>";
          });
          $("#city").append($html);
          //append后必須從新渲染
          form.render('select');
        }
      }
 
    });
 
  });
 
  //監(jiān)聽市下拉框
  form.on('select(city)', function(dataObj){
    //移除縣區(qū)下拉框所有選項(xiàng)
    $("#area").empty();
    var html = '<option value="">請選擇或搜索縣/區(qū)</option>';
    $("#area").html(html);
 
    cityText = $("#city").find("option:selected").text();
    var value = $("#city").val();
    //異步加載下拉框數(shù)據(jù)
    $.post(WEB_ROOT+"dtArea/queryByParentId",{"id":value},function (data) {
      if(!data.success){
        layer.msg(data.msg)
      }else{
        var $html = "";
        if(data.data != null) {
          $.each(data.data, function (index, item) {
            $html += "<option value='" + item.id + "'>" + item.areaName + "</option>";
          });
          $("#area").append($html);
          //append后必須從新渲染
          form.render('select');
        }
      }
 
    });
 
  });
 
  //監(jiān)聽縣區(qū)下拉框
  form.on('select(area)', function(dataObj){
    areaText = $("#area").find("option:selected").text();
  });
});

5.頁面效果