㈠ 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浜