在线考试系统的功能描述及源码下载

最新推荐文章于 2023-02-12 18:44:18 发布
置顶 最新推荐文章于 2023-02-12 18:44:18 发布
阅读量599 收藏
点赞数 1
分类专栏： JavaWeb Maven mysql 文章标签： mysql java 数据分析 javascript 项目管理
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43407843/article/details/106743474
版权
mysql 同时被 3 个专栏收录
3 篇文章 0 订阅
订阅专栏
JavaWeb
1 篇文章 0 订阅
订阅专栏
Maven
1 篇文章 0 订阅
订阅专栏

本文讲述在线考试系统的功能，可下载对应资源。

  1. 基本描述
    1. B/S模式，SSM框架， Maven项目
    2. 基于eclipse开发，Tomcat部署，MySQL数据库
    3. 基本技术： Spring、SpringMVC、Mybatis、SiteMesh、Shiro、slf4j + log4j、JSP、Ajax、JS
  2. 前台基本功能
    1. 登陆（密码加密保存）
    2. 注册
    3. 找回密码（通过密保）
    4. 使用手册
    5. 后台登陆
    6. 在线考试（随机组卷或固定组卷）
    7. 查看错题（整体回顾）
    8. 查看成绩（查找、导出Excel）
    9. 修改个人信息
    10. 等等。。。。。。
  3. 后台基本功能
    1. 登陆（信息加密）
    2. 学生管理（增删查改，Excel批量插入，分页显示、模糊搜索）
    3. 试题管理（增删查改，支持试题带图片，难度区分，题型区分）
    4. 考试管理（增删查改，信息统计）
    5. 成绩管理（增删查改，导出Excel，迷糊搜索）
    6. 成绩分析（数据以图表统计显示：echart）
    7. 系统管理（个人信息管理）
    8. 场次管理（布置考试相关信息）
    9. 等等。。。。。。
  4. 备注：需要请留言，基础项目，可作为入行基础、毕业设计、课题作业，其它需求可实现快速修改实现
  5. 下载链接：https://download.csdn.net/download/weixin_43407843/12521767
  7. 以下内容不重要
  8. 源码目录：
    exam
    Java Resources
    src
    com.project.exam.common //通用基础类，如系统配置信息类，拦截器等
    com.project.exam.controller //与其名称一致主要存放Controller类
    com.project.exam.controller.f //前端Controller
    com.project.exam.dao //数据库Mapper类
    com.project.exam.model //表映射java对象
    com.project.exam.service //服务类
    com.project.exam.xml //mybatis表映射xml文件
    com.project.utils //存放全局工具类
    com.project.utils.shiro //shiro
    resources
    config.properties //系统配置文件
    jdbc.properties //jdbc配置文件
    log4j.properties //日志配置文件
    mybatis-config.xml //MyBatis核心配置文件
    spring-mvc.xml //spring-mvc配置文件
    spring-mybatis.xml //spring-mybatis整合配置文件 ，spring和MyBatis的完美结合，不需要mybatis的配置映射文件
    spring-shiro.xml //授权验证的配置，spring与shiro整合时，需要将shiro的ini配置放到xml文件中
    WebRoot
    assets
    css
    front
    images
    js
    plugin
    META-INF
    MANIFEST.MF
    WEB-INF
    exam
    exercise
    front
    layouts
    question
    student
    system
    decorators.xml
    execl.jsp
    uetest.jsp
    web.xml
    generatorConfig.xml
    pom.xml
  9. SQL文件：
    /*
    Navicat MySQL Data Transfer

Source Server : localhost
Source Server Version : 50645
Source Host : localhost:3306
Source Database : examonline

Target Server Type : MYSQL
Target Server Version : 50645
File Encoding : 65001

Date: 2020-06-05 10:09:17
*/

SET FOREIGN_KEY_CHECKS=0;

– Table structure for front_user

DROP TABLE IF EXISTS front_user;
CREATE TABLE front_user (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
name varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ‘姓名’,
password varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ‘密码’,
deleted tinyint(1) DEFAULT ‘0’ COMMENT ‘是否删除：1，已删除或无效；0，未删除或有效’,
create_time datetime DEFAULT NULL,
student_no varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ‘学号’,
securityQuestion varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
securityAnswer varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
adminId int(11) NOT NULL,
state int(1) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY student_no (student_no) USING BTREE,
KEY adminId (adminId),
CONSTRAINT adminId FOREIGN KEY (adminId) REFERENCES sys_user (id)
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT=‘注册用户表’;

– Records of front_user

INSERT INTO front_user VALUES (‘76’, ‘测试考生1’, ‘zz20200001’, ‘0’, ‘2020-05-26 15:04:04’, ‘20200001’, ‘我的老师ID是？’, ‘1’, ‘1’, ‘1’);
INSERT INTO front_user VALUES (‘77’, ‘测试考生2’, ‘zz20200002’, ‘0’, ‘2020-05-26 15:04:04’, ‘20200002’, ‘我的老师ID是？’, ‘1’, ‘1’, ‘0’);
INSERT INTO front_user VALUES (‘78’, ‘测试考生3’, ‘zz20200003’, ‘0’, ‘2020-05-26 15:04:04’, ‘20200003’, ‘我的老师ID是？’, ‘1’, ‘1’, ‘0’);
INSERT INTO front_user VALUES (‘79’, ‘测试考生4’, ‘zz20200004’, ‘0’, ‘2020-05-26 15:04:04’, ‘20200004’, ‘我的老师ID是？’, ‘1’, ‘1’, ‘0’);
INSERT INTO front_user VALUES (‘80’, ‘测试考生5’, ‘zz20200005’, ‘0’, ‘2020-05-26 15:04:04’, ‘20200005’, ‘我的老师ID是？’, ‘1’, ‘1’, ‘0’);
INSERT INTO front_user VALUES (‘81’, ‘测试考生6’, ‘zz20200006’, ‘0’, ‘2020-05-26 15:04:04’, ‘20200006’, ‘我的老师ID是？’, ‘1’, ‘1’, ‘0’);
INSERT INTO front_user VALUES (‘82’, ‘测试考生7’, ‘zz20200007’, ‘0’, ‘2020-05-26 15:04:04’, ‘20200007’, ‘我的老师ID是？’, ‘1’, ‘1’, ‘0’);
INSERT INTO front_user VALUES (‘83’, ‘测试考生8’, ‘zz20200008’, ‘0’, ‘2020-05-26 15:04:04’, ‘20200008’, ‘我的老师ID是？’, ‘1’, ‘1’, ‘0’);

– Table structure for sys_user

DROP TABLE IF EXISTS sys_user;
CREATE TABLE sys_user (
id int(11) NOT NULL AUTO_INCREMENT,
user_name varchar(50) NOT NULL COMMENT ‘用户名，登陆名’,
real_name varchar(50) DEFAULT NULL COMMENT ‘真实姓名，昵称’,
password varchar(70) DEFAULT NULL COMMENT ‘密码’,
phone varchar(15) DEFAULT NULL COMMENT ‘手机号’,
type int(2) DEFAULT NULL COMMENT ‘1:管理员；2：学员’,
deleted tinyint(1) DEFAULT NULL COMMENT ‘是否删除：1，已删除或无效；0，未删除或有效’,
create_time datetime NOT NULL,
update_time datetime DEFAULT NULL,
duration int(5) DEFAULT NULL COMMENT ‘答题时长’,
amount varchar(25) DEFAULT NULL COMMENT ‘题目数量’,
times int(2) DEFAULT NULL,
paper_title varchar(25) DEFAULT NULL COMMENT ‘试卷编号或名称’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

– Records of sys_user

INSERT INTO sys_user VALUES (‘1’, ‘admin’, ‘超级管理员’, ‘0859e04820336c7d2a14511d8f173ff2aab923911bdce5f7b23cf116’, ‘’, ‘1’, ‘0’, ‘2017-02-13 18:23:40’, ‘2018-12-02 16:44:29’, ‘120’, ‘0,0,0,0,10’, ‘1’, ‘科目一测试’);
INSERT INTO sys_user VALUES (‘2’, ‘Superman’, ‘张三’, ‘f5b77aea40c88103959977fb234d1c55311981cf2d2c70f15b16976f’, ‘10086’, ‘2’, ‘0’, ‘2020-05-24 11:52:08’, ‘2020-05-24 11:52:12’, null, null, null, null);

– Table structure for tb_exam

DROP TABLE IF EXISTS tb_exam;
CREATE TABLE tb_exam (
id int(11) NOT NULL AUTO_INCREMENT,
student_id int(11) DEFAULT NULL COMMENT ‘学员id’,
score int(11) DEFAULT NULL COMMENT ‘分数’,
create_time datetime DEFAULT NULL,
update_time datetime DEFAULT NULL,
paper_title varchar(25) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT=‘考试成绩表’;

– Records of tb_exam

INSERT INTO tb_exam VALUES (‘1’, ‘77’, ‘20’, ‘2020-06-04 14:36:43’, ‘2020-06-04 14:36:43’, ‘期末测试卷1’);
INSERT INTO tb_exam VALUES (‘2’, ‘76’, ‘0’, ‘2020-06-04 14:42:29’, ‘2020-06-04 14:42:29’, ‘科目一测试’);

– Table structure for tb_exam_info

DROP TABLE IF EXISTS tb_exam_info;
CREATE TABLE tb_exam_info (
id int(11) NOT NULL AUTO_INCREMENT,
exam_id int(11) DEFAULT NULL COMMENT ‘试卷id’,
question_id int(11) DEFAULT NULL COMMENT ‘试题id’,
sort int(11) DEFAULT NULL COMMENT ‘序号’,
is_right int(1) DEFAULT NULL COMMENT ‘是否正确’,
create_time datetime DEFAULT NULL,
myanswer varchar(10) DEFAULT NULL COMMENT ‘我的答案’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT=‘答题信息表’;

– Records of tb_exam_info

INSERT INTO tb_exam_info VALUES (‘1’, ‘1’, ‘114’, ‘1’, ‘1’, ‘2020-06-04 14:36:43’, ‘C’);
INSERT INTO tb_exam_info VALUES (‘2’, ‘1’, ‘112’, ‘2’, ‘1’, ‘2020-06-04 14:36:43’, ‘D’);
INSERT INTO tb_exam_info VALUES (‘3’, ‘1’, ‘109’, ‘3’, ‘1’, ‘2020-06-04 14:36:43’, ‘B’);
INSERT INTO tb_exam_info VALUES (‘4’, ‘1’, ‘107’, ‘4’, ‘1’, ‘2020-06-04 14:36:43’, ‘D’);
INSERT INTO tb_exam_info VALUES (‘5’, ‘1’, ‘115’, ‘5’, ‘1’, ‘2020-06-04 14:36:43’, ‘A’);
INSERT INTO tb_exam_info VALUES (‘6’, ‘1’, ‘108’, ‘6’, ‘1’, ‘2020-06-04 14:36:43’, ‘B’);
INSERT INTO tb_exam_info VALUES (‘7’, ‘1’, ‘111’, ‘7’, ‘1’, ‘2020-06-04 14:36:43’, ‘D’);
INSERT INTO tb_exam_info VALUES (‘8’, ‘1’, ‘110’, ‘8’, ‘1’, ‘2020-06-04 14:36:43’, ‘C’);
INSERT INTO tb_exam_info VALUES (‘9’, ‘1’, ‘104’, ‘9’, ‘1’, ‘2020-06-04 14:36:43’, ‘C’);
INSERT INTO tb_exam_info VALUES (‘10’, ‘1’, ‘113’, ‘10’, ‘1’, ‘2020-06-04 14:36:43’, ‘D’);
INSERT INTO tb_exam_info VALUES (‘11’, ‘2’, ‘107’, ‘1’, ‘0’, ‘2020-06-04 14:42:29’, null);
INSERT INTO tb_exam_info VALUES (‘12’, ‘2’, ‘109’, ‘2’, ‘0’, ‘2020-06-04 14:42:29’, null);
INSERT INTO tb_exam_info VALUES (‘13’, ‘2’, ‘104’, ‘3’, ‘0’, ‘2020-06-04 14:42:29’, null);
INSERT INTO tb_exam_info VALUES (‘14’, ‘2’, ‘111’, ‘4’, ‘0’, ‘2020-06-04 14:42:29’, null);
INSERT INTO tb_exam_info VALUES (‘15’, ‘2’, ‘108’, ‘5’, ‘0’, ‘2020-06-04 14:42:29’, null);
INSERT INTO tb_exam_info VALUES (‘16’, ‘2’, ‘115’, ‘6’, ‘0’, ‘2020-06-04 14:42:29’, null);
INSERT INTO tb_exam_info VALUES (‘17’, ‘2’, ‘114’, ‘7’, ‘0’, ‘2020-06-04 14:42:29’, null);
INSERT INTO tb_exam_info VALUES (‘18’, ‘2’, ‘113’, ‘8’, ‘0’, ‘2020-06-04 14:42:29’, null);
INSERT INTO tb_exam_info VALUES (‘19’, ‘2’, ‘110’, ‘9’, ‘0’, ‘2020-06-04 14:42:29’, null);
INSERT INTO tb_exam_info VALUES (‘20’, ‘2’, ‘112’, ‘10’, ‘0’, ‘2020-06-04 14:42:29’, null);

– Table structure for tb_options

DROP TABLE IF EXISTS tb_options;
CREATE TABLE tb_options (
id int(11) NOT NULL AUTO_INCREMENT,
question_id int(11) DEFAULT NULL COMMENT ‘题目id’,
opt varchar(50) DEFAULT NULL COMMENT ‘选项’,
content varchar(1000) DEFAULT NULL COMMENT ‘选项内容’,
rig bit(1) DEFAULT NULL COMMENT ‘是否正确’,
create_time datetime DEFAULT NULL,
update_time datetime DEFAULT NULL,
PRIMARY KEY (id),
KEY question_id (question_id),
CONSTRAINT question_id FOREIGN KEY (question_id) REFERENCES tb_question (id)
) ENGINE=InnoDB AUTO_INCREMENT=464 DEFAULT CHARSET=utf8mb4 COMMENT=‘选项表’;

– Records of tb_options

INSERT INTO tb_options VALUES (‘244’, ‘62’, ‘A’, ‘0’, ‘’, ‘2020-04-19 20:07:47’, null);
INSERT INTO tb_options VALUES (‘245’, ‘62’, ‘B’, ‘1’, ‘’, ‘2020-04-19 20:07:47’, null);
INSERT INTO tb_options VALUES (‘246’, ‘62’, ‘C’, ‘2’, ‘’, ‘2020-04-19 20:07:47’, null);
INSERT INTO tb_options VALUES (‘247’, ‘62’, ‘D’, ‘3’, ‘’, ‘2020-04-19 20:07:47’, null);
INSERT INTO tb_options VALUES (‘248’, ‘63’, ‘A’, ‘1’, ‘’, ‘2020-04-19 20:09:33’, null);
INSERT INTO tb_options VALUES (‘249’, ‘63’, ‘B’, ‘2’, ‘’, ‘2020-04-19 20:09:33’, null);
INSERT INTO tb_options VALUES (‘250’, ‘63’, ‘C’, ‘3’, ‘’, ‘2020-04-19 20:09:33’, null);
INSERT INTO tb_options VALUES (‘251’, ‘63’, ‘D’, ‘4’, ‘’, ‘2020-04-19 20:09:33’, null);
INSERT INTO tb_options VALUES (‘252’, ‘64’, ‘A’, ‘1’, ‘’, ‘2020-04-19 20:09:52’, null);
INSERT INTO tb_options VALUES (‘253’, ‘64’, ‘B’, ‘2’, ‘’, ‘2020-04-19 20:09:52’, null);
INSERT INTO tb_options VALUES (‘254’, ‘64’, ‘C’, ‘3’, ‘’, ‘2020-04-19 20:09:52’, null);
INSERT INTO tb_options VALUES (‘255’, ‘64’, ‘D’, ‘4’, ‘’, ‘2020-04-19 20:09:52’, null);
INSERT INTO tb_options VALUES (‘256’, ‘65’, ‘A’, ‘4’, ‘’, ‘2020-04-19 20:10:22’, null);
INSERT INTO tb_options VALUES (‘257’, ‘65’, ‘B’, ‘5’, ‘’, ‘2020-04-19 20:10:22’, null);
INSERT INTO tb_options VALUES (‘258’, ‘65’, ‘C’, ‘6’, ‘’, ‘2020-04-19 20:10:22’, null);
INSERT INTO tb_options VALUES (‘259’, ‘65’, ‘D’, ‘7’, ‘’, ‘2020-04-19 20:10:22’, null);
INSERT INTO tb_options VALUES (‘260’, ‘66’, ‘A’, ‘4’, ‘’, ‘2020-04-19 20:10:40’, null);
INSERT INTO tb_options VALUES (‘261’, ‘66’, ‘B’, ‘5’, ‘’, ‘2020-04-19 20:10:40’, null);
INSERT INTO tb_options VALUES (‘262’, ‘66’, ‘C’, ‘6’, ‘’, ‘2020-04-19 20:10:40’, null);
INSERT INTO tb_options VALUES (‘263’, ‘66’, ‘D’, ‘7’, ‘’, ‘2020-04-19 20:10:40’, null);
INSERT INTO tb_options VALUES (‘264’, ‘67’, ‘A’, ‘1+0’, ‘’, ‘2020-04-19 20:13:07’, null);
INSERT INTO tb_options VALUES (‘265’, ‘67’, ‘B’, ‘1-0’, ‘’, ‘2020-04-19 20:13:07’, null);
INSERT INTO tb_options VALUES (‘266’, ‘67’, ‘C’, ‘10’, ‘’, ‘2020-04-19 20:13:07’, null);
INSERT INTO tb_options VALUES (‘267’, ‘67’, ‘D’, ‘1/0’, ‘’, ‘2020-04-19 20:13:07’, null);
INSERT INTO tb_options VALUES (‘268’, ‘68’, ‘A’, ‘1+1’, ‘’, ‘2020-04-19 20:13:46’, null);
INSERT INTO tb_options VALUES (‘269’, ‘68’, ‘B’, ‘1-1’, ‘’, ‘2020-04-19 20:13:46’, null);
INSERT INTO tb_options VALUES (‘270’, ‘68’, ‘C’, '11’, ‘’, ‘2020-04-19 20:13:46’, null);
INSERT INTO tb_options VALUES (‘271’, ‘68’, ‘D’, ‘3-1’, ‘’, ‘2020-04-19 20:13:46’, null);
INSERT INTO tb_options VALUES (‘272’, ‘69’, ‘A’, ‘1+1’, ‘’, ‘2020-04-19 20:14:30’, null);
INSERT INTO tb_options VALUES (‘273’, ‘69’, ‘B’, ‘4-1’, ‘’, ‘2020-04-19 20:14:30’, null);
INSERT INTO tb_options VALUES (‘274’, ‘69’, ‘C’, ‘11’, ‘’, ‘2020-04-19 20:14:30’, null);
INSERT INTO tb_options VALUES (‘275’, ‘69’, ‘D’, ‘3-1’, ‘’, ‘2020-04-19 20:14:30’, null);
INSERT INTO tb_options VALUES (‘276’, ‘70’, ‘A’, ‘1+3’, ‘’, ‘2020-04-19 20:14:58’, null);
INSERT INTO tb_options VALUES (‘277’, ‘70’, ‘B’, ‘4-1’, ‘’, ‘2020-04-19 20:14:58’, null);
INSERT INTO tb_options VALUES (‘278’, ‘70’, ‘C’, '11’, ‘’, ‘2020-04-19 20:14:58’, null);
INSERT INTO tb_options VALUES (‘279’, ‘70’, ‘D’, ‘5-1’, ‘’, ‘2020-04-19 20:14:58’, null);
INSERT INTO tb_options VALUES (‘280’, ‘71’, ‘A’, ‘1+3’, ‘’, ‘2020-04-19 20:15:24’, null);
INSERT INTO tb_options VALUES (‘281’, ‘71’, ‘B’, ‘7-2’, ‘’, ‘2020-04-19 20:15:24’, null);
INSERT INTO tb_options VALUES (‘282’, ‘71’, ‘C’, ‘1*5’, ‘’, ‘2020-04-19 20:15:24’, null);
INSERT INTO tb_options VALUES (‘283’, ‘71’, ‘D’, ‘5-1’, ‘’, ‘2020-04-19 20:15:24’, null);
INSERT INTO tb_options VALUES (‘284’, ‘72’, ‘A’, ‘你’, ‘’, ‘2020-04-19 20:18:07’, null);
INSERT INTO tb_options VALUES (‘285’, ‘72’, ‘B’, ‘我’, ‘’, ‘2020-04-19 20:18:07’, null);
INSERT INTO tb_options VALUES (‘286’, ‘72’, ‘C’, ‘他’, ‘’, ‘2020-04-19 20:18:07’, null);
INSERT INTO tb_options VALUES (‘287’, ‘72’, ‘D’, ‘她’, ‘’, ‘2020-04-19 20:18:07’, null);
INSERT INTO tb_options VALUES (‘288’, ‘73’, ‘A’, ‘你’, ‘’, ‘2020-04-19 20:18:22’, null);
INSERT INTO tb_options VALUES (‘289’, ‘73’, ‘B’, ‘我’, ‘’, ‘2020-04-19 20:18:22’, null);
INSERT INTO tb_options VALUES (‘290’, ‘73’, ‘C’, ‘他’, ‘’, ‘2020-04-19 20:18:22’, null);
INSERT INTO tb_options VALUES (‘291’, ‘73’, ‘D’, ‘她’, ‘’, ‘2020-04-19 20:18:22’, null);
INSERT INTO tb_options VALUES (‘296’, ‘75’, ‘A’, ‘你’, ‘’, ‘2020-04-19 20:18:57’, null);
INSERT INTO tb_options VALUES (‘297’, ‘75’, ‘B’, ‘我’, ‘’, ‘2020-04-19 20:18:57’, null);
INSERT INTO tb_options VALUES (‘298’, ‘75’, ‘C’, ‘他’, ‘’, ‘2020-04-19 20:18:57’, null);
INSERT INTO tb_options VALUES (‘299’, ‘75’, ‘D’, ‘她’, ‘’, ‘2020-04-19 20:18:57’, null);
INSERT INTO tb_options VALUES (‘300’, ‘76’, ‘A’, ‘你’, ‘’, ‘2020-04-19 20:19:20’, null);
INSERT INTO tb_options VALUES (‘301’, ‘76’, ‘B’, ‘我’, ‘’, ‘2020-04-19 20:19:20’, null);
INSERT INTO tb_options VALUES (‘302’, ‘76’, ‘C’, ‘它’, ‘’, ‘2020-04-19 20:19:20’, null);
INSERT INTO tb_options VALUES (‘303’, ‘76’, ‘D’, ‘她’, ‘’, ‘2020-04-19 20:19:20’, null);
INSERT INTO tb_options VALUES (‘304’, ‘77’, ‘A’, ‘你的’, ‘’, ‘2020-04-19 20:19:48’, null);
INSERT INTO tb_options VALUES (‘305’, ‘77’, ‘B’, ‘我的’, ‘’, ‘2020-04-19 20:19:48’, null);
INSERT INTO tb_options VALUES (‘306’, ‘77’, ‘C’, ‘它的’, ‘’, ‘2020-04-19 20:19:48’, null);
INSERT INTO tb_options VALUES (‘307’, ‘77’, ‘D’, ‘她的’, ‘’, ‘2020-04-19 20:19:48’, null);
INSERT INTO tb_options VALUES (‘308’, ‘78’, ‘A’, ‘你的’, ‘’, ‘2020-04-19 20:20:04’, null);
INSERT INTO tb_options VALUES (‘309’, ‘78’, ‘B’, ‘我的’, ‘’, ‘2020-04-19 20:20:04’, null);
INSERT INTO tb_options VALUES (‘310’, ‘78’, ‘C’, ‘它的’, ‘’, ‘2020-04-19 20:20:04’, null);
INSERT INTO tb_options VALUES (‘311’, ‘78’, ‘D’, ‘她的’, ‘’, ‘2020-04-19 20:20:04’, null);
INSERT INTO tb_options VALUES (‘312’, ‘79’, ‘A’, ‘你的’, ‘’, ‘2020-04-19 20:20:26’, null);
INSERT INTO tb_options VALUES (‘313’, ‘79’, ‘B’, ‘他的’, ‘’, ‘2020-04-19 20:20:26’, null);
INSERT INTO tb_options VALUES (‘314’, ‘79’, ‘C’, ‘它的’, ‘’, ‘2020-04-19 20:20:26’, null);
INSERT INTO tb_options VALUES (‘315’, ‘79’, ‘D’, ‘她的’, ‘’, ‘2020-04-19 20:20:26’, null);
INSERT INTO tb_options VALUES (‘316’, ‘80’, ‘A’, ‘你的’, ‘’, ‘2020-04-19 20:20:48’, null);
INSERT INTO tb_options VALUES (‘317’, ‘80’, ‘B’, ‘他的’, ‘’, ‘2020-04-19 20:20:48’, null);
INSERT INTO tb_options VALUES (‘318’, ‘80’, ‘C’, ‘它的’, ‘’, ‘2020-04-19 20:20:48’, null);
INSERT INTO tb_options VALUES (‘319’, ‘80’, ‘D’, ‘她的’, ‘’, ‘2020-04-19 20:20:48’, null);
INSERT INTO tb_options VALUES (‘320’, ‘81’, ‘A’, ‘你的’, ‘’, ‘2020-04-19 20:21:29’, null);
INSERT INTO tb_options VALUES (‘321’, ‘81’, ‘B’, ‘他的’, ‘’, ‘2020-04-19 20:21:29’, null);
INSERT INTO tb_options VALUES (‘322’, ‘81’, ‘C’, ‘它的’, ‘’, ‘2020-04-19 20:21:29’, null);
INSERT INTO tb_options VALUES (‘323’, ‘81’, ‘D’, ‘她的’, ‘’, ‘2020-04-19 20:21:29’, null);
INSERT INTO tb_options VALUES (‘324’, ‘74’, ‘A’, ‘你’, ‘’, ‘2020-04-19 20:21:56’, null);
INSERT INTO tb_options VALUES (‘325’, ‘74’, ‘B’, ‘我’, ‘’, ‘2020-04-19 20:21:56’, null);
INSERT INTO tb_options VALUES (‘326’, ‘74’, ‘C’, ‘他’, ‘’, ‘2020-04-19 20:21:56’, null);
INSERT INTO tb_options VALUES (‘327’, ‘74’, ‘D’, ‘她’, ‘’, ‘2020-04-19 20:21:56’, null);
INSERT INTO tb_options VALUES (‘328’, ‘82’, ‘A’, ‘杜甫’, ‘’, ‘2020-04-19 20:23:46’, null);
INSERT INTO tb_options VALUES (‘329’, ‘82’, ‘B’, ‘李白’, ‘’, ‘2020-04-19 20:23:46’, null);
INSERT INTO tb_options VALUES (‘330’, ‘82’, ‘C’, ‘孟浩然’, ‘’, ‘2020-04-19 20:23:46’, null);
INSERT INTO tb_options VALUES (‘331’, ‘82’, ‘D’, ‘王之涣’, ‘’, ‘2020-04-19 20:23:46’, null);
INSERT INTO tb_options VALUES (‘332’, ‘83’, ‘A’, ‘杜甫’, ‘’, ‘2020-04-19 20:24:02’, null);
INSERT INTO tb_options VALUES (‘333’, ‘83’, ‘B’, ‘李白’, ‘’, ‘2020-04-19 20:24:02’, null);
INSERT INTO tb_options VALUES (‘334’, ‘83’, ‘C’, ‘孟浩然’, ‘’, ‘2020-04-19 20:24:02’, null);
INSERT INTO tb_options VALUES (‘335’, ‘83’, ‘D’, ‘王之涣’, ‘’, ‘2020-04-19 20:24:02’, null);
INSERT INTO tb_options VALUES (‘336’, ‘84’, ‘A’, ‘杜甫’, ‘’, ‘2020-04-19 20:24:26’, null);
INSERT INTO tb_options VALUES (‘337’, ‘84’, ‘B’, ‘李白’, ‘’, ‘2020-04-19 20:24:26’, null);
INSERT INTO tb_options VALUES (‘338’, ‘84’, ‘C’, ‘孟浩然’, ‘’, ‘2020-04-19 20:24:26’, null);
INSERT INTO tb_options VALUES (‘339’, ‘84’, ‘D’, ‘王之涣’, ‘’, ‘2020-04-19 20:24:26’, null);
INSERT INTO tb_options VALUES (‘340’, ‘85’, ‘A’, ‘杜甫’, ‘’, ‘2020-04-19 20:25:02’, null);
INSERT INTO tb_options VALUES (‘341’, ‘85’, ‘B’, ‘李白’, ‘’, ‘2020-04-19 20:25:02’, null);
INSERT INTO tb_options VALUES (‘342’, ‘85’, ‘C’, ‘孟浩然’, ‘’, ‘2020-04-19 20:25:02’, null);
INSERT INTO tb_options VALUES (‘343’, ‘85’, ‘D’, ‘王之涣’, ‘’, ‘2020-04-19 20:25:02’, null);
INSERT INTO tb_options VALUES (‘344’, ‘86’, ‘A’, ‘杜甫’, ‘’, ‘2020-04-19 20:25:43’, null);
INSERT INTO tb_options VALUES (‘345’, ‘86’, ‘B’, ‘李白’, ‘’, ‘2020-04-19 20:25:43’, null);
INSERT INTO tb_options VALUES (‘346’, ‘86’, ‘C’, ‘孟浩然’, ‘’, ‘2020-04-19 20:25:43’, null);
INSERT INTO tb_options VALUES (‘347’, ‘86’, ‘D’, ‘王之涣’, ‘’, ‘2020-04-19 20:25:43’, null);
INSERT INTO tb_options VALUES (‘348’, ‘87’, ‘A’, ‘冲出’, ‘’, ‘2020-04-19 20:29:40’, null);
INSERT INTO tb_options VALUES (‘349’, ‘87’, ‘B’, ‘太阳’, ‘’, ‘2020-04-19 20:29:40’, null);
INSERT INTO tb_options VALUES (‘350’, ‘87’, ‘C’, ‘飞向’, ‘’, ‘2020-04-19 20:29:40’, null);
INSERT INTO tb_options VALUES (‘351’, ‘87’, ‘D’, ‘月亮’, ‘’, ‘2020-04-19 20:29:40’, null);
INSERT INTO tb_options VALUES (‘352’, ‘88’, ‘A’, ‘冲出’, ‘’, ‘2020-04-19 20:30:07’, null);
INSERT INTO tb_options VALUES (‘353’, ‘88’, ‘B’, ‘太阳’, ‘’, ‘2020-04-19 20:30:07’, null);
INSERT INTO tb_options VALUES (‘354’, ‘88’, ‘C’, ‘飞向’, ‘’, ‘2020-04-19 20:30:07’, null);
INSERT INTO tb_options VALUES (‘355’, ‘88’, ‘D’, ‘月亮’, ‘’, ‘2020-04-19 20:30:07’, null);
INSERT INTO tb_options VALUES (‘356’, ‘89’, ‘A’, ‘飞快的’, ‘’, ‘2020-04-19 20:31:05’, null);
INSERT INTO tb_options VALUES (‘357’, ‘89’, ‘B’, ‘温暖的’, ‘’, ‘2020-04-19 20:31:05’, null);
INSERT INTO tb_options VALUES (‘358’, ‘89’, ‘C’, ‘快速地’, ‘’, ‘2020-04-19 20:31:05’, null);
INSERT INTO tb_options VALUES (‘359’, ‘89’, ‘D’, ‘残酷的’, ‘’, ‘2020-04-19 20:31:05’, null);
INSERT INTO tb_options VALUES (‘360’, ‘90’, ‘A’, ‘缓慢地’, ‘’, ‘2020-04-19 20:32:15’, null);
INSERT INTO tb_options VALUES (‘361’, ‘90’, ‘B’, ‘奇怪的’, ‘’, ‘2020-04-19 20:32:15’, null);
INSERT INTO tb_options VALUES (‘362’, ‘90’, ‘C’, ‘快速地’, ‘’, ‘2020-04-19 20:32:15’, null);
INSERT INTO tb_options VALUES (‘363’, ‘90’, ‘D’, ‘痛苦地’, ‘’, ‘2020-04-19 20:32:15’, null);
INSERT INTO tb_options VALUES (‘364’, ‘91’, ‘A’, ‘夜以继日’, ‘’, ‘2020-04-19 20:34:27’, null);
INSERT INTO tb_options VALUES (‘365’, ‘91’, ‘B’, ‘拔苗助长’, ‘’, ‘2020-04-19 20:34:27’, null);
INSERT INTO tb_options VALUES (‘366’, ‘91’, ‘C’, ‘快速奔跑’, ‘’, ‘2020-04-19 20:34:27’, null);
INSERT INTO tb_options VALUES (‘367’, ‘91’, ‘D’, ‘痛心疾首’, ‘’, ‘2020-04-19 20:34:27’, null);
INSERT INTO tb_options VALUES (‘368’, ‘92’, ‘A’, ‘一氧化碳’, ‘’, ‘2020-04-19 20:44:07’, null);
INSERT INTO tb_options VALUES (‘369’, ‘92’, ‘B’, ‘二氧化碳’, ‘’, ‘2020-04-19 20:44:07’, null);
INSERT INTO tb_options VALUES (‘370’, ‘92’, ‘C’, ‘氧气’, ‘’, ‘2020-04-19 20:44:07’, null);
INSERT INTO tb_options VALUES (‘371’, ‘92’, ‘D’, ‘二氧化氮’, ‘’, ‘2020-04-19 20:44:07’, null);
INSERT INTO tb_options VALUES (‘372’, ‘93’, ‘A’, ‘氧气’, ‘’, ‘2020-04-19 20:46:37’, null);
INSERT INTO tb_options VALUES (‘373’, ‘93’, ‘B’, ‘氮气’, ‘’, ‘2020-04-19 20:46:37’, null);
INSERT INTO tb_options VALUES (‘374’, ‘93’, ‘C’, ‘稀有气体’, ‘’, ‘2020-04-19 20:46:37’, null);
INSERT INTO tb_options VALUES (‘375’, ‘93’, ‘D’, ‘二氧化碳’, ‘’, ‘2020-04-19 20:46:37’, null);
INSERT INTO tb_options VALUES (‘376’, ‘94’, ‘A’, ‘氧气’, ‘’, ‘2020-04-19 20:47:03’, null);
INSERT INTO tb_options VALUES (‘377’, ‘94’, ‘B’, ‘氮气’, ‘’, ‘2020-04-19 20:47:03’, null);
INSERT INTO tb_options VALUES (‘378’, ‘94’, ‘C’, ‘稀有气体’, ‘’, ‘2020-04-19 20:47:03’, null);
INSERT INTO tb_options VALUES (‘379’, ‘94’, ‘D’, ‘二氧化碳’, ‘’, ‘2020-04-19 20:47:03’, null);
INSERT INTO tb_options VALUES (‘380’, ‘95’, ‘A’, ‘食物变臭’, ‘’, ‘2020-04-19 20:49:41’, null);
INSERT INTO tb_options VALUES (‘381’, ‘95’, ‘B’, ‘冰雪融化’, ‘’, ‘2020-04-19 20:49:41’, null);
INSERT INTO tb_options VALUES (‘382’, ‘95’, ‘C’, ‘灯泡发光’, ‘’, ‘2020-04-19 20:49:41’, null);
INSERT INTO tb_options VALUES (‘383’, ‘95’, ‘D’, ‘合成塑料’, ‘’, ‘2020-04-19 20:49:41’, null);
INSERT INTO tb_options VALUES (‘384’, ‘96’, ‘A’, ‘食物变臭’, ‘’, ‘2020-04-19 20:50:57’, null);
INSERT INTO tb_options VALUES (‘385’, ‘96’, ‘B’, ‘冰雪融化’, ‘’, ‘2020-04-19 20:50:57’, null);
INSERT INTO tb_options VALUES (‘386’, ‘96’, ‘C’, ‘灯泡发光’, ‘’, ‘2020-04-19 20:50:57’, null);
INSERT INTO tb_options VALUES (‘387’, ‘96’, ‘D’, ‘橡皮泥变形’, ‘’, ‘2020-04-19 20:50:57’, null);
INSERT INTO tb_options VALUES (‘388’, ‘97’, ‘A’, ‘双氧水’, ‘’, ‘2020-04-19 20:53:50’, null);
INSERT INTO tb_options VALUES (‘389’, ‘97’, ‘B’, ‘二氧化锰’, ‘’, ‘2020-04-19 20:53:50’, null);
INSERT INTO tb_options VALUES (‘390’, ‘97’, ‘C’, ‘硫酸铜’, ‘’, ‘2020-04-19 20:53:50’, null);
INSERT INTO tb_options VALUES (‘391’, ‘97’, ‘D’, ‘镁’, ‘’, ‘2020-04-19 20:53:50’, null);
INSERT INTO tb_options VALUES (‘392’, ‘98’, ‘A’, ‘双氧水’, ‘’, ‘2020-04-19 20:55:09’, null);
INSERT INTO tb_options VALUES (‘393’, ‘98’, ‘B’, ‘二氧化锰’, ‘’, ‘2020-04-19 20:55:09’, null);
INSERT INTO tb_options VALUES (‘394’, ‘98’, ‘C’, ‘硫酸铜’, ‘’, ‘2020-04-19 20:55:09’, null);
INSERT INTO tb_options VALUES (‘395’, ‘98’, ‘D’, ‘一氧化碳’, ‘’, ‘2020-04-19 20:55:09’, null);
INSERT INTO tb_options VALUES (‘396’, ‘99’, ‘A’, ‘氧’, ‘’, ‘2020-04-19 20:56:45’, null);
INSERT INTO tb_options VALUES (‘397’, ‘99’, ‘B’, ‘氮’, ‘’, ‘2020-04-19 20:56:45’, null);
INSERT INTO tb_options VALUES (‘398’, ‘99’, ‘C’, ‘碳’, ‘’, ‘2020-04-19 20:56:45’, null);
INSERT INTO tb_options VALUES (‘399’, ‘99’, ‘D’, ‘镁’, ‘’, ‘2020-04-19 20:56:45’, null);
INSERT INTO tb_options VALUES (‘400’, ‘100’, ‘A’, ‘氧’, ‘’, ‘2020-04-19 20:57:27’, null);
INSERT INTO tb_options VALUES (‘401’, ‘100’, ‘B’, ‘钙’, ‘’, ‘2020-04-19 20:57:27’, null);
INSERT INTO tb_options VALUES (‘402’, ‘100’, ‘C’, ‘碳’, ‘’, ‘2020-04-19 20:57:27’, null);
INSERT INTO tb_options VALUES (‘403’, ‘100’, ‘D’, ‘镁’, ‘’, ‘2020-04-19 20:57:27’, null);
INSERT INTO tb_options VALUES (‘404’, ‘101’, ‘A’, ‘氧’, ‘’, ‘2020-04-19 20:58:54’, null);
INSERT INTO tb_options VALUES (‘405’, ‘101’, ‘B’, ‘钙’, ‘’, ‘2020-04-19 20:58:54’, null);
INSERT INTO tb_options VALUES (‘406’, ‘101’, ‘C’, ‘金’, ‘’, ‘2020-04-19 20:58:54’, null);
INSERT INTO tb_options VALUES (‘407’, ‘101’, ‘D’, ‘镁’, ‘’, ‘2020-04-19 20:58:54’, null);
INSERT INTO tb_options VALUES (‘416’, ‘104’, ‘A’, ‘违规行为’, ‘’, ‘2020-05-23 22:48:48’, null);
INSERT INTO tb_options VALUES (‘417’, ‘104’, ‘B’, ‘违章行为’, ‘’, ‘2020-05-23 22:48:48’, null);
INSERT INTO tb_options VALUES (‘418’, ‘104’, ‘C’, ‘违法行为’, ‘’, ‘2020-05-23 22:48:48’, null);
INSERT INTO tb_options VALUES (‘419’, ‘104’, ‘D’, ‘犯罪行为’, ‘’, ‘2020-05-23 22:48:48’, null);
INSERT INTO tb_options VALUES (‘428’, ‘107’, ‘A’, ‘红色小型客车（E）行驶车道是正确的’, ‘’, ‘2020-06-04 14:15:31’, null);
INSERT INTO tb_options VALUES (‘429’, ‘107’, ‘B’, ‘灰色小型客车（A）行驶车道是正确的’, ‘’, ‘2020-06-04 14:15:31’, null);
INSERT INTO tb_options VALUES (‘430’, ‘107’, ‘C’, ‘黄色小型客车（B）行驶车道是正确的’, ‘’, ‘2020-06-04 14:15:31’, null);
INSERT INTO tb_options VALUES (‘431’, ‘107’, ‘D’, ‘蓝色小型客车（C）行驶车道是正确的’, ‘’, ‘2020-06-04 14:15:31’, null);
INSERT INTO tb_options VALUES (‘432’, ‘108’, ‘A’, ‘B车自负责任’, ‘’, ‘2020-06-04 14:17:49’, null);
INSERT INTO tb_options VALUES (‘433’, ‘108’, ‘B’, ‘A车负全部责任’, ‘’, ‘2020-06-04 14:17:49’, null);
INSERT INTO tb_options VALUES (‘434’, ‘108’, ‘C’, ‘各负一半责任’, ‘’, ‘2020-06-04 14:17:49’, null);
INSERT INTO tb_options VALUES (‘435’, ‘108’, ‘D’, ‘偶然事件，不可避免’, ‘’, ‘2020-06-04 14:17:49’, null);
INSERT INTO tb_options VALUES (‘436’, ‘109’, ‘A’, ‘沿左侧车道掉头’, ‘’, ‘2020-06-04 14:19:36’, null);
INSERT INTO tb_options VALUES (‘437’, ‘109’, ‘B’, ‘该路口不能掉头’, ‘’, ‘2020-06-04 14:19:36’, null);
INSERT INTO tb_options VALUES (‘438’, ‘109’, ‘C’, ‘选择中间车道掉头’, ‘’, ‘2020-06-04 14:19:36’, null);
INSERT INTO tb_options VALUES (‘439’, ‘109’, ‘D’, ‘在路口内掉头’, ‘’, ‘2020-06-04 14:19:36’, null);
INSERT INTO tb_options VALUES (‘440’, ‘110’, ‘A’, ‘强行从右侧超车’, ‘’, ‘2020-06-04 14:21:34’, null);
INSERT INTO tb_options VALUES (‘441’, ‘110’, ‘B’, ‘越黄线行驶’, ‘’, ‘2020-06-04 14:21:34’, null);
INSERT INTO tb_options VALUES (‘442’, ‘110’, ‘C’, ‘占用专用车道’, ‘’, ‘2020-06-04 14:21:34’, null);
INSERT INTO tb_options VALUES (‘443’, ‘110’, ‘D’, ‘未开启右转向灯’, ‘’, ‘2020-06-04 14:21:34’, null);
INSERT INTO tb_options VALUES (‘444’, ‘111’, ‘A’, ‘警告标志’, ‘’, ‘2020-06-04 14:23:13’, null);
INSERT INTO tb_options VALUES (‘445’, ‘111’, ‘B’, ‘禁令标志’, ‘’, ‘2020-06-04 14:23:13’, null);
INSERT INTO tb_options VALUES (‘446’, ‘111’, ‘C’, ‘指示标志’, ‘’, ‘2020-06-04 14:23:13’, null);
INSERT INTO tb_options VALUES (‘447’, ‘111’, ‘D’, ‘指路标志’, ‘’, ‘2020-06-04 14:23:13’, null);
INSERT INTO tb_options VALUES (‘448’, ‘112’, ‘A’, ‘涵洞’, ‘’, ‘2020-06-04 14:24:45’, null);
INSERT INTO tb_options VALUES (‘449’, ‘112’, ‘B’, ‘水渠’, ‘’, ‘2020-06-04 14:24:45’, null);
INSERT INTO tb_options VALUES (‘450’, ‘112’, ‘C’, ‘桥梁’, ‘’, ‘2020-06-04 14:24:45’, null);
INSERT INTO tb_options VALUES (‘451’, ‘112’, ‘D’, ‘隧道’, ‘’, ‘2020-06-04 14:24:45’, null);
INSERT INTO tb_options VALUES (‘452’, ‘113’, ‘A’, ‘高速公路界牌编号’, ‘’, ‘2020-06-04 14:26:45’, null);
INSERT INTO tb_options VALUES (‘453’, ‘113’, ‘B’, ‘高速公路里程编号’, ‘’, ‘2020-06-04 14:26:45’, null);
INSERT INTO tb_options VALUES (‘454’, ‘113’, ‘C’, ‘高速公路命名编号’, ‘’, ‘2020-06-04 14:26:45’, null);
INSERT INTO tb_options VALUES (‘455’, ‘113’, ‘D’, ‘高速公路路段编号’, ‘’, ‘2020-06-04 14:26:45’, null);
INSERT INTO tb_options VALUES (‘456’, ‘114’, ‘A’, ‘图1’, ‘’, ‘2020-06-04 14:32:58’, null);
INSERT INTO tb_options VALUES (‘457’, ‘114’, ‘B’, ‘图2’, ‘’, ‘2020-06-04 14:32:58’, null);
INSERT INTO tb_options VALUES (‘458’, ‘114’, ‘C’, ‘图3’, ‘’, ‘2020-06-04 14:32:58’, null);
INSERT INTO tb_options VALUES (‘459’, ‘114’, ‘D’, ‘图4’, ‘’, ‘2020-06-04 14:32:58’, null);
INSERT INTO tb_options VALUES (‘460’, ‘115’, ‘A’, ‘两侧变窄’, ‘’, ‘2020-06-04 14:34:40’, null);
INSERT INTO tb_options VALUES (‘461’, ‘115’, ‘B’, ‘右侧变窄’, ‘’, ‘2020-06-04 14:34:40’, null);
INSERT INTO tb_options VALUES (‘462’, ‘115’, ‘C’, ‘左侧变窄’, ‘’, ‘2020-06-04 14:34:40’, null);
INSERT INTO tb_options VALUES (‘463’, ‘115’, ‘D’, ‘桥面变窄’, ‘’, ‘2020-06-04 14:34:40’, null);

– Table structure for tb_question

DROP TABLE IF EXISTS tb_question;
CREATE TABLE tb_question (
id int(11) NOT NULL AUTO_INCREMENT,
subject int(2) DEFAULT NULL COMMENT ‘科目’,
title varchar(2000) DEFAULT NULL COMMENT ‘题目’,
analysis text COMMENT ‘解析’,
type int(2) DEFAULT NULL COMMENT ‘题型。1：单选；2：多选，3：其他’,
answer varchar(50) DEFAULT NULL COMMENT ‘答案，多选用,分割’,
attachment varchar(1000) DEFAULT NULL COMMENT ‘图片’,
create_time datetime DEFAULT NULL,
update_time datetime DEFAULT NULL,
difficulty int(2) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COMMENT=‘题库表’;

– Records of tb_question

INSERT INTO tb_question VALUES (‘62’, ‘1’, ‘1+1=？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:07:47’, null, ‘0’);
INSERT INTO tb_question VALUES (‘63’, ‘1’, ‘1+2=？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:09:33’, null, ‘0’);
INSERT INTO tb_question VALUES (‘64’, ‘1’, ‘1+3=？’, ‘’, ‘1’, ‘D’, null, ‘2020-04-19 20:09:52’, null, ‘0’);
INSERT INTO tb_question VALUES (‘65’, ‘1’, ‘1+4=？’, ‘’, ‘1’, ‘B’, null, ‘2020-04-19 20:10:22’, null, ‘0’);
INSERT INTO tb_question VALUES (‘66’, ‘1’, ‘1+5=？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:10:40’, null, ‘0’);
INSERT INTO tb_question VALUES (‘67’, ‘1’, ‘下列结果为1的算式是？’, ‘’, ‘2’, ‘A,B’, null, ‘2020-04-19 20:13:07’, null, ‘0’);
INSERT INTO tb_question VALUES (‘68’, ‘1’, ‘下列结果为2的算式是？’, ‘’, ‘2’, ‘A,D’, null, ‘2020-04-19 20:13:46’, null, ‘0’);
INSERT INTO tb_question VALUES (‘69’, ‘1’, ‘下列结果为3的算式是？’, ‘’, ‘2’, ‘B’, null, ‘2020-04-19 20:14:30’, null, ‘0’);
INSERT INTO tb_question VALUES (‘70’, ‘1’, ‘下列结果为4的算式是？’, ‘’, ‘2’, ‘A,D’, null, ‘2020-04-19 20:14:58’, null, ‘0’);
INSERT INTO tb_question VALUES (‘71’, ‘1’, ‘下列结果为5的算式是？’, ‘’, ‘2’, ‘B,C’, null, ‘2020-04-19 20:15:24’, null, ‘0’);
INSERT INTO tb_question VALUES (‘72’, ‘1’, ‘i的汉语意思是什么？’, ‘’, ‘1’, ‘B’, null, ‘2020-04-19 20:18:07’, null, ‘1’);
INSERT INTO tb_question VALUES (‘73’, ‘1’, ‘you的汉语意思是什么？’, ‘’, ‘1’, ‘A’, null, ‘2020-04-19 20:18:22’, null, ‘1’);
INSERT INTO tb_question VALUES (‘74’, ‘1’, ‘she的汉语意思是什么？’, ‘’, ‘1’, ‘D’, null, ‘2020-04-19 20:18:35’, null, ‘1’);
INSERT INTO tb_question VALUES (‘75’, ‘1’, ‘he的汉语意思是什么？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:18:57’, null, ‘1’);
INSERT INTO tb_question VALUES (‘76’, ‘1’, ‘it的汉语意思是什么？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:19:20’, null, ‘1’);
INSERT INTO tb_question VALUES (‘77’, ‘1’, ‘my的汉语意思是什么？’, ‘’, ‘1’, ‘B,C’, null, ‘2020-04-19 20:19:48’, null, ‘1’);
INSERT INTO tb_question VALUES (‘78’, ‘1’, ‘her的汉语意思是什么？’, ‘’, ‘1’, ‘D’, null, ‘2020-04-19 20:20:04’, null, ‘1’);
INSERT INTO tb_question VALUES (‘79’, ‘1’, ‘his的汉语意思是什么？’, ‘’, ‘1’, ‘B’, null, ‘2020-04-19 20:20:26’, null, ‘1’);
INSERT INTO tb_question VALUES (‘80’, ‘1’, ‘its的汉语意思是什么？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:20:48’, null, ‘1’);
INSERT INTO tb_question VALUES (‘81’, ‘1’, ‘your的汉语意思是什么？’, ‘’, ‘1’, ‘A’, null, ‘2020-04-19 20:21:29’, null, ‘1’);
INSERT INTO tb_question VALUES (‘82’, ‘1’, ‘静夜思作者是谁？’, ‘’, ‘1’, ‘B’, null, ‘2020-04-19 20:23:46’, null, ‘2’);
INSERT INTO tb_question VALUES (‘83’, ‘1’, ‘春晓作者是谁？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:24:02’, null, ‘2’);
INSERT INTO tb_question VALUES (‘84’, ‘1’, ‘登黄鹤楼作者是谁？’, ‘’, ‘1’, ‘D’, null, ‘2020-04-19 20:24:26’, null, ‘2’);
INSERT INTO tb_question VALUES (‘85’, ‘1’, ‘望庐山瀑布作者是谁？’, ‘’, ‘1’, ‘B’, null, ‘2020-04-19 20:25:02’, null, ‘2’);
INSERT INTO tb_question VALUES (‘86’, ‘1’, ‘绝句-其一作者是谁？’, ‘’, ‘1’, ‘A’, null, ‘2020-04-19 20:25:43’, null, ‘2’);
INSERT INTO tb_question VALUES (‘87’, ‘1’, ‘下列不属于动词的是？’, ‘’, ‘1’, ‘B,D’, null, ‘2020-04-19 20:29:40’, null, ‘2’);
INSERT INTO tb_question VALUES (‘88’, ‘1’, ‘下列不属于名词的是？’, ‘’, ‘1’, ‘A,C’, null, ‘2020-04-19 20:30:07’, null, ‘2’);
INSERT INTO tb_question VALUES (‘89’, ‘1’, ‘下列不属于形容词的是？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:31:05’, null, ‘2’);
INSERT INTO tb_question VALUES (‘90’, ‘1’, ‘下列不属于副词的是？’, ‘’, ‘1’, ‘B’, null, ‘2020-04-19 20:32:15’, null, ‘2’);
INSERT INTO tb_question VALUES (‘91’, ‘1’, ‘下列不属于成语的是？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:34:27’, null, ‘2’);
INSERT INTO tb_question VALUES (‘92’, ‘1’, ‘下列气体有毒的是？’, ‘’, ‘1’, ‘A,D’, null, ‘2020-04-19 20:44:07’, null, ‘3’);
INSERT INTO tb_question VALUES (‘93’, ‘1’, ‘在空气中下列哪种气体含量最多？’, ‘’, ‘1’, ‘B’, null, ‘2020-04-19 20:46:37’, null, ‘3’);
INSERT INTO tb_question VALUES (‘94’, ‘1’, ‘在空气中下列哪种气体含量第二多？’, ‘’, ‘1’, ‘A’, null, ‘2020-04-19 20:47:03’, null, ‘3’);
INSERT INTO tb_question VALUES (‘95’, ‘1’, ‘下列哪些现象属于物理变化？’, ‘’, ‘1’, ‘B’, null, ‘2020-04-19 20:49:41’, null, ‘3’);
INSERT INTO tb_question VALUES (‘96’, ‘1’, ‘下列哪些现象属于化学变化？’, ‘’, ‘1’, ‘A,C’, null, ‘2020-04-19 20:50:57’, null, ‘3’);
INSERT INTO tb_question VALUES (‘97’, ‘1’, ‘下列可以制造氧气是？’, ‘’, ‘1’, ‘A,B’, null, ‘2020-04-19 20:53:50’, null, ‘3’);
INSERT INTO tb_question VALUES (‘98’, ‘1’, ‘下列有C元素的是？’, ‘’, ‘1’, ‘D’, null, ‘2020-04-19 20:55:09’, null, ‘3’);
INSERT INTO tb_question VALUES (‘99’, ‘1’, ‘下列元素属于金属元素的是？’, ‘’, ‘1’, ‘D’, null, ‘2020-04-19 20:56:45’, null, ‘3’);
INSERT INTO tb_question VALUES (‘100’, ‘1’, ‘下列元素不属于金属元素的是？’, ‘’, ‘1’, ‘A,C’, null, ‘2020-04-19 20:57:27’, null, ‘3’);
INSERT INTO tb_question VALUES (‘101’, ‘1’, ‘下列元素在自然界以单质存在的是？’, ‘’, ‘1’, ‘C’, null, ‘2020-04-19 20:58:54’, null, ‘3’);
INSERT INTO tb_question VALUES (‘104’, ‘1’, ‘驾驶这种机动车属于什么行为？’, ‘遮挡车牌属于违法行为。’, ‘1’, ‘C’, ‘assets/upload/question/1590245327768.png’, ‘2020-05-23 22:48:48’, null, ‘4’);
INSERT INTO tb_question VALUES (‘107’, ‘1’, ‘在图中所示有车道信号灯的路段，请判断哪辆机动车行驶的车道是正确的？’, ‘通行指示灯为绿色才可以通行。’, ‘1’, ‘D’, ‘assets/upload/question/1591251331182.jpg’, ‘2020-06-04 14:15:31’, null, ‘4’);
INSERT INTO tb_question VALUES (‘108’, ‘1’, ‘如图所示，A车货物掉落，导致B车与掉落货物发生碰撞，以下说法正确的是什么？’, ‘A车（货车）转载货物不合规定。’, ‘1’, ‘B’, ‘assets/upload/question/1591251469443.jpg’, ‘2020-06-04 14:17:49’, null, ‘4’);
INSERT INTO tb_question VALUES (‘109’, ‘1’, ‘遇到这种情况的路口，以下做法正确的是什么？’, ‘禁止掉头的标志。’, ‘1’, ‘B’, ‘assets/upload/question/1591251576219.jpg’, ‘2020-06-04 14:19:36’, null, ‘4’);
INSERT INTO tb_question VALUES (‘110’, ‘1’, ‘请判断一下图中这辆黄色小型客车的违法行为是什么？’, ‘占用公共汽车车道。’, ‘1’, ‘C’, ‘assets/upload/question/1591251694287.jpg’, ‘2020-06-04 14:21:34’, null, ‘4’);
INSERT INTO tb_question VALUES (‘111’, ‘1’, ‘这属于哪一类标志？’, ‘指示路口的信息。’, ‘1’, ‘D’, ‘assets/upload/question/1591251793199.jpg’, ‘2020-06-04 14:23:13’, null, ‘4’);
INSERT INTO tb_question VALUES (‘112’, ‘1’, ‘这个标志是何含义？’, ‘进入隧道的标志。’, ‘1’, ‘D’, ‘assets/upload/question/1591251884879.jpg’, ‘2020-06-04 14:24:45’, null, ‘4’);
INSERT INTO tb_question VALUES (‘113’, ‘1’, ‘这个标志是何含义？’, ‘G为国家高速公路路段编号。’, ‘1’, ‘D’, ‘assets/upload/question/1591252004521.jpg’, ‘2020-06-04 14:26:45’, null, ‘4’);
INSERT INTO tb_question VALUES (‘114’, ‘1’, ‘图中哪个报警灯亮，提示发动机控制系统异常或故障？’, ‘发动机外形，里面有check字样。’, ‘1’, ‘C’, ‘assets/upload/question/1591252377560.jpg’, ‘2020-06-04 14:32:58’, null, ‘4’);
INSERT INTO tb_question VALUES (‘115’, ‘1’, ‘这是什么交通标志？’, ‘显然两侧逐渐变窄了。’, ‘1’, ‘A’, ‘assets/upload/question/1591252479762.jpg’, ‘2020-06-04 14:34:40’, null, ‘4’);

大理的小白白
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
在线考试系统系统架构说明
06-17
1. 新闻管理：（1）新闻发布（发布新的新闻） （2）新闻的编辑（修改，删除） 2. 题库管理 （1）题库类型管理（添加，修改，删除） （2）添加新题（单选，多选，填空，简答） （3）编辑题库（修改，删除） 3． 试卷管理 （1）试卷查询 （2）试卷编辑（添加，修改，删除） 4． 阅卷管理 （1）待阅部门
[附源码]计算机毕业设计学生在线考试系统Springboot程序
计算机程序源码
12-03 376
项目运行环境配置：Jdk1.8 + Tomcat7.0 + Mysql + HBuilderX（Webstorm也行）+ Eclispe（IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持）。项目技术：SSM + mybatis + Maven + Vue 等等组成，B/S模式 + Maven管理等等。环境需要1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
在线考试系统
程序猿麦小七
11-20 1494
在线考试系统”是集合现代考试理论、方法和现代信息技术手段的智能化网上考试系统，为学生个性化学习提供“灵活、方便、科学、公平”的“个别化考试服务”，是终结性评价系统。没有合适的类型或系统?在线考试系统现在应用非常广泛，能适用于大、中、小学的学生考试以及试卷的批改和成绩的统计分析中，相对于计算机和外语学科非常实用。本文内文研究的是通过构建在线考试系统利用学校的教师笔试进行管理化，通过调查和分析现在系统考试相关信息，综合评价了我国考试现状和以及今后的发展趋势，进而提出了比较好的在线考试系统策略和方案。
线上在线考试系统设计与实现
杭州.黄老师
02-12 3513
本课题主要目标是设计并能够实现一个在线考试的java系统，整体使用了基于浏览器的B/S架构，技术上使用了基于java的springboot框架；使用浏览器，通过后台添加考试题目，学生通过浏览器登录和参与考试，帮助学生提高学习效率、提升学生理解能力。：现在传统的考试方式：由老师纸上出题，学生纸上答题，老师人工阅卷，以及人工试卷分析四大步骤组成。这样做一是给老师带来工作上的繁琐，不利于老师工作效率的提高；二是人工的考试方式由于工作量大从而容易出错；三是人为因素的不确定性，可能会造成选题范围过于狭窄。
.Net在线考试系统源码
04-13
在线考试系统的功能实现，登陆验证、权限管理等，欢迎下载 二、功能介绍 本源码是一个在线考试系统源码，分为学生界面和管理员界面两种登陆方式，实现不同权限 三、菜单功能 学生界面 1、我的考试：参加考试；...
4、【SpringBoot项目】在线考试系统源码.zip
03-05
项目名称：在线考试系统 （mysql脚本文件在项目根目录下）  开发环境：Tomcat9.0 Mysql8 springboot、springmvc、mybatis、thymeleaf、bootstrap、maven、druid、jquery、ajax、layer、lombok、 devtools、...
在线考试系统网站源码
03-08
这是一款相对比较完整的在线考试系统，采用了典型的三层架构模式，这次主要修改了 源码当中的一些bug，该源码可以作为课程设计使用，也比较适合学习交流使用，有需要的 可以下载看看。 二、功能介绍 1、个人信息...
基于Jsp 网络在线考试系统源码，Java
03-25
基于Jsp 网络在线考试系统源码，Java。 本系统为基于JSP的网络在线考试系统，功能： 1、注册 (学生) 注册信息包括登录帐号、姓名、性别、年龄、班级、任课老师。 2、参加考试 (学生) 从试卷列表中选择考试卷，考试卷...
java 在线考试系统源码(含数据库脚本).rar
06-23
业务描述：根据前面所做的需求分析及用户的需求可知，网络在线考试系统属于中小型软件，在系统实施后应达到以下目标。 1，具有空间性。被授权的用户可以在异地登录网络在线考试系统，而无须到指定地点进行考试。 2，...
在线考试系统源码
06-15
使用SSH框架写的一个在线考试系统，功能已基本完善，使用MySQL数据库，使用时将源码导入到eclipse，在MySQL中导入SQL文件，数据库默认密码为root，可以在ots\src\applicationContex.xml文件中进行配置。
mvc模式在线考试系统
12-21
经典mvc开发模式的在线考试系统，其中用到jquery、ajax局部刷新等，数据库用的MySql，压缩包中包含代码加数据库脚本，需先创建etest数据库再倒入数据
Mybatis-SpringMVC在线考试系统源码
05-29
本人毕业所用系统源码。基于SSM，很简单的例子，功能可能少，但是架构是全的，可作为搭建环境的参考.
在线考试系统(全部源码)
05-14
系统介绍 为了保障整个系统的安全性，在线考试系统实现了分类验证的登录模块，通过此模块，可以对不同身份的登录用户进行验证，确保了不同身份的用户操作系统。在抽取试题上，系统使用随机抽取试题的方式，体现了考试的客观与公正。当考生答题完毕之后，提交试卷即可得知本次考试的得分，体现系统的高效性。在后台管理上，分后台管理员管理模块和试题管理模块。分别适应不同的用户，前者只有系统的高级管理员才能进入，对整个系统进行管理。而后者只允许教师登录，教师可以对自己任教的科目试题进行修改，并且可以查看所有参加过自己任教科目的学生成绩。
[源代码] C# ASP.NET 项目实战 - 在线考试系统
08-14
☆☆ 资源说明：☆☆ ☆ 系统功能：☆ 系统采用人机交互方式，界面美观友好，信息查询灵活、方便，数据存储安全可靠； 实现从数据库中随机抽取试题； 对用户输入的数据进行严格的数据检验，尽可能地避免人为错误； 实现对考试结果自动评分； 实现教师和后台管理员对试题信息单独管理； 系统最大限度地实现了易维护性和易操作性
基于springboot学生管理系统设计与实现
weixin_2630663675的博客
11-18 2817
基于springboot学生信息管理系统
Java实现在线考试系统（系统介绍）
热门推荐
灵魂漫步的博客
06-19 5万+
1.和现在有的考试系统有以下几种优势： a.和现在有的系统比较起来，本系统有科目、章节、老师、学生、班级等信息的管理，还有批阅试卷查看已批阅试卷等。传统的考试系统划分并不细，业务功能简单。 b.和学校的考试系统还有外面的考试系统比较起来，本系统是B/S结构，学校的考试系统一般为C/S结构，性能方面不如B/S结构，并且C/S接口需要安装客户端，客户端压力很大，我的系统只需要电脑具有浏览器，在同一...
在线考试系统需求分析
monder_monster的博客
10-24 3万+
一、功能需求概述 1.1.目标 描述：下面就对在线考试系统的设计进行需求分析。 首先，系统开发的时候考虑到对象的特殊性质，所以对象在进入该系统的时候，要对其进行身份的验证。如果对象第一次使用该系统的时候，要进行注册，再次进入时候就可以直接登录。学生可以选择相对应的科目的题目进行答题。为了做到考试的规范性，学生随机抽到的试题题型一致，但会稍作修改。基于网络环境的条件下进行在线答题考试，试卷应该...
Java实现在线考试系统（学生功能）
灵魂漫步的博客
06-09 5万+
学生模块功能比较少，就是进行考试和查看自己成绩两个大的功能。 学生进行考试的功能比较复杂（首先做了校验，不在考试时间范围内，不能进行考试） 考试试题是数据库根据发布考试时的条件随机产生的一套试题。因为每次考试题型题量都是不同的，因此我们继续采用JSON的格式去保存数据，当状态为1:表示正在考试； 状态为2:表示已经考试结束；状态为3:表示老师已经阅完试卷 （1）当考试考试的时候...
php在线考试系统源码
最新发布
05-13
PHP在线考试系统源码是一种用PHP语言编写的...总的来说，PHP在线考试系统源码是一个简单实用、功能完善的在线考试系统，可以满足不同机构的各种考试需求，有助于提高考试的效率，简化考试流程，让考试更加科学有效。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值