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

拖拉机零件CAPP系统研究一基于MySQL 数据库和Web技术 谷禾ll芬 焦作师范高等专科学校计算机与信息工程学院 针对虚拟制造屮的拖拉机零部件智能工艺生成过程，提出了一种基于MySQL数 据库和Web技术的CAPP系统，从而实现了对拖拉机零部件工艺过程的查询、设 计、仿真、评价、修改，以及可查询和可视化功能。采用B/S基本框架设计了数 据持久层，实现了数据库的交互，使用Java技术编写了数据接口，解决了 Web 应用程序访问数据库的问题。为了验证方案的可行性，设计了基于MySQL数据库 和Web技术的拖拉机零件CAPP系统，并对系统进行了测试，以拖拉机变速箱齿 轮零件的工艺设计为例，验证了 CAPP系统的工艺生成过程。系统测试结果表明: 使用MySQL数据库和Web技术对系统进行改进后，可以实现工艺设计过程的可查 询功能和可视化功能，并且釆用木次设计的CAPP系统后，有效提高了零部件的 设计效率，降低了设计费用，是一种高效的拖拉机零部件工艺设计系统。 关键词 拖拉机零件;CAPP系统;MySQL数据库;Web技术;B/S基本框架; 谷利芬（1974-），女，河南濮阳人，讲师，硕士，（ ） feixuliuyun8447038@sohu. com。 :2017-05-15 基金河南省高等学校重点科研项Fl （17B520022） Research on CAPP System of Tractor Parts——Based on MySQL Database and Web Technology Gu Lifen School of Computer and Information Engineering, Jiaozuo Teachers College; Abstract According to the production process of intelligent tractor parts in virtual manufacturing, this paper brings forward a CAPP system based on Web tech no logy 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 feasibi 1 ity of the design of the CAPP system and t rac tor par ts MySQL dat abase based on Web techno logy，and the sys tem 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 effeetivcly improve the design efficiency of parts, reduce the design cost, which is a kind of efficient tractor parts process design system. Keyword tractor pa