基于springboot的校园资料分享平台(mysql)-JAVA.VUE【数据库设计、论文、源码、开题报告】_springboot 项目 ppt 论文

功能介绍

用户端功能有：资料搜索、资料查看、资料下载、资料收藏、资料评价、资料上传分享、资料在线举报、公告浏览等

管理端功能有：学生管理、资源分类管理、资料管理、举报反馈管理、系统公告管理等

更多功能请看运行截图！

使用技术

开发语言：Java
使用框架：spring boot
前端技术：JavaScript、VUE.js（2.X）、css3
数据库：MySQL 5.7
数据库管理工具：Navicat或sqlyog
开发工具：IDEA或Eclipse均可

数据库脚本

/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - springboot2mc6m
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`springboot2mc6m` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `springboot2mc6m`;

/*Table structure for table `chat` */

DROP TABLE IF EXISTS `chat`;

CREATE TABLE `chat` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id',
  `ask` longtext COMMENT '提问',
  `reply` longtext COMMENT '回复',
  `isreply` int(11) DEFAULT NULL COMMENT '是否回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1618217193705 DEFAULT CHARSET=utf8 COMMENT='在线客服';

/*Data for the table `chat` */

insert  into `chat`(`id`,`addtime`,`userid`,`adminid`,`ask`,`reply`,`isreply`) values (51,'2021-04-10 16:23:46',1,1,'提问1','回复1',1),(52,'2021-04-10 16:23:46',2,2,'提问2','回复2',2),(53,'2021-04-10 16:23:46',3,3,'提问3','回复3',3),(54,'2021-04-10 16:23:46',4,4,'提问4','回复4',4),(55,'2021-04-10 16:23:46',5,5,'提问5','回复5',5),(56,'2021-04-10 16:23:46',6,6,'提问6','回复6',6),(1618217193704,'2021-04-12 16:46:33',11,NULL,'测试',NULL,1);

/*Table structure for table `config` */

DROP TABLE IF EXISTS `config`;

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=7 DEFAULT CHARSET=utf8 COMMENT='配置文件';

/*Data for the table `config` */

insert  into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/springboot2mc6m/upload/1618217049300.jpg'),(2,'picture2','http://localhost:8080/springboot2mc6m/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/springboot2mc6m/upload/picture3.jpg'),(6,'homepage',NULL);

/*Table structure for table `discussziliaofenxiang` */

DROP TABLE IF EXISTS `discussziliaofenxiang`;

CREATE TABLE `discussziliaofenxiang` (
  `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=1618217186174 DEFAULT CHARSET=utf8 COMMENT='资料分享评论表';

/*Data for the table `discussziliaofenxiang` */

insert  into `discussziliaofenxiang`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (81,'2021-04-10 16:23:46',1,1,'用户名1','评论内容1','回复内容1'),(82,'2021-04-10 16:23:46',2,2,'用户名2','评论内容2','回复内容2'),(83,'2021-04-10 16:23:46',3,3,'用户名3','评论内容3','回复内容3'),(84,'2021-04-10 16:23:46',4,4,'用户名4','评论内容4','回复内容4'),(85,'2021-04-10 16:23:46',5,5,'用户名5','评论内容5','回复内容5'),(86,'2021-04-10 16:23:46',6,6,'用户名6','评论内容6','回复内容6'),(1618217186173,'2021-04-12 16:46:25',21,11,'学生1','测试',NULL);

/*Table structure for table `jubaofankui` */

DROP TABLE IF EXISTS `jubaofankui`;

CREATE TABLE `jubaofankui` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ziliaomingcheng` varchar(200) DEFAULT NULL COMMENT '资料名称',
  `leibie` varchar(200) DEFAULT NULL COMMENT '类别',
  `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
  `jubaoyuanyin` longtext COMMENT '举报原因',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1618217271808 DEFAULT CHARSET=utf8 COMMENT='举报反馈';

/*Data for the table `jubaofankui` */

insert  into `jubaofankui`(`id`,`addtime`,`ziliaomingcheng`,`leibie`,`fengmian`,`jubaoyuanyin`,`sfsh`,`shhf`) values (41,'2021-04-10 16:23:46','资料名称1','类别1','http://localhost:8080/springboot2mc6m/upload/jubaofankui_fengmian1.jpg','举报原因1','是',''),(43,'2021-04-10 16:23:46','资料名称3','类别3','http://localhost:8080/springboot2mc6m/upload/jubaofankui_fengmian3.jpg','举报原因3','是',''),(44,'2021-04-10 16:23:46','资料名称4','类别4','http://localhost:8080/springboot2mc6m/upload/jubaofankui_fengmian4.jpg','举报原因4','是',''),(45,'2021-04-10 16:23:46','资料名称5','类别5','http://localhost:8080/springboot2mc6m/upload/jubaofankui_fengmian5.jpg','举报原因5','是',''),(46,'2021-04-10 16:23:46','资料名称6','类别6','http://localhost:8080/springboot2mc6m/upload/jubaofankui_fengmian6.jpg','举报原因6','是',''),(1618217271807,'2021-04-12 16:47:51','测试','课件','http://localhost:8080/springboot2mc6m/upload/1618217247983.jpg','<p>请输入举报原因</p>','是','测试');

/*Table structure for table `news` */

DROP TABLE IF EXISTS `news`;

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=77 DEFAULT CHARSET=utf8 COMMENT='公告资讯';

/*Data for the table `news` */

insert  into `news`(`id`,`addtime`,`title`,`introduction`,`picture`,`content`) values (71,'2021-04-10 16:23:46','标题1','简介1','http://localhost:8080/springboot2mc6m/upload/news_picture1.jpg','内容1'),(72,'2021-04-10 16:23:46','标题2','简介2','http://localhost:8080/springboot2mc6m/upload/news_picture2.jpg','内容2'),(73,'2021-04-10 16:23:46','测试','测试','http://localhost:8080/springboot2mc6m/upload/news_picture3.jpg','<h1>测试</h1>'),(74,'2021-04-10 16:23:46','标题4','简介4','http://localhost:8080/springboot2mc6m/upload/news_picture4.jpg','内容4'),(75,'2021-04-10 16:23:46','标题5','简介5','http://localhost:8080/springboot2mc6m/upload/news_picture5.jpg','内容5'),(76,'2021-04-10 16:23:46','标题6','简介6','http://localhost:8080/springboot2mc6m/upload/news_picture6.jpg','内容6');

/*Table structure for table `storeup` */

DROP TABLE IF EXISTS `storeup`;

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 '收藏图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1618217176683 DEFAULT CHARSET=utf8 COMMENT='收藏表';

/*Data for the table `storeup` */

insert  into `storeup`(`id`,`addtime`,`userid`,`refid`,`tablename`,`name`,`picture`) values (1618217176682,'2021-04-12 16:46:16',11,21,'ziliaofenxiang','资料名称1','http://localhost:8080/springboot2mc6m/upload/ziliaofenxiang_fengmian1.jpg');

/*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`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='token表';

/*Data for the table `token` */

insert  into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,11,'学生1','xuesheng','学生','sxykgeh0kywhffcjv7eshz3xbaheyvq5','2021-04-10 16:26:36','2021-04-12 17:45:21'),(2,1,'abo','users','管理员','u9xdd3xnjcs3wafufndgp0vg6mtr4e16','2021-04-10 16:27:46','2021-04-12 17:48:27');

/*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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

/*Data for the table `users` */

insert  into `users`(`id`,`username`,`password`,`role`,`addtime`) values (1,'abo','abo','管理员','2021-04-10 16:23:46');

/*Table structure for table `xuesheng` */

DROP TABLE IF EXISTS `xuesheng`;

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 '性别',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
  `zhuceshijian` date DEFAULT NULL COMMENT '注册时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=1618216849670 DEFAULT CHARSET=utf8 COMMENT='学生';

/*Data for the table `xuesheng` */

insert  into `xuesheng`(`id`,`addtime`,`xuehao`,`mima`,`xingming`,`xingbie`,`shouji`,`youxiang`,`zhaopian`,`zhuceshijian`) values (11,'2021-04-10 16:23:46','学生1','123456','姓名1','男','13823888881','773890001@qq.com','http://localhost:8080/springboot2mc6m/upload/xuesheng_zhaopian1.jpg','2021-04-23'),(12,'2021-04-10 16:23:46','学生2','123456','姓名2','男','13823888882','773890002@qq.com','http://localhost:8080/springboot2mc6m/upload/xuesheng_zhaopian2.jpg','2021-04-12'),(13,'2021-04-10 16:23:46','学生3','123456','姓名3','女','13823888883','773890003@qq.com','http://localhost:8080/springboot2mc6m/upload/xuesheng_zhaopian3.jpg','2021-04-10'),(14,'2021-04-10 16:23:46','学生4','123456','姓名4','男','13823888884','773890004@qq.com','http://localhost:8080/springboot2mc6m/upload/xuesheng_zhaopian4.jpg','2021-04-10'),(15,'2021-04-10 16:23:46','学生5','123456','姓名5','男','13823888885','773890005@qq.com','http://localhost:8080/springboot2mc6m/upload/xuesheng_zhaopian5.jpg','2021-04-10'),(16,'2021-04-10 16:23:46','学生6','123456','姓名6','男','13823888886','773890006@qq.com','http://localhost:8080/springboot2mc6m/upload/xuesheng_zhaopian6.jpg','2021-04-10'),(1618216673088,'2021-04-12 16:37:53','01','01','01','男','13800138000','01@qq.com','http://localhost:8080/springboot2mc6m/upload/1618216667860.jpg','2021-04-12'),(1618216849669,'2021-04-12 16:40:49','111','111','111','女','13800138111','111@qq.com','http://localhost:8080/springboot2mc6m/upload/1618216845928.png','2021-04-12');

/*Table structure for table `ziliaofenxiang` */

DROP TABLE IF EXISTS `ziliaofenxiang`;

CREATE TABLE `ziliaofenxiang` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ziliaomingcheng` varchar(200) DEFAULT NULL COMMENT '资料名称',
  `leibie` varchar(200) DEFAULT NULL COMMENT '类别',
  `wenjian` varchar(200) DEFAULT NULL COMMENT '文件',
  `ziliaojieshao` longtext COMMENT '资料介绍',
  `shangchuanshijian` datetime DEFAULT NULL COMMENT '上传时间',
  `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
  `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1618217250745 DEFAULT CHARSET=utf8 COMMENT='资料分享';

/*Data for the table `ziliaofenxiang` */

insert  into `ziliaofenxiang`(`id`,`addtime`,`ziliaomingcheng`,`leibie`,`wenjian`,`ziliaojieshao`,`shangchuanshijian`,`fengmian`,`xuehao`,`xingming`,`thumbsupnum`,`crazilynum`) values (21,'2021-04-10 16:23:46','资料名称1','类别1','http://localhost:8080/springboot2mc6m/upload/1618216741276.docx','<p>资料介绍1</p>','2021-04-10 16:23:46','http://localhost:8080/springboot2mc6m/upload/ziliaofenxiang_fengmian1.jpg','学生1','姓名1',2,1),(22,'2021-04-10 16:23:46','资料名称2','类别2','','<p>资料介绍2</p>','2021-04-10 16:23:46','http://localhost:8080/springboot2mc6m/upload/ziliaofenxiang_fengmian2.jpg','学生2','姓名2',2,2),(23,'2021-04-10 16:23:46','资料名称3','类别3','','资料介绍3','2021-04-10 16:23:46','http://localhost:8080/springboot2mc6m/upload/ziliaofenxiang_fengmian3.jpg','学号3','姓名3',3,3),(25,'2021-04-10 16:23:46','资料名称5','类别5','','资料介绍5','2021-04-10 16:23:46','http://localhost:8080/springboot2mc6m/upload/ziliaofenxiang_fengmian5.jpg','学号5','姓名5',5,5),(26,'2021-04-10 16:23:46','资料名称6','类别6','','资料介绍6','2021-04-10 16:23:46','http://localhost:8080/springboot2mc6m/upload/ziliaofenxiang_fengmian6.jpg','学号6','姓名6',6,6),(1618217250744,'2021-04-12 16:47:29','测试','课件','http://localhost:8080/springboot2mc6m/upload/1618217222958.docx','<p>测试</p>','2021-04-12 16:46:44','http://localhost:8080/springboot2mc6m/upload/1618217247983.jpg','学生1','姓名1',0,0);

/*Table structure for table `ziyuanfenlei` */

DROP TABLE IF EXISTS `ziyuanfenlei`;

CREATE TABLE `ziyuanfenlei` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `fenlei` varchar(200) DEFAULT NULL COMMENT '分类',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1618216982269 DEFAULT CHARSET=utf8 COMMENT='资源分类';

/*Data for the table `ziyuanfenlei` */

insert  into `ziyuanfenlei`(`id`,`addtime`,`fenlei`) values (31,'2021-04-10 16:23:46','课件'),(32,'2021-04-10 16:23:46','学习资料'),(33,'2021-04-10 16:23:46','报告'),(34,'2021-04-10 16:23:46','软件安装包'),(1618216982268,'2021-04-12 16:43:02','习题');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;





1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238

项目截图