功能介绍
用户端功能有:首页、课程信息、我的课程、课程作业、我的作业、课程考试、我的考试、在线留言、班级信息、我的班级、个人中心等
管理端功能有:教师管理、学生管理、课程信息查看、我的课程管理、作业管理、考试管理、作业批改、考试批改、班级信息管理、我的班级管理、系统管理
教师后台功能有:课程信息查看、我的课程管理、作业管理、考试管理、作业批改、考试批改、班级信息管理、我的班级管理
更多功能请看运行截图!
使用技术
开发语言:python
使用框架:Django2.0
前端技术:JavaScript、VUE.js(2.X)、css3
数据库:MySQL 5.7
数据库管理工具:Navicat或sqlyog
开发工具:pycharm
python版本:python3.7及以上
数据库脚本
DROP DATABASE IF EXISTS django22858;
CREATE DATABASE django22858 default character set utf8mb4 collate utf8mb4_general_ci;
USE django22858;
DROP TABLE IF EXISTS `xuesheng`;
CREATE TABLE `xuesheng` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) NOT NULL UNIQUE COMMENT '学号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xueshengxingming` varchar(200) NOT NULL COMMENT '学生姓名',
`xingbie` varchar(200) COMMENT '性别',
`xueyuan` varchar(200) COMMENT '学院',
`zhuanye` varchar(200) COMMENT '专业',
`lianxidianhua` varchar(200) COMMENT '联系电话',
`youxiang` varchar(200) COMMENT '邮箱',
`zhaopian` varchar(200) COMMENT '照片',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='学生';
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(11,'学生1','123456','学生姓名1','男','学院1','专业1','13823888881','773890001@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian1.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(12,'学生2','123456','学生姓名2','男','学院2','专业2','13823888882','773890002@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian2.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(13,'学生3','123456','学生姓名3','男','学院3','专业3','13823888883','773890003@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian3.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(14,'学生4','123456','学生姓名4','男','学院4','专业4','13823888884','773890004@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian4.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(15,'学生5','123456','学生姓名5','男','学院5','专业5','13823888885','773890005@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian5.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(16,'学生6','123456','学生姓名6','男','学院6','专业6','13823888886','773890006@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian6.jpg');
DROP TABLE IF EXISTS `jiaoshi`;
CREATE TABLE `jiaoshi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) NOT NULL UNIQUE COMMENT '工号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`xingbie` varchar(200) COMMENT '性别',
`touxiang` varchar(200) COMMENT '头像',
`zhicheng` varchar(200) COMMENT '职称',
`dianhua` varchar(200) COMMENT '电话',
`youxiang` varchar(200) COMMENT '邮箱',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='教师';
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(21,'教师1','123456','教师姓名1','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang1.jpg','职称1','13823888881','773890001@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(22,'教师2','123456','教师姓名2','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang2.jpg','职称2','13823888882','773890002@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(23,'教师3','123456','教师姓名3','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang3.jpg','职称3','13823888883','773890003@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(24,'教师4','123456','教师姓名4','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang4.jpg','职称4','13823888884','773890004@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(25,'教师5','123456','教师姓名5','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang5.jpg','职称5','13823888885','773890005@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(26,'教师6','123456','教师姓名6','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang6.jpg','职称6','13823888886','773890006@qq.com');
DROP TABLE IF EXISTS `kechengxinxi`;
CREATE TABLE `kechengxinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`kechengbianhao` varchar(200) NOT NULL UNIQUE COMMENT '课程编号',
`kechengmingcheng` varchar(200) NOT NULL COMMENT '课程名称',
`kechengleixing` varchar(200) COMMENT '课程类型',
`tupian` varchar(200) COMMENT '图片',
`kechengziliao` varchar(200) COMMENT '课程资料',
`kechengneirong` longtext COMMENT '课程内容',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`thumbsupnum` int default '0' COMMENT '赞',
`crazilynum` int default '0' COMMENT '踩',
`clicktime` datetime COMMENT '最近点击时间',
`clicknum` int default '0' COMMENT '点击次数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程信息';
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(31,'课程编号1','课程名称1','课程类型1','http://localhost:8080/django22858/upload/kechengxinxi_tupian1.jpg','','课程内容1','工号1','教师姓名1',1,1,CURRENT_TIMESTAMP,1);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(32,'课程编号2','课程名称2','课程类型2','http://localhost:8080/django22858/upload/kechengxinxi_tupian2.jpg','','课程内容2','工号2','教师姓名2',2,2,CURRENT_TIMESTAMP,2);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(33,'课程编号3','课程名称3','课程类型3','http://localhost:8080/django22858/upload/kechengxinxi_tupian3.jpg','','课程内容3','工号3','教师姓名3',3,3,CURRENT_TIMESTAMP,3);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(34,'课程编号4','课程名称4','课程类型4','http://localhost:8080/django22858/upload/kechengxinxi_tupian4.jpg','','课程内容4','工号4','教师姓名4',4,4,CURRENT_TIMESTAMP,4);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(35,'课程编号5','课程名称5','课程类型5','http://localhost:8080/django22858/upload/kechengxinxi_tupian5.jpg','','课程内容5','工号5','教师姓名5',5,5,CURRENT_TIMESTAMP,5);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(36,'课程编号6','课程名称6','课程类型6','http://localhost:8080/django22858/upload/kechengxinxi_tupian6.jpg','','课程内容6','工号6','教师姓名6',6,6,CURRENT_TIMESTAMP,6);
DROP TABLE IF EXISTS `kechengfenlei`;
CREATE TABLE `kechengfenlei` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`kechengleixing` varchar(200) COMMENT '课程类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程分类';
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(41,'课程类型1');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(42,'课程类型2');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(43,'课程类型3');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(44,'课程类型4');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(45,'课程类型5');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(46,'课程类型6');
DROP TABLE IF EXISTS `wodekecheng`;
CREATE TABLE `wodekecheng` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`kechengbianhao` varchar(200) COMMENT '课程编号',
`kechengmingcheng` varchar(200) COMMENT '课程名称',
`kechengleixing` varchar(200) COMMENT '课程类型',
`tupian` varchar(200) COMMENT '图片',
`kechengziliao` varchar(200) COMMENT '课程资料',
`kechengneirong` longtext COMMENT '课程内容',
`kechengjieshao` longtext COMMENT '课程介绍',
`userid` bigint COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的课程';
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(51,'学号1','学生姓名1','工号1','教师姓名1','课程编号1','课程名称1','课程类型1','http://localhost:8080/django22858/upload/wodekecheng_tupian1.jpg','','课程内容1','课程介绍1',1);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(52,'学号2','学生姓名2','工号2','教师姓名2','课程编号2','课程名称2','课程类型2','http://localhost:8080/django22858/upload/wodekecheng_tupian2.jpg','','课程内容2','课程介绍2',2);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(53,'学号3','学生姓名3','工号3','教师姓名3','课程编号3','课程名称3','课程类型3','http://localhost:8080/django22858/upload/wodekecheng_tupian3.jpg','','课程内容3','课程介绍3',3);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(54,'学号4','学生姓名4','工号4','教师姓名4','课程编号4','课程名称4','课程类型4','http://localhost:8080/django22858/upload/wodekecheng_tupian4.jpg','','课程内容4','课程介绍4',4);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(55,'学号5','学生姓名5','工号5','教师姓名5','课程编号5','课程名称5','课程类型5','http://localhost:8080/django22858/upload/wodekecheng_tupian5.jpg','','课程内容5','课程介绍5',5);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(56,'学号6','学生姓名6','工号6','教师姓名6','课程编号6','课程名称6','课程类型6','http://localhost:8080/django22858/upload/wodekecheng_tupian6.jpg','','课程内容6','课程介绍6',6);
DROP TABLE IF EXISTS `kechengzuoye`;
CREATE TABLE `kechengzuoye` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`kechengbianhao` varchar(200) COMMENT '课程编号',
`kechengmingcheng` varchar(200) COMMENT '课程名称',
`kechengleixing` varchar(200) COMMENT '课程类型',
`zuoyemingcheng` varchar(200) COMMENT '作业名称',
`xiangguanfujian` varchar(200) COMMENT '相关附件',
`buzhishijian` datetime COMMENT '布置时间',
`jiezhishijian` datetime COMMENT '截止时间',
`zuoyeneirong` longtext COMMENT '作业内容',
`xiangguantupian` varchar(200) COMMENT '相关图片',
`userid` bigint COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程作业';
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(61,'工号1','教师姓名1','学号1','学生姓名1','课程编号1','课程名称1','课程类型1','作业名称1','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容1','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian1.jpg',1);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(62,'工号2','教师姓名2','学号2','学生姓名2','课程编号2','课程名称2','课程类型2','作业名称2','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容2','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian2.jpg',2);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(63,'工号3','教师姓名3','学号3','学生姓名3','课程编号3','课程名称3','课程类型3','作业名称3','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容3','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian3.jpg',3);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(64,'工号4','教师姓名4','学号4','学生姓名4','课程编号4','课程名称4','课程类型4','作业名称4','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容4','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian4.jpg',4);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(65,'工号5','教师姓名5','学号5','学生姓名5','课程编号5','课程名称5','课程类型5','作业名称5','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容5','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian5.jpg',5);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(66,'工号6','教师姓名6','学号6','学生姓名6','课程编号6','课程名称6','课程类型6','作业名称6','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容6','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian6.jpg',6);
DROP TABLE IF EXISTS `wodezuoye`;
CREATE TABLE `wodezuoye` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`kechengbianhao` varchar(200) COMMENT '课程编号',
`kechengmingcheng` varchar(200) COMMENT '课程名称',
`kechengleixing` varchar(200) COMMENT '课程类型',
`zuoyemingcheng` varchar(200) COMMENT '作业名称',
`xiangguanfujian` varchar(200) COMMENT '相关附件',
`tijiaoshijian` datetime COMMENT '提交时间',
`pigaineirong` longtext COMMENT '批改内容',
`zuoyechengji` varchar(200) COMMENT '作业成绩',
`xiangguantupian` varchar(200) COMMENT '相关图片',
`beizhu` varchar(200) COMMENT '备注',
`userid` bigint COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的作业';
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(71,'工号1','教师姓名1','学号1','学生姓名1','课程编号1','课程名称1','课程类型1','作业名称1','',CURRENT_TIMESTAMP,'批改内容1','作业成绩1','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian1.jpg','备注1',1);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(72,'工号2','教师姓名2','学号2','学生姓名2','课程编号2','课程名称2','课程类型2','作业名称2','',CURRENT_TIMESTAMP,'批改内容2','作业成绩2','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian2.jpg','备注2',2);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(73,'工号3','教师姓名3','学号3','学生姓名3','课程编号3','课程名称3','课程类型3','作业名称3','',CURRENT_TIMESTAMP,'批改内容3','作业成绩3','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian3.jpg','备注3',3);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(74,'工号4','教师姓名4','学号4','学生姓名4','课程编号4','课程名称4','课程类型4','作业名称4','',CURRENT_TIMESTAMP,'批改内容4','作业成绩4','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian4.jpg','备注4',4);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(75,'工号5','教师姓名5','学号5','学生姓名5','课程编号5','课程名称5','课程类型5','作业名称5','',CURRENT_TIMESTAMP,'批改内容5','作业成绩5','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian5.jpg','备注5',5);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(76,'工号6','教师姓名6','学号6','学生姓名6','课程编号6','课程名称6','课程类型6','作业名称6','',CURRENT_TIMESTAMP,'批改内容6','作业成绩6','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian6.jpg','备注6',6);
DROP TABLE IF EXISTS `kechengkaoshi`;
CREATE TABLE `kechengkaoshi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`kechengbianhao` varchar(200) COMMENT '课程编号',
`kechengmingcheng` varchar(200) COMMENT '课程名称',
`kechengleixing` varchar(200) COMMENT '课程类型',
`shijuanmingcheng` varchar(200) COMMENT '试卷名称',
`xiangguanfujian` varchar(200) COMMENT '相关附件',
`xiangguantupian` varchar(200) COMMENT '相关图片',
`shijuanneirong` longtext COMMENT '试卷内容',
`kaishishijian` datetime COMMENT '开始时间',
`jieshushijian` datetime COMMENT '结束时间',
`userid` bigint COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程考试';
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(81,'工号1','教师姓名1','学号1','学生姓名1','课程编号1','课程名称1','课程类型1','试卷名称1','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian1.jpg','试卷内容1',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,1);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(82,'工号2','教师姓名2','学号2','学生姓名2','课程编号2','课程名称2','课程类型2','试卷名称2','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian2.jpg','试卷内容2',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,2);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(83,'工号3','教师姓名3','学号3','学生姓名3','课程编号3','课程名称3','课程类型3','试卷名称3','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian3.jpg','试卷内容3',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,3);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(84,'工号4','教师姓名4','学号4','学生姓名4','课程编号4','课程名称4','课程类型4','试卷名称4','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian4.jpg','试卷内容4',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,4);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(85,'工号5','教师姓名5','学号5','学生姓名5','课程编号5','课程名称5','课程类型5','试卷名称5','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian5.jpg','试卷内容5',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,5);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(86,'工号6','教师姓名6','学号6','学生姓名6','课程编号6','课程名称6','课程类型6','试卷名称6','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian6.jpg','试卷内容6',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,6);
DROP TABLE IF EXISTS `wodekaoshi`;
CREATE TABLE `wodekaoshi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`kechengbianhao` varchar(200) COMMENT '课程编号',
`kechengmingcheng` varchar(200) COMMENT '课程名称',
`kechengleixing` varchar(200) COMMENT '课程类型',
`shijuanmingcheng` varchar(200) COMMENT '试卷名称',
`xiangguanfujian` varchar(200) COMMENT '相关附件',
`xiangguantupian` varchar(200) COMMENT '相关图片',
`shijuanneirong` longtext COMMENT '试卷内容',
`shijuanchengji` varchar(200) COMMENT '试卷成绩',
`beizhu` varchar(200) COMMENT '备注',
`userid` bigint COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的考试';
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(91,'工号1','教师姓名1','学号1','学生姓名1','课程编号1','课程名称1','课程类型1','试卷名称1','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian1.jpg','试卷内容1','试卷成绩1','备注1',1);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(92,'工号2','教师姓名2','学号2','学生姓名2','课程编号2','课程名称2','课程类型2','试卷名称2','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian2.jpg','试卷内容2','试卷成绩2','备注2',2);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(93,'工号3','教师姓名3','学号3','学生姓名3','课程编号3','课程名称3','课程类型3','试卷名称3','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian3.jpg','试卷内容3','试卷成绩3','备注3',3);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(94,'工号4','教师姓名4','学号4','学生姓名4','课程编号4','课程名称4','课程类型4','试卷名称4','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian4.jpg','试卷内容4','试卷成绩4','备注4',4);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(95,'工号5','教师姓名5','学号5','学生姓名5','课程编号5','课程名称5','课程类型5','试卷名称5','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian5.jpg','试卷内容5','试卷成绩5','备注5',5);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(96,'工号6','教师姓名6','学号6','学生姓名6','课程编号6','课程名称6','课程类型6','试卷名称6','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian6.jpg','试卷内容6','试卷成绩6','备注6',6);
DROP TABLE IF EXISTS `zuoyepigai`;
CREATE TABLE `zuoyepigai` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`kechengbianhao` varchar(200) COMMENT '课程编号',
`kechengmingcheng` varchar(200) COMMENT '课程名称',
`kechengleixing` varchar(200) COMMENT '课程类型',
`zuoyemingcheng` varchar(200) COMMENT '作业名称',
`xiangguantupian` varchar(200) COMMENT '相关图片',
`xiangguanfujian` varchar(200) COMMENT '相关附件',
`zuoyeneirong` longtext COMMENT '作业内容',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='作业批改';
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(101,'工号1','教师姓名1','课程编号1','课程名称1','课程类型1','作业名称1','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian1.jpg','','作业内容1','学号1','学生姓名1');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(102,'工号2','教师姓名2','课程编号2','课程名称2','课程类型2','作业名称2','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian2.jpg','','作业内容2','学号2','学生姓名2');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(103,'工号3','教师姓名3','课程编号3','课程名称3','课程类型3','作业名称3','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian3.jpg','','作业内容3','学号3','学生姓名3');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(104,'工号4','教师姓名4','课程编号4','课程名称4','课程类型4','作业名称4','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian4.jpg','','作业内容4','学号4','学生姓名4');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(105,'工号5','教师姓名5','课程编号5','课程名称5','课程类型5','作业名称5','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian5.jpg','','作业内容5','学号5','学生姓名5');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(106,'工号6','教师姓名6','课程编号6','课程名称6','课程类型6','作业名称6','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian6.jpg','','作业内容6','学号6','学生姓名6');
DROP TABLE IF EXISTS `kaoshipigai`;
CREATE TABLE `kaoshipigai` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`kechengbianhao` varchar(200) COMMENT '课程编号',
`kechengmingcheng` varchar(200) COMMENT '课程名称',
`kechengleixing` varchar(200) COMMENT '课程类型',
`shijuanmingcheng` varchar(200) COMMENT '试卷名称',
`xiangguanfujian` varchar(200) COMMENT '相关附件',
`xiangguantupian` varchar(200) COMMENT '相关图片',
`shijuanneirong` varchar(200) COMMENT '试卷内容',
`jiaojuanshijian` datetime COMMENT '交卷时间',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='考试批改';
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(111,'工号1','教师姓名1','课程编号1','课程名称1','课程类型1','试卷名称1','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian1.jpg','',CURRENT_TIMESTAMP,'学号1','学生姓名1');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(112,'工号2','教师姓名2','课程编号2','课程名称2','课程类型2','试卷名称2','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian2.jpg','',CURRENT_TIMESTAMP,'学号2','学生姓名2');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(113,'工号3','教师姓名3','课程编号3','课程名称3','课程类型3','试卷名称3','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian3.jpg','',CURRENT_TIMESTAMP,'学号3','学生姓名3');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(114,'工号4','教师姓名4','课程编号4','课程名称4','课程类型4','试卷名称4','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian4.jpg','',CURRENT_TIMESTAMP,'学号4','学生姓名4');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(115,'工号5','教师姓名5','课程编号5','课程名称5','课程类型5','试卷名称5','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian5.jpg','',CURRENT_TIMESTAMP,'学号5','学生姓名5');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(116,'工号6','教师姓名6','课程编号6','课程名称6','课程类型6','试卷名称6','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian6.jpg','',CURRENT_TIMESTAMP,'学号6','学生姓名6');
DROP TABLE IF EXISTS `kechenggonggao`;
CREATE TABLE `kechenggonggao` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`gonggaobiaoti` varchar(200) COMMENT '公告标题',
`gonggaoneirong` longtext COMMENT '公告内容',
`kechengmingcheng` varchar(200) COMMENT '课程名称',
`kechengbianhao` varchar(200) COMMENT '课程编号',
`kechengleixing` varchar(200) COMMENT '课程类型',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`faburiqi` date COMMENT '发布日期',
`gonggaotupian` varchar(200) COMMENT '公告图片',
`thumbsupnum` int default '0' COMMENT '赞',
`crazilynum` int default '0' COMMENT '踩',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程公告';
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(121,'公告标题1','公告内容1','课程名称1','课程编号1','课程类型1','工号1','教师姓名1',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian1.jpg',1,1);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(122,'公告标题2','公告内容2','课程名称2','课程编号2','课程类型2','工号2','教师姓名2',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian2.jpg',2,2);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(123,'公告标题3','公告内容3','课程名称3','课程编号3','课程类型3','工号3','教师姓名3',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian3.jpg',3,3);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(124,'公告标题4','公告内容4','课程名称4','课程编号4','课程类型4','工号4','教师姓名4',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian4.jpg',4,4);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(125,'公告标题5','公告内容5','课程名称5','课程编号5','课程类型5','工号5','教师姓名5',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian5.jpg',5,5);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(126,'公告标题6','公告内容6','课程名称6','课程编号6','课程类型6','工号6','教师姓名6',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian6.jpg',6,6);
DROP TABLE IF EXISTS `banjixinxi`;
CREATE TABLE `banjixinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`banji` varchar(200) NOT NULL UNIQUE COMMENT '班级',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`dianhua` varchar(200) COMMENT '电话',
`tupian` varchar(200) COMMENT '图片',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='班级信息';
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(131,'班级1','工号1','教师姓名1','电话1','http://localhost:8080/django22858/upload/banjixinxi_tupian1.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(132,'班级2','工号2','教师姓名2','电话2','http://localhost:8080/django22858/upload/banjixinxi_tupian2.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(133,'班级3','工号3','教师姓名3','电话3','http://localhost:8080/django22858/upload/banjixinxi_tupian3.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(134,'班级4','工号4','教师姓名4','电话4','http://localhost:8080/django22858/upload/banjixinxi_tupian4.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(135,'班级5','工号5','教师姓名5','电话5','http://localhost:8080/django22858/upload/banjixinxi_tupian5.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(136,'班级6','工号6','教师姓名6','电话6','http://localhost:8080/django22858/upload/banjixinxi_tupian6.jpg');
DROP TABLE IF EXISTS `wodebanji`;
CREATE TABLE `wodebanji` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`banji` varchar(200) NOT NULL COMMENT '班级',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`dianhua` varchar(200) COMMENT '电话',
`tupian` varchar(200) COMMENT '图片',
`sfsh` varchar(200) default '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的班级';
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(141,'学号1','学生姓名1','班级1','工号1','教师姓名1','电话1','http://localhost:8080/django22858/upload/wodebanji_tupian1.jpg','是','',1);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(142,'学号2','学生姓名2','班级2','工号2','教师姓名2','电话2','http://localhost:8080/django22858/upload/wodebanji_tupian2.jpg','是','',2);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(143,'学号3','学生姓名3','班级3','工号3','教师姓名3','电话3','http://localhost:8080/django22858/upload/wodebanji_tupian3.jpg','是','',3);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(144,'学号4','学生姓名4','班级4','工号4','教师姓名4','电话4','http://localhost:8080/django22858/upload/wodebanji_tupian4.jpg','是','',4);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(145,'学号5','学生姓名5','班级5','工号5','教师姓名5','电话5','http://localhost:8080/django22858/upload/wodebanji_tupian5.jpg','是','',5);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(146,'学号6','学生姓名6','班级6','工号6','教师姓名6','电话6','http://localhost:8080/django22858/upload/wodebanji_tupian6.jpg','是','',6);
DROP TABLE IF EXISTS `zaixianliuyan`;
CREATE TABLE `zaixianliuyan` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`liuyanbianhao` varchar(200) NOT NULL UNIQUE COMMENT '留言编号',
`tupian` varchar(200) COMMENT '图片',
`liuyanneirong` longtext COMMENT '留言内容',
`liuyanshijian` datetime COMMENT '留言时间',
`userid` bigint COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='在线留言';
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(151,'学号1','学生姓名1','工号1','教师姓名1','留言编号1','http://localhost:8080/django22858/upload/zaixianliuyan_tupian1.jpg','留言内容1',CURRENT_TIMESTAMP,1);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(152,'学号2','学生姓名2','工号2','教师姓名2','留言编号2','http://localhost:8080/django22858/upload/zaixianliuyan_tupian2.jpg','留言内容2',CURRENT_TIMESTAMP,2);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(153,'学号3','学生姓名3','工号3','教师姓名3','留言编号3','http://localhost:8080/django22858/upload/zaixianliuyan_tupian3.jpg','留言内容3',CURRENT_TIMESTAMP,3);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(154,'学号4','学生姓名4','工号4','教师姓名4','留言编号4','http://localhost:8080/django22858/upload/zaixianliuyan_tupian4.jpg','留言内容4',CURRENT_TIMESTAMP,4);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(155,'学号5','学生姓名5','工号5','教师姓名5','留言编号5','http://localhost:8080/django22858/upload/zaixianliuyan_tupian5.jpg','留言内容5',CURRENT_TIMESTAMP,5);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(156,'学号6','学生姓名6','工号6','教师姓名6','留言编号6','http://localhost:8080/django22858/upload/zaixianliuyan_tupian6.jpg','留言内容6',CURRENT_TIMESTAMP,6);
DROP TABLE IF EXISTS `liuyanhuifu`;
CREATE TABLE `liuyanhuifu` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) COMMENT '工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`xuehao` varchar(200) COMMENT '学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`liuyanbianhao` varchar(200) COMMENT '留言编号',
`tupian` varchar(200) COMMENT '图片',
`liuyanneirong` varchar(200) COMMENT '留言内容',
`huifuneirong` longtext COMMENT '回复内容',
`huifushijian` datetime COMMENT '回复时间',
`userid` bigint COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='留言回复';
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(161,'工号1','教师姓名1','学号1','学生姓名1','留言编号1','http://localhost:8080/django22858/upload/liuyanhuifu_tupian1.jpg','留言内容1','回复内容1',CURRENT_TIMESTAMP,1);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(162,'工号2','教师姓名2','学号2','学生姓名2','留言编号2','http://localhost:8080/django22858/upload/liuyanhuifu_tupian2.jpg','留言内容2','回复内容2',CURRENT_TIMESTAMP,2);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(163,'工号3','教师姓名3','学号3','学生姓名3','留言编号3','http://localhost:8080/django22858/upload/liuyanhuifu_tupian3.jpg','留言内容3','回复内容3',CURRENT_TIMESTAMP,3);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(164,'工号4','教师姓名4','学号4','学生姓名4','留言编号4','http://localhost:8080/django22858/upload/liuyanhuifu_tupian4.jpg','留言内容4','回复内容4',CURRENT_TIMESTAMP,4);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(165,'工号5','教师姓名5','学号5','学生姓名5','留言编号5','http://localhost:8080/django22858/upload/liuyanhuifu_tupian5.jpg','留言内容5','回复内容5',CURRENT_TIMESTAMP,5);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(166,'工号6','教师姓名6','学号6','学生姓名6','留言编号6','http://localhost:8080/django22858/upload/liuyanhuifu_tupian6.jpg','留言内容6','回复内容6',CURRENT_TIMESTAMP,6);
DROP TABLE IF EXISTS `storeup`;
CREATE TABLE `storeup` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint NOT NULL COMMENT '用户id',
`refid` bigint COMMENT '收藏id',
`tablename` varchar(200) COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '收藏名称',
`picture` varchar(200) NOT NULL COMMENT '收藏图片',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
DROP TABLE IF EXISTS `discusskechengxinxi`;
CREATE TABLE `discusskechengxinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint NOT NULL COMMENT '关联表id',
`userid` bigint NOT NULL COMMENT '用户id',
`nickname` varchar(200) COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程信息评论表';
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(181,1,1,'用户名1','评论内容1','回复内容1');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(182,2,2,'用户名2','评论内容2','回复内容2');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(183,3,3,'用户名3','评论内容3','回复内容3');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(184,4,4,'用户名4','评论内容4','回复内容4');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(185,5,5,'用户名5','评论内容5','回复内容5');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(186,6,6,'用户名6','评论内容6','回复内容6');
DROP TABLE IF EXISTS `discusswodekecheng`;
CREATE TABLE `discusswodekecheng` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint NOT NULL COMMENT '关联表id',
`userid` bigint NOT NULL COMMENT '用户id',
`nickname` varchar(200) COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的课程评论表';
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(191,1,1,'用户名1','评论内容1','回复内容1');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(192,2,2,'用户名2','评论内容2','回复内容2');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(193,3,3,'用户名3','评论内容3','回复内容3');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(194,4,4,'用户名4','评论内容4','回复内容4');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(195,5,5,'用户名5','评论内容5','回复内容5');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(196,6,6,'用户名6','评论内容6','回复内容6');
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config`(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='配置文件';
insert into config(id,name,value) values(1,'picture1','http://localhost:8080/django22858/upload/picture1.jpg');
insert into config(id,name,value) values(2,'picture2','http://localhost:8080/django22858/upload/picture2.jpg');
insert into config(id,name,value) values(3,'picture3','http://localhost:8080/django22858/upload/picture3.jpg');
insert into config(id,name) values(6,'homepage');
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) default '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';
insert into users(id,username, password) values(1,'abo','abo');
项目截图