Spring、SpringMVC、MyBatis在线考试系统

/* Navicat MySQL Data Transfer Source Server : 本地连接 Source Server Version : 50505 Source Host : localhost:3306 Source Database : db_online_ssm Target Server Type : MYSQL Target Server Version : 50505 File Encoding : 65001 Date: 2018-10-19 15:50:09 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `c3p0testtable` -- ---------------------------- DROP TABLE IF EXISTS `c3p0testtable`; CREATE TABLE `c3p0testtable` ( `a` char(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of c3p0testtable -- ---------------------------- -- ---------------------------- -- Table structure for `classinfo` -- ---------------------------- DROP TABLE IF EXISTS `classinfo`; CREATE TABLE `classinfo` ( `classId` int(11) NOT NULL AUTO_INCREMENT, `className` varchar(50) NOT NULL, `gradeId` int(11) NOT NULL, `teacherId` int(11) DEFAULT NULL, PRIMARY KEY (`classId`), KEY `teacherId` (`teacherId`), KEY `FK_Reference_1` (`gradeId`), CONSTRAINT `FK_Reference_1` FOREIGN KEY (`gradeId`) REFERENCES `gradeinfo` (`gradeId`), CONSTRAINT `classinfo_ibfk_1` FOREIGN KEY (`teacherId`) REFERENCES `teacherinfo` (`teacherId`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of classinfo -- ---------------------------- INSERT INTO `classinfo` VALUES ('1', '高一一班', '1', '2'); INSERT INTO `classinfo` VALUES ('2', '高一二班', '1', '1'); INSERT INTO `classinfo` VALUES ('3', '高一三班', '1', '3'); INSERT INTO `classinfo` VALUES ('4', '高一四班', '1', '4'); INSERT INTO `classinfo` VALUES ('5', '高一五班', '1', '5'); INSERT INTO `classinfo` VALUES ('6', '高一六班', '1', '6'); INSERT INTO `classinfo` VALUES ('7', '高二一班', '2', '7'); INSERT INTO `classinfo` VALUES ('8', '高二二班', '2', '8'); INSERT INTO `classinfo` VALUES ('9', '高二三班', '2', '9'); INSERT INTO `classinfo` VALUES ('10', '高二四班', '2', '10'); INSERT INTO `classinfo` VALUES ('11', '高二五班', '2', '11'); INSERT INTO `classinfo` VALUES ('12', '高二六班', '2', '12'); INSERT INTO `classinfo` VALUES ('13', '高三一班', '3', '13'); INSERT INTO `classinfo` VALUES ('14', '高三二班', '3', '14'); INSERT INTO `classinfo` VALUES ('15', '高三三班', '3', '15'); INSERT INTO `classinfo` VALUES ('16', '高三四班', '3', '16'); INSERT INTO `classinfo` VALUES ('17', '高三五班', '3', '17'); INSERT INTO `classinfo` VALUES ('18', '高三六班', '3', '18'); INSERT INTO `classinfo` VALUES ('19', '软件1501', '4', '21'); INSERT INTO `classinfo` VALUES ('20', '网络安全1501', '4', '22'); -- ---------------------------- -- Table structure for `courseinfo` -- ---------------------------- DROP TABLE IF EXISTS `courseinfo`; CREATE TABLE `courseinfo` ( `courseId` int(11) NOT NULL AUTO_INCREMENT, `courseName` varchar(50) NOT NULL, `division` int(11) DEFAULT '0', `gradeId` int(11) DEFAULT NULL, PRIMARY KEY (`courseId`), KEY `gradeId` (`gradeId`), CONSTRAINT `courseinfo_ibfk_1` FOREIGN KEY (`gradeId`) REFERENCES `gradeinfo` (`gradeId`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of courseinfo -- ---------------------------- INSERT INTO `courseinfo` VALUES ('1', '语文', '1', '3'); INSERT INTO `courseinfo` VALUES ('2', '数学', '0', '2'); INSERT INTO `courseinfo` VALUES ('3', '英语', '1', '1'); INSERT INTO `courseinfo` VALUES ('4', '常识题', '0', '1'); INSERT INTO `courseinfo` VALUES ('5', '理化类', '0', '1'); INSERT INTO `courseinfo` VALUES ('6', '天文类', '0', '1'); INSERT INTO `courseinfo` VALUES ('7', '文史类', '0', '1'); INSERT INTO `courseinfo` VALUES ('8', '文体类', '0', '1'); INSERT INTO `courseinfo` VALUES ('9', '计算机常识', '0', '4'); INSERT INTO `courseinfo` VALUES ('10', '网络安全', '2', '4'); -- ---------------------------- -- Table structure for `examchooseinfo` -- ---------------------------- DROP TABLE IF EXISTS `examchooseinfo`; CREATE TABLE `examchooseinfo` ( `chooseId` int(11) NOT NULL AUTO_INCREMENT, `studentId` int(11) NOT NULL, `examPaperId` int(11) NOT NULL, `subjectId` int(11) NOT NULL, `chooseResult` varchar(500) NOT NULL, PRIMARY KEY (`chooseId`), KEY `FK_Reference_11` (`studentId`), KEY `FK_Reference_12` (`examPaperId`), KEY `FK_Reference_13` (`subjectId`), CONSTRAINT `FK_Reference_11` FOREIGN KEY (`studentId`) REFERENCES `studentinfo` (`studentId`), CONSTRAINT `FK_Reference_12` FOREIGN KEY (`examPaperId`) REFERENCES `exampaperinfo` (`examPaperId`), CONSTRAINT `FK_Reference_13` FOREIGN KEY (`subjectId`) REFERENCES `subjectinfo` (`subjectId`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of examchooseinfo -- ---------------------------- INSERT INTO `examchooseinfo` VALUES ('17', '11', '8', '6545', '这是简答题呀！'); INSERT INTO `examchooseinfo` VALUES ('18', '11', '8', '6546', '帅的掉渣呀！'); INSERT INTO `examchooseinfo` VALUES ('19', '11', '8', '6508', 'D'); INSERT INTO `examchooseinfo` VALUES ('20', '11', '8', '6523', '多做项目'); INSERT INTO `examchooseinfo` VALUES ('21', '11', '8', '6541', 'C'); INSERT INTO `examchooseinfo` VALUES ('22', '11', '8', '6525', 'A,C'); INSERT INTO `examchooseinfo` VALUES ('23', '11', '8', '6544', 'B,D'); INSERT INTO `examchooseinfo` VALUES ('24', '11', '8', '6542', 'B'); INSERT INTO `examchooseinfo` VALUES ('25', '11', '8', '6543', 'A,B,D'); INSERT INTO `examchooseinfo` VALUES ('26', '11', '7', '6541', 'B'); INSERT INTO `examchooseinfo` VALUES ('27', '11', '7', '6542', 'C'); INSERT INTO `examchooseinfo` VALUES ('28', '11', '7', '6543', 'A,C,D'); INSERT INTO `examchooseinfo` VALUES ('29', '11', '7', '6544', 'A,B,D'); INSERT INTO `examchooseinfo` VALUES ('30', '11', '7', '6545', '简答题答案'); INSERT INTO `examchooseinfo` VALUES ('31', '11', '1', '10', 'C'); INSERT INTO `examchooseinfo` VALUES ('32', '17', '8', '6508', 'B'); INSERT INTO `examchooseinfo` VALUES ('33', '17', '8', '6523', '多做项目，作实战项目，跟着猿来入此站长做实战项目。'); INSERT INTO `examchooseinfo` VALUES ('34', '17', '8', '6525', 'A,B,C,D'); INSERT INTO `examchooseinfo` VALUES ('35', '17', '8', '6541', 'B'); INSERT INTO `examchooseinfo` VALUES ('36', '17', '8', '6542', 'C'); INSERT INTO `examchooseinfo` VALUES ('37', '17', '8', '6543', 'A,C'); INSERT INTO `examchooseinfo` VALUES ('38', '17', '8', '6544', 'A,C,D'); INSERT INTO `examchooseinfo` VALUES ('39', '17', '8', '6545', '简答题答案'); INSERT INTO `examchooseinfo` VALUES ('40', '17', '8', '6546', '帅得掉渣'); INSERT INTO `examchooseinfo` VALUES ('41', '17', '1', '10', 'C'); INSERT INTO `examchooseinfo` VALUES ('42', '18', '8', '6508', 'B'); INSERT INTO `examchooseinfo` VALUES ('43', '18', '8', '6523', '多做项目，作实战项目，跟着猿来入此站长做实战项目。'); INSERT INTO `examchooseinfo` VALUES ('44', '18', '8', '6525', 'A,B,C,D'); INSERT INTO `examchooseinfo` VALUES ('45', '18', '8', '6541', 'B'); INSERT INTO `examchooseinfo` VALUES ('46', '18', '8', '6542', 'C'); INSERT INTO `examchooseinfo` VALUES ('47', '18', '8', '6543', 'A,C'); INSERT INTO `examchooseinfo` VALUES ('48', '18', '8', '6544', 'A,C,D'); INSERT INTO `examchooseinfo` VALUES ('49', '18', '8', '6545', '简答题答案'); INSERT INTO `examchooseinfo` VALUES ('50', '18', '8', '6546', '帅得掉渣'); INSERT INTO `examchooseinfo` VALUES ('51', '18', '1', '10', 'C'); INSERT INTO `examchooseinfo` VALUES ('52', '1', '1', '10', 'C'); INSERT INTO `examchooseinfo` VALUES ('53', '11', '3', '3', 'C'); INSERT INTO `examchooseinfo` VALUES ('54', '11', '3', '4', 'C'); -- ---------------------------- -- Table structure for `examhistoryinfo` -- ----------------