| In order to ensure product quality in modern electronics industry production,we hope that the management personnel can query the production status in time,find out and actively intervene the product quality problems in time,so as to improve the quality control level.Therefore,we need the factory to be able to test in the production process,and get the test results to the test operators and management personnel in time.This thesis is for the small and medium-sized electronic production enterprises printed circuit board automatic detection requirements,based on LabVIEW development platform and combined with MySQL database,developed a software for tooling automation test.The software can realize the test process,data acquisition,data processing and automatic report generation of circuit board tooling.The software uses database to save user information and test data.The first chapter introduces the research background and the history and current situation of virtual instrument.The second chapter mainly introduces the main technology and platform of the development process,LabVIEW development tools and MySQL database,and how to realize the communication between LabVIEW and MySQL database through the Open Database Connectivity(ODBC).The third chapter analyzes the requirements and introduces the overall design scheme.The fourth chapter introduces the implementation of account management system in the software,which is realized by sub modules.In this part,LabVIEW and MySQL database are used to save account information,and SHA-1 is used to encrypt the account password.The fifth chapter introduces the software implementation of the test module,including communication mode,test process,automatic report generation and data saving.Finally,the mode window is used to switch the test interface and login interface.Finally,the software test simulation environment and test results are introduced.This design is based on a specific circuit board tooling automation test platform software,to achieve automatic circuit board testing,data acquisition,data collation and automatic report generation functions.At present,the following functions have been implemented: 1.Account management,which only allows authorized users to use the program,and automatically adds tester information to the test report;account information encryption,with complete account management procedures.2.LabVIEW will automatically execute the test program and output the test report.3.LabVIEW can save the test results to MySQL database.4.By analyzing the test data,the early warning function can be realized when the card quality defect rate exceeds the threshold value.There are still some shortcomings in the architecture,and there is room for further development and improvement in various aspects of performance. |