沈阳理工大学学士学位论文

摘 要

在校园、企业机关里，传统的问卷调查不仅繁琐、发放问卷困难，回收问卷更是一个难解决的问题，并且相当的费时费力。而网络问卷调查系统的出现，从根本上解决这一问题，与传统问卷调查相比其更加省时、省力，回收率也比较高；其题目支持单选题、多选题、带文本输入的单选题、带文本输入的多选题、问答题；用户可以给某问卷添加图片；用户可以给问卷设置密码，IP限制，包括黑名单和白名单，用户也可以设置同一IP是否可以重复提交等防作弊选项；系统提供对客观题调查结果的智能统计，并用图表展示出来；针对每一张问卷的每一个题目的任易选项，用户也可以设置截断，终止调查，也可以设置跳转，即被调查者点击了某个选项后自动跳转到与该选项匹配的后续题目上。

关键词：J2EE体系结构；问卷调查；设计模式；通用框架

V

沈阳理工大学学士学位论文

Abstract

In the campus, enterprise authority, not only the traditional questionnaire trival, difficulty of a questionnaire, and recycling questionnaire is a difficult problem, and quite laborious. And the emergence of the network questionnaire system, fundamentally solve the problem, compared with the traditional questionnaire survey of its time, manpower, more recovery rate is high; The subject support single, multiple choice of topics, single topic selection with text input, multiple choice and questions and answers with text input; The user can add images to a questionnaire; The user can set the password to questionnaire, IP restrictions, including black and white list, whether the user can also set the same IP can be repeated to submit such as anti-cheating options; System provides the objective in the smarter statistics of survey results and chart display; Each title for each questionnaire as easy option, the user can also set the truncation, terminate the investigation, also can set the jump, the respondents will redirect after click on an option to match with the option of the follow-up questions.

Keywords: J2EE;questionnaire;common framework;survey

VI

沈阳理工大学学士学位论文

目 录

1 引言 ......................................................................................................................... 1

1.1 开发背景 ..................................................................................................... 1 1.2 国内外研究现状 ......................................................................................... 1 1.3 系统设计的目标 ......................................................................................... 1 2 开发环境及相关技术的介绍 ................................................................................. 3

2.1 开发环境 ..................................................................................................... 3 2.2 开发软件介绍 ............................................................................................. 3

2.2.1 关于MyEclipse ................................................................................. 3 2.2.2 运行环境 ........................................................................................... 4 2.2.3 SQL SERVER 简介 .......................................................................... 4 2.2.4 Tomcat简介 ...................................................................................... 5 2.3 相关开发技术介绍 ..................................................................................... 5

2.3.1 JavaEE简介 ...................................................................................... 5 2.3.2 JSP与Servlet简介 ........................................................................... 6 2.3.3 JavaScript简介 ................................................................................. 7 2.3.4 Css+Div简介 .................................................................................... 8 2.3.5 B/S结构 ............................................................................................ 8

3 系统需求分析 ....................................................................................................... 10

3.1 功能需求 ................................................................................................... 10 3.2 功能分析 ................................................................................................... 10 3.2 数据库分析 ............................................................................................... 12 4 系统总体设计 ....................................................................................................... 13

4.1 系统主要功能设计 ................................................................................... 13 4.2 各功能模块设计 ....................................................................................... 13 4.3 系统构架 ................................................................................................... 14 4.4 系统总体结构 ........................................................................................... 14 4.5 数据库设计 ............................................................................................... 15

4.5.1 数据表设计 ..................................................................................... 15

VII

沈阳理工大学学士学位论文

4.5.2 数据库连接方法 ............................................................................. 18

5 系统详细设计与实现 ........................................................................................... 21

5.1 前台功能模块 ........................................................................................... 21 5.2 后台功能模块 ........................................................................................... 23 6 系统测试 ............................................................................................................... 28

6.1 测试概论 ................................................................................................... 28 6.2 网上问卷调查系统采用的测试方法 ....................................................... 28

6.2.1 系统后台界面测试 ......................................................................... 29 6.2.2 系统前台界面测试 ......................................................................... 30 6.2.3 功能测试 ........................................................................................ 30

7 结论 ....................................................................................................................... 31

7.1 本系统的特点 ........................................................................................... 31 7.2 本系统存在的不足 ................................................................................... 31 7.3 心得体会 ................................................................................................... 31 致 谢 ........................................................................................................................... 33 参考文献 ..................................................................................................................... 34 附录A 英文附录 ..................................................................................................... 35 附录B 中文附录 ..................................................................................................... 39 附录C 程序附录 ..................................................................................................... 43

VIII