master

分支 (1)

管理

管理

master

student
/
student_mis.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           : localhost:3306
 Source Schema         : student_mis

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 25/05/2020 16:51:49
*/

create database student_mis;
use student_mis;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `level` tinyint(4) NOT NULL DEFAULT 0,
  `school` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0',
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `sex` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, 'root', 'password', '庄江辉', 0, '福建工程学院', '1174683095@qq.com', '15659441699', 0, '2020-03-28 15:06:24');

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '编号',
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程名',
  `credits` decimal(4, 1) NOT NULL DEFAULT 2.0 COMMENT '学分',
  `score` int(11) NOT NULL DEFAULT 100 COMMENT '满分',
  `number` int(4) NOT NULL DEFAULT 32 COMMENT '课时',
  `year` int(6) NOT NULL DEFAULT 2016 COMMENT '届时',
  `term` tinyint(4) NOT NULL DEFAULT 0 COMMENT '学期',
  `type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '类别 1必修 2选修',
  `profession` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '专业',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES ('2016011001', '数字电路基础', 4.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:06');
INSERT INTO `course` VALUES ('2016011002', '大学物理', 4.0, 100, 20, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:05');
INSERT INTO `course` VALUES ('2016011003', '线性代数', 1.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:04');
INSERT INTO `course` VALUES ('2016011004', '复变函数', 2.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:03');
INSERT INTO `course` VALUES ('2016011005', '模拟电子线路', 4.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:02');
INSERT INTO `course` VALUES ('2016011006', '信号与系统', 2.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:01');
INSERT INTO `course` VALUES ('2016011007', '大学英语', 4.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:07');
INSERT INTO `course` VALUES ('2016011008', '体育', 1.0, 100, 16, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:08');
INSERT INTO `course` VALUES ('2016011009', '电子技术', 2.0, 100, 16, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:09');
INSERT INTO `course` VALUES ('2016011010', '多媒体技术', 2.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:10');
INSERT INTO `course` VALUES ('2016021001', '物联网工程导论', 2.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:36:10');
INSERT INTO `course` VALUES ('2016021002', '物联网安全', 2.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:40:55');
INSERT INTO `course` VALUES ('2016021003', '现代通信技术', 1.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:47:11');
INSERT INTO `course` VALUES ('2016021004', '无线传感器网络', 4.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:51:16');
INSERT INTO `course` VALUES ('2016021005', '现代传感器技术', 2.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:52:23');
INSERT INTO `course` VALUES ('2016021006', '信号与系统概论', 2.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:53:33');
INSERT INTO `course` VALUES ('2016031001', '计算机网络技术', 1.0, 100, 18, 2016, 1, 1, '计算机', '2020-05-04 21:54:51');
INSERT INTO `course` VALUES ('2016031002', '网络与通信', 1.0, 100, 18, 2016, 1, 1, '计算机', '2020-05-04 21:55:28');
INSERT INTO `course` VALUES ('2016031003', '计算机安全', 2.0, 100, 15, 2016, 1, 1, '计算机', '2020-05-04 21:55:51');
INSERT INTO `course` VALUES ('2016031004', '算法与数据结构', 4.0, 100, 18, 2016, 1, 1, '计算机', '2020-05-04 21:56:17');
INSERT INTO `course` VALUES ('2016031005', '多媒体信息处理', 2.0, 100, 14, 2016, 1, 1, '计算机', '2020-05-04 21:56:42');
INSERT INTO `course` VALUES ('2016031006', '计算机组成原理', 2.0, 100, 18, 2016, 1, 1, '计算机', '2020-05-04 21:57:38');
INSERT INTO `course` VALUES ('2016041001', '高频电子线路', 4.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 21:58:30');
INSERT INTO `course` VALUES ('2016041002', '光纤通讯', 2.0, 100, 16, 2016, 1, 1, '通信工程', '2020-05-04 21:58:44');
INSERT INTO `course` VALUES ('2016041003', '移动通讯', 1.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 21:58:59');
INSERT INTO `course` VALUES ('2016041004', '电路分析', 1.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 21:59:12');
INSERT INTO `course` VALUES ('2016041005', '程控交换技术', 2.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 22:05:37');
INSERT INTO `course` VALUES ('2016041006', '通信原理', 4.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 22:05:57');

-- ----------------------------
-- Table structure for course_info
-- ----------------------------
DROP TABLE IF EXISTS `course_info`;
CREATE TABLE `course_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `start` int(11) NOT NULL,
  `end` int(11) NOT NULL,
  `room` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `profession` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of course_info
-- ----------------------------
INSERT INTO `course_info` VALUES (1, '2016011001', 1, 25, '404', '电子信息工程');
INSERT INTO `course_info` VALUES (2, '2016011002', 1, 25, '401', '电子信息工程');
INSERT INTO `course_info` VALUES (3, '2016011003', 1, 25, '403', '电子信息工程');
INSERT INTO `course_info` VALUES (4, '2016011004', 1, 25, '406', '电子信息工程');
INSERT INTO `course_info` VALUES (5, '2016011005', 1, 25, '405', '电子信息工程');
INSERT INTO `course_info` VALUES (6, '2016011006', 1, 25, '402', '电子信息工程');
INSERT INTO `course_info` VALUES (7, '2016021001', 1, 25, '505', '物联网');
INSERT INTO `course_info` VALUES (8, '2016021002', 1, 25, NULL, '物联网');
INSERT INTO `course_info` VALUES (9, '2016021003', 1, 25, NULL, '物联网');
INSERT INTO `course_info` VALUES (10, '2016021005', 1, 25, NULL, '物联网');
INSERT INTO `course_info` VALUES (11, '2016021006', 1, 25, NULL, '物联网');
INSERT INTO `course_info` VALUES (12, '2016031001', 1, 25, '506', '计算机');
INSERT INTO `course_info` VALUES (13, '2016031002', 1, 25, NULL, '计算机');
INSERT INTO `course_info` VALUES (14, '2016031003', 1, 25, NULL, '计算机');
INSERT INTO `course_info` VALUES (15, '2016031004', 1, 25, NULL, '计算机');
INSERT INTO `course_info` VALUES (16, '2016031005', 1, 25, NULL, '计算机');
INSERT INTO `course_info` VALUES (17, '2016031006', 1, 25, NULL, '计算机');
INSERT INTO `course_info` VALUES (18, '2016041001', 1, 25, '506', '通信工程');
INSERT INTO `course_info` VALUES (19, '2016041002', 1, 25, NULL, '通信工程');
INSERT INTO `course_info` VALUES (20, '2016041003', 1, 25, NULL, '通信工程');
INSERT INTO `course_info` VALUES (21, '2016021004', 1, 25, NULL, '物联网');
INSERT INTO `course_info` VALUES (22, '2016041004', 1, 25, NULL, '通信工程');
INSERT INTO `course_info` VALUES (23, '2016041005', 1, 25, NULL, '通信工程');
INSERT INTO `course_info` VALUES (24, '2016041006', 1, 25, NULL, '通信工程');
INSERT INTO `course_info` VALUES (27, '2016011007', 1, 25, NULL, '电子信息工程');
INSERT INTO `course_info` VALUES (28, '2016011008', 1, 25, NULL, '电子信息工程');
INSERT INTO `course_info` VALUES (29, '2016011009', 1, 25, NULL, '电子信息工程');
INSERT INTO `course_info` VALUES (30, '2016011010', 1, 25, NULL, '电子信息工程');

-- ----------------------------
-- Table structure for profession
-- ----------------------------
DROP TABLE IF EXISTS `profession`;
CREATE TABLE `profession`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of profession
-- ----------------------------
INSERT INTO `profession` VALUES (1, '电子信息工程');
INSERT INTO `profession` VALUES (2, '物联网');
INSERT INTO `profession` VALUES (3, '计算机');
INSERT INTO `profession` VALUES (4, '通信工程');
INSERT INTO `profession` VALUES (5, '土木工程');
INSERT INTO `profession` VALUES (6, '网络工程');
INSERT INTO `profession` VALUES (7, '工程造价');
INSERT INTO `profession` VALUES (8, '会计');
INSERT INTO `profession` VALUES (9, '环境工程');
INSERT INTO `profession` VALUES (12, '123');

-- ----------------------------
-- Table structure for silent
-- ----------------------------
DROP TABLE IF EXISTS `silent`;
CREATE TABLE `silent`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `state` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of silent
-- ----------------------------
INSERT INTO `silent` VALUES (1, 0);

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `level` tinyint(4) NOT NULL DEFAULT 2,
  `school` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `admission_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0',
  `profession` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `grade` int(11) NOT NULL,
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `sex` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('3168901101', '3168901101', '123456', '林立川', 2, '福建工程学院', '2016', '1564387882@qq.com', '电子信息工程', 1601, '13358204423', 1, '2020-03-31 15:50:22');
INSERT INTO `student` VALUES ('3168901102', '3168901102', '123456', '韩季强', 2, '福建工程学院', '2016', '1564387882@qq.com', '电子信息工程', 1601, '13904568561', 0, '2020-03-31 15:50:22');
INSERT INTO `student` VALUES ('3168901103', '3168901103', '123456', '曹维启', 2, '福建工程学院', '2016', '1913637409@qq.com', '电子信息工程', 1601, '13700090921', 0, '2020-03-31 15:53:31');
INSERT INTO `student` VALUES ('3168901104', '3168901104', '123456', '吕德', 2, '福建工程学院', '2016', '1720646161@qq.com', '电子信息工程', 1601, '15903373628', 1, '2020-03-31 15:53:31');
INSERT INTO `student` VALUES ('3168901105', '3168901105', '123456', '柏泽', 2, '福建工程学院', '2016', '1030844828@qq.com', '电子信息工程', 1601, '13306440038', 0, '2020-03-31 15:53:31');
INSERT INTO `student` VALUES ('3168901106', '3168901106', '123456', '熊辉力', 2, '福建工程学院', '2016', '1368517693@qq.com', '电子信息工程', 1601, '13600865966', 1, '2020-03-31 15:53:31');
INSERT INTO `student` VALUES ('3168901107', '3168901107', '123456', '傅冠', 2, '福建工程学院', '2016', '1633449201@qq.com', '电子信息工程', 1601, '13701752096', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901108', '3168901108', '123456', '酆保', 2, '福建工程学院', '2016', '1603230942@qq.com', '电子信息工程', 1601, '15200310443', 1, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901109', '3168901109', '123456', '郑腾', 2, '福建工程学院', '2016', '1905995751@qq.com', '电子信息工程', 1601, '13803191852', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901110', '3168901110', '123456', '吴斌', 2, '福建工程学院', '2016', '1268829036@qq.com', '电子信息工程', 1601, '13104042247', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901111', '3168901111', '123456', '柳慧巧', 2, '福建工程学院', '2016', '1866710083@qq.com', '电子信息工程', 1601, '13704864349', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901112', '3168901112', '123456', '伏颖', 2, '福建工程学院', '2016', '1810351523@qq.com', '电子信息工程', 1601, '13003758800', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901113', '3168901113', '123456', '鲍翔旭', 2, '福建工程学院', '2016', '1393604939@qq.com', '电子信息工程', 1601, '15105275012', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901114', '3168901114', '123456', '周泰盛', 2, '福建工程学院', '2016', '1459773822@qq.com', '电子信息工程', 1601, '13605744985', 1, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901115', '3168901115', '123456', '葛思', 2, '福建工程学院', '2016', '1139434347@qq.com', '电子信息工程', 1601, '13102513003', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901116', '3168901116', '123456', '舒乐', 2, '福建工程学院', '2016', '1720673668@qq.com', '电子信息工程', 1601, '13004250563', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901117', '3168901117', '123456', '孔月莺', 2, '福建工程学院', '2016', '1984607297@qq.com', '电子信息工程', 1601, '13402975067', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901118', '3168901118', '123456', '姜斌', 2, '福建工程学院', '2016', '1064021840@qq.com', '电子信息工程', 1601, '15301138688', 1, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901119', '3168901119', '123456', '汪敬震', 2, '福建工程学院', '2016', '1632228805@qq.com', '电子信息工程', 1601, '15704356031', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901120', '3168901120', '123456', '曹旭', 2, '福建工程学院', '2016', '1189607467@qq.com', '电子信息工程', 1601, '13508641007', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901121', '3168901121', '123456', '柳影荔', 2, '福建工程学院', '2016', '1860190234@qq.com', '电子信息工程', 1601, '13006594022', 1, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901122', '3168901122', '123456', '蓝敬震', 2, '福建工程学院', '2016', '1642978396@qq.com', '电子信息工程', 1601, '15001253493', 0, '2020-03-31 15:53:32');
INSERT INTO `student` VALUES ('3168901123', '3168901123', '123456', '陈启', 2, '福建工程学院', '2016', '1693928397@qq.com', '电子信息工程', 1601, '15901024868', 1, '2020-03-31 15:53:33');
INSERT INTO `student` VALUES ('3168901124', '3168901124', '123456', '严发', 2, '福建工程学院', '2016', '1377953093@qq.com', '电子信息工程', 1601, '13402228948', 0, '2020-03-31 15:53:33');
INSERT INTO `student` VALUES ('3168901125', '3168901125', '123456', '严强军', 2, '福建工程学院', '2016', '1283938615@qq.com', '电子信息工程', 1601, '13501243126', 1, '2020-03-31 15:51:39');
INSERT INTO `student` VALUES ('3168901126', '3168901126', '123456', '傅梅', 2, '福建工程学院', '2016', '1951738850@qq.com', '电子信息工程', 1601, '13304491796', 0, '2020-03-31 15:57:17');
INSERT INTO `student` VALUES ('3168901127', '3168901127', '123456', '齐莲', 2, '福建工程学院', '2016', '1518418751@qq.com', '电子信息工程', 1601, '13506746627', 1, '2020-03-31 15:57:17');
INSERT INTO `student` VALUES ('3168901128', '3168901128', '123456', '邹燕彩', 2, '福建工程学院', '2016', '1844811992@qq.com', '电子信息工程', 1601, '15806244167', 1, '2020-03-31 15:57:17');
INSERT INTO `student` VALUES ('3168901129', '3168901129', '123456', '滕承乐', 2, '福建工程学院', '2016', '1694373866@qq.com', '电子信息工程', 1601, '15302491589', 1, '2020-03-31 15:57:18');
INSERT INTO `student` VALUES ('3168901130', '3168901130', '123456', '吴翰', 2, '福建工程学院', '2016', '1443532361@qq.com', '电子信息工程', 1601, '15906814748', 0, '2020-03-31 15:57:18');
INSERT INTO `student` VALUES ('3168901131', '3168901131', '123456', '杨梦', 2, '福建工程学院', '2016', '1217218205@qq.com', '电子信息工程', 1601, '13507047383', 0, '2020-03-31 15:57:18');
INSERT INTO `student` VALUES ('3168901132', '3168901132', '123456', '尹厚庆', 2, '福建工程学院', '2016', '1563536627@qq.com', '电子信息工程', 1601, '15300773435', 1, '2020-03-31 15:57:18');
INSERT INTO `student` VALUES ('3168901133', '3168901133', '123456', '康莎', 2, '福建工程学院', '2016', '1703023907@qq.com', '电子信息工程', 1601, '15602604715', 1, '2020-03-31 15:57:18');
INSERT INTO `student` VALUES ('3168901134', '3168901134', '123456', '薛婉娴', 2, '福建工程学院', '2016', '1750397403@qq.com', '电子信息工程', 1601, '15206754657', 1, '2020-03-31 15:57:18');
INSERT INTO `student` VALUES ('3168901135', '3168901135', '123456', '毕强军', 2, '福建工程学院', '2016', '1729941302@qq.com', '电子信息工程', 1601, '13403206262', 1, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901136', '3168901136', '123456', '孔雅', 2, '福建工程学院', '2016', '1756085533@qq.com', '电子信息工程', 1601, '13406450046', 0, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901137', '3168901137', '123456', '谈世', 2, '福建工程学院', '2016', '1096417457@qq.com', '电子信息工程', 1601, '13307891428', 0, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901138', '3168901138', '123456', '米勤', 2, '福建工程学院', '2016', '1014671661@qq.com', '电子信息工程', 1601, '15606914831', 0, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901139', '3168901139', '123456', '水利清', 2, '福建工程学院', '2016', '1720099038@qq.com', '电子信息工程', 1601, '15008216365', 1, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901140', '3168901140', '123456', '昌飞彬', 2, '福建工程学院', '2016', '1651430112@qq.com', '电子信息工程', 1601, '13004858329', 0, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901141', '3168901141', '123456', '范之', 2, '福建工程学院', '2016', '1209163886@qq.com', '电子信息工程', 1601, '13500697610', 0, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901142', '3168901142', '123456', '薛聪澜', 2, '福建工程学院', '2016', '1624959266@qq.com', '电子信息工程', 1601, '13704804643', 0, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901143', '3168901143', '123456', '蓝盛', 2, '福建工程学院', '2016', '1335148161@qq.com', '电子信息工程', 1601, '13005132500', 0, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901144', '3168901144', '123456', '朱庆', 2, '福建工程学院', '2016', '1970163510@qq.com', '电子信息工程', 1601, '13107244178', 0, '2020-03-31 15:57:19');
INSERT INTO `student` VALUES ('3168901145', '3168901145', '123456', '殷环', 2, '福建工程学院', '2016', '1114181684@qq.com', '电子信息工程', 1601, '13605745626', 0, '2020-03-31 15:57:20');
INSERT INTO `student` VALUES ('3168901146', '3168901146', '123456', '水兴', 2, '福建工程学院', '2016', '1738525339@qq.com', '电子信息工程', 1601, '13906668841', 0, '2020-03-31 15:57:20');
INSERT INTO `student` VALUES ('3168901147', '3168901147', '123456', '姚言', 2, '福建工程学院', '2016', '1994704574@qq.com', '电子信息工程', 1601, '13003380011', 0, '2020-03-31 15:57:20');
INSERT INTO `student` VALUES ('3168901148', '3168901148', '123456', '邵震', 2, '福建工程学院', '2016', '1475455334@qq.com', '电子信息工程', 1601, '13707638959', 1, '2020-03-31 15:57:20');
INSERT INTO `student` VALUES ('3168901149', '3168901149', '123456', '史震', 2, '福建工程学院', '2016', '1247780895@qq.com', '电子信息工程', 1601, '15607800436', 0, '2020-03-31 15:57:20');
INSERT INTO `student` VALUES ('3168901150', '3168901150', '123456', '卞奇', 2, '福建工程学院', '2016', '1249904227@qq.com', '电子信息工程', 1601, '13903720567', 0, '2020-03-31 15:57:20');
INSERT INTO `student` VALUES ('3168901201', '3168901201', '123456', '范婉娴', 2, '福建工程学院', '2016', '1719066785@qq.com', '电子信息工程', 1602, '15200665684', 0, '2020-03-31 16:01:20');
INSERT INTO `student` VALUES ('3168901202', '3168901202', '123456', '廉善', 2, '福建工程学院', '2016', '1697077805@qq.com', '电子信息工程', 1602, '15103087634', 1, '2020-03-31 16:01:20');
INSERT INTO `student` VALUES ('3168901203', '3168901203', '123456', '倪士以', 2, '福建工程学院', '2016', '1095246750@qq.com', '电子信息工程', 1602, '13202301117', 1, '2020-03-31 16:01:20');
INSERT INTO `student` VALUES ('3168901204', '3168901204', '123456', '鲁梦', 2, '福建工程学院', '2016', '1065615209@qq.com', '电子信息工程', 1602, '15701427428', 0, '2020-03-31 16:01:20');
INSERT INTO `student` VALUES ('3168901205', '3168901205', '123456', '董素', 2, '福建工程学院', '2016', '1633187005@qq.com', '电子信息工程', 1602, '13004697373', 1, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901206', '3168901206', '123456', '孙山仁', 2, '福建工程学院', '2016', '1463528551@qq.com', '电子信息工程', 1602, '13103794192', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901207', '3168901207', '123456', '贺山仁', 2, '福建工程学院', '2016', '1281195423@qq.com', '电子信息工程', 1602, '15707381051', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901208', '3168901208', '123456', '严成', 2, '福建工程学院', '2016', '1768734901@qq.com', '电子信息工程', 1602, '13102565239', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901209', '3168901209', '123456', '袁邦', 2, '福建工程学院', '2016', '1870438832@qq.com', '电子信息工程', 1602, '13801956288', 1, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901210', '3168901210', '123456', '邵清', 2, '福建工程学院', '2016', '1405331751@qq.com', '电子信息工程', 1602, '15302941699', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901211', '3168901211', '123456', '曹平保', 2, '福建工程学院', '2016', '1739957382@qq.com', '电子信息工程', 1602, '13304641069', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901212', '3168901212', '123456', '邵天', 2, '福建工程学院', '2016', '1425740987@qq.com', '电子信息工程', 1602, '15900528218', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901213', '3168901213', '123456', '卞振壮', 2, '福建工程学院', '2016', '1710250597@qq.com', '电子信息工程', 1602, '15204903116', 1, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901214', '3168901214', '123456', '袁政谦', 2, '福建工程学院', '2016', '1480549541@qq.com', '电子信息工程', 1602, '15101678130', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901215', '3168901215', '123456', '于波宁', 2, '福建工程学院', '2016', '1245580023@qq.com', '电子信息工程', 1602, '13708476173', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901216', '3168901216', '123456', '柏家', 2, '福建工程学院', '2016', '1976832913@qq.com', '电子信息工程', 1602, '15201043973', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901217', '3168901217', '123456', '葛德', 2, '福建工程学院', '2016', '1173278771@qq.com', '电子信息工程', 1602, '15006110211', 0, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901218', '3168901218', '123456', '王素', 2, '福建工程学院', '2016', '1570050051@qq.com', '电子信息工程', 1602, '15005900817', 1, '2020-03-31 16:01:21');
INSERT INTO `student` VALUES ('3168901219', '3168901219', '123456', '尹岚苑', 2, '福建工程学院', '2016', '1089253261@qq.com', '电子信息工程', 1602, '13108404753', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901220', '3168901220', '123456', '滕树', 2, '福建工程学院', '2016', '1931572398@qq.com', '电子信息工程', 1602, '15903057279', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901221', '3168901221', '123456', '黄菁梦', 2, '福建工程学院', '2016', '1051805395@qq.com', '电子信息工程', 1602, '13700871498', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901222', '3168901222', '123456', '安桂', 2, '福建工程学院', '2016', '1474178072@qq.com', '电子信息工程', 1602, '15000897256', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901223', '3168901223', '123456', '邵波宁', 2, '福建工程学院', '2016', '1927785579@qq.com', '电子信息工程', 1602, '13500587267', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901224', '3168901224', '123456', '米雄琛', 2, '福建工程学院', '2016', '1500736436@qq.com', '电子信息工程', 1602, '15805237601', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901225', '3168901225', '123456', '昌全', 2, '福建工程学院', '2016', '1282140601@qq.com', '电子信息工程', 1602, '15901796970', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901226', '3168901226', '123456', '明娴', 2, '福建工程学院', '2016', '1385775220@qq.com', '电子信息工程', 1602, '15005352602', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901227', '3168901227', '123456', '梁咏卿', 2, '福建工程学院', '2016', '1438691430@qq.com', '电子信息工程', 1602, '13604517122', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901228', '3168901228', '123456', '米富顺', 2, '福建工程学院', '2016', '1975482659@qq.com', '电子信息工程', 1602, '13303637011', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901229', '3168901229', '123456', '韩飞彬', 2, '福建工程学院', '2016', '1994538716@qq.com', '电子信息工程', 1602, '13705887682', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901230', '3168901230', '123456', '钱明永', 2, '福建工程学院', '2016', '1019321152@qq.com', '电子信息工程', 1602, '15101923463', 1, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901231', '3168901231', '123456', '纪宁', 2, '福建工程学院', '2016', '1005719512@qq.com', '电子信息工程', 1602, '15308857297', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901232', '3168901232', '123456', '陶坚和', 2, '福建工程学院', '2016', '1174269895@qq.com', '电子信息工程', 1602, '13300181425', 0, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901233', '3168901233', '123456', '成晨辰', 2, '福建工程学院', '2016', '1330063898@qq.com', '电子信息工程', 1602, '15101247675', 1, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901234', '3168901234', '123456', '酆融', 2, '福建工程学院', '2016', '1957225894@qq.com', '电子信息工程', 1602, '15004932761', 1, '2020-03-31 16:01:22');
INSERT INTO `student` VALUES ('3168901235', '3168901235', '123456', '闵文', 2, '福建工程学院', '2016', '1243674461@qq.com', '电子信息工程', 1602, '15605853783', 1, '2020-03-31 16:01:23');
INSERT INTO `student` VALUES ('3168901236', '3168901236', '123456', '毛翔旭', 2, '福建工程学院', '2016', '1196658502@qq.com', '电子信息工程', 1602, '15508876086', 0, '2020-03-31 16:01:23');
INSERT INTO `student` VALUES ('3168901237', '3168901237', '123456', '戚豪', 2, '福建工程学院', '2016', '1484714907@qq.com', '电子信息工程', 1602, '13804981406', 0, '2020-03-31 16:01:23');
INSERT INTO `student` VALUES ('3168901238', '3168901238', '123456', '窦保', 2, '福建工程学院', '2016', '1044585191@qq.com', '电子信息工程', 1602, '13804422431', 0, '2020-03-31 16:01:23');
INSERT INTO `student` VALUES ('3168901239', '3168901239', '123456', '殷力', 2, '福建工程学院', '2016', '1899792813@qq.com', '电子信息工程', 1602, '15700181146', 1, '2020-03-31 16:01:23');
INSERT INTO `student` VALUES ('3168901240', '3168901240', '123456', '云琰', 2, '福建工程学院', '2016', '1216885884@qq.com', '电子信息工程', 1602, '13203990980', 0, '2020-03-31 16:01:23');
INSERT INTO `student` VALUES ('3168901241', '3168901241', '123456', '宋信子', 2, '福建工程学院', '2016', '1684899065@qq.com', '电子信息工程', 1602, '13301951352', 1, '2020-03-31 16:01:23');
INSERT INTO `student` VALUES ('3168901242', '3168901242', '123456', '喻梦', 2, '福建工程学院', '2016', '1633455677@qq.com', '电子信息工程', 1602, '15907352579', 0, '2020-03-31 16:01:23');
INSERT INTO `student` VALUES ('3168901243', '3168901243', '123456', '狄琳素', 2, '福建工程学院', '2016', '1982259565@qq.com', '电子信息工程', 1602, '13605291327', 1, '2020-03-31 16:01:23');
INSERT INTO `student` VALUES ('3168901244', '3168901244', '123456', '蓝岩中', 2, '福建工程学院', '2016', '1592034709@qq.com', '电子信息工程', 1602, '15005721758', 0, '2020-03-31 16:01:24');
INSERT INTO `student` VALUES ('3168901245', '3168901245', '123456', '潘琛', 2, '福建工程学院', '2016', '1251193640@qq.com', '电子信息工程', 1602, '15102333417', 1, '2020-03-31 16:01:24');
INSERT INTO `student` VALUES ('3168901246', '3168901246', '123456', '余娣叶', 2, '福建工程学院', '2016', '1894720780@qq.com', '电子信息工程', 1602, '13108318197', 1, '2020-03-31 16:01:24');
INSERT INTO `student` VALUES ('3168901247', '3168901247', '123456', '谢克伦', 2, '福建工程学院', '2016', '1375117525@qq.com', '电子信息工程', 1602, '15206410040', 0, '2020-03-31 16:01:24');
INSERT INTO `student` VALUES ('3168901248', '3168901248', '123456', '昌冠', 2, '福建工程学院', '2016', '1721022682@qq.com', '电子信息工程', 1602, '15303469002', 0, '2020-03-31 16:01:24');
INSERT INTO `student` VALUES ('3168901249', '3168901249', '123456', '滕栋', 2, '福建工程学院', '2016', '1660780624@qq.com', '电子信息工程', 1602, '15103267560', 0, '2020-03-31 16:01:24');
INSERT INTO `student` VALUES ('3168901250', '3168901250', '123456', '曹河哲', 2, '福建工程学院', '2016', '1658913795@qq.com', '电子信息工程', 1602, '13008637635', 0, '2020-03-31 16:01:24');
INSERT INTO `student` VALUES ('3168901324', '3168901324', '123456', '林立川', 2, '福建工程学院', '2016', '1532224308@qq.com', '电子信息工程', 1603, '13358204723', 0, '2020-03-31 23:57:59');
INSERT INTO `student` VALUES ('3168902101', '3168902101', '123456', '席壮', 2, '福建工程学院', '2016', '1683001104@qq.com', '物联网', 1601, '15103486559', 0, '2020-03-31 16:02:38');
INSERT INTO `student` VALUES ('3168902102', '3168902102', '123456', '孙涛', 2, '福建工程学院', '2016', '1198288956@qq.com', '物联网', 1601, '13405007356', 0, '2020-03-31 16:02:38');
INSERT INTO `student` VALUES ('3168902103', '3168902103', '123456', '俞翔旭', 2, '福建工程学院', '2016', '1788043861@qq.com', '物联网', 1601, '15306108810', 0, '2020-03-31 16:02:38');
INSERT INTO `student` VALUES ('3168902104', '3168902104', '123456', '汤璐', 2, '福建工程学院', '2016', '1395940999@qq.com', '物联网', 1601, '13303164030', 1, '2020-03-31 16:02:38');
INSERT INTO `student` VALUES ('3168902105', '3168902105', '123456', '和菊', 2, '福建工程学院', '2016', '1481823978@qq.com', '物联网', 1601, '13805636006', 1, '2020-03-31 16:02:38');
INSERT INTO `student` VALUES ('3168902106', '3168902106', '123456', '乐邦', 2, '福建工程学院', '2016', '1788516059@qq.com', '物联网', 1601, '15101332030', 0, '2020-03-31 16:02:38');
INSERT INTO `student` VALUES ('3168902107', '3168902107', '123456', '袁林有', 2, '福建工程学院', '2016', '1889742207@qq.com', '物联网', 1601, '13507104946', 0, '2020-03-31 16:02:38');
INSERT INTO `student` VALUES ('3168902108', '3168902108', '123456', '穆博', 2, '福建工程学院', '2016', '1421464323@qq.com', '物联网', 1601, '15702516509', 1, '2020-03-31 16:02:39');
INSERT INTO `student` VALUES ('3168902109', '3168902109', '123456', '殷全', 2, '福建工程学院', '2016', '1576737323@qq.com', '物联网', 1601, '13305743836', 1, '2020-03-31 16:02:39');
INSERT INTO `student` VALUES ('3168902110', '3168902110', '123456', '卫飘育', 2, '福建工程学院', '2016', '1877192876@qq.com', '物联网', 1601, '13403998966', 1, '2020-03-31 16:02:39');
INSERT INTO `student` VALUES ('3168902111', '3168902111', '123456', '章之', 2, '福建工程学院', '2016', '1009496283@qq.com', '物联网', 1601, '13603544801', 1, '2020-03-31 16:02:39');
INSERT INTO `student` VALUES ('3168902112', '3168902112', '123456', '姜君琴', 2, '福建工程学院', '2016', '1326823822@qq.com', '物联网', 1601, '15201964043', 1, '2020-03-31 16:02:39');
INSERT INTO `student` VALUES ('3168902113', '3168902113', '123456', '袁茗', 2, '福建工程学院', '2016', '1395618087@qq.com', '物联网', 1601, '15508095896', 0, '2020-03-31 16:02:39');
INSERT INTO `student` VALUES ('3168902114', '3168902114', '123456', '戴震', 2, '福建工程学院', '2016', '1264281062@qq.com', '物联网', 1601, '15101167731', 0, '2020-03-31 16:02:40');
INSERT INTO `student` VALUES ('3168902115', '3168902115', '123456', '许策腾', 2, '福建工程学院', '2016', '1661986021@qq.com', '物联网', 1601, '13506343459', 0, '2020-03-31 16:02:40');
INSERT INTO `student` VALUES ('3168902116', '3168902116', '123456', '陈莉桂', 2, '福建工程学院', '2016', '1698397615@qq.com', '物联网', 1601, '15106679011', 0, '2020-03-31 16:02:40');
INSERT INTO `student` VALUES ('3168902117', '3168902117', '123456', '朱兴', 2, '福建工程学院', '2016', '1267636671@qq.com', '物联网', 1601, '15302426853', 0, '2020-03-31 16:02:40');
INSERT INTO `student` VALUES ('3168902118', '3168902118', '123456', '酆黛', 2, '福建工程学院', '2016', '1814235413@qq.com', '物联网', 1601, '13608096005', 0, '2020-03-31 16:02:40');
INSERT INTO `student` VALUES ('3168902119', '3168902119', '123456', '陶岚苑', 2, '福建工程学院', '2016', '1680719053@qq.com', '物联网', 1601, '15003078999', 0, '2020-03-31 16:02:40');
INSERT INTO `student` VALUES ('3168902120', '3168902120', '123456', '章坚和', 2, '福建工程学院', '2016', '1499083208@qq.com', '物联网', 1601, '13603367319', 1, '2020-03-31 16:02:40');
INSERT INTO `student` VALUES ('3168902121', '3168902121', '123456', '云芸', 2, '福建工程学院', '2016', '1917726441@qq.com', '物联网', 1601, '13900754208', 1, '2020-03-31 16:02:40');
INSERT INTO `student` VALUES ('3168902122', '3168902122', '123456', '滕泰盛', 2, '福建工程学院', '2016', '1460595603@qq.com', '物联网', 1601, '13500132249', 0, '2020-03-31 16:02:40');
INSERT INTO `student` VALUES ('3168902123', '3168902123', '123456', '张莲', 2, '福建工程学院', '2016', '1239997832@qq.com', '物联网', 1601, '15003028260', 1, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902124', '3168902124', '123456', '吴宜可', 2, '福建工程学院', '2016', '1967330019@qq.com', '物联网', 1601, '15804581074', 0, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902125', '3168902125', '123456', '韩茜秋', 2, '福建工程学院', '2016', '1659881874@qq.com', '物联网', 1601, '15202835736', 1, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902126', '3168902126', '123456', '祝兰凤', 2, '福建工程学院', '2016', '1184287836@qq.com', '物联网', 1601, '13403960525', 0, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902127', '3168902127', '123456', '韩珠', 2, '福建工程学院', '2016', '1063468928@qq.com', '物联网', 1601, '13904268355', 0, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902128', '3168902128', '123456', '齐思', 2, '福建工程学院', '2016', '1628300166@qq.com', '物联网', 1601, '15503093998', 0, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902129', '3168902129', '123456', '祝飞彬', 2, '福建工程学院', '2016', '1588650427@qq.com', '物联网', 1601, '13101859008', 0, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902130', '3168902130', '123456', '尤刚', 2, '福建工程学院', '2016', '1260160959@qq.com', '物联网', 1601, '15902102066', 1, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902131', '3168902131', '123456', '平寒', 2, '福建工程学院', '2016', '1986488099@qq.com', '物联网', 1601, '15704166295', 1, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902132', '3168902132', '123456', '杨亮', 2, '福建工程学院', '2016', '1249285463@qq.com', '物联网', 1601, '13107006338', 0, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902133', '3168902133', '123456', '雷生龙', 2, '福建工程学院', '2016', '1675436427@qq.com', '物联网', 1601, '13101926692', 0, '2020-03-31 16:02:41');
INSERT INTO `student` VALUES ('3168902134', '3168902134', '123456', '康婕馨', 2, '福建工程学院', '2016', '1767837707@qq.com', '物联网', 1601, '15600040596', 1, '2020-03-31 16:02:42');
INSERT INTO `student` VALUES ('3168902135', '3168902135', '123456', '袁健世', 2, '福建工程学院', '2016', '1970651017@qq.com', '物联网', 1601, '13108545292', 0, '2020-03-31 16:02:42');
INSERT INTO `student` VALUES ('3168902136', '3168902136', '123456', '梁莎', 2, '福建工程学院', '2016', '1785631134@qq.com', '物联网', 1601, '13400511072', 0, '2020-03-31 16:02:42');
INSERT INTO `student` VALUES ('3168902137', '3168902137', '123456', '湛军', 2, '福建工程学院', '2016', '1308225520@qq.com', '物联网', 1601, '15503630832', 0, '2020-03-31 16:02:42');
INSERT INTO `student` VALUES ('3168902138', '3168902138', '123456', '朱杰涛', 2, '福建工程学院', '2016', '1550769606@qq.com', '物联网', 1601, '13904171530', 1, '2020-03-31 16:02:42');
INSERT INTO `student` VALUES ('3168902139', '3168902139', '123456', '喻炎德', 2, '福建工程学院', '2016', '1453632096@qq.com', '物联网', 1601, '15805347451', 1, '2020-03-31 16:02:42');
INSERT INTO `student` VALUES ('3168902140', '3168902140', '123456', '尹月莺', 2, '福建工程学院', '2016', '1916805916@qq.com', '物联网', 1601, '15505291717', 0, '2020-03-31 16:02:42');
INSERT INTO `student` VALUES ('3168902141', '3168902141', '123456', '茅民', 2, '福建工程学院', '2016', '1773720969@qq.com', '物联网', 1601, '15204632454', 1, '2020-03-31 16:02:42');
INSERT INTO `student` VALUES ('3168902142', '3168902142', '123456', '鲁健世', 2, '福建工程学院', '2016', '1634912989@qq.com', '物联网', 1601, '13206965608', 1, '2020-03-31 16:02:43');
INSERT INTO `student` VALUES ('3168902143', '3168902143', '123456', '袁启', 2, '福建工程学院', '2016', '1203540768@qq.com', '物联网', 1601, '13104485856', 0, '2020-03-31 16:02:43');
INSERT INTO `student` VALUES ('3168902144', '3168902144', '123456', '滕朋斌', 2, '福建工程学院', '2016', '1632348680@qq.com', '物联网', 1601, '15903052507', 1, '2020-03-31 16:02:43');
INSERT INTO `student` VALUES ('3168902145', '3168902145', '123456', '董顺', 2, '福建工程学院', '2016', '1661185387@qq.com', '物联网', 1601, '13902584245', 0, '2020-03-31 16:02:43');
INSERT INTO `student` VALUES ('3168902146', '3168902146', '123456', '苏辉力', 2, '福建工程学院', '2016', '1070381636@qq.com', '物联网', 1601, '15807118947', 1, '2020-03-31 16:02:43');
INSERT INTO `student` VALUES ('3168902147', '3168902147', '123456', '贝厚庆', 2, '福建工程学院', '2016', '1747127700@qq.com', '物联网', 1601, '15607921314', 0, '2020-03-31 16:02:44');
INSERT INTO `student` VALUES ('3168902148', '3168902148', '123456', '卞健世', 2, '福建工程学院', '2016', '1929454326@qq.com', '物联网', 1601, '15005296876', 1, '2020-03-31 16:02:44');
INSERT INTO `student` VALUES ('3168902149', '3168902149', '123456', '伍会思', 2, '福建工程学院', '2016', '1797517387@qq.com', '物联网', 1601, '15007587312', 1, '2020-03-31 16:02:44');
INSERT INTO `student` VALUES ('3168902150', '3168902150', '123456', '陈伯', 2, '福建工程学院', '2016', '1790390528@qq.com', '物联网', 1601, '13605841004', 1, '2020-03-31 16:02:44');
INSERT INTO `student` VALUES ('3168903101', '3168903101', '123456', '元才发', 2, '福建工程学院', '2016', '1002184134@qq.com', '计算机', 1601, '13103547031', 0, '2020-03-31 16:04:16');
INSERT INTO `student` VALUES ('3168903102', '3168903102', '123456', '余伯', 2, '福建工程学院', '2016', '1483980096@qq.com', '计算机', 1601, '15604376436', 0, '2020-03-31 16:04:16');
INSERT INTO `student` VALUES ('3168903103', '3168903103', '123456', '云光天', 2, '福建工程学院', '2016', '1879736089@qq.com', '计算机', 1601, '15502865043', 0, '2020-03-31 16:04:16');
INSERT INTO `student` VALUES ('3168903104', '3168903104', '123456', '傅珊莎', 2, '福建工程学院', '2016', '1430965623@qq.com', '计算机', 1601, '15606345572', 0, '2020-03-31 16:04:16');
INSERT INTO `student` VALUES ('3168903105', '3168903105', '123456', '唐强军', 2, '福建工程学院', '2016', '1800424639@qq.com', '计算机', 1601, '13602820914', 0, '2020-03-31 16:04:16');
INSERT INTO `student` VALUES ('3168903106', '3168903106', '123456', '卞军', 2, '福建工程学院', '2016', '1037708204@qq.com', '计算机', 1601, '15704135823', 0, '2020-03-31 16:04:16');
INSERT INTO `student` VALUES ('3168903107', '3168903107', '123456', '苏乐', 2, '福建工程学院', '2016', '1799770515@qq.com', '计算机', 1601, '13108878576', 0, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903108', '3168903108', '123456', '宋超', 2, '福建工程学院', '2016', '1991601381@qq.com', '计算机', 1601, '15801237351', 0, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903109', '3168903109', '123456', '朱馥', 2, '福建工程学院', '2016', '1216825166@qq.com', '计算机', 1601, '13000817911', 1, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903110', '3168903110', '123456', '屈波宁', 2, '福建工程学院', '2016', '1770729608@qq.com', '计算机', 1601, '15801190411', 1, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903111', '3168903111', '123456', '葛莲', 2, '福建工程学院', '2016', '1254764939@qq.com', '计算机', 1601, '13200454507', 1, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903112', '3168903112', '123456', '孙荔', 2, '福建工程学院', '2016', '1307744267@qq.com', '计算机', 1601, '13704534046', 1, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903113', '3168903113', '123456', '花武新', 2, '福建工程学院', '2016', '1962101811@qq.com', '计算机', 1601, '15808323376', 0, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903114', '3168903114', '123456', '伏振壮', 2, '福建工程学院', '2016', '1840352630@qq.com', '计算机', 1601, '15706043432', 0, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903115', '3168903115', '123456', '茅岩中', 2, '福建工程学院', '2016', '1602568244@qq.com', '计算机', 1601, '13002866039', 0, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903116', '3168903116', '123456', '倪辰', 2, '福建工程学院', '2016', '1358727399@qq.com', '计算机', 1601, '13603716371', 0, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903117', '3168903117', '123456', '史元全', 2, '福建工程学院', '2016', '1172408160@qq.com', '计算机', 1601, '13602182506', 0, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903118', '3168903118', '123456', '宋磊民', 2, '福建工程学院', '2016', '1465035710@qq.com', '计算机', 1601, '15902811178', 1, '2020-03-31 16:04:17');
INSERT INTO `student` VALUES ('3168903119', '3168903119', '123456', '祁纯毓', 2, '福建工程学院', '2016', '1066952047@qq.com', '计算机', 1601, '15808573157', 0, '2020-03-31 16:04:18');
INSERT INTO `student` VALUES ('3168903120', '3168903120', '123456', '殷融', 2, '福建工程学院', '2016', '1137996766@qq.com', '计算机', 1601, '13405893627', 1, '2020-03-31 16:04:18');
INSERT INTO `student` VALUES ('3168903121', '3168903121', '123456', '米健世', 2, '福建工程学院', '2016', '1798743817@qq.com', '计算机', 1601, '13003773456', 0, '2020-03-31 16:04:18');
INSERT INTO `student` VALUES ('3168903122', '3168903122', '123456', '明秀娟', 2, '福建工程学院', '2016', '1940469514@qq.com', '计算机', 1601, '13404290952', 0, '2020-03-31 16:04:18');
INSERT INTO `student` VALUES ('3168903123', '3168903123', '123456', '窦娣叶', 2, '福建工程学院', '2016', '1009014215@qq.com', '计算机', 1601, '13100236570', 1, '2020-03-31 16:04:18');
INSERT INTO `student` VALUES ('3168903124', '3168903124', '123456', '计冰爽', 2, '福建工程学院', '2016', '1606094523@qq.com', '计算机', 1601, '15702601224', 0, '2020-03-31 16:04:18');
INSERT INTO `student` VALUES ('3168903125', '3168903125', '123456', '谈舒', 2, '福建工程学院', '2016', '1208628615@qq.com', '计算机', 1601, '15003818062', 0, '2020-03-31 16:04:18');
INSERT INTO `student` VALUES ('3168903126', '3168903126', '123456', '顾眉', 2, '福建工程学院', '2016', '1107948352@qq.com', '计算机', 1601, '15107282488', 1, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903127', '3168903127', '123456', '褚新', 2, '福建工程学院', '2016', '1890980408@qq.com', '计算机', 1601, '15605921069', 1, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903128', '3168903128', '123456', '周春菊', 2, '福建工程学院', '2016', '1966296578@qq.com', '计算机', 1601, '13005820297', 0, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903129', '3168903129', '123456', '熊晓', 2, '福建工程学院', '2016', '1921255760@qq.com', '计算机', 1601, '15308567262', 0, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903130', '3168903130', '123456', '余岚苑', 2, '福建工程学院', '2016', '1677437923@qq.com', '计算机', 1601, '15304308001', 1, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903131', '3168903131', '123456', '汪咏卿', 2, '福建工程学院', '2016', '1999603741@qq.com', '计算机', 1601, '13001385871', 0, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903132', '3168903132', '123456', '屈红', 2, '福建工程学院', '2016', '1799655534@qq.com', '计算机', 1601, '13301538384', 1, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903133', '3168903133', '123456', '邹生龙', 2, '福建工程学院', '2016', '1019247336@qq.com', '计算机', 1601, '13605362553', 1, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903134', '3168903134', '123456', '倪山仁', 2, '福建工程学院', '2016', '1283366710@qq.com', '计算机', 1601, '15905396257', 0, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903135', '3168903135', '123456', '喻坚和', 2, '福建工程学院', '2016', '1594625485@qq.com', '计算机', 1601, '13608855055', 0, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903136', '3168903136', '123456', '戚盛', 2, '福建工程学院', '2016', '1336221903@qq.com', '计算机', 1601, '15606708614', 0, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903137', '3168903137', '123456', '乐发', 2, '福建工程学院', '2016', '1952019252@qq.com', '计算机', 1601, '13002970580', 0, '2020-03-31 16:04:19');
INSERT INTO `student` VALUES ('3168903138', '3168903138', '123456', '韦星', 2, '福建工程学院', '2016', '1227179479@qq.com', '计算机', 1601, '15208574865', 0, '2020-03-31 16:04:20');
INSERT INTO `student` VALUES ('3168903139', '3168903139', '123456', '唐明永', 2, '福建工程学院', '2016', '1158982878@qq.com', '计算机', 1601, '13507304825', 0, '2020-03-31 16:04:20');
INSERT INTO `student` VALUES ('3168903140', '3168903140', '123456', '曹辉力', 2, '福建工程学院', '2016', '1317928620@qq.com', '计算机', 1601, '15600438238', 0, '2020-03-31 16:04:20');
INSERT INTO `student` VALUES ('3168903141', '3168903141', '123456', '杜楠榕', 2, '福建工程学院', '2016', '1612760164@qq.com', '计算机', 1601, '13602362192', 0, '2020-03-31 16:04:20');
INSERT INTO `student` VALUES ('3168903142', '3168903142', '123456', '苗彬', 2, '福建工程学院', '2016', '1326239145@qq.com', '计算机', 1601, '13201425239', 0, '2020-03-31 16:04:20');
INSERT INTO `student` VALUES ('3168903143', '3168903143', '123456', '任丹', 2, '福建工程学院', '2016', '1460850717@qq.com', '计算机', 1601, '15808123448', 0, '2020-03-31 16:04:20');
INSERT INTO `student` VALUES ('3168903144', '3168903144', '123456', '朱真环', 2, '福建工程学院', '2016', '1336696503@qq.com', '计算机', 1601, '13708397491', 0, '2020-03-31 16:04:21');
INSERT INTO `student` VALUES ('3168903145', '3168903145', '123456', '喻欣', 2, '福建工程学院', '2016', '1764076576@qq.com', '计算机', 1601, '13904380381', 0, '2020-03-31 16:04:21');
INSERT INTO `student` VALUES ('3168903146', '3168903146', '123456', '杜进', 2, '福建工程学院', '2016', '1807429356@qq.com', '计算机', 1601, '15307768082', 0, '2020-03-31 16:04:21');
INSERT INTO `student` VALUES ('3168903147', '3168903147', '123456', '费国胜', 2, '福建工程学院', '2016', '1751333222@qq.com', '计算机', 1601, '13004227758', 0, '2020-03-31 16:04:21');
INSERT INTO `student` VALUES ('3168903148', '3168903148', '123456', '计有', 2, '福建工程学院', '2016', '1611573771@qq.com', '计算机', 1601, '15300275062', 0, '2020-03-31 16:04:21');
INSERT INTO `student` VALUES ('3168903149', '3168903149', '123456', '沈梁栋', 2, '福建工程学院', '2016', '1378891007@qq.com', '计算机', 1601, '15203263894', 0, '2020-03-31 16:04:21');
INSERT INTO `student` VALUES ('3168903150', '3168903150', '123456', '臧艺', 2, '福建工程学院', '2016', '1072722366@qq.com', '计算机', 1601, '15700102986', 1, '2020-03-31 16:04:21');
INSERT INTO `student` VALUES ('3168903151', '3168903151', '123456', '邹伟刚', 2, '福建工程学院', '2016', '1663026936@qq.com', '计算机', 1601, '13200214912', 1, '2020-03-31 16:04:21');
INSERT INTO `student` VALUES ('3168903152', '3168903152', '123456', '鲍刚', 2, '福建工程学院', '2016', '1664602481@qq.com', '计算机', 1601, '13908224032', 0, '2020-03-31 16:04:21');
INSERT INTO `student` VALUES ('3168903153', '3168903153', '123456', '萧俊峰', 2, '福建工程学院', '2016', '1676564510@qq.com', '计算机', 1601, '13206005405', 0, '2020-03-31 16:04:22');
INSERT INTO `student` VALUES ('3168903154', '3168903154', '123456', '臧梁栋', 2, '福建工程学院', '2016', '1052995554@qq.com', '计算机', 1601, '15506807247', 1, '2020-03-31 16:04:22');
INSERT INTO `student` VALUES ('3168903155', '3168903155', '123456', '祝子', 2, '福建工程学院', '2016', '1648054190@qq.com', '计算机', 1601, '13304790554', 0, '2020-03-31 16:04:22');
INSERT INTO `student` VALUES ('3168903156', '3168903156', '123456', '沈盛', 2, '福建工程学院', '2016', '1558596647@qq.com', '计算机', 1601, '13706062577', 0, '2020-03-31 16:04:22');
INSERT INTO `student` VALUES ('3168903157', '3168903157', '123456', '谢叶', 2, '福建工程学院', '2016', '1504350004@qq.com', '计算机', 1601, '13204126549', 0, '2020-03-31 16:04:22');
INSERT INTO `student` VALUES ('3168903158', '3168903158', '123456', '鲁咏卿', 2, '福建工程学院', '2016', '1659285589@qq.com', '计算机', 1601, '13608542851', 0, '2020-03-31 16:04:22');
INSERT INTO `student` VALUES ('3168903159', '3168903159', '123456', '曹倩', 2, '福建工程学院', '2016', '1044425487@qq.com', '计算机', 1601, '13601900215', 0, '2020-03-31 16:04:22');
INSERT INTO `student` VALUES ('3168903160', '3168903160', '123456', '戴峰', 2, '福建工程学院', '2016', '1120167279@qq.com', '计算机', 1601, '15106011572', 0, '2020-03-31 16:04:22');
INSERT INTO `student` VALUES ('3168904101', '3168904101', '123456', '赵浩亮', 2, '福建工程学院', '2016', '1551439003@qq.com', '通信工程', 1601, '13505125127', 1, '2020-03-31 16:06:06');
INSERT INTO `student` VALUES ('3168904102', '3168904102', '123456', '卞菲寒', 2, '福建工程学院', '2016', '1050719423@qq.com', '通信工程', 1601, '15804904927', 1, '2020-03-31 16:06:06');
INSERT INTO `student` VALUES ('3168904103', '3168904103', '123456', '葛家', 2, '福建工程学院', '2016', '1586861990@qq.com', '通信工程', 1601, '13604445841', 0, '2020-03-31 16:06:06');
INSERT INTO `student` VALUES ('3168904104', '3168904104', '123456', '吕嘉', 2, '福建工程学院', '2016', '1827286844@qq.com', '通信工程', 1601, '15205658984', 0, '2020-03-31 16:06:06');
INSERT INTO `student` VALUES ('3168904105', '3168904105', '123456', '邬清', 2, '福建工程学院', '2016', '1255463962@qq.com', '通信工程', 1601, '13007448079', 0, '2020-03-31 16:06:06');
INSERT INTO `student` VALUES ('3168904106', '3168904106', '123456', '苏学祥', 2, '福建工程学院', '2016', '1110543494@qq.com', '通信工程', 1601, '15208054294', 0, '2020-03-31 16:06:06');
INSERT INTO `student` VALUES ('3168904107', '3168904107', '123456', '马芝玉', 2, '福建工程学院', '2016', '1039316462@qq.com', '通信工程', 1601, '15200115470', 1, '2020-03-31 16:06:06');
INSERT INTO `student` VALUES ('3168904108', '3168904108', '123456', '云敬震', 2, '福建工程学院', '2016', '1880441268@qq.com', '通信工程', 1601, '13001260738', 1, '2020-03-31 16:06:06');
INSERT INTO `student` VALUES ('3168904109', '3168904109', '123456', '宋全', 2, '福建工程学院', '2016', '1666189026@qq.com', '通信工程', 1601, '13007791693', 1, '2020-03-31 16:06:07');
INSERT INTO `student` VALUES ('3168904110', '3168904110', '123456', '康苑', 2, '福建工程学院', '2016', '1188246945@qq.com', '通信工程', 1601, '13604936676', 1, '2020-03-31 16:06:07');
INSERT INTO `student` VALUES ('3168904111', '3168904111', '123456', '尹羽希', 2, '福建工程学院', '2016', '1356116072@qq.com', '通信工程', 1601, '13307840205', 0, '2020-03-31 16:06:07');
INSERT INTO `student` VALUES ('3168904112', '3168904112', '123456', '鲍义兴', 2, '福建工程学院', '2016', '1602030447@qq.com', '通信工程', 1601, '15204966979', 1, '2020-03-31 16:06:07');
INSERT INTO `student` VALUES ('3168904113', '3168904113', '123456', '云清', 2, '福建工程学院', '2016', '1010470881@qq.com', '通信工程', 1601, '13603440902', 0, '2020-03-31 16:06:07');
INSERT INTO `student` VALUES ('3168904114', '3168904114', '123456', '戴娟', 2, '福建工程学院', '2016', '1462265481@qq.com', '通信工程', 1601, '13903597786', 0, '2020-03-31 16:06:07');
INSERT INTO `student` VALUES ('3168904115', '3168904115', '123456', '汪福', 2, '福建工程学院', '2016', '1918668662@qq.com', '通信工程', 1601, '15205787430', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904116', '3168904116', '123456', '屈泽', 2, '福建工程学院', '2016', '1994294625@qq.com', '通信工程', 1601, '13104365811', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904117', '3168904117', '123456', '李滢馥', 2, '福建工程学院', '2016', '1958019598@qq.com', '通信工程', 1601, '13607196617', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904118', '3168904118', '123456', '方超', 2, '福建工程学院', '2016', '1085888464@qq.com', '通信工程', 1601, '13404356920', 1, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904119', '3168904119', '123456', '陈昌成', 2, '福建工程学院', '2016', '1452361950@qq.com', '通信工程', 1601, '15802804961', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904120', '3168904120', '123456', '纪炎德', 2, '福建工程学院', '2016', '1108214778@qq.com', '通信工程', 1601, '15306760885', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904121', '3168904121', '123456', '吕龙', 2, '福建工程学院', '2016', '1746077496@qq.com', '通信工程', 1601, '15000545035', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904122', '3168904122', '123456', '苗巧', 2, '福建工程学院', '2016', '1314645763@qq.com', '通信工程', 1601, '15507556383', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904123', '3168904123', '123456', '杜澜', 2, '福建工程学院', '2016', '1158839936@qq.com', '通信工程', 1601, '13604614894', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904124', '3168904124', '123456', '熊世', 2, '福建工程学院', '2016', '1225797661@qq.com', '通信工程', 1601, '13500874579', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904125', '3168904125', '123456', '安泰盛', 2, '福建工程学院', '2016', '1494685775@qq.com', '通信工程', 1601, '15107975617', 0, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904126', '3168904126', '123456', '鲍山仁', 2, '福建工程学院', '2016', '1114464092@qq.com', '通信工程', 1601, '13605760092', 1, '2020-03-31 16:06:08');
INSERT INTO `student` VALUES ('3168904127', '3168904127', '123456', '任英华', 2, '福建工程学院', '2016', '1076481421@qq.com', '通信工程', 1601, '15503136993', 1, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904128', '3168904128', '123456', '成仪', 2, '福建工程学院', '2016', '1265211944@qq.com', '通信工程', 1601, '15302981655', 1, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904129', '3168904129', '123456', '杜固之', 2, '福建工程学院', '2016', '1450906024@qq.com', '通信工程', 1601, '15008304791', 1, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904130', '3168904130', '123456', '茅成', 2, '福建工程学院', '2016', '1737015459@qq.com', '通信工程', 1601, '13800952780', 0, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904131', '3168904131', '123456', '于磊民', 2, '福建工程学院', '2016', '1635777568@qq.com', '通信工程', 1601, '15607931925', 0, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904132', '3168904132', '123456', '柳芳', 2, '福建工程学院', '2016', '1830484095@qq.com', '通信工程', 1601, '13706950569', 0, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904133', '3168904133', '123456', '余海', 2, '福建工程学院', '2016', '1051495535@qq.com', '通信工程', 1601, '13704891330', 0, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904134', '3168904134', '123456', '卞霞香', 2, '福建工程学院', '2016', '1334925034@qq.com', '通信工程', 1601, '13100480633', 1, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904135', '3168904135', '123456', '倪学祥', 2, '福建工程学院', '2016', '1611131207@qq.com', '通信工程', 1601, '15107555810', 1, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904136', '3168904136', '123456', '严琦', 2, '福建工程学院', '2016', '1592290396@qq.com', '通信工程', 1601, '13906328892', 1, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904137', '3168904137', '123456', '余时', 2, '福建工程学院', '2016', '1239670430@qq.com', '通信工程', 1601, '13201590518', 1, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904138', '3168904138', '123456', '凤亚', 2, '福建工程学院', '2016', '1282748813@qq.com', '通信工程', 1601, '15301276714', 1, '2020-03-31 16:06:09');
INSERT INTO `student` VALUES ('3168904139', '3168904139', '123456', '褚言', 2, '福建工程学院', '2016', '1706304654@qq.com', '通信工程', 1601, '15708360649', 1, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904140', '3168904140', '123456', '禹发', 2, '福建工程学院', '2016', '1550503222@qq.com', '通信工程', 1601, '15101258148', 0, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904141', '3168904141', '123456', '彭亚', 2, '福建工程学院', '2016', '1716426868@qq.com', '通信工程', 1601, '13706551100', 1, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904142', '3168904142', '123456', '赵若鸣', 2, '福建工程学院', '2016', '1001143453@qq.com', '通信工程', 1601, '13500586474', 0, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904143', '3168904143', '123456', '苏振壮', 2, '福建工程学院', '2016', '1128602509@qq.com', '通信工程', 1601, '13007713265', 0, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904144', '3168904144', '123456', '魏君琴', 2, '福建工程学院', '2016', '1187533205@qq.com', '通信工程', 1601, '15603145688', 0, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904145', '3168904145', '123456', '阮清', 2, '福建工程学院', '2016', '1326254034@qq.com', '通信工程', 1601, '13101556782', 0, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904146', '3168904146', '123456', '陶仪', 2, '福建工程学院', '2016', '1444454169@qq.com', '通信工程', 1601, '15102578553', 0, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904147', '3168904147', '123456', '孙江超', 2, '福建工程学院', '2016', '1082729400@qq.com', '通信工程', 1601, '13300085346', 1, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904148', '3168904148', '123456', '罗保', 2, '福建工程学院', '2016', '1323624421@qq.com', '通信工程', 1601, '15307366857', 0, '2020-03-31 16:06:10');
INSERT INTO `student` VALUES ('3168904149', '3168904149', '123456', '陈菁梦', 2, '福建工程学院', '2016', '1960696357@qq.com', '通信工程', 1601, '15503606222', 1, '2020-03-31 16:06:11');
INSERT INTO `student` VALUES ('3168904150', '3168904150', '123456', '陶之', 2, '福建工程学院', '2016', '1738079004@qq.com', '通信工程', 1601, '15101498900', 1, '2020-03-31 16:06:11');
INSERT INTO `student` VALUES ('3168904151', '3168904151', '123456', '贝菲寒', 2, '福建工程学院', '2016', '1673112346@qq.com', '通信工程', 1601, '13301842690', 1, '2020-03-31 16:06:11');
INSERT INTO `student` VALUES ('3168904152', '3168904152', '123456', '茅士以', 2, '福建工程学院', '2016', '1291698991@qq.com', '通信工程', 1601, '13804657813', 0, '2020-03-31 16:06:11');
INSERT INTO `student` VALUES ('3168904153', '3168904153', '123456', '湛先', 2, '福建工程学院', '2016', '1051028534@qq.com', '通信工程', 1601, '13901004234', 1, '2020-03-31 16:06:11');
INSERT INTO `student` VALUES ('3168904154', '3168904154', '123456', '纪思', 2, '福建工程学院', '2016', '1507633347@qq.com', '通信工程', 1601, '13403936099', 0, '2020-03-31 16:06:11');
INSERT INTO `student` VALUES ('3168904155', '3168904155', '123456', '杜广志', 2, '福建工程学院', '2016', '1850691984@qq.com', '通信工程', 1601, '15202426390', 0, '2020-03-31 16:06:11');
INSERT INTO `student` VALUES ('3168904156', '3168904156', '123456', '王伯', 2, '福建工程学院', '2016', '1036802461@qq.com', '通信工程', 1601, '13406052420', 1, '2020-03-31 16:06:12');
INSERT INTO `student` VALUES ('3168904157', '3168904157', '123456', '奚翔旭', 2, '福建工程学院', '2016', '1466068504@qq.com', '通信工程', 1601, '15601417194', 0, '2020-03-31 16:06:12');
INSERT INTO `student` VALUES ('3168904158', '3168904158', '123456', '谈东文', 2, '福建工程学院', '2016', '1094342337@qq.com', '通信工程', 1601, '13204147851', 0, '2020-03-31 16:06:12');
INSERT INTO `student` VALUES ('3168904159', '3168904159', '123456', '萧亮', 2, '福建工程学院', '2016', '1807810851@qq.com', '通信工程', 1601, '13500583800', 0, '2020-03-31 16:06:12');
INSERT INTO `student` VALUES ('3168904160', '3168904160', '123456', '唐新', 2, '福建工程学院', '2016', '1551692638@qq.com', '通信工程', 1601, '15005468008', 0, '2020-03-31 16:06:12');
INSERT INTO `student` VALUES ('3168904201', '3168904201', '123456', '唐康星', 2, '福建工程学院', '2016', '1179726447@qq.com', '通信工程', 1602, '13800714945', 0, '2020-03-31 16:06:55');
INSERT INTO `student` VALUES ('3168904202', '3168904202', '123456', '薛毅', 2, '福建工程学院', '2016', '1278825856@qq.com', '通信工程', 1602, '13002833874', 1, '2020-03-31 16:06:55');
INSERT INTO `student` VALUES ('3168904203', '3168904203', '123456', '陈博', 2, '福建工程学院', '2016', '1410592593@qq.com', '通信工程', 1602, '13608750816', 0, '2020-03-31 16:06:55');
INSERT INTO `student` VALUES ('3168904204', '3168904204', '123456', '许林有', 2, '福建工程学院', '2016', '1892414074@qq.com', '通信工程', 1602, '13004811461', 0, '2020-03-31 16:06:55');
INSERT INTO `student` VALUES ('3168904205', '3168904205', '123456', '戴富顺', 2, '福建工程学院', '2016', '1116973778@qq.com', '通信工程', 1602, '13103532396', 0, '2020-03-31 16:06:55');
INSERT INTO `student` VALUES ('3168904206', '3168904206', '123456', '窦义兴', 2, '福建工程学院', '2016', '1214547818@qq.com', '通信工程', 1602, '15808022844', 0, '2020-03-31 16:06:55');
INSERT INTO `student` VALUES ('3168904207', '3168904207', '123456', '殷梅', 2, '福建工程学院', '2016', '1389004633@qq.com', '通信工程', 1602, '15300893109', 0, '2020-03-31 16:06:55');
INSERT INTO `student` VALUES ('3168904208', '3168904208', '123456', '黄固之', 2, '福建工程学院', '2016', '1760363306@qq.com', '通信工程', 1602, '15607603244', 0, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904209', '3168904209', '123456', '闵红', 2, '福建工程学院', '2016', '1774578248@qq.com', '通信工程', 1602, '15806815153', 1, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904210', '3168904210', '123456', '袁君琴', 2, '福建工程学院', '2016', '1435554445@qq.com', '通信工程', 1602, '15607796076', 1, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904211', '3168904211', '123456', '华翰', 2, '福建工程学院', '2016', '1737784743@qq.com', '通信工程', 1602, '15901698233', 0, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904212', '3168904212', '123456', '岑伊亚', 2, '福建工程学院', '2016', '1852404398@qq.com', '通信工程', 1602, '15606441224', 0, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904213', '3168904213', '123456', '曹维启', 2, '福建工程学院', '2016', '1791196600@qq.com', '通信工程', 1602, '13803145331', 0, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904214', '3168904214', '123456', '蓝时', 2, '福建工程学院', '2016', '1899490187@qq.com', '通信工程', 1602, '13202367671', 1, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904215', '3168904215', '123456', '朱影荔', 2, '福建工程学院', '2016', '1613015178@qq.com', '通信工程', 1602, '13900805004', 1, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904216', '3168904216', '123456', '茅祥', 2, '福建工程学院', '2016', '1367671242@qq.com', '通信工程', 1602, '13307565071', 0, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904217', '3168904217', '123456', '尤群豪', 2, '福建工程学院', '2016', '1589945387@qq.com', '通信工程', 1602, '13407666082', 0, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904218', '3168904218', '123456', '曹利清', 2, '福建工程学院', '2016', '1420593525@qq.com', '通信工程', 1602, '15207096014', 1, '2020-03-31 16:06:56');
INSERT INTO `student` VALUES ('3168904219', '3168904219', '123456', '袁子', 2, '福建工程学院', '2016', '1780252194@qq.com', '通信工程', 1602, '13907830158', 0, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904220', '3168904220', '123456', '祁刚', 2, '福建工程学院', '2016', '1453023620@qq.com', '通信工程', 1602, '15305143563', 1, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904221', '3168904221', '123456', '戚武新', 2, '福建工程学院', '2016', '1732231506@qq.com', '通信工程', 1602, '15303945832', 0, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904222', '3168904222', '123456', '曹荷丹', 2, '福建工程学院', '2016', '1550585254@qq.com', '通信工程', 1602, '13707885335', 0, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904223', '3168904223', '123456', '严斌', 2, '福建工程学院', '2016', '1178190674@qq.com', '通信工程', 1602, '13800210942', 1, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904224', '3168904224', '123456', '彭苑', 2, '福建工程学院', '2016', '1206717110@qq.com', '通信工程', 1602, '13206596867', 1, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904225', '3168904225', '123456', '鲁晨辰', 2, '福建工程学院', '2016', '1684642289@qq.com', '通信工程', 1602, '15502376599', 0, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904226', '3168904226', '123456', '苏秀娟', 2, '福建工程学院', '2016', '1039082349@qq.com', '通信工程', 1602, '15101991093', 0, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904227', '3168904227', '123456', '柳美娜', 2, '福建工程学院', '2016', '1095144372@qq.com', '通信工程', 1602, '15705426277', 0, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904228', '3168904228', '123456', '齐致树', 2, '福建工程学院', '2016', '1919190081@qq.com', '通信工程', 1602, '15603912822', 0, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904229', '3168904229', '123456', '庞生龙', 2, '福建工程学院', '2016', '1507128781@qq.com', '通信工程', 1602, '13706932275', 0, '2020-03-31 16:06:57');
INSERT INTO `student` VALUES ('3168904230', '3168904230', '123456', '奚贵福', 2, '福建工程学院', '2016', '1970982666@qq.com', '通信工程', 1602, '15305825752', 1, '2020-03-31 16:06:58');
INSERT INTO `student` VALUES ('3168904231', '3168904231', '123456', '吴武新', 2, '福建工程学院', '2016', '1202209332@qq.com', '通信工程', 1602, '13608679000', 1, '2020-03-31 16:06:58');
INSERT INTO `student` VALUES ('3168904232', '3168904232', '123456', '祝辉力', 2, '福建工程学院', '2016', '1479607876@qq.com', '通信工程', 1602, '13204133213', 0, '2020-03-31 16:06:58');
INSERT INTO `student` VALUES ('3168904233', '3168904233', '123456', '陈成', 2, '福建工程学院', '2016', '1491809586@qq.com', '通信工程', 1602, '13008885135', 0, '2020-03-31 16:06:58');
INSERT INTO `student` VALUES ('3168904234', '3168904234', '123456', '史壮', 2, '福建工程学院', '2016', '1475968119@qq.com', '通信工程', 1602, '15301550866', 0, '2020-03-31 16:06:58');
INSERT INTO `student` VALUES ('3168904235', '3168904235', '123456', '孙行时', 2, '福建工程学院', '2016', '1114574365@qq.com', '通信工程', 1602, '13400484901', 0, '2020-03-31 16:06:58');
INSERT INTO `student` VALUES ('3168904236', '3168904236', '123456', '倪君琴', 2, '福建工程学院', '2016', '1912056535@qq.com', '通信工程', 1602, '15803543399', 0, '2020-03-31 16:06:58');
INSERT INTO `student` VALUES ('3168904237', '3168904237', '123456', '柳怡婵', 2, '福建工程学院', '2016', '1390555467@qq.com', '通信工程', 1602, '13503267307', 1, '2020-03-31 16:06:58');
INSERT INTO `student` VALUES ('3168904238', '3168904238', '123456', '元元全', 2, '福建工程学院', '2016', '1489102909@qq.com', '通信工程', 1602, '15701543994', 0, '2020-03-31 16:06:59');
INSERT INTO `student` VALUES ('3168904239', '3168904239', '123456', '施谦', 2, '福建工程学院', '2016', '1086169222@qq.com', '通信工程', 1602, '15601576505', 0, '2020-03-31 16:06:59');
INSERT INTO `student` VALUES ('3168904240', '3168904240', '123456', '时凤', 2, '福建工程学院', '2016', '1102557574@qq.com', '通信工程', 1602, '15805388550', 0, '2020-03-31 16:06:59');
INSERT INTO `student` VALUES ('3168904241', '3168904241', '123456', '张固之', 2, '福建工程学院', '2016', '1153109470@qq.com', '通信工程', 1602, '15208713721', 1, '2020-03-31 16:06:59');
INSERT INTO `student` VALUES ('3168904242', '3168904242', '123456', '范梁栋', 2, '福建工程学院', '2016', '1719172416@qq.com', '通信工程', 1602, '15202824411', 0, '2020-03-31 16:06:59');
INSERT INTO `student` VALUES ('3168904243', '3168904243', '123456', '任舒', 2, '福建工程学院', '2016', '1414309745@qq.com', '通信工程', 1602, '13502407279', 0, '2020-03-31 16:06:59');
INSERT INTO `student` VALUES ('3168904244', '3168904244', '123456', '郑会思', 2, '福建工程学院', '2016', '1657385833@qq.com', '通信工程', 1602, '15105699002', 0, '2020-03-31 16:06:59');
INSERT INTO `student` VALUES ('3168904245', '3168904245', '123456', '严娜', 2, '福建工程学院', '2016', '1305385326@qq.com', '通信工程', 1602, '15502555116', 0, '2020-03-31 16:06:59');
INSERT INTO `student` VALUES ('3168904246', '3168904246', '123456', '沈子', 2, '福建工程学院', '2016', '1543942717@qq.com', '通信工程', 1602, '15205826176', 1, '2020-03-31 16:07:00');
INSERT INTO `student` VALUES ('3168904247', '3168904247', '123456', '齐辰', 2, '福建工程学院', '2016', '1948056906@qq.com', '通信工程', 1602, '15005297958', 1, '2020-03-31 16:07:00');
INSERT INTO `student` VALUES ('3168904248', '3168904248', '123456', '葛才发', 2, '福建工程学院', '2016', '1321579930@qq.com', '通信工程', 1602, '13107087922', 1, '2020-03-31 16:07:00');
INSERT INTO `student` VALUES ('3168904249', '3168904249', '123456', '雷晨辰', 2, '福建工程学院', '2016', '1672657273@qq.com', '通信工程', 1602, '13004418366', 0, '2020-03-31 16:07:00');
INSERT INTO `student` VALUES ('3168904250', '3168904250', '123456', '姚强军', 2, '福建工程学院', '2016', '1589121838@qq.com', '通信工程', 1602, '13407660787', 0, '2020-03-31 16:07:00');
INSERT INTO `student` VALUES ('3168905101', '3168905101', '123456', '薛有', 2, '福建工程学院', '2016', '1162644782@qq.com', '土木工程', 1601, '13901818612', 0, '2020-03-31 16:09:50');
INSERT INTO `student` VALUES ('3168905102', '3168905102', '123456', '邵瑾颖', 2, '福建工程学院', '2016', '1560218490@qq.com', '土木工程', 1601, '13607570681', 0, '2020-03-31 16:09:50');
INSERT INTO `student` VALUES ('3168905103', '3168905103', '123456', '许梁栋', 2, '福建工程学院', '2016', '1589579622@qq.com', '土木工程', 1601, '15900673026', 0, '2020-03-31 16:09:50');
INSERT INTO `student` VALUES ('3168905104', '3168905104', '123456', '杜珍贞', 2, '福建工程学院', '2016', '1589359574@qq.com', '土木工程', 1601, '13603046662', 0, '2020-03-31 16:09:50');
INSERT INTO `student` VALUES ('3168905105', '3168905105', '123456', '计娜', 2, '福建工程学院', '2016', '1916549037@qq.com', '土木工程', 1601, '15208423996', 0, '2020-03-31 16:09:50');
INSERT INTO `student` VALUES ('3168905106', '3168905106', '123456', '傅悦昭', 2, '福建工程学院', '2016', '1557649664@qq.com', '土木工程', 1601, '13801109039', 0, '2020-03-31 16:09:50');
INSERT INTO `student` VALUES ('3168905107', '3168905107', '123456', '陈亮', 2, '福建工程学院', '2016', '1111512586@qq.com', '土木工程', 1601, '13204516620', 0, '2020-03-31 16:09:50');
INSERT INTO `student` VALUES ('3168905108', '3168905108', '123456', '和维启', 2, '福建工程学院', '2016', '1804017892@qq.com', '土木工程', 1601, '15703470448', 0, '2020-03-31 16:09:50');
INSERT INTO `student` VALUES ('3168905109', '3168905109', '123456', '谢朋斌', 2, '福建工程学院', '2016', '1677792312@qq.com', '土木工程', 1601, '15307806665', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905110', '3168905110', '123456', '祁浩亮', 2, '福建工程学院', '2016', '1755124223@qq.com', '土木工程', 1601, '15607922192', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905111', '3168905111', '123456', '褚飘育', 2, '福建工程学院', '2016', '1840183401@qq.com', '土木工程', 1601, '13102471312', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905112', '3168905112', '123456', '酆保', 2, '福建工程学院', '2016', '1794586459@qq.com', '土木工程', 1601, '15601978199', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905113', '3168905113', '123456', '殷艳', 2, '福建工程学院', '2016', '1019859632@qq.com', '土木工程', 1601, '15908681481', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905114', '3168905114', '123456', '蒋荣', 2, '福建工程学院', '2016', '1793445056@qq.com', '土木工程', 1601, '15502914776', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905115', '3168905115', '123456', '赵斌', 2, '福建工程学院', '2016', '1325585081@qq.com', '土木工程', 1601, '15802154872', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905116', '3168905116', '123456', '昌刚', 2, '福建工程学院', '2016', '1988629376@qq.com', '土木工程', 1601, '13902011844', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905117', '3168905117', '123456', '酆韵融', 2, '福建工程学院', '2016', '1462309505@qq.com', '土木工程', 1601, '15807331449', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905118', '3168905118', '123456', '卞亮', 2, '福建工程学院', '2016', '1395286289@qq.com', '土木工程', 1601, '13403826440', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905119', '3168905119', '123456', '谢武新', 2, '福建工程学院', '2016', '1701213789@qq.com', '土木工程', 1601, '15208237578', 0, '2020-03-31 16:09:51');
INSERT INTO `student` VALUES ('3168905120', '3168905120', '123456', '元竹霭', 2, '福建工程学院', '2016', '1785139437@qq.com', '土木工程', 1601, '13100257391', 0, '2020-03-31 16:09:52');
INSERT INTO `student` VALUES ('3168905121', '3168905121', '123456', '黄义兴', 2, '福建工程学院', '2016', '1179368447@qq.com', '土木工程', 1601, '13902875920', 0, '2020-03-31 16:09:52');
INSERT INTO `student` VALUES ('3168905122', '3168905122', '123456', '尹蓉眉', 2, '福建工程学院', '2016', '1638295649@qq.com', '土木工程', 1601, '13406892790', 0, '2020-03-31 16:09:52');
INSERT INTO `student` VALUES ('3168905123', '3168905123', '123456', '戴叶', 2, '福建工程学院', '2016', '1498562329@qq.com', '土木工程', 1601, '13906166126', 0, '2020-03-31 16:09:52');
INSERT INTO `student` VALUES ('3168905124', '3168905124', '123456', '皮坚和', 2, '福建工程学院', '2016', '1572405833@qq.com', '土木工程', 1601, '15608627381', 0, '2020-03-31 16:09:52');
INSERT INTO `student` VALUES ('3168905125', '3168905125', '123456', '马妍', 2, '福建工程学院', '2016', '1555284649@qq.com', '土木工程', 1601, '13607867762', 0, '2020-03-31 16:09:52');
INSERT INTO `student` VALUES ('3168905126', '3168905126', '123456', '倪永', 2, '福建工程学院', '2016', '1556338590@qq.com', '土木工程', 1601, '13501937379', 0, '2020-03-31 16:09:52');
INSERT INTO `student` VALUES ('3168905127', '3168905127', '123456', '狄爱妹', 2, '福建工程学院', '2016', '1503773125@qq.com', '土木工程', 1601, '15100787017', 0, '2020-03-31 16:09:52');
INSERT INTO `student` VALUES ('3168905128', '3168905128', '123456', '方先', 2, '福建工程学院', '2016', '1421372003@qq.com', '土木工程', 1601, '15804813609', 0, '2020-03-31 16:09:52');
INSERT INTO `student` VALUES ('3168905129', '3168905129', '123456', '褚世', 2, '福建工程学院', '2016', '1193522325@qq.com', '土木工程', 1601, '13502793981', 1, '2020-03-31 16:10:19');
INSERT INTO `student` VALUES ('3168905130', '3168905130', '123456', '何伊亚', 2, '福建工程学院', '2016', '1667252381@qq.com', '土木工程', 1601, '13608516609', 1, '2020-03-31 16:10:19');
INSERT INTO `student` VALUES ('3168906101', '3168906101', '123456', '汤士以', 2, '福建工程学院', '2016', '1699637515@qq.com', '网络工程', 1601, '15608252593', 0, '2020-03-31 16:11:40');
INSERT INTO `student` VALUES ('3168906102', '3168906102', '123456', '姜馨', 2, '福建工程学院', '2016', '1283885074@qq.com', '网络工程', 1601, '15601755368', 0, '2020-03-31 16:11:40');
INSERT INTO `student` VALUES ('3168906103', '3168906103', '123456', '毕平保', 2, '福建工程学院', '2016', '1638859299@qq.com', '网络工程', 1601, '15503969000', 0, '2020-03-31 16:11:40');
INSERT INTO `student` VALUES ('3168906104', '3168906104', '123456', '蒋涛', 2, '福建工程学院', '2016', '1520872406@qq.com', '网络工程', 1601, '15108786958', 1, '2020-03-31 16:11:40');
INSERT INTO `student` VALUES ('3168906105', '3168906105', '123456', '苏康星', 2, '福建工程学院', '2016', '1678593544@qq.com', '网络工程', 1601, '15106743118', 0, '2020-03-31 16:11:40');
INSERT INTO `student` VALUES ('3168906106', '3168906106', '123456', '赵英华', 2, '福建工程学院', '2016', '1389829323@qq.com', '网络工程', 1601, '13705411042', 0, '2020-03-31 16:11:40');
INSERT INTO `student` VALUES ('3168906107', '3168906107', '123456', '皮钧冠', 2, '福建工程学院', '2016', '1113340370@qq.com', '网络工程', 1601, '13606992942', 0, '2020-03-31 16:11:40');
INSERT INTO `student` VALUES ('3168906108', '3168906108', '123456', '阮功', 2, '福建工程学院', '2016', '1011100607@qq.com', '网络工程', 1601, '13203153390', 1, '2020-03-31 16:11:40');
INSERT INTO `student` VALUES ('3168906109', '3168906109', '123456', '薛新', 2, '福建工程学院', '2016', '1158027196@qq.com', '网络工程', 1601, '13202115410', 1, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906110', '3168906110', '123456', '章俊峰', 2, '福建工程学院', '2016', '1128271310@qq.com', '网络工程', 1601, '13502487476', 1, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906111', '3168906111', '123456', '张秀娟', 2, '福建工程学院', '2016', '1751104281@qq.com', '网络工程', 1601, '15203818581', 0, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906112', '3168906112', '123456', '计建家', 2, '福建工程学院', '2016', '1303174668@qq.com', '网络工程', 1601, '13304451272', 1, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906113', '3168906113', '123456', '时瑞凡', 2, '福建工程学院', '2016', '1413413565@qq.com', '网络工程', 1601, '15708462518', 0, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906114', '3168906114', '123456', '郎栋', 2, '福建工程学院', '2016', '1339195092@qq.com', '网络工程', 1601, '15707293272', 1, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906115', '3168906115', '123456', '任勇毅', 2, '福建工程学院', '2016', '1311120793@qq.com', '网络工程', 1601, '13504573344', 0, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906116', '3168906116', '123456', '昌克伦', 2, '福建工程学院', '2016', '1325751163@qq.com', '网络工程', 1601, '15508016482', 0, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906117', '3168906117', '123456', '计超', 2, '福建工程学院', '2016', '1661030642@qq.com', '网络工程', 1601, '13203201154', 1, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906118', '3168906118', '123456', '蒋芬芳', 2, '福建工程学院', '2016', '1080953720@qq.com', '网络工程', 1601, '15807766531', 0, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906119', '3168906119', '123456', '熊枫芸', 2, '福建工程学院', '2016', '1445919872@qq.com', '网络工程', 1601, '13400800200', 1, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906120', '3168906120', '123456', '范浩亮', 2, '福建工程学院', '2016', '1191840099@qq.com', '网络工程', 1601, '13907121638', 0, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906121', '3168906121', '123456', '臧馨', 2, '福建工程学院', '2016', '1780151337@qq.com', '网络工程', 1601, '13406022569', 1, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906122', '3168906122', '123456', '戴利清', 2, '福建工程学院', '2016', '1404510138@qq.com', '网络工程', 1601, '13200037105', 1, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906123', '3168906123', '123456', '湛博', 2, '福建工程学院', '2016', '1079284533@qq.com', '网络工程', 1601, '13007677305', 1, '2020-03-31 16:11:41');
INSERT INTO `student` VALUES ('3168906124', '3168906124', '123456', '邹淑', 2, '福建工程学院', '2016', '1698585883@qq.com', '网络工程', 1601, '15506476352', 1, '2020-03-31 16:11:42');
INSERT INTO `student` VALUES ('3168906125', '3168906125', '123456', '禹嘉', 2, '福建工程学院', '2016', '1079498815@qq.com', '网络工程', 1601, '13908771178', 1, '2020-03-31 16:11:42');
INSERT INTO `student` VALUES ('3168906126', '3168906126', '123456', '萧仁', 2, '福建工程学院', '2016', '1665449866@qq.com', '网络工程', 1601, '15901601340', 0, '2020-03-31 16:11:42');
INSERT INTO `student` VALUES ('3168906127', '3168906127', '123456', '吕坚和', 2, '福建工程学院', '2016', '1325198920@qq.com', '网络工程', 1601, '13805965539', 0, '2020-03-31 16:11:42');
INSERT INTO `student` VALUES ('3168906128', '3168906128', '123456', '许倩', 2, '福建工程学院', '2016', '1377036487@qq.com', '网络工程', 1601, '15802938330', 0, '2020-03-31 16:11:42');
INSERT INTO `student` VALUES ('3168906129', '3168906129', '123456', '喻士以', 2, '福建工程学院', '2016', '1228902995@qq.com', '网络工程', 1601, '15805126327', 0, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906130', '3168906130', '123456', '苏胜', 2, '福建工程学院', '2016', '1917042308@qq.com', '网络工程', 1601, '15003487861', 1, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906131', '3168906131', '123456', '岑平保', 2, '福建工程学院', '2016', '1067364226@qq.com', '网络工程', 1601, '13906575021', 1, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906132', '3168906132', '123456', '贝颖', 2, '福建工程学院', '2016', '1550625094@qq.com', '网络工程', 1601, '15101909008', 1, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906133', '3168906133', '123456', '赵晓', 2, '福建工程学院', '2016', '1040861929@qq.com', '网络工程', 1601, '13606533815', 0, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906134', '3168906134', '123456', '姜康星', 2, '福建工程学院', '2016', '1741159715@qq.com', '网络工程', 1601, '13001808887', 1, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906135', '3168906135', '123456', '俞天', 2, '福建工程学院', '2016', '1249354390@qq.com', '网络工程', 1601, '15501357410', 0, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906136', '3168906136', '123456', '鲁彩', 2, '福建工程学院', '2016', '1631956022@qq.com', '网络工程', 1601, '13406551954', 0, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906137', '3168906137', '123456', '朱福', 2, '福建工程学院', '2016', '1027338521@qq.com', '网络工程', 1601, '15904713617', 1, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906138', '3168906138', '123456', '赵才发', 2, '福建工程学院', '2016', '1147023303@qq.com', '网络工程', 1601, '13002780489', 0, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906139', '3168906139', '123456', '窦义兴', 2, '福建工程学院', '2016', '1798279352@qq.com', '网络工程', 1601, '15200933313', 0, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906140', '3168906140', '123456', '郑永', 2, '福建工程学院', '2016', '1992705740@qq.com', '网络工程', 1601, '15008184885', 0, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906141', '3168906141', '123456', '康梁栋', 2, '福建工程学院', '2016', '1655814167@qq.com', '网络工程', 1601, '15902453985', 1, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906142', '3168906142', '123456', '岑梅', 2, '福建工程学院', '2016', '1572583821@qq.com', '网络工程', 1601, '15103860726', 0, '2020-03-31 16:11:43');
INSERT INTO `student` VALUES ('3168906143', '3168906143', '123456', '杨海', 2, '福建工程学院', '2016', '1213810733@qq.com', '网络工程', 1601, '13407639067', 0, '2020-03-31 16:11:44');
INSERT INTO `student` VALUES ('3168906144', '3168906144', '123456', '时腾', 2, '福建工程学院', '2016', '1990631011@qq.com', '网络工程', 1601, '13708174471', 0, '2020-03-31 16:11:44');
INSERT INTO `student` VALUES ('3168906145', '3168906145', '123456', '席平保', 2, '福建工程学院', '2016', '1530684079@qq.com', '网络工程', 1601, '13406474693', 0, '2020-03-31 16:11:44');
INSERT INTO `student` VALUES ('3168906146', '3168906146', '123456', '柳和', 2, '福建工程学院', '2016', '1241465981@qq.com', '网络工程', 1601, '13600293419', 0, '2020-03-31 16:11:44');
INSERT INTO `student` VALUES ('3168906147', '3168906147', '123456', '蓝鸣', 2, '福建工程学院', '2016', '1059015186@qq.com', '网络工程', 1601, '13704193769', 1, '2020-03-31 16:11:44');
INSERT INTO `student` VALUES ('3168906148', '3168906148', '123456', '余进', 2, '福建工程学院', '2016', '1888019463@qq.com', '网络工程', 1601, '13106543020', 0, '2020-03-31 16:11:44');
INSERT INTO `student` VALUES ('3168906149', '3168906149', '123456', '伍言', 2, '福建工程学院', '2016', '1744047447@qq.com', '网络工程', 1601, '13601944276', 0, '2020-03-31 16:11:44');
INSERT INTO `student` VALUES ('3168906150', '3168906150', '123456', '尤克伦', 2, '福建工程学院', '2016', '1692927496@qq.com', '网络工程', 1601, '15206614057', 0, '2020-03-31 16:11:44');
INSERT INTO `student` VALUES ('3168906201', '3168906201', '123456', '韦晨辰', 2, '福建工程学院', '2016', '1115222209@qq.com', '网络工程', 1602, '13904222241', 0, '2020-03-31 16:12:37');
INSERT INTO `student` VALUES ('3168906202', '3168906202', '123456', '乐辰', 2, '福建工程学院', '2016', '1319283547@qq.com', '网络工程', 1602, '13007183609', 1, '2020-03-31 16:12:37');
INSERT INTO `student` VALUES ('3168906203', '3168906203', '123456', '纪安', 2, '福建工程学院', '2016', '1968035965@qq.com', '网络工程', 1602, '13807864913', 0, '2020-03-31 16:12:37');
INSERT INTO `student` VALUES ('3168906204', '3168906204', '123456', '阮英华', 2, '福建工程学院', '2016', '1261437192@qq.com', '网络工程', 1602, '13800686182', 0, '2020-03-31 16:12:37');
INSERT INTO `student` VALUES ('3168906205', '3168906205', '123456', '项荷丹', 2, '福建工程学院', '2016', '1640696733@qq.com', '网络工程', 1602, '13203685022', 1, '2020-03-31 16:12:37');
INSERT INTO `student` VALUES ('3168906206', '3168906206', '123456', '彭雅', 2, '福建工程学院', '2016', '1550549085@qq.com', '网络工程', 1602, '13706492898', 0, '2020-03-31 16:12:37');
INSERT INTO `student` VALUES ('3168906207', '3168906207', '123456', '卫富顺', 2, '福建工程学院', '2016', '1354246608@qq.com', '网络工程', 1602, '13706706832', 0, '2020-03-31 16:12:37');
INSERT INTO `student` VALUES ('3168906208', '3168906208', '123456', '戚荣', 2, '福建工程学院', '2016', '1772900414@qq.com', '网络工程', 1602, '13803707907', 1, '2020-03-31 16:12:37');
INSERT INTO `student` VALUES ('3168906209', '3168906209', '123456', '方利清', 2, '福建工程学院', '2016', '1536731144@qq.com', '网络工程', 1602, '15101430306', 1, '2020-03-31 16:12:38');
INSERT INTO `student` VALUES ('3168906210', '3168906210', '123456', '魏楠榕', 2, '福建工程学院', '2016', '1268752449@qq.com', '网络工程', 1602, '13508884787', 1, '2020-03-31 16:12:38');
INSERT INTO `student` VALUES ('3168906211', '3168906211', '123456', '云红', 2, '福建工程学院', '2016', '1080021479@qq.com', '网络工程', 1602, '15504955545', 0, '2020-03-31 16:12:38');
INSERT INTO `student` VALUES ('3168906212', '3168906212', '123456', '和承乐', 2, '福建工程学院', '2016', '1277257778@qq.com', '网络工程', 1602, '13000551455', 0, '2020-03-31 16:12:38');
INSERT INTO `student` VALUES ('3168906213', '3168906213', '123456', '茅清', 2, '福建工程学院', '2016', '1556612386@qq.com', '网络工程', 1602, '15202607807', 0, '2020-03-31 16:12:38');
INSERT INTO `student` VALUES ('3168906214', '3168906214', '123456', '臧振壮', 2, '福建工程学院', '2016', '1680269043@qq.com', '网络工程', 1602, '15300510538', 0, '2020-03-31 16:12:38');
INSERT INTO `student` VALUES ('3168906215', '3168906215', '123456', '戴之', 2, '福建工程学院', '2016', '1309251318@qq.com', '网络工程', 1602, '15007732058', 0, '2020-03-31 16:12:38');
INSERT INTO `student` VALUES ('3168906216', '3168906216', '123456', '倪利清', 2, '福建工程学院', '2016', '1952120470@qq.com', '网络工程', 1602, '13507747383', 1, '2020-03-31 16:12:38');
INSERT INTO `student` VALUES ('3168906217', '3168906217', '123456', '宋伟刚', 2, '福建工程学院', '2016', '1765642426@qq.com', '网络工程', 1602, '15304768019', 0, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906218', '3168906218', '123456', '周力', 2, '福建工程学院', '2016', '1852030131@qq.com', '网络工程', 1602, '13006223579', 0, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906219', '3168906219', '123456', '薛顺', 2, '福建工程学院', '2016', '1867642978@qq.com', '网络工程', 1602, '13005806631', 1, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906220', '3168906220', '123456', '闵纨仪', 2, '福建工程学院', '2016', '1173688068@qq.com', '网络工程', 1602, '15002438337', 0, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906221', '3168906221', '123456', '唐强军', 2, '福建工程学院', '2016', '1017314380@qq.com', '网络工程', 1602, '13302364592', 1, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906222', '3168906222', '123456', '滕芸', 2, '福建工程学院', '2016', '1417747339@qq.com', '网络工程', 1602, '13105385035', 0, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906223', '3168906223', '123456', '皮玲', 2, '福建工程学院', '2016', '1225092272@qq.com', '网络工程', 1602, '15802258850', 0, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906224', '3168906224', '123456', '方凡', 2, '福建工程学院', '2016', '1943551835@qq.com', '网络工程', 1602, '13004338996', 0, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906225', '3168906225', '123456', '孔文', 2, '福建工程学院', '2016', '1389970438@qq.com', '网络工程', 1602, '15508027234', 0, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906226', '3168906226', '123456', '魏星', 2, '福建工程学院', '2016', '1066262083@qq.com', '网络工程', 1602, '13700252218', 0, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906227', '3168906227', '123456', '顾叶', 2, '福建工程学院', '2016', '1677700807@qq.com', '网络工程', 1602, '15505593724', 0, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906228', '3168906228', '123456', '张祥', 2, '福建工程学院', '2016', '1199638531@qq.com', '网络工程', 1602, '15104708998', 1, '2020-03-31 16:12:39');
INSERT INTO `student` VALUES ('3168906229', '3168906229', '123456', '毛炎德', 2, '福建工程学院', '2016', '1888245026@qq.com', '网络工程', 1602, '13708411957', 0, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906230', '3168906230', '123456', '华滢馥', 2, '福建工程学院', '2016', '1227940682@qq.com', '网络工程', 1602, '13208743640', 1, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906231', '3168906231', '123456', '卜影荔', 2, '福建工程学院', '2016', '1328800469@qq.com', '网络工程', 1602, '13506015239', 1, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906232', '3168906232', '123456', '蒋诚先', 2, '福建工程学院', '2016', '1460296373@qq.com', '网络工程', 1602, '15104052840', 0, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906233', '3168906233', '123456', '云固之', 2, '福建工程学院', '2016', '1227137616@qq.com', '网络工程', 1602, '15305515022', 1, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906234', '3168906234', '123456', '范富顺', 2, '福建工程学院', '2016', '1323644221@qq.com', '网络工程', 1602, '13704227367', 0, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906235', '3168906235', '123456', '窦晨辰', 2, '福建工程学院', '2016', '1988950453@qq.com', '网络工程', 1602, '15906928376', 1, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906236', '3168906236', '123456', '王毅', 2, '福建工程学院', '2016', '1383974513@qq.com', '网络工程', 1602, '13304704727', 0, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906237', '3168906237', '123456', '许谦', 2, '福建工程学院', '2016', '1834140065@qq.com', '网络工程', 1602, '15703648020', 0, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906238', '3168906238', '123456', '戴钧冠', 2, '福建工程学院', '2016', '1201714214@qq.com', '网络工程', 1602, '13204986448', 0, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906239', '3168906239', '123456', '鲍全', 2, '福建工程学院', '2016', '1569231669@qq.com', '网络工程', 1602, '15108368467', 1, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906240', '3168906240', '123456', '奚中', 2, '福建工程学院', '2016', '1068158351@qq.com', '网络工程', 1602, '15201887621', 0, '2020-03-31 16:12:40');
INSERT INTO `student` VALUES ('3168906301', '3168906301', '123456', '钱飘育', 2, '福建工程学院', '2016', '1451060462@qq.com', '网络工程', 1603, '13603013155', 0, '2020-03-31 16:13:09');
INSERT INTO `student` VALUES ('3168906302', '3168906302', '123456', '禹利清', 2, '福建工程学院', '2016', '1307236422@qq.com', '网络工程', 1603, '15208276773', 0, '2020-03-31 16:13:09');
INSERT INTO `student` VALUES ('3168906303', '3168906303', '123456', '喻启', 2, '福建工程学院', '2016', '1510048644@qq.com', '网络工程', 1603, '13901441329', 0, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906304', '3168906304', '123456', '伍鹏泽', 2, '福建工程学院', '2016', '1104078587@qq.com', '网络工程', 1603, '13908301935', 0, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906305', '3168906305', '123456', '昌翰', 2, '福建工程学院', '2016', '1932829321@qq.com', '网络工程', 1603, '15303844427', 0, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906306', '3168906306', '123456', '贝翠雅', 2, '福建工程学院', '2016', '1459866826@qq.com', '网络工程', 1603, '13001533007', 1, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906307', '3168906307', '123456', '任莲', 2, '福建工程学院', '2016', '1570256036@qq.com', '网络工程', 1603, '15302300382', 0, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906308', '3168906308', '123456', '周国胜', 2, '福建工程学院', '2016', '1735699205@qq.com', '网络工程', 1603, '13906221994', 0, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906309', '3168906309', '123456', '褚元全', 2, '福建工程学院', '2016', '1721766793@qq.com', '网络工程', 1603, '13803131104', 0, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906310', '3168906310', '123456', '庞青倩', 2, '福建工程学院', '2016', '1881512550@qq.com', '网络工程', 1603, '13205265916', 1, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906311', '3168906311', '123456', '吕馨', 2, '福建工程学院', '2016', '1973286865@qq.com', '网络工程', 1603, '15908595911', 1, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906312', '3168906312', '123456', '项玲', 2, '福建工程学院', '2016', '1203635766@qq.com', '网络工程', 1603, '15307336154', 1, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906313', '3168906313', '123456', '戴钧冠', 2, '福建工程学院', '2016', '1190308457@qq.com', '网络工程', 1603, '15201578224', 0, '2020-03-31 16:13:10');
INSERT INTO `student` VALUES ('3168906314', '3168906314', '123456', '吴贞', 2, '福建工程学院', '2016', '1552123459@qq.com', '网络工程', 1603, '13801017391', 0, '2020-03-31 16:13:11');
INSERT INTO `student` VALUES ('3168906315', '3168906315', '123456', '湛可', 2, '福建工程学院', '2016', '1788980608@qq.com', '网络工程', 1603, '13208311701', 0, '2020-03-31 16:13:11');
INSERT INTO `student` VALUES ('3168906316', '3168906316', '123456', '金影荔', 2, '福建工程学院', '2016', '1203497085@qq.com', '网络工程', 1603, '15004322875', 0, '2020-03-31 16:13:11');
INSERT INTO `student` VALUES ('3168906317', '3168906317', '123456', '卞会思', 2, '福建工程学院', '2016', '1125201213@qq.com', '网络工程', 1603, '15708242619', 0, '2020-03-31 16:13:11');
INSERT INTO `student` VALUES ('3168906318', '3168906318', '123456', '常苑', 2, '福建工程学院', '2016', '1990450179@qq.com', '网络工程', 1603, '13506187016', 1, '2020-03-31 16:13:11');
INSERT INTO `student` VALUES ('3168906319', '3168906319', '123456', '明壮', 2, '福建工程学院', '2016', '1393099392@qq.com', '网络工程', 1603, '13002284152', 0, '2020-03-31 16:13:11');
INSERT INTO `student` VALUES ('3168906320', '3168906320', '123456', '沈伦', 2, '福建工程学院', '2016', '1253682955@qq.com', '网络工程', 1603, '15605204887', 0, '2020-03-31 16:13:11');
INSERT INTO `student` VALUES ('3168906321', '3168906321', '123456', '邬裕', 2, '福建工程学院', '2016', '1405305312@qq.com', '网络工程', 1603, '13404606658', 1, '2020-03-31 16:13:11');
INSERT INTO `student` VALUES ('3168906322', '3168906322', '123456', '戴岚苑', 2, '福建工程学院', '2016', '1055812561@qq.com', '网络工程', 1603, '13506546594', 0, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906323', '3168906323', '123456', '贺雄琛', 2, '福建工程学院', '2016', '1389941183@qq.com', '网络工程', 1603, '15306827071', 0, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906324', '3168906324', '123456', '花梦', 2, '福建工程学院', '2016', '1802161884@qq.com', '网络工程', 1603, '13106401397', 0, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906325', '3168906325', '123456', '马茂进', 2, '福建工程学院', '2016', '1914911924@qq.com', '网络工程', 1603, '13703008338', 0, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906326', '3168906326', '123456', '赵德', 2, '福建工程学院', '2016', '1907425225@qq.com', '网络工程', 1603, '13503582561', 0, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906327', '3168906327', '123456', '俞苑', 2, '福建工程学院', '2016', '1879894502@qq.com', '网络工程', 1603, '15803167526', 1, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906328', '3168906328', '123456', '薛才发', 2, '福建工程学院', '2016', '1918211156@qq.com', '网络工程', 1603, '15106192996', 0, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906329', '3168906329', '123456', '祁山仁', 2, '福建工程学院', '2016', '1634168187@qq.com', '网络工程', 1603, '15801962944', 0, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906330', '3168906330', '123456', '秦环', 2, '福建工程学院', '2016', '1354015129@qq.com', '网络工程', 1603, '13801707235', 1, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906331', '3168906331', '123456', '韩松善', 2, '福建工程学院', '2016', '1699254755@qq.com', '网络工程', 1603, '13700817774', 0, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906332', '3168906332', '123456', '梁毅', 2, '福建工程学院', '2016', '1794130766@qq.com', '网络工程', 1603, '15900222062', 1, '2020-03-31 16:13:12');
INSERT INTO `student` VALUES ('3168906333', '3168906333', '123456', '戚彩', 2, '福建工程学院', '2016', '1439358642@qq.com', '网络工程', 1603, '15907076929', 1, '2020-03-31 16:13:13');
INSERT INTO `student` VALUES ('3168906334', '3168906334', '123456', '狄轮翰', 2, '福建工程学院', '2016', '1171619792@qq.com', '网络工程', 1603, '15902474750', 1, '2020-03-31 16:13:13');
INSERT INTO `student` VALUES ('3168906335', '3168906335', '123456', '张文', 2, '福建工程学院', '2016', '1265281962@qq.com', '网络工程', 1603, '15103088877', 0, '2020-03-31 16:13:13');
INSERT INTO `student` VALUES ('3168906336', '3168906336', '123456', '阮辰', 2, '福建工程学院', '2016', '1362745556@qq.com', '网络工程', 1603, '13000741348', 0, '2020-03-31 16:13:13');
INSERT INTO `student` VALUES ('3168906337', '3168906337', '123456', '戴启', 2, '福建工程学院', '2016', '1827066001@qq.com', '网络工程', 1603, '15004066163', 1, '2020-03-31 16:13:13');
INSERT INTO `student` VALUES ('3168906338', '3168906338', '123456', '纪功', 2, '福建工程学院', '2016', '1057586939@qq.com', '网络工程', 1603, '15304254571', 0, '2020-03-31 16:13:13');
INSERT INTO `student` VALUES ('3168906339', '3168906339', '123456', '柏震', 2, '福建工程学院', '2016', '1914064113@qq.com', '网络工程', 1603, '13802224790', 0, '2020-03-31 16:13:13');
INSERT INTO `student` VALUES ('3168906340', '3168906340', '123456', '朱茂进', 2, '福建工程学院', '2016', '1451181828@qq.com', '网络工程', 1603, '13507831784', 1, '2020-03-31 16:13:13');
INSERT INTO `student` VALUES ('3168907101', '3168907101', '123456', '宋岩中', 2, '福建工程学院', '2016', '1983023356@qq.com', '工程造价', 1601, '15108116728', 0, '2020-03-31 16:14:46');
INSERT INTO `student` VALUES ('3168907102', '3168907102', '123456', '舒雁蓓', 2, '福建工程学院', '2016', '1660288343@qq.com', '工程造价', 1601, '13200681455', 0, '2020-03-31 16:14:46');
INSERT INTO `student` VALUES ('3168907103', '3168907103', '123456', '赵承乐', 2, '福建工程学院', '2016', '1371459563@qq.com', '工程造价', 1601, '13404124307', 0, '2020-03-31 16:14:46');
INSERT INTO `student` VALUES ('3168907104', '3168907104', '123456', '卫军', 2, '福建工程学院', '2016', '1618949853@qq.com', '工程造价', 1601, '13705644996', 1, '2020-03-31 16:14:46');
INSERT INTO `student` VALUES ('3168907105', '3168907105', '123456', '汤锦黛', 2, '福建工程学院', '2016', '1661964670@qq.com', '工程造价', 1601, '13505578250', 1, '2020-03-31 16:14:46');
INSERT INTO `student` VALUES ('3168907106', '3168907106', '123456', '倪裕', 2, '福建工程学院', '2016', '1005521606@qq.com', '工程造价', 1601, '13201591571', 0, '2020-03-31 16:14:46');
INSERT INTO `student` VALUES ('3168907107', '3168907107', '123456', '严霭', 2, '福建工程学院', '2016', '1143800020@qq.com', '工程造价', 1601, '15005848731', 0, '2020-03-31 16:14:46');
INSERT INTO `student` VALUES ('3168907108', '3168907108', '123456', '韩士以', 2, '福建工程学院', '2016', '1289236808@qq.com', '工程造价', 1601, '15106058466', 0, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907109', '3168907109', '123456', '姚之', 2, '福建工程学院', '2016', '1832992278@qq.com', '工程造价', 1601, '13602011127', 1, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907110', '3168907110', '123456', '方思', 2, '福建工程学院', '2016', '1989963715@qq.com', '工程造价', 1601, '13600614939', 0, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907111', '3168907111', '123456', '纪洁梅', 2, '福建工程学院', '2016', '1383214415@qq.com', '工程造价', 1601, '13308227892', 1, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907112', '3168907112', '123456', '元勤', 2, '福建工程学院', '2016', '1866987541@qq.com', '工程造价', 1601, '13104211910', 0, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907113', '3168907113', '123456', '卞时', 2, '福建工程学院', '2016', '1735210726@qq.com', '工程造价', 1601, '15100535297', 0, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907114', '3168907114', '123456', '平心邦', 2, '福建工程学院', '2016', '1837081939@qq.com', '工程造价', 1601, '15702721844', 0, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907115', '3168907115', '123456', '郝俊峰', 2, '福建工程学院', '2016', '1656879212@qq.com', '工程造价', 1601, '13800035977', 1, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907116', '3168907116', '123456', '皮淑', 2, '福建工程学院', '2016', '1216112397@qq.com', '工程造价', 1601, '15003018519', 1, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907117', '3168907117', '123456', '褚哲', 2, '福建工程学院', '2016', '1577585485@qq.com', '工程造价', 1601, '15003394474', 1, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907118', '3168907118', '123456', '张健世', 2, '福建工程学院', '2016', '1297826474@qq.com', '工程造价', 1601, '15103750458', 0, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907119', '3168907119', '123456', '雷倩', 2, '福建工程学院', '2016', '1098388503@qq.com', '工程造价', 1601, '13802892218', 1, '2020-03-31 16:14:47');
INSERT INTO `student` VALUES ('3168907120', '3168907120', '123456', '沈坚和', 2, '福建工程学院', '2016', '1991492248@qq.com', '工程造价', 1601, '13801832013', 0, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907121', '3168907121', '123456', '姚言', 2, '福建工程学院', '2016', '1977537199@qq.com', '工程造价', 1601, '15500196960', 1, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907122', '3168907122', '123456', '云以', 2, '福建工程学院', '2016', '1406507083@qq.com', '工程造价', 1601, '15105657610', 0, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907123', '3168907123', '123456', '华强军', 2, '福建工程学院', '2016', '1592260015@qq.com', '工程造价', 1601, '15206175428', 0, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907124', '3168907124', '123456', '吕彬', 2, '福建工程学院', '2016', '1229833564@qq.com', '工程造价', 1601, '13406662810', 0, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907125', '3168907125', '123456', '贺晶妍', 2, '福建工程学院', '2016', '1430266529@qq.com', '工程造价', 1601, '13000180040', 0, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907126', '3168907126', '123456', '卞茂进', 2, '福建工程学院', '2016', '1355393066@qq.com', '工程造价', 1601, '13604495928', 1, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907127', '3168907127', '123456', '舒克伦', 2, '福建工程学院', '2016', '1582038657@qq.com', '工程造价', 1601, '13707857927', 0, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907128', '3168907128', '123456', '阮卿', 2, '福建工程学院', '2016', '1617713747@qq.com', '工程造价', 1601, '15201670043', 0, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907129', '3168907129', '123456', '阮辉力', 2, '福建工程学院', '2016', '1379602667@qq.com', '工程造价', 1601, '15901637482', 1, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907130', '3168907130', '123456', '苏裕', 2, '福建工程学院', '2016', '1752977198@qq.com', '工程造价', 1601, '13900170960', 0, '2020-03-31 16:14:48');
INSERT INTO `student` VALUES ('3168907201', '3168907201', '123456', '殷茜秋', 2, '福建工程学院', '2016', '1017506028@qq.com', '工程造价', 1602, '15505470052', 0, '2020-03-31 16:18:06');
INSERT INTO `student` VALUES ('3168907202', '3168907202', '123456', '罗飘育', 2, '福建工程学院', '2016', '1156415967@qq.com', '工程造价', 1602, '13400092727', 0, '2020-03-31 16:18:07');
INSERT INTO `student` VALUES ('3168907203', '3168907203', '123456', '沈梅', 2, '福建工程学院', '2016', '1149633410@qq.com', '工程造价', 1602, '13306322232', 0, '2020-03-31 16:18:07');
INSERT INTO `student` VALUES ('3168907204', '3168907204', '123456', '廉友裕', 2, '福建工程学院', '2016', '1509404046@qq.com', '工程造价', 1602, '13600362811', 1, '2020-03-31 16:18:07');
INSERT INTO `student` VALUES ('3168907205', '3168907205', '123456', '葛亮', 2, '福建工程学院', '2016', '1958899029@qq.com', '工程造价', 1602, '13607398376', 0, '2020-03-31 16:18:07');
INSERT INTO `student` VALUES ('3168907206', '3168907206', '123456', '尹有', 2, '福建工程学院', '2016', '1071259276@qq.com', '工程造价', 1602, '15305282849', 0, '2020-03-31 16:18:07');
INSERT INTO `student` VALUES ('3168907207', '3168907207', '123456', '俞凤', 2, '福建工程学院', '2016', '1637772993@qq.com', '工程造价', 1602, '13401005604', 1, '2020-03-31 16:18:07');
INSERT INTO `student` VALUES ('3168907208', '3168907208', '123456', '方栋', 2, '福建工程学院', '2016', '1159191529@qq.com', '工程造价', 1602, '13202328164', 1, '2020-03-31 16:18:07');
INSERT INTO `student` VALUES ('3168907209', '3168907209', '123456', '郝厚庆', 2, '福建工程学院', '2016', '1257954474@qq.com', '工程造价', 1602, '13700452892', 0, '2020-03-31 16:18:07');
INSERT INTO `student` VALUES ('3168907210', '3168907210', '123456', '严敬震', 2, '福建工程学院', '2016', '1541282159@qq.com', '工程造价', 1602, '15604727823', 1, '2020-03-31 16:18:07');
INSERT INTO `student` VALUES ('3168907211', '3168907211', '123456', '陶健世', 2, '福建工程学院', '2016', '1809684252@qq.com', '工程造价', 1602, '13003584437', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907212', '3168907212', '123456', '雷安', 2, '福建工程学院', '2016', '1061729894@qq.com', '工程造价', 1602, '13905287674', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907213', '3168907213', '123456', '曹克伦', 2, '福建工程学院', '2016', '1545706453@qq.com', '工程造价', 1602, '13505481091', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907214', '3168907214', '123456', '史毅', 2, '福建工程学院', '2016', '1012713189@qq.com', '工程造价', 1602, '13004590872', 1, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907215', '3168907215', '123456', '梁磊民', 2, '福建工程学院', '2016', '1597241795@qq.com', '工程造价', 1602, '13002041064', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907216', '3168907216', '123456', '明元全', 2, '福建工程学院', '2016', '1409620059@qq.com', '工程造价', 1602, '15303852449', 1, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907217', '3168907217', '123456', '孟茂进', 2, '福建工程学院', '2016', '1983854150@qq.com', '工程造价', 1602, '13304210187', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907218', '3168907218', '123456', '湛婉娴', 2, '福建工程学院', '2016', '1392548173@qq.com', '工程造价', 1602, '13100121018', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907219', '3168907219', '123456', '孔妹', 2, '福建工程学院', '2016', '1026179320@qq.com', '工程造价', 1602, '15208575211', 1, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907220', '3168907220', '123456', '皮涛', 2, '福建工程学院', '2016', '1550759418@qq.com', '工程造价', 1602, '13404370683', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907221', '3168907221', '123456', '孟萍红', 2, '福建工程学院', '2016', '1585179997@qq.com', '工程造价', 1602, '13800576628', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907222', '3168907222', '123456', '戚亨奇', 2, '福建工程学院', '2016', '1462385211@qq.com', '工程造价', 1602, '15301082128', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907223', '3168907223', '123456', '姚洁梅', 2, '福建工程学院', '2016', '1970667668@qq.com', '工程造价', 1602, '13901175551', 1, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907224', '3168907224', '123456', '鲍云莲', 2, '福建工程学院', '2016', '1575519460@qq.com', '工程造价', 1602, '13807734835', 0, '2020-03-31 16:18:08');
INSERT INTO `student` VALUES ('3168907225', '3168907225', '123456', '穆贵福', 2, '福建工程学院', '2016', '1499233893@qq.com', '工程造价', 1602, '15504494364', 0, '2020-03-31 16:18:09');
INSERT INTO `student` VALUES ('3168907226', '3168907226', '123456', '俞炎德', 2, '福建工程学院', '2016', '1982334669@qq.com', '工程造价', 1602, '15706221579', 0, '2020-03-31 16:18:09');
INSERT INTO `student` VALUES ('3168907227', '3168907227', '123456', '严强军', 2, '福建工程学院', '2016', '1180833784@qq.com', '工程造价', 1602, '13005341016', 0, '2020-03-31 16:18:09');
INSERT INTO `student` VALUES ('3168907228', '3168907228', '123456', '喻厚庆', 2, '福建工程学院', '2016', '1519288248@qq.com', '工程造价', 1602, '15005760370', 0, '2020-03-31 16:18:09');
INSERT INTO `student` VALUES ('3168907229', '3168907229', '123456', '祁天', 2, '福建工程学院', '2016', '1378718688@qq.com', '工程造价', 1602, '15800958873', 0, '2020-03-31 16:18:09');
INSERT INTO `student` VALUES ('3168907230', '3168907230', '123456', '薛胜', 2, '福建工程学院', '2016', '1093568090@qq.com', '工程造价', 1602, '13803442201', 0, '2020-03-31 16:18:09');
INSERT INTO `student` VALUES ('3168908101', '3168908101', '123456', '秦辰', 2, '福建工程学院', '2016', '1580908563@qq.com', '会计学', 1601, '13408726118', 0, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908102', '3168908102', '123456', '苏寒', 2, '福建工程学院', '2016', '1637677130@qq.com', '会计学', 1601, '13006626404', 0, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908103', '3168908103', '123456', '平红', 2, '福建工程学院', '2016', '1446941312@qq.com', '会计学', 1601, '15004750137', 0, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908104', '3168908104', '123456', '平柔', 2, '福建工程学院', '2016', '1815862545@qq.com', '会计学', 1601, '15004742284', 0, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908105', '3168908105', '123456', '彭群豪', 2, '福建工程学院', '2016', '1644989570@qq.com', '会计学', 1601, '13007873005', 0, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908106', '3168908106', '123456', '赵思', 2, '福建工程学院', '2016', '1966363018@qq.com', '会计学', 1601, '15500010856', 0, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908107', '3168908107', '123456', '郑亚', 2, '福建工程学院', '2016', '1325666495@qq.com', '会计学', 1601, '13805853659', 1, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908108', '3168908108', '123456', '章强军', 2, '福建工程学院', '2016', '1923856573@qq.com', '会计学', 1601, '15802978597', 1, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908109', '3168908109', '123456', '苗梅', 2, '福建工程学院', '2016', '1434080046@qq.com', '会计学', 1601, '13100052708', 0, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908110', '3168908110', '123456', '卜若鸣', 2, '福建工程学院', '2016', '1169924528@qq.com', '会计学', 1601, '13504425523', 0, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908111', '3168908111', '123456', '鲍融', 2, '福建工程学院', '2016', '1653987526@qq.com', '会计学', 1601, '13506468489', 0, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908112', '3168908112', '123456', '何兰凤', 2, '福建工程学院', '2016', '1811308342@qq.com', '会计学', 1601, '15007185597', 1, '2020-03-31 16:18:53');
INSERT INTO `student` VALUES ('3168908113', '3168908113', '123456', '成裕', 2, '福建工程学院', '2016', '1755969960@qq.com', '会计学', 1601, '15002478671', 0, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908114', '3168908114', '123456', '于君琴', 2, '福建工程学院', '2016', '1998989151@qq.com', '会计学', 1601, '13500071397', 0, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908115', '3168908115', '123456', '宋翔旭', 2, '福建工程学院', '2016', '1298352553@qq.com', '会计学', 1601, '13100384604', 0, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908116', '3168908116', '123456', '姚娜', 2, '福建工程学院', '2016', '1390265950@qq.com', '会计学', 1601, '15704244011', 0, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908117', '3168908117', '123456', '祁晶妍', 2, '福建工程学院', '2016', '1869283346@qq.com', '会计学', 1601, '15506718014', 0, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908118', '3168908118', '123456', '吴娟', 2, '福建工程学院', '2016', '1685944610@qq.com', '会计学', 1601, '13307725743', 0, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908119', '3168908119', '123456', '任士以', 2, '福建工程学院', '2016', '1824374634@qq.com', '会计学', 1601, '15000075200', 1, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908120', '3168908120', '123456', '席真环', 2, '福建工程学院', '2016', '1278292628@qq.com', '会计学', 1601, '15900467952', 0, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908121', '3168908121', '123456', '湛瑶', 2, '福建工程学院', '2016', '1610455639@qq.com', '会计学', 1601, '13201541499', 0, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908122', '3168908122', '123456', '彭胜', 2, '福建工程学院', '2016', '1087650016@qq.com', '会计学', 1601, '13907484315', 0, '2020-03-31 16:18:54');
INSERT INTO `student` VALUES ('3168908123', '3168908123', '123456', '彭博', 2, '福建工程学院', '2016', '1057370865@qq.com', '会计学', 1601, '15300914321', 0, '2020-03-31 16:18:55');
INSERT INTO `student` VALUES ('3168908124', '3168908124', '123456', '滕心邦', 2, '福建工程学院', '2016', '1509665890@qq.com', '会计学', 1601, '13204761141', 0, '2020-03-31 16:18:55');
INSERT INTO `student` VALUES ('3168908125', '3168908125', '123456', '毛仪', 2, '福建工程学院', '2016', '1699581374@qq.com', '会计学', 1601, '15502465623', 0, '2020-03-31 16:18:55');
INSERT INTO `student` VALUES ('3168908126', '3168908126', '123456', '喻生龙', 2, '福建工程学院', '2016', '1105297916@qq.com', '会计学', 1601, '15706998422', 0, '2020-03-31 16:18:55');
INSERT INTO `student` VALUES ('3168908127', '3168908127', '123456', '汪健世', 2, '福建工程学院', '2016', '1353966243@qq.com', '会计学', 1601, '15300281736', 1, '2020-03-31 16:18:55');
INSERT INTO `student` VALUES ('3168908128', '3168908128', '123456', '酆康星', 2, '福建工程学院', '2016', '1081681687@qq.com', '会计学', 1601, '13907493203', 0, '2020-03-31 16:18:55');
INSERT INTO `student` VALUES ('3168908129', '3168908129', '123456', '范福', 2, '福建工程学院', '2016', '1075651891@qq.com', '会计学', 1601, '13006963789', 0, '2020-03-31 16:18:55');
INSERT INTO `student` VALUES ('3168908130', '3168908130', '123456', '毕娟', 2, '福建工程学院', '2016', '1370818841@qq.com', '会计学', 1601, '13805495016', 0, '2020-03-31 16:18:55');
INSERT INTO `student` VALUES ('3168909101', '3168909101', '123456', '郑云莲', 2, '福建工程学院', '2016', '1586495864@qq.com', '环境工程', 1601, '13508131199', 0, '2020-03-31 16:19:26');
INSERT INTO `student` VALUES ('3168909102', '3168909102', '123456', '和壮', 2, '福建工程学院', '2016', '1065908911@qq.com', '环境工程', 1601, '13201104008', 1, '2020-03-31 16:19:26');
INSERT INTO `student` VALUES ('3168909103', '3168909103', '123456', '陈娜', 2, '福建工程学院', '2016', '1678569921@qq.com', '环境工程', 1601, '15003709063', 1, '2020-03-31 16:19:26');
INSERT INTO `student` VALUES ('3168909104', '3168909104', '123456', '元德', 2, '福建工程学院', '2016', '1978096979@qq.com', '环境工程', 1601, '13502894821', 0, '2020-03-31 16:19:26');
INSERT INTO `student` VALUES ('3168909105', '3168909105', '123456', '齐江超', 2, '福建工程学院', '2016', '1416299359@qq.com', '环境工程', 1601, '15301850413', 0, '2020-03-31 16:19:26');
INSERT INTO `student` VALUES ('3168909106', '3168909106', '123456', '纪艳', 2, '福建工程学院', '2016', '1208397988@qq.com', '环境工程', 1601, '15007214278', 1, '2020-03-31 16:19:26');
INSERT INTO `student` VALUES ('3168909107', '3168909107', '123456', '毕楠榕', 2, '福建工程学院', '2016', '1172977089@qq.com', '环境工程', 1601, '15508767430', 0, '2020-03-31 16:19:26');
INSERT INTO `student` VALUES ('3168909108', '3168909108', '123456', '毛蓉眉', 2, '福建工程学院', '2016', '1705047780@qq.com', '环境工程', 1601, '15108688029', 0, '2020-03-31 16:19:26');
INSERT INTO `student` VALUES ('3168909109', '3168909109', '123456', '郎时', 2, '福建工程学院', '2016', '1981239410@qq.com', '环境工程', 1601, '13007282958', 0, '2020-03-31 16:19:26');
INSERT INTO `student` VALUES ('3168909110', '3168909110', '123456', '顾庆', 2, '福建工程学院', '2016', '1206266355@qq.com', '环境工程', 1601, '15805940129', 1, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909111', '3168909111', '123456', '毛奇', 2, '福建工程学院', '2016', '1030205905@qq.com', '环境工程', 1601, '15703356148', 1, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909112', '3168909112', '123456', '庞言', 2, '福建工程学院', '2016', '1022321947@qq.com', '环境工程', 1601, '13306870002', 1, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909113', '3168909113', '123456', '罗策腾', 2, '福建工程学院', '2016', '1509639947@qq.com', '环境工程', 1601, '13207970791', 0, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909114', '3168909114', '123456', '秦榕', 2, '福建工程学院', '2016', '1577757202@qq.com', '环境工程', 1601, '15706105132', 0, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909115', '3168909115', '123456', '孟民', 2, '福建工程学院', '2016', '1277323985@qq.com', '环境工程', 1601, '13804661628', 0, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909116', '3168909116', '123456', '云建家', 2, '福建工程学院', '2016', '1483998695@qq.com', '环境工程', 1601, '13005174820', 0, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909117', '3168909117', '123456', '姜军', 2, '福建工程学院', '2016', '1609001938@qq.com', '环境工程', 1601, '15704477681', 0, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909118', '3168909118', '123456', '齐浩亮', 2, '福建工程学院', '2016', '1385200542@qq.com', '环境工程', 1601, '13008228882', 0, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909119', '3168909119', '123456', '董健世', 2, '福建工程学院', '2016', '1437335456@qq.com', '环境工程', 1601, '15600796565', 1, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909120', '3168909120', '123456', '云鹏泽', 2, '福建工程学院', '2016', '1100766485@qq.com', '环境工程', 1601, '15701030384', 0, '2020-03-31 16:19:27');
INSERT INTO `student` VALUES ('3168909121', '3168909121', '123456', '梁鸣', 2, '福建工程学院', '2016', '1917955608@qq.com', '环境工程', 1601, '13007401889', 0, '2020-03-31 16:19:28');
INSERT INTO `student` VALUES ('3168909122', '3168909122', '123456', '伍固之', 2, '福建工程学院', '2016', '1235160248@qq.com', '环境工程', 1601, '15004802706', 1, '2020-03-31 16:19:28');
INSERT INTO `student` VALUES ('3168909123', '3168909123', '123456', '戴翰', 2, '福建工程学院', '2016', '1740864253@qq.com', '环境工程', 1601, '15601550653', 0, '2020-03-31 16:19:28');
INSERT INTO `student` VALUES ('3168909124', '3168909124', '123456', '孙松善', 2, '福建工程学院', '2016', '1131880784@qq.com', '环境工程', 1601, '13306801848', 0, '2020-03-31 16:19:28');
INSERT INTO `student` VALUES ('3168909125', '3168909125', '123456', '戚祥', 2, '福建工程学院', '2016', '1609631730@qq.com', '环境工程', 1601, '15100350867', 1, '2020-03-31 16:19:28');
INSERT INTO `student` VALUES ('3168909126', '3168909126', '123456', '余顺', 2, '福建工程学院', '2016', '1159502859@qq.com', '环境工程', 1601, '15607924859', 0, '2020-03-31 16:19:28');
INSERT INTO `student` VALUES ('3168909127', '3168909127', '123456', '华琰', 2, '福建工程学院', '2016', '1498254423@qq.com', '环境工程', 1601, '15003226614', 0, '2020-03-31 16:19:28');
INSERT INTO `student` VALUES ('3168909128', '3168909128', '123456', '钱若鸣', 2, '福建工程学院', '2016', '1691711016@qq.com', '环境工程', 1601, '15504366173', 0, '2020-03-31 16:19:29');
INSERT INTO `student` VALUES ('3168909129', '3168909129', '123456', '常宁欣', 2, '福建工程学院', '2016', '1381211403@qq.com', '环境工程', 1601, '15801144873', 0, '2020-03-31 16:19:29');
INSERT INTO `student` VALUES ('3168909130', '3168909130', '123456', '成炎德', 2, '福建工程学院', '2016', '1748840703@qq.com', '环境工程', 1601, '13206864689', 0, '2020-03-31 16:19:29');

-- ----------------------------
-- Table structure for student_course
-- ----------------------------
DROP TABLE IF EXISTS `student_course`;
CREATE TABLE `student_course`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `course_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `score` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `point` decimal(4, 2) NOT NULL,
  `credits` decimal(4, 2) NOT NULL,
  `term` tinyint(4) NOT NULL,
  `year` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 475 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student_course
-- ----------------------------
INSERT INTO `student_course` VALUES (1, '3168901101', '2016011001', '数字电路基础', '75', 2.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (2, '3168901102', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (3, '3168901103', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (4, '3168901104', '2016011001', '数字电路基础', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (5, '3168901105', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (6, '3168901106', '2016011001', '数字电路基础', '98', 4.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (7, '3168901107', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (8, '3168901108', '2016011001', '数字电路基础', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (9, '3168901109', '2016011001', '数字电路基础', '67', 1.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (10, '3168901110', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (11, '3168901111', '2016011001', '数字电路基础', '32', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (12, '3168901112', '2016011001', '数字电路基础', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (13, '3168901113', '2016011001', '数字电路基础', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (14, '3168901114', '2016011001', '数字电路基础', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (15, '3168901115', '2016011001', '数字电路基础', '23', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (16, '3168901116', '2016011001', '数字电路基础', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (17, '3168901117', '2016011001', '数字电路基础', '64', 1.40, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (18, '3168901118', '2016011001', '数字电路基础', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (19, '3168901119', '2016011001', '数字电路基础', '34', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (20, '3168901120', '2016011001', '数字电路基础', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (21, '3168901121', '2016011001', '数字电路基础', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (22, '3168901122', '2016011001', '数字电路基础', '34', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (23, '3168901123', '2016011001', '数字电路基础', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (24, '3168901124', '2016011001', '数字电路基础', '34', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (25, '3168901125', '2016011001', '数字电路基础', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (26, '3168901126', '2016011001', '数字电路基础', '75', 2.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (27, '3168901127', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (28, '3168901128', '2016011001', '数字电路基础', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (29, '3168901129', '2016011001', '数字电路基础', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (30, '3168901130', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (31, '3168901131', '2016011001', '数字电路基础', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (32, '3168901132', '2016011001', '数字电路基础', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (33, '3168901133', '2016011001', '数字电路基础', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (34, '3168901134', '2016011001', '数字电路基础', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (35, '3168901135', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (36, '3168901136', '2016011001', '数字电路基础', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (37, '3168901137', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (38, '3168901138', '2016011001', '数字电路基础', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (39, '3168901139', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (40, '3168901140', '2016011001', '数字电路基础', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (41, '3168901141', '2016011001', '数字电路基础', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (42, '3168901142', '2016011001', '数字电路基础', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (43, '3168901143', '2016011001', '数字电路基础', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (44, '3168901144', '2016011001', '数字电路基础', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (45, '3168901145', '2016011001', '数字电路基础', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (46, '3168901146', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (47, '3168901147', '2016011001', '数字电路基础', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (48, '3168901148', '2016011001', '数字电路基础', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (49, '3168901149', '2016011001', '数字电路基础', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (50, '3168901150', '2016011001', '数字电路基础', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (51, '3168901101', '2016011002', '大学物理', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (52, '3168901102', '2016011002', '大学物理', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (53, '3168901103', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (54, '3168901104', '2016011002', '大学物理', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (55, '3168901105', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (56, '3168901106', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (57, '3168901107', '2016011002', '大学物理', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (58, '3168901108', '2016011002', '大学物理', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (59, '3168901109', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (60, '3168901110', '2016011002', '大学物理', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (61, '3168901111', '2016011002', '大学物理', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (62, '3168901112', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (63, '3168901113', '2016011002', '大学物理', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (64, '3168901114', '2016011002', '大学物理', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (65, '3168901115', '2016011002', '大学物理', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (66, '3168901116', '2016011002', '大学物理', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (67, '3168901117', '2016011002', '大学物理', '67', 1.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (68, '3168901118', '2016011002', '大学物理', '67', 1.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (69, '3168901119', '2016011002', '大学物理', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (70, '3168901120', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (71, '3168901121', '2016011002', '大学物理', '34', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (72, '3168901122', '2016011002', '大学物理', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (73, '3168901123', '2016011002', '大学物理', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (74, '3168901124', '2016011002', '大学物理', '68', 1.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (75, '3168901125', '2016011002', '大学物理', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (76, '3168901126', '2016011002', '大学物理', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (77, '3168901127', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (78, '3168901128', '2016011002', '大学物理', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (79, '3168901129', '2016011002', '大学物理', '97', 4.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (80, '3168901130', '2016011002', '大学物理', '67', 1.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (81, '3168901131', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (82, '3168901132', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (83, '3168901133', '2016011002', '大学物理', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (84, '3168901134', '2016011002', '大学物理', '77', 2.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (85, '3168901135', '2016011002', '大学物理', '98', 4.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (86, '3168901136', '2016011002', '大学物理', '32', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (87, '3168901137', '2016011002', '大学物理', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (88, '3168901138', '2016011002', '大学物理', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (89, '3168901139', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (90, '3168901140', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (91, '3168901141', '2016011002', '大学物理', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (92, '3168901142', '2016011002', '大学物理', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (93, '3168901143', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (94, '3168901144', '2016011002', '大学物理', '75', 2.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (95, '3168901145', '2016011002', '大学物理', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (96, '3168901146', '2016011002', '大学物理', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (97, '3168901147', '2016011002', '大学物理', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (98, '3168901148', '2016011002', '大学物理', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (99, '3168901149', '2016011002', '大学物理', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (100, '3168901150', '2016011002', '大学物理', '34', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (101, '3168901101', '2016011003', '线性代数', '23', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (102, '3168901102', '2016011003', '线性代数', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (103, '3168901103', '2016011003', '线性代数', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (104, '3168901104', '2016011003', '线性代数', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (105, '3168901105', '2016011003', '线性代数', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (106, '3168901106', '2016011003', '线性代数', '75', 2.50, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (107, '3168901107', '2016011003', '线性代数', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (108, '3168901108', '2016011003', '线性代数', '76', 2.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (109, '3168901109', '2016011003', '线性代数', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (110, '3168901110', '2016011003', '线性代数', '65', 1.50, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (111, '3168901111', '2016011003', '线性代数', '67', 1.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (112, '3168901112', '2016011003', '线性代数', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (113, '3168901113', '2016011003', '线性代数', '65', 1.50, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (114, '3168901114', '2016011003', '线性代数', '76', 2.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (115, '3168901115', '2016011003', '线性代数', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (116, '3168901116', '2016011003', '线性代数', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (117, '3168901117', '2016011003', '线性代数', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (118, '3168901118', '2016011003', '线性代数', '76', 2.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (119, '3168901119', '2016011003', '线性代数', '65', 1.50, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (120, '3168901120', '2016011003', '线性代数', '65', 1.50, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (121, '3168901121', '2016011003', '线性代数', '65', 1.50, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (122, '3168901122', '2016011003', '线性代数', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (123, '3168901123', '2016011003', '线性代数', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (124, '3168901124', '2016011003', '线性代数', '34', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (125, '3168901125', '2016011003', '线性代数', '65', 1.50, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (126, '3168901126', '2016011003', '线性代数', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (127, '3168901127', '2016011003', '线性代数', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (128, '3168901128', '2016011003', '线性代数', '65', 1.50, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (129, '3168901129', '2016011003', '线性代数', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (130, '3168901130', '2016011003', '线性代数', '67', 1.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (131, '3168901131', '2016011003', '线性代数', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (132, '3168901132', '2016011003', '线性代数', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (133, '3168901133', '2016011003', '线性代数', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (134, '3168901134', '2016011003', '线性代数', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (135, '3168901135', '2016011003', '线性代数', '98', 4.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (136, '3168901136', '2016011003', '线性代数', '65', 1.50, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (137, '3168901137', '2016011003', '线性代数', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (138, '3168901138', '2016011003', '线性代数', '98', 4.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (139, '3168901139', '2016011003', '线性代数', '67', 1.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (140, '3168901140', '2016011003', '线性代数', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (141, '3168901141', '2016011003', '线性代数', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (142, '3168901142', '2016011003', '线性代数', '67', 1.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (143, '3168901143', '2016011003', '线性代数', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (144, '3168901144', '2016011003', '线性代数', '98', 4.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (145, '3168901145', '2016011003', '线性代数', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (146, '3168901146', '2016011003', '线性代数', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (147, '3168901147', '2016011003', '线性代数', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (148, '3168901148', '2016011003', '线性代数', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (149, '3168901149', '2016011003', '线性代数', '66', 1.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (150, '3168901150', '2016011003', '线性代数', '77', 2.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (151, '3168901101', '2016011004', '复变函数', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (152, '3168901102', '2016011004', '复变函数', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (153, '3168901103', '2016011004', '复变函数', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (154, '3168901104', '2016011004', '复变函数', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (155, '3168901105', '2016011004', '复变函数', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (156, '3168901106', '2016011004', '复变函数', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (157, '3168901107', '2016011004', '复变函数', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (158, '3168901108', '2016011004', '复变函数', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (159, '3168901109', '2016011004', '复变函数', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (160, '3168901110', '2016011004', '复变函数', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (161, '3168901111', '2016011004', '复变函数', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (162, '3168901112', '2016011004', '复变函数', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (163, '3168901113', '2016011004', '复变函数', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (164, '3168901114', '2016011004', '复变函数', '98', 4.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (165, '3168901115', '2016011004', '复变函数', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (166, '3168901116', '2016011004', '复变函数', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (167, '3168901117', '2016011004', '复变函数', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (168, '3168901118', '2016011004', '复变函数', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (169, '3168901119', '2016011004', '复变函数', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (170, '3168901120', '2016011004', '复变函数', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (171, '3168901121', '2016011004', '复变函数', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (172, '3168901122', '2016011004', '复变函数', '78', 2.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (173, '3168901123', '2016011004', '复变函数', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (174, '3168901124', '2016011004', '复变函数', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (175, '3168901125', '2016011004', '复变函数', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (176, '3168901126', '2016011004', '复变函数', '67', 1.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (177, '3168901127', '2016011004', '复变函数', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (178, '3168901128', '2016011004', '复变函数', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (179, '3168901129', '2016011004', '复变函数', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (180, '3168901130', '2016011004', '复变函数', '77', 2.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (181, '3168901131', '2016011004', '复变函数', '78', 2.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (182, '3168901132', '2016011004', '复变函数', '78', 2.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (183, '3168901133', '2016011004', '复变函数', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (184, '3168901134', '2016011004', '复变函数', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (185, '3168901135', '2016011004', '复变函数', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (186, '3168901136', '2016011004', '复变函数', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (187, '3168901137', '2016011004', '复变函数', '33', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (188, '3168901138', '2016011004', '复变函数', '67', 1.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (189, '3168901139', '2016011004', '复变函数', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (190, '3168901140', '2016011004', '复变函数', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (191, '3168901141', '2016011004', '复变函数', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (192, '3168901142', '2016011004', '复变函数', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (193, '3168901143', '2016011004', '复变函数', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (194, '3168901144', '2016011004', '复变函数', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (195, '3168901145', '2016011004', '复变函数', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (196, '3168901146', '2016011004', '复变函数', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (197, '3168901147', '2016011004', '复变函数', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (198, '3168901148', '2016011004', '复变函数', '73', 2.30, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (199, '3168901149', '2016011004', '复变函数', '32', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (200, '3168901150', '2016011004', '复变函数', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (201, '3168901101', '2016011005', '模拟电子线路', '67', 1.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (202, '3168901102', '2016011005', '模拟电子线路', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (203, '3168901103', '2016011005', '模拟电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (204, '3168901104', '2016011005', '模拟电子线路', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (205, '3168901105', '2016011005', '模拟电子线路', '64', 1.40, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (206, '3168901106', '2016011005', '模拟电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (207, '3168901107', '2016011005', '模拟电子线路', '77', 2.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (208, '3168901108', '2016011005', '模拟电子线路', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (209, '3168901109', '2016011005', '模拟电子线路', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (210, '3168901110', '2016011005', '模拟电子线路', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (211, '3168901111', '2016011005', '模拟电子线路', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (212, '3168901112', '2016011005', '模拟电子线路', '74', 2.40, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (213, '3168901113', '2016011005', '模拟电子线路', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (214, '3168901114', '2016011005', '模拟电子线路', '57', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (215, '3168901115', '2016011005', '模拟电子线路', '85', 3.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (216, '3168901116', '2016011005', '模拟电子线路', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (217, '3168901117', '2016011005', '模拟电子线路', '85', 3.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (218, '3168901118', '2016011005', '模拟电子线路', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (219, '3168901119', '2016011005', '模拟电子线路', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (220, '3168901120', '2016011005', '模拟电子线路', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (221, '3168901121', '2016011005', '模拟电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (222, '3168901122', '2016011005', '模拟电子线路', '34', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (223, '3168901123', '2016011005', '模拟电子线路', '75', 2.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (224, '3168901124', '2016011005', '模拟电子线路', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (225, '3168901125', '2016011005', '模拟电子线路', '74', 2.40, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (226, '3168901126', '2016011005', '模拟电子线路', '77', 2.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (227, '3168901127', '2016011005', '模拟电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (228, '3168901128', '2016011005', '模拟电子线路', '75', 2.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (229, '3168901129', '2016011005', '模拟电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (230, '3168901130', '2016011005', '模拟电子线路', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (231, '3168901131', '2016011005', '模拟电子线路', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (232, '3168901132', '2016011005', '模拟电子线路', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (233, '3168901133', '2016011005', '模拟电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (234, '3168901134', '2016011005', '模拟电子线路', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (235, '3168901135', '2016011005', '模拟电子线路', '97', 4.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (236, '3168901136', '2016011005', '模拟电子线路', '46', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (237, '3168901137', '2016011005', '模拟电子线路', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (238, '3168901138', '2016011005', '模拟电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (239, '3168901139', '2016011005', '模拟电子线路', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (240, '3168901140', '2016011005', '模拟电子线路', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (241, '3168901141', '2016011005', '模拟电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (242, '3168901142', '2016011005', '模拟电子线路', '67', 1.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (243, '3168901143', '2016011005', '模拟电子线路', '67', 1.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (244, '3168901144', '2016011005', '模拟电子线路', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (245, '3168901145', '2016011005', '模拟电子线路', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (246, '3168901146', '2016011005', '模拟电子线路', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (247, '3168901147', '2016011005', '模拟电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (248, '3168901148', '2016011005', '模拟电子线路', '76', 2.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (249, '3168901149', '2016011005', '模拟电子线路', '46', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (250, '3168901150', '2016011005', '模拟电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (251, '3168901101', '2016011006', '信号与系统', '35', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (252, '3168901102', '2016011006', '信号与系统', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (253, '3168901103', '2016011006', '信号与系统', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (254, '3168901104', '2016011006', '信号与系统', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (255, '3168901105', '2016011006', '信号与系统', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (256, '3168901106', '2016011006', '信号与系统', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (257, '3168901107', '2016011006', '信号与系统', '74', 2.40, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (258, '3168901108', '2016011006', '信号与系统', '86', 3.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (259, '3168901109', '2016011006', '信号与系统', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (260, '3168901110', '2016011006', '信号与系统', '85', 3.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (261, '3168901111', '2016011006', '信号与系统', '86', 3.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (262, '3168901112', '2016011006', '信号与系统', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (263, '3168901113', '2016011006', '信号与系统', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (264, '3168901114', '2016011006', '信号与系统', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (265, '3168901115', '2016011006', '信号与系统', '83', 3.30, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (266, '3168901116', '2016011006', '信号与系统', '75', 2.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (267, '3168901117', '2016011006', '信号与系统', '23', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (268, '3168901118', '2016011006', '信号与系统', '86', 3.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (269, '3168901119', '2016011006', '信号与系统', '37', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (270, '3168901120', '2016011006', '信号与系统', '75', 2.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (271, '3168901121', '2016011006', '信号与系统', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (272, '3168901122', '2016011006', '信号与系统', '34', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (273, '3168901123', '2016011006', '信号与系统', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (274, '3168901124', '2016011006', '信号与系统', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (275, '3168901125', '2016011006', '信号与系统', '86', 3.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (276, '3168901126', '2016011006', '信号与系统', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (277, '3168901127', '2016011006', '信号与系统', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (278, '3168901128', '2016011006', '信号与系统', '86', 3.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (279, '3168901129', '2016011006', '信号与系统', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (280, '3168901130', '2016011006', '信号与系统', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (281, '3168901131', '2016011006', '信号与系统', '95', 4.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (282, '3168901132', '2016011006', '信号与系统', '67', 1.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (283, '3168901133', '2016011006', '信号与系统', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (284, '3168901134', '2016011006', '信号与系统', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (285, '3168901135', '2016011006', '信号与系统', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (286, '3168901136', '2016011006', '信号与系统', '34', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (287, '3168901137', '2016011006', '信号与系统', '77', 2.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (288, '3168901138', '2016011006', '信号与系统', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (289, '3168901139', '2016011006', '信号与系统', '86', 3.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (290, '3168901140', '2016011006', '信号与系统', '76', 2.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (291, '3168901141', '2016011006', '信号与系统', '23', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (292, '3168901142', '2016011006', '信号与系统', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (293, '3168901143', '2016011006', '信号与系统', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (294, '3168901144', '2016011006', '信号与系统', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (295, '3168901145', '2016011006', '信号与系统', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (296, '3168901146', '2016011006', '信号与系统', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (297, '3168901147', '2016011006', '信号与系统', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (298, '3168901148', '2016011006', '信号与系统', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (299, '3168901149', '2016011006', '信号与系统', '43', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (300, '3168901150', '2016011006', '信号与系统', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (301, '3168904101', '2016041001', '高频电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (302, '3168904102', '2016041001', '高频电子线路', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (303, '3168904103', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (304, '3168904104', '2016041001', '高频电子线路', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (305, '3168904105', '2016041001', '高频电子线路', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (306, '3168904106', '2016041001', '高频电子线路', '94', 4.40, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (307, '3168904107', '2016041001', '高频电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (308, '3168904108', '2016041001', '高频电子线路', '66', 1.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (309, '3168904109', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (310, '3168904110', '2016041001', '高频电子线路', '88', 3.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (311, '3168904111', '2016041001', '高频电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (312, '3168904112', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (313, '3168904113', '2016041001', '高频电子线路', '98', 4.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (314, '3168904114', '2016041001', '高频电子线路', '88', 3.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (315, '3168904115', '2016041001', '高频电子线路', '98', 4.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (316, '3168904116', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (317, '3168904117', '2016041001', '高频电子线路', '99', 4.90, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (318, '3168904118', '2016041001', '高频电子线路', '88', 3.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (319, '3168904119', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (320, '3168904120', '2016041001', '高频电子线路', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (321, '3168904121', '2016041001', '高频电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (322, '3168904122', '2016041001', '高频电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (323, '3168904123', '2016041001', '高频电子线路', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (324, '3168904124', '2016041001', '高频电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (325, '3168904125', '2016041001', '高频电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (326, '3168904126', '2016041001', '高频电子线路', '12', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (327, '3168904127', '2016041001', '高频电子线路', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (328, '3168904128', '2016041001', '高频电子线路', '66', 1.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (329, '3168904129', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (330, '3168904130', '2016041001', '高频电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (331, '3168904131', '2016041001', '高频电子线路', '56', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (332, '3168904132', '2016041001', '高频电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (333, '3168904133', '2016041001', '高频电子线路', '100', 5.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (334, '3168904134', '2016041001', '高频电子线路', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (335, '3168904135', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (336, '3168904136', '2016041001', '高频电子线路', '89', 3.90, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (337, '3168904137', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (338, '3168904138', '2016041001', '高频电子线路', '98', 4.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (339, '3168904139', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (340, '3168904140', '2016041001', '高频电子线路', '89', 3.90, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (341, '3168904141', '2016041001', '高频电子线路', '89', 3.90, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (342, '3168904142', '2016041001', '高频电子线路', '89', 3.90, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (343, '3168904143', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (344, '3168904144', '2016041001', '高频电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (345, '3168904145', '2016041001', '高频电子线路', '66', 1.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (346, '3168904146', '2016041001', '高频电子线路', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (347, '3168904147', '2016041001', '高频电子线路', '79', 2.90, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (348, '3168904148', '2016041001', '高频电子线路', '88', 3.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (349, '3168904149', '2016041001', '高频电子线路', '65', 1.50, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (350, '3168904150', '2016041001', '高频电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (351, '3168904151', '2016041001', '高频电子线路', '66', 1.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (352, '3168904152', '2016041001', '高频电子线路', '87', 3.70, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (353, '3168904153', '2016041001', '高频电子线路', '99', 4.90, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (354, '3168904154', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (355, '3168904155', '2016041001', '高频电子线路', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (356, '3168904156', '2016041001', '高频电子线路', '66', 1.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (357, '3168904157', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (358, '3168904158', '2016041001', '高频电子线路', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (359, '3168904159', '2016041001', '高频电子线路', '66', 1.60, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (360, '3168904160', '2016041001', '高频电子线路', '78', 2.80, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (361, '3168902111', '2016021001', '物联网工程导论', '88', 3.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (362, '3168902112', '2016021001', '物联网工程导论', '78', 2.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (363, '3168902113', '2016021001', '物联网工程导论', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (364, '3168902114', '2016021001', '物联网工程导论', '66', 1.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (365, '3168902115', '2016021001', '物联网工程导论', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (366, '3168902116', '2016021001', '物联网工程导论', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (367, '3168902117', '2016021001', '物联网工程导论', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (368, '3168902118', '2016021001', '物联网工程导论', '66', 1.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (369, '3168902119', '2016021001', '物联网工程导论', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (370, '3168902120', '2016021001', '物联网工程导论', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (371, '3168902121', '2016021001', '物联网工程导论', '88', 3.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (372, '3168902122', '2016021001', '物联网工程导论', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (373, '3168902123', '2016021001', '物联网工程导论', '98', 4.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (374, '3168902124', '2016021001', '物联网工程导论', '78', 2.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (375, '3168902125', '2016021001', '物联网工程导论', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (376, '3168902126', '2016021001', '物联网工程导论', '66', 1.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (377, '3168902127', '2016021001', '物联网工程导论', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (378, '3168902128', '2016021001', '物联网工程导论', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (379, '3168902129', '2016021001', '物联网工程导论', '88', 3.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (380, '3168902130', '2016021001', '物联网工程导论', '98', 4.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (381, '3168902131', '2016021001', '物联网工程导论', '78', 2.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (382, '3168902132', '2016021001', '物联网工程导论', '98', 4.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (383, '3168902133', '2016021001', '物联网工程导论', '88', 3.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (384, '3168902134', '2016021001', '物联网工程导论', '78', 2.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (385, '3168902135', '2016021001', '物联网工程导论', '98', 4.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (386, '3168902136', '2016021001', '物联网工程导论', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (387, '3168902137', '2016021001', '物联网工程导论', '100', 5.00, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (388, '3168902138', '2016021001', '物联网工程导论', '88', 3.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (389, '3168902139', '2016021001', '物联网工程导论', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (390, '3168902140', '2016021001', '物联网工程导论', '44', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (391, '3168902102', '2016021001', '物联网工程导论', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (392, '3168902103', '2016021001', '物联网工程导论', '89', 3.90, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (393, '3168902104', '2016021001', '物联网工程导论', '78', 2.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (394, '3168902105', '2016021001', '物联网工程导论', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (395, '3168902106', '2016021001', '物联网工程导论', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (396, '3168902107', '2016021001', '物联网工程导论', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (397, '3168902108', '2016021001', '物联网工程导论', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (398, '3168902109', '2016021001', '物联网工程导论', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (399, '3168902110', '2016021001', '物联网工程导论', '66', 1.60, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (400, '3168902101', '2016021001', '物联网工程导论', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (401, '3168902141', '2016021001', '物联网工程导论', '87', 3.70, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (402, '3168902142', '2016021001', '物联网工程导论', '88', 3.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (403, '3168902143', '2016021001', '物联网工程导论', '98', 4.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (404, '3168902144', '2016021001', '物联网工程导论', '78', 2.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (405, '3168902145', '2016021001', '物联网工程导论', '54', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (406, '3168902146', '2016021001', '物联网工程导论', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (407, '3168902147', '2016021001', '物联网工程导论', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (408, '3168902148', '2016021001', '物联网工程导论', '45', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (409, '3168902149', '2016021001', '物联网工程导论', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (410, '3168902150', '2016021001', '物联网工程导论', '65', 1.50, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (411, '3168903101', '2016031001', '计算机网络技术', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (412, '3168903102', '2016031001', '计算机网络技术', '55', 0.00, 0.00, 1, 2016);
INSERT INTO `student_course` VALUES (413, '3168903103', '2016031001', '计算机网络技术', '76', 2.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (414, '3168903104', '2016031001', '计算机网络技术', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (415, '3168903105', '2016031001', '计算机网络技术', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (416, '3168903106', '2016031001', '计算机网络技术', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (417, '3168903107', '2016031001', '计算机网络技术', '76', 2.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (418, '3168903108', '2016031001', '计算机网络技术', '76', 2.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (419, '3168903109', '2016031001', '计算机网络技术', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (420, '3168903110', '2016031001', '计算机网络技术', '67', 1.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (421, '3168903111', '2016031001', '计算机网络技术', '76', 2.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (422, '3168903112', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (423, '3168903113', '2016031001', '计算机网络技术', '66', 1.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (424, '3168903114', '2016031001', '计算机网络技术', '77', 2.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (425, '3168903115', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (426, '3168903116', '2016031001', '计算机网络技术', '99', 4.90, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (427, '3168903117', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (428, '3168903118', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (429, '3168903119', '2016031001', '计算机网络技术', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (430, '3168903120', '2016031001', '计算机网络技术', '98', 4.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (431, '3168903121', '2016031001', '计算机网络技术', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (432, '3168903122', '2016031001', '计算机网络技术', '89', 3.90, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (433, '3168903123', '2016031001', '计算机网络技术', '77', 2.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (434, '3168903124', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (435, '3168903125', '2016031001', '计算机网络技术', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (436, '3168903126', '2016031001', '计算机网络技术', '98', 4.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (437, '3168903127', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (438, '3168903128', '2016031001', '计算机网络技术', '66', 1.60, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (439, '3168903129', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (440, '3168903130', '2016031001', '计算机网络技术', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (441, '3168903131', '2016031001', '计算机网络技术', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (442, '3168903132', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (443, '3168903133', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (444, '3168903134', '2016031001', '计算机网络技术', '77', 2.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (445, '3168903135', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (446, '3168903136', '2016031001', '计算机网络技术', '98', 4.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (447, '3168903137', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (448, '3168903138', '2016031001', '计算机网络技术', '100', 5.00, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (449, '3168903139', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (450, '3168903140', '2016031001', '计算机网络技术', '98', 4.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (451, '3168903141', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (452, '3168903142', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (453, '3168903143', '2016031001', '计算机网络技术', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (454, '3168903144', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (455, '3168903145', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (456, '3168903146', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (457, '3168903147', '2016031001', '计算机网络技术', '99', 4.90, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (458, '3168903148', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (459, '3168903149', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (460, '3168903150', '2016031001', '计算机网络技术', '77', 2.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (461, '3168903151', '2016031001', '计算机网络技术', '89', 3.90, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (462, '3168903152', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (463, '3168903153', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (464, '3168903154', '2016031001', '计算机网络技术', '98', 4.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (465, '3168903155', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (466, '3168903156', '2016031001', '计算机网络技术', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (467, '3168903157', '2016031001', '计算机网络技术', '77', 2.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (468, '3168903158', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (469, '3168903159', '2016031001', '计算机网络技术', '87', 3.70, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (470, '3168903160', '2016031001', '计算机网络技术', '78', 2.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (471, '3168901101', '2016011008', '体育', '88', 3.80, 1.00, 1, 2016);
INSERT INTO `student_course` VALUES (472, '3168901101', '2016011010', '多媒体技术', '88', 3.80, 2.00, 1, 2016);
INSERT INTO `student_course` VALUES (473, '3168901101', '2016011007', '大学英语', '80', 3.00, 4.00, 1, 2016);
INSERT INTO `student_course` VALUES (474, '3168901101', '2016011009', '电子技术', '62', 1.20, 2.00, 1, 2016);

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `level` tinyint(4) NOT NULL DEFAULT 1,
  `school` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0',
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `sex` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3890311 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES (3890001, '3890001', '159357', '冯静淑', 1, '福建工程学院', '1963551835@qq.com', '15501905622', 1, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890011, '3890011', '159357', '沈芝玉', 1, '福建工程学院', '1708884815@qq.com', '13306387834', 1, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890021, '3890021', '159357', '花启', 1, '福建工程学院', '1544192276@qq.com', '13507731614', 1, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890030, '3890030', '159357', '余之', 1, '福建工程学院', '1625877976@qq.com', '15300308560', 0, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890040, '3890040', '159357', '尤爱妹', 1, '福建工程学院', '1034979625@qq.com', '13004971520', 0, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890050, '3890050', '159357', '韩欢霄', 1, '福建工程学院', '1401785583@qq.com', '15203875368', 0, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890060, '3890060', '159357', '卞林有', 1, '福建工程学院', '1786307189@qq.com', '15806324835', 0, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890070, '3890070', '159357', '时松善', 1, '福建工程学院', '1967037674@qq.com', '15007264285', 0, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890080, '3890080', '159357', '雷谦', 1, '福建工程学院', '1349297112@qq.com', '15803877153', 0, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890090, '3890090', '159357', '岑志', 1, '福建工程学院', '1529310157@qq.com', '15305324810', 0, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890100, '3890100', '159357', '闵世', 1, '福建工程学院', '1562878504@qq.com', '13801569100', 0, '2020-03-31 17:10:07');
INSERT INTO `teacher` VALUES (3890111, '3890111', '159357', '倪峰', 1, '福建工程学院', '1218208094@qq.com', '13201196252', 1, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890121, '3890121', '159357', '乐博', 1, '福建工程学院', '1878740423@qq.com', '15707822243', 1, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890130, '3890130', '159357', '张河哲', 1, '福建工程学院', '1418974154@qq.com', '13903362620', 0, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890140, '3890140', '159357', '水达安', 1, '福建工程学院', '1861931683@qq.com', '13803977654', 0, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890150, '3890150', '159357', '余进', 1, '福建工程学院', '1986037053@qq.com', '15200484007', 0, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890160, '3890160', '159357', '水昌成', 1, '福建工程学院', '1222509395@qq.com', '13301415159', 0, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890170, '3890170', '159357', '邬爽', 1, '福建工程学院', '1920238756@qq.com', '15706327447', 0, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890180, '3890180', '159357', '穆思', 1, '福建工程学院', '1514580859@qq.com', '13203831721', 0, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890191, '3890191', '159357', '张榕', 1, '福建工程学院', '1040370175@qq.com', '13701634820', 1, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890201, '3890201', '159357', '喻清', 1, '福建工程学院', '1834713942@qq.com', '15200438039', 1, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890211, '3890211', '159357', '薛保', 1, '福建工程学院', '1601714145@qq.com', '13000134418', 1, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890221, '3890221', '159357', '薛胜', 1, '福建工程学院', '1362849132@qq.com', '13305326764', 1, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890230, '3890230', '159357', '陈学祥', 1, '福建工程学院', '1822630732@qq.com', '13504492052', 0, '2020-03-31 17:10:08');
INSERT INTO `teacher` VALUES (3890240, '3890240', '159357', '湛文', 1, '福建工程学院', '1411341634@qq.com', '15805962625', 0, '2020-03-31 17:10:09');
INSERT INTO `teacher` VALUES (3890251, '3890251', '159357', '金先', 1, '福建工程学院', '1954401657@qq.com', '13908853584', 1, '2020-03-31 17:10:09');
INSERT INTO `teacher` VALUES (3890261, '3890261', '159357', '魏达安', 1, '福建工程学院', '1291977381@qq.com', '15906847962', 1, '2020-03-31 17:10:09');
INSERT INTO `teacher` VALUES (3890270, '3890270', '159357', '杨敬震', 1, '福建工程学院', '1256798176@qq.com', '15600310242', 0, '2020-03-31 17:10:09');
INSERT INTO `teacher` VALUES (3890281, '3890281', '159357', '殷义兴', 1, '福建工程学院', '1130372848@qq.com', '15006590956', 1, '2020-03-31 17:10:09');
INSERT INTO `teacher` VALUES (3890290, '3890290', '159357', '马文', 1, '福建工程学院', '1814243309@qq.com', '15700204445', 0, '2020-03-31 17:10:09');

-- ----------------------------
-- Table structure for teacher_course
-- ----------------------------
DROP TABLE IF EXISTS `teacher_course`;
CREATE TABLE `teacher_course`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `profession` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `grade` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `term` tinyint(4) NOT NULL,
  `course_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of teacher_course
-- ----------------------------
INSERT INTO `teacher_course` VALUES (1, '3890290', '3890290', '数字电路基础', '电子信息工程', '1601', 1, '2016011001');
INSERT INTO `teacher_course` VALUES (2, '3890290', '3890290', '物联网工程导论', '物联网', '1601', 1, '2016021001');
INSERT INTO `teacher_course` VALUES (3, '3890290', '3890290', '计算机网络技术', '计算机', '1601', 1, '2016031001');
INSERT INTO `teacher_course` VALUES (4, '3890290', '3890290', '高频电子线路', '通信工程', '1601', 1, '2016041001');
INSERT INTO `teacher_course` VALUES (7, '3890281', '3890281', '大学物理', '电子信息工程', '1601', 1, '2016011002');
INSERT INTO `teacher_course` VALUES (8, '3890281', '3890281', '物联网安全', '物联网', '1601', 1, '2016021002');
INSERT INTO `teacher_course` VALUES (9, '3890281', '3890281', '网络与通信', '计算机', '1601', 1, '2016031002');
INSERT INTO `teacher_course` VALUES (10, '3890281', '3890281', '光纤通讯', '通信工程', '1601', 1, '2016041002');
INSERT INTO `teacher_course` VALUES (11, '3890270', '3890270', '线性代数', '电子信息工程', '1601', 1, '2016011003');
INSERT INTO `teacher_course` VALUES (12, '3890270', '3890270', '现代通信技术', '物联网', '1601', 1, '2016021003');
INSERT INTO `teacher_course` VALUES (13, '3890270', '3890270', '计算机安全', '计算机', '1601', 1, '2016031003');
INSERT INTO `teacher_course` VALUES (14, '3890270', '3890270', '移动通讯', '通信工程', '1601', 1, '2016041003');
INSERT INTO `teacher_course` VALUES (15, '3890261', '3890261', '复变函数', '电子信息工程', '1601', 1, '2016011004');
INSERT INTO `teacher_course` VALUES (16, '3890261', '3890261', '现代传感器技术', '物联网', '1601', 1, '2016021005');
INSERT INTO `teacher_course` VALUES (17, '3890261', '3890261', '算法与数据结构', '计算机', '1601', 1, '2016031004');
INSERT INTO `teacher_course` VALUES (18, '3890261', '3890261', '电路分析', '通信工程', '1601', 1, '2016041004');
INSERT INTO `teacher_course` VALUES (19, '3890251', '3890251', '模拟电子线路', '电子信息工程', '1601', 1, '2016011005');
INSERT INTO `teacher_course` VALUES (20, '3890251', '3890251', '信号与系统概论', '物联网', '1601', 1, '2016021006');
INSERT INTO `teacher_course` VALUES (21, '3890251', '3890251', '多媒体信息处理', '计算机', '1601', 1, '2016031005');
INSERT INTO `teacher_course` VALUES (22, '3890251', '3890251', '程控交换技术', '通信工程', '1601', 1, '2016041005');
INSERT INTO `teacher_course` VALUES (23, '3890240', '3890240', '信号与系统', '电子信息工程', '1601', 1, '2016011006');
INSERT INTO `teacher_course` VALUES (24, '3890240', '3890240', '无线传感器网络', '物联网', '1601', 1, '2016021004');
INSERT INTO `teacher_course` VALUES (25, '3890240', '3890240', '计算机组成原理', '计算机', '1601', 1, '2016031006');
INSERT INTO `teacher_course` VALUES (26, '3890240', '3890240', '光纤通讯', '通信工程', '1601', 1, '2016041006');

-- ----------------------------
-- Table structure for timetable
-- ----------------------------
DROP TABLE IF EXISTS `timetable`;
CREATE TABLE `timetable`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `week_id` int(11) NOT NULL,
  `profession` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `grade` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `year` int(11) NOT NULL,
  `term` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of timetable
-- ----------------------------
INSERT INTO `timetable` VALUES (1, 1, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (2, 2, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (3, 3, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (4, 4, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (5, 5, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (6, 6, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (7, 7, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (8, 8, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (9, 9, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (10, 10, '电子信息工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (11, 11, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (12, 12, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (13, 13, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (14, 14, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (15, 15, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (16, 16, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (17, 17, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (18, 18, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (19, 19, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (20, 20, '物联网', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (21, 21, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (22, 22, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (23, 23, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (24, 24, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (25, 25, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (26, 26, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (27, 27, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (28, 28, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (29, 29, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (30, 30, '计算机', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (31, 31, '通信工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (32, 32, '通信工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (33, 33, '通信工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (34, 34, '通信工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (35, 35, '通信工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (36, 36, '通信工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (37, 37, '通信工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (38, 38, '通信工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (39, 39, '通信工程', '1601', 2016, 1);
INSERT INTO `timetable` VALUES (40, 40, '通信工程', '1601', 2016, 1);

-- ----------------------------
-- Table structure for upload
-- ----------------------------
DROP TABLE IF EXISTS `upload`;
CREATE TABLE `upload`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of upload
-- ----------------------------
INSERT INTO `upload` VALUES (1, '1', 0, 'sms/static/img/1e3d1f1a-33b5-4677-a70d-7ab754f3c436.jpg');
INSERT INTO `upload` VALUES (2, '3168901102', 2, 'sms/static/img/98d6ec65-bb2c-4b41-8f7f-ac723085b59b.jpg');
INSERT INTO `upload` VALUES (3, '3890290', 1, 'sms/static/img/859d30a4-5089-47bd-822e-0c435b009a82.png');
INSERT INTO `upload` VALUES (4, '3168901101', 2, 'sms/static/img/4f60c9ba-d99c-4dac-9767-4d833a430d90.jpg');

-- ----------------------------
-- Table structure for week
-- ----------------------------
DROP TABLE IF EXISTS `week`;
CREATE TABLE `week`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `monday` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `tuesday` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `wednesday` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `thursday` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `friday` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `saturday` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `sunday` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of week
-- ----------------------------
INSERT INTO `week` VALUES (1, '大学物理', '一', '模拟电子线路', '一', '一', '一', '一');
INSERT INTO `week` VALUES (2, '大学物理', '一', '模拟电子线路', '一', '一', '一', '一');
INSERT INTO `week` VALUES (3, '一', '线性代数', '一', '复变函数', '信号与系统', '一', '一');
INSERT INTO `week` VALUES (4, '一', '线性代数', '一', '复变函数', '信号与系统', '一', '一');
INSERT INTO `week` VALUES (5, '信号与系统', '数字电路基础', '大学物理', '大学物理', '一', '一', '一');
INSERT INTO `week` VALUES (6, '信号与系统', '数字电路基础', '大学物理', '大学物理', '一', '一', '一');
INSERT INTO `week` VALUES (7, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (8, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (9, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (10, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (11, '一', '信号与系统概论', '一', '物联网安全', '现代通信技术', '一', '一');
INSERT INTO `week` VALUES (12, '一', '信号与系统概论', '一', '物联网安全', '现代通信技术', '一', '一');
INSERT INTO `week` VALUES (13, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (14, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (15, '物联网工程导论', '无线传感器网络', '现代传感器技术', '一', '一', '一', '一');
INSERT INTO `week` VALUES (16, '物联网工程导论', '无线传感器网络', '现代传感器技术', '一', '一', '一', '一');
INSERT INTO `week` VALUES (17, '现代通信技术', '一', '一', '物联网工程导论', '一', '一', '一');
INSERT INTO `week` VALUES (18, '现代通信技术', '一', '一', '物联网工程导论', '一', '一', '一');
INSERT INTO `week` VALUES (19, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (20, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (21, '一', '算法与数据结构', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (22, '一', '算法与数据结构', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (23, '网络与通信', '一', '计算机网络技术', '网络与通信', '一', '一', '一');
INSERT INTO `week` VALUES (24, '网络与通信', '一', '计算机网络技术', '网络与通信', '一', '一', '一');
INSERT INTO `week` VALUES (25, '一', '一', '计算机组成原理', '多媒体信息处理', '一', '一', '一');
INSERT INTO `week` VALUES (26, '一', '一', '计算机组成原理', '多媒体信息处理', '一', '一', '一');
INSERT INTO `week` VALUES (27, '一', '多媒体信息处理', '一', '一', '计算机组成原理', '一', '一');
INSERT INTO `week` VALUES (28, '一', '多媒体信息处理', '一', '一', '计算机组成原理', '一', '一');
INSERT INTO `week` VALUES (29, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (30, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (31, '一', '一', '一', '高频电子线路', '一', '一', '一');
INSERT INTO `week` VALUES (32, '一', '一', '一', '高频电子线路', '一', '一', '一');
INSERT INTO `week` VALUES (33, '一', '一', '一', '光纤通讯', '一', '一', '一');
INSERT INTO `week` VALUES (34, '一', '一', '一', '光纤通讯', '一', '一', '一');
INSERT INTO `week` VALUES (35, '通信原理', '光纤通讯', '一', '电路分析', '移动通讯', '一', '一');
INSERT INTO `week` VALUES (36, '通信原理', '光纤通讯', '一', '电路分析', '移动通讯', '一', '一');
INSERT INTO `week` VALUES (37, '高频电子线路', '一', '电路分析', '一', '一', '一', '一');
INSERT INTO `week` VALUES (38, '高频电子线路', '一', '电路分析', '一', '一', '一', '一');
INSERT INTO `week` VALUES (39, '一', '一', '一', '一', '一', '一', '一');
INSERT INTO `week` VALUES (40, '一', '一', '一', '一', '一', '一', '一');

SET FOREIGN_KEY_CHECKS = 1;