基于組態王數據庫在塑殼斷路器參數測試中的應用
吳學忠,李飛,匡紅兵
(江蘇大全凱帆電器股份有限公司,江蘇 鎮江 212211)
摘 要: 介紹了組態王SQL 數據庫的特點和訪問功能,分析了塑殼斷路器參數測試系統組成和PLC 數據與組態王變量關聯方式,利用組態王SQL 及變量組態技術組態和編制命令程序實現對測試數據庫的操作。運行結果表明,該應用有效提高了產品測試的質量控制和數據分析能力。
關鍵詞: 組態王;SQL 數據庫;塑殼斷路器
中圖分類號:TM561 文獻標識碼: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
參考文獻
[1] 朱希余,金霄兵. 塑殼斷路器特性與自動檢測[J].電工技術雜志,2002(9):64-66.
[2] 楊嘯. 產品質量監督檢測中的數據庫研究[J]. 計算機光盤軟件與應用,2013(18):125-127.
[3] 李雁飛,陳國鈞,張衛東,等. 組態王環境下數據庫訪問技術及其應用[J].微計算機信息,2004(12):5-6.
[4] 劉海波.Access 數據庫應用[M]. 北京:北京郵電大學出版社,2010.