毕 业 设 计（论 文）
MES 生产制造执行系统设计与实现
I
摘 要
当下，如果还依然使用纸质文档来记录并且管理相关信息，可能会出现很多
问题，比如原始文件的丢失，因为采用纸质文档，很容易受潮或者怕火，不容易
备份，需要花费大量的人员和资金来管理用纸质文档存储的信息，最重要的是数
据出现问题寻找起来很麻烦，并且修改也困难，如果还这样操作会造成很大的资
源浪费和经济损失。所以，对于本课题研究的产品生产制造信息的管理就需要有
一款软件来代替手工操作，因此 MES 生产制造执行系统就应运而生。
MES 生产制造执行系统运用的工具包括 Eclipse，Tomcat 以及 Navicat 等。
该系统可以实现部门信息管理，工序信息管理，工艺线路管理，物料信息管理，
客户信息管理，销售订单管理，产品信息管理，生产计划管理等功能。
MES 生产制造执行系统就是采用目前最流行的互联网应用思维，让信息处
理变得更加高效，并且处理结果更加的符合预期，只要是关于数据管理方面，不
管是添加还是修改，以及数据维护甚至是数据迁移，都可以达到更快更安全的要
求。
关键词：MES 生产制造执行系统；销售订单；产品
II
Abstract
At present, if paper documents are still used to record and manage related
information, there may be many problems, such as the loss of original documents,
because paper documents are easily damped or afraid of fire, not easy to back up, and
require a lot of personnel. and funds to manage the information stored in paper
documents, the most important thing is that it is very troublesome to find data
problems, and it is also difficult to modify, if you continue to do this, it will cause
great waste of resources and economic losses. Therefore, there is a need for a software
to replace manual operation for the management of the manufacturing information of
the products studied in this topic, so the MES manufacturing execution system came
into being.
The tools used by MES manufacturing execution system include Eclipse, Tomcat
and Navicat. The system can realize department information management, process
information management, process line management, material information
management, customer information management, sales order management, product
information management, production planning management and other functions.
MES Manufacturing Execution System adopts the most popular Internet
application thinking to make information processing more efficient, and the
processing results are more in line with expectations, as long as it is about data
management, whether it is addition or modification, and data maintenance or even
data Migration can achieve faster and safer requirements.
Key Words：MES Manufacturing Execution System; Sales Orders; Products
III
目 录
第 1 章 绪论 ..................................................................................................................1
1.1 选题动因 .........................................................................................................1
1.2 目的和意义 .....................................................................................................1
1.3 论文结构安排 .................................................................................................2
第 2 章 开发环境与技术 ..............................................................................................3
2.1 TOMCAT 简介...................................................................................................3
2.2 ECLIPSE 简介 ....................................................................................................3
2.3 NAVICAT 简介...................................................................................................4
2.4 VUE 框架 ..........................................................................................................4
第 3 章 系统分析 ..........................................................................................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 经济可行性 ..........................................................................................5
3.1.2 技术可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程分析 .................................................................................................6
3.3 系统性能分析 .................................................................................................7
3.4 系统功能分析 .................................................................................................8
第 4 章 系统设计 ........................................................................................................11
4.1 布局设计原则 ...............................................................................................11
4.2 功能结构设计 ...............................................................................................12
4.3 数据库设计 ...................................................................................................13
4.3.1 数据库 E-R 图设计............................................................................13
4.3.2 数据库表结构设计 ............................................................................16
第 5 章 系统实现 ........................................................................................................21
5.1 管理员功能实现 ...........................................................................................21
5.1.1 工艺线路管理 ....................................................................................21
IV
5.1.2 生产计划管理 ....................................................................................22
5.1.3 生产计划统计报表 ............................................................................22
5.1.4 销售订单统计报表 ............................................................................23
5.1.5 物料信息管理 ....................................................................................24
5.2 员工功能实现 ...............................................................................................24
5.2.1 客户信息管理 ....................................................................................24
5.2.2 客户信息统计报表 ............................................................................25
5.2.3 销售订单管理 ....................................................................................26
5.2.4 工序信息查看 ....................................................................................26
第 6 章 系统测试 ........................................................................................................28
6.1 系统测试方法 ...............................................................................................28
6.2 功能测试 .......................................................................................................28
6.2.1 登录功能测试 ....................................................................................28
6.2.2 销售订单查询功能测试 ....................................................................29
6.3 测试结果分析 ...............................................................................................29
结 论 ..........................................................................................................................30
参考文献 ......................................................................................................................31
致 谢 ..........................................................................................................................32
