作者：安子良, 轩福贞, 涂善东
作者单位：华东理工大学机械与动力工程学院, 上海 200237
关键词：软件自动化; VB; Access; Excel; RS485通讯协议; 多点数据采集
摘要：
数据采集和控制软件系统采用串口通协议,实现了对4台蠕变实验机多点数据采集和数据的自动记录。遵循温度控制器的RS485通讯协议,软件系统可以自动调控蠕变高温炉的温度。通过OLE技术和人工代码,VB与Access、Excel无缝连接,将试验数据保存到Access数据库中。运行结果表明系统的软、硬件工作稳定,可靠性高,完全实现了蠕变实验机的温度自动控制和试验数据的自动记录。
Measurement and control system of creep testers under the Frame of VB、Excel and Access
AN Zi-liang, XUAN Fu-zhen, TU Shan-dong
School of Mechanical and Power Engineering, East China University of Science and Technology, Shanghai 200237, China
Abstract: Serial port communication protocol was introduced into the software system of data acquisition and control,multipoint data acquisition and data self-record of 4 creep testers were implemented.According to the RS485 communication protocol of the temperature controller,software system could autocontrol the temperature of the creep furnace.By means of the techniques of OLE and artificial code,the seamless integration among VB,Access and Excel were realized and the experimental results were saved into Access database.Operating results indicated that the hardware and software of the system are high reliability and stability,temperature auto-control and testing data self-record of the creep tester are completely achieved.
Keywords: Software Automation; VB; Access; Excel; RS485 Communication Protocol; Multipoint Data Acquisition
2007, 33(3): 84-87 收稿日期: 2006-9-25;收到修改稿日期: 2006-12-7
基金项目: 国家自然科学基金(50475068);国家高新技术研究发展专项经费资助(2006AA04Z413)
作者简介: 安子良(1972-),男,河北唐山市人,博士研究生,主要从事扩散焊接头高温性能的研究。
参考文献
[1] 涂善东.高温结构完整性原理[M].北京:科学出版社,2003.
[2] 徐梅泉,何伟康,朱月梅,等.蠕变试验机的技术改造[J].理化检验一物理分册,2002,38(4):164-166.
[3] 朱泉,朱月梅,荘瑛.提高RD2-3性蠕变持久试验机的力值精度[J].理化检验一物理分册,1997,33(4):42-44.
[4] 郑德华,陶继伟.RS-485通讯协议在集散控制系统中的应用[J].中国仪器仪表,2005,9:93-95.
[5] 李卫中,曹顺安,李红霞.Win2000下VB和ADAM-5000/485串口通信的实现方案[J].工业控制计算机,2002,15(7):40-41.
[6] 张东,严殊,刘广起.VB和Excel在数据采集系统中的应用[J].自动化与仪器仪表,2006,1:42-43.
[7] 彭旭煌.VB实现串口通讯并调用Excel处理其数据的方法[J].舰船光学,2001,3:42-43.
[8] 王永华,张浞,李斌,等.基于Excel VBA技术的自动数据采集系统[J].南京工业大学学报,2006,28(5):93-95.
[9] 杜中华,王兴贵,马吉胜.用VB6.0和ACCESS2000建立某型坦克底盘的故障数据处理系统[J].车辆与动力技术,2001,3:37-40.
[10] 邵冬华.如何利用VB实现Excel数据和Access数据之问的转换[J].南通航运职业技术学院学报,2004,9:33-37.
