基于微信公众号的旅游论坛管理系统设计
摘要：自二零一九年十二月以来，湖北省武汉市部分医院陆续发现了多例有华南海鲜市场暴露史的不明原因肺炎病
例，证实为 2019 新型冠状病毒感染引起的急性呼吸道传染病。截止二零二一年五月，新型冠状病毒肺炎疫情席卷全
世界各个国家，目前全球已有上亿人确诊，超三百万人因此丧失生命。由于受到此次新型冠状病毒肺炎疫情的严重
影响, 中国政府本着对中国人民和世界人民生命安全和身体健康高度负责的态度，采取最全面、最严格、最彻底的
防控举措，同疫情开展坚决斗争。大家为了呼应祖国的政策，人们都尽量减少外出待在家里，为抗击新冠做出自己
的贡献。朋友圈打开，也没有来自各地的美丽照片了，你看到的是更多的人们从卧室到客厅的旅行，经过几个月在
家待着不出门，疫情结束后，很多人都想着出门旅游好好玩一次去放松心情，为了实现传输旅游信息与经验，使用
户更好的了解旅游景点和交流，使用 eclipse 及 SQLite 数据库等开发工具的旅游论坛管理系统由此诞生。该系统集
发布帖子和查询景点等功能，可以看到景点的详细信息和游客发布的游记，可以知道什么时候去最适合，制定路线
等等，减少游客一些不必要的麻烦。
关键词：eclipse;微信公众号;旅游论坛;MySQL 数据库
WeChat forum official account management system
Abstract: Since December 2019, A number of cases of unexplained pneumonia with history of exposure to the seafood
market in Hubei were found in a number of hospitals in Wuhan, Hubei Province, and proved to be acute respiratory
infectious diseases caused by 2019 New Coronavirus infection. As at may 2021, The epidemic of New Coronavirus
pneumonia has swept all countries around the world., At present, hundreds of millions of people around the world have been
diagnosed, and more than three million people have died, Seriously affected by the epidemic of New Coronavirus
pneumonia., With a highly responsible attitude towards the life safety and health of the Chinese people and the people of the
world, the Chinese government has taken the most comprehensive, rigorous and thorough prevention and control measures to
resolutely fight against the epidemic.,everybody in response to thepolicy of the motherland， people try to avoid going out
and staying at home ，Make our own contribution to fight against the epidemic 。Open the circle of friends，there are no more
beautiful photos of places，what we see is more about the travel from the bedroom to the living room。After months at home，
after the end of the epidemic, many people want to go out for a good trip to relax。In order to realize the transmission of
tourism information and experience，make users better understand the tourist attractions and communicate with each other，
the tourism forum system with eclipse and SQLite database is born。
The system has the functions of publishing posts and querying scenic spots，you can see the detailed information of the scenic
spots and the travel notes issued by tourists，can know when is the best time to go, make routes and so on, so as to reduce
some unnecessary troubles for tourists。
Keywords: eclipse; WeChat official account; Tourism Forum; MySql database
目 录
一、系统概述 ............................................................. 3
（一）系统简介 ........................................................... 3
（二）系统分析 ........................................................... 3
1.需求分析 ......................................................... 3
2.业务分析 ......................................................... 4
3.功能模块设计 ..................................................... 6
二、开发工具及相关技术介绍 ............................................... 7
（一）开发工具介绍 ....................................................... 7
1、eclipse ....................................................... 7
2、MySQL 数据库 .................................................. 7
3、ngrok ......................................................... 7
4、JDK ........................................................... 7
5、Tomcat ........................................................ 7
（二）相关技术介绍 ....................................................... 8
1、Java .......................................................... 8
2、SSH ........................................................... 8
3、SpringBoot .................................................... 8
三、系统实施 ............................................................. 9
（一）数据库设计 ......................................................... 9
（二）用户信息修改维护模块 .............................................. 10
1、用户登录界面 ................................................. 10
2、用户注册界面 ................................................. 12
3、修改权限界面 ................................................. 14
（三）旅游景点管理模块 .................................................. 16
1、景点搜索界面 ................................................. 16
2、景点信息界面 ................................................. 18
3、修改景点界面 ................................................. 19
（四）游记管理模块 ...................................................... 21
1、浏览游记界面 ................................................. 21
2、发布游记界面 ................................................. 23
3、回复游记界面 ................................................. 25
四、系统测试 ............................................................ 26
（一）测试过程 .......................................................... 26
五、结束语 .............................................................. 27
六、参考文献 ............................................................ 28
参考文献
[1] 吴超. 从 Java 走向 JavaEE[M].北京:人民邮电出版社,2009.01
[2] 刘亚宾. 精通 Eclipse[M].北京:电子工业出版社,2004.10
[3] 李松林,陈华清,任鑫. Eclipse 宝典[M].北京:电子工业出版社,2007.05
[4] 塔黑戈尔贾尔,威廉斯. 学习 MySQL[M].南京:东南大学出版社,2007.05
[5]施瓦茨,扎伊采夫,特卡琴科. 高性能 MySQL[M].北京:电子工业出版社,2013.05
[6] Bruce Eckel. Java 编程思想[M].北京:机械工业出版社,2007.06
[7]凯·S·霍斯特曼. Java 核心技术[M].北京:机械工业出版社,2019.12
[8]Ben Forta. MySQL 必知必会[M].北京:人民邮电出版社,2020.021
[9]明日科技. Java 从入门到精通[M].北京:清华大学出版社,2019.02
[10]黄能耿,邱晓荣,许敏. JavaEE 应用开发及实训[M].北京:机械工业出版社,2018.07
[11]克雷格·沃斯. Spring Boot 实战[M].北京:人民邮电出版社,2018.07
[12]布洛赫. Effective Java [M].北京:电子工业出版社,2015.10
[13]周志明. 深入理解 Java 虚拟机[M].北京:机械工业出版社,2013.06
[14]焦玲,胡晓辉,林春洪. java 语言程序设计[M].北京:机械工业出版社,2009.04
[15]科曼. 算法导论[M].北京:机械工业出版社[M],2006.06
[15]塞奇威克,韦恩. 算法[M].北京:人民邮电出版社[M],2012.10
