基于Java+SpringBoot+Vue摄影分享网站的设计与实现前后端分离【Java毕业设计·文档报告·代码讲解·安装调试】

🍊作者：计算机编程-吉哥
🍊简介：专业从事JavaWeb程序开发，微信小程序开发，定制化项目、源码、代码讲解、文档撰写、ppt制作。做自己喜欢的事，生活就是快乐的。
🍊心愿：点赞 👍 收藏 ⭐评论 📝
🍅 文末获取源码联系

👇🏻 精彩专栏推荐订阅 👇🏻 不然下次找不到哟~
Java毕业设计项目~热门选题推荐《1000套》

技术选型

springboot、mybatisplus、vue、elementui、html、css、js、mysql、jdk1.8

数据库表结构

18张

开发工具

idea、navicat

⭐功能

【角色】

管理员、用户

【前台功能模块】

登录注册
首页
论坛
活动
公告资讯
图片素材
视频素材
个人中心

【后台功能模块】

登录
首页
个人中心
管理员管理
用户管理
图片素材管理
视频素材管理
活动管理
活动报名管理
基础数据管理
论坛管理
公告资讯管理
轮播图信息

🏆项目演示截图

1、前台-登录

2、前台-首页

3、前台-视频素材

4、前台-论坛

5、前台-帖子发布

6、前台-活动报名

7、前台-公告资讯

8、前台-图片素材

9、后台-登录

10、后台-用户管理

11、后台-图片素材管理

12、后台-视频素材管理

13、后台-活动报名管理

数据库文件设计


 
CREATE DATABASE /*!32312 IF NOT EXISTS*/`youguangsheyingwz` /*!40100 DEFAULT CHARACTER SET utf8 */;
 
USE `youguangsheyingwz`;
 
/*Table structure for table `config` */
 
DROP TABLE IF EXISTS `config`;
 
CREATE TABLE `config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) DEFAULT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 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` bigint(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`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 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,'sucaishipin_types','视频素材类型',1,'视频素材类型1',NULL,NULL,'2023-03-31 09:43:42'),(2,'sucaishipin_types','视频素材类型',2,'视频素材类型2',NULL,NULL,'2023-03-31 09:43:42'),(3,'sucaishipin_types','视频素材类型',3,'视频素材类型3',NULL,NULL,'2023-03-31 09:43:42'),(4,'sucaishipin_collection_types','收藏表类型',1,'收藏',NULL,NULL,'2023-03-31 09:43:42'),(5,'sucaishipin_collection_types','收藏表类型',2,'赞',NULL,NULL,'2023-03-31 09:43:42'),(6,'sucaishipin_collection_types','收藏表类型',3,'踩',NULL,NULL,'2023-03-31 09:43:42'),(7,'sucai_types','图片素材类型',1,'图片素材类型1',NULL,NULL,'2023-03-31 09:43:42'),(8,'sucai_types','图片素材类型',2,'图片素材类型2',NULL,NULL,'2023-03-31 09:43:42'),(9,'sucai_types','图片素材类型',3,'图片素材类型3',NULL,NULL,'2023-03-31 09:43:42'),(10,'sucai_collection_types','收藏表类型',1,'收藏',NULL,NULL,'2023-03-31 09:43:42'),(11,'sucai_collection_types','收藏表类型',2,'赞',NULL,NULL,'2023-03-31 09:43:42'),(12,'sucai_collection_types','收藏表类型',3,'踩',NULL,NULL,'2023-03-31 09:43:42'),(13,'huodong_types','活动类型',1,'活动类型1',NULL,NULL,'2023-03-31 09:43:42'),(14,'huodong_types','活动类型',2,'活动类型2',NULL,NULL,'2023-03-31 09:43:42'),(15,'huodong_types','活动类型',3,'活动类型3',NULL,NULL,'2023-03-31 09:43:42'),(16,'huodong_collection_types','收藏表类型',1,'收藏',NULL,NULL,'2023-03-31 09:43:42'),(17,'huodong_collection_types','收藏表类型',2,'赞',NULL,NULL,'2023-03-31 09:43:42'),(18,'huodong_collection_types','收藏表类型',3,'踩',NULL,NULL,'2023-03-31 09:43:42'),(19,'huodong_yuyue_yesno_types','报名状态',1,'待审核',NULL,NULL,'2023-03-31 09:43:42'),(20,'huodong_yuyue_yesno_types','报名状态',2,'同意',NULL,NULL,'2023-03-31 09:43:42'),(21,'huodong_yuyue_yesno_types','报名状态',3,'拒绝',NULL,NULL,'2023-03-31 09:43:42'),(22,'news_types','公告类型',1,'公告类型1',NULL,NULL,'2023-03-31 09:43:42'),(23,'news_types','公告类型',2,'公告类型2',NULL,NULL,'2023-03-31 09:43:42'),(24,'news_types','公告类型',3,'公告类型3',NULL,NULL,'2023-03-31 09:43:42'),(25,'sex_types','性别类型',1,'男',NULL,NULL,'2023-03-31 09:43:42'),(26,'sex_types','性别类型',2,'女',NULL,NULL,'2023-03-31 09:43:43'),(27,'forum_state_types','帖子状态',1,'发帖',NULL,NULL,'2023-03-31 09:43:43'),(28,'forum_state_types','帖子状态',2,'回帖',NULL,NULL,'2023-03-31 09:43:43');
 
/*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 '用户',
  `users_id` int(11) DEFAULT NULL COMMENT '管理员',
  `forum_content` longtext 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`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='论坛';
 
/*Data for the table `forum` */
 
insert  into `forum`(`id`,`forum_name`,`yonghu_id`,`users_id`,`forum_content`,`super_ids`,`forum_state_types`,`insert_time`,`update_time`,`create_time`) values (1,'帖子标题1',1,NULL,'发布内容1',45,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,'帖子标题2',3,NULL,'发布内容2',8,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,'帖子标题3',1,NULL,'发布内容3',171,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,'帖子标题4',2,NULL,'发布内容4',122,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,'帖子标题5',2,NULL,'发布内容5',410,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,'帖子标题6',3,NULL,'发布内容6',31,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,'帖子标题7',2,NULL,'发布内容7',106,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,'帖子标题8',2,NULL,'发布内容8',401,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,'帖子标题9',2,NULL,'发布内容9',167,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,'帖子标题10',1,NULL,'发布内容10',448,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,'帖子标题11',1,NULL,'发布内容11',70,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,'帖子标题12',1,NULL,'发布内容12',13,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,'帖子标题13',3,NULL,'发布内容13',63,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,'帖子标题14',2,NULL,'发布内容14',98,1,'2023-03-31 09:47:09','2023-03-31 09:47:09','2023-03-31 09:47:09'),(15,NULL,1,NULL,'登录后才可以查看数据详情页 和留言收藏点赞等操作',14,2,'2023-03-31 10:06:29',NULL,'2023-03-31 10:06:29'),(16,NULL,NULL,1,'222222222222222222222',14,2,'2023-03-31 10:09:12',NULL,'2023-03-31 10:09:12');
 
/*Table structure for table `huodong` */
 
DROP TABLE IF EXISTS `huodong`;
 
CREATE TABLE `huodong` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
  `huodong_uuid_number` varchar(200) DEFAULT NULL COMMENT '活动编号',
  `huodong_name` varchar(200) DEFAULT NULL COMMENT '活动标题  Search111 ',
  `huodong_photo` varchar(200) DEFAULT NULL COMMENT '活动封面',
  `huodong_types` int(11) DEFAULT NULL COMMENT '活动类型 Search111',
  `huodong_clicknum` int(11) DEFAULT NULL COMMENT '活动热度',
  `zan_number` int(11) DEFAULT NULL COMMENT '赞',
  `cai_number` int(11) DEFAULT NULL COMMENT '踩',
  `huodong_content` longtext COMMENT '活动介绍 ',
  `huodong_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '录入时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show1 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='活动';
 
/*Data for the table `huodong` */
 
insert  into `huodong`(`id`,`huodong_uuid_number`,`huodong_name`,`huodong_photo`,`huodong_types`,`huodong_clicknum`,`zan_number`,`cai_number`,`huodong_content`,`huodong_delete`,`insert_time`,`create_time`) values (1,'1680227229952','活动标题1','upload/huodong1.jpg',3,166,257,471,'活动介绍1',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,'1680227229991','活动标题2','upload/huodong2.jpg',2,382,95,252,'活动介绍2',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,'1680227229911','活动标题3','upload/huodong3.jpg',2,414,359,167,'活动介绍3',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,'1680227229939','活动标题4','upload/huodong4.jpg',3,370,167,135,'活动介绍4',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,'1680227229940','活动标题5','upload/huodong5.jpg',1,336,41,318,'活动介绍5',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,'1680227229983','活动标题6','upload/huodong6.jpg',3,26,499,348,'活动介绍6',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,'1680227229997','活动标题7','upload/huodong7.jpg',2,413,87,421,'活动介绍7',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,'1680227229983','活动标题8','upload/huodong8.jpg',2,208,31,338,'活动介绍8',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,'1680227229954','活动标题9','upload/huodong9.jpg',1,324,242,177,'活动介绍9',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,'1680227229956','活动标题10','upload/huodong10.jpg',3,412,302,300,'活动介绍10',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,'1680227229925','活动标题11','upload/huodong11.jpg',3,54,84,33,'活动介绍11',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,'1680227229947','活动标题12','upload/huodong12.jpg',3,233,261,93,'活动介绍12',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,'1680227229918','活动标题13','upload/huodong13.jpg',1,67,21,88,'活动介绍13',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,'1680227229989','活动标题14','upload/huodong14.jpg',2,432,40,416,'活动介绍14',1,'2023-03-31 09:47:09','2023-03-31 09:47:09');
 
/*Table structure for table `huodong_collection` */
 
DROP TABLE IF EXISTS `huodong_collection`;
 
CREATE TABLE `huodong_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `huodong_id` int(11) DEFAULT NULL COMMENT '活动',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `huodong_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`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='活动收藏';
 
/*Data for the table `huodong_collection` */
 
insert  into `huodong_collection`(`id`,`huodong_id`,`yonghu_id`,`huodong_collection_types`,`insert_time`,`create_time`) values (1,1,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,2,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,3,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,4,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,5,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,7,1,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,8,1,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,9,1,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,10,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,11,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,12,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,13,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,14,1,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(15,14,1,3,'2023-03-31 10:06:50','2023-03-31 10:06:50');
 
/*Table structure for table `huodong_liuyan` */
 
DROP TABLE IF EXISTS `huodong_liuyan`;
 
CREATE TABLE `huodong_liuyan` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `huodong_id` int(11) DEFAULT NULL COMMENT '活动',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `huodong_liuyan_text` longtext COMMENT '留言内容',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '留言时间',
  `reply_text` longtext COMMENT '回复内容',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='活动留言';
 
/*Data for the table `huodong_liuyan` */
 
insert  into `huodong_liuyan`(`id`,`huodong_id`,`yonghu_id`,`huodong_liuyan_text`,`insert_time`,`reply_text`,`update_time`,`create_time`) values (1,1,3,'留言内容1','2023-03-31 09:47:09','回复信息1','2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,2,1,'留言内容2','2023-03-31 09:47:09','回复信息2','2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,3,1,'留言内容3','2023-03-31 09:47:09','回复信息3','2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,4,2,'留言内容4','2023-03-31 09:47:09','回复信息4','2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,5,3,'留言内容5','2023-03-31 09:47:09','回复信息5','2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,6,1,'留言内容6','2023-03-31 09:47:09','回复信息6','2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,7,2,'留言内容7','2023-03-31 09:47:09','回复信息7','2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,8,3,'留言内容8','2023-03-31 09:47:09','回复信息8','2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,9,3,'留言内容9','2023-03-31 09:47:09','回复信息9','2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,10,1,'留言内容10','2023-03-31 09:47:09','回复信息10','2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,11,2,'留言内容11','2023-03-31 09:47:09','回复信息11','2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,12,2,'留言内容12','2023-03-31 09:47:09','回复信息12','2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,13,3,'留言内容13','2023-03-31 09:47:09','回复信息13','2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,14,3,'留言内容14','2023-03-31 09:47:09','回复信息14','2023-03-31 09:47:09','2023-03-31 09:47:09');
 
/*Table structure for table `huodong_yuyue` */
 
DROP TABLE IF EXISTS `huodong_yuyue`;
 
CREATE TABLE `huodong_yuyue` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `huodong_yuyue_uuid_number` varchar(200) DEFAULT NULL COMMENT '报名编号 Search111 ',
  `huodong_id` int(11) DEFAULT NULL COMMENT '活动',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `huodong_yuyue_text` longtext COMMENT '报名理由',
  `huodong_yuyue_yesno_types` int(11) DEFAULT NULL COMMENT '报名状态 Search111 ',
  `huodong_yuyue_yesno_text` longtext COMMENT '审核回复',
  `huodong_yuyue_shenhe_time` timestamp NULL DEFAULT NULL COMMENT '审核时间',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '报名时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='活动报名';
 
/*Data for the table `huodong_yuyue` */
 
insert  into `huodong_yuyue`(`id`,`huodong_yuyue_uuid_number`,`huodong_id`,`yonghu_id`,`huodong_yuyue_text`,`huodong_yuyue_yesno_types`,`huodong_yuyue_yesno_text`,`huodong_yuyue_shenhe_time`,`insert_time`,`create_time`) values (1,'1680227229976',1,1,'报名理由1',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,'1680227229978',2,3,'报名理由2',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,'1680227229970',3,1,'报名理由3',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,'1680227229975',4,2,'报名理由4',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,'1680227229994',5,2,'报名理由5',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,'1680227229957',6,3,'报名理由6',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,'1680227229982',7,3,'报名理由7',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,'1680227229967',8,1,'报名理由8',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,'1680227229992',9,1,'报名理由9',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,'1680227229979',10,2,'报名理由10',1,NULL,NULL,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,'1680227229940',11,3,'报名理由11',3,'2','2023-03-31 10:02:49','2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,'1680227229990',12,1,'报名理由12',3,'2','2023-03-31 10:02:42','2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,'1680227229941',13,1,'报名理由13',2,'1','2023-03-31 10:02:38','2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,'1680227229928',14,1,'报名理由14',2,'123','2023-03-31 10:02:33','2023-03-31 09:47:09','2023-03-31 09:47:09'),(15,'1680228402624',2,1,'1111111',2,'同意111111','2023-03-31 10:08:57','2023-03-31 10:06:43','2023-03-31 10:06:43');
 
/*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` longtext COMMENT '公告详情',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 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',3,'upload/news1.jpg','2023-03-31 09:47:09','公告详情1','2023-03-31 09:47:09'),(2,'公告标题2',3,'upload/news2.jpg','2023-03-31 09:47:09','公告详情2','2023-03-31 09:47:09'),(3,'公告标题3',2,'upload/news3.jpg','2023-03-31 09:47:09','公告详情3','2023-03-31 09:47:09'),(4,'公告标题4',1,'upload/news4.jpg','2023-03-31 09:47:09','公告详情4','2023-03-31 09:47:09'),(5,'公告标题5',2,'upload/news5.jpg','2023-03-31 09:47:09','公告详情5','2023-03-31 09:47:09'),(6,'公告标题6',3,'upload/news6.jpg','2023-03-31 09:47:09','公告详情6','2023-03-31 09:47:09'),(7,'公告标题7',1,'upload/news7.jpg','2023-03-31 09:47:09','公告详情7','2023-03-31 09:47:09'),(8,'公告标题8',1,'upload/news8.jpg','2023-03-31 09:47:09','公告详情8','2023-03-31 09:47:09'),(9,'公告标题9',2,'upload/news9.jpg','2023-03-31 09:47:09','公告详情9','2023-03-31 09:47:09'),(10,'公告标题10',2,'upload/news10.jpg','2023-03-31 09:47:09','公告详情10','2023-03-31 09:47:09'),(11,'公告标题11',1,'upload/news11.jpg','2023-03-31 09:47:09','公告详情11','2023-03-31 09:47:09'),(12,'公告标题12',2,'upload/news12.jpg','2023-03-31 09:47:09','公告详情12','2023-03-31 09:47:09'),(13,'公告标题13',1,'upload/news13.jpg','2023-03-31 09:47:09','公告详情13','2023-03-31 09:47:09'),(14,'公告标题14',1,'upload/news14.jpg','2023-03-31 09:47:09','公告详情14','2023-03-31 09:47:09');
 
/*Table structure for table `sucai` */
 
DROP TABLE IF EXISTS `sucai`;
 
CREATE TABLE `sucai` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
  `sucai_uuid_number` varchar(200) DEFAULT NULL COMMENT '图片素材编号',
  `sucai_name` varchar(200) DEFAULT NULL COMMENT '图片素材名称  Search111 ',
  `sucai_photo` varchar(200) DEFAULT NULL COMMENT '图片素材照片',
  `sucai_file` varchar(200) DEFAULT NULL COMMENT '图片素材',
  `sucai_types` int(11) DEFAULT NULL COMMENT '图片素材类型 Search111',
  `sucai_clicknum` int(11) DEFAULT NULL COMMENT '图片素材热度',
  `zan_number` int(11) DEFAULT NULL COMMENT '赞',
  `cai_number` int(11) DEFAULT NULL COMMENT '踩',
  `sucai_content` longtext COMMENT '图片素材介绍 ',
  `sucai_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '录入时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show1 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='图片素材';
 
/*Data for the table `sucai` */
 
insert  into `sucai`(`id`,`sucai_uuid_number`,`sucai_name`,`sucai_photo`,`sucai_file`,`sucai_types`,`sucai_clicknum`,`zan_number`,`cai_number`,`sucai_content`,`sucai_delete`,`insert_time`,`create_time`) values (1,'1680227229999','图片素材名称1','upload/sucai1.jpg','upload/file.rar',1,141,376,470,'图片素材介绍1',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,'1680227229928','图片素材名称2','upload/sucai2.jpg','upload/file.rar',2,374,81,487,'图片素材介绍2',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,'1680227229962','图片素材名称3','upload/sucai3.jpg','upload/file.rar',1,485,275,24,'图片素材介绍3',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,'1680227230008','图片素材名称4','upload/sucai4.jpg','upload/file.rar',2,321,233,42,'图片素材介绍4',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,'1680227229933','图片素材名称5','upload/sucai5.jpg','upload/file.rar',2,383,170,207,'图片素材介绍5',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,'1680227229945','图片素材名称6','upload/sucai6.jpg','upload/file.rar',3,464,102,248,'图片素材介绍6',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,'1680227229969','图片素材名称7','upload/sucai7.jpg','upload/file.rar',3,336,425,123,'图片素材介绍7',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,'1680227229961','图片素材名称8','upload/sucai8.jpg','upload/file.rar',3,389,315,461,'图片素材介绍8',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,'1680227230000','图片素材名称9','upload/sucai9.jpg','upload/file.rar',3,24,158,300,'图片素材介绍9',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,'1680227229998','图片素材名称10','upload/sucai10.jpg','upload/file.rar',2,372,40,414,'图片素材介绍10',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,'1680227229949','图片素材名称11','upload/sucai11.jpg','upload/file.rar',2,393,203,261,'图片素材介绍11',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,'1680227229987','图片素材名称12','upload/sucai12.jpg','upload/file.rar',1,239,292,495,'图片素材介绍12',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,'1680227230004','图片素材名称13','upload/sucai13.jpg','upload/file.rar',3,254,38,86,'图片素材介绍13',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,'1680227229995','图片素材名称14','upload/sucai14.jpg','upload/file.rar',3,5,188,493,'图片素材介绍14',1,'2023-03-31 09:47:09','2023-03-31 09:47:09');
 
/*Table structure for table `sucai_collection` */
 
DROP TABLE IF EXISTS `sucai_collection`;
 
CREATE TABLE `sucai_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `sucai_id` int(11) DEFAULT NULL COMMENT '图片素材',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `sucai_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`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='图片素材收藏';
 
/*Data for the table `sucai_collection` */
 
insert  into `sucai_collection`(`id`,`sucai_id`,`yonghu_id`,`sucai_collection_types`,`insert_time`,`create_time`) values (1,1,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,2,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,3,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,4,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,5,1,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,6,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,8,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,9,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,10,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,11,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,12,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,13,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,14,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(15,11,1,2,'2023-03-31 10:07:13','2023-03-31 10:07:13');
 
/*Table structure for table `sucai_liuyan` */
 
DROP TABLE IF EXISTS `sucai_liuyan`;
 
CREATE TABLE `sucai_liuyan` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `sucai_id` int(11) DEFAULT NULL COMMENT '图片素材',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `sucai_liuyan_text` longtext COMMENT '留言内容',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '留言时间',
  `reply_text` longtext COMMENT '回复内容',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='图片素材留言';
 
/*Data for the table `sucai_liuyan` */
 
insert  into `sucai_liuyan`(`id`,`sucai_id`,`yonghu_id`,`sucai_liuyan_text`,`insert_time`,`reply_text`,`update_time`,`create_time`) values (1,1,1,'留言内容1','2023-03-31 09:47:09','回复信息1','2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,2,1,'留言内容2','2023-03-31 09:47:09','回复信息2','2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,3,3,'留言内容3','2023-03-31 09:47:09','回复信息3','2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,4,2,'留言内容4','2023-03-31 09:47:09','回复信息4','2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,5,1,'留言内容5','2023-03-31 09:47:09','回复信息5','2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,6,2,'留言内容6','2023-03-31 09:47:09','回复信息6','2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,7,3,'留言内容7','2023-03-31 09:47:09','回复信息7','2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,8,2,'留言内容8','2023-03-31 09:47:09','回复信息8','2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,9,3,'留言内容9','2023-03-31 09:47:09','回复信息9','2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,10,2,'留言内容10','2023-03-31 09:47:09','回复信息10','2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,11,2,'留言内容11','2023-03-31 09:47:09','回复信息11','2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,12,1,'留言内容12','2023-03-31 09:47:09','回复信息12','2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,13,3,'留言内容13','2023-03-31 09:47:09','回复信息13','2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,14,3,'留言内容14','2023-03-31 09:47:09','回复信息14','2023-03-31 09:47:09','2023-03-31 09:47:09'),(15,11,1,'留言11111','2023-03-31 10:07:19','回复内容11111','2023-03-31 10:08:15','2023-03-31 10:07:19');
 
/*Table structure for table `sucaishipin` */
 
DROP TABLE IF EXISTS `sucaishipin`;
 
CREATE TABLE `sucaishipin` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
  `sucaishipin_uuid_number` varchar(200) DEFAULT NULL COMMENT '视频素材编号',
  `sucaishipin_name` varchar(200) DEFAULT NULL COMMENT '视频素材名称  Search111 ',
  `sucaishipin_photo` varchar(200) DEFAULT NULL COMMENT '视频素材封面',
  `sucaishipin_video` varchar(200) DEFAULT NULL COMMENT '视频',
  `sucaishipin_file` varchar(200) DEFAULT NULL COMMENT '视频素材',
  `sucaishipin_types` int(11) DEFAULT NULL COMMENT '视频素材类型 Search111',
  `sucaishipin_clicknum` int(11) DEFAULT NULL COMMENT '视频素材热度',
  `zan_number` int(11) DEFAULT NULL COMMENT '赞',
  `cai_number` int(11) DEFAULT NULL COMMENT '踩',
  `sucaishipin_content` longtext COMMENT '视频素材介绍 ',
  `sucaishipin_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '录入时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show1 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='视频素材';
 
/*Data for the table `sucaishipin` */
 
insert  into `sucaishipin`(`id`,`sucaishipin_uuid_number`,`sucaishipin_name`,`sucaishipin_photo`,`sucaishipin_video`,`sucaishipin_file`,`sucaishipin_types`,`sucaishipin_clicknum`,`zan_number`,`cai_number`,`sucaishipin_content`,`sucaishipin_delete`,`insert_time`,`create_time`) values (1,'1680227229972','视频素材名称1','upload/sucaishipin1.jpg','upload/video.mp4','upload/file.rar',1,179,156,56,'视频素材介绍1',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,'1680227230009','视频素材名称2','upload/sucaishipin2.jpg','upload/video.mp4','upload/file.rar',3,31,366,300,'视频素材介绍2',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,'1680227230023','视频素材名称3','upload/sucaishipin3.jpg','upload/video.mp4','upload/file.rar',3,77,254,90,'视频素材介绍3',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,'1680227229980','视频素材名称4','upload/sucaishipin4.jpg','upload/video.mp4','upload/file.rar',3,223,109,417,'视频素材介绍4',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,'1680227229955','视频素材名称5','upload/sucaishipin5.jpg','upload/video.mp4','upload/file.rar',3,187,309,110,'视频素材介绍5',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,'1680227229967','视频素材名称6','upload/sucaishipin6.jpg','upload/video.mp4','upload/file.rar',2,54,3,100,'视频素材介绍6',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,'1680227229939','视频素材名称7','upload/sucaishipin7.jpg','upload/video.mp4','upload/file.rar',3,290,124,381,'视频素材介绍7',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,'1680227229946','视频素材名称8','upload/sucaishipin8.jpg','upload/video.mp4','upload/file.rar',2,456,253,123,'视频素材介绍8',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,'1680227229957','视频素材名称9','upload/sucaishipin9.jpg','upload/video.mp4','upload/file.rar',1,15,455,290,'视频素材介绍9',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,'1680227229979','视频素材名称10','upload/sucaishipin10.jpg','upload/video.mp4','upload/file.rar',3,470,345,27,'视频素材介绍10',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,'1680227229981','视频素材名称11','upload/sucaishipin11.jpg','upload/video.mp4','upload/file.rar',2,352,99,394,'视频素材介绍11',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,'1680227230024','视频素材名称12','upload/sucaishipin12.jpg','upload/video.mp4','upload/file.rar',3,320,29,480,'视频素材介绍12',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,'1680227229972','视频素材名称13','upload/sucaishipin13.jpg','upload/video.mp4','upload/file.rar',1,66,170,168,'视频素材介绍13',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,'1680227229966','视频素材名称14','upload/sucaishipin14.jpg','upload/video.mp4','upload/file.rar',2,272,405,182,'视频素材介绍14',1,'2023-03-31 09:47:09','2023-03-31 09:47:09');
 
/*Table structure for table `sucaishipin_collection` */
 
DROP TABLE IF EXISTS `sucaishipin_collection`;
 
CREATE TABLE `sucaishipin_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `sucaishipin_id` int(11) DEFAULT NULL COMMENT '视频素材',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `sucaishipin_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`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='视频素材收藏';
 
/*Data for the table `sucaishipin_collection` */
 
insert  into `sucaishipin_collection`(`id`,`sucaishipin_id`,`yonghu_id`,`sucaishipin_collection_types`,`insert_time`,`create_time`) values (1,1,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,2,1,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,3,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,4,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,5,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,6,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,7,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,8,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,9,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,10,1,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,11,3,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,12,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,13,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,14,2,1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(15,3,1,2,'2023-03-31 10:05:35','2023-03-31 10:05:35'),(16,7,1,1,'2023-03-31 10:05:55','2023-03-31 10:05:55'),(17,7,1,2,'2023-03-31 10:05:58','2023-03-31 10:05:58');
 
/*Table structure for table `sucaishipin_liuyan` */
 
DROP TABLE IF EXISTS `sucaishipin_liuyan`;
 
CREATE TABLE `sucaishipin_liuyan` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `sucaishipin_id` int(11) DEFAULT NULL COMMENT '视频素材',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `sucaishipin_liuyan_text` longtext COMMENT '留言内容',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '留言时间',
  `reply_text` longtext COMMENT '回复内容',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='视频素材留言';
 
/*Data for the table `sucaishipin_liuyan` */
 
insert  into `sucaishipin_liuyan`(`id`,`sucaishipin_id`,`yonghu_id`,`sucaishipin_liuyan_text`,`insert_time`,`reply_text`,`update_time`,`create_time`) values (1,1,2,'留言内容1','2023-03-31 09:47:09','回复信息1','2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,2,2,'留言内容2','2023-03-31 09:47:09','回复信息2','2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,3,1,'留言内容3','2023-03-31 09:47:09','回复信息3','2023-03-31 09:47:09','2023-03-31 09:47:09'),(4,4,2,'留言内容4','2023-03-31 09:47:09','回复信息4','2023-03-31 09:47:09','2023-03-31 09:47:09'),(5,5,3,'留言内容5','2023-03-31 09:47:09','回复信息5','2023-03-31 09:47:09','2023-03-31 09:47:09'),(6,6,3,'留言内容6','2023-03-31 09:47:09','回复信息6','2023-03-31 09:47:09','2023-03-31 09:47:09'),(7,7,3,'留言内容7','2023-03-31 09:47:09','回复信息7','2023-03-31 09:47:09','2023-03-31 09:47:09'),(8,8,1,'留言内容8','2023-03-31 09:47:09','回复信息8','2023-03-31 09:47:09','2023-03-31 09:47:09'),(9,9,1,'留言内容9','2023-03-31 09:47:09','回复信息9','2023-03-31 09:47:09','2023-03-31 09:47:09'),(10,10,2,'留言内容10','2023-03-31 09:47:09','回复信息10','2023-03-31 09:47:09','2023-03-31 09:47:09'),(11,11,1,'留言内容11','2023-03-31 09:47:09','回复信息11','2023-03-31 09:47:09','2023-03-31 09:47:09'),(12,12,3,'留言内容12','2023-03-31 09:47:09','回复信息12','2023-03-31 09:47:09','2023-03-31 09:47:09'),(13,13,2,'留言内容13','2023-03-31 09:47:09','回复信息13','2023-03-31 09:47:09','2023-03-31 09:47:09'),(14,14,2,'留言内容14','2023-03-31 09:47:09','回复信息14','2023-03-31 09:47:09','2023-03-31 09:47:09'),(15,3,1,'添加留言评论1','2023-03-31 10:05:45',NULL,NULL,'2023-03-31 10:05:45');
 
/*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,1,'admin','users','管理员','ytseirf1jkyczn45moeaalkpfrki3oxi','2023-03-31 10:01:52','2023-03-31 11:12:16'),(2,1,'a1','yonghu','用户','wz7m46t8te3q6el3dz1k5ycc49503m9i','2023-03-31 10:02:57','2023-03-31 11:05:17');
 
/*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,'admin','admin','管理员','2023-03-31 09:43:42');
 
/*Table structure for table `yonghu` */
 
DROP TABLE IF EXISTS `yonghu`;
 
CREATE TABLE `yonghu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(200) DEFAULT NULL COMMENT '账户',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `yonghu_name` varchar(200) DEFAULT NULL COMMENT '用户名称 Search111 ',
  `yonghu_phone` varchar(200) DEFAULT NULL COMMENT '用户手机号',
  `yonghu_id_number` varchar(200) DEFAULT NULL COMMENT '用户身份证号',
  `yonghu_photo` varchar(200) DEFAULT NULL COMMENT '用户头像',
  `sex_types` int(11) DEFAULT NULL COMMENT '性别 Search111',
  `yonghu_email` varchar(200) DEFAULT NULL COMMENT '用户邮箱',
  `yonghu_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '添加时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户';
 
/*Data for the table `yonghu` */
 
insert  into `yonghu`(`id`,`username`,`password`,`yonghu_name`,`yonghu_phone`,`yonghu_id_number`,`yonghu_photo`,`sex_types`,`yonghu_email`,`yonghu_delete`,`insert_time`,`create_time`) values (1,'a1','123456','用户名称1','17703786901','410224199010102001','upload/yonghu1.jpg',2,'1@qq.com',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(2,'a2','123456','用户名称2','17703786902','410224199010102002','upload/yonghu2.jpg',1,'2@qq.com',1,'2023-03-31 09:47:09','2023-03-31 09:47:09'),(3,'a3','123456','用户名称3','17703786903','410224199010102003','upload/yonghu3.jpg',1,'3@qq.com',1,'2023-03-31 09:47:09','2023-03-31 09:47:09');
 
/*!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 */;

核心代码


 
package com.controller;
 
 
import java.util.Arrays;
import java.util.Calendar;
import java.util.Date;
import java.util.Map;
 
import javax.servlet.http.HttpServletRequest;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
 
import com.annotation.IgnoreAuth;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.entity.TokenEntity;
import com.entity.UserEntity;
import com.service.TokenService;
import com.service.UserService;
import com.utils.CommonUtil;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.ValidatorUtils;
 
/**
 * 计算机编程-吉哥
 */
@RequestMapping("users")
@RestController
public class UserController{
	
	@Autowired
	private UserService userService;
	
	@Autowired
	private TokenService tokenService;
 
	/**
	 * 登录
	 */
	@IgnoreAuth
	@PostMapping(value = "/login")
	public R login(String username, String password, String captcha, HttpServletRequest request) {
		UserEntity user = userService.selectOne(new EntityWrapper().eq("username", username));
		if(user==null || !user.getPassword().equals(password)) {
			return R.error("账号或密码不正确");
		}
		String token = tokenService.generateToken(user.getId(),username, "users", user.getRole());
		return R.ok().put("token", token);
	}
	
	/**
	 * 注册
	 */
	@IgnoreAuth
	@PostMapping(value = "/register")
	public R register(@RequestBody UserEntity user){
//    	ValidatorUtils.validateEntity(user);
    	if(userService.selectOne(new EntityWrapper().eq("username", user.getUsername())) !=null) {
    		return R.error("用户已存在");
    	}
        userService.insert(user);
        return R.ok();
    }
 
	/**
	 * 退出
	 */
	@GetMapping(value = "logout")
	public R logout(HttpServletRequest request) {
		request.getSession().invalidate();
		return R.ok("退出成功");
	}
	
	/**
     * 密码重置
     */
    @IgnoreAuth
	@RequestMapping(value = "/resetPass")
    public R resetPass(String username, HttpServletRequest request){
    	UserEntity user = userService.selectOne(new EntityWrapper().eq("username", username));
    	if(user==null) {
    		return R.error("账号不存在");
    	}
    	user.setPassword("123456");
        userService.update(user,null);
        return R.ok("密码已重置为：123456");
    }
	
	/**
     * 列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map params,UserEntity user){
        EntityWrapper ew = new EntityWrapper();
    	PageUtils page = userService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.allLike(ew, user), params), params));
        return R.ok().put("data", page);
    }
 
	/**
     * 列表
     */
    @RequestMapping("/list")
    public R list( UserEntity user){
       	EntityWrapper ew = new EntityWrapper();
      	ew.allEq(MPUtil.allEQMapPre( user, "user")); 
        return R.ok().put("data", userService.selectListView(ew));
    }
 
    /**
     * 信息
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") String id){
        UserEntity user = userService.selectById(id);
        return R.ok().put("data", user);
    }
    
    /**
     * 获取用户的session用户信息
     */
    @RequestMapping("/session")
    public R getCurrUser(HttpServletRequest request){
    	Long id = (Long)request.getSession().getAttribute("userId");
        UserEntity user = userService.selectById(id);
        return R.ok().put("data", user);
    }
 
    /**
     * 保存
     */
    @PostMapping("/save")
    public R save(@RequestBody UserEntity user){
//    	ValidatorUtils.validateEntity(user);
    	if(userService.selectOne(new EntityWrapper().eq("username", user.getUsername())) !=null) {
    		return R.error("用户已存在");
    	}
        userService.insert(user);
        return R.ok();
    }
 
    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody UserEntity user){
//        ValidatorUtils.validateEntity(user);
    	UserEntity u = userService.selectOne(new EntityWrapper().eq("username", user.getUsername()));
    	if(u!=null && u.getId()!=user.getId() && u.getUsername().equals(user.getUsername())) {
    		return R.error("用户名已存在。");
    	}
        userService.updateById(user);//全部更新
        return R.ok();
    }
 
    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        userService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
}

更多项目推荐:计算机毕业设计项目

↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓如果大家有任何疑虑，请在下方位置详细咨询。

相关阅读:
密码相关----对称加密，非对称加密
 Linux常用的命令
 java-net-php-python-jsp社会公共常识科普网的设计与实现计算机毕业设计程序
 easy_login通关思路
 知识蒸馏算法汇总
 LLM+RAG: 关于知识问答优化的思考总结
 面试真经（运维工程师）
消息中间件
 Recall：JS EventLoop
数据结构期末复习（十套试卷）库题
原文地址：https://blog.csdn.net/weixin_51966461/article/details/132768530

基于Java+SpringBoot+Vue摄影分享网站的设计与实现 前后端分离【Java毕业设计·文档报告·代码讲解·安装调试】