毕 业 设 计（论 文）
题目：基于 Spring Boot 的在线问卷调查系统的设计与实现
摘 要
如今社会上各行各业，都在用属于自己专用的软件来进行工作，互联网发展
到这个时候，人们已经发现离不开了互联网。互联网的发展，离不开一些新的技
术，而新技术的产生往往是为了解决现有问题而产生的。针对于问卷调查信息管
理方面的不规范，容错率低，管理人员处理数据费工费时，采用新开发的在线问
卷调查系统可以从根源上规范整个数据处理流程的正规性和合法性。
在线问卷调查系统能够实现问卷管理，用户管理，题目管理，问卷调查管理，
新闻资讯管理等功能。该系统采用了 Mysql 数据库，Java 语言，Spring Boot 框
架等技术进行编程实现。
在线问卷调查系统可以提高问卷调查信息管理问题的解决效率，优化问卷调
查信息处理流程，并且能够保证存储数据的安全，它是一个非常可靠，非常安全
的应用程序。
关键词：在线问卷调查系统；Mysql 数据库；Java 语言
Abstract
Nowadays,all walks of life in the society,are using their own special software to
work,the Development of the Internet at this time,people have found that they can not
do without the Internet.The development of the Internet is inseparable from some new
technologies,and new technologies are often produced to solve existing problems.In
view of the non-standard questionnaire information management,low fault tolerance
rate,management personnel processing data time-consuming,using the newly
developed online questionnaire system can standardize the whole data processing
process from the root of the formal and legitimate.
Online questionnaire survey system can achieve questionnaire management,user
management,topic management,questionnaire management,news management and
other functions.The system uses Mysql database,Java language,Spring Boot
framework and other technologies to achieve programming.
Online questionnaire system can improve the efficiency of questionnaire
information management problems,optimize the process of questionnaire information
processing,and can ensure the security of stored data,it is a very reliable,very safe
application.
Key Words ： Online questionnaire survey system; Mysql database; The Java
language
目 录
第 1 章 绪论 ..................................................................................................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术 ..............................................................................................3
2.1 JAVA 语言 .........................................................................................................3
2.2 MYSQL 数据库 ...............................................................................................3
2.3 IDEA 开发工具................................................................................................4
2.4 SPRING BOOT 框架............................................................................................4
第 3 章 系统分析 ..........................................................................................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 技术可行性 ..........................................................................................5
3.1.2 经济可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程 .........................................................................................................5
3.2.1 操作流程 ..............................................................................................6
3.2.2 登录流程 ..............................................................................................6
3.2.3 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................7
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计 ........................................................................................................11
4.1 功能结构设计 ...............................................................................................11
4.2 数据库设计 ...................................................................................................12
4.2.1 数据库概念设计 ................................................................................12
4.2.2 数据库物理设计 ................................................................................15
第 5 章 系统实现 ........................................................................................................18
5.1 管理员功能实现 ...........................................................................................18
5.1.1 问卷管理 ............................................................................................18
5.1.2 问卷调查管理 ....................................................................................18
5.1.3 题目管理 ............................................................................................19
5.1.4 用户管理 ............................................................................................19
5.1.5 新闻资讯管理 ....................................................................................20
5.2 用户功能实现 ...............................................................................................20
5.2.1 问卷列表 ............................................................................................20
5.2.2 问卷调查 ............................................................................................21
5.2.3 新闻资讯 ............................................................................................21
5.2.4 问卷调查记录 ....................................................................................22
第 6 章 系统测试 ........................................................................................................23
6.1 功能测试 .......................................................................................................23
6.1.1 登录功能测试 ....................................................................................23
6.1.2 修改密码功能测试 ............................................................................24
6.2 系统测试结果 ...............................................................................................25
结 论 ..........................................................................................................................26
参考文献 ......................................................................................................................28
致 谢 ..........................................................................................................................29
