SSM周测在线答题考试系统
项目描述
以前的老项目，SSM学生在线考试系统，内有文档，上课的时候，团队一块做的，那会技术不行，一个人刚不来，小团队集思广益，整的一个在线测试系统，有些页面不全，可以继续添加，可以当个毕业设计。
运行环境
myeclipse、eclipse、idea
项目技术(必填)
spring+spring mvc+mybatis+bootstrap+excel导出+jsp
数据库文件
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for db_answers
-- ----------------------------
DROP TABLE IF EXISTS `db_answers`;
CREATE TABLE `db_answers` (
`username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`questionid` int(11) DEFAULT NULL,
`stuanswer` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`judge` int(11) DEFAULT NULL,
`shijuanid` int(20) DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of db_answers
-- ----------------------------
INSERT INTO `db_answers` VALUES ('student1', 50, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 52, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 36, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 16, NULL, 0, 84);
INSERT INTO `db_answers` VALUES ('student1', 45, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 31, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 17, NULL, 0, 84);
INSERT INTO `db_answers` VALUES ('student1', 20, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 15, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 37, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 28, NULL, 0, 84);
INSERT INTO `db_answers` VALUES ('student1', 27, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 32, NULL, 0, 84);
INSERT INTO `db_answers` VALUES ('student1', 47, NULL, 0, 84);
INSERT INTO `db_answers` VALUES ('student1', 40, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 46, NULL, 0, 84);
INSERT INTO `db_answers` VALUES ('student1', 29, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 38, 'b', 1, 84);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 40, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 15, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 49, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 31, NULL, 0, 87);
INSERT INTO `db_answers` VALUES ('student1', 32, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 46, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 21, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 50, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 39, NULL, 0, 87);
INSERT INTO `db_answers` VALUES ('student1', 48, NULL, 0, 87);
INSERT INTO `db_answers` VALUES ('student1', 19, NULL, 0, 87);
INSERT INTO `db_answers` VALUES ('student1', 23, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 16, NULL, 0, 87);
INSERT INTO `db_answers` VALUES ('student1', 33, NULL, 0, 87);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 47, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 26, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 24, 'b', 1, 87);
INSERT INTO `db_answers` VALUES ('student1', 44, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 15, NULL, 0, 88);
INSERT INTO `db_answers` VALUES ('student1', 50, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 37, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 19, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 21, NULL, 0, 88);
INSERT INTO `db_answers` VALUES ('student1', 43, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 27, NULL, 0, 88);
INSERT INTO `db_answers` VALUES ('student1', 47, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 40, NULL, 0, 88);
INSERT INTO `db_answers` VALUES ('student1', 53, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 45, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 32, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 42, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 29, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 25, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 39, 'b', 1, 88);
INSERT INTO `db_answers` VALUES ('student1', 42, 'b', 1, 92);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 92);
INSERT INTO `db_answers` VALUES ('student1', 51, 'c', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 32, 'b', 1, 92);
INSERT INTO `db_answers` VALUES ('student1', 20, 'a', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 24, 'b', 1, 92);
INSERT INTO `db_answers` VALUES ('student1', 22, 'c', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 28, 'd', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 37, 'b', 1, 92);
INSERT INTO `db_answers` VALUES ('student1', 43, 'c', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 50, 'b', 1, 92);
INSERT INTO `db_answers` VALUES ('student1', 16, 'c', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 34, 'b', 1, 92);
INSERT INTO `db_answers` VALUES ('student1', 26, 'c', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 52, 'b', 1, 92);
INSERT INTO `db_answers` VALUES ('student1', 44, 'c', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 31, 'd', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 29, 'b', 1, 92);
INSERT INTO `db_answers` VALUES ('student1', 25, 'c', 0, 92);
INSERT INTO `db_answers` VALUES ('student1', 38, NULL, 0, 92);
INSERT INTO `db_answers` VALUES ('student3', 23, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 41, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 26, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 28, NULL, 0, 101);
INSERT INTO `db_answers` VALUES ('student3', 49, NULL, 0, 101);
INSERT INTO `db_answers` VALUES ('student3', 45, NULL, 0, 101);
INSERT INTO `db_answers` VALUES ('student3', 19, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 27, NULL, 0, 101);
INSERT INTO `db_answers` VALUES ('student3', 44, NULL, 0, 101);
INSERT INTO `db_answers` VALUES ('student3', 18, NULL, 0, 101);
INSERT INTO `db_answers` VALUES ('student3', 52, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 47, NULL, 0, 101);
INSERT INTO `db_answers` VALUES ('student3', 16, NULL, 0, 101);
INSERT INTO `db_answers` VALUES ('student3', 39, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 37, NULL, 0, 101);
INSERT INTO `db_answers` VALUES ('student3', 22, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 51, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 15, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 17, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 21, 'b', 1, 101);
INSERT INTO `db_answers` VALUES ('student3', 34, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 17, NULL, 0, 102);
INSERT INTO `db_answers` VALUES ('student3', 35, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 30, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 44, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 49, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 40, NULL, 0, 102);
INSERT INTO `db_answers` VALUES ('student3', 21, NULL, 0, 102);
INSERT INTO `db_answers` VALUES ('student3', 25, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 51, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 48, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 28, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 16, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 36, NULL, 0, 102);
INSERT INTO `db_answers` VALUES ('student3', 52, NULL, 0, 102);
INSERT INTO `db_answers` VALUES ('student3', 38, NULL, 0, 102);
INSERT INTO `db_answers` VALUES ('student3', 31, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 43, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 53, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('student3', 37, 'b', 1, 102);
INSERT INTO `db_answers` VALUES ('1', 20, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 44, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('1', 47, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 28, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 26, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 39, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 20, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 36, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 45, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('1', 33, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 32, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 42, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 19, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 49, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('1', 20, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 44, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('1', 47, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 28, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 26, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 39, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 20, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 36, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 45, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('1', 33, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 32, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 42, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 19, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 49, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('1', 20, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 44, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('1', 47, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 28, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 26, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 39, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 20, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 36, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 45, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('1', 33, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 32, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 42, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 19, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 49, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('1', 20, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 44, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('1', 47, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 28, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 26, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 39, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 20, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 36, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 45, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('1', 33, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 32, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 42, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 19, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 49, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('1', 20, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 44, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('1', 47, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 28, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 26, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 39, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 20, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 36, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 45, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('1', 33, 'b', 1, 104);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 32, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 42, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 19, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 49, NULL, 0, 105);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 105);
INSERT INTO `db_answers` VALUES ('student1', 37, 'c', 0, 114);
INSERT INTO `db_answers` VALUES ('student1', 25, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 42, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 19, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 46, 'c', 0, 114);
INSERT INTO `db_answers` VALUES ('student1', 44, 'c', 0, 114);
INSERT INTO `db_answers` VALUES ('student1', 24, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 36, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 38, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 27, 'c', 0, 114);
INSERT INTO `db_answers` VALUES ('student1', 39, 'c', 0, 114);
INSERT INTO `db_answers` VALUES ('student1', 47, 'c', 0, 114);
INSERT INTO `db_answers` VALUES ('student1', 53, 'c', 0, 114);
INSERT INTO `db_answers` VALUES ('student1', 50, 'c', 0, 114);
INSERT INTO `db_answers` VALUES ('student1', 31, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 51, NULL, 0, 114);
INSERT INTO `db_answers` VALUES ('student1', 20, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 21, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 49, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 114);
INSERT INTO `db_answers` VALUES ('student1', 18, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 19, NULL, 0, 120);
INSERT INTO `db_answers` VALUES ('student1', 44, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 26, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 39, NULL, 0, 120);
INSERT INTO `db_answers` VALUES ('student1', 34, NULL, 0, 120);
INSERT INTO `db_answers` VALUES ('student1', 20, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 42, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 32, NULL, 0, 120);
INSERT INTO `db_answers` VALUES ('student1', 40, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 53, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 48, NULL, 0, 120);
INSERT INTO `db_answers` VALUES ('student1', 31, NULL, 0, 120);
INSERT INTO `db_answers` VALUES ('student1', 23, NULL, 0, 120);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 43, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 52, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 33, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 16, 'b', 1, 120);
INSERT INTO `db_answers` VALUES ('student1', 37, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 41, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 38, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 20, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 52, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 16, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 19, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 27, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 33, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 39, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 36, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 47, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 40, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 29, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 18, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 15, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 21, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 37, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 41, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 38, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 20, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 52, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 16, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 19, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 27, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 33, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 39, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 36, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 47, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 40, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 29, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 18, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 15, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 21, 'b', 1, 121);
INSERT INTO `db_answers` VALUES ('student1', 26, 'a', 0, 122);
INSERT INTO `db_answers` VALUES ('student1', 52, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 41, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 33, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 15, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 21, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 34, NULL, 0, 122);
INSERT INTO `db_answers` VALUES ('student1', 43, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 32, 'a', 0, 122);
INSERT INTO `db_answers` VALUES ('student1', 46, 'a', 0, 122);
INSERT INTO `db_answers` VALUES ('student1', 47, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 53, NULL, 0, 122);
INSERT INTO `db_answers` VALUES ('student1', 18, NULL, 0, 122);
INSERT INTO `db_answers` VALUES ('student1', 19, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 27, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 37, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('student1', 51, 'b', 1, 122);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 37, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 39, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 50, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 44, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 24, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 53, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 25, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 18, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 33, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 51, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 19, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 17, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 23, 'a', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 34, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 16, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 52, 'b', 1, 123);
INSERT INTO `db_answers` VALUES ('x1', 49, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 20, 'c', 0, 123);
INSERT INTO `db_answers` VALUES ('x1', 46, 'd', 0, 123);
INSERT INTO `db_answers` VALUES ('student1', 45, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 47, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 21, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 20, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 53, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 29, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 16, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 50, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 27, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 24, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 31, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 33, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 19, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 43, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 23, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 45, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 47, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 21, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 20, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 22, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 30, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 53, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 29, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 16, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 50, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 27, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 24, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 31, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 33, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 19, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 43, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 23, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 35, 'b', 1, 144);
INSERT INTO `db_answers` VALUES ('student1', 49, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 33, NULL, 0, 145);
INSERT INTO `db_answers` VALUES ('student1', 27, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 51, NULL, 0, 145);
INSERT INTO `db_answers` VALUES ('student1', 23, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 46, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 20, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 41, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 53, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 17, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 37, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 40, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 32, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 45, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 52, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 44, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 39, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 21, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 48, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student1', 34, 'b', 1, 145);
INSERT INTO `db_answers` VALUES ('student2', 32, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 44, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 36, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 34, NULL, 0, 146);
INSERT INTO `db_answers` VALUES ('student2', 33, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 45, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 29, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 21, NULL, 0, 146);
INSERT INTO `db_answers` VALUES ('student2', 17, NULL, 0, 146);
INSERT INTO `db_answers` VALUES ('student2', 26, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 15, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 30, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 48, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 23, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 28, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 43, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 38, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 16, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 37, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 22, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 32, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 44, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 36, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 34, NULL, 0, 146);
INSERT INTO `db_answers` VALUES ('student2', 33, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 45, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 29, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 21, NULL, 0, 146);
INSERT INTO `db_answers` VALUES ('student2', 17, NULL, 0, 146);
INSERT INTO `db_answers` VALUES ('student2', 26, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 15, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 30, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 48, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 23, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 28, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 43, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 38, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 16, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 37, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('student2', 22, 'b', 1, 146);
INSERT INTO `db_answers` VALUES ('x1', 36, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 48, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 30, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 16, NULL, 0, 147);
INSERT INTO `db_answers` VALUES ('x1', 15, NULL, 0, 147);
INSERT INTO `db_answers` VALUES ('x1', 26, NULL, 0, 147);
INSERT INTO `db_answers` VALUES ('x1', 49, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 18, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 19, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 53, NULL, 0, 147);
INSERT INTO `db_answers` VALUES ('x1', 39, NULL, 0, 147);
INSERT INTO `db_answers` VALUES ('x1', 27, NULL, 0, 147);
INSERT INTO `db_answers` VALUES ('x1', 28, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 51, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 38, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 20, NULL, 0, 147);
INSERT INTO `db_answers` VALUES ('x1', 25, NULL, 0, 147);
INSERT INTO `db_answers` VALUES ('x1', 33, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 23, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('x1', 29, 'b', 1, 147);
INSERT INTO `db_answers` VALUES ('student3', 16, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 27, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 53, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 39, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 52, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 47, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 45, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 50, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 22, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 48, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 33, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 28, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 19, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 35, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 36, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 23, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 17, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 37, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 40, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 15, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 16, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 27, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 53, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 39, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 52, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 47, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 45, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 50, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 22, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 48, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 33, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 28, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 19, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 35, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 36, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 23, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 17, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 37, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 40, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 15, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 16, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 27, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 53, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 39, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 52, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 47, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 45, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 50, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 22, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 48, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 33, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 28, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 19, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 35, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 36, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 23, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 17, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 37, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('student3', 40, 'b', 1, 148);
INSERT INTO `db_answers` VALUES ('student3', 15, NULL, 0, 148);
INSERT INTO `db_answers` VALUES ('x1', 40, 'b', 1, 151);
INSERT INTO `db_answers` VALUES ('x1', 29, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 34, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 50, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 30, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 36, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 53, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 31, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 20, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 41, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 52, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 25, 'b', 1, 151);
INSERT INTO `db_answers` VALUES ('x1', 49, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 24, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 47, 'b', 1, 151);
INSERT INTO `db_answers` VALUES ('x1', 33, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 32, 'b', 1, 151);
INSERT INTO `db_answers` VALUES ('x1', 23, 'b', 1, 151);
INSERT INTO `db_answers` VALUES ('x1', 44, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x1', 18, NULL, 0, 151);
INSERT INTO `db_answers` VALUES ('x2', 35, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 51, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 47, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 22, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 49, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 36, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 37, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 40, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 18, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 48, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 26, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 21, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 32, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 42, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 31, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 20, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 52, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 30, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 25, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 15, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x3', 27, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 16, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 41, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 24, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 44, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 39, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 49, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 47, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 28, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 23, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 22, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 38, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 33, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 18, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 51, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 26, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 43, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 46, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 2, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 48, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 27, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 16, NULL, 0, 150);
INSERT INTO `db_answers` VALUES ('x3', 41, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 24, NULL, 0, 150);
INSERT INTO `db_answers` VALUES ('x3', 44, NULL, 0, 150);
INSERT INTO `db_answers` VALUES ('x3', 39, 'c', 0, 150);
INSERT INTO `db_answers` VALUES ('x3', 49, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 47, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 28, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 23, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 22, NULL, 0, 150);
INSERT INTO `db_answers` VALUES ('x3', 38, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 33, NULL, 0, 150);
INSERT INTO `db_answers` VALUES ('x3', 18, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 51, NULL, 0, 150);
INSERT INTO `db_answers` VALUES ('x3', 26, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 43, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 46, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 2, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x3', 48, 'b', 1, 150);
INSERT INTO `db_answers` VALUES ('x2', 35, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 51, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 47, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 22, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 49, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 36, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 37, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 40, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 18, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 48, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 26, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 21, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 32, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 42, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 31, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 20, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 52, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 30, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 25, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x2', 15, 'a', 0, 149);
INSERT INTO `db_answers` VALUES ('x4', 38, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 26, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 35, 'a', 0, 152);
INSERT INTO `db_answers` VALUES ('x4', 40, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 29, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 15, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 51, 'a', 0, 152);
INSERT INTO `db_answers` VALUES ('x4', 16, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 27, 'a', 0, 152);
INSERT INTO `db_answers` VALUES ('x4', 39, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 53, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 46, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 36, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 41, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 19, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 21, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 47, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 34, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 17, 'b', 1, 152);
INSERT INTO `db_answers` VALUES ('x4', 44, 'b', 1, 152);
-- ----------------------------
-- Table structure for db_question
-- ----------------------------
DROP TABLE IF EXISTS `db_question`;
CREATE TABLE `db_question` (
`questionid` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`ansA` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`ansB` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`ansC` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`ansD` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`trueans` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`subjectid` int(20) NOT NULL,
`knowledge` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`questionid`) USING BTREE,
INDEX `FK_db_question`(`subjectid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of db_question
-- ----------------------------
INSERT INTO `db_question` VALUES (2, '1+1=?', '1', '2', '3', '4', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (3, '1+2=?', '2', '3', '4', '5', 'b', 1, 'java知识点3');
INSERT INTO `db_question` VALUES (4, '1+3=?', '3', '4', '5', '6', 'b', 1, 'java知识点4');
INSERT INTO `db_question` VALUES (5, '1+4=?', '4', '5', '6', '7', 'b', 2, '大数据知识点1');
INSERT INTO `db_question` VALUES (6, '1+5=?', '5', '6', '7', '8', 'b', 2, '大数据知识点2');
INSERT INTO `db_question` VALUES (7, '1+6=?', '6', '7', '8', '9', 'b', 2, '大数据知识点3');
INSERT INTO `db_question` VALUES (8, '1+7=?', '7', '8', '9', '10', 'b', 3, 'UI知识点1');
INSERT INTO `db_question` VALUES (9, '1+8=?', '8', '9', '10', '11', 'b', 3, 'UI知识点2');
INSERT INTO `db_question` VALUES (10, '1+9=?', '9', '10', '11', '12', 'b', 4, '嵌入式知识点1');
INSERT INTO `db_question` VALUES (11, '1+10=?', '10', '11', '12', '13', 'b', 5, 'PHP知识点1');
INSERT INTO `db_question` VALUES (12, '1+11=?', '11', '12', '13', '14', 'b', 6, 'web前端知识点1');
INSERT INTO `db_question` VALUES (13, '1+12=?', '12', '13', '14', '15', 'b', 1, 'cookies');
INSERT INTO `db_question` VALUES (14, '1+13=?', '13', '14', '15', '16', 'b', 1, 'cookies');
INSERT INTO `db_question` VALUES (15, '1+14=?', '14', '15', '16', '17', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (16, '1+15=?', '15', '16', '17', '18', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (17, '1+16=?', '16', '17', '18', '19', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (18, '1+17=?', '17', '18', '19', '20', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (19, '1+18=?', '18', '19', '20', '21', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (20, '1+19=?', '19', '20', '21', '22', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (21, '1+20=?', '20', '21', '22', '23', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (22, '1+21=?', '21', '22', '23', '24', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (23, '1+22=?', '22', '23', '24', '25', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (24, '1+23=?', '23', '24', '25', '26', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (25, '1+24=?', '24', '25', '26', '27', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (26, '1+25=?', '25', '26', '27', '28', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (27, '1+26=?', '26', '27', '28', '29', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (28, '1+27=?', '27', '28', '29', '30', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (29, '1+28=?', '28', '29', '30', '31', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (30, '1+29=?', '29', '30', '31', '32', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (31, '1+30=?', '30', '31', '32', '33', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (32, '1+31=?', '31', '32', '33', '34', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (33, '1+32=?', '32', '33', '34', '35', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (34, '1+33=?', '33', '34', '35', '36', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (35, '1+34=?', '34', '35', '36', '37', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (36, '1+35=?', '35', '36', '37', '38', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (37, '1+36=?', '36', '37', '38', '39', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (38, '1+37=?', '37', '38', '39', '40', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (39, '1+38=?', '38', '39', '40', '41', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (40, '1+39=?', '39', '40', '41', '42', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (41, '1+40=?', '40', '41', '42', '43', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (42, '1+41=?', '41', '42', '43', '44', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (43, '1+42=?', '42', '43', '44', '45', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (44, '1+43=?', '43', '44', '45', '46', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (45, '1+44=?', '44', '45', '46', '47', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (46, '1+45=?', '45', '46', '47', '48', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (47, '1+46=?', '46', '47', '48', '49', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (48, '1+47=?', '47', '48', '49', '50', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (49, '1+48=?', '48', '49', '50', '51', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (50, '1+49=?', '49', '50', '51', '52', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (51, '1+50=?', '50', '51', '52', '53', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (52, '1+51=?', '51', '52', '53', '54', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (53, '1+52=?', '52', '53', '54', '55', 'b', 1, 'java知识点2');
INSERT INTO `db_question` VALUES (54, '300-100=?', '122', '123', '200', '221', 'C', 1, 'java5');
INSERT INTO `db_question` VALUES (57, 'aaa', '1', '1', '1', '1', '1', 1, '1111');
INSERT INTO `db_question` VALUES (58, '323', '343', '4523', '453', '123', '312', 2, '3245153');
INSERT INTO `db_question` VALUES (59, '24', '245', '425', '42', '4525', '425', 6, '425');
-- ----------------------------
-- Table structure for db_shijuan
-- ----------------------------
DROP TABLE IF EXISTS `db_shijuan`;
CREATE TABLE `db_shijuan` (
`shijuanid` int(20) NOT NULL AUTO_INCREMENT,
`username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`grade` int(10) DEFAULT NULL,
PRIMARY KEY (`shijuanid`, `username`, `date`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 154 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of db_shijuan
-- ----------------------------
INSERT INTO `db_shijuan` VALUES (84, 'student1', '2017-09-06 15:48:20', 14);
INSERT INTO `db_shijuan` VALUES (90, 'student1', '2017-09-06 19:10:40', NULL);
INSERT INTO `db_shijuan` VALUES (89, 'student1', '2017-09-06 19:10:22', NULL);
INSERT INTO `db_shijuan` VALUES (87, 'student1', '2017-09-06 16:09:30', 14);
INSERT INTO `db_shijuan` VALUES (88, 'student1', '2017-09-06 16:18:38', 16);
INSERT INTO `db_shijuan` VALUES (91, 'student1', '2017-09-06 19:11:04', NULL);
INSERT INTO `db_shijuan` VALUES (92, 'student1', '2017-09-06 19:11:33', 9);
INSERT INTO `db_shijuan` VALUES (93, 'student3', '2017-09-08 08:50:40', NULL);
INSERT INTO `db_shijuan` VALUES (94, '1', '2017-09-08 08:52:52', NULL);
INSERT INTO `db_shijuan` VALUES (95, 'student3', '2017-09-08 08:59:10', NULL);
INSERT INTO `db_shijuan` VALUES (96, 'student4', '2017-09-08 09:02:14', NULL);
INSERT INTO `db_shijuan` VALUES (97, 'student1', '2017-09-08 09:02:18', NULL);
INSERT INTO `db_shijuan` VALUES (98, 'student1', '2017-09-08 09:04:30', NULL);
INSERT INTO `db_shijuan` VALUES (99, 'student3', '2017-09-08 09:07:23', NULL);
INSERT INTO `db_shijuan` VALUES (100, 'student2', '2017-09-08 09:08:04', NULL);
INSERT INTO `db_shijuan` VALUES (101, 'student3', '2017-09-08 09:08:12', 11);
INSERT INTO `db_shijuan` VALUES (102, 'student3', '2017-09-08 19:34:23', 14);
INSERT INTO `db_shijuan` VALUES (107, 'student3', '2017-09-13 16:47:27', 54);
INSERT INTO `db_shijuan` VALUES (104, '1', '2017-09-13 16:43:32', 44);
INSERT INTO `db_shijuan` VALUES (105, 'student1', '2017-09-13 16:43:34', 44);
INSERT INTO `db_shijuan` VALUES (106, 'student5', '2017-09-13 16:44:06', 44);
INSERT INTO `db_shijuan` VALUES (108, 'STUDENT3', '2017-09-13 19:27:27', NULL);
INSERT INTO `db_shijuan` VALUES (109, 'STUDENT3', '2017-09-13 19:27:29', NULL);
INSERT INTO `db_shijuan` VALUES (110, 'student1', '2017-09-13 19:27:31', NULL);
INSERT INTO `db_shijuan` VALUES (111, 'STUDENT1', '2017-09-13 19:30:17', NULL);
INSERT INTO `db_shijuan` VALUES (112, 'STUDENT2', '2017-09-13 19:30:19', NULL);
INSERT INTO `db_shijuan` VALUES (113, 'STUDENT1', '2017-09-13 19:53:01', NULL);
INSERT INTO `db_shijuan` VALUES (114, 'student1', '2017-09-13 19:54:03', 11);
INSERT INTO `db_shijuan` VALUES (115, 'student2', '2017-09-13 19:55:43', NULL);
INSERT INTO `db_shijuan` VALUES (116, 'student1', '2017-09-13 19:55:45', NULL);
INSERT INTO `db_shijuan` VALUES (117, 'student1', '2017-09-13 20:20:21', NULL);
INSERT INTO `db_shijuan` VALUES (118, 'student2', '2017-09-13 20:26:25', NULL);
INSERT INTO `db_shijuan` VALUES (119, 'student1', '2017-09-13 20:26:28', NULL);
INSERT INTO `db_shijuan` VALUES (120, 'student1', '2017-09-14 09:19:16', 13);
INSERT INTO `db_shijuan` VALUES (121, 'student1', '2017-09-14 09:27:30', 31);
INSERT INTO `db_shijuan` VALUES (122, 'student1', '2017-09-14 10:00:02', 14);
INSERT INTO `db_shijuan` VALUES (123, 'x1', '2017-09-14 10:21:55', 7);
INSERT INTO `db_shijuan` VALUES (124, 'x8', '2017-09-14 10:23:30', 26);
INSERT INTO `db_shijuan` VALUES (125, 'x1', '2017-09-14 10:24:13', NULL);
INSERT INTO `db_shijuan` VALUES (126, 'x1', '2017-09-14 10:24:14', NULL);
INSERT INTO `db_shijuan` VALUES (127, 'x12', '2017-09-14 10:25:04', NULL);
INSERT INTO `db_shijuan` VALUES (128, '1', '2017-09-14 10:25:33', 47);
INSERT INTO `db_shijuan` VALUES (129, 'x12', '2017-09-14 10:28:31', 47);
INSERT INTO `db_shijuan` VALUES (130, 'x12', '2017-09-14 10:31:14', 47);
INSERT INTO `db_shijuan` VALUES (131, 'x4', '2017-09-14 10:32:40', 47);
INSERT INTO `db_shijuan` VALUES (132, 'x4', '2017-09-14 10:33:09', 60);
INSERT INTO `db_shijuan` VALUES (133, 'x1', '2017-09-14 10:36:16', NULL);
INSERT INTO `db_shijuan` VALUES (134, 'x1', '2017-09-14 10:36:21', NULL);
INSERT INTO `db_shijuan` VALUES (135, 'x12', '2017-09-14 10:36:23', 86);
INSERT INTO `db_shijuan` VALUES (136, 'x1', '2017-09-14 10:36:34', NULL);
INSERT INTO `db_shijuan` VALUES (137, 'x1', '2017-09-14 10:36:35', NULL);
INSERT INTO `db_shijuan` VALUES (138, 'x1', '2017-09-14 10:36:39', NULL);
INSERT INTO `db_shijuan` VALUES (139, 'x1', '2017-09-14 10:36:40', NULL);
INSERT INTO `db_shijuan` VALUES (140, 'x1', '2017-09-14 10:36:45', NULL);
INSERT INTO `db_shijuan` VALUES (141, 'x1', '2017-09-14 10:36:57', NULL);
INSERT INTO `db_shijuan` VALUES (142, 'x1', '2017-09-14 10:36:59', NULL);
INSERT INTO `db_shijuan` VALUES (143, 'x1', '2017-09-14 10:37:04', 87);
INSERT INTO `db_shijuan` VALUES (144, 'student1', '2017-09-15 09:18:27', 38);
INSERT INTO `db_shijuan` VALUES (145, 'student1', '2017-09-15 09:56:05', 18);
INSERT INTO `db_shijuan` VALUES (146, 'student2', '2017-09-15 10:05:18', 18);
INSERT INTO `db_shijuan` VALUES (147, 'x1', '2017-09-15 10:20:54', 12);
INSERT INTO `db_shijuan` VALUES (148, 'student3', '2017-09-18 09:06:18', 10);
INSERT INTO `db_shijuan` VALUES (149, 'x2', '2017-09-18 10:32:51', 0);
INSERT INTO `db_shijuan` VALUES (150, 'x3', '2017-09-18 10:32:51', 13);
INSERT INTO `db_shijuan` VALUES (151, 'x1', '2017-09-18 10:32:51', 5);
INSERT INTO `db_shijuan` VALUES (152, 'x4', '2017-09-18 10:36:10', 17);
INSERT INTO `db_shijuan` VALUES (153, 'student1', '2019-10-29 23:43:44', NULL);
-- ----------------------------
-- Table structure for db_subject
-- ----------------------------
DROP TABLE IF EXISTS `db_subject`;
CREATE TABLE `db_subject` (
`subjectid` int(11) NOT NULL AUTO_INCREMENT,
`subjecttype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`subjectid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of db_subject
-- ----------------------------
INSERT INTO `db_subject` VALUES (1, 'JAVA');
INSERT INTO `db_subject` VALUES (2, '大数据');
INSERT INTO `db_subject` VALUES (3, 'UI');
INSERT INTO `db_subject` VALUES (4, '嵌入式');
INSERT INTO `db_subject` VALUES (5, 'PHP');
INSERT INTO `db_subject` VALUES (6, 'web前端');
INSERT INTO `db_subject` VALUES (7, '最代码代码学习');
-- ----------------------------
-- Table structure for db_users
-- ----------------------------
DROP TABLE IF EXISTS `db_users`;
CREATE TABLE `db_users` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`userpwd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`subjectid` int(11) DEFAULT NULL,
`usertype` int(11) DEFAULT NULL,
PRIMARY KEY (`userid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of db_users
-- ----------------------------
INSERT INTO `db_users` VALUES (1, '李老师', 'Aa111111', 1, 1);
INSERT INTO `db_users` VALUES (2, '王老师', 'Aa111111', 2, 1);
INSERT INTO `db_users` VALUES (3, 'teacher', 'Aa111111', 3, 1);
INSERT INTO `db_users` VALUES (4, 'student1', '123456', 1, 2);
INSERT INTO `db_users` VALUES (5, 'student2', '123456', 2, 2);
INSERT INTO `db_users` VALUES (6, 'student3', '123456', 2, 2);
INSERT INTO `db_users` VALUES (7, 'student4', '123456', 1, 2);
INSERT INTO `db_users` VALUES (8, 'student5', '123456', 3, 2);
INSERT INTO `db_users` VALUES (9, 'admin', '000000', NULL, 0);
INSERT INTO `db_users` VALUES (10, '123', '123', 1, 1);
INSERT INTO `db_users` VALUES (11, '1', '1', 1, 2);
INSERT INTO `db_users` VALUES (12, '2', '2', 2, 2);
INSERT INTO `db_users` VALUES (13, 'Dawn', '000000', 1, 1);
INSERT INTO `db_users` VALUES (14, 'student6', '123456', 3, 2);
INSERT INTO `db_users` VALUES (15, 'x1', '123456', 1, 2);
INSERT INTO `db_users` VALUES (16, 'x2', '123456', 1, 2);
INSERT INTO `db_users` VALUES (17, 'x3', '123456', 1, 2);
INSERT INTO `db_users` VALUES (18, 'x4', '123456', 1, 2);
INSERT INTO `db_users` VALUES (19, 'x5', '123456', 1, 2);
INSERT INTO `db_users` VALUES (20, 'x6', '123456', 1, 2);
INSERT INTO `db_users` VALUES (21, 'x7', '123456', 1, 2);
INSERT INTO `db_users` VALUES (22, 'x8', '123456', 1, 2);
INSERT INTO `db_users` VALUES (23, 'x9', '123456', 1, 2);
INSERT INTO `db_users` VALUES (24, 'x10', '123456', 1, 2);
INSERT INTO `db_users` VALUES (25, 'x11', '123456', 1, 2);
INSERT INTO `db_users` VALUES (26, 'x12', '123456', 1, 2);
INSERT INTO `db_users` VALUES (27, 'zuidaima', '111111', 1, 1);
INSERT INTO `db_users` VALUES (28, '111', '111111', 1, 2);
SET FOREIGN_KEY_CHECKS = 1;
下载地址
链接：https://pan.baidu.com/s/1Gp_Pl1RovxI8Voba_m15Ug
提取码：z7qw
复制这段内容后打开百度网盘手机App，操作更方便哦
475
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
