非洲购物网站排名,替代wordpress,网站的结构怎么做,网页游戏推广平台博主介绍#xff1a;✌从事软件开发10年之余#xff0c;专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ #x1f345;文末获取源码联系#x1f345; #x1f447;#x1f3fb; 精… 博主介绍✌从事软件开发10年之余专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ 文末获取源码联系 精彩专栏推荐订阅 不然下次找不到哟 ————————————————计算机毕业设计《1000套》✌ 目录
1、项目介绍及开发技术
1.1 项目介绍
1.2 开发技术
2、系统功能设计结构图
3、功能截图
4、数据库表结构设计
5、关键代码
5.1 课程资源管理Controller模块
5.2 课程资源管理Service模块
5.3 课程资源管理ServiceImpl模块
5.4 课程资源管理Dao模块
6、论文目录结构
7、源码获取 1、项目介绍及开发技术 1.1 项目介绍
传统办法管理信息首先需要花费的时间比较多其次数据出错率比较高而且对错误的数据进行更改也比较困难最后检索数据费事费力。因此在计算机上安装大学生平时成绩量化管理系统软件来发挥其高效地信息处理的作用可以规范信息管理流程让管理工作可以系统化和程序化同时大学生平时成绩量化管理系统的有效运用可以帮助管理人员准确快速地处理信息。
大学生平时成绩量化管理系统在对开发工具的选择上也很慎重为了便于开发实现选择的开发工具为Eclipse选择的数据库工具为Mysql。以此搭建开发环境实现大学生平时成绩量化管理系统的功能。其中管理员管理用户新闻公告。
大学生平时成绩量化管理系统是一款运用软件开发技术设计实现的应用系统在信息处理上可以达到快速的目的不管是针对数据添加数据维护和统计以及数据查询等处理要求大学生平时成绩量化管理系统都可以轻松应对。
1.2 开发技术
Java开发语言、SpringBoot、MyBatisPlus、MySQL数据库、Maven、IDEA开发工具、JDK1.8、Vue、HTML、CSS、JS。 2、系统功能设计结构图 3、功能截图 学生管理学生的查询管理可以删除学生、修改学生、新增学生还进行了对用户名称的模糊查询的条件。 成绩信息管理 查看已发布的成绩信息数据修改成绩信息成绩信息作废即可删除还进行了对成绩信息名称的模糊查询 成绩信息信息的类型查询等等一些条件。 公告类型管理 根据公告类型进行条件查询还可以对公告类型进行新增、修改、查询操作等等。 公告信息管理 根据公告信息进行新增、修改、查询操作等等。 4、数据库表结构设计 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)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT配置文件;/*Data for the table config */insert into config(id,name,value) values (1,轮播图1,upload/config1.jpg),(2,轮播图2,upload/config2.jpg),(3,轮播图3,upload/config3.jpg);/*Table structure for table dictionary */DROP TABLE IF EXISTS dictionary;CREATE TABLE dictionary (id int(20) NOT NULL AUTO_INCREMENT COMMENT 主键,dic_code varchar(200) DEFAULT NULL COMMENT 字段,dic_name varchar(200) DEFAULT NULL COMMENT 字段名,code_index int(11) DEFAULT NULL COMMENT 编码,index_name varchar(200) DEFAULT NULL COMMENT 编码名字 Search111 ,super_id int(11) DEFAULT NULL COMMENT 父字段id,beizhu varchar(200) DEFAULT NULL COMMENT 备注,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT20 DEFAULT CHARSETutf8 COMMENT字典表;/*Data for the table dictionary */insert into dictionary(id,dic_code,dic_name,code_index,index_name,super_id,beizhu,create_time) values (1,fabujiaoan_types,教案类型,1,教案类型1,NULL,NULL,2023-03-13 14:42:20),(2,fabujiaoan_types,教案类型,2,教案类型2,NULL,NULL,2023-03-13 14:42:20),(3,fabujiaoan_types,教案类型,3,教案类型3,NULL,NULL,2023-03-13 14:42:20),(4,kecheng_types,课程类型,1,课程类型1,NULL,NULL,2023-03-13 14:42:20),(5,kecheng_types,课程类型,2,课程类型2,NULL,NULL,2023-03-13 14:42:20),(6,kecheng_types,课程类型,3,课程类型3,NULL,NULL,2023-03-13 14:42:20),(7,sex_types,性别,1,男,NULL,NULL,2023-03-13 14:42:20),(8,sex_types,性别,2,女,NULL,NULL,2023-03-13 14:42:20),(9,news_types,公告类型,1,公告类型1,NULL,NULL,2023-03-13 14:42:20),(10,news_types,公告类型,2,公告类型2,NULL,NULL,2023-03-13 14:42:20),(11,news_types,公告类型,3,公告类型3,NULL,NULL,2023-03-13 14:42:20),(12,forum_state_types,帖子状态,1,发帖,NULL,NULL,2023-03-13 14:42:20),(13,forum_state_types,帖子状态,2,回帖,NULL,NULL,2023-03-13 14:42:20),(14,kecheng_collection_types,收藏表类型,1,收藏,NULL,NULL,2023-03-13 14:42:21),(15,kecheng_collection_types,收藏表类型,2,赞,NULL,NULL,2023-03-13 14:42:21),(16,kecheng_collection_types,收藏表类型,3,踩,NULL,NULL,2023-03-13 14:42:21),(17,xueke_types,学科,1,学科1,NULL,NULL,2023-03-13 14:42:21),(18,xueke_types,学科,2,学科2,NULL,NULL,2023-03-13 14:42:21),(19,xueke_types,学科,3,学科3,NULL,NULL,2023-03-13 14:42:21);/*Table structure for table fabujiaoan */DROP TABLE IF EXISTS fabujiaoan;CREATE TABLE fabujiaoan (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,fabujiaoan_name varchar(200) DEFAULT NULL COMMENT 教案名称 Search111,fabujiaoan_photo varchar(200) DEFAULT NULL COMMENT 教案图片,fabujiaoan_types int(11) DEFAULT NULL COMMENT 教案类型 Search111,fabujiaoan_content text COMMENT 教案详情,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT教案信息;/*Data for the table fabujiaoan */insert into fabujiaoan(id,fabujiaoan_name,fabujiaoan_photo,fabujiaoan_types,fabujiaoan_content,create_time) values (1,教案名称1,upload/fabujiaoan1.jpg,3,教案详情1,2023-03-13 14:42:36),(2,教案名称2,upload/fabujiaoan2.jpg,1,教案详情2,2023-03-13 14:42:36),(3,教案名称3,upload/fabujiaoan3.jpg,1,教案详情3,2023-03-13 14:42:36),(4,教案名称4,upload/fabujiaoan4.jpg,1,教案详情4,2023-03-13 14:42:36),(5,教案名称5,upload/fabujiaoan5.jpg,3,教案详情5,2023-03-13 14:42:36),(6,教案名称6,upload/fabujiaoan6.jpg,2,教案详情6,2023-03-13 14:42:36),(7,教案名称7,upload/fabujiaoan7.jpg,3,教案详情7,2023-03-13 14:42:36),(8,教案名称8,upload/fabujiaoan8.jpg,2,教案详情8,2023-03-13 14:42:36),(9,教案名称9,upload/fabujiaoan9.jpg,3,教案详情9,2023-03-13 14:42:36),(10,教案名称10,upload/fabujiaoan10.jpg,3,教案详情10,2023-03-13 14:42:36),(11,教案名称11,upload/fabujiaoan11.jpg,2,教案详情11,2023-03-13 14:42:36),(12,教案名称12,upload/fabujiaoan12.jpg,3,教案详情12,2023-03-13 14:42:36),(13,教案名称13,upload/fabujiaoan13.jpg,2,教案详情13,2023-03-13 14:42:36),(14,教案名称14,upload/fabujiaoan14.jpg,1,教案详情14,2023-03-13 14:42:36);/*Table structure for table forum */DROP TABLE IF EXISTS forum;CREATE TABLE forum (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,forum_name varchar(200) DEFAULT NULL COMMENT 帖子标题 Search111 ,yonghu_id int(11) DEFAULT NULL COMMENT 学生,jiaoshi_id int(11) DEFAULT NULL COMMENT 教师,users_id int(11) DEFAULT NULL COMMENT 管理员,forum_content text COMMENT 发布内容,super_ids int(11) DEFAULT NULL COMMENT 父id,forum_state_types int(11) DEFAULT NULL COMMENT 帖子状态,insert_time timestamp NULL DEFAULT NULL COMMENT 发帖时间,update_time timestamp NULL DEFAULT NULL COMMENT 修改时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show2,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT18 DEFAULT CHARSETutf8 COMMENT论坛;/*Data for the table forum */insert into forum(id,forum_name,yonghu_id,jiaoshi_id,users_id,forum_content,super_ids,forum_state_types,insert_time,update_time,create_time) values (1,帖子标题1,2,NULL,NULL,发布内容1,493,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(2,帖子标题2,1,NULL,NULL,发布内容2,230,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(3,帖子标题3,1,NULL,NULL,发布内容3,166,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(4,帖子标题4,2,NULL,NULL,发布内容4,37,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(5,帖子标题5,1,NULL,NULL,发布内容5,225,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(6,帖子标题6,2,NULL,NULL,发布内容6,245,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(7,帖子标题7,2,NULL,NULL,发布内容7,196,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(8,帖子标题8,2,NULL,NULL,发布内容8,397,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(9,帖子标题9,3,NULL,NULL,发布内容9,37,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(10,帖子标题10,2,NULL,NULL,发布内容10,333,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(11,帖子标题11,1,NULL,NULL,发布内容11,409,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(12,帖子标题12,2,NULL,NULL,发布内容12,489,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(13,帖子标题13,2,NULL,NULL,发布内容13,285,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(14,帖子标题14,1,NULL,NULL,发布内容14,160,1,2023-03-13 14:42:36,2023-03-13 14:42:36,2023-03-13 14:42:36),(15,NULL,1,NULL,NULL,123123,14,2,2023-03-13 15:10:26,NULL,2023-03-13 15:10:26),(16,NULL,NULL,1,NULL,123,14,2,2023-03-13 15:11:43,NULL,2023-03-13 15:11:43),(17,NULL,NULL,NULL,NULL,123123,14,2,2023-03-13 15:12:34,NULL,2023-03-13 15:12:34);/*Table structure for table jiaoshi */DROP TABLE IF EXISTS jiaoshi;CREATE TABLE jiaoshi (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,jiaoshi_uuid_number varchar(200) DEFAULT NULL COMMENT 工号 Search111 ,username varchar(200) DEFAULT NULL COMMENT 账户,password varchar(200) DEFAULT NULL COMMENT 密码,jiaoshi_name varchar(200) DEFAULT NULL COMMENT 教师姓名 Search111 ,jiaoshi_photo varchar(255) DEFAULT NULL COMMENT 头像,sex_types int(11) DEFAULT NULL COMMENT 性别 Search111 ,jiaoshi_phone varchar(200) DEFAULT NULL COMMENT 联系方式,jiaoshi_email varchar(200) DEFAULT NULL COMMENT 邮箱,jiaoshi_delete int(11) DEFAULT 1 COMMENT 假删,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT教师;/*Data for the table jiaoshi */insert into jiaoshi(id,jiaoshi_uuid_number,username,password,jiaoshi_name,jiaoshi_photo,sex_types,jiaoshi_phone,jiaoshi_email,jiaoshi_delete,create_time) values (1,1678689756311,a1,123456,教师姓名1,upload/jiaoshi1.jpg,1,17703786901,1qq.com,1,2023-03-13 14:42:36),(2,1678689756321,a2,123456,教师姓名2,upload/jiaoshi2.jpg,2,17703786902,2qq.com,1,2023-03-13 14:42:36),(3,1678689756337,a3,123456,教师姓名3,upload/jiaoshi3.jpg,2,17703786903,3qq.com,1,2023-03-13 14:42:36);/*Table structure for table kecheng */DROP TABLE IF EXISTS kecheng;CREATE TABLE kecheng (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,kecheng_name varchar(200) DEFAULT NULL COMMENT 课程名称 Search111,kecheng_photo varchar(200) DEFAULT NULL COMMENT 课程封面,kecheng_video varchar(200) DEFAULT NULL COMMENT 课程视频,kecheng_file varchar(200) DEFAULT NULL COMMENT 课程文件,xueke_types int(11) DEFAULT NULL COMMENT 学科 Search111,jiaoshi_id int(11) DEFAULT NULL COMMENT 教师,zan_number int(11) DEFAULT NULL COMMENT 赞,cai_number int(11) DEFAULT NULL COMMENT 踩,kecheng_types int(11) DEFAULT NULL COMMENT 课程类型 Search111,kecheng_content text COMMENT 课程详情,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show1 show2 photoShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT课程资源;/*Data for the table kecheng */insert into kecheng(id,kecheng_name,kecheng_photo,kecheng_video,kecheng_file,xueke_types,jiaoshi_id,zan_number,cai_number,kecheng_types,kecheng_content,create_time) values (1,课程名称1,upload/kecheng1.jpg,upload/video.mp4,upload/file.rar,2,1,112,377,1,课程详情1,2023-03-13 14:42:36),(2,课程名称2,upload/kecheng2.jpg,upload/video.mp4,upload/file.rar,1,3,496,363,3,课程详情2,2023-03-13 14:42:36),(3,课程名称3,upload/kecheng3.jpg,upload/video.mp4,upload/file.rar,1,2,165,439,3,课程详情3,2023-03-13 14:42:36),(4,课程名称4,upload/kecheng4.jpg,upload/video.mp4,upload/file.rar,1,1,304,479,1,课程详情4,2023-03-13 14:42:36),(5,课程名称5,upload/kecheng5.jpg,upload/video.mp4,upload/file.rar,2,2,433,332,1,课程详情5,2023-03-13 14:42:36),(6,课程名称6,upload/kecheng6.jpg,upload/video.mp4,upload/file.rar,2,2,236,500,2,课程详情6,2023-03-13 14:42:36),(7,课程名称7,upload/kecheng7.jpg,upload/video.mp4,upload/file.rar,2,2,165,113,3,课程详情7,2023-03-13 14:42:36),(8,课程名称8,upload/kecheng8.jpg,upload/video.mp4,upload/file.rar,2,2,181,252,3,课程详情8,2023-03-13 14:42:36),(9,课程名称9,upload/kecheng9.jpg,upload/video.mp4,upload/file.rar,2,2,158,371,1,课程详情9,2023-03-13 14:42:36),(10,课程名称10,upload/kecheng10.jpg,upload/video.mp4,upload/file.rar,2,2,145,270,1,课程详情10,2023-03-13 14:42:36),(11,课程名称11,upload/kecheng11.jpg,upload/video.mp4,upload/file.rar,1,1,297,129,2,课程详情11,2023-03-13 14:42:36),(12,课程名称12,upload/kecheng12.jpg,upload/video.mp4,upload/file.rar,3,1,426,205,1,课程详情12,2023-03-13 14:42:36),(13,课程名称13,upload/kecheng13.jpg,upload/video.mp4,upload/file.rar,3,3,414,45,2,课程详情13,2023-03-13 14:42:36),(14,课程名称14,upload/kecheng14.jpg,upload/video.mp4,upload/file.rar,3,1,258,7,3,p课程详情14/p,2023-03-13 14:42:36);/*Table structure for table kecheng_collection */DROP TABLE IF EXISTS kecheng_collection;CREATE TABLE kecheng_collection (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,kecheng_id int(11) DEFAULT NULL COMMENT 课程,yonghu_id int(11) DEFAULT NULL COMMENT 用户,kecheng_collection_types int(11) DEFAULT NULL COMMENT 类型,insert_time timestamp NULL DEFAULT NULL COMMENT 收藏时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show3 photoShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT18 DEFAULT CHARSETutf8 COMMENT课程收藏;/*Data for the table kecheng_collection */insert into kecheng_collection(id,kecheng_id,yonghu_id,kecheng_collection_types,insert_time,create_time) values (1,1,3,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(2,2,1,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(3,3,1,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(4,4,2,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(5,5,2,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(6,6,2,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(9,9,3,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(11,11,3,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(12,12,2,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(13,13,2,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(14,14,1,1,2023-03-13 14:42:36,2023-03-13 14:42:36),(15,10,1,2,2023-03-13 15:09:55,2023-03-13 15:09:55),(17,13,1,2,2023-03-13 15:10:43,2023-03-13 15:10:43);/*Table structure for table kecheng_liuyan */DROP TABLE IF EXISTS kecheng_liuyan;CREATE TABLE kecheng_liuyan (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,kecheng_id int(11) DEFAULT NULL COMMENT 课程,yonghu_id int(11) DEFAULT NULL COMMENT 用户,kecheng_liuyan_text text COMMENT 留言内容,insert_time timestamp NULL DEFAULT NULL COMMENT 留言时间,reply_text text COMMENT 回复内容,update_time timestamp NULL DEFAULT NULL COMMENT 回复时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT16 DEFAULT CHARSETutf8 COMMENT课程留言;/*Data for the table kecheng_liuyan */insert into kecheng_liuyan(id,kecheng_id,yonghu_id,kecheng_liuyan_text,insert_time,reply_text,update_time,create_time) values (1,1,2,留言内容1,2023-03-13 14:42:36,回复信息1,2023-03-13 14:42:36,2023-03-13 14:42:36),(2,2,2,留言内容2,2023-03-13 14:42:36,回复信息2,2023-03-13 14:42:36,2023-03-13 14:42:36),(3,3,3,留言内容3,2023-03-13 14:42:36,回复信息3,2023-03-13 14:42:36,2023-03-13 14:42:36),(4,4,3,留言内容4,2023-03-13 14:42:36,回复信息4,2023-03-13 14:42:36,2023-03-13 14:42:36),(5,5,3,留言内容5,2023-03-13 14:42:36,回复信息5,2023-03-13 14:42:36,2023-03-13 14:42:36),(6,6,2,留言内容6,2023-03-13 14:42:36,回复信息6,2023-03-13 14:42:36,2023-03-13 14:42:36),(7,7,3,留言内容7,2023-03-13 14:42:36,回复信息7,2023-03-13 14:42:36,2023-03-13 14:42:36),(8,8,1,留言内容8,2023-03-13 14:42:36,回复信息8,2023-03-13 14:42:36,2023-03-13 14:42:36),(9,9,1,留言内容9,2023-03-13 14:42:36,回复信息9,2023-03-13 14:42:36,2023-03-13 14:42:36),(10,10,3,留言内容10,2023-03-13 14:42:36,回复信息10,2023-03-13 14:42:36,2023-03-13 14:42:36),(11,11,3,留言内容11,2023-03-13 14:42:36,回复信息11,2023-03-13 14:42:36,2023-03-13 14:42:36),(12,12,1,留言内容12,2023-03-13 14:42:36,回复信息12,2023-03-13 14:42:36,2023-03-13 14:42:36),(13,13,1,留言内容13,2023-03-13 14:42:36,回复信息13,2023-03-13 14:42:36,2023-03-13 14:42:36),(14,14,1,留言内容14,2023-03-13 14:42:36,回复信息14111111,2023-03-13 15:11:24,2023-03-13 14:42:36);/*Table structure for table news */DROP TABLE IF EXISTS news;CREATE TABLE news (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,news_name varchar(200) DEFAULT NULL COMMENT 公告标题 Search111 ,news_types int(11) DEFAULT NULL COMMENT 公告类型 Search111 ,news_photo varchar(200) DEFAULT NULL COMMENT 公告图片,insert_time timestamp NULL DEFAULT NULL COMMENT 公告时间,news_content text COMMENT 公告详情,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show1 show2 nameShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT公告信息;/*Data for the table news */insert into news(id,news_name,news_types,news_photo,insert_time,news_content,create_time) values (1,公告标题1,1,upload/news1.jpg,2023-03-13 14:42:36,公告详情1,2023-03-13 14:42:36),(2,公告标题2,3,upload/news2.jpg,2023-03-13 14:42:36,公告详情2,2023-03-13 14:42:36),(3,公告标题3,2,upload/news3.jpg,2023-03-13 14:42:36,公告详情3,2023-03-13 14:42:36),(4,公告标题4,2,upload/news4.jpg,2023-03-13 14:42:36,公告详情4,2023-03-13 14:42:36),(5,公告标题5,1,upload/news5.jpg,2023-03-13 14:42:36,公告详情5,2023-03-13 14:42:36),(6,公告标题6,3,upload/news6.jpg,2023-03-13 14:42:36,公告详情6,2023-03-13 14:42:36),(7,公告标题7,2,upload/news7.jpg,2023-03-13 14:42:36,公告详情7,2023-03-13 14:42:36),(8,公告标题8,1,upload/news8.jpg,2023-03-13 14:42:36,公告详情8,2023-03-13 14:42:36),(9,公告标题9,1,upload/news9.jpg,2023-03-13 14:42:36,公告详情9,2023-03-13 14:42:36),(10,公告标题10,1,upload/news10.jpg,2023-03-13 14:42:36,公告详情10,2023-03-13 14:42:36),(11,公告标题11,3,upload/news11.jpg,2023-03-13 14:42:36,公告详情11,2023-03-13 14:42:36),(12,公告标题12,1,upload/news12.jpg,2023-03-13 14:42:36,公告详情12,2023-03-13 14:42:36),(13,公告标题13,1,upload/news13.jpg,2023-03-13 14:42:36,公告详情13,2023-03-13 14:42:36),(14,公告标题14,2,upload/news14.jpg,2023-03-13 14:42:36,公告详情14,2023-03-13 14:42:36);/*Table structure for table token */DROP TABLE IF EXISTS token;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)
) ENGINEInnoDB AUTO_INCREMENT7 DEFAULT CHARSETutf8 COMMENTtoken表;/*Data for the table token */insert into token(id,userid,username,tablename,role,token,addtime,expiratedtime) values (4,1,admin,users,管理员,zdruuwybjtxolo5enow04j719sptxfbu,2023-03-13 15:00:52,2023-03-13 16:14:22),(5,1,a1,yonghu,学生,0ql5t8o2gkm88mkabmz9i784edlt7fy8,2023-03-13 15:01:34,2023-03-13 16:09:52),(6,1,a1,jiaoshi,教师,cxuc5icct1eqlsyiy84yhoddd0uhstxu,2023-03-13 15:11:10,2023-03-13 16:11:11);/*Table structure for table users */DROP TABLE IF EXISTS users;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)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT用户表;/*Data for the table users */insert into users(id,username,password,role,addtime) values (1,admin,admin,管理员,2023-03-13 14:42:21);/*Table structure for table xueshengchengji */DROP TABLE IF EXISTS xueshengchengji;CREATE TABLE xueshengchengji (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,yonghu_id int(11) DEFAULT NULL COMMENT 学生,jiaoshi_id int(11) DEFAULT NULL COMMENT 教师,chengji int(11) DEFAULT NULL COMMENT 成绩,xueshengchengji_time date DEFAULT NULL COMMENT 时间,xueke_types int(11) DEFAULT NULL COMMENT 学科 Search111,xueshengchengji_content text COMMENT 成绩详情,insert_time timestamp NULL DEFAULT NULL COMMENT 添加时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show3 listShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT学生成绩;/*Data for the table xueshengchengji */insert into xueshengchengji(id,yonghu_id,jiaoshi_id,chengji,xueshengchengji_time,xueke_types,xueshengchengji_content,insert_time,create_time) values (1,2,2,269,2023-03-13,2,成绩详情1,2023-03-13 14:42:36,2023-03-13 14:42:36),(2,1,3,231,2023-03-13,1,成绩详情2,2023-03-13 14:42:36,2023-03-13 14:42:36),(3,3,1,63,2023-03-13,2,成绩详情3,2023-03-13 14:42:36,2023-03-13 14:42:36),(4,1,1,467,2023-03-13,3,成绩详情4,2023-03-13 14:42:36,2023-03-13 14:42:36),(5,1,2,330,2023-03-13,2,成绩详情5,2023-03-13 14:42:36,2023-03-13 14:42:36),(6,1,1,131,2023-03-13,1,成绩详情6,2023-03-13 14:42:36,2023-03-13 14:42:36),(7,3,2,361,2023-03-13,3,成绩详情7,2023-03-13 14:42:36,2023-03-13 14:42:36),(8,2,2,492,2023-03-13,3,成绩详情8,2023-03-13 14:42:36,2023-03-13 14:42:36),(9,1,2,25,2023-03-13,3,成绩详情9,2023-03-13 14:42:36,2023-03-13 14:42:36),(10,2,1,254,2023-03-13,1,成绩详情10,2023-03-13 14:42:36,2023-03-13 14:42:36),(11,1,1,495,2023-03-13,2,成绩详情11,2023-03-13 14:42:36,2023-03-13 14:42:36),(12,1,3,370,2023-03-13,1,成绩详情12,2023-03-13 14:42:36,2023-03-13 14:42:36),(13,3,3,357,2023-03-13,2,成绩详情13,2023-03-13 14:42:36,2023-03-13 14:42:36),(14,2,3,57,2023-03-13,1,成绩详情14,2023-03-13 14:42:36,2023-03-13 14:42:36);/*Table structure for table yonghu */DROP TABLE IF EXISTS yonghu;CREATE TABLE yonghu (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,yonghu_uuid_number varchar(200) DEFAULT NULL COMMENT 学号 Search111 ,username varchar(200) DEFAULT NULL COMMENT 账户,password varchar(200) DEFAULT NULL COMMENT 密码,yonghu_name varchar(200) DEFAULT NULL COMMENT 学生姓名 Search111 ,yonghu_photo varchar(255) DEFAULT NULL COMMENT 头像,sex_types int(11) DEFAULT NULL COMMENT 性别 Search111 ,yonghu_phone varchar(200) DEFAULT NULL COMMENT 联系方式,yonghu_id_number varchar(200) DEFAULT NULL COMMENT 学生身份证号 ,yonghu_email varchar(200) DEFAULT NULL COMMENT 邮箱,yonghu_delete int(11) DEFAULT 1 COMMENT 假删,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT学生;/*Data for the table yonghu */insert into yonghu(id,yonghu_uuid_number,username,password,yonghu_name,yonghu_photo,sex_types,yonghu_phone,yonghu_id_number,yonghu_email,yonghu_delete,create_time) values (1,1678689756363,a1,123456,学生姓名1,upload/yonghu1.jpg,2,17703786901,410224199010102001,1qq.com,1,2023-03-13 14:42:36),(2,1678689756341,a2,123456,学生姓名2,upload/yonghu2.jpg,1,17703786902,410224199010102002,2qq.com,1,2023-03-13 14:42:36),(3,1678689756384,a3,123456,学生姓名3,upload/yonghu3.jpg,2,17703786903,410224199010102003,3qq.com,1,2023-03-13 14:42:36);/*!40101 SET SQL_MODEOLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKSOLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKSOLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTESOLD_SQL_NOTES */;5、关键代码 5.1 课程资源管理Controller模块
/*** 课程资源* 后端接口* author 学长编程* email* WeChat jsjbysj88
*/
RestController
Controller
RequestMapping(/kecheng)
public class KechengController {private static final Logger logger LoggerFactory.getLogger(KechengController.class);private static final String TABLE_NAME kecheng;Autowiredprivate KechengService kechengService;Autowiredprivate TokenService tokenService;Autowiredprivate DictionaryService dictionaryService;//字典表Autowiredprivate FabujiaoanService fabujiaoanService;//教案信息Autowiredprivate ForumService forumService;//论坛Autowiredprivate JiaoshiService jiaoshiService;//教师Autowiredprivate KechengCollectionService kechengCollectionService;//课程收藏Autowiredprivate KechengLiuyanService kechengLiuyanService;//课程留言Autowiredprivate NewsService newsService;//公告信息Autowiredprivate XueshengchengjiService xueshengchengjiService;//学生成绩Autowiredprivate YonghuService yonghuService;//学生Autowiredprivate UsersService usersService;//用户表/*** 后端列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params, HttpServletRequest request){logger.debug(page方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));String role String.valueOf(request.getSession().getAttribute(role));if(false)return R.error(511,永不会进入);else if(学生.equals(role))params.put(yonghuId,request.getSession().getAttribute(userId));else if(教师.equals(role))params.put(jiaoshiId,request.getSession().getAttribute(userId));CommonUtil.checkMap(params);PageUtils page kechengService.queryPage(params);//字典表数据转换ListKechengView list (ListKechengView)page.getList();for(KechengView c:list){//修改对应字典表字段dictionaryService.dictionaryConvert(c, request);}return R.ok().put(data, page);}/*** 后端详情*/RequestMapping(/info/{id})public R info(PathVariable(id) Long id, HttpServletRequest request){logger.debug(info方法:,,Controller:{},,id:{},this.getClass().getName(),id);KechengEntity kecheng kechengService.selectById(id);if(kecheng !null){//entity转viewKechengView view new KechengView();BeanUtils.copyProperties( kecheng , view );//把实体数据重构到view中//级联表 教师//级联表JiaoshiEntity jiaoshi jiaoshiService.selectById(kecheng.getJiaoshiId());if(jiaoshi ! null){BeanUtils.copyProperties( jiaoshi , view ,new String[]{ id, createTime, insertTime, updateTime, jiaoshiId});//把级联的数据添加到view中,并排除id和创建时间字段,当前表的级联注册表view.setJiaoshiId(jiaoshi.getId());}//修改对应字典表字段dictionaryService.dictionaryConvert(view, request);return R.ok().put(data, view);}else {return R.error(511,查不到数据);}}/*** 后端保存*/RequestMapping(/save)public R save(RequestBody KechengEntity kecheng, HttpServletRequest request){logger.debug(save方法:,,Controller:{},,kecheng:{},this.getClass().getName(),kecheng.toString());String role String.valueOf(request.getSession().getAttribute(role));if(false)return R.error(511,永远不会进入);else if(教师.equals(role))kecheng.setJiaoshiId(Integer.valueOf(String.valueOf(request.getSession().getAttribute(userId))));WrapperKechengEntity queryWrapper new EntityWrapperKechengEntity().eq(kecheng_name, kecheng.getKechengName()).eq(kecheng_video, kecheng.getKechengVideo()).eq(xueke_types, kecheng.getXuekeTypes()).eq(jiaoshi_id, kecheng.getJiaoshiId()).eq(zan_number, kecheng.getZanNumber()).eq(cai_number, kecheng.getCaiNumber()).eq(kecheng_types, kecheng.getKechengTypes());logger.info(sql语句:queryWrapper.getSqlSegment());KechengEntity kechengEntity kechengService.selectOne(queryWrapper);if(kechengEntitynull){kecheng.setCreateTime(new Date());kechengService.insert(kecheng);return R.ok();}else {return R.error(511,表中有相同数据);}}/*** 后端修改*/RequestMapping(/update)public R update(RequestBody KechengEntity kecheng, HttpServletRequest request) throws NoSuchFieldException, ClassNotFoundException, IllegalAccessException, InstantiationException {logger.debug(update方法:,,Controller:{},,kecheng:{},this.getClass().getName(),kecheng.toString());KechengEntity oldKechengEntity kechengService.selectById(kecheng.getId());//查询原先数据String role String.valueOf(request.getSession().getAttribute(role));
// if(false)
// return R.error(511,永远不会进入);
// else if(教师.equals(role))
// kecheng.setJiaoshiId(Integer.valueOf(String.valueOf(request.getSession().getAttribute(userId))));if(.equals(kecheng.getKechengPhoto()) || null.equals(kecheng.getKechengPhoto())){kecheng.setKechengPhoto(null);}if(.equals(kecheng.getKechengVideo()) || null.equals(kecheng.getKechengVideo())){kecheng.setKechengVideo(null);}if(.equals(kecheng.getKechengFile()) || null.equals(kecheng.getKechengFile())){kecheng.setKechengFile(null);}kechengService.updateById(kecheng);//根据id更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Integer[] ids, HttpServletRequest request){logger.debug(delete:,,Controller:{},,ids:{},this.getClass().getName(),ids.toString());ListKechengEntity oldKechengList kechengService.selectBatchIds(Arrays.asList(ids));//要删除的数据kechengService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 批量上传*/RequestMapping(/batchInsert)public R save( String fileName, HttpServletRequest request){logger.debug(batchInsert方法:,,Controller:{},,fileName:{},this.getClass().getName(),fileName);Integer yonghuId Integer.valueOf(String.valueOf(request.getSession().getAttribute(userId)));SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd HH:mm:ss);try {ListKechengEntity kechengList new ArrayList();//上传的东西MapString, ListString seachFields new HashMap();//要查询的字段Date date new Date();int lastIndexOf fileName.lastIndexOf(.);if(lastIndexOf -1){return R.error(511,该文件没有后缀);}else{String suffix fileName.substring(lastIndexOf);if(!.xls.equals(suffix)){return R.error(511,只支持后缀为xls的excel文件);}else{URL resource this.getClass().getClassLoader().getResource(static/upload/ fileName);//获取文件路径File file new File(resource.getFile());if(!file.exists()){return R.error(511,找不到上传文件请联系管理员);}else{ListListString dataList PoiUtil.poiImport(file.getPath());//读取xls文件dataList.remove(0);//删除第一行因为第一行是提示for(ListString data:dataList){//循环KechengEntity kechengEntity new KechengEntity();
// kechengEntity.setKechengName(data.get(0)); //课程名称 要改的
// kechengEntity.setKechengPhoto();//详情和图片
// kechengEntity.setKechengVideo(data.get(0)); //课程视频 要改的
// kechengEntity.setKechengFile(data.get(0)); //课程文件 要改的
// kechengEntity.setXuekeTypes(Integer.valueOf(data.get(0))); //学科 要改的
// kechengEntity.setJiaoshiId(Integer.valueOf(data.get(0))); //教师 要改的
// kechengEntity.setZanNumber(Integer.valueOf(data.get(0))); //赞 要改的
// kechengEntity.setCaiNumber(Integer.valueOf(data.get(0))); //踩 要改的
// kechengEntity.setKechengTypes(Integer.valueOf(data.get(0))); //课程类型 要改的
// kechengEntity.setKechengContent();//详情和图片
// kechengEntity.setCreateTime(date);//时间kechengList.add(kechengEntity);//把要查询是否重复的字段放入map中}//查询是否重复kechengService.insertBatch(kechengList);return R.ok();}}}}catch (Exception e){e.printStackTrace();return R.error(511,批量插入数据异常请联系管理员);}}/*** 个性推荐*/IgnoreAuthRequestMapping(/gexingtuijian)public R gexingtuijian(RequestParam MapString, Object params, HttpServletRequest request){logger.debug(gexingtuijian方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));CommonUtil.checkMap(params);ListKechengView returnKechengViewList new ArrayList();//查看收藏MapString, Object params1 new HashMap(params);params1.put(sort,id);params1.put(yonghuId,request.getSession().getAttribute(userId));PageUtils pageUtils kechengCollectionService.queryPage(params1);ListKechengCollectionView collectionViewsList (ListKechengCollectionView)pageUtils.getList();MapInteger,Integer typeMapnew HashMap();//购买的类型listfor(KechengCollectionView collectionView:collectionViewsList){Integer kechengTypes collectionView.getKechengTypes();if(typeMap.containsKey(kechengTypes)){typeMap.put(kechengTypes,typeMap.get(kechengTypes)1);}else{typeMap.put(kechengTypes,1);}}ListInteger typeList new ArrayList();//排序后的有序的类型 按最多到最少typeMap.entrySet().stream().sorted((o1, o2) - o2.getValue() - o1.getValue()).forEach(e - typeList.add(e.getKey()));//排序Integer limit Integer.valueOf(String.valueOf(params.get(limit)));for(Integer type:typeList){MapString, Object params2 new HashMap(params);params2.put(kechengTypes,type);PageUtils pageUtils1 kechengService.queryPage(params2);ListKechengView kechengViewList (ListKechengView)pageUtils1.getList();returnKechengViewList.addAll(kechengViewList);if(returnKechengViewList.size() limit) break;//返回的推荐数量大于要的数量 跳出循环}//正常查询出来商品,用于补全推荐缺少的数据PageUtils page kechengService.queryPage(params);if(returnKechengViewList.size()limit){//返回数量还是小于要求数量int toAddNum limit - returnKechengViewList.size();//要添加的数量ListKechengView kechengViewList (ListKechengView)page.getList();for(KechengView kechengView:kechengViewList){Boolean addFlag true;for(KechengView returnKechengView:returnKechengViewList){if(returnKechengView.getId().intValue() kechengView.getId().intValue()) addFlagfalse;//返回的数据中已存在此商品}if(addFlag){toAddNumtoAddNum-1;returnKechengViewList.add(kechengView);if(toAddNum0) break;//够数量了}}}else {returnKechengViewList returnKechengViewList.subList(0, limit);}for(KechengView c:returnKechengViewList)dictionaryService.dictionaryConvert(c, request);page.setList(returnKechengViewList);return R.ok().put(data, page);}/*** 前端列表*/IgnoreAuthRequestMapping(/list)public R list(RequestParam MapString, Object params, HttpServletRequest request){logger.debug(list方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));CommonUtil.checkMap(params);PageUtils page kechengService.queryPage(params);//字典表数据转换ListKechengView list (ListKechengView)page.getList();for(KechengView c:list)dictionaryService.dictionaryConvert(c, request); //修改对应字典表字段return R.ok().put(data, page);}/*** 前端详情*/RequestMapping(/detail/{id})public R detail(PathVariable(id) Long id, HttpServletRequest request){logger.debug(detail方法:,,Controller:{},,id:{},this.getClass().getName(),id);KechengEntity kecheng kechengService.selectById(id);if(kecheng !null){//entity转viewKechengView view new KechengView();BeanUtils.copyProperties( kecheng , view );//把实体数据重构到view中//级联表JiaoshiEntity jiaoshi jiaoshiService.selectById(kecheng.getJiaoshiId());if(jiaoshi ! null){BeanUtils.copyProperties( jiaoshi , view ,new String[]{ id, createDate});//把级联的数据添加到view中,并排除id和创建时间字段view.setJiaoshiId(jiaoshi.getId());}//修改对应字典表字段dictionaryService.dictionaryConvert(view, request);return R.ok().put(data, view);}else {return R.error(511,查不到数据);}}/*** 前端保存*/RequestMapping(/add)public R add(RequestBody KechengEntity kecheng, HttpServletRequest request){logger.debug(add方法:,,Controller:{},,kecheng:{},this.getClass().getName(),kecheng.toString());WrapperKechengEntity queryWrapper new EntityWrapperKechengEntity().eq(kecheng_name, kecheng.getKechengName()).eq(kecheng_video, kecheng.getKechengVideo()).eq(xueke_types, kecheng.getXuekeTypes()).eq(jiaoshi_id, kecheng.getJiaoshiId()).eq(zan_number, kecheng.getZanNumber()).eq(cai_number, kecheng.getCaiNumber()).eq(kecheng_types, kecheng.getKechengTypes())
// .notIn(kecheng_types, new Integer[]{102});logger.info(sql语句:queryWrapper.getSqlSegment());KechengEntity kechengEntity kechengService.selectOne(queryWrapper);if(kechengEntitynull){kecheng.setCreateTime(new Date());kechengService.insert(kecheng);return R.ok();}else {return R.error(511,表中有相同数据);}}}5.2 课程资源管理Service模块
package com.service;import com.baomidou.mybatisplus.service.IService;
import com.utils.PageUtils;
import com.entity.KechengEntity;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.lang.Nullable;
import java.util.List;/*** 课程资源 服务类*/
public interface KechengService extends IServiceKechengEntity {/*** param params 查询参数* return 带分页的查询出来的数据*/PageUtils queryPage(MapString, Object params);}
5.3 课程资源管理ServiceImpl模块
package com.service.impl;import com.utils.StringUtil;
import com.service.DictionaryService;
import com.utils.ClazzDiff;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.lang.reflect.Field;
import java.util.*;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import org.springframework.transaction.annotation.Transactional;
import com.utils.PageUtils;
import com.utils.Query;
import org.springframework.web.context.ContextLoader;
import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import org.springframework.lang.Nullable;
import org.springframework.util.Assert;
import com.dao.KechengDao;
import com.entity.KechengEntity;
import com.service.KechengService;
import com.entity.view.KechengView;/*** 课程资源 服务实现类*/
Service(kechengService)
Transactional
public class KechengServiceImpl extends ServiceImplKechengDao, KechengEntity implements KechengService {Overridepublic PageUtils queryPage(MapString,Object params) {PageKechengView page new QueryKechengView(params).getPage();page.setRecords(baseMapper.selectListView(page,params));return new PageUtils(page);}}5.4 课程资源管理Dao模块
package com.dao;import com.entity.KechengEntity;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import java.util.List;
import java.util.Map;
import com.baomidou.mybatisplus.plugins.pagination.Pagination;import org.apache.ibatis.annotations.Param;
import com.entity.view.KechengView;/*** 课程资源 Dao 接口** author 学长编程* WeChat jsjbysj88
*/
public interface KechengDao extends BaseMapperKechengEntity {ListKechengView selectListView(Pagination page,Param(params)MapString,Object params);}6、论文目录结构 7、源码获取 感谢大家的阅读如有不懂的问题可以评论区交流或私聊! 喜欢文章可以点赞、收藏、关注、评论啦 →获取源码请私信←
