拖拉机零件CAPP系统研究—基于MySQL数据库和Web技术  

Research on CAPP System of Tractor Parts—Based on MySQL Database and Web Technology

作　　者：谷利芬[1] 

机构地区：[1]焦作师范高等专科学校计算机与信息工程学院,河南焦作454000

出　　处：《农机化研究》2018年第6期257-260,268,共5页Journal of Agricultural Mechanization Research

基　　金：河南省高等学校重点科研项目(17B520022)

摘　　要：针对虚拟制造中的拖拉机零部件智能工艺生成过程,提出了一种基于MySQL数据库和Web技术的CAPP系统,从而实现了对拖拉机零部件工艺过程的查询、设计、仿真、评价、修改,以及可查询和可视化功能。采用B/S基本框架设计了数据持久层,实现了数据库的交互,使用Java技术编写了数据接口,解决了Web应用程序访问数据库的问题。为了验证方案的可行性,设计了基于MySQL数据库和Web技术的拖拉机零件CAPP系统,并对系统进行了测试,以拖拉机变速箱齿轮零件的工艺设计为例,验证了CAPP系统的工艺生成过程。系统测试结果表明:使用MySQL数据库和Web技术对系统进行改进后,可以实现工艺设计过程的可查询功能和可视化功能,并且采用本次设计的CAPP系统后,有效提高了零部件的设计效率,降低了设计费用,是一种高效的拖拉机零部件工艺设计系统。According to the production process of intelligent tractor parts in virtual manufacturing, this paper brings for- ward a CAPP system based on Web technology and MySQL database, so as to achieve the process of tractor spare parts inquiry, design, simulation, evaluation and revision, it realizes the query and visualization process. It designed the data persistence layer by using the basic framework of B/S, and realized the interaction of database. The data interface is written by using Java technology, and the problem of accessing database by Web application is solved. In order to verify the feasibility of the design of the CAPP system and tractor parts MySQL database based on Web technology, and the system was tested, the process design of gear box of tractor parts as an example, to verify the process of generating process of CAPP system. As indicated by the test results of the system, using MySQL database and Web technology to improve the system, it can achieve the design process of query function and visual function. It use CAPP to the design of the system to effectively improve the design efficiency of parts, reduce the design cost, which is a kind of efficient tractor parts process design system.

关 键 词：拖拉机零件 CAPP系统 MYSQL数据库 WEB技术 B/S基本框架 

分 类 号：S219[农业科学—农业机械化工程] TP391.7[农业科学—农业工程]