/* Navicat MySQL Data Transfer Source Server : mysql01 Source Server Version : 50720 Source Host : localhost:3306 Source Database : jiaowusystem Target Server Type : MYSQL Target Server Version : 50720 File Encoding : 65001 Date: 2018-03-24 17:27:45 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `cetgrade` -- ---------------------------- DROP TABLE IF EXISTS `cetgrade`; CREATE TABLE `cetgrade` ( `yearTerm` varchar(20) NOT NULL, `studentId` bigint(20) NOT NULL, `levelEaxmCourse` varchar(10) NOT NULL, `eaxmTime` varchar(30) NOT NULL, `grade` varchar(20) NOT NULL, `examId` varchar(20) NOT NULL, `listenGrade` varchar(20) NOT NULL, `readingGrade` varchar(20) NOT NULL, `writingGrade` varchar(20) NOT NULL, `spokenGrade` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of cetgrade -- ---------------------------- INSERT INTO `cetgrade` VALUES ('2016春季', '4225111212', '英语四级', '42539', '515', '42048015140', '197', '158', '160', '0'); INSERT INTO `cetgrade` VALUES ('2017春季', '4225111212', '英语六级', '42539', '515', '42048015140', '197', '158', '160', '0'); INSERT INTO `cetgrade` VALUES ('2016秋季', '4225111212', '英语六级', '42539', '544', '42048451509', '197', '183', '164', '0'); INSERT INTO `cetgrade` VALUES ('2017秋季', '4225111212', '英语六级', '42539', '488', '42004015356', '182', '162', '144', '0'); INSERT INTO `cetgrade` VALUES ('2017春季', '2125101235', '英语六级', '42539', '571', '42478056150', '207', '191', '173', '0'); INSERT INTO `cetgrade` VALUES ('2016秋季', '2125101235', '英语六级', '42539', '521', '42478056150', '172', '170', '179', '0'); INSERT INTO `cetgrade` VALUES ('2017秋季', '2125101235', '英语六级', '42539', '508', '42478056150', '167', '183', '158', '0'); -- ---------------------------- -- Table structure for `courseschedule` -- ---------------------------- DROP TABLE IF EXISTS `courseschedule`; CREATE TABLE `courseschedule` ( `yearTerm` varchar(20) NOT NULL, `studentId` varchar(20) NOT NULL, `week` varchar(20) NOT NULL, `weekday` varchar(20) NOT NULL, `joint` varchar(10) NOT NULL, `course` varchar(30) NOT NULL, `teacher` varchar(20) NOT NULL, `classplace` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of courseschedule -- ---------------------------- INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第1周', '星期一', '1-2', 'C语言程序设计', '小英', '教1-213'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第1周', '星期二', '3-4', 'C语言程序设计', '小英', '教1-213'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第1周', '星期三', '6-7', 'java程序设计', '小英', '教1-214'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第1周', '星期四', '8-9', '高数', '小王', '教1-215'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第1周', '星期五', '3-4', '大学英语', '小王', '教2-316'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第2周', '星期一', '8-9', '马克思主义理论', '小王', '教1-412'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第2周', '星期二', '1-2', '近代史', '小王', '教3-310'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第2周', '星期三', '10-12', '大学生职业规划', '小王', '教4-219'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第2周', '星期四', '3-4', '高数', '小王', '教1-220'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第2周', '星期五', '10-12', '大学物理', '小王', '教1-109'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第3周', '星期一', '6-7', '大学英语', '小王', '教3-222'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第3周', '星期二', '8-9', '高数', '小王', '教1-223'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第3周', '星期三', '3-4', 'C语言程序设计', '小王', '教1-224'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第3周', '星期四', '8-9', '线性代数', '小王', '教2-225'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第3周', '星期五', '1-2', '电路', '小王', '教2-420'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第4周', '星期一', '8-9', '大学物理', '小王', '教1-227'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第4周', '星期二', '1-2', 'java程序设计', '小王', '教1-110'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第4周', '星期三', '1-2', '近代史', '小王', '教1-229'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第4周', '星期四', '6-7', '高数', '小王', '教3-230'); INSERT INTO `courseschedule` VALUES ('2017秋季', '4225111212', '第4周', '星期五', '6-7', '大学英语', '小王', '教1-102'); -- ---------------------------- -- Table structure for `examarrange` -- ---------------------------- DROP TABLE IF EXISTS `examarrange`; CREATE TABLE `examarrange` ( `yearTerm` varchar(20) NOT NULL, `studentId` varchar(20) NOT NULL, `studentName` varchar(10) NOT NULL, `examCourse` varchar(10) NOT NULL, `examWay` varchar(30) NOT NULL, `examDate` varchar(30) NOT NULL, `examTime` varchar(20) NOT NULL, `examWeek` varchar(20) NOT NULL, `examCampus` varchar(20) NOT NULL, `examplace` varchar(20) NOT NULL, `examSeatNum` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of examarrange -- ---------------------------- INSERT INTO `examarrange` VALUES ('2017秋季', '4225111212', '小明', 'C语言程序设计', '闭卷', '2017/11/14', '08:30--10:05', '18', '大学城校区', '教3-110', '25'); INSERT INTO `examarrange` VALUES ('2017秋季', '4225111212', '小明', '大学英语', '闭卷', '2017/11/15', '14:00--16:00', '18', '大学城校区', '教3-111', '25'); INSERT INTO `examarrange` VALUES ('2017秋季', '4225111212', '小明', '高数', '闭卷', '2017/11/16', '08:30--10:05', '18', '大学城校区', '教3-112', '25'); INSERT INTO `examarrange` VALUES ('2017秋季', '4225111212', '小明', '计算机组成原理', '闭卷', '2017/11/17', '14:40--16:15', '18', '大学城校区', '教3-113', '25'); INSERT INTO `examarrange` VALUES ('2017秋季', '4225111212', '小明', '自动化控制原理', '闭卷', '2017/11/18', '10:25--12:00', '18', '大学城校区', '教3-114', '25'); INSERT INTO `examarrange` VALUES ('2016秋季', '4225111212', '小明', '大学物理', '闭卷', '2017/11/19', '08:30--10:05', '18', '大学城校区', '教3-115', '25'); INSERT INTO `examarrange` VALUES ('2016秋季', '4225111212', '小明', '线性代数', '闭卷', '2017/11/20', '14:00--16:00', '18', '大学城校区', '教3-116', '25'); INSERT INTO `examarrange` VALUES ('2016秋季', '4225111212', '小明', '近代史', '闭卷', '2017/11/21', '08:30--10:05', '18', '大学城校区', '教3-117', '25'); INSERT INTO `examarrange` VALUES ('2016秋季', '4225111212', '小明', '面向对象程序设计', '闭卷', '2017/11/22', '14:40--16:15', '18', '大学城校区', '教3-118', '25'); INSERT INTO `examarrange` VALUES ('2016秋季', '4225111212', '小明', '', '', '', '', '', '', '', ''); -- ---------------------------- -- Table structure for `exemptionapply` -- ---------------------------- DROP TABLE IF EXISTS `exemptionapply`; CREATE TABLE `exemptionapply` ( `yearTerm` varchar(20) NOT NULL, `studentId` varchar(20) NOT NULL, `courseName` varchar(30) NOT NULL, `applyReason` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of exemptionapply -- ---------------------------- INSERT INTO `exemptionapply` VALUES ('2017秋季', '4225111212', '高数', '考试对我来说太简单了'); -- ---------------------------- -- Table structure for `jwteacherinformation` -- ---------------------------- DROP TABLE IF EXISTS `jwteacherinformation`; CREATE TABLE `jwteacherinformation` ( `teacherId` varchar(20) NOT NULL, `teacherName` varchar(10) NOT NULL, `gender` varchar(5) NOT NULL, `politicstatus` varchar(10) NOT NULL, `nation` varchar(20) NOT NULL, `nativeplace` varchar(20) NOT NULL, `academy` varchar(20) NOT NULL, `qq` varchar(20) NOT NULL, `phone` varchar(20) NOT NULL, `email` varchar(20) NOT NULL, `address` varchar(20) NOT NULL, PRIMARY KEY (`teacherId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of jwteacherinformation -- ---------------------------- INSERT INTO `jwteacherinformation` VALUES ('zdhjw01', '小美', '女', '党员', '汉族', '广东广州', '电子信息学院', '1293546688', '15564346546', '124346@163.com', '广东广州'); -- ---------------------------- -- Table structure for `levelexam` -- ---------------------------- DROP TABLE IF EXISTS `levelexam`; CREATE TABLE `levelexam` ( `yearTerm` varchar(20) NOT NULL, `courseId` varchar(10) NOT NULL, `courseName` varchar(30) NOT NULL, `applyTime` varchar(20) NOT NULL, `examTime` varchar(20) NOT NULL, `examCost` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of levelexam -- ---------------------------- INSERT INTO `levelexam` VALUES ('2017秋季', 'CET6-123', '英语六级', '2017-03-09 00:01:14', '2017-06-16', '36元'); INSERT INTO `levelexam` VALUES ('2017春季', 'CET6-124', '英语六级', '2017-03-09 00:01:15', '2017-06-17', '36元'); INSERT INTO `levelexam` VALUES ('2016秋季', 'CET6-125', '英语六级', '2016-03-09 00:01:16', '2017-06-18', '36元'); INSERT INTO `levelexam` VALUES ('2016春季', 'CET6-126', '英语六级', '2016-03-09 00:01:17', '2017-06-19', '36元'); INSERT INTO `levelexam` VALUES ('2016秋季', 'CET4-257', '英语四级', '2016-03-09 00:01:18', '2017-06-20', '36元'); INSERT INTO `levelexam` VALUES ('2016春季', 'CET4-258', '英语四级', '2016-03-09 00:01:19', '2017-06-21', '36元'); INSERT INTO `levelexam` VALUES ('2017秋季', 'CET4-259', '英语四级', '2017-03-09 00:01:20', '2017-06-22', '36元'); INSERT INTO `levelexam` VALUES ('2017春季', 'CET4-260', '英语四级', '2017-03-09 00:01:21', '2017-06-23', '36元'); INSERT INTO `levelexam` VALUES ('2017春季', 'MPL1799', '计算机水平考试二级(C语言)', '2017-03-09 00:01:22', '2017-06-24', '44元'); INSERT INTO `levelexam` VALUES ('2017春季', 'MPL1800', '计算机水平考试二级(office应用)', '2017-03-09 00:01:23', '2017-06-25', '45元'); INSERT INTO `levelexam` VALUES ('2017春季', 'MPL1799', '计算机水平考试二级java程序设计)', '2017-03-09 00:01:24', '2017-06-26', '46元'); INSERT INTO `levelexam` VALUES ('2017秋季', 'MPL1799', '计算机水平考试二级(C语言)', '2017-03-09 00:01:22', '2017-06-24', '44元'); INSERT INTO `levelexam` VALUES ('2017秋季', 'MPL1800', '计算机水平考试二级(office应用)', '2017-03-09 00:01:23', '2017-06-25', '45元'); INSERT INTO `levelexam` VALUES ('2017秋季', 'MPL1799', '计算机水平考试二级java程序设计)', '2017-03-09 00:01:24', '2017-06-26', '46元'); -- ---------------------------- -- Table structure for `levelexamlist` -- ---------------------------- DROP TABLE IF EXISTS `levelexamlist`; CREATE TABLE `levelexamlist` ( `studentId` varchar(20) DEFAULT NULL, `courseId` varchar(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of levelexamlist -- ---------------------------- INSERT INTO `levelexamlist` VALUES ('4225111212', 'CET4-259'); -- ---------------------------- -- Table structure for `optionalcourse` -- ---------------------------- DROP TABLE IF EXISTS `optionalcourse`; CREATE TABLE `optionalcourse` ( `yearTerm` varchar(20) NOT NULL, `courseId` varchar(10) NOT NULL, `courseName` varchar(30) NOT NULL, `credit` varchar(20) NOT NULL, `courseType` varchar(20) NOT NULL, `teacher` varchar(20) NOT NULL, `classWay` varchar(20) NOT NULL, `classTime` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of optionalcourse -- ---------------------------- INSERT INTO `optionalcourse` VALUES ('2017秋季', 'MPL1791', '世界文学名著欣赏', '1.5', '人文社会科学类', '小英', '慕课', '第2-9周 周二 10-12节'); INSERT INTO `optionalcourse` VALUES ('2017秋季', 'MPL1792', '市场营销学', '1.5', '人文社会科学类', '小风', '正常上课', '第10-18周 周二 10-12节'); INSERT INTO `optionalcourse` VALUES ('2017秋季', 'MPL1793', '影视鉴赏', '2.0', '人文社会科学类', '大王', '正常上课', '第2-9周 周一 10-12节'); INSERT INTO `optionalcourse` VALUES ('2017秋季', 'MPL1794', '生物细胞科学', '1.5', '工程技术基础类', '大佬', '正常上课', '第2-10周 周二 10-12节'); INSERT INTO `optionalcourse` VALUES ('2016秋季', 'MPL1795', '探秘自动化', '1.5', '人文社会科学类', '小华', '正常上课', '第2-9周 周四 10-12节'); INSERT INTO `optionalcourse` VALUES ('2016秋季', 'MPL1796', '神奇的润滑', '2.0', '人文社会科学类', '小哥', '正常上课', '第10-18周 周二 10-12节'); INSERT INTO `optionalcourse` VALUES ('2016秋季', 'MPL1797', '中华诗词', '1.5', '人文社会科学类', '老大', '正常上课', '第2-9周 周三 10-12节'); INSERT INTO `optionalcourse` VALUES ('2017春季', 'MPL1798', 'C++图形用户界面', '1.5', '工程技术基础类', '小黑', '正常上课', '第2-9周 周一10-12节'); INSERT INTO `optionalcourse` VALUES ('2017春季', 'MPL1799', '现代公司企业法', '1.5', '人文社会科学类', '大哥', '正常上课', '第2-9周 周五 10-12节'); INSERT INTO `optionalcourse` VALUES ('2017春季', 'MPL1800', '法论', '1.5', '人文社会科学类', '龙大', '慕课', '第10-18周 周二 10-12节'); -- ---------------------------- -- Table structure for `postponeexamapply` -- ---------------------------- DROP TABLE IF EXISTS `postponeexamapply`; CREATE TABLE `postponeexamapply` ( `yearTerm` varchar(20) NOT NULL, `studentId` varchar(20) NOT NULL, `courseName` varchar(30) NOT NULL, `applyReason` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of postponeexamapply -- ---------------------------- INSERT INTO `postponeexamapply` VALUES ('2017秋季', '4225111212', '电路', '我不想考试'); INSERT INTO `postponeexamapply` VALUES ('2017春季', '4225111212', '高数', '老子特么不想学习'); INSERT INTO `postponeexamapply` VALUES ('2017秋季', '4225111212', '大学英语', '太难了，我还需要再学一下'); -- ---------------------------- -- Table structure for `studentbasicinformation` -- ---------------------------- DROP TABLE IF EXISTS `studentbasicinformation`; CREATE TABLE `studentbasicinformation` ( `studentId` bigint(20) NOT NULL AUTO_INCREMENT, `studentName` varchar(10) NOT NULL, `gender` varchar(5) NOT NULL, `grade` varchar(10) NOT NULL, `className` varchar(20) NOT NULL, `academy` varchar(20) NOT NULL, `profession` varchar(20) NOT NULL, `campus` varchar(20) NOT NULL, `phone` varchar(20) NOT NULL, `homeAddress` varchar(30) NOT NULL, PRIMARY KEY (`studentId`) ) ENGINE=InnoDB AUTO_INCREMENT=4225111213 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of studentbasicinformation -- ---------------------------- INSERT INTO `studentbasicinformation` VALUES ('2125101235', '小布', '男', '2015级', '电子15(1)', '电子信息学院', '电子信息工程', '大学城校区', '18236545691', '广东省广州市'); INSERT INTO `studentbasicinformation` VALUES ('4225111212', '小明', '男', '2015级', '电子15(1)', '电子信息学院', '电子信息工程', '大学城校区', '19712345423', '广东省广州市'); -- ---------------------------- -- Table structure for `studentgrade` -- ---------------------------- DROP TABLE IF EXISTS `studentgrade`; CREATE TABLE `studentgrade` ( `yearTerm` varchar(20) NOT NULL, `studentId` bigint(20) NOT NULL, `studentName` varchar(10) NOT NULL, `courseId` varchar(10) NOT NULL, `courseName` varchar(30) NOT NULL, `score` varchar(20) NOT NULL, `gradePoint` varchar(20) NOT NULL, `credit` varchar(20) NOT NULL, `courseClass` varchar(20) NOT NULL, `studyWay` varchar(20) NOT NULL, `examWay` varchar(20) NOT NULL, `gradeWay` varchar(20) NOT NULL, `effectivity` varchar(20) NOT NULL, `remarks` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of studentgrade -- ---------------------------- INSERT INTO `studentgrade` VALUES ('2017秋季', '4225111212', '小明', 'HFP1256', '电磁场与微波技术', '88', '3.8', '2', '专业基础课', '选修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017秋季', '4225111212', '小明', 'HFP1786', '常用EDA系统设计', '95', '4.5', '1.5', '公共选修课', '选修', '正常考试', '百分制', '1', ',工程技术基础类'); INSERT INTO `studentgrade` VALUES ('2017秋季', '4225111212', '小明', 'HFP1787', '通信原理', '87', '3.7', '3', '专业基础课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017秋季', '4225111212', '小明', 'HFP1788', '通信原理实验', '85', '3.5', '0.5', '实验实习实训', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017秋季', '4225111212', '小明', 'HFP1789', '微机原理与单片机技术', '85', '3.5', '3', '专业基础课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017秋季', '4225111212', '小明', 'HFP1790', '微机原理与单片机技术实验', '86', '3.6', '1', '实验实习实训', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017春季', '4225111212', '小明', 'HFP1791', '通信系统', '82', '3.2', '2', '专业基础课', '选修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017春季', '4225111212', '小明', 'HFP1792', '专业英语', '94', '4.4', '2', '专业基础课', '选修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017春季', '4225111212', '小明', 'HFP1793', '数字信号处理', '83', '3.3', '2', '专业课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017春季', '4225111212', '小明', 'HFP1794', 'VHDL设计实验', '95', '4.5', '1', '实验实习实训', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017春季', '4225111212', '小明', 'HFP1795', 'EDA电子技术实训', '95', '4.5', '2', '实验实习实训', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017春季', '4225111212', '小明', 'HFP1796', '电子技术综合设计与实践', '85', '3.5', '1', '设计(论文)', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2017春季', '4225111212', '小明', 'HFP1797', 'VHDL设计基础', '95', '4.5', '1.5', '专业方向课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016秋季', '4225111212', '小明', 'HFP1798', '线性代数', '90', '4', '2', '专业基础课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016秋季', '4225111212', '小明', 'HFP1799', '世界文学名著欣赏', '85', '3.5', '1.5', '公共选修课', '选修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016秋季', '4225111212', '小明', 'HFP1800', '信号与系统实验', '95', '4.5', '0.5', '实验实习实训', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016秋季', '4225111212', '小明', 'HFP1801', '应用文写作', '95', '4.5', '1.5', '公共选修课', '选修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016秋季', '4225111212', '小明', 'HFP1802', '信号与系统', '95', '4.5', '3', '专业基础课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016秋季', '4225111212', '小明', 'HFP1803', '市场营销学', '88', '3.8', '1.5', '公共选修课', '选修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016秋季', '4225111212', '小明', 'HFP1804', '复变函数与积分变换', '96', '4.6', '2', '专业基础课', '选修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016秋季', '4225111212', '小明', 'HFP1805', '马克思主义基本原理', '91', '4.1', '3', '公共基础课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016春季', '4225111212', '小明', 'HFP1806', '大学物理实验(2)', '85', '3.5', '1.5', '实验实习实训', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016春季', '4225111212', '小明', 'HFP1807', '大学英语(3)', '93', '4.3', '4', '公共基础课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016春季', '4225111212', '小明', 'HFP1808', '模拟电子技术', '92', '4.2', '3.5', '专业基础课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016春季', '4225111212', '小明', 'HFP1809', '模拟电子技术实验', '85', '3.5', '1', '实验实习实训', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016春季', '4225111212', '小明', 'HFP1810', '体育(3)', '90', '4', '2', '公共基础课', '必修', '正常考试', '百分制', '1', ''); INSERT INTO `studentgrade` VALUES ('2016春季', '4225111212', '小明', 'HFP1811', '大学物理(2)', '77', '2.7', '4', '公共基础课', '必修', '正常考试', '百分制', '1', ''); -- ---------------------------- -- Table structure for `studentoptcourse` -- ---------------------------- DROP TABLE IF EXISTS `studentoptcourse`; CREATE TABLE `studentoptcourse` ( `studentId` varchar(20) DEFAULT NULL, `courseId` varchar(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of studentoptcourse -- ---------------------------- INSERT INTO `studentoptcourse` VALUES ('4225111212', 'MPL1791'); INSERT INTO `studentoptcourse` VALUES ('4225111212', 'MPL1792'); -- ---------------------------- -- Table structure for `teacherinformation` -- ---------------------------- DROP TABLE IF EXISTS `teacherinformation`; CREATE TABLE `teacherinformation` ( `teacherId` varchar(20) NOT NULL, `teacherName` varchar(10) NOT NULL, `gender` varchar(5) NOT NULL, `politicstatus` varchar(10) NOT NULL, `nation` varchar(20) NOT NULL, `nativeplace` varchar(20) NOT NULL, `academy` varchar(20) NOT NULL, `profession` varchar(20) NOT NULL, `phone` varchar(20) NOT NULL, `email` varchar(20) NOT NULL, `address` varchar(20) NOT NULL, PRIMARY KEY (`teacherId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of teacherinformation -- ---------------------------- INSERT INTO `teacherinformation` VALUES ('123456', '小英', '女', '党员', '汉族', '广东广州', '计算机学院', '计算机科学与技术', '15626438843', '123th@126.com', '广州市越秀区区庄地铁口'); -- ---------------------------- -- Table structure for `users` -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `username` varchar(20) NOT NULL, `password` varchar(20) NOT NULL, `name` varchar(20) NOT NULL, `identity` varchar(20) NOT NULL, `findMMproof` varchar(20) NOT NULL, `login_last_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `password_last_changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES ('123456', '123456', '小英', '教师', '123456789', '2018-03-20 14:53:03', '2018-03-20 14:53:03'); INSERT INTO `users` VALUES ('2125101235', '123456', '小布', '学生', '123456789 ', '2018-03-20 14:52:03', '2018-03-20 14:52:03'); INSERT INTO `users` VALUES ('4225111212', '123456', '小明', '学生', '42048015140', '2018-03-20 14:42:10', '2018-03-20 14:42:10'); INSERT INTO `users` VALUES ('admin01', '123456', '大佬', '管理员', '123456789', '2018-03-20 14:53:46', '2018-03-20 14:53:46'); INSERT INTO `users` VALUES ('zdhjw01', '123456', '小美', '教务员', '123456789', '2018-03-20 19:01:24', '2018-03-20 19:01:24');