久久久精品一区ed2k-女人被男人叉到高潮的视频-中文字幕乱码一区久久麻豆樱花-俄罗斯熟妇真实视频

Vue級(jí)聯(lián)下拉框怎么實(shí)現(xiàn)

今天小編給大家分享一下Vue級(jí)聯(lián)下拉框怎么實(shí)現(xiàn)的相關(guān)知識(shí)點(diǎn),內(nèi)容詳細(xì),邏輯清晰,相信大部分人都還太了解這方面的知識(shí),所以分享這篇文章給大家參考一下,希望大家閱讀完這篇文章后有所收獲,下面我們一起來(lái)了解一下吧。

創(chuàng)新互聯(lián)是一家專業(yè)的成都網(wǎng)站建設(shè)公司,我們專注成都網(wǎng)站制作、成都網(wǎng)站設(shè)計(jì)、外貿(mào)營(yíng)銷網(wǎng)站建設(shè)、網(wǎng)絡(luò)營(yíng)銷、企業(yè)網(wǎng)站建設(shè),買友情鏈接,廣告投放為企業(yè)客戶提供一站式建站解決方案,能帶給客戶新的互聯(lián)網(wǎng)理念。從網(wǎng)站結(jié)構(gòu)的規(guī)劃UI設(shè)計(jì)到用戶體驗(yàn)提高,創(chuàng)新互聯(lián)力求做到盡善盡美。

1.數(shù)據(jù)庫(kù)設(shè)計(jì)

所有的相關(guān)數(shù)據(jù)皆可存在一張表中,這樣數(shù)據(jù)就可以不受層級(jí)的限制。

表結(jié)構(gòu)可以參考如下建表SQL:

CREATE TABLE `supplies_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_type` varchar(64) NOT NULL COMMENT "類別種類:大類、中類、小類",
  `big_category_name` varchar(64) NOT NULL COMMENT "大類名稱",
  `middle_category_name` varchar(64) DEFAULT NULL COMMENT "中類名稱",
  `small_category_name` varchar(64) DEFAULT NULL COMMENT "小類名稱",
  `parent_id` int(11) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user_name` varchar(64) DEFAULT NULL COMMENT "創(chuàng)建人用戶名",
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `is_deleted` tinyint(1) DEFAULT "0" COMMENT "是否刪除,1表示已刪除",
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

數(shù)據(jù)庫(kù)截圖如下圖所示,注:本系統(tǒng)為了減少查詢次數(shù),故冗余了一些字段,讀者可根據(jù)自己的需求調(diào)整。

Vue級(jí)聯(lián)下拉框怎么實(shí)現(xiàn)

核心設(shè)計(jì)在于parent_id,根據(jù)parent_id字段即可查詢到子類,結(jié)果如下圖所示:

Vue級(jí)聯(lián)下拉框怎么實(shí)現(xiàn)

Vue級(jí)聯(lián)下拉框怎么實(shí)現(xiàn)

2.前端頁(yè)面

前端頁(yè)面效果如下:

Vue級(jí)聯(lián)下拉框怎么實(shí)現(xiàn)

Html代碼如下:

<div class="app-container">
    <span style="margin-left:120px;margin-right: 20px;width: 150px;display: inline-block;">大類:</span>
    <el-select v-model="big" placeholder="請(qǐng)選擇" @change="getSuppliesType(big)" style="width: 19%;">
      <el-option
        v-for="item in bigTypes"
        :key="item.bigCategoryName"
        :label="item.bigCategoryName"
        :value="item.id">
      </el-option>
    </el-select>
    <span style="margin-left:120px;margin-right: 20px; width: 150px;display: inline-block;">中類:</span>
    <el-select v-model="middle" placeholder="請(qǐng)選擇" @change="getSuppliesType(middle)" style="width: 19%;">
      <el-option
        v-for="item in middleTypes"
        :key="item.middleCategoryName"
        :label="item.middleCategoryName"
        :value="item.id">
      </el-option>
    </el-select>
    <br>
    <br>
    <br>
    <span style="margin-left:120px;margin-right: 20px;width: 150px; margin-top:20px; display: inline-block;">小類:</span>
    <el-select v-model="small" placeholder="請(qǐng)選擇" style="width: 19%;">
      <el-option
        v-for="item in smallTypes"
        :key="item.smallCategoryName"
        :label="item.smallCategoryName"
        :value="item.id">
      </el-option>
    </el-select>
</div>

上面的item.smallCategoryName、item.smallCategoryName數(shù)據(jù)為后端從數(shù)據(jù)庫(kù)中查詢出來(lái)的數(shù)據(jù)(駝峰命名),后端只負(fù)責(zé)查詢、并返回結(jié)果。

Vue中數(shù)據(jù)定義如下:

data() {
    return {
        big: "",
        bigTypes: null,
        middle: "",
        middleTypes: null,
        small: "",
        smallTypes: null
    }
},

在頁(yè)面初始化時(shí),自動(dòng)獲取大類列表:

created() {
		this.getSuppliesType(0)
},

頁(yè)面中的getSuppliesType方法如下:

getSuppliesType(id) {
  this.listLoading = true
  const queryData = {
    parentId: id
  }
  //此處的調(diào)用后端接口按照自己的調(diào)用方式寫(xiě)即可
  //此處的getSuppliersType是項(xiàng)目中自己封裝的util中的方法
  //如果請(qǐng)求方式是post,JSON.stringify(queryData)
  //如果請(qǐng)求方式是get,queryData
  getSuppliersType(JSON.stringify(queryData)).then(response => {
    console.log(response)
    console.log(response.data[0].categoryType)
    //根據(jù)type自動(dòng)向三個(gè)下拉框賦值
    if (response.data[0].categoryType === "BIG") {
      this.bigTypes = response.data
    } else if (response.data[0].categoryType === "MIDDLE") {
      this.middleTypes = response.data
    } else {
      this.smallTypes = response.data
    }
    this.listLoading = false
  }).catch(function (error) {
    console.log(error)
    this.listLoading = false
  })
},

3.一個(gè)完整的demo

下面這個(gè)頁(yè)面為完成代碼,其中的數(shù)據(jù)為部分?jǐn)?shù)據(jù),后臺(tái)接口獲取使用JS來(lái)完成。

<template>
  <div class="app-container">
    <span style="margin-left:120px;margin-right: 20px;width: 150px;display: inline-block;">大類:</span>
    <el-select v-model="big" placeholder="請(qǐng)選擇" @change="getSuppliesType(big)" style="width: 19%;">
      <el-option
        v-for="item in bigTypes"
        :key="item.bigCategoryName"
        :label="item.bigCategoryName"
        :value="item.id">
      </el-option>
    </el-select>
    <span style="margin-left:120px;margin-right: 20px; width: 150px;display: inline-block;">中類:</span>
    <el-select v-model="middle" placeholder="請(qǐng)選擇" @change="getSuppliesType(middle)" style="width: 19%;">
      <el-option
        v-for="item in middleTypes"
        :key="item.middleCategoryName"
        :label="item.middleCategoryName"
        :value="item.id">
      </el-option>
    </el-select>
    <br>
    <br>
    <br>
    <span style="margin-left:120px;margin-right: 20px;width: 150px; margin-top:20px; display: inline-block;">小類:</span>
    <el-select v-model="small" placeholder="請(qǐng)選擇" style="width: 19%;">
      <el-option
        v-for="item in smallTypes"
        :key="item.smallCategoryName"
        :label="item.smallCategoryName"
        :value="item.id">
      </el-option>
    </el-select>
    <br>
    <br>
    <br>
    <el-button type="primary" round style="margin-left:280px" @click.native.prevent="commit">添加</el-button>
    <el-button type="primary" round style="margin-left:100px" @click.native.prevent="cancel">取消</el-button>
  </div>
</template>

<script>
    export default {
        filters: {
            parseTime(timestamp) {
                return parseTime(timestamp, null)
            }
        },
        data() {
            return {
                big: "",
                bigTypes: null,
                middle: "",
                middleTypes: null,
                small: "",
                smallTypes: null,
                dataList: [
                    {"id":1,"categoryType":"BIG","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":null,"smallCategoryName":null,"parentId":0,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":"2021-07-04T13:34:31.000+0000","isDeleted":false},
                    {"id":27,"categoryType":"BIG","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":null,"smallCategoryName":null,"parentId":0,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":2,"categoryType":"MIDDLE","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.1現(xiàn)場(chǎng)監(jiān)測(cè)","smallCategoryName":null,"parentId":1,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":10,"categoryType":"MIDDLE","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.2現(xiàn)場(chǎng)安全","smallCategoryName":null,"parentId":1,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":3,"categoryType":"SMALL","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.1現(xiàn)場(chǎng)監(jiān)測(cè)","smallCategoryName":"1.1.1氣象監(jiān)測(cè)","parentId":2,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":4,"categoryType":"SMALL","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.1現(xiàn)場(chǎng)監(jiān)測(cè)","smallCategoryName":"1.1.2地震監(jiān)測(cè)","parentId":2,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":5,"categoryType":"SMALL","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.1現(xiàn)場(chǎng)監(jiān)測(cè)","smallCategoryName":"1.1.3地質(zhì)災(zāi)害監(jiān)測(cè)","parentId":2,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":6,"categoryType":"SMALL","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.1現(xiàn)場(chǎng)監(jiān)測(cè)","smallCategoryName":"1.1.4水文監(jiān)測(cè)","parentId":2,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":7,"categoryType":"SMALL","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.1現(xiàn)場(chǎng)監(jiān)測(cè)","smallCategoryName":"1.1.5環(huán)境監(jiān)測(cè)","parentId":2,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":8,"categoryType":"SMALL","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.1現(xiàn)場(chǎng)監(jiān)測(cè)","smallCategoryName":"1.1.6疫病監(jiān)測(cè)","parentId":2,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":9,"categoryType":"SMALL","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.1現(xiàn)場(chǎng)監(jiān)測(cè)","smallCategoryName":"1.1.7觀察測(cè)量","parentId":2,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":11,"categoryType":"SMALL","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.2現(xiàn)場(chǎng)安全","smallCategoryName":"1.2.1現(xiàn)場(chǎng)照明","parentId":10,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":12,"categoryType":"SMALL","bigCategoryName":"1.現(xiàn)場(chǎng)管理與保障","middleCategoryName":"1.2現(xiàn)場(chǎng)安全","smallCategoryName":"1.2.2現(xiàn)場(chǎng)警戒","parentId":10,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":28,"categoryType":"MIDDLE","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.1人員安全防護(hù)","smallCategoryName":null,"parentId":27,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":34,"categoryType":"MIDDLE","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.2生命搜救與營(yíng)救","smallCategoryName":null,"parentId":27,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":"2021-07-04T13:03:23.000+0000","isDeleted":false},
                    {"id":29,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.1人員安全防護(hù)","smallCategoryName":"2.1.1衛(wèi)生防疫","parentId":28,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":30,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.1人員安全防護(hù)","smallCategoryName":"2.1.2消防防護(hù)","parentId":28,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":31,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.1人員安全防護(hù)","smallCategoryName":"2.1.3化學(xué)與放射","parentId":28,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":32,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.1人員安全防護(hù)","smallCategoryName":"2.1.4防高空墜落","parentId":28,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":33,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.1人員安全防護(hù)","smallCategoryName":"2.1.5通用防護(hù)","parentId":28,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":35,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.2生命搜救與營(yíng)救","smallCategoryName":"2.2.1生命搜索","parentId":34,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":36,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.2生命搜救與營(yíng)救","smallCategoryName":"2.2.2攀巖營(yíng)救","parentId":34,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":37,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.2生命搜救與營(yíng)救","smallCategoryName":"2.2.3破拆起重","parentId":34,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":38,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.2生命搜救與營(yíng)救","smallCategoryName":"2.2.4水下?tīng)I(yíng)救","parentId":34,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false},
                    {"id":39,"categoryType":"SMALL","bigCategoryName":"2.生命救援與生活救助","middleCategoryName":"2.2生命搜救與營(yíng)救","smallCategoryName":"2.2.5通用工具","parentId":34,"createTime":"2021-07-04T11:13:36.000+0000","createUserName":null,"updateTime":null,"isDeleted":false}
                    ]
            }
        },
        created() {
            this.getSuppliesType(0)
        },
        methods: {
            getSuppliesType(id) {
                const queryData = {
                    parentId: id
                }
                //此處為js模擬,真實(shí)數(shù)據(jù)的獲取還需要后臺(tái)接口的支持
                getSuppliersType(JSON.stringify(queryData)).then(response => {
                    console.log(response)
                    console.log(response.data[0].categoryType)
                    //存放此次查詢結(jié)果
                    let tmpList = []
                    this.dataList.forEach((item, index) => {
                        if(item.parentId === id){
                            tmpList.push(item)
                        }
                    })
                    if (tmpList[0].categoryType === "BIG") {
                        this.bigTypes = tmpList
                    } else if (response.data[0].categoryType === "MIDDLE") {
                        this.middleTypes = tmpList
                    } else {
                        this.smallTypes = tmpList
                    }
                }).catch(function (error) {
                    console.log(error)
                })
            },
            commit() {
                console.log("點(diǎn)擊了提交按鈕")
            },
            cancel() {
                this.$router.go(-1)
            }
        }
    }
</script>

以上就是“Vue級(jí)聯(lián)下拉框怎么實(shí)現(xiàn)”這篇文章的所有內(nèi)容,感謝各位的閱讀!相信大家閱讀完這篇文章都有很大的收獲,小編每天都會(huì)為大家更新不同的知識(shí),如果還想學(xué)習(xí)更多的知識(shí),請(qǐng)關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道。

分享文章:Vue級(jí)聯(lián)下拉框怎么實(shí)現(xiàn)
轉(zhuǎn)載來(lái)源:http://sd-ha.com/article20/popgco.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供企業(yè)網(wǎng)站制作、面包屑導(dǎo)航、網(wǎng)站導(dǎo)航、用戶體驗(yàn)網(wǎng)站排名、網(wǎng)站內(nèi)鏈

廣告

聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)

綿陽(yáng)服務(wù)器托管