浠嬬垂浜嗗湪楂樺璁婇牷鍣ㄧ洠(ji膩n)鎺ц粺浠惰ō(sh猫)瑷堥亷绋嬩腑锛岀偤浜嗗鐝�(xi脿n)閬嬭鍙冩暩(sh霉)鐨勮閷勭瓑鍔熻兘鎵€鎳夌敤鐨凙DO鏁�(sh霉)鎿�(j霉)搴法绋嬫妧琛�(sh霉)銆傜郸鍑轰唬纰煎苟瑭崇窗瑾槑浜嗗湪VB绋嬪簭涓埄鐢ˋDO灏嶈薄鍕曟厠(t脿i)鍓�(chu脿ng)寤烘暩(sh霉)鎿�(j霉)搴拰鏁�(sh霉)鎿�(j霉)琛ㄧ殑鏂规硶锛岄€欎簺鏂规硶鍦ㄩ枊鐧�(f膩)VB鏁�(sh霉)鎿�(j霉)搴噳鐢ㄧ▼搴忎腑寰堟湁瀵︾敤鍍瑰€�锛屽苟鍙互鎻愰珮鏁�(sh霉)鎿�(j霉)搴殑闈堟椿鎬�銆�

闂�(gu膩n)閸佃锛�ADO锛孉DOX锛岄珮澹撹畩闋诲櫒锛屾暩(sh霉)鎿�(j霉)搴法绋�

Application of PrOgramming Technology of ADO Database in Supervise Control Software of High Voltage Inverter

Abstract锛�This paper introduces the programming technology of ADO atabase which is used in the supervise-control software of high voltage inverter in order to realize the functions锛巗uch as recording the running parameters etc锛嶵he program codes are presented and the methods of ADO object which is used to create database and data table dynamically in VB program are illuminated in detail锛嶵hese methods are practically used for the development of VB database application program锛巜hich can greatly enhance the flexibility of database program锛�

Keywords锛�ADO锛嶢DOX锛嶩igh Voltage Inverter锛嶥atabase Program

鍩轰簬VB6.0鎵€闁嬬櫦(f膩)鐨勯珮澹撹畩闋诲櫒鐩�(ji膩n)鎺ц粺浠�锛岄渶瑕佸湪鐩�(ji膩n)鎺ч亷绋嬩腑瑷橀寗閬嬭鍙冩暩(sh霉)銆佹晠闅滀俊鎭�銆佸姛鑳借ō(sh猫)瀹氬弮鏁�(sh霉)銆侀珮澹撹畩闋诲櫒鍩烘湰鍙冩暩(sh霉)銆侀瀹氬弮鏁�(sh霉)銆侀浕姗熷弮鏁�(sh霉)绛�銆傚彟澶�锛岄倓闇€瑕佸鐝�(xi脿n)娉㈠舰椤ず锛屽苟鑳藉?q奴)危銊愯姕M琛屽瓨鍎蹭互鍙婃尝褰㈠洖鏀剧瓑銆傞€欎簺鍔熻兘鐨勫鐝�(xi脿n)锛屽彲浠ラ噰鐢ˋDO鏁�(sh霉)鎿�(j霉)搴法绋嬫妧琛�(sh霉)銆侫DO鏄崹绔嬩簬闁嬬櫦(f膩)宸ュ叿鍜岄枊鐧�(f膩)瑾炶█鐨勭啊鍠€屼笖瀹规槗浣跨敤鐨勬暩(sh霉)鎿�(j霉)鎺ュ彛锛岄€氶亷ADO灏嶈薄绶ㄧ▼瑷晱鏁�(sh霉)鎿�(j霉)搴彲浠ョ郸鐢ㄦ埗鎻愪緵寰堝ぇ鐨勬柟渚�銆�

1 ADO鍜孉DO×绨′粙

VB鎻愪緵骞剧ó瑷晱鏁�(sh霉)鎿�(j霉)搴殑鏂规硶锛屽垎鍒ユ槸鏁�(sh霉)鎿�(j霉)瑷晱灏嶈薄锛圖AO锛�銆侀仩绋嬫暩(sh霉)鎿�(j霉)灏嶈薄锛圧DO锛�銆丄ctiveX鏁�(sh霉)鎿�(j霉)灏嶈薄锛圓DO锛夈€侫DO鏄疍AO锛廟DO鐨勫悗绾�(x霉)鐢�(ch菐n)鐗�锛屽畠鎿村睍浜咲AO鍜孯DO鎵€浣跨敤鐨勫皪璞℃ā鍨嬶紝鏄熀浜嶰LE DB涔嬩笂鐨勬妧琛�(sh霉)锛屽洜姝DO鏄€氶亷鍏跺収(n猫i)閮ㄧ殑灞€у拰鏂规硶鎻愪緵绲�(t菕ng)涓€鐨勬暩(sh霉)鎿�(j霉)瑷晱鎺ュ彛鏂规硶锛屾槸涓€鍊嬩究浜庝娇鐢ㄧ殑鎳夌敤绋嬪簭鎺ュ彛锛屽叿鏈夋洿鍔犵啊鍠�銆侀潏娲荤殑鎿嶄綔鎬ц兘銆�

浣跨敤ADO闁嬬櫦(f膩)鏁�(sh霉)鎿�(j霉)搴噳鐢ㄧ▼搴忔檪锛岄渶瑕佸紩鐢ㄥ皪璞″韩“Ml_crosoft ActiveX Data bjects 2.5 Library”锛堢啊绋辩偤ADO锛夛紝瀹冩槸VB鏁�(sh霉)鎿�(j霉)搴枊鐧�(f膩)浜哄摗缍�(j墨ng)甯稿紩鐢ㄧ殑灏嶈薄搴�銆傚鏋滆鍦ㄧ▼搴忛亱琛岄亷绋嬩腑鍕曟厠(t脿i)鍓�(chu脿ng)寤烘暩(sh霉)鎿�(j霉)搴拰琛�锛岄倓瑕佸紩鐢ㄥ皪璞″韩“Microsoft A—DO Ext.2.8 For DDL Security”锛堢啊绋辩偤ADOX锛�锛屽叾搴枃浠跺悕鐐猴細msadox.dll銆侫DOX鏄皪ADO灏嶈薄鍜岀法绋嬫ā鍨嬬殑鎿村睍锛屽畠灏嘇DO鎿村睍鐐哄寘鎷壍(chu脿ng)寤�銆佷慨鏀瑰拰鍒櫎妯″紡灏嶈薄銆傚畠閭勫寘鎷畨鍏ㄥ皪璞�锛岀敤浜庣董璀风敤鎴跺拰绲勶紝浠ュ強鎺堜簣鍜屾挙娑堝皪璞＄殑娆�(qu谩n)闄�銆�

鍦╒B涓紝閫氬父鏈夊叐绋柟娉曞彲浠ュ鐝�(xi脿n)灏岮DO鐨勬搷浣�锛屼竴鏄€氶亷ADO Data鎺т欢鐨勯潪绶ㄧ▼瑷晱鏂瑰紡锛涗簩鏄埄鐢ˋDO灏嶈薄绶ㄧ▼渚嗚í鍟忓悇绋鍨嬬殑鏁�(sh霉)鎿�(j霉)搴�銆�

瑭崇窗鍏�(n猫i)瀹硅珛榛炴搳锛� 楂樺璁婇牷鍣ㄧ洠(ji膩n)鎺ц粺浠朵腑ADO鏁�(sh霉)鎿�(j霉)搴法绋嬫妧琛�(sh霉)鐨勬噳鐢�