1、. 353.3.12 留言板功能模块的实现 .35第 4 章 系统的重点与难点算法分析 .374.1 在 JSP 中连接 MYSQL 数据库 .374.2 用户登录时数据验证与用户信息初始化的算法 .384.3 添加开课和修改开课的关键算法.394.4 添加排课时的验证问题 .414.5 数据库中多表更新时的事务处理.444.6 数据库中表更新时的锁定问题 .454.7 数据库的自动备份与恢复 .474.8 学生学分统计的算法.484.9JavaBean 的使用 .504.10JavaScript 的应用表单验证 .534.11 导出网页 Table 中的数据到 Word 文档 .55第 5
2、章 系统的安全性策略问题.565.1 系统安全设计的重要性 .565.2 B/S 模式下系统的安全层次 .57第 6 章 总结 .58参考文献.59致谢 .60附录 .61ContentChapter 1 Foreword. 11.1 Background . 11.2 Brief Introduction of Teaching and Maintenance Management System for MSE .11.3Main Content and Structure . 2Chapter 2 Technology Introduce for the System .32.1 Trad
3、itional Client/Server Two-Layer System Structure.32.2 New Browser/Server Three-Layer System Structure .42.3 Web Programming Language JSP . 62.4 Database Server MySQL. 62.5 Structured Query Language. 72.6 Java Data Base Connectivity. 82.7Web Server Tomcat . 9Chapter 3 Setting Up Teaching and Maintena
4、nce Management System for MSE Based onB/S. 103.1Goal of Setting Up System . 103.2Structure Design and Development Conditions . 113.3Performance System Design and Implement . 123.3.1 Structure of Performance System. 123.3.2 The Realization of Function Modules of Start Course. 153.3.3 The Realization
5、of Function Modules of Arrange Course and Curriculum . 173.3.4 The Realization of Function Modules of Choose Course. 223.3.5 The Realization of Function Modules of Attend Course. 233.3.6 The Realization of Function Modules of Course Scores. 253.3.7 The Realization of Function Modules of Login and Lo
6、gout. 303.3.8 The Realization of Function Modules of Mentor Relationship. 313.3.9 The Realization of Function Modules of StudentsInformation . 333.3.10 The Realization of Function Modules of TeachersInformation . 353.3.11 The Realization of Function Modules of Information Security.353.3.12 The Reali
7、zation of Function Modules of Message Board.35Chapter 4 The Analysis of Difficult and Important Arithmetic in System.374.1 Connect MySQL DataBase Using JSP.374.2 Validation and Initialization of UsersInformation.384.3 Arithmetic of Adding Start Course.394.4 Validation of Adding Arrange Course.414.5
8、Transaction Processing in MySQL DataBase.444.6 Lock Tables in MySQL DataBase .454.7 Backup and Restoration in MySQL DataBase.474.8 Arithmetic of Calculating Scores.484.9 Using JavaBean.504.10 Application of JavaScript.534.11 Data Conversion Between JSP Page and Word Document .55Chapter 5 Strategy of
9、 System Security.565.1 Importance of Security Design for System .565.2 Security Levels of System Based on B/S.57Chapter 6 Conclusion .58References.郑州大学毕业设计（论文）题 目 AGV 调度系统设计院 系 国际学院专 业 机械工程及其自动化年 级学生姓名指导教师20XX 年 X 月 X 日郑州大学学士学位论文 AGV 调度系统设计摘 要近年来，随着现代制造业的高速发展以及国内人力成本的不断提高，现代工厂对生产力、鲁棒性的要求不断提高，AGV 作为作
10、为现代制造系统里的一个新兴的子系统，可以根据生产需要、工艺流程、仓储要求等突发情况随时对调度系统进行调整，极大地降低了生产车间对人力资源的需求量，实现了 AGV 小车与主系统之间物流联通的信息化，增强了整个制造系统的鲁棒性，没有局限性、效率低、货物破损率高等传统物流过程中经常出现的问题，有自动化程度高、安全可靠、人力需求很少、施工铺设轨道以及建立系统较为简单且维修方便、与传统的输送带和传送线相比运行过程中无噪音无污染运行成本低廉等优点，因而 AGV 被广泛地应用于汽车制造行业、烟草行业、工程机械制造行业、机场码头邮局等物资运输场所等在国内外的现代智能工厂改造中得到了越来越多的应用。本文针对 X
11、XXX 智能工厂改造方案的子方案“AGV 小车调度系统设计”进行研究。了解 AGV 的定义、路径导引方式、控制以及通讯的基本原理， AGV 小车系统的历史背景、特点以及应用范围；研究 AGV 小车的调度原理和方法，结合实际情况在给出的车间草图基础上铺设 AGV 小车的路径；用 Visio 建立调度流程图对调度流程进行描述；了解以路径最短为原则求最优解的算法有哪些并结合实际情况选择 Dijkstra 算法作为研究内容；设立一些假设来简化课题并以路径最短为原则使用 Dijkstra 算法求最优解；熟悉 C 语言知识，针对已经完成的优化算法使用 C 语言编程进行描述。关键词：AGV、调度、Dijks
12、tra 算法、C 语言AbstractIn recent years, with the rapid development of modern manufacturing industry and the continuous improvement of domestic labor costs, modern factory for the requirement of increasing the productivity, robustness, AGV as a modern I郑州大学学士学位论文 AGV 调度系统设计manufacturing system, a new sub
13、system, can according to production needs, process, storage and other emergency at any time to adjust dispatching system, significantly reduced the demand for human resources in the workshop, with the main system for logistics information of unicom, enhanced the robustness of the manufacturing syste
14、m, no limitations, low efficiency and high goods breakage problems that often appear in the process of traditional logistics, have a high degree of automation, safe and reliable, human needs few laying track, construction and building system is relatively simple and convenient maintenance, compared
15、with the conventional conveyor belt and transmission line operation no noise pollution in the process of the advantages of low cost, thus AGV is widely used in automobile manufacturing industry, the tobacco industry, engineering machinery manufacturing industry, airport terminal post offices and oth
16、er places of goods transportation at home and abroad, such as the reform of the modern intelligent factory got more and more applications.In the light of the son XXXX intelligent plant retrofit scheme plan “AGV vehicle scheduling system design“ for research. Understand the definition of AGV, route g
17、uidance method, control and communications, the basic principle of the historical background of AGV car system, characteristics and application scope; Study of AGV car scheduling principle and method of combining actual situation on the basis of given workshop sketches laid the path of the AGV car;
18、Description of scheduling process is established using Visio scheduling flow chart; Know the optimal solution based on principles of shortest path algorithm and combined with actual situation choice Dijkstra algorithm as the research content; Set up hypothesis and with the principle of the shortest
19、path for the principle using the Dijkstra algorithm the optimal solution; Familiar with C language knowledge, in view of the completed optimization algorithm using C language programming is described.Key words: AGV, scheduling, Dijkstra algorithm, C languageII郑州大学学士学位论文 AGV 调度系统设计目录摘 要 .IAbstract. I目录.III第一章 绪论. 11.1课题的背景. 11.1.1 AGV 概述 . 11.1.2 AGV 的特点. 11.1.3 AGV 的应用. 21.2 选题的目的意义 .51.3国内外研究概况. 71.4本文研究内容. 91.5 本章小结. 11第二章 AGV 小车路径设计 . 122.1 XXXX 裁剪车间智能化改造整体方案 . 122.1.1 集团目前生产流程分析 . 122.1.2 总体示意图 .122.1.3 总体方案图 .
