JAVA基于S2SH的问卷调查平台系统【数据库设计、论文、源码、开题报告】

主要使用技术

Spring+Struts2+Hibernate+JSP+CSS+JS+Mysql

功能介绍

本系统是一套jsp+mysql的问卷调查系统，包含普通用户和管理员角色，功能如下：
普通用户：注册、登录、查看、修改我的个人信息、查看问卷调查列表、查看问卷详情、问卷作答并提交、查看网站公告。
管理员用户：可以修改个人密码、管理员管理、注册会员（用户）管理、
问卷信息管理（添加问卷、问卷预览、添加问卷题目、查看问卷调查结果、柱状图显示问卷调查结果）、系统公告管理、退出系统等等。
本系统使用ssh框架，功能完善，包含论文等资料。

数据库脚本

/*
SQLyog Ultimate v9.30 
MySQL - 5.7.26 : Database - db_toupiao
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_toupiao` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;

USE `db_toupiao`;

/*Table structure for table `t_admin` */

DROP TABLE IF EXISTS `t_admin`;

CREATE TABLE `t_admin` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(50) DEFAULT NULL,
  `userPw` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `t_admin` */

insert  into `t_admin`(`userId`,`userName`,`userPw`) values (1,'admin','123456');

/*Table structure for table `t_gonggao` */

DROP TABLE IF EXISTS `t_gonggao`;

CREATE TABLE `t_gonggao` (
  `gonggao_id` int(11) NOT NULL AUTO_INCREMENT,
  `gonggao_title` varchar(50) DEFAULT NULL,
  `gonggao_content` varchar(255) DEFAULT NULL,
  `gonggao_data` varchar(50) DEFAULT NULL,
  `gonggao_fabuzhe` varchar(50) DEFAULT NULL,
  `gonggao_del` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`gonggao_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `t_gonggao` */

insert  into `t_gonggao`(`gonggao_id`,`gonggao_title`,`gonggao_content`,`gonggao_data`,`gonggao_fabuzhe`,`gonggao_del`) values (1,'网站上线啦','网站上线啦','2021-03-02 12:21:28',NULL,NULL),(2,'欢迎大家积极参与！','欢迎大家积极参与问卷调查系统','2021-03-02 12:21:36',NULL,NULL);

/*Table structure for table `t_toupiao` */

DROP TABLE IF EXISTS `t_toupiao`;

CREATE TABLE `t_toupiao` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) DEFAULT NULL,
  `wenjuan_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `t_toupiao` */

insert  into `t_toupiao`(`id`,`title`,`wenjuan_id`) values ('1338624593185','长时间使用电脑对人体危害，你是这样合理膳食','1338624423793'),('1338624839208','炎热的夏日，头顶着烈日，当你口干舌燥，百无聊赖之时，你会选择','1338624423793'),('1338624983578','以下哪个选项不是不是绿色食品','1338624423793'),('1338625484112','您经常使用化妆品吗','1338625440243'),('1338625526243','.你认为时尚杂志上的化妆品广告数量还应该再增加吗','1338625440243'),('1338855153957','测试题目','1338624423793'),('1338855177043','11111111111','1338855116547');

/*Table structure for table `t_toupiaoxuanxiang` */

DROP TABLE IF EXISTS `t_toupiaoxuanxiang`;

CREATE TABLE `t_toupiaoxuanxiang` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `xuanxiangneirong` varchar(255) DEFAULT NULL,
  `piaoshu` int(11) DEFAULT NULL,
  `toupiao_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `t_toupiaoxuanxiang` */

insert  into `t_toupiaoxuanxiang`(`id`,`xuanxiangneirong`,`piaoshu`,`toupiao_id`) values ('1338624593332','多吃高蛋白，含维生素多的食品 ',2,'1338624593185'),('1338624593436','多吃含磷脂高的事物 ',1,'1338624593185'),('1338624593540','多吃健眼事物 ',0,'1338624593185'),('1338624593645','并没有过多的注意合理膳食 ',1,'1338624593185'),('1338624839312','冰镇汽水或饮料',3,'1338624839208'),('1338624839416','冰淇淋',0,'1338624839208'),('1338624839521','有清凉味的食品',0,'1338624839208'),('1338624839625','什么也不吃 ',1,'1338624839208'),('1338624983680','白菜',2,'1338624983578'),('1338624983783','黄豆',0,'1338624983578'),('1338624983887','紫菜',0,'1338624983578'),('1338624983991','花菜',1,'1338624983578'),('1338625484214','一直用',0,'1338625484112'),('1338625484316','经常用',1,'1338625484112'),('1338625484420','经常用',0,'1338625484112'),('1338625484524','从不用',0,'1338625484112'),('1338625526345','应该增加',0,'1338625526243'),('1338625526477','保持',0,'1338625526243'),('1338625526580','都可以',0,'1338625526243'),('1338625526684','应该减少',2,'1338625526243'),('1338631508945','',0,'1338631508808'),('1338631509051','',0,'1338631508808'),('1338855154060','测试题目选项1',1,'1338855153957'),('1338855154165','测试题目选项2',0,'1338855153957'),('1338855154267','测试题目选项3',0,'1338855153957'),('1338855154371','测试题目选项4',0,'1338855153957'),('1338855177147','222222222',0,'1338855177043'),('1338855177270','333333333',0,'1338855177043');

/*Table structure for table `t_user` */

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(50) DEFAULT NULL,
  `user_pw` varchar(50) DEFAULT NULL,
  `user_realname` varchar(50) DEFAULT NULL,
  `user_address` varchar(50) DEFAULT NULL,
  `user_sex` varchar(50) DEFAULT NULL,
  `user_tel` varchar(50) DEFAULT NULL,
  `user_email` varchar(50) DEFAULT NULL,
  `user_qq` varchar(50) DEFAULT NULL,
  `user_del` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `t_user` */

insert  into `t_user`(`user_id`,`user_name`,`user_pw`,`user_realname`,`user_address`,`user_sex`,`user_tel`,`user_email`,`user_qq`,`user_del`) values (1,'liusan','123456','刘三','北京路','男','13888888888','liusan@yahoo.cn','11111','no'),(2,'lisisi','123456','李思思','北京路','男','13999999999','lisisi@yaho.cn','2223','no');

/*Table structure for table `t_wenjuan` */

DROP TABLE IF EXISTS `t_wenjuan`;

CREATE TABLE `t_wenjuan` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `mingcheng` varchar(255) DEFAULT NULL,
  `shijian` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `t_wenjuan` */

insert  into `t_wenjuan`(`id`,`mingcheng`,`shijian`) values ('1338624423793','目前高校大学生饮食情况状况调查问卷','2021-03-02'),('1338625440243','关于杂志上化妆品广告投放特点的调查','2021-03-02'),('1338855116547','测试问卷调查','2021-03-02');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

项目截图