毕 业 设 计（论 文）
题目：大湾区旅游推荐系统的设计与实现
摘 要
如今社会上各行各业，都喜欢用自己行业的专属软件工作，互联网发展到这
个时候，人们已经发现离不开了互联网。新技术的产生，往往能解决一些老技术
的弊端问题。因为传统大湾区旅游景点信息管理难度大，容错率低，管理人员处
理数据费工费时，所以专门为解决这个难题开发了一个大湾区旅游推荐系统，可
以解决许多问题。
大湾区旅游推荐系统实现的功能包括酒店管理，旅游景点管理，酒店预定管
理，旅游景点预定管理，公告管理，论坛管理，用户管理等功能。该系统采用了
Mysql 数据库，Java 语言，SSM 框架等技术进行编程实现。
大湾区旅游推荐系统可以提高大湾区旅游景点信息管理问题的解决效率，优
化大湾区旅游景点信息处理流程，保证大湾区旅游景点信息数据的安全，它是一
个非常可靠，非常安全的应用程序。
关键词：大湾区旅游推荐系统；Mysql 数据库；Java 语言
Abstract
Nowadays, all walks of life in society like to work with their own
industry-specific software. At this point in the development of the Internet, people
have found that they cannot do without the Internet. The emergence of new
technologies can often solve the drawbacks of some old technologies. Due to the
difficulty in managing the information of traditional tourist attractions in the Greater
Bay Area, the low fault tolerance rate, and the time-consuming and labor-intensive
processing of data by managers, a Greater Bay Area tourism recommendation system
has been developed specifically to solve this problem, which can solve many
problems.
The functions implemented by the Greater Bay Area tourism recommendation
system include hotel management, tourist attraction management, hotel reservation
management, tourist attraction reservation management, announcement management,
forum management, user management and other functions. The system uses Mysql
database, Java language, SSM framework and other technologies for programming.
The tourism recommendation system in the Greater Bay Area can improve the
efficiency of solving the problem of information management of tourist attractions in
the Greater Bay Area, optimize the information processing process of the tourist
attractions in the Greater Bay Area, and ensure the security of the information and
data of the tourist attractions in the Greater Bay Area. It is a very reliable and very
safe. application.
Key Words ： Greater Bay Area tourism recommendation system; Mysql database;
Java language
目 录
第 1 章 绪论 ..................................................................................................................1
1.1 研究背景意义及内容 .....................................................................................1
1.1.1 研究背景 ..............................................................................................1
1.1.2 研究意义 ..............................................................................................1
1.1.3 研究内容 ..............................................................................................1
1.2 开发所用技术 .................................................................................................2
1.2.1 Java 语言...............................................................................................2
1.2.2 MYSQL 数据库 ....................................................................................2
1.2.3 IDEA 开发工具 ....................................................................................3
1.2.4 SSM 框架 ..............................................................................................3
第 2 章 系统分析 ..........................................................................................................4
2.1 可行性分析 .....................................................................................................4
2.1.1 技术可行性 ..........................................................................................4
2.1.2 经济可行性 ..........................................................................................4
2.1.3 操作可行性 ..........................................................................................4
2.2 需求分析 .........................................................................................................4
2.2.1 性能需求 ..............................................................................................4
2.2.2 功能需求 ..............................................................................................5
第 3 章 系统设计 ..........................................................................................................9
3.1 系统设计思想 .................................................................................................9
3.2 总体设计 .......................................................................................................10
3.2.1 管理员框图 ........................................................................................10
3.2.2 用户框图 ............................................................................................10
3.3 数据库设计 ...................................................................................................11
3.3.1 数据库概念设计 ................................................................................11
3.3.2 数据库物理设计 ................................................................................14
3.4 流程图设计 ...................................................................................................17
第 4 章 系统实现 ........................................................................................................21
4.1 管理员功能实现 ...........................................................................................21
4.1.1 论坛管理 ............................................................................................21
4.1.2 旅游景点管理 ....................................................................................21
4.1.3 旅游景点订单管理 ............................................................................22
4.1.4 酒店信息管理 ....................................................................................22
4.1.5 酒店订单管理 ....................................................................................23
4.1.6 公告信息管理 ....................................................................................23
4.1.7 用户管理 ............................................................................................24
4.2 用户功能实现 ...............................................................................................25
4.2.1 旅游景点 ............................................................................................25
4.2.2 在线论坛 ............................................................................................25
4.2.3 酒店信息 ............................................................................................26
4.2.4 旅游景点预定 ....................................................................................26
4.2.5 酒店预定 ............................................................................................27
第 5 章 系统测试 ........................................................................................................28
5.1 测试任务 .......................................................................................................28
5.2 测试目标 .......................................................................................................28
5.3 测试方案 .......................................................................................................29
5.4 功能测试 .......................................................................................................30
5.4.1 登录功能测试 ....................................................................................30
5.4.2 修改密码功能测试 ............................................................................31
5.5 系统测试结果 ...............................................................................................32
第 6 章 结论 ................................................................................................................33
参考文献 ......................................................................................................................34
致 谢 ..........................................................................................................................35
