摘要:二十一世纪以来，世界经济飞速发展带动了文化产业的快速崛起，旅行社数量也增长迅速。为了在竞争中生存，就要提高工作效率。为了更有效的管理公司业务，用户对计算机提出了更高的要求，就是将业务整合到一个系统中，方便各岗位的职工进行相应的操作。这就需要一个旅行社办公自动化系统为公司的运营提供方便，提高其工作效率，为旅客提供更全面的信息，以便做出正确的选择。

　　　本文首先介绍了“聂辉旅行社办公自动化系统的设计与实现”的课题背景、课题研究现状、课题研究意义。介绍了相关技术与工具，包括servlet、Jsp、Struts2技术和Myeclipse、MySql工具。介绍了课题需求分析，说明旅行社日常网上办公的系统需求和网上预订、付款、旅游信息管理、会员信息管理、公文公告管理、业务员信息管理、订单管理的系统主要功能。通过运用J2EE技术,B/S体系结构,Struts2框架、Jsp技术和MySQL数据库管理等技术来实现系统的功能。接下来使用UML业务用例图、业务活动图、系统用例图、系统活动图等来阐述系统功能。系统设计部分包括系统体系结构设计、系统软件设计、数据库设计。本文用系统部署图来描述系统体系结构；用业务处理功能的系统用例图为例绘制类图和该类对应的顺序图来描述系统软件设计，通过ER图和详细的数据库表来描述数据库设计。然后是系统实现，软件测试，重点介绍了各模块功能的实现方法、界面的详细设计方法和设计过程。

关键词  旅行社办公自动化；MVC；Struts2

Abstract:Since the twenty-first century, the rapid development of the world economy has led to the rapid rise of the cultural industry .The number of travel agency is also growing rapidly. In order to survive in the competition, it is necessary to improve work efficiency. The user has a higher demand for computer so as to manage the company more effective. In other words, the workers can easily carry out the appropriate action by integrating business into one system. This requires a travel agency office automation system for the company's operation to improve its efficiency and provide more comprehensive information for travelers in order to help them to make the right choice.

　　This paper first introduces the subject background, research status quo and research significance about the design and implementation of NieHui travel agency office automation system. The article also introduces the related technologies and tools, including servlets, JSP ,the Struts2 technology , MyEclipse and MySql. The requirement analysis is also presented. At the same time, it also introduces the system requirements of the daily travel agency online office. The main function of this system includes online booking, payment, tourist information management, member information management, document notice management, the clerk information management and order management. The function of the system is achieved through the use of J2EE technology, B / S architecture, Struts2 framework, JSP technology and MySQL database management technology. Next, the system function is elaborated through the use of UML use case diagram, business activity diagram, system use case diagram and system activity diagram. The part of the system design includes the system architecture design, system software design and database design. In this paper, the system deployment diagram is used to describe the system architecture. The paper uses the system use case diagram to draw class diagram. The system software design is described by the class diagram and the sequence diagram corresponding to the class. The article describes the database design by using ER diagram and detailed database table. The paper also comprises system implementation and software testing. It focuses on the implementation of the function of each module. It also highlights interface design method and design process.

Keywords  travelagencyOA  MVC  Struts