摘要当今旅游业发展迅速、旅游成为了人们的生活习惯。同时，计算机行业发展火爆，互联网的运用使得人们旅行更加方便。在旅游网站上，人们可以足不出户了解景点信息、酒店信息、当地民俗等等，方便了人们的出行。另一方面自由行的兴起，使越来越多的驴友选择了网上交流沟通，线下见面拼团一起出行的旅游方式。在此基础上本课题为游客、商家、景区提供了一个沟通交流的平台。本课题在IntelliJ IDEA上进行开发，使用Spring+SpringMVC+MyBatis框架进行代码编写，数据库采用MySQL Server5.5,服务器采用Tomcat 7.0，并运用了JSP、AJAX等技术。51054

本网站可以较为全面的展示一个景区的信息，方便驴友之间的沟通交流，制定旅行计划。具有看帖、回帖，浏览景区信息、最新帖子、旅行活动，发起、参与旅行活动等功能。相对于其他网站，本网站操作简单，界面清晰，系统运行稳定，并针对于自由行的旅客，具有一定特色。

该论文有图20幅，表5个，参考文献20篇。

毕业论文关键词：自组织旅游  Java  JSP  数据库  SpringMVC

 Design and Implementation Self-organizing Travel Sites

Abstract

By the rapid development of tourism, tourism has become the people's living habits. At the same time, the computer industry is hot, use of the Internet makes it easier to travel. On travel websites, people can stay at home browse information on attractions, hotel information, local customs, etc., and travel websites facilitate people's travel. On the other hand because of the rise of the Free Tour, more and more people choose online communication, group meet offline and travel together. On this basis, this paper provides a communication platform for visitors, businesses, attractions. This can be carried out on the IntelliJ IDEA development using Spring + SpringMVC + MyBatis framework of the preparation of the code, the database uses MySQL Server5.5, server uses Tomcat 7.0, and the use of JSP, AJAX and other technologies.

This site can show a more comprehensive scenic information to facilitate communication between the tourist, trip planning. Have to see posts, replies, browse resort information, latest post, tours, sponsoring, participating in tours and other functions. Compared to other sites, this site is simple, clear interface, the system is stable, and directed to the free exercise of visitors, have certain characteristics.

Key Words: JSP   Java  Mysql  SpringMVC  Self-Organized Tour

目  录

摘要Ⅰ

Abstract-Ⅱ目录Ⅲ图清单-Ⅳ

表清单-Ⅳ

1 绪论1

1.1背景1

1.1.1国内旅游网站现状1

1.1.2互联网+旅游业的发展-2

1.1.3旅游网站的建设-2

1.2开发技术介绍2

1.2.1开发环境简介2

1.2.2 SpringMVC+Spring+MyBatis框架-3

1.3本章小结4

2 需求分析-4

2.1可行性分析-5

2.1.1技术可行性-5

2.1.2经济可行性-5

2.2.3操作可行性-5

2.2安全性分析-5

2.2.1用户权限安全性-5

2.2.2输入安全5

2.3系统功能分析5

2.3.1登录6

2.3.2注册6

2.3.3浏览景点信息6

2.3.4社区6

2.3.5活动发起、参与-6

2.3.6查看活动-6

2.4类图-6

2.5用例图8

3 概要设计9

3.1模块设计-9

3.2数据库设计-10

3.2.1E-R模型-10

3.2.2数据库表逻辑结构设计11

3.3功能设计13

3.3.1身份验证和登录认证-13

3.3.2社区发帖、回帖功能-15

3.3.3活动发布、参与功能15

3.4本章小结16

4 详细设计与实现16