㈠ mfc濡備綍灝嗘爲褰㈡帶浠惰礬寰勪繚瀛樿嚦緙栬緫妗
閫夋嫨鏂囦歡榪欎釜紿楀彛鏄浣犺嚜宸卞啓鐨勫悧錛熷傛灉鏄浣犺嚜宸卞啓鐨勶紝閭ｄ箞灝辮佸湪嫻忚堥偅涓鎸夐挳鎵鍦ㄥ硅瘽妗嗗寘鍚榪欎釜瀵硅瘽妗嗙殑澶存枃浠躲傜劧鍚庡畾涔変竴涓鏂囦歡閫夋嫨瀵硅瘽妗嗙殑綾伙紝鐢ㄨ繖涓綾昏幏寰楁爲褰㈡帶浠墮噷闈㈢殑鏂囦歡璺寰勪繚瀛樺埌鍘熸潵鐨勫硅瘽妗嗕腑
㈡ 璇鋒暀鏄撹璦鐨勬爲鍨嬫嗗拰淇濆瓨鏁版嵁
鈥樹笉鐢ㄥ栭儴鏁版嵁搴擄紝娣誨姞涓涓鏁版嵁搴撹繛鎺1鎺т歡錛
鈥欏亣璁懼簱鏂囦歡鍚嶄負鈥滀駭鍝佹暟鎹搴.mdb鈥濓紝搴撲腑鐨勮〃鍚嶄負鈥滀駭鍝佽〃鈥濓紝浜у搧瀛楁靛悕鈥滅被鍒鈥
鍏ㄥ矓鍙橀噺錛歛 鏂囨湰鍨
濡傛灉鐪燂紙鏁版嵁搴撹繛鎺1.榪炴帴Access錛堝彇榪愯岀洰褰曪紙錛+鈥\浜у搧鏁版嵁搴.mdb鈥濓紝鈥溾濓級=鍋囷級
淇℃伅妗嗭紙鈥滆繛鎺ユ暟鎹搴撳け璐ワ紒鈥濓紝0錛岋級
榪斿洖錛堬級
鈥欐坊鍔犱竴涓璁板綍闆嗘帶浠訛紱
璁板綍闆1.緗榪炴帴錛堟暟鎹搴撹繛鎺1錛
鈥樹笂闈㈡垜浠宸茬粡鎵撳紑騫朵笖榪炴帴濂戒簡MDB鏁版嵁搴擄紝鎺ヤ笅鏉ユ垜浠鍋氳誨彇鍜屾樉紺猴紱
璁板綍闆1.鎵撳紑錛堚渟elect * from 浜у搧琛ㄢ濓紝#SQL璇鍙ワ紝#鏈嶅姟鍣ㄧ娓告爣錛
璁板綍闆1.鍒伴栬板綍錛堬級
鍒ゆ柇寰鐜棣栵紙璁板綍闆1.灝捐板綍鍚=鍋囷級
璁板綍闆1.璇繪枃鏈錛堚滅被鍒鈥濓紝a錛
濡傛灉鐪燂紙a=鈥滄棩鐢ㄥ搧鈥濓級
鏍戝瀷妗1.鍔犲叆欏圭洰錛0錛宎錛岋紝錛岋紝錛岋級
濡傛灉鐪燂紙a=鈥滄礂鍖栫敤鍝佲濓級
鏍戝瀷妗1.鍔犲叆欏圭洰錛1錛宎錛岋紝錛岋紝錛岋級
濡傛灉鐪燂紙a=鈥滄礂鍙戞按鈥 鎴 a=鈥滄礂琛ｇ矇鈥濓級
鏍戝瀷妗1.鍔犲叆欏圭洰錛2錛宎錛岋紝錛岋紝錛岋級
璁板綍闆1.鍒頒笅涓鏉★紙錛
鍒ゆ柇寰鐜灝撅紙錛
璁板綍闆1.鍏抽棴錛堬級
㈢ 璇﹁В濡備綍瀹炵幇Element鏍戝艦鎺т歡Tree鍦ㄦ噿鍔犺澆妯″紡涓嬬殑鍔ㄦ佹洿鏂
Element鎻愪緵鐨凾ree鏍戝艦鎺т歡錛屽彲浠ョ敤娓呮櫚鐨勫眰綰х粨鏋勫睍紺轟俊鎮錛岃繕鍙浠ュ睍寮鎴栨姌鍙犮俆ree鏀鎸佷袱縐嶅姞杞芥ā寮忥細涓嬈℃у姞杞藉叏閮ㄦ爲鑺傜偣鍜屾噿鍔犺澆妯″紡銆傛墍璋撴噿鍔犺澆妯″紡錛屾槸鎸囧綋闇瑕佸睍寮鐖惰妭鐐規椂鎵嶆覆鏌撳瓙鑺傜偣銆傛噿鍔犺澆妯″紡鐨勫簲鐢ㄥ満鏅閫傚悎鏍戣妭鐐規暟鎹閲忓ぇ鐨勬儏褰錛屽湪涓瀹氱▼搴︿笂鍙浠ヤ紭鍖栧浘褰㈢敤鎴風晫闈㈢殑鍝嶅簲鏁堢巼浠ュ強鎻愬崌鐢ㄦ埛浣撻獙銆備絾鏄錛屾噿鍔犺澆妯″紡瀵規暟鎹鍔ㄦ佸埛鏂板簲鐢ㄩ渶奼傜殑鏀鎸佷笉灝藉傛剰銆傛爲褰㈡帶浠惰妭鐐逛竴鏃﹀睍寮灝辯紦瀛樺湪鏈鍦幫紝鍚庣畫涓嶄細鍐嶇戶緇鏇存柊鍜屽埛鏂拌妭鐐規暟鎹銆傛湰鏂囧皢浠嬬粛濡備綍瀹炵幇Element鏍戝艦鎺т歡Tree鍦ㄦ噿鍔犺澆妯″紡涓嬬殑鍔ㄦ佹洿鏂般傚叿浣撻渶奼傚備笅鍥炬墍紺猴細
鍔ㄦ佹洿鏂伴渶奼
褰揝elect閫夋嫨鍣ㄩ夋嫨綆卞彉銆侀嗗彉鍣ㄣ佹眹嫻佺辨垨緇勪覆絳夌被鍨嬫椂錛孴ree鏍戝艦鎺т歡浼氬姩鎬佸埛鏂版樉紺虹浉搴旂被鍨嬬殑璁懼囧悕縐般傛垜浠鐭ラ亾鍦ㄦ噿鍔犺澆妯″紡涓嬶紝Tree鏍戝艦鎺т歡鑺傜偣涓鏃﹀睍寮錛屽氨涓嶅啀閲嶆柊鍔犺澆鑺傜偣鏁版嵁銆傞偅涔堝備綍瀹炵幇鍦ㄩ夋嫨涓嶅悓綾誨瀷鏃跺姩鎬佸埛鏂版爲褰㈡帶浠惰妭鐐規暟鎹鏄劇ず鍛錛熶竴縐嶅疄鐜版濊礬鏄鍦⊿elect閫夋嫨鍣ㄥ彂鐢熷彉鍖栨椂錛屽湪change浜嬩歡涓娓呯┖Tree鏍戝艦鎺т歡鐨勫叏閮ㄥ瓙鑺傜偣錛岀劧鍚庡啀閲嶆柊鍔犺澆鏍戝艦鎺т歡鑺傜偣鏁版嵁銆傚叧閿浠ｇ爜濡備笅鍥炬墍紺猴細
娓呯┖鏍戝艦鎺т歡鑺傜偣
棣栧厛錛岄氳繃鏍戝艦鎺т歡鐨勭埗鑺傜偣娓呯┖鎵鏈夊瓙鑺傜偣鏁版嵁錛岀劧鍚庤皟鐢╨oadNode1鏂規硶閲嶆柊鏋勫緩鏍戝艦鎺т歡鎳掑姞杞芥暟鎹銆俵oadNode1鏄鏍戝艦鎺т歡load灞炴ф寚瀹氱殑鍔犺澆鏍戠殑鏂規硶錛岃ユ柟娉曞湪鍔犺澆鏍戞垨鑰呭睍寮鏌愪釜鑺傜偣鏃朵細琚鑷鍔ㄨ皟鐢ㄣ
鎴戜滑鍙浠ョ湅鍒幫紝浼犻掔粰loadNode1鏂規硶鏈変袱涓鍙傛暟錛宼his.node鍜宼his.resolve錛岃繖涓や釜鍙傛暟閮芥槸鏍戝艦鎺т歡欏跺眰鑺傜偣灞炴ф暟鍊箋傞偅涔堬紝鏄濡備綍鑾峰彇鍒拌繖涓や釜鍙傛暟鏁板肩殑鍛錛熷叿浣撴柟娉曟槸錛氶栧厛錛岀敵鏄巒ode鍜宺eslove涓や釜鍙橀噺鐢ㄤ簬淇濆瓨欏跺眰鑺傜偣鐨刵ode鍜宺eslove鏁板箋傜劧鍚庯紝鍦ㄦ爲褰㈡帶浠跺姞杞芥椂灝唍ode.level===0鎯呭喌涓嬬殑node鍜宺eslove鏁板間繚瀛樸傚備笅鍥炬墍紺猴細
鑾峰彇欏跺眰鑺傜偣
loadNode1鍐呴儴鏄閫氳繃reslove鏂規硶錛屽皢鏁版嵁閫愮駭鎺ㄨ嚦鏍戝艦鎺т歡鏁版嵁緇撴瀯涓鐨勩傚厛鎵ц宺eslove鏂規硶鐨勬暟鎹鏄鐖惰妭鐐癸紝鍚庢墽琛宺eslove鏂規硶鐨勬暟鎹鏄瀛愯妭鐐癸紝鍦ㄦ棤瀛愯妭鐐圭殑鎯呭喌涓嬮氳繃璋冪敤reslove([])瀹炵幇銆
緇撴潫璇錛氳嚦姝わ紝瀹炵幇浜咵lement鐨凾ree鏍戝艦鎺т歡鎳掑姞杞芥ā寮忎笅鐨勮妭鐐規暟鎹鍔ㄦ佹洿鏂般傚湪瀛愯妭鐐規暟鎹閲忓ぇ鐨勬儏鍐典笅錛屾噿鍔犺澆鍜屽姩鎬佹洿鏂版満鍒訛紝鍦ㄤ竴瀹氱▼搴︿笂瑙ｅ喅浜嗗搷搴旀晥鐜囬棶棰橈紝涔熸彁鍗囦簡鐢ㄦ埛浣撻獙銆
琛ュ厖:element ui 鎳掑姞杞芥爲鑺傜偣鍐呭瓙欏圭殑鍔ㄦ佹洿鏂
<el-tree
:props="props1"
:load="loadNode1"
lazy
show-checkbox>
</el-tree>
<script>
export default {
data() {
return {
props1: {
label: 'name',
children: 'zones',
isLeaf: 'leaf'
},
};
},
methods: {
loadNode1(node, resolve) {
if (node.level === 0) {
return resolve([{ name: 'region' }]);
}
if (node.level > 1) return resolve([]);
setTimeout(() => {
const data = [{
name: 'leaf',
leaf: true
}, {
name: 'zone'
}];
resolve(data);
}, 500);
}
}
};
</script>
涓婇潰浠ｇ爜鏄痚lement ui瀹樻柟鏍戞噿鍔犺澆鐨勫疄渚嬨傚疄鐜板氨鏄娣誨姞lazy錛岀粦瀹氫竴涓猯oad灞炴э紝鐐瑰嚮鑺傜偣鐨勬椂鍊欙紝灝變細瑙﹀彂loadNode1鐨勬柟娉曪紝灝嗘暟鎹鍒峰埌鐐瑰嚮鐨勮妭鐐歸噷闈銆
榪欓噷鐨勯棶棰樻槸錛氬傛灉璇ヨ妭鐐筶oad榪囨暟鎹錛屽啀嬈＄偣鍑繪槸涓嶄細瑙﹀彂loadNode1榪欎釜鏂規硶鐨勶紝浣嗘槸榪欎釜鑺傜偣涓嬬殑瀛愯妭鐐逛篃璁鎬細鍔ㄦ佸炲姞鎴栬呭垹闄
瑙ｅ喅鐨勬濊礬鏄錛
1銆佸緱鍒伴変腑鐨勮妭鐐
2銆佸皢閫変腑鑺傜偣鐨勫瓙鑺傜偣鍏ㄩ儴鍒犻櫎
3銆佸皢閫変腑鑺傜偣鐨勫瓙鑺傜偣鏁版嵁鎵嬪姩鍒峰埌璇ヨ妭鐐瑰唴
鎴戞煡榪噀lement ui婧愮爜錛岃繖閲岀敤鍒版簮鐮佸唴鐨勬柟娉曪紝鎵浠ユ垜浠瀹炵幇涓嬫潵寰堟柟渚匡紝鍙瑕佷笁琛屼唬鐮
function refreshLazyTree(node, children) {
var theChildren = node.childNodes
theChildren.splice(0, theChildren.length)
node.doCreateChildren(children)
}
1銆乶ode灝辨槸閫変腑鐨勭殑鑺傜偣錛堜篃灝辨槸鐐瑰嚮灞曞紑鐨勮妭鐐癸級錛屼綘鍙浠ラ氳繃element ui閲岀殑getNode鏂規硶鑾峰緱錛屼篃鍙浠ョ洿鎺ョ洃鍚珸node-click浜嬩歡鐩存帴鑾峰彇閫変腑鐨勮妭鐐廣
2銆乧hildren灝辨槸node榪欎釜鑺傜偣鐨勫瓙欏
3銆侀氳繃splice鏂規硶鍒犻櫎node鑺傜偣涓嬬殑鎵鏈夊瓙欏
4銆佽皟鐢╠oCreateChildren鍒涘緩瀛愰」灝眔k浜