毕 业 设 计（论文）
题目：济南旅游网站设计与实现
I
摘 要
互联网发展到如今也近 20 年之久，济南旅游网站一直作为互联网发展中的
一个重要角色在不断更新进化。济南旅游网站从最初的文本显示到现在集文字、
视频、音频与一体，成为一种网络多媒体浏览网站。作为一种媒体传输媒介，济
南旅游网站如今也分各个类别，各种形式。本文着重对济南旅游网站进行分析和
研究，浅析济南旅游网站的现状和存在的一些问题并对此进行研究，通过对问题
和现状的分析研究和对用户需求的一个简单整理建模，设计并且实现一个济南旅
游网站。
济南旅游网站采用的开发框架为 SSM 框架，也就是 Spring mvc、Spring、
MyBatis 这三个框架，页面设计用的是 jsp 技术作为动态页面文件设计，jsp 文件
里可以对实现 html 等界面布局的代码，采用 SpringMVC 替代传统的 struts2 框架，
主要对 jsp 访问的拦截和控制，Spring 作为整个控制的核心，通过控制反转技术
和面向切面技术，让 Spring 自动对使用的类文件进行调用和导入，MyBatis 主要
作为底层操作数据库，不牵扯业务逻辑，开发工具采用 Eclipse，服务器用的是
tomcat。编码语言是 Java，数据库采用 Mysql。
关键词：济南旅游网站；Java；MySQL；SSM 框架；VUE 框架
II
Abstract
It has been nearly 20 years since the development of the Internet, and Jinan
tourism websites have been constantly updating and evolving as an important role in
the development of the Internet. Jinan tourism website has integrated text, video and
audio from the initial text display to now, becoming a kind of network multimedia
browsing website. As a media transmission medium, Jinan tourism websites are now
divided into various categories and various forms. This article focuses on the analysis
and research of Jinan tourism website, analyzes the current situation and existing
problems of Jinan tourism website, and conducts research on it. Through the analysis
and research of the problems and current situation and a simple modeling of user
needs, design and Realize a Jinan tourism website.
The development framework used by the Jinan tourism website is the SSM
framework, which is Spring mvc, Spring, and MyBatis. The page design uses jsp
technology as a dynamic page file design. The jsp file can be used to implement the
code of the interface layout such as html. Using SpringMVC instead of the traditional
struts2 framework, it mainly intercepts and controls JSP access. Spring is the core of
the entire control. Through the inversion of control technology and the aspect-oriented
technology, Spring can automatically call and import the used class files. MyBatis is
mainly used as The underlying operation database does not involve business logic, the
development tool uses Eclipse, and the server uses tomcat. The coding language is
Java, and the database uses Mysql.
Key Words ： Jinan Tourism Website; Java; MySQL; SSM framework; VUE
framework
III
目 录
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 论文结构安排 .................................................................................................2
2 相关技术............................................4
2.1 SSM 框架介绍 .................................................................................................4
2.2 B/S 架构介绍 ...................................................................................................4
2.3 MYSQL 数据库介绍........................................................................................5
2.4 JAVA 语言介绍 ...............................................................................................6
2.5 VUE 框架 .........................................................................................................6
3 系统分析............................................7
3.1 系统可行性分析 ..............................................................................................7
3.1.1 技术可行性分析 ..................................................................................7
3.1.2 经济可行性分析 ..................................................................................7
3.1.3 运行可行性分析 ..................................................................................7
3.2 系统性能分析 ..................................................................................................8
3.2.1 系统安全性 ..........................................................................................8
3.2.2 数据完整性 ..........................................................................................8
3.2.3 系统可扩展性 .......................................................................................9
3.3 系统流程分析 ..................................................................................................9
3.3.1 系统登录流程 .....................................................................................10
3.3.2 信息添加流程 .....................................................................................11
3.3.3 信息删除流程 .....................................................................................11
4 系统设计...........................................13
4.1 系统概要设计 ................................................................................................13
IV
4.2 系统功能结构设计 ........................................................................................13
4.3 数据库设计 ....................................................................................................14
4.3.1 数据库 E-R 图设计.............................................................................14
4.3.2 数据库表结构设计 ............................................................................15
5 系统实现...........................................20
5.1 用户信息管理 ...............................................................................................20
5.2 旅游资讯管理 ...............................................................................................20
5.3 景区介绍管理 ...............................................................................................21
5.4 首页信息 .......................................................................................................21
6 系统测试 ...........................................23
6.1 本系统测试 .................................................................................................23
6.1.1 登录功能测试 .....................................................................................23
6.1.2 修改密码功能测试 .............................................................................24
6.2 测试结果分析 ................................................................................................24
结 论...............................................25
参考文献.............................................27
致 谢...............................................28
