大学本科毕业论文（设计）
问卷调查系统的设计与实现
学 号：
学 生 姓 名：
入 学 年 度：
指 导 教 师：
完 成 日 期：
I
摘 要
传统信息的管理大部分依赖于管理人员的手工登记与管理，然而，随着近些年信
息技术的迅猛发展，让许多比较老套的信息管理模式进行了更新迭代，问卷信息因为
其管理内容繁杂，管理数量繁多导致手工进行处理不能满足广大用户的需求，因此就
应运而生出相应的问卷调查系统。
本问卷调查系统分为管理员还有用户两个权限，管理员可以管理用户的基本信息
内容，可以管理新闻资讯信息以及新闻资讯的租赁信息，能够与用户进行相互交流等
操作，用户可以查看问卷信息，可以查看新闻资讯以及查看管理员回复信息等操作。
该问卷调查系统采用的是 WEB 应用程序开发中最受欢迎的 B/S 三层结构模式，
使用占用空间小但功能齐全的 MySQL 数据库进行数据的存储操作，系统开发技术使
用到了 JSP 技术。该问卷调查系统能够解决许多传统手工操作的难题，比如数据查询
耽误时间长，数据管理步骤繁琐等问题。总的来说，问卷调查系统性能稳定，功能较
全，投入运行使用性价比很高。
关键词：问卷调查系统；MySQL 数据库；SSM 技术
II
Abstract
Most of the management of traditional car rental information relies on the manual
registration and management of managers. However, with the rapid development of
information technology in recent years, many old-fashioned information management
models have been iterated and updated, and car rental information is because of its The
management content is complicated, and the large number of managements leads to
manual processing that cannot meet the needs of the majority of car rental users. Therefore,
the corresponding car rental management system should be born.
The car rental management system is divided into two functions: the administrator
and the user. The administrator can manage the basic information content of the user, can
manage the car information and the rental information of the car, and can communicate
with the user, etc., and the user can view the car information. You can rent a car online,
you can leave a message online, and view the administrator's reply information.
The car rental management system adopts the most popular B/S three-layer structure
mode in WEB application development, and uses a small but full-featured MySQL
database for data storage operations. The system development technology uses JSP
technology. The car rental management system can solve many traditional manual
operation problems, such as long delays in data query and cumbersome data management
steps. In general, the car rental management system has stable performance and
full-featured functions.
Key Words：Car rental management system; MySQL database; SSM technology
III
目 录
摘 要 ................................................................................................................................I
Abstract ................................................................................................................................II
目 录 .............................................................................................................................III
第一章 课题背景及研究内容............................................................................................1
1.1 课题背景.................................................................................................................1
1.2 开发目的和意义.....................................................................................................1
1.3 论文研究内容.........................................................................................................1
第二章 相关技术..................................................................................................................3
2.1 B/S 结构...................................................................................................................3
2.2 MySQL 数据库........................................................................................................3
第三章 系统分析..................................................................................................................5
3.1 可行性分析..............................................................................................................5
3.1.1 时间可行性...................................................................................................5
3.1.2 经济可行性..................................................................................................5
3.1.3 操作可行性..................................................................................................5
3.1.4 技术可行性..................................................................................................5
3.1.5 法律可行性..................................................................................................5
3.2 系统流程分析.........................................................................................................6
3.3 系统功能需求分析..................................................................................................7
3.4 系统非功能需求分析.............................................................................................7
第四章 系统设计..................................................................................................................9
4.1 总体功能.................................................................................................................9
4.2 系统模块设计.........................................................................................................9
4.3 数据库设计...........................................................................................................10
4.3.1 数据库设计................................................................................................10
4.3.2 数据库 E-R 图...........................................................................................10
4.3.3 数据库表设计............................................................................................11
第五章 系统实现................................................................................................................13
5.1 管理员功能模块的实现.......................................................................................13
5.1.1 问卷列表....................................................................................................13
5.1.2 新闻资讯信息管理....................................................................................13
5.1.3 新闻资讯类型管理....................................................................................14
第六章 系统测试................................................................................................................15
6.1 软件测试................................................................................................................15
6.2 测试环境................................................................................................................16
6.3 测试用例...............................................................................................................16
6.3.1 用户登录测试............................................................................................16
6.4.2 添加新闻资讯类别测试............................................................................16
6.5 测试结果................................................................................................................16
结 论..................................................................................................................................17
参考文献..............................................................................................................................19
