Allegro基于MySQL数据库的数据录入系统设计

Allegro data-recording system based on MySQL database

为了实现通过Allegro软件对PCB板卡数据自动采集、录入、保存等功能,研究基于SKILL语言的Allegro软件二次开发和IPC通信原理,提出并设计一种Allegro软件基于MySQL数据库的数据录入系统。根据实际数据存取需求及用户权限,设计前端数据采集模块和网页显示模块,在前端数据采集模块中,通过研究IPC通信,制定通信协议,并结合SKILL语言、Python语言编写通信接口,实现Allegro软件与MySQL数据库通信;网页显示模块使用Java语言用于对数据进行展示和处理。最后对数据录入系统进行功能测试,测试证明能够达到预期效果。系统中Allegro软件与MySQL数据库通信协议设计以及通信接口设计是系统的关键设计,系统数据采集模块的实现对后续Allegro软件与其他语言通信、网页端功能扩展具有很大的参考价值。

In order to realize the functions of automatic acquisition, input and storage of PCB data by Allegro software, the sec-ondary development of Allegro software based on SKILL language and the principle of IPC communication are studied. A data input system based on MySQL database is proposed and designed. According to the actual data access requirements and user permissions,the front-end data acquisition module and web page display module are designed. In the front-end data acquisition module,through the study of IPC communication, the communication protocol is formulated, and the communication interface is written with SKILL language and Python language to realize the communication between Allegro software and MySQL database. The web display module uses Java language to display and process the data. Finally, the function test of the data entry system is carried out, and the test results show that it can achieve the expected effect. The design of communication protocol between Allegro software and MySQL database, and the design of communication interface are the key design of the system. The realization of data acquisition module of the system has a strong reference value for the communication between Allegro software and other languages, and the function expansion of web page.