分 类 号 论 文 编 号
本 科 生 毕 业 设 计
旅游网站
姓 名：
院 系：
年级专业：
指导教师：
2018 年 5 月
旅游网站系统的设计与实现
目录
第一章 绪论..................................................................................................................1
1.1 引言..................................................................................................................1
1.2 背景..................................................................................................................1
1.3 旅游网站系统现状问题分析..........................................................................2
1.4 旅游网站开发的意义和目的..........................................................................2
第二章 相关技术介绍..................................................................................................5
2.1 系统开发使用技术介绍.................................................................................5
2.1.1JAVA 概况介绍...................................................................................5
2.1.2MySQL 概况介绍................................................................................5
2.1.3Tomcat 概况介绍.................................................................................6
2.1.4Spring MVC 概况介绍 ........................................................................6
2.1.5CSS 概况介绍......................................................................................7
第三章 系统分析..........................................................................................................8
3.1 系统开发的软件环境可行性分析.................................................................8
3.2 系统开发的硬件环境可行性分析.................................................................8
3.3 系统开发的构架设计可行性分析.................................................................8
3.3.1B/S 构架与 C/S 构架介绍...................................................................8
3.3.2C/S 构架的选择与分析.......................................................................9
3.4 系统开发需求分析.........................................................................................9
3.4.1 旅游网站系统流程分析.....................................................................9
3.4.2 系统功能需求分析...........................................................................10
第四章 系统设计........................................................................................................12
4.1 数据库的设计...............................................................................................12
4.2 建立数据库...................................................................................................13
4.3 系统功能设计...............................................................................................15
4.3.1 登录设计...........................................................................................15
4.3.2 管理员功能设计...............................................................................16
4.3.3 游客功能设计...................................................................................17
第五章 系统的实现....................................................................................................18
5.1 登录功能的实现...........................................................................................18
5.2 景点管理.......................................................................................................19
5.3 美食管理功能...............................................................................................22
5.4 景点浏览管理功能.......................................................................................25
5.5 景点搜索功能...............................................................................................27
5.6 游客登录和注册...........................................................................................30
5.7 景点评论功能...............................................................................................31
第六章 展望与未来....................................................................................................34
旅游网站系统的设计与实现
总结..............................................................................................................................35
参考文献......................................................................................................................36
致谢..............................................................................................................................37
旅游网站系统的设计与实现
摘要
旅游电子商务网站要实现收益递增，必须充分利用网络来进行技术创新。通
过对我国旅行电子商务网站市场前景、产品策略和盈利模式等多个方面进行分析，
并结合其所面临的制约因素探讨了我国旅行电子商务网站未来发展的对策。
改革开放以来，我国的旅游业发展迅速，目前我国正处于旅游大国向旅游强
国迈进的转型期，国际旅游和国内旅游的竞争异常激烈，旅游产品的不可储存性
和不可转移性，以及旅游目的地之间的可替代性等特性，都决定了旅游业的竞争
是品牌的竞争，是信息传播手段、方法和效果的竞争，谁能够了解更多的旅游者
的信息，能够针对旅游者进行有效的旅游信息传播、控制，那么谁就会有更大的
主动性。伴随着我国旅游业的发展，我国的旅游传媒发展至今已经具备了一定的
规模，涌现出一批深受旅游者喜爱的旅游图书、旅游电视节目和旅游网站，
本系统采用 B/S 架构实现，其中服务端程序采用 Java 语言开发，基于
Spring MVC+Hibernate 框架实现，从而运用了 MVC 架构，将业务逻辑和视图全
面分离，提高了代码的重用性，减少了冗余代码的出现。因其本身将视图逻辑分
离，互不影响，解决了以往 JSP WEB 程序里 JSP 脚本和 HTML 标签混合存在使页
面结构杂乱不易维护的问题，同时也为系统修改和扩展提供了良好的条件。系统
Java 代码采用面向对象思想设计，业务逻辑按照系统功能模块分离，独立存在，
杜绝不通业务之间代码影响。MySQL 作为本系统的数据库，成为本系统不二之选。
在程序中，基本的数据库操作用原生 SQL 脚本自己编写，从而提高了数据库操作
的灵活性和便利性，同时也提高了数据库查询效率，而其他设计多表联查、数据
类型处理等操作也采用自己编写 SQL 脚本来实现。WEB 服务器部分同样采用最常
见的 Tomcat 8.5 搭建，在项目开发中采用 JDK8。系统客户端页面基于 Bootstrap
和 JQuery 以及 HTML5 整合实现，可以很好的适应各种屏幕、分辨率的设备，从
而实现的响应式的页面设计。
关键词：旅游 B/S 架构 Tomcat MySQL Bootstrap Jquery
旅游网站系统的设计与实现
Abstract
To achieve increasing returns, tourism e-business websites must make full use
of the network to carry out technological innovation. Through the analysis of the
market prospect, product strategy and profit model of China's travel electronic
commerce website, the Countermeasures of the future development of China's travel
electronic commerce website are discussed in combination with the constraints faced
by it.
Since the reform and opening up, China's tourism industry has developed
rapidly. At present, China is in a period of transition from a large tourist country to a
powerful tourist power. The competition of international tourism and domestic
tourism is extremely fierce, the non storage and non transferability of tourism
products, as well as the substitutability of tourist destinations, have all decided
tourism. The competition of the industry is the competition of the brand. It is the
competition of the means, methods and effects of information dissemination. Who can
understand more tourists' information, and can carry out effective travel information
and control for the tourists, then who will have greater initiative. With the
development of China's tourism industry, the development of China's tourism media
has already had a certain scale, and a number of tourist books, TV programs and
tourist websites have emerged, which are popular among tourists.
This system is implemented with B/S architecture, in which the server
program is developed in Java language and based on the Spring MVC+Hibernate
framework. Thus, the MVC architecture is used to separate the business logic and
view, which improves the reusability of the code and reduces the appearance of
redundant code. Because it separates the logic of view itself and does not affect each
other, it solves the problem that the JSP script and the HTML label in the previous
JSP WEB program make the page structure disorderly and difficult to maintain, and
also provide good conditions for the system modification and extension. The Java
code of the system is designed by object-oriented thinking. The business logic is
separated from the functional modules of the system and exists independently, so as to
eliminate the influence of code between businesses. As the database of the system,
MySQL becomes the best choice of the system. In the program, the basic database
exercises the original SQL script to write its own, which improves the flexibility and
convenience of the database operation. At the same time, it also improves the
efficiency of database query, while other operations such as multi table connection
and data type processing have also been implemented by writing SQL feet. The WEB
server part is also built with the most common Tomcat 8.5, and JDK8 is used in
project development. System client page based on Bootstrap and JQuery and HTML5
integration implementation, can be well adapted to various screen, resolution
equipment, so as to achieve the response type of page design.
Keywords：Tourism B/S structs Tomcat MySQL Bootstrap Jquery
