功能介绍
用户端功能有：首页、学习资源、资源推荐、资源评价、公告信息、个人中心、后台管理。登录后台有个人信息管理、学习记录管理、资源评价管理、收藏管理。
管理端功能有：科目管理、教师管理、学生管理、学习资源管理、学习记录管理、资源评价管理、系统管理等。
教师端的功能有：个人中心、学习资源管理、学习记录管理、资源评价管理
更多功能请看运行截图！
使用技术
开发语言：python
使用框架：Django2.0
前端技术：JavaScript、VUE.js（2.X）、css3
数据库：MySQL 5.7
数据库管理工具：Navicat或sqlyog
开发工具：pycharm
python版本：python3.7及以上
数据库脚本
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)---- Host: localhost Database: djangoqn3mz-- -------------------------------------------------------- Server version5.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: `djangoqn3mz`--/*!40000 DROP DATABASE IF EXISTS `djangoqn3mz`*/;CREATE DATABASE /*!32312 IF NOT EXISTS*/ `djangoqn3mz` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE `djangoqn3mz`;---- 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 `discussxuexiziyuan`--DROP TABLE IF EXISTS `discussxuexiziyuan`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `discussxuexiziyuan` (`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',`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',`content` longtext NOT NULL COMMENT '评论内容',`reply` longtext COMMENT '回复内容',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='学习资源评论表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `discussxuexiziyuan`--LOCK TABLES `discussxuexiziyuan` WRITE;/*!40000 ALTER TABLE `discussxuexiziyuan` DISABLE KEYS */;/*!40000 ALTER TABLE `discussxuexiziyuan` 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 '教师工号',`mima` varchar(200) NOT NULL COMMENT '密码',`jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名',`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',`zhicheng` varchar(200) DEFAULT NULL COMMENT '职称',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',`jiaoshiyouxiang` varchar(200) DEFAULT NULL COMMENT '教师邮箱',PRIMARY KEY (`id`),UNIQUE KEY `jiaoshigonghao` (`jiaoshigonghao`)) ENGINE=InnoDB AUTO_INCREMENT=27 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 */;/*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `kemu`--DROP TABLE IF EXISTS `kemu`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `kemu` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`kemu` varchar(200) NOT NULL COMMENT '科目',PRIMARY KEY (`id`),UNIQUE KEY `kemu` (`kemu`)) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='科目';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `kemu`--LOCK TABLES `kemu` WRITE;/*!40000 ALTER TABLE `kemu` DISABLE KEYS */;INSERT INTO `kemu` VALUES (11,'-02-23 12:58:48','科目1'),(12,'-02-23 12:58:48','科目2'),(13,'-02-23 12:58:48','科目3'),(14,'-02-23 12:58:48','科目4'),(15,'-02-23 12:58:48','科目5'),(16,'-02-23 12:58:48','科目6');/*!40000 ALTER TABLE `kemu` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `news`--DROP TABLE IF EXISTS `news`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `news` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`title` varchar(200) NOT NULL COMMENT '标题',`introduction` longtext COMMENT '简介',`picture` varchar(200) NOT NULL COMMENT '图片',`content` longtext NOT NULL COMMENT '内容',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='公告信息';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `news`--LOCK TABLES `news` WRITE;/*!40000 ALTER TABLE `news` DISABLE KEYS */;/*!40000 ALTER TABLE `news` 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` varchar(200) NOT NULL COMMENT '收藏图片',`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',`inteltype` 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 `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,'abo','abo','管理员','-02-23 12:58:48');/*!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 '学号',`mima` varchar(200) NOT NULL COMMENT '密码',`xingming` varchar(200) NOT NULL COMMENT '姓名',`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',`shouji` varchar(200) DEFAULT NULL COMMENT '手机',`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',PRIMARY KEY (`id`),UNIQUE KEY `xuehao` (`xuehao`)) ENGINE=InnoDB AUTO_INCREMENT=37 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 (31,'-02-23 12:58:48','学号1','123456','姓名1','男','upload/xuesheng_touxiang1.jpg','13823888881','773890001@'),(32,'-02-23 12:58:48','学号2','123456','姓名2','男','upload/xuesheng_touxiang2.jpg','13823888882','773890002@'),(33,'-02-23 12:58:48','学号3','123456','姓名3','男','upload/xuesheng_touxiang3.jpg','13823888883','773890003@'),(34,'-02-23 12:58:48','学号4','123456','姓名4','男','upload/xuesheng_touxiang4.jpg','13823888884','773890004@'),(35,'-02-23 12:58:48','学号5','123456','姓名5','男','upload/xuesheng_touxiang5.jpg','13823888885','773890005@'),(36,'-02-23 12:58:48','学号6','123456','姓名6','男','upload/xuesheng_touxiang6.jpg','13823888886','773890006@');/*!40000 ALTER TABLE `xuesheng` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `xuexijilu`--DROP TABLE IF EXISTS `xuexijilu`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `xuexijilu` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`mingcheng` varchar(200) DEFAULT NULL COMMENT '名称',`kemu` varchar(200) DEFAULT NULL COMMENT '科目',`tupian` varchar(200) DEFAULT NULL COMMENT '图片',`shipin` varchar(200) DEFAULT NULL COMMENT '视频',`ziyuan` varchar(200) DEFAULT NULL COMMENT '资源',`xuexijindu` varchar(200) NOT NULL COMMENT '学习进度',`xuexibiji` longtext COMMENT '学习笔记',`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',`xuexiriqi` date DEFAULT NULL COMMENT '学习日期',`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`shouji` varchar(200) DEFAULT NULL COMMENT '手机',`crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',`crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',`shhf` longtext COMMENT '审核回复',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='学习记录';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `xuexijilu`--LOCK TABLES `xuexijilu` WRITE;/*!40000 ALTER TABLE `xuexijilu` DISABLE KEYS */;INSERT INTO `xuexijilu` VALUES (51,'-02-23 12:58:48','名称1','科目1','upload/xuexijilu_tupian1.jpg','','','学习中','学习笔记1','教师工号1','教师姓名1','-02-23','学号1','姓名1','13823888881',1,1,'是',''),(52,'-02-23 12:58:48','名称2','科目2','upload/xuexijilu_tupian2.jpg','','','学习中','学习笔记2','教师工号2','教师姓名2','-02-23','学号2','姓名2','13823888882',2,2,'是',''),(53,'-02-23 12:58:48','名称3','科目3','upload/xuexijilu_tupian3.jpg','','','学习中','学习笔记3','教师工号3','教师姓名3','-02-23','学号3','姓名3','13823888883',3,3,'是',''),(54,'-02-23 12:58:48','名称4','科目4','upload/xuexijilu_tupian4.jpg','','','学习中','学习笔记4','教师工号4','教师姓名4','-02-23','学号4','姓名4','13823888884',4,4,'是',''),(55,'-02-23 12:58:48','名称5','科目5','upload/xuexijilu_tupian5.jpg','','','学习中','学习笔记5','教师工号5','教师姓名5','-02-23','学号5','姓名5','13823888885',5,5,'是',''),(56,'-02-23 12:58:48','名称6','科目6','upload/xuexijilu_tupian6.jpg','','','学习中','学习笔记6','教师工号6','教师姓名6','-02-23','学号6','姓名6','13823888886',6,6,'是','');/*!40000 ALTER TABLE `xuexijilu` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `xuexiziyuan`--DROP TABLE IF EXISTS `xuexiziyuan`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `xuexiziyuan` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`mingcheng` varchar(200) NOT NULL COMMENT '名称',`kemu` varchar(200) DEFAULT NULL COMMENT '科目',`tupian` varchar(200) DEFAULT NULL COMMENT '图片',`shipin` varchar(200) DEFAULT NULL COMMENT '视频',`ziyuan` varchar(200) DEFAULT NULL COMMENT '资源',`xiangqing` longtext COMMENT '详情',`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',`faburiqi` date DEFAULT NULL COMMENT '发布日期',`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='学习资源';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `xuexiziyuan`--LOCK TABLES `xuexiziyuan` WRITE;/*!40000 ALTER TABLE `xuexiziyuan` DISABLE KEYS */;INSERT INTO `xuexiziyuan` VALUES (41,'-02-23 12:58:48','名称1','科目1','upload/xuexiziyuan_tupian1.jpg','','','详情1','教师工号1','教师姓名1','13823888881','-02-23','-02-23 20:58:48'),(42,'-02-23 12:58:48','名称2','科目2','upload/xuexiziyuan_tupian2.jpg','','','详情2','教师工号2','教师姓名2','13823888882','-02-23','-02-23 20:58:48'),(43,'-02-23 12:58:48','名称3','科目3','upload/xuexiziyuan_tupian3.jpg','','','详情3','教师工号3','教师姓名3','13823888883','-02-23','-02-23 20:58:48'),(44,'-02-23 12:58:48','名称4','科目4','upload/xuexiziyuan_tupian4.jpg','','','详情4','教师工号4','教师姓名4','13823888884','-02-23','-02-23 20:58:48'),(45,'-02-23 12:58:48','名称5','科目5','upload/xuexiziyuan_tupian5.jpg','','','详情5','教师工号5','教师姓名5','13823888885','-02-23','-02-23 20:58:48'),(46,'-02-23 12:58:48','名称6','科目6','upload/xuexiziyuan_tupian6.jpg','','','详情6','教师工号6','教师姓名6','13823888886','-02-23','-02-23 20:58:48');/*!40000 ALTER TABLE `xuexiziyuan` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `ziyuanpingjia`--DROP TABLE IF EXISTS `ziyuanpingjia`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `ziyuanpingjia` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`mingcheng` varchar(200) DEFAULT NULL COMMENT '名称',`kemu` varchar(200) DEFAULT NULL COMMENT '科目',`tupian` varchar(200) DEFAULT NULL COMMENT '图片',`ziyuanpingfen` varchar(200) NOT NULL COMMENT '资源评分',`ziyuanpingjia` longtext COMMENT '资源评价',`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',`pingjiariqi` date DEFAULT NULL COMMENT '评价日期',`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',`crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',`crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',`shhf` longtext COMMENT '审核回复',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='资源评价';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `ziyuanpingjia`--LOCK TABLES `ziyuanpingjia` WRITE;/*!40000 ALTER TABLE `ziyuanpingjia` DISABLE KEYS */;INSERT INTO `ziyuanpingjia` VALUES (61,'-02-23 12:58:48','名称1','科目1','upload/ziyuanpingjia_tupian1.jpg','1','资源评价1','教师工号1','-02-23','学号1',1,1,'是',''),(62,'-02-23 12:58:48','名称2','科目2','upload/ziyuanpingjia_tupian2.jpg','1','资源评价2','教师工号2','-02-23','学号2',2,2,'是',''),(63,'-02-23 12:58:48','名称3','科目3','upload/ziyuanpingjia_tupian3.jpg','1','资源评价3','教师工号3','-02-23','学号3',3,3,'是',''),(64,'-02-23 12:58:48','名称4','科目4','upload/ziyuanpingjia_tupian4.jpg','1','资源评价4','教师工号4','-02-23','学号4',4,4,'是',''),(65,'-02-23 12:58:48','名称5','科目5','upload/ziyuanpingjia_tupian5.jpg','1','资源评价5','教师工号5','-02-23','学号5',5,5,'是',''),(66,'-02-23 12:58:48','名称6','科目6','upload/ziyuanpingjia_tupian6.jpg','1','资源评价6','教师工号6','-02-23','学号6',6,6,'是','');/*!40000 ALTER TABLE `ziyuanpingjia` 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 -02-27 11:26:06
