您好,登錄后才能下訂單哦!
這篇文章主要講解了“Vue如何實(shí)現(xiàn)級(jí)聯(lián)下拉框”,文中的講解內(nèi)容簡(jiǎn)單清晰,易于學(xué)習(xí)與理解,下面請(qǐng)大家跟著小編的思路慢慢深入,一起來(lái)研究和學(xué)習(xí)“Vue如何實(shí)現(xiàn)級(jí)聯(lián)下拉框”吧!
所有的相關(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 "類(lèi)別種類(lèi):大類(lèi)、中類(lèi)、小類(lèi)", `big_category_name` varchar(64) NOT NULL COMMENT "大類(lèi)名稱(chēng)", `middle_category_name` varchar(64) DEFAULT NULL COMMENT "中類(lèi)名稱(chēng)", `small_category_name` varchar(64) DEFAULT NULL COMMENT "小類(lèi)名稱(chēng)", `parent_id` int(11) DEFAULT NULL, `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `create_user_name` varchar(64) DEFAULT NULL COMMENT "創(chuàng)建人用戶(hù)名", `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;
注:本系統(tǒng)為了減少查詢(xún)次數(shù),故冗余了一些字段,讀者可根據(jù)自己的需求調(diào)整。
核心設(shè)計(jì)在于parent_id,根據(jù)parent_id字段即可查詢(xún)到子類(lèi)
Html代碼如下:
<div class="app-container"> <span style="margin-left:120px;margin-right: 20px;width: 150px;display: inline-block;">大類(lèi):</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;">中類(lèi):</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;">小類(lèi):</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ù)中查詢(xún)出來(lái)的數(shù)據(jù)(駝峰命名),后端只負(fù)責(zé)查詢(xún)、并返回結(jié)果。
Vue中數(shù)據(jù)定義如下:
data() { return { big: "", bigTypes: null, middle: "", middleTypes: null, small: "", smallTypes: null } },
在頁(yè)面初始化時(shí),自動(dòng)獲取大類(lèi)列表:
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 }) },
下面這個(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;">大類(lèi):</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;">中類(lèi):</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;">小類(lèi):</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) //存放此次查詢(xún)結(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如何實(shí)現(xiàn)級(jí)聯(lián)下拉框”的內(nèi)容了,經(jīng)過(guò)本文的學(xué)習(xí)后,相信大家對(duì)Vue如何實(shí)現(xiàn)級(jí)聯(lián)下拉框這一問(wèn)題有了更深刻的體會(huì),具體使用情況還需要大家實(shí)踐驗(yàn)證。這里是億速云,小編將為大家推送更多相關(guān)知識(shí)點(diǎn)的文章,歡迎關(guān)注!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。