🍊作者：计算机编程-吉哥
🍊简介：专业从事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{@Autowiredprivate UserService userService;@Autowiredprivate TokenService tokenService;/*** 登录*/@IgnoreAuth@PostMapping(value = "/login")public R login(String username, String password, String captcha, HttpServletRequest request) {UserEntity user = userService.selectOne(new EntityWrapper<UserEntity>().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<UserEntity>().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<UserEntity>().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<String, Object> params,UserEntity user){EntityWrapper<UserEntity> ew = new EntityWrapper<UserEntity>();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<UserEntity> ew = new EntityWrapper<UserEntity>();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<UserEntity>().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<UserEntity>().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();}
}
更多项目推荐:计算机毕业设计项目
↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓如果大家有任何疑虑，请在下方位置详细咨询。
