本科毕业设计论文
题目：付费问答系统设计与实现
系 别：
专 业：
班 级：
学生姓名：
学生学号：
指导教师：
毕业设计论文
摘 要
在如今社会上，关于信息上面的处理，没有任何一个企业或者个人会忽视，如何让
信息急速传递，并且归档储存查询，采用之前的纸张记录模式已经不符合当前使用要求
了。所以，对问答信息管理的提升，也为了对问答信息进行更好的维护，付费问答系统
的出现就变得水到渠成不可缺少。通过对付费问答系统的开发，不仅仅可以学以致用，
让学到的知识变成成果出现，也强化了知识记忆，扩大了知识储备，是提升自我的一种
很好的方法。通过具体的开发，对整个软件开发的过程熟练掌握，不论是前期的设计，
还是后续的编码测试，都有了很深刻的认知。
付费问答系统通过 MySQL 数据库与 Spring Boot 框架进行开发，付费问答系统能够
实现新闻类型管理，问题帖子管理，付费记录管理，新闻信息管理，用户管理，轮播图
管理等功能。
通过付费问答系统对相关信息的处理，让信息处理变的更加的系统，更加的规范，
这是一个必然的结果。已经处理好的信息，不管是用来查找，还是分析，在效率上都会
成倍的提高，让计算机变得更加符合生产需要，变成人们不可缺少的一种信息处理工具，
实现了绿色办公，节省社会资源，为环境保护也做了力所能及的贡献。
关键字：付费问答系统，问题帖子，付费记录
毕业设计论文
Abstract
In today's society, with regard to the processing of information, no enterprise or
individual will ignore how to quickly transmit information and archive and store queries. The
previous paper record mode is no longer in line with current usage requirements. Therefore, in
order to improve the management of question and answer information, and to better maintain
the question and answer information, the emergence of the paid question and answer system
has become inevitable. Through the development of the paid question answering system, not
only can you apply what you have learned, but also make the knowledge you learn into results
appear, but also strengthen the knowledge memory and expand the knowledge reserve, which
is a good way to improve yourself. Through specific development, I have a good grasp of the
entire software development process, whether it is the early design or the follow-up coding
test, I have a very deep understanding.
The paid question and answer system is developed through MySQL database and Spring
Boot framework. The paid question and answer system can realize news type management,
question post management, paid record management, news information management, user
management, carousel image management and other functions.
Through the processing of relevant information through the paid question and answer
system, it is an inevitable result to make information processing more systematic and more
standardized. The information that has been processed, whether it is used for search or
analysis, will be doubled in efficiency, making computers more suitable for production needs,
becoming an indispensable information processing tool for people, and realizing green office,
Save social resources and contribute to environmental protection.
Key Words：Paid Q&A System, Question Posts, Paid Records
毕业设计论文
目 录
第一章 绪论...............................................................................................................................1
1.1 选题背景 ..............................................................................................................................1
1.2 选题意义 ..............................................................................................................................1
1.3 研究内容 ..............................................................................................................................2
第二章 开发环境.......................................................................................................................3
2.1 JAVA 语言..............................................................................................................................3
2.2 MYSQL 数据库....................................................................................................................3
2.3 ECLIPSE 开发工具 .................................................................................................................4
2.4 SPRING BOOT 框架 ................................................................................................................4
2.5 B/S 架构................................................................................................................................5
第三章 系统分析.......................................................................................................................6
3.1 可行性分析...........................................................................................................................6
3.1.1 技术可行性................................................................................................................6
3.1.2 操作可行性................................................................................................................6
3.1.3 经济可行性................................................................................................................6
3.2 系统流程分析.......................................................................................................................7
3.3 系统性能分析.....................................................................................................................10
3.3.1 系统安全性..............................................................................................................10
3.3.2 数据完整性..............................................................................................................11
3.3.3 系统可扩展性..........................................................................................................11
3.4 系统功能分析.....................................................................................................................11
第四章 系统设计.....................................................................................................................14
4.1 系统设计目标 ....................................................................................................................14
4.2 功能结构设计.....................................................................................................................15
4.3 数据库设计.........................................................................................................................16
4.3.1 数据库概念设计.....................................................................................................16
4.3.2 数据库物理设计.....................................................................................................20
毕业设计论文
第五章 系统实现.....................................................................................................................22
5.1 管理员功能实现.................................................................................................................22
5.1.1 问题帖子管理.........................................................................................................22
5.1.2 付费记录管理.........................................................................................................22
5.1.3 新闻信息管理.........................................................................................................23
5.1.4 用户管理.................................................................................................................24
5.1.5 轮播图管理.............................................................................................................24
5.2 用户功能实现 ....................................................................................................................25
5.2.1 新闻信息.................................................................................................................25
5.2.2 发布帖子.................................................................................................................26
5.2.3 回答帖子.................................................................................................................26
5.2.4 查看帖子.................................................................................................................27
5.2.5 付费记录查看.........................................................................................................27
第六章 系统测试.....................................................................................................................29
6.1 测试任务 ............................................................................................................................29
6.2 测试目标 ............................................................................................................................29
6.3 测试方案 ............................................................................................................................29
6.4 系统测试的特点.................................................................................................................31
6.5 系统功能测试 ....................................................................................................................32
6.5.1 用户登录测试.........................................................................................................32
6.5.2 付费记录查询测试.................................................................................................32
6.6 系统测试结果 ....................................................................................................................32
结 论.......................................................................................................................................33
致 谢.......................................................................................................................................35
参考文献...................................................................................................................................36
