数据库原理实验评判系统

使用Springboot和vue开发
其中前端资源已经打包在/src/resources/static内
数据源使用h2数据库
第一次启动的时候默认初始化数据库,数据库文件保存再本地中
jdk版本：jdk8

data:2023/1/11

首页

管理员页面

用户管理

题目管理

试卷管理

成绩报表

普通用户

练习中心

我的成绩

初始表

CREATE TABLE `link_question_group`
(
    `id`                bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `create_time`       datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time`       datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `question_group_id` bigint unsigned NOT NULL COMMENT '试题组ID',
    `question_id`       bigint unsigned NOT NULL COMMENT '试题ID',
    PRIMARY KEY (`id`)
) COMMENT '关联试题';

----------------------
CREATE TABLE `question`
(
    `id`             bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `create_time`    datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time`    datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `question_title` varchar(128) NOT NULL COMMENT '题目标题',
    `content`        varchar(512) NULL COMMENT '题目描述',
    `init_table_sql` text         NOT NULL COMMENT '初始化表结构',
    `init_data_sql`  text         NOT NULL COMMENT '初始化数据',
    `answer_sql`     text         NOT NULL COMMENT '答案',
    `score`          int          NOT NULL COMMENT '得分',
    `info`           json NULL COMMENT '其他信息',
    PRIMARY KEY (`id`)
) COMMENT '题目';

----------------------
CREATE TABLE `question_group`
(
    `id`                   bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `create_time`          datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time`          datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `question_group_title` varchar(128) NOT NULL COMMENT '题目组标题',
    PRIMARY KEY (`id`)
) COMMENT '题目组';

----------------------
CREATE TABLE `setting`
(
    `id`          bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `create_time` datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `key`         varchar(32)  NOT NULL COMMENT 'KEY',
    `value`       varchar(512) NOT NULL COMMENT 'VALUE',
    PRIMARY KEY (`id`)
) COMMENT '基本配置';

----------------------
CREATE TABLE `user`
(
    `id`          bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `create_time` datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `username`    varchar(128) NOT NULL COMMENT '用户名',
    `password`    varchar(128) NOT NULL COMMENT '密码',
    `role_code`   varchar(32) NULL COMMENT '角色',
    `info`        json NULL COMMENT '其他信息',
    PRIMARY KEY (`id`)
) COMMENT '用户表';

----------------------
CREATE TABLE `user_result`
(
    `id`                bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `create_time`       datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time`       datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `user_id`           bigint unsigned NOT NULL COMMENT '用户ID',
    `question_group_id` bigint unsigned NOT NULL COMMENT '试题组ID',
    `question_id`       bigint unsigned NOT NULL COMMENT '试题ID',
    `score`             int      NOT NULL COMMENT '得分',
    `answer`            varchar(512) NULL COMMENT '答案',
    `start_time`        datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始时间',
    `end_time`          datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '结束时间',
    `info`              json NULL COMMENT '其他信息',
    PRIMARY KEY (`id`)
) COMMENT '用户结果';

插入数据1

INSERT INTO `link_question_group`
VALUES (14, '2021-02-09 14:12:55', '2021-02-09 14:12:55', 4, 5),
       (15, '2021-02-09 14:12:55', '2021-02-09 14:12:55', 4, 3),
       (19, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 6),
       (20, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 1),
       (21, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 2),
       (22, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 5),
       (23, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 4),
       (24, '2021-02-11 18:54:48', '2021-02-11 18:54:48', 5, 2);
----------------------
INSERT INTO `question`
VALUES (1, '2021-02-09 11:16:43', '2021-02-09 11:16:43', '获取学生总成绩',
        '根据以下表结构，请输入SQL语句来获取全班同学的总成绩',
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIFNVTShzY29yZSkgRlJPTSB0ZW1wX3N0dWRlbnRfcmVzdWx0IA==', 10, NULL),
       (2, '2021-02-09 11:39:46', '2021-02-09 11:39:46', '获取学生平均分', '获取学生平均分',
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIEFWRyhzY29yZSkgRlJPTSB0ZW1wX3N0dWRlbnRfcmVzdWx0', 10, NULL),
       (3, '2021-02-09 11:39:46', '2021-02-09 11:39:46', '获取学生最高分', NULL,
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIE1BWChzY29yZSkgRlJPTSB0ZW1wX3N0dWRlbnRfcmVzdWx0', 10, NULL),
       (4, '2021-02-09 11:39:46', '2021-02-09 11:39:46', '获取学生最低分', NULL,
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIE1JTihzY29yZSkgRlJPTSB0ZW1wX3N0dWRlbnRfcmVzdWx0', 10, NULL),
       (5, '2021-02-09 11:39:46', '2021-02-09 11:39:46', '获取学生人数', '<b>别名为 student_num</b>',
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIENPVU5UKCopIGFzIHN0dWRlbnRfbnVtIEZST00gdGVtcF9zdHVkZW50X3Jlc3VsdA==', 10, NULL),
       (6, '2021-02-10 14:31:33', '2021-02-10 14:31:33', '获取班级内的学生',
        '根据以下表结构，关联teacher表与student表，获取张老师的所有学生学号和姓名<div style=\"text-align: right;\"><b>提示: 根据teacher_id进行关联，并且需要的是学生的学号和姓名哦！</b></div>',
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3RlYWNoZXJgICAoCiAgYGlkYCBiaWdpbnQgdW5zaWduZWQgIE5PVCBOVUxMIEFVVE9fSU5DUkVNRU5UIENPTU1FTlQgJ0lEJywKICBgdGVhY2hlcl9uYW1lYCB2YXJjaGFyKDMyKSAgTk9UIE5VTEwgQ09NTUVOVCAn6ICB5biI5ZCN56ewJywKICBgdGVhY2hlcl90eXBlYCB2YXJjaGFyKDMyKSAgTk9UIE5VTEwgQ09NTUVOVCAn5o6I6K++57G75Z6LJywKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICfmlZnluIgnOwoKQ1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRgICAoCiAgYGlkYCBiaWdpbnQgdW5zaWduZWQgIE5PVCBOVUxMIEFVVE9fSU5DUkVNRU5UIENPTU1FTlQgJ0lEJywKICBgc3R1ZGVudF9ub2AgdmFyY2hhcigzMikgIE5PVCBOVUxMIENPTU1FTlQgJ+WtpuWPtycsCiAgYHN0dWRlbnRfbmFtZWAgdmFyY2hhcigzMikgIE5PVCBOVUxMIENPTU1FTlQgJ+WtpueUn+Wnk+WQjScsCiAgYHRlYWNoZXJfaWRgIGJpZ2ludCB1bnNpZ25lZCAgTk9UIE5VTEwgQ09NTUVOVCAn5pWZ5biISUQnLAogIFBSSU1BUlkgS0VZIChgaWRgKQopIENPTU1FTlQgJ+WtpueUn+ihqCc7Cg==',
        'SU5TRVJUIElOVE8gYHRlbXBfdGVhY2hlcmAoYGlkYCwgYHRlYWNoZXJfbmFtZWAsIGB0ZWFjaGVyX3R5cGVgKSBWQUxVRVMgKDEsICflvKDogIHluIgnLCAn5pWw5a2mJyk7CklOU0VSVCBJTlRPIGB0ZW1wX3RlYWNoZXJgKGBpZGAsIGB0ZWFjaGVyX25hbWVgLCBgdGVhY2hlcl90eXBlYCkgVkFMVUVTICgyLCAn546L6ICB5biIJywgJ+ivreaWhycpOwpJTlNFUlQgSU5UTyBgdGVtcF90ZWFjaGVyYChgaWRgLCBgdGVhY2hlcl9uYW1lYCwgYHRlYWNoZXJfdHlwZWApIFZBTFVFUyAoMywgJ+adjuiAgeW4iCcsICfoi7Hor60nKTsKCklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHN0dWRlbnRfbmFtZWAsIGB0ZWFjaGVyX2lkYCkgVkFMVUVTICgxLCAnMTAwMDEnLCAn5bCPQScsIDEpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzdHVkZW50X25hbWVgLCBgdGVhY2hlcl9pZGApIFZBTFVFUyAoMiwgJzEwMDAxJywgJ+Wwj0EnLCAzKTsKSU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc3R1ZGVudF9uYW1lYCwgYHRlYWNoZXJfaWRgKSBWQUxVRVMgKDMsICcxMDAwMScsICflsI9CJywgMSk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHN0dWRlbnRfbmFtZWAsIGB0ZWFjaGVyX2lkYCkgVkFMVUVTICg0LCAnMTAwMDEnLCAn5bCPQycsIDEpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzdHVkZW50X25hbWVgLCBgdGVhY2hlcl9pZGApIFZBTFVFUyAoNSwgJzEwMDAxJywgJ+Wwj0QnLCAxKTsKSU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc3R1ZGVudF9uYW1lYCwgYHRlYWNoZXJfaWRgKSBWQUxVRVMgKDYsICcxMDAwMScsICflsI9FJywgMSk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHN0dWRlbnRfbmFtZWAsIGB0ZWFjaGVyX2lkYCkgVkFMVUVTICg3LCAnMTAwMDEnLCAn5bCPQScsIDIpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzdHVkZW50X25hbWVgLCBgdGVhY2hlcl9pZGApIFZBTFVFUyAoOCwgJzEwMDAxJywgJ+Wwj0InLCAyKTsKSU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc3R1ZGVudF9uYW1lYCwgYHRlYWNoZXJfaWRgKSBWQUxVRVMgKDksICcxMDAwMScsICflsI9DJywgMyk7',
        'U0VMRUNUIHN0dWRlbnRfbm8sc3R1ZGVudF9uYW1lIEZST00gdGVtcF9zdHVkZW50IHMKTEVGVCBKT0lOIHRlbXBfdGVhY2hlciB0IE9OIHMudGVhY2hlcl9pZCA9IHQuaWQKV0hFUkUgdC50ZWFjaGVyX25hbWUgPSAn5byg6ICB5biIJw==',
        20, NULL);
----------------------
INSERT INTO `question_group`
VALUES (3, '2021-02-09 14:06:29', '2021-02-09 14:06:29', '单元测试1'),
       (4, '2021-02-09 14:12:55', '2021-02-09 14:12:55', '单元测试2'),
       (5, '2021-02-11 18:54:48', '2021-02-11 18:54:48', '期末考试');
----------------------
INSERT INTO `user`
VALUES (1, '2020-10-15 10:49:16', '2020-10-15 14:11:09', 'zhangbowen', 'zhangbowen', 'COMMON', NULL),
       (2, '2020-10-15 10:49:16', '2020-10-15 14:11:32', 'admin', 'admin', 'ADMIN', NULL),
       (3, '2020-10-15 14:10:30', '2020-10-15 14:10:30', '小王', '3', 'ADMIN', NULL),
       (4, '2020-10-15 14:12:22', '2020-10-15 14:12:22', 'tuzhuangzhuang', 'tuzhuangzhuang', 'ADMIN', NULL),
       (5, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '繁春柔', '123456', 'COMMON', NULL),
       (6, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '全含芙', '123456', 'COMMON', NULL),
       (7, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '宓绿凝', '123456', 'COMMON', NULL),
       (8, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '本傲冬', '123456', 'COMMON', NULL),
       (9, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '闾妙菡123', '123456', 'COMMON', NULL),
       (10, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '咸灵珊', '123456', 'COMMON', NULL),
       (11, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '段干润', '123456', 'COMMON', NULL),
       (16, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '蔺宏峻', '123456', 'COMMON', NULL),
       (17, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '令狐映寒', '123456', 'COMMON', NULL),
       (18, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '颜安萱', '123456', 'COMMON', NULL),
       (19, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '佟秋芸', '123456', 'COMMON', NULL),
       (20, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '茆寒云', '123456', 'COMMON', NULL),
       (21, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '理柏', '123456', 'COMMON', NULL),
       (22, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '钮利', '123456', 'COMMON', NULL),
       (23, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '庞友灵', '123456', 'COMMON', NULL),
       (24, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '岑吉月', '123456', 'COMMON', NULL),
       (25, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '缪茉莉', '123456', 'COMMON', NULL),
       (26, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '乙伟晔', '123456', 'COMMON', NULL),
       (27, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '宣宛妙', '123456', 'COMMON', NULL),
       (28, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '鲜嘉珍', '123456', 'COMMON', NULL),
       (29, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '衅晴丽', '123456', 'COMMON', NULL),
       (30, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '米雪', '123456', 'COMMON', NULL),
       (31, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '甲浩波', '123456', 'COMMON', NULL),
       (32, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '景维', '123456', 'COMMON', NULL),
       (33, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '衷蔓菁', '123456', 'COMMON', NULL),
       (34, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '斛亦', '123456', 'COMMON', NULL),
       (35, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '荤俊爽', '123456', 'COMMON', NULL),
       (36, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '乘凝雁', '123456', 'COMMON', NULL),
       (37, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '杜慧晨', '123456', 'COMMON', NULL),
       (38, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '柳轶', '123456', 'COMMON', NULL),
       (39, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '阮冬萱', '123456', 'COMMON', NULL),
       (40, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '施天蓉', '123456', 'COMMON', NULL),
       (41, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '俟浩穰', '123456', 'COMMON', NULL),
       (42, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '郑星海', '123456', 'COMMON', NULL),
       (43, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '邰萍韵', '123456', 'COMMON', NULL),
       (44, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '浦元槐', '123456', 'COMMON', NULL),
       (45, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '郸莺韵', '123456', 'COMMON', NULL),
       (46, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '邬秀媛', '123456', 'COMMON', NULL),
       (47, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '暨馨蓉', '123456', 'COMMON', NULL),
       (48, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '宛忆灵', '123456', 'COMMON', NULL),
       (49, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '首贞静', '123456', 'COMMON', NULL),
       (50, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '郯嘉淑', '123456', 'COMMON', NULL),
       (51, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '兴听南', '123456', 'COMMON', NULL),
       (52, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '费莫鸿博', '123456', 'COMMON', NULL),
       (53, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '箕瑞云', '123456', 'COMMON', NULL),
       (54, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '悟光远', '123456', 'COMMON', NULL),
       (55, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '仙凝蝶', '123456', 'COMMON', NULL),
       (56, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '盖智菱', '123456', 'COMMON', NULL),
       (57, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '及梦泽', '123456', 'COMMON', NULL),
       (58, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '禽乐安', '123456', 'COMMON', NULL),
       (59, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '成嘉纳', '123456', 'COMMON', NULL),
       (60, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '郗朗', '123456', 'COMMON', NULL),
       (61, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '冼罡', '123456', 'COMMON', NULL),
       (62, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '富察青易', '123456', 'COMMON', NULL),
       (63, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '虢若蕊', '123456', 'COMMON', NULL),
       (64, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '答曼文', '123456', 'COMMON', NULL),
       (65, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '卞安民', '123456', 'COMMON', NULL),
       (66, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '务凯捷', '123456', 'COMMON', NULL),
       (67, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '栋和畅', '123456', 'COMMON', NULL),
       (68, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '集康安', '123456', 'COMMON', NULL),
       (69, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '浮睿达', '123456', 'COMMON', NULL),
       (70, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '闳飞薇', '123456', 'COMMON', NULL),
       (71, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '微生芷蓝', '123456', 'COMMON', NULL),
       (72, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '亢嘉茂', '123456', 'COMMON', NULL),
       (73, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '杭岚彩', '123456', 'COMMON', NULL),
       (74, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '赖俊英', '123456', 'COMMON', NULL),
       (75, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '仍书萱', '123456', 'COMMON', NULL),
       (76, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '濮嘉石', '123456', 'COMMON', NULL),
       (77, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '洋刚洁', '123456', 'COMMON', NULL),
       (78, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '尔紫薇', '123456', 'COMMON', NULL),
       (79, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '召德寿', '123456', 'COMMON', NULL),
       (80, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '司空叶春', '123456', 'COMMON', NULL),
       (81, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '罗媛女', '123456', 'COMMON', NULL),
       (82, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '籍春雪', '123456', 'COMMON', NULL),
       (83, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '类琳', '123456', 'COMMON', NULL),
       (84, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '慕容若兰', '123456', 'COMMON', NULL),
       (85, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '韶炫', '123456', 'COMMON', NULL),
       (86, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '喻长莹', '123456', 'COMMON', NULL),
       (87, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '赧飞瑶', '123456', 'COMMON', NULL),
       (88, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '司寇寄春', '123456', 'COMMON', NULL),
       (89, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '苑信瑞', '123456', 'COMMON', NULL),
       (90, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '愈晓兰', '123456', 'COMMON', NULL),
       (91, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '余菀柳', '123456', 'COMMON', NULL),
       (92, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '抗晓曼', '123456', 'COMMON', NULL),
       (93, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '邱艳娇', '123456', 'COMMON', NULL),
       (94, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '福睿好', '123456', 'COMMON', NULL),
       (95, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '隆翰', '123456', 'COMMON', NULL),
       (96, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '楼迎夏', '123456', 'COMMON', NULL),
       (97, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '广贞芳', '123456', 'COMMON', NULL),
       (98, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '嘉凝珍', '123456', 'COMMON', NULL),
       (99, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '子车平卉', '123456', 'COMMON', NULL),
       (100, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '局乐蓉', '123456', 'COMMON', NULL),
       (101, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '松涵梅', '123456', 'COMMON', NULL),
       (102, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '历丹丹', '123456', 'COMMON', NULL),
       (103, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '蒋念雁', '123456', 'COMMON', NULL),
       (104, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '睦辰', '123456', 'COMMON', NULL),
       (105, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '终诗珊', '123456', 'COMMON', NULL),
       (106, '2021-01-16 18:05:12', '2021-01-16 18:05:12', 'test', 'test', 'COMMON', NULL),
       (107, '2021-01-17 13:42:25', '2021-01-17 13:42:25', 'test', 'test', 'COMMON', NULL),
       (108, '2021-02-09 14:56:43', '2021-02-09 14:56:43', '666', '666', 'ADMIN', NULL);
----------------------
INSERT INTO `user_result`
VALUES (8, '2021-02-10 15:19:17', '2021-02-10 15:19:17', 1, 4, 5, 10,
        'SELECT COUNT(*) AS student_num FROM temp_student_result', '2021-02-10 15:18:02', '2021-02-10 15:19:17', NULL),
       (9, '2021-02-10 15:19:17', '2021-02-10 15:19:17', 1, 4, 3, 10, 'SELECT MAX(score) FROM temp_student_result',
        '2021-02-10 15:18:02', '2021-02-10 15:19:17', NULL),
       (10, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 6, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (11, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 1, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (12, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 2, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (13, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 5, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (14, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 4, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (15, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 107, 3, 5, 15, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (16, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 107, 4, 3, 17, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (17, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 108, 5, 1, 15, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (18, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 103, 4, 1, 14, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (19, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 103, 5, 2, 19, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (20, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 103, 4, 2, 17, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (21, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 103, 3, 1, 14, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (22, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 101, 3, 6, 9, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (23, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 101, 3, 2, 14, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (24, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 101, 4, 6, 17, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (25, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 101, 4, 5, 1, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (26, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 104, 4, 1, 2, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (27, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 104, 3, 6, 19, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (28, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 104, 4, 4, 18, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL);

插入数据2

-- MySQL dump 10.13  Distrib 8.0.19, for macos10.15 (x86_64)
--
-- Host: localhost    Database: sql_study_platform
-- ------------------------------------------------------
-- Server version	8.0.19

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

--
-- Dumping data for table `link_question_group`
--

LOCK
TABLES `link_question_group` WRITE;
/*!40000 ALTER TABLE `link_question_group` DISABLE KEYS */;
INSERT INTO `link_question_group`
VALUES (14, '2021-02-09 14:12:55', '2021-02-09 14:12:55', 4, 5),
       (15, '2021-02-09 14:12:55', '2021-02-09 14:12:55', 4, 3),
       (19, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 6),
       (20, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 1),
       (21, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 2),
       (22, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 5),
       (23, '2021-02-10 14:32:52', '2021-02-10 14:32:52', 3, 4),
       (24, '2021-02-11 18:54:48', '2021-02-11 18:54:48', 5, 2);
/*!40000 ALTER TABLE `link_question_group` ENABLE KEYS */;
UNLOCK
TABLES;

--
-- Dumping data for table `question`
--

LOCK
TABLES `question` WRITE;
/*!40000 ALTER TABLE `question` DISABLE KEYS */;
INSERT INTO `question`
VALUES (1, '2021-02-09 11:16:43', '2021-02-09 11:16:43', '获取学生总成绩',
        '根据以下表结构，请输入SQL语句来获取全班同学的总成绩',
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIFNVTShzY29yZSkgRlJPTSB0ZW1wX3N0dWRlbnRfcmVzdWx0IA==', 10, NULL),
       (2, '2021-02-09 11:39:46', '2021-02-09 11:39:46', '获取学生平均分', '获取学生平均分',
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIEFWRyhzY29yZSkgRlJPTSB0ZW1wX3N0dWRlbnRfcmVzdWx0', 10, NULL),
       (3, '2021-02-09 11:39:46', '2021-02-09 11:39:46', '获取学生最高分', NULL,
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIE1BWChzY29yZSkgRlJPTSB0ZW1wX3N0dWRlbnRfcmVzdWx0', 10, NULL),
       (4, '2021-02-09 11:39:46', '2021-02-09 11:39:46', '获取学生最低分', NULL,
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIE1JTihzY29yZSkgRlJPTSB0ZW1wX3N0dWRlbnRfcmVzdWx0', 10, NULL),
       (5, '2021-02-09 11:39:46', '2021-02-09 11:39:46', '获取学生人数', '<b>别名为 student_num</b>',
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YCAgKAogIGBpZGAgYmlnaW50IHVuc2lnbmVkICBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCBDT01NRU5UICdJRCcsCiAgYHN0dWRlbnRfbm9gIHZhcmNoYXIoMzIpICBOT1QgTlVMTCAsCiAgYHNjb3JlYCBpbnQgIE5PVCBOVUxMICwKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICflrabnlJ/miJDnu6knOwo=',
        'SU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudF9yZXN1bHRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHNjb3JlYCkgVkFMVUVTICgxLCAnMTAwMDEnLCA5OCk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRfcmVzdWx0YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzY29yZWApIFZBTFVFUyAoMiwgJzEwMDAyJywgNzgpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50X3Jlc3VsdGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc2NvcmVgKSBWQUxVRVMgKDMsICcxMDAwMycsIDgwKTs=',
        'U0VMRUNUIENPVU5UKCopIGFzIHN0dWRlbnRfbnVtIEZST00gdGVtcF9zdHVkZW50X3Jlc3VsdA==', 10, NULL),
       (6, '2021-02-10 14:31:33', '2021-02-10 14:31:33', '获取班级内的学生',
        '根据以下表结构，关联teacher表与student表，获取张老师的所有学生学号和姓名<div style=\"text-align: right;\"><b>提示: 根据teacher_id进行关联，并且需要的是学生的学号和姓名哦！</b></div>',
        'Q1JFQVRFIFRBQkxFIGB0ZW1wX3RlYWNoZXJgICAoCiAgYGlkYCBiaWdpbnQgdW5zaWduZWQgIE5PVCBOVUxMIEFVVE9fSU5DUkVNRU5UIENPTU1FTlQgJ0lEJywKICBgdGVhY2hlcl9uYW1lYCB2YXJjaGFyKDMyKSAgTk9UIE5VTEwgQ09NTUVOVCAn6ICB5biI5ZCN56ewJywKICBgdGVhY2hlcl90eXBlYCB2YXJjaGFyKDMyKSAgTk9UIE5VTEwgQ09NTUVOVCAn5o6I6K++57G75Z6LJywKICBQUklNQVJZIEtFWSAoYGlkYCkKKSBDT01NRU5UICfmlZnluIgnOwoKQ1JFQVRFIFRBQkxFIGB0ZW1wX3N0dWRlbnRgICAoCiAgYGlkYCBiaWdpbnQgdW5zaWduZWQgIE5PVCBOVUxMIEFVVE9fSU5DUkVNRU5UIENPTU1FTlQgJ0lEJywKICBgc3R1ZGVudF9ub2AgdmFyY2hhcigzMikgIE5PVCBOVUxMIENPTU1FTlQgJ+WtpuWPtycsCiAgYHN0dWRlbnRfbmFtZWAgdmFyY2hhcigzMikgIE5PVCBOVUxMIENPTU1FTlQgJ+WtpueUn+Wnk+WQjScsCiAgYHRlYWNoZXJfaWRgIGJpZ2ludCB1bnNpZ25lZCAgTk9UIE5VTEwgQ09NTUVOVCAn5pWZ5biISUQnLAogIFBSSU1BUlkgS0VZIChgaWRgKQopIENPTU1FTlQgJ+WtpueUn+ihqCc7Cg==',
        'SU5TRVJUIElOVE8gYHRlbXBfdGVhY2hlcmAoYGlkYCwgYHRlYWNoZXJfbmFtZWAsIGB0ZWFjaGVyX3R5cGVgKSBWQUxVRVMgKDEsICflvKDogIHluIgnLCAn5pWw5a2mJyk7CklOU0VSVCBJTlRPIGB0ZW1wX3RlYWNoZXJgKGBpZGAsIGB0ZWFjaGVyX25hbWVgLCBgdGVhY2hlcl90eXBlYCkgVkFMVUVTICgyLCAn546L6ICB5biIJywgJ+ivreaWhycpOwpJTlNFUlQgSU5UTyBgdGVtcF90ZWFjaGVyYChgaWRgLCBgdGVhY2hlcl9uYW1lYCwgYHRlYWNoZXJfdHlwZWApIFZBTFVFUyAoMywgJ+adjuiAgeW4iCcsICfoi7Hor60nKTsKCklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHN0dWRlbnRfbmFtZWAsIGB0ZWFjaGVyX2lkYCkgVkFMVUVTICgxLCAnMTAwMDEnLCAn5bCPQScsIDEpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzdHVkZW50X25hbWVgLCBgdGVhY2hlcl9pZGApIFZBTFVFUyAoMiwgJzEwMDAxJywgJ+Wwj0EnLCAzKTsKSU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc3R1ZGVudF9uYW1lYCwgYHRlYWNoZXJfaWRgKSBWQUxVRVMgKDMsICcxMDAwMScsICflsI9CJywgMSk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHN0dWRlbnRfbmFtZWAsIGB0ZWFjaGVyX2lkYCkgVkFMVUVTICg0LCAnMTAwMDEnLCAn5bCPQycsIDEpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzdHVkZW50X25hbWVgLCBgdGVhY2hlcl9pZGApIFZBTFVFUyAoNSwgJzEwMDAxJywgJ+Wwj0QnLCAxKTsKSU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc3R1ZGVudF9uYW1lYCwgYHRlYWNoZXJfaWRgKSBWQUxVRVMgKDYsICcxMDAwMScsICflsI9FJywgMSk7CklOU0VSVCBJTlRPIGB0ZW1wX3N0dWRlbnRgKGBpZGAsIGBzdHVkZW50X25vYCwgYHN0dWRlbnRfbmFtZWAsIGB0ZWFjaGVyX2lkYCkgVkFMVUVTICg3LCAnMTAwMDEnLCAn5bCPQScsIDIpOwpJTlNFUlQgSU5UTyBgdGVtcF9zdHVkZW50YChgaWRgLCBgc3R1ZGVudF9ub2AsIGBzdHVkZW50X25hbWVgLCBgdGVhY2hlcl9pZGApIFZBTFVFUyAoOCwgJzEwMDAxJywgJ+Wwj0InLCAyKTsKSU5TRVJUIElOVE8gYHRlbXBfc3R1ZGVudGAoYGlkYCwgYHN0dWRlbnRfbm9gLCBgc3R1ZGVudF9uYW1lYCwgYHRlYWNoZXJfaWRgKSBWQUxVRVMgKDksICcxMDAwMScsICflsI9DJywgMyk7',
        'U0VMRUNUIHN0dWRlbnRfbm8sc3R1ZGVudF9uYW1lIEZST00gdGVtcF9zdHVkZW50IHMKTEVGVCBKT0lOIHRlbXBfdGVhY2hlciB0IE9OIHMudGVhY2hlcl9pZCA9IHQuaWQKV0hFUkUgdC50ZWFjaGVyX25hbWUgPSAn5byg6ICB5biIJw==',
        20, NULL);
/*!40000 ALTER TABLE `question` ENABLE KEYS */;
UNLOCK
TABLES;

--
-- Dumping data for table `question_group`
--

LOCK
TABLES `question_group` WRITE;
/*!40000 ALTER TABLE `question_group` DISABLE KEYS */;
INSERT INTO `question_group`
VALUES (3, '2021-02-09 14:06:29', '2021-02-09 14:06:29', '单元测试1'),
       (4, '2021-02-09 14:12:55', '2021-02-09 14:12:55', '单元测试2'),
       (5, '2021-02-11 18:54:48', '2021-02-11 18:54:48', '期末考试');
/*!40000 ALTER TABLE `question_group` ENABLE KEYS */;
UNLOCK
TABLES;

--
-- Dumping data for table `setting`
--

LOCK
TABLES `setting` WRITE;
/*!40000 ALTER TABLE `setting` DISABLE KEYS */;
/*!40000 ALTER TABLE `setting` ENABLE KEYS */;
UNLOCK
TABLES;

--
-- Dumping data for table `user`
--

LOCK
TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user`
VALUES (1, '2020-10-15 10:49:16', '2020-10-15 14:11:09', '1', '1', 'COMMON', NULL),
       (2, '2020-10-15 10:49:16', '2020-10-15 14:11:32', 'admin', 'admin', 'ADMIN', NULL),
       (3, '2020-10-15 14:10:30', '2020-10-15 14:10:30', '小王', '3', 'ADMIN', NULL),
       (4, '2020-10-15 14:12:22', '2020-10-15 14:12:22', '2', '2', 'ADMIN', NULL),
       (5, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '繁春柔', '123456', 'COMMON', NULL),
       (6, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '全含芙', '123456', 'COMMON', NULL),
       (7, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '宓绿凝', '123456', 'COMMON', NULL),
       (8, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '本傲冬', '123456', 'COMMON', NULL),
       (9, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '闾妙菡123', '123456', 'COMMON', NULL),
       (10, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '咸灵珊', '123456', 'COMMON', NULL),
       (11, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '段干润', '123456', 'COMMON', NULL),
       (16, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '蔺宏峻', '123456', 'COMMON', NULL),
       (17, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '令狐映寒', '123456', 'COMMON', NULL),
       (18, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '颜安萱', '123456', 'COMMON', NULL),
       (19, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '佟秋芸', '123456', 'COMMON', NULL),
       (20, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '茆寒云', '123456', 'COMMON', NULL),
       (21, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '理柏', '123456', 'COMMON', NULL),
       (22, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '钮利', '123456', 'COMMON', NULL),
       (23, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '庞友灵', '123456', 'COMMON', NULL),
       (24, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '岑吉月', '123456', 'COMMON', NULL),
       (25, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '缪茉莉', '123456', 'COMMON', NULL),
       (26, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '乙伟晔', '123456', 'COMMON', NULL),
       (27, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '宣宛妙', '123456', 'COMMON', NULL),
       (28, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '鲜嘉珍', '123456', 'COMMON', NULL),
       (29, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '衅晴丽', '123456', 'COMMON', NULL),
       (30, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '米雪', '123456', 'COMMON', NULL),
       (31, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '甲浩波', '123456', 'COMMON', NULL),
       (32, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '景维', '123456', 'COMMON', NULL),
       (33, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '衷蔓菁', '123456', 'COMMON', NULL),
       (34, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '斛亦', '123456', 'COMMON', NULL),
       (35, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '荤俊爽', '123456', 'COMMON', NULL),
       (36, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '乘凝雁', '123456', 'COMMON', NULL),
       (37, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '杜慧晨', '123456', 'COMMON', NULL),
       (38, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '柳轶', '123456', 'COMMON', NULL),
       (39, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '阮冬萱', '123456', 'COMMON', NULL),
       (40, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '施天蓉', '123456', 'COMMON', NULL),
       (41, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '俟浩穰', '123456', 'COMMON', NULL),
       (42, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '郑星海', '123456', 'COMMON', NULL),
       (43, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '邰萍韵', '123456', 'COMMON', NULL),
       (44, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '浦元槐', '123456', 'COMMON', NULL),
       (45, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '郸莺韵', '123456', 'COMMON', NULL),
       (46, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '邬秀媛', '123456', 'COMMON', NULL),
       (47, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '暨馨蓉', '123456', 'COMMON', NULL),
       (48, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '宛忆灵', '123456', 'COMMON', NULL),
       (49, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '首贞静', '123456', 'COMMON', NULL),
       (50, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '郯嘉淑', '123456', 'COMMON', NULL),
       (51, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '兴听南', '123456', 'COMMON', NULL),
       (52, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '费莫鸿博', '123456', 'COMMON', NULL),
       (53, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '箕瑞云', '123456', 'COMMON', NULL),
       (54, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '悟光远', '123456', 'COMMON', NULL),
       (55, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '仙凝蝶', '123456', 'COMMON', NULL),
       (56, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '盖智菱', '123456', 'COMMON', NULL),
       (57, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '及梦泽', '123456', 'COMMON', NULL),
       (58, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '禽乐安', '123456', 'COMMON', NULL),
       (59, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '成嘉纳', '123456', 'COMMON', NULL),
       (60, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '郗朗', '123456', 'COMMON', NULL),
       (61, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '冼罡', '123456', 'COMMON', NULL),
       (62, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '富察青易', '123456', 'COMMON', NULL),
       (63, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '虢若蕊', '123456', 'COMMON', NULL),
       (64, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '答曼文', '123456', 'COMMON', NULL),
       (65, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '卞安民', '123456', 'COMMON', NULL),
       (66, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '务凯捷', '123456', 'COMMON', NULL),
       (67, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '栋和畅', '123456', 'COMMON', NULL),
       (68, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '集康安', '123456', 'COMMON', NULL),
       (69, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '浮睿达', '123456', 'COMMON', NULL),
       (70, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '闳飞薇', '123456', 'COMMON', NULL),
       (71, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '微生芷蓝', '123456', 'COMMON', NULL),
       (72, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '亢嘉茂', '123456', 'COMMON', NULL),
       (73, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '杭岚彩', '123456', 'COMMON', NULL),
       (74, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '赖俊英', '123456', 'COMMON', NULL),
       (75, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '仍书萱', '123456', 'COMMON', NULL),
       (76, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '濮嘉石', '123456', 'COMMON', NULL),
       (77, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '洋刚洁', '123456', 'COMMON', NULL),
       (78, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '尔紫薇', '123456', 'COMMON', NULL),
       (79, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '召德寿', '123456', 'COMMON', NULL),
       (80, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '司空叶春', '123456', 'COMMON', NULL),
       (81, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '罗媛女', '123456', 'COMMON', NULL),
       (82, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '籍春雪', '123456', 'COMMON', NULL),
       (83, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '类琳', '123456', 'COMMON', NULL),
       (84, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '慕容若兰', '123456', 'COMMON', NULL),
       (85, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '韶炫', '123456', 'COMMON', NULL),
       (86, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '喻长莹', '123456', 'COMMON', NULL),
       (87, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '赧飞瑶', '123456', 'COMMON', NULL),
       (88, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '司寇寄春', '123456', 'COMMON', NULL),
       (89, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '苑信瑞', '123456', 'COMMON', NULL),
       (90, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '愈晓兰', '123456', 'COMMON', NULL),
       (91, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '余菀柳', '123456', 'COMMON', NULL),
       (92, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '抗晓曼', '123456', 'COMMON', NULL),
       (93, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '邱艳娇', '123456', 'COMMON', NULL),
       (94, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '福睿好', '123456', 'COMMON', NULL),
       (95, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '隆翰', '123456', 'COMMON', NULL),
       (96, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '楼迎夏', '123456', 'COMMON', NULL),
       (97, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '广贞芳', '123456', 'COMMON', NULL),
       (98, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '嘉凝珍', '123456', 'COMMON', NULL),
       (99, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '子车平卉', '123456', 'COMMON', NULL),
       (100, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '局乐蓉', '123456', 'COMMON', NULL),
       (101, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '松涵梅', '123456', 'COMMON', NULL),
       (102, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '历丹丹', '123456', 'COMMON', NULL),
       (103, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '蒋念雁', '123456', 'COMMON', NULL),
       (104, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '睦辰', '123456', 'COMMON', NULL),
       (105, '2020-10-21 16:51:52', '2020-10-21 16:51:52', '终诗珊', '123456', 'COMMON', NULL),
       (106, '2021-01-16 18:05:12', '2021-01-16 18:05:12', 'test', 'test', 'COMMON', NULL),
       (107, '2021-01-17 13:42:25', '2021-01-17 13:42:25', 'test', 'test', 'COMMON', NULL),
       (108, '2021-02-09 14:56:43', '2021-02-09 14:56:43', '666', '666', 'ADMIN', NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK
TABLES;

--
-- Dumping data for table `user_result`
--

LOCK
TABLES `user_result` WRITE;
/*!40000 ALTER TABLE `user_result` DISABLE KEYS */;
INSERT INTO `user_result`
VALUES (8, '2021-02-10 15:19:17', '2021-02-10 15:19:17', 1, 4, 5, 10,
        'SELECT COUNT(*) AS student_num FROM temp_student_result', '2021-02-10 15:18:02', '2021-02-10 15:19:17', NULL),
       (9, '2021-02-10 15:19:17', '2021-02-10 15:19:17', 1, 4, 3, 10, 'SELECT MAX(score) FROM temp_student_result',
        '2021-02-10 15:18:02', '2021-02-10 15:19:17', NULL),
       (10, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 6, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (11, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 1, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (12, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 2, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (13, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 5, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (14, '2021-02-10 15:23:34', '2021-02-10 15:23:34', 1, 3, 4, 0, '123', '2021-02-10 15:23:21',
        '2021-02-10 15:23:33', NULL),
       (15, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 107, 3, 5, 15, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (16, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 107, 4, 3, 17, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (17, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 108, 5, 1, 15, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (18, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 103, 4, 1, 14, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (19, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 103, 5, 2, 19, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (20, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 103, 4, 2, 17, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (21, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 103, 3, 1, 14, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (22, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 101, 3, 6, 9, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (23, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 101, 3, 2, 14, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (24, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 101, 4, 6, 17, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (25, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 101, 4, 5, 1, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (26, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 104, 4, 1, 2, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (27, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 104, 3, 6, 19, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL),
       (28, '2021-02-11 19:10:58', '2021-02-11 19:10:58', 104, 4, 4, 18, 'mock', '2021-02-11 19:10:58',
        '2021-02-11 19:10:58', NULL);
/*!40000 ALTER TABLE `user_result` ENABLE KEYS */;
UNLOCK
TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-02-12 12:07:03

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
.idea		.idea
src		src
target		target
pom.xml		pom.xml
readme.md		readme.md
sql-study-platform-controller.iml		sql-study-platform-controller.iml

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

数据库原理实验评判系统

首页

管理员页面

用户管理

题目管理

试卷管理

成绩报表

普通用户

练习中心

我的成绩

初始表

插入数据1

插入数据2

接口文档（todo）

About

Releases

Packages

Languages

WenTesla/sql-study-platform

Folders and files

Latest commit

History

Repository files navigation

数据库原理实验评判系统

首页

管理员页面

用户管理

题目管理

试卷管理

成绩报表

普通用户

练习中心

我的成绩

初始表

插入数据1

插入数据2

接口文档（todo）

About

Resources

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages