基于組態(tài)王數(shù)據(jù)庫在塑殼斷路器參數(shù)測試中的應(yīng)用
吳學(xué)忠，李飛，匡紅兵
(江蘇大全凱帆電器股份有限公司，江蘇 鎮(zhèn)江 212211)
摘 要： 介紹了組態(tài)王SQL 數(shù)據(jù)庫的特點和訪問功能，分析了塑殼斷路器參數(shù)測試系統(tǒng)組成和PLC 數(shù)據(jù)與組態(tài)王變量關(guān)聯(lián)方式，利用組態(tài)王SQL 及變量組態(tài)技術(shù)組態(tài)和編制命令程序?qū)崿F(xiàn)對測試數(shù)據(jù)庫的操作。運行結(jié)果表明，該應(yīng)用有效提高了產(chǎn)品測試的質(zhì)量控制和數(shù)據(jù)分析能力。
關(guān)鍵詞： 組態(tài)王；SQL 數(shù)據(jù)庫；塑殼斷路器
中圖分類號：TM561 文獻(xiàn)標(biāo)識碼：B 文章編號：1007-3175(2015)07-0031-07
Application in Parameters Testing of Moulded Case Circuit Breaker Based on KingView Database
WU Xue-zhong, LI Fei, KUANG Hong-bing
（Jiangsu Daqo Kfine Electric Co., Ltd, Zhenjiang 212211 , China）
Abstract: Introduction was made to the features and access functions of KingView structured query language (SQL) database. This paper analyzed the associated mode between the composition of moulded case circuit breaker (MCCB) parameters testing system and the programmable logic controller (PLC) database, as well as the KingView variables. The KingView SQL and variables configuration technology, together with the programming commands were used to realize the operation on testing database. The operational results show that this application effectively improves the quality control and data analysis ability of product testing.
Key words: KingView; structured query language database; moulded case circuit breaker
參考文獻(xiàn)
[1] 朱希余，金霄兵. 塑殼斷路器特性與自動檢測[J].電工技術(shù)雜志，2002(9)：64-66.
[2] 楊嘯. 產(chǎn)品質(zhì)量監(jiān)督檢測中的數(shù)據(jù)庫研究[J]. 計算機(jī)光盤軟件與應(yīng)用，2013(18)：125-127.
[3] 李雁飛，陳國鈞，張衛(wèi)東，等. 組態(tài)王環(huán)境下數(shù)據(jù)庫訪問技術(shù)及其應(yīng)用[J].微計算機(jī)信息，2004(12)：5-6.
[4] 劉海波.Access 數(shù)據(jù)庫應(yīng)用[M]. 北京：北京郵電大學(xué)出版社，2010.
