一、前言
快速发展的社会中,人们的生活水平都在提高,生活节奏也在逐渐加快。为了节省时间和提高工作效率,越来越多的人选择利用互联网进行线上打理各种事务,然后线上管理系统也就相继涌现。与此同时,人们开始接受方便的生活方式。他们不仅希望页面简单大方,还希望操作方便,可以快速锁定他们需要的线上管理方式。基于这种情况,我们需要这样一个界面简单大方、功能齐全的系统来解决用户问题,满足用户需求。
课题主要分为三大模块:即管理员模块和学生、教师模块,主要功能包括:学生、教师、作业信息、学习模块、教学评价、学习情况等;
二、开发环境
开发语言:Java
框架:springboot
JDK版本:JDK1.8
服务器:tomcat7
数据库:mysql 5.7(一定要5.7版本)
数据库工具:Navicat11
开发软件:eclipse/myeclipse/idea
Maven包:Maven3.3.9
浏览器:谷歌浏览器
三、系统功能设计
一个用例图就能对应出系统中的一个功能过程,系统中完整的功能都是由许多不同的用例图所组成的。
学生作业管理系统分为三个部分,即管理员和学生、教师。该系统是根据用户的实际需求开发的,贴近生活。从管理员处获得的指定账号和密码可用于进入系统和使用相关的系统应用程序。管理员拥有最大的权限,其次是教师,最后是学生。管理员一般负责整个系统的运行维护和总体协调。
四、系统数据库设计
五、系统效果
六、核心代码
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: springboott43m8
-- ------------------------------------------------------
-- Server version 5.7.31
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `springboott43m8`
--
/*!40000 DROP DATABASE IF EXISTS `springboott43m8`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springboott43m8` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `springboott43m8`;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussxueximokuai`
--
DROP TABLE IF EXISTS `discussxueximokuai`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussxueximokuai` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`avatarurl` longtext COMMENT '头像',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='学习模块评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussxueximokuai`
--
LOCK TABLES `discussxueximokuai` WRITE;
/*!40000 ALTER TABLE `discussxueximokuai` DISABLE KEYS */;
/*!40000 ALTER TABLE `discussxueximokuai` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forum`
--
DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
`content` longtext NOT NULL COMMENT '帖子内容',
`parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`avatarurl` longtext COMMENT '头像',
`isdone` varchar(200) DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='交流论坛';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forum`
--
LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (81,'2023-03-05 03:21:14','帖子标题1','帖子内容1',0,1,'用户名1','upload/forum_avatarurl1.jpg,upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg','开放'),(82,'2023-03-05 03:21:14','帖子标题2','帖子内容2',0,2,'用户名2','upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg','开放'),(83,'2023-03-05 03:21:14','帖子标题3','帖子内容3',0,3,'用户名3','upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg','开放'),(84,'2023-03-05 03:21:14','帖子标题4','帖子内容4',0,4,'用户名4','upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg','开放'),(85,'2023-03-05 03:21:14','帖子标题5','帖子内容5',0,5,'用户名5','upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg','开放'),(86,'2023-03-05 03:21:14','帖子标题6','帖子内容6',0,6,'用户名6','upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg','开放'),(87,'2023-03-05 03:21:14','帖子标题7','帖子内容7',0,7,'用户名7','upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg','开放'),(88,'2023-03-05 03:21:14','帖子标题8','帖子内容8',0,8,'用户名8','upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg,upload/forum_avatarurl10.jpg','开放');
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaoshi`
--
DROP TABLE IF EXISTS `jiaoshi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaoshi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiaoshigonghao` varchar(200) NOT NULL COMMENT '教师工号',
`jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名',
`mima` varchar(200) NOT NULL COMMENT '密码',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`zhaopian` longtext COMMENT '照片',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
PRIMARY KEY (`id`),
UNIQUE KEY `jiaoshigonghao` (`jiaoshigonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1677986689242 DEFAULT CHARSET=utf8 COMMENT='教师';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaoshi`
--
LOCK TABLES `jiaoshi` WRITE;
/*!40000 ALTER TABLE `jiaoshi` DISABLE KEYS */;
INSERT INTO `jiaoshi` VALUES (21,'2023-03-05 03:21:14','教师工号1','教师姓名1','123456','13823888881','男','upload/jiaoshi_zhaopian1.jpg',1),(22,'2023-03-05 03:21:14','教师工号2','教师姓名2','123456','13823888882','男','upload/jiaoshi_zhaopian2.jpg',2),(23,'2023-03-05 03:21:14','教师工号3','教师姓名3','123456','13823888883','男','upload/jiaoshi_zhaopian3.jpg',3),(24,'2023-03-05 03:21:14','教师工号4','教师姓名4','123456','13823888884','男','upload/jiaoshi_zhaopian4.jpg',4),(25,'2023-03-05 03:21:14','教师工号5','教师姓名5','123456','13823888885','男','upload/jiaoshi_zhaopian5.jpg',5),(26,'2023-03-05 03:21:14','教师工号6','教师姓名6','123456','13823888886','男','upload/jiaoshi_zhaopian6.jpg',6),(27,'2023-03-05 03:21:14','教师工号7','教师姓名7','123456','13823888887','男','upload/jiaoshi_zhaopian7.jpg',7),(28,'2023-03-05 03:21:14','教师工号8','教师姓名8','123456','13823888888','男','upload/jiaoshi_zhaopian8.jpg',8),(1677986689241,'2023-03-05 03:24:49','22','王老师','22','13612341234','男','upload/1677986684099.jpg',35);
/*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaoxuepingjia`
--
DROP TABLE IF EXISTS `jiaoxuepingjia`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaoxuepingjia` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`pingjiabianhao` varchar(200) DEFAULT NULL COMMENT '评价编号',
`kechengmingcheng` varchar(200) DEFAULT NULL COMMENT '课程名称',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`pingjiakecheng` varchar(200) DEFAULT NULL COMMENT '评价课程',
`jiaoxuezhiliang` varchar(200) DEFAULT NULL COMMENT '教学质量',
`manyichengdu` varchar(200) DEFAULT NULL COMMENT '满意程度',
`pingjiashijian` datetime DEFAULT NULL COMMENT '评价时间',
`pingyu` longtext COMMENT '评语',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
PRIMARY KEY (`id`),
UNIQUE KEY `pingjiabianhao` (`pingjiabianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1677986837186 DEFAULT CHARSET=utf8 COMMENT='教学评价';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaoxuepingjia`
--
LOCK TABLES `jiaoxuepingjia` WRITE;
/*!40000 ALTER TABLE `jiaoxuepingjia` DISABLE KEYS */;
INSERT INTO `jiaoxuepingjia` VALUES (61,'2023-03-05 03:21:14','1111111111','课程名称1','教师工号1','教师姓名1','★','★','满意','2023-03-05 11:21:14','评语1','学号1','姓名1'),(62,'2023-03-05 03:21:14','2222222222','课程名称2','教师工号2','教师姓名2','★','★','满意','2023-03-05 11:21:14','评语2','学号2','姓名2'),(63,'2023-03-05 03:21:14','3333333333','课程名称3','教师工号3','教师姓名3','★','★','满意','2023-03-05 11:21:14','评语3','学号3','姓名3'),(64,'2023-03-05 03:21:14','4444444444','课程名称4','教师工号4','教师姓名4','★','★','满意','2023-03-05 11:21:14','评语4','学号4','姓名4'),(65,'2023-03-05 03:21:14','5555555555','课程名称5','教师工号5','教师姓名5','★','★','满意','2023-03-05 11:21:14','评语5','学号5','姓名5'),(66,'2023-03-05 03:21:14','6666666666','课程名称6','教师工号6','教师姓名6','★','★','满意','2023-03-05 11:21:14','评语6','学号6','姓名6'),(67,'2023-03-05 03:21:14','7777777777','课程名称7','教师工号7','教师姓名7','★','★','满意','2023-03-05 11:21:14','评语7','学号7','姓名7'),(68,'2023-03-05 03:21:14','8888888888','课程名称8','教师工号8','教师姓名8','★','★','满意','2023-03-05 11:21:14','评语8','学号8','姓名8'),(1677986837185,'2023-03-05 03:27:16','1677986812591','历史','22','王老师','★★','★★★','满意','2023-03-05 11:26:52','很好','11','小黄');
/*!40000 ALTER TABLE `jiaoxuepingjia` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kechengfenlei`
--
DROP TABLE IF EXISTS `kechengfenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kechengfenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`kechengfenlei` varchar(200) DEFAULT NULL COMMENT '课程分类',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='课程分类';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kechengfenlei`
--
LOCK TABLES `kechengfenlei` WRITE;
/*!40000 ALTER TABLE `kechengfenlei` DISABLE KEYS */;
INSERT INTO `kechengfenlei` VALUES (41,'2023-03-05 03:21:14','课程分类1'),(42,'2023-03-05 03:21:14','课程分类2'),(43,'2023-03-05 03:21:14','课程分类3'),(44,'2023-03-05 03:21:14','课程分类4'),(45,'2023-03-05 03:21:14','课程分类5'),(46,'2023-03-05 03:21:14','课程分类6'),(47,'2023-03-05 03:21:14','课程分类7'),(48,'2023-03-05 03:21:14','课程分类8');
/*!40000 ALTER TABLE `kechengfenlei` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`refid` bigint(20) DEFAULT NULL COMMENT '商品id',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '名称',
`picture` longtext NOT NULL COMMENT '图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩,31:竞拍参与,41:关注)',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
`remark` varchar(200) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,1677986624651,'11','xuesheng','学生','r03v6y392hi5hlge4ifpnyl5qec7uj9d','2023-03-05 03:23:55','2023-03-05 04:25:54'),(2,1677986689241,'22','jiaoshi','教师','7gva99i11pay5ll4o2kjmckmxe3yofh8','2023-03-05 03:25:01','2023-03-05 04:25:02'),(3,1,'admin','users','管理员','cba79jvqz9cmc16ly13evf6cp3zqkps5','2023-03-05 03:27:38','2023-03-05 04:27:39');
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','admin','管理员','2023-03-05 03:21:14');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xuesheng`
--
DROP TABLE IF EXISTS `xuesheng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuesheng` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) NOT NULL COMMENT '学号',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`mima` varchar(200) NOT NULL COMMENT '密码',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`zhaopian` longtext COMMENT '照片',
PRIMARY KEY (`id`),
UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=1677986624652 DEFAULT CHARSET=utf8 COMMENT='学生';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xuesheng`
--
LOCK TABLES `xuesheng` WRITE;
/*!40000 ALTER TABLE `xuesheng` DISABLE KEYS */;
INSERT INTO `xuesheng` VALUES (11,'2023-03-05 03:21:14','学号1','姓名1','男',1,'123456','13823888881','upload/xuesheng_zhaopian1.jpg'),(12,'2023-03-05 03:21:14','学号2','姓名2','男',2,'123456','13823888882','upload/xuesheng_zhaopian2.jpg'),(13,'2023-03-05 03:21:14','学号3','姓名3','男',3,'123456','13823888883','upload/xuesheng_zhaopian3.jpg'),(14,'2023-03-05 03:21:14','学号4','姓名4','男',4,'123456','13823888884','upload/xuesheng_zhaopian4.jpg'),(15,'2023-03-05 03:21:14','学号5','姓名5','男',5,'123456','13823888885','upload/xuesheng_zhaopian5.jpg'),(16,'2023-03-05 03:21:14','学号6','姓名6','男',6,'123456','13823888886','upload/xuesheng_zhaopian6.jpg'),(17,'2023-03-05 03:21:14','学号7','姓名7','男',7,'123456','13823888887','upload/xuesheng_zhaopian7.jpg'),(18,'2023-03-05 03:21:14','学号8','姓名8','男',8,'123456','13823888888','upload/xuesheng_zhaopian8.jpg'),(1677986624651,'2023-03-05 03:23:44','11','小黄','男',18,'11','13512341234','upload/1677986623718.png');
/*!40000 ALTER TABLE `xuesheng` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xueximokuai`
--
DROP TABLE IF EXISTS `xueximokuai`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xueximokuai` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`kechengbianhao` varchar(200) DEFAULT NULL COMMENT '课程编号',
`kechengmingcheng` varchar(200) DEFAULT NULL COMMENT '课程名称',
`kechengfenlei` varchar(200) DEFAULT NULL COMMENT '课程分类',
`xiangqing` longtext COMMENT '详情',
`shipin` longtext COMMENT '视频',
`tupian` longtext COMMENT '图片',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`wendang` longtext COMMENT '文档',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
PRIMARY KEY (`id`),
UNIQUE KEY `kechengbianhao` (`kechengbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='学习模块';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xueximokuai`
--
LOCK TABLES `xueximokuai` WRITE;
/*!40000 ALTER TABLE `xueximokuai` DISABLE KEYS */;
INSERT INTO `xueximokuai` VALUES (51,'2023-03-05 03:21:14','1111111111','课程名称1','课程分类1','详情1','','upload/xueximokuai_tupian1.jpg,upload/xueximokuai_tupian2.jpg,upload/xueximokuai_tupian3.jpg','教师工号1','教师姓名1','',1,1),(52,'2023-03-05 03:21:14','2222222222','课程名称2','课程分类2','详情2','','upload/xueximokuai_tupian2.jpg,upload/xueximokuai_tupian3.jpg,upload/xueximokuai_tupian4.jpg','教师工号2','教师姓名2','',2,2),(53,'2023-03-05 03:21:14','3333333333','课程名称3','课程分类3','详情3','','upload/xueximokuai_tupian3.jpg,upload/xueximokuai_tupian4.jpg,upload/xueximokuai_tupian5.jpg','教师工号3','教师姓名3','',3,3),(54,'2023-03-05 03:21:14','4444444444','课程名称4','课程分类4','详情4','','upload/xueximokuai_tupian4.jpg,upload/xueximokuai_tupian5.jpg,upload/xueximokuai_tupian6.jpg','教师工号4','教师姓名4','',4,4),(55,'2023-03-05 03:21:14','5555555555','课程名称5','课程分类5','详情5','','upload/xueximokuai_tupian5.jpg,upload/xueximokuai_tupian6.jpg,upload/xueximokuai_tupian7.jpg','教师工号5','教师姓名5','',5,5),(56,'2023-03-05 03:21:14','6666666666','课程名称6','课程分类6','详情6','','upload/xueximokuai_tupian6.jpg,upload/xueximokuai_tupian7.jpg,upload/xueximokuai_tupian8.jpg','教师工号6','教师姓名6','',6,6),(57,'2023-03-05 03:21:14','7777777777','课程名称7','课程分类7','详情7','','upload/xueximokuai_tupian7.jpg,upload/xueximokuai_tupian8.jpg,upload/xueximokuai_tupian9.jpg','教师工号7','教师姓名7','',7,7),(58,'2023-03-05 03:21:14','8888888888','课程名称8','课程分类8','详情8','','upload/xueximokuai_tupian8.jpg,upload/xueximokuai_tupian9.jpg,upload/xueximokuai_tupian10.jpg','教师工号8','教师姓名8','',8,8);
/*!40000 ALTER TABLE `xueximokuai` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xuexiqingkuang`
--
DROP TABLE IF EXISTS `xuexiqingkuang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuexiqingkuang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`kechengmingcheng` varchar(200) DEFAULT NULL COMMENT '课程名称',
`fengmian` longtext COMMENT '封面',
`xuexitianshu` float DEFAULT NULL COMMENT '学习天数',
`wanchengdu` float DEFAULT NULL COMMENT '完成度',
`zongshizhang` float DEFAULT NULL COMMENT '总时长',
`shangkeqingkuang` longtext COMMENT '上课情况',
`dengjiriqi` date DEFAULT NULL COMMENT '登记日期',
`jiaoshizhanghao` varchar(200) DEFAULT NULL COMMENT '教师账号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='学习情况';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xuexiqingkuang`
--
LOCK TABLES `xuexiqingkuang` WRITE;
/*!40000 ALTER TABLE `xuexiqingkuang` DISABLE KEYS */;
INSERT INTO `xuexiqingkuang` VALUES (71,'2023-03-05 03:21:14','学号1','姓名1','课程名称1','upload/xuexiqingkuang_fengmian1.jpg,upload/xuexiqingkuang_fengmian2.jpg,upload/xuexiqingkuang_fengmian3.jpg',1,1,1,'上课情况1','2023-03-05','教师账号1','教师姓名1',1),(72,'2023-03-05 03:21:14','学号2','姓名2','课程名称2','upload/xuexiqingkuang_fengmian2.jpg,upload/xuexiqingkuang_fengmian3.jpg,upload/xuexiqingkuang_fengmian4.jpg',2,2,2,'上课情况2','2023-03-05','教师账号2','教师姓名2',2),(73,'2023-03-05 03:21:14','学号3','姓名3','课程名称3','upload/xuexiqingkuang_fengmian3.jpg,upload/xuexiqingkuang_fengmian4.jpg,upload/xuexiqingkuang_fengmian5.jpg',3,3,3,'上课情况3','2023-03-05','教师账号3','教师姓名3',3),(74,'2023-03-05 03:21:14','学号4','姓名4','课程名称4','upload/xuexiqingkuang_fengmian4.jpg,upload/xuexiqingkuang_fengmian5.jpg,upload/xuexiqingkuang_fengmian6.jpg',4,4,4,'上课情况4','2023-03-05','教师账号4','教师姓名4',4),(75,'2023-03-05 03:21:14','学号5','姓名5','课程名称5','upload/xuexiqingkuang_fengmian5.jpg,upload/xuexiqingkuang_fengmian6.jpg,upload/xuexiqingkuang_fengmian7.jpg',5,5,5,'上课情况5','2023-03-05','教师账号5','教师姓名5',5),(76,'2023-03-05 03:21:14','学号6','姓名6','课程名称6','upload/xuexiqingkuang_fengmian6.jpg,upload/xuexiqingkuang_fengmian7.jpg,upload/xuexiqingkuang_fengmian8.jpg',6,6,6,'上课情况6','2023-03-05','教师账号6','教师姓名6',6),(77,'2023-03-05 03:21:14','学号7','姓名7','课程名称7','upload/xuexiqingkuang_fengmian7.jpg,upload/xuexiqingkuang_fengmian8.jpg,upload/xuexiqingkuang_fengmian9.jpg',7,7,7,'上课情况7','2023-03-05','教师账号7','教师姓名7',7),(78,'2023-03-05 03:21:14','学号8','姓名8','课程名称8','upload/xuexiqingkuang_fengmian8.jpg,upload/xuexiqingkuang_fengmian9.jpg,upload/xuexiqingkuang_fengmian10.jpg',8,8,8,'上课情况8','2023-03-05','教师账号8','教师姓名8',8);
/*!40000 ALTER TABLE `xuexiqingkuang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zuoyexinxi`
--
DROP TABLE IF EXISTS `zuoyexinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zuoyexinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zuoyemingcheng` varchar(200) NOT NULL COMMENT '作业名称',
`zuoyeneirong` longtext COMMENT '作业内容',
`tupian` longtext COMMENT '图片',
`xiangguanfujian` longtext NOT NULL COMMENT '相关附件',
`zuoyezhuangtai` varchar(200) DEFAULT NULL COMMENT '作业状态',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
`xuehao` varchar(200) NOT NULL COMMENT '学号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1677986735740 DEFAULT CHARSET=utf8 COMMENT='作业信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zuoyexinxi`
--
LOCK TABLES `zuoyexinxi` WRITE;
/*!40000 ALTER TABLE `zuoyexinxi` DISABLE KEYS */;
INSERT INTO `zuoyexinxi` VALUES (31,'2023-03-05 03:21:14','作业名称1','作业内容1','upload/zuoyexinxi_tupian1.jpg,upload/zuoyexinxi_tupian2.jpg,upload/zuoyexinxi_tupian3.jpg','','已完成','教师工号1','教师姓名1','2023-03-05 11:21:14','学号1','姓名1'),(32,'2023-03-05 03:21:14','作业名称2','作业内容2','upload/zuoyexinxi_tupian2.jpg,upload/zuoyexinxi_tupian3.jpg,upload/zuoyexinxi_tupian4.jpg','','已完成','教师工号2','教师姓名2','2023-03-05 11:21:14','学号2','姓名2'),(33,'2023-03-05 03:21:14','作业名称3','作业内容3','upload/zuoyexinxi_tupian3.jpg,upload/zuoyexinxi_tupian4.jpg,upload/zuoyexinxi_tupian5.jpg','','已完成','教师工号3','教师姓名3','2023-03-05 11:21:14','学号3','姓名3'),(34,'2023-03-05 03:21:14','作业名称4','作业内容4','upload/zuoyexinxi_tupian4.jpg,upload/zuoyexinxi_tupian5.jpg,upload/zuoyexinxi_tupian6.jpg','','已完成','教师工号4','教师姓名4','2023-03-05 11:21:14','学号4','姓名4'),(35,'2023-03-05 03:21:14','作业名称5','作业内容5','upload/zuoyexinxi_tupian5.jpg,upload/zuoyexinxi_tupian6.jpg,upload/zuoyexinxi_tupian7.jpg','','已完成','教师工号5','教师姓名5','2023-03-05 11:21:14','学号5','姓名5'),(36,'2023-03-05 03:21:14','作业名称6','作业内容6','upload/zuoyexinxi_tupian6.jpg,upload/zuoyexinxi_tupian7.jpg,upload/zuoyexinxi_tupian8.jpg','','已完成','教师工号6','教师姓名6','2023-03-05 11:21:14','学号6','姓名6'),(37,'2023-03-05 03:21:14','作业名称7','作业内容7','upload/zuoyexinxi_tupian7.jpg,upload/zuoyexinxi_tupian8.jpg,upload/zuoyexinxi_tupian9.jpg','','已完成','教师工号7','教师姓名7','2023-03-05 11:21:14','学号7','姓名7'),(38,'2023-03-05 03:21:14','作业名称8','作业内容8','upload/zuoyexinxi_tupian8.jpg,upload/zuoyexinxi_tupian9.jpg,upload/zuoyexinxi_tupian10.jpg','','已完成','教师工号8','教师姓名8','2023-03-05 11:21:14','学号8','姓名8'),(1677986735739,'2023-03-05 03:25:35','历史','<p>测试</p>','upload/1677986722081.png','upload/1677986726382.png','未完成','22','王老师','2023-03-05 11:25:05','11','小黄');
/*!40000 ALTER TABLE `zuoyexinxi` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-03-08 10:27:26