中圖分類號(hào)： TP31
文獻(xiàn)標(biāo)識(shí)碼： A
DOI：10.16157/j.issn.0258-7998.211832
中文引用格式： 劉濤，付深圳，張柱，等. Allegro基于MySQL數(shù)據(jù)庫的數(shù)據(jù)錄入系統(tǒng)設(shè)計(jì)[J].電子技術(shù)應(yīng)用，2022，48(5)：84-88.
英文引用格式： Liu Tao，F(xiàn)u Shenzhen，Zhang Zhu，et al. Allegro data-recording system based on MySQL database[J]. Application of Electronic Technique，2022，48(5)：84-88.

Allegro data-recording system based on MySQL database

Abstract： In order to realize the functions of automatic acquisition, input and storage of PCB data by Allegro software, the secondary 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.

Key words : Allegro；secondary development；interprocess communication(IPC)；MySQL