基于java在线教育管理系统设计毕业设计程序

/* Navicat MySQL Data Transfer Source Server : 127.0.0.1 Source Server Version : 50553 Source Host : localhost:3306 Source Database : jsp8tvgs Target Server Type : MYSQL Target Server Version : 50553 File Encoding : 65001 Date: 2020-05-07 15:02:43 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `chengjixinxi` -- ---------------------------- DROP TABLE IF EXISTS `chengjixinxi`; CREATE TABLE `chengjixinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `bianhao` varchar(200) DEFAULT NULL COMMENT '编号', `kaoshikemu` varchar(200) DEFAULT NULL COMMENT '考试科目', `xuehao` varchar(200) DEFAULT NULL COMMENT '学号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `chengji` varchar(200) DEFAULT NULL COMMENT '成绩', `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号', `pingyu` longtext COMMENT '评语', PRIMARY KEY (`id`), UNIQUE KEY `bianhao` (`bianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=1588486630614 DEFAULT CHARSET=utf8 COMMENT='成绩信息'; -- ---------------------------- -- Records of chengjixinxi -- ---------------------------- INSERT INTO `chengjixinxi` VALUES ('1588486630613', '2020-05-03 14:17:10', '1588486609', '', '50', '小敏', '60', '001', '成绩不够理想要继续加油啊'); -- ---------------------------- -- Table structure for `config` -- ---------------------------- DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='配置文件'; -- ---------------------------- -- Records of config -- ---------------------------- INSERT INTO `config` VALUES ('1', 'picture1', 'http://localhost:8080/jsp8tvGs/upload/1588486650278.jpg'); INSERT INTO `config` VALUES ('2', 'picture2', 'http://localhost:8080/jsp8tvGs/upload/1588486661457.jpg'); INSERT INTO `config` VALUES ('3', 'picture3', null); INSERT INTO `config` VALUES ('4', 'picture4', null); INSERT INTO `config` VALUES ('5', 'picture5', null); INSERT INTO `config` VALUES ('6', 'homepage', null); -- ---------------------------- -- Table structure for `discussxuexiziliao` -- ---------------------------- DROP TABLE IF EXISTS `discussxuexiziliao`; CREATE TABLE `discussxuexiziliao` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `refid` bigint(20) NOT NULL COMMENT '关联表id', `content` varchar(200) NOT NULL COMMENT '评论内容', `userid` bigint(20) NOT NULL COMMENT '用户id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1588486812329 DEFAULT CHARSET=utf8 COMMENT='学习资料评论表'; -- ---------------------------- -- Records of discussxuexiziliao -- ---------------------------- INSERT INTO `discussxuexiziliao` VALUES ('1588486812328', '2020-05-03 14:20:11', '1588485679533', '12121212', '1588485256878'); -- ---------------------------- -- Table structure for `exampaper` -- ---------------------------- DROP TABLE IF EXISTS `exampaper`; CREATE TABLE `exampaper` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `name` varchar(200) NOT NULL COMMENT '试卷名称', `time` int(11) NOT NULL COMMENT '考试时长，秒', `status` int(11) NOT NULL DEFAULT '0' COMMENT '试卷状态，0：禁用 1：启用', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1588486120770 DEFAULT CHARSET=utf8 COMMENT='试卷表'; -- ---------------------------- -- Records of exampaper -- ---------------------------- INSERT INTO `exampaper` VALUES ('1588485399397', '2020-05-03 13:56:38', '英语', '3600', '1'); INSERT INTO `exampaper` VALUES ('1588485463446', '2020-05-03 13:57:43', '数学', '3600', '1'); INSERT INTO `exampaper` VALUES ('1588486120769', '2020-05-03 14:08:40', '语文', '3600', '1'); -- ---------------------------- -- Table structure for `examquestion` -- ---------------------------- DROP TABLE IF EXISTS `examquestion`; CREATE TABLE `examquestion` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `paperid` bigint(20) NOT NULL COMMENT '所属试卷id（外键）', `papername` varchar(200) NOT NULL COMMENT '试卷名称', `questionname` varchar(200) NOT NULL COMMENT '试题名称', `options` longtext COMMENT '选项，json字符串', `score` bigint(20) DEFAULT '0' COMMENT '分值', `answer` varchar(200) DEFAULT NULL COMMENT '正确答案', `analysis` longtext COMMENT '答案解析', `type` bigint(20) DEFAULT '0' COMMENT '试题类型，0：单选题 1：多选题 2：判断题 3：填空题（暂不考虑多项填空）', `sequence` bigint(20) DEFAULT '100' COMMENT '试题排序，值越大排越前面', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1588486148519 DEFAULT CHARSET=utf8 COMMENT='试题表'; -- ---------------------------- -- Records of examquestion -- ---------------------------- INSERT INTO `examquestion` VALUES ('1588485508180', '2020-05-03 13:58:27', '1588485463446', '数学', '1+1', '[{\"text\":\"1\",\"code\":\"A\"},{\"text\":\"2\",\"code\":\"B\"},{\"text\":\"3\",\"code\":\"C\"},{\"text\":\"4\",\"code\":\"D\"}]', '20', 'B', '1212', '0', '1'); INSERT INTO `examquestion` VALUES ('1588485541188', '2020-05-03 13:59:00', '1588485463446', '数学', '12122', '[{\"text\":\"1\",\"code\":\"A\"},{\"text\":\"1\",\"code\":\"B\"},{\"text\":\"1\",\"code\":\"C\"},{\"text\":\"1\",\"code\":\"D\"}]', '20', 'A', '1111', '0', '1'); INSERT INTO `examquestion` VALUES ('1588485571471', '2020-05-03 13:59:30', '1588485463446', '数学', '11212', '[{\"text\":\"1\",\"code\":\"A\"},{\"text\":\"1\",\"code\":\"B\"},{\"text\":\"1\",\"code\":\"C\"},{\"text\":\"1\",\"code\":\"D\"}]', '20', 'A,B', '1111', '1', '1'); INSERT INTO `examquestion` VALUES ('1588485589340', '2020-05-03 13:59:49', '1588485463446', '数学', '1211221', '[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]', '20', 'A', '1212121', '2', '1'); INSERT INTO `examquestion` VALUES ('1588486148518', '2020-05-03 14:09:07', '1588485463446', '数学', '121212', '[]', '20', '1', '122112', '3', '1'); -- ---------------------------- -- Table structure for `examrecord` -- ---------------------------- DROP TABLE IF EXISTS `examrecord`; CREATE TABLE `examrecord` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `userid` bigint(20) NOT NULL COMMENT '用户id', `paperid` bigint(20) NOT NULL COMMENT '试卷id（外键）', `papername` varchar(200) NOT NULL COMMENT '试卷名称', `questionid` bigint(20) NOT NULL COMMENT '试题id（外键）', `questionname` varchar(200) NOT NULL COMMENT '试题名称', `options` longtext COMMENT '选项，json字符串', `score` bigint(20) DEFAULT '0' COMMENT '分值', `answer` varchar(200) DEFAULT NULL COMMENT '正确答案', `analysis` longtext COMMENT '答案解析', `myscore` bigint(20) NOT NULL DEFAULT '0' COMMENT '试题得分', `myanswer` varchar(200) DEFAULT NULL COMMENT '考生答案', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1588486503979 DEFAULT CHARSET=utf8 COMMENT='考试记录表'; -- ---------------------------- -- Records of examrecord -- ---------------------------- INSERT INTO `examrecord` VALUES ('1588486374503', '2020-05-03 14:12:54', '1588485256878', '1588485463446', '数学', '1588485508180', '1+1', '[{\"text\":\"1\",\"code\":\"A\"},{\"text\":\"2\",\"code\":\"B\"},{\"text\":\"3\",\"code\":\"C\"},{\"text\":\"4\",\"code\":\"D\"}]', '20', 'B', '1212', '0', 'A'); INSERT INTO `examrecord` VALUES ('1588486381094', '2020-05-03 14:13:00', '1588485