主要使用技术
开发语言:Java
框架:ssm
JDK版本:JDK1.8
服务器:tomcat9
数据库:mysql 5.7
数据库工具:Navicat11
开发软件:eclipse/myeclipse/idea
Maven包:Maven3.3.9
浏览器:谷歌浏览器
小程序框架:uniapp
小程序开发软件:HBuilder X
小程序运行软件:微信开发者
功能介绍
本系统采用微信开发者开发、结合后台java语言以及Mysql数据库等技术。
系统主要分为管理员和用户、校友三部分
管理员服务端:首页、个人中心、用户管理、校友管理、校友风采管理、校友视频管理、视频分类管理、班级信息管理、留言板管理、论坛交流、系统管理,
校友服务端:首页、个人中心、校友风采管理、校友视频管理,用户客户端;首页、校友风采、校友视频、交流论坛、我的,
校友客户端;首页、校友风采、校友视频、交流论坛、我的等功能,基本上实现了整个校友录网站小程序信息管理的过程。本系统在一般校友录网站小程序的基础上增加了最新信息的功能方便用户快速浏览,是一个高效的、动态的、相互友好的校友录网站小程序。
数据库脚本
/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 5.5.40 : Database - ssm5i1pf
*********************************************************************
*/
/*!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*/`ssm5i1pf` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ssm5i1pf`;
/*Table structure for table `banjixinxi` */
DROP TABLE IF EXISTS `banjixinxi`;
CREATE TABLE `banjixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhuanyebanji` varchar(200) DEFAULT NULL COMMENT '专业班级',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='班级信息';
/*Data for the table `banjixinxi` */
insert into `banjixinxi`(`id`,`addtime`,`zhuanyebanji`) values
(61,'2021-03-12 12:05:54','专业班级1'),
(62,'2021-03-12 12:05:54','专业班级2'),
(63,'2021-03-12 12:05:54','专业班级3'),
(64,'2021-03-12 12:05:54','专业班级4'),
(65,'2021-03-12 12:05:54','专业班级5'),
(66,'2021-03-12 12:05:54','专业班级6');
/*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=1615537685704 DEFAULT CHARSET=utf8 COMMENT='在线聊天';
/*Data for the table `chat` */
insert into `chat`(`id`,`addtime`,`userid`,`adminid`,`ask`,`reply`,`isreply`) values
(71,'2021-03-12 12:05:54',1,1,'提问1','回复1',0),
(72,'2021-03-12 12:05:54',2,2,'提问2','回复2',2),
(73,'2021-03-12 12:05:54',3,3,'提问3','回复3',3),
(74,'2021-03-12 12:05:54',4,4,'提问4','回复4',4),
(75,'2021-03-12 12:05:54',5,5,'提问5','回复5',5),
(76,'2021-03-12 12:05:54',6,6,'提问6','回复6',6),
(1615537477240,'2021-03-12 16:24:36',1615537415550,NULL,'asdfsfdsfdsf',NULL,0),
(1615537512948,'2021-03-12 16:25:12',1615537415550,1,NULL,'回复回复回复回复',NULL),
(1615537685703,'2021-03-12 16:28:05',1,1,NULL,'2312312',NULL);
/*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/ssm5i1pf/upload/picture1.jpg'),
(2,'picture2','http://localhost:8080/ssm5i1pf/upload/picture2.jpg'),
(3,'picture3','http://localhost:8080/ssm5i1pf/upload/picture3.jpg'),
(6,'homepage',NULL);
/*Table structure for table `discussxiaoyoufengcai` */
DROP TABLE IF EXISTS `discussxiaoyoufengcai`;
CREATE TABLE `discussxiaoyoufengcai` (
`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=1615537554197 DEFAULT CHARSET=utf8 COMMENT='校友风采评论表';
/*Data for the table `discussxiaoyoufengcai` */
insert into `discussxiaoyoufengcai`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values
(111,'2021-03-12 12:05:54',1,1,'用户名1','评论内容1','回复内容1'),
(112,'2021-03-12 12:05:54',2,2,'用户名2','评论内容2','回复内容2'),
(113,'2021-03-12 12:05:54',3,3,'用户名3','评论内容3','回复内容3'),
(114,'2021-03-12 12:05:54',4,4,'用户名4','评论内容4','回复内容4'),
(115,'2021-03-12 12:05:54',5,5,'用户名5','评论内容5','回复内容5'),
(116,'2021-03-12 12:05:54',6,6,'用户名6','评论内容6','回复内容6'),
(1615537554196,'2021-03-12 16:25:54',1615537450271,1615537424197,'2','是的范德萨范德萨','asdas');
/*Table structure for table `discussxiaoyoushipin` */
DROP TABLE IF EXISTS `discussxiaoyoushipin`;
CREATE TABLE `discussxiaoyoushipin` (
`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=127 DEFAULT CHARSET=utf8 COMMENT='校友视频评论表';
/*Data for the table `discussxiaoyoushipin` */
insert into `discussxiaoyoushipin`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values
(121,'2021-03-12 12:05:54',1,1,'用户名1','评论内容1','回复内容1'),
(122,'2021-03-12 12:05:54',2,2,'用户名2','评论内容2','回复内容2'),
(123,'2021-03-12 12:05:54',3,3,'用户名3','评论内容3','回复内容3'),
(124,'2021-03-12 12:05:54',4,4,'用户名4','评论内容4','回复内容4'),
(125,'2021-03-12 12:05:54',5,5,'用户名5','评论内容5','回复内容5'),
(126,'2021-03-12 12:05:54',6,6,'用户名6','评论内容6','回复内容6');
/*Table structure for table `forum` */
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
`content` longtext NOT NULL COMMENT '帖子内容',
`parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`isdone` varchar(200) DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615537579049 DEFAULT CHARSET=utf8 COMMENT='论坛交流';
/*Data for the table `forum` */
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values
(81,'2021-03-12 12:05:54','帖子标题1','帖子内容1',1,1,'用户名1','开放'),
(82,'2021-03-12 12:05:54','帖子标题2','帖子内容2',2,2,'用户名2','开放'),
(83,'2021-03-12 12:05:54','帖子标题3','帖子内容3',3,3,'用户名3','开放'),
(84,'2021-03-12 12:05:54','帖子标题4','帖子内容4',4,4,'用户名4','开放'),
(85,'2021-03-12 12:05:54','帖子标题5','帖子内容5',5,5,'用户名5','开放'),
(86,'2021-03-12 12:05:54','帖子标题6','帖子内容6',6,6,'用户名6','开放'),
(1615537526590,'2021-03-12 16:25:26','讨论讨论讨论','讨论讨论讨论讨论讨论讨论',0,1615537415550,'2','开放'),
(1615537533929,'2021-03-12 16:25:33',NULL,'阿斯顿撒旦',1615537526590,1615537415550,'2',NULL),
(1615537579048,'2021-03-12 16:26:18',NULL,'萨达萨达萨达',1615537526590,1615537424197,'2',NULL);
/*Table structure for table `messages` */
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '留言人id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '留言内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615537593988 DEFAULT CHARSET=utf8 COMMENT='留言板';
/*Data for the table `messages` */
insert into `messages`(`id`,`addtime`,`userid`,`username`,`content`,`reply`) values
(101,'2021-03-12 12:05:54',1,'用户名1','留言内容1','回复内容1'),
(102,'2021-03-12 12:05:54',2,'用户名2','留言内容2','回复内容2'),
(103,'2021-03-12 12:05:54',3,'用户名3','留言内容3','回复内容3'),
(104,'2021-03-12 12:05:54',4,'用户名4','留言内容4','回复内容4'),
(105,'2021-03-12 12:05:54',5,'用户名5','留言内容5','回复内容5'),
(106,'2021-03-12 12:05:54',6,'用户名6','留言内容6','回复内容6'),
(1615537593987,'2021-03-12 16:26:33',1615537424197,'2','留言留言留言留言留言','111');
/*Table structure for table `shipinfenlei` */
DROP TABLE IF EXISTS `shipinfenlei`;
CREATE TABLE `shipinfenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shipinfenlei` varchar(200) DEFAULT NULL COMMENT '视频分类',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='视频分类';
/*Data for the table `shipinfenlei` */
insert into `shipinfenlei`(`id`,`addtime`,`shipinfenlei`) values
(51,'2021-03-12 12:05:54','新闻'),
(52,'2021-03-12 12:05:54','视频分类2'),
(53,'2021-03-12 12:05:54','视频分类3'),
(54,'2021-03-12 12:05:54','视频分类4'),
(55,'2021-03-12 12:05:54','视频分类5'),
(56,'2021-03-12 12:05:54','视频分类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=1615537572706 DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*Data for the table `storeup` */
insert into `storeup`(`id`,`addtime`,`userid`,`refid`,`tablename`,`name`,`picture`) values
(1615537572705,'2021-03-12 16:26:12',1615537424197,41,'xiaoyoushipin','标题1','http://localhost:8080/ssm5i1pf/upload/xiaoyoushipin_shipinfengmian1.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 ON UPDATE CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='token表';
/*Data for the table `token` */
insert into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values
(1,1,'abo','users','管理员','vmi0ttjid6e57zcmkrag9e31le0q4hvs','2021-03-12 12:10:56','2021-03-12 17:27:14'),
(2,21,'1','xiaoyou','校友','14evzvqn1b0grolsl1oo6wrs6y7njbq1','2021-03-12 12:11:09','2021-03-12 13:11:09'),
(3,11,'1','yonghu','用户','8gw4lchwhf14swqza28mrrb46bvht0ek','2021-03-12 12:11:20','2021-03-12 13:11:20'),
(4,1615537415550,'2','xiaoyou','校友','jn4mydl5tvx6ka2vr2qk3v59yxzpe0m1','2021-03-12 16:23:48','2021-03-12 17:28:13'),
(5,1615537424197,'2','yonghu','用户','dybkd39hymj9mf09em2oei0m7qmmhta0','2021-03-12 16:25:42','2021-03-12 17:25:42');
/*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,'itrjxxs','itrjxxs','管理员','2021-03-12 12:05:54');
/*Table structure for table `xiaoyou` */
DROP TABLE IF EXISTS `xiaoyou`;
CREATE TABLE `xiaoyou` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xiaoyouzhanghao` varchar(200) NOT NULL COMMENT '校友账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xiaoyouxingming` varchar(200) DEFAULT NULL COMMENT '校友姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615537415551 DEFAULT CHARSET=utf8 COMMENT='校友';
/*Data for the table `xiaoyou` */
insert into `xiaoyou`(`id`,`addtime`,`xiaoyouzhanghao`,`mima`,`xiaoyouxingming`,`xingbie`,`nianling`,`touxiang`,`lianxifangshi`) values
(21,'2021-03-12 12:05:54','1','1','校友姓名1','男',1,'http://localhost:8080/ssm5i1pf/upload/xiaoyou_touxiang1.jpg','13823888881'),
(22,'2021-03-12 12:05:54','校友2','123456','校友姓名2','男',2,'http://localhost:8080/ssm5i1pf/upload/xiaoyou_touxiang2.jpg','13823888882'),
(23,'2021-03-12 12:05:54','校友3','123456','校友姓名3','男',3,'http://localhost:8080/ssm5i1pf/upload/xiaoyou_touxiang3.jpg','13823888883'),
(24,'2021-03-12 12:05:54','校友4','123456','校友姓名4','男',4,'http://localhost:8080/ssm5i1pf/upload/xiaoyou_touxiang4.jpg','13823888884'),
(25,'2021-03-12 12:05:54','校友5','123456','校友姓名5','男',5,'http://localhost:8080/ssm5i1pf/upload/xiaoyou_touxiang5.jpg','13823888885'),
(26,'2021-03-12 12:05:54','校友6','123456','校友姓名6','男',6,'http://localhost:8080/ssm5i1pf/upload/xiaoyou_touxiang6.jpg','13823888886'),
(1615537415550,'2021-03-12 16:23:35','2','2','xxx校友','男',22,'http://localhost:8080/ssm5i1pf/upload/1615537439405.jpg','13245678910');
/*Table structure for table `xiaoyoufengcai` */
DROP TABLE IF EXISTS `xiaoyoufengcai`;
CREATE TABLE `xiaoyoufengcai` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xiaoyouzhanghao` varchar(200) DEFAULT NULL COMMENT '校友账号',
`xiaoyouxingming` varchar(200) DEFAULT NULL COMMENT '校友姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` varchar(200) DEFAULT NULL COMMENT '年龄',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
`zhuanyebanji` varchar(200) DEFAULT NULL COMMENT '专业班级',
`gerenjieshao` longtext COMMENT '个人介绍',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615537450272 DEFAULT CHARSET=utf8 COMMENT='校友风采';
/*Data for the table `xiaoyoufengcai` */
insert into `xiaoyoufengcai`(`id`,`addtime`,`xiaoyouzhanghao`,`xiaoyouxingming`,`xingbie`,`nianling`,`touxiang`,`lianxifangshi`,`zhuanyebanji`,`gerenjieshao`,`thumbsupnum`,`crazilynum`,`userid`) values
(31,'2021-03-12 12:05:54','校友账号1','校友姓名1','性别1','年龄1','http://localhost:8080/ssm5i1pf/upload/xiaoyoufengcai_touxiang1.jpg','联系方式1','专业班级1','个人介绍1',1,1,1),
(32,'2021-03-12 12:05:54','校友账号2','校友姓名2','性别2','年龄2','http://localhost:8080/ssm5i1pf/upload/xiaoyoufengcai_touxiang2.jpg','联系方式2','专业班级2','个人介绍2',2,2,2),
(33,'2021-03-12 12:05:54','校友账号3','校友姓名3','性别3','年龄3','http://localhost:8080/ssm5i1pf/upload/xiaoyoufengcai_touxiang3.jpg','联系方式3','专业班级3','个人介绍3',3,3,3),
(34,'2021-03-12 12:05:54','校友账号4','校友姓名4','性别4','年龄4','http://localhost:8080/ssm5i1pf/upload/xiaoyoufengcai_touxiang4.jpg','联系方式4','专业班级4','个人介绍4',4,4,4),
(35,'2021-03-12 12:05:54','校友账号5','校友姓名5','性别5','年龄5','http://localhost:8080/ssm5i1pf/upload/xiaoyoufengcai_touxiang5.jpg','联系方式5','专业班级5','个人介绍5',5,5,5),
(36,'2021-03-12 12:05:54','校友账号6','校友姓名6','性别6','年龄6','http://localhost:8080/ssm5i1pf/upload/xiaoyoufengcai_touxiang6.jpg','联系方式6','专业班级6','个人介绍6',6,6,6),
(1615537450271,'2021-03-12 16:24:09','2','xxx校友','男','22','http://localhost:8080/ssm5i1pf/upload/1615537439405.jpg','13245678910','专业班级3','sdfdsfdsfdsf',1,0,1615537415550);
/*Table structure for table `xiaoyoushipin` */
DROP TABLE IF EXISTS `xiaoyoushipin`;
CREATE TABLE `xiaoyoushipin` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`biaoti` varchar(200) DEFAULT NULL COMMENT '标题',
`shipinfenlei` varchar(200) DEFAULT NULL COMMENT '视频分类',
`shipin` varchar(200) DEFAULT NULL COMMENT '视频',
`shipinfengmian` varchar(200) DEFAULT NULL COMMENT '视频封面',
`xiaoyouzhanghao` varchar(200) DEFAULT NULL COMMENT '校友账号',
`xiaoyouxingming` varchar(200) DEFAULT NULL COMMENT '校友姓名',
`fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
`shipinjianjie` longtext COMMENT '视频简介',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='校友视频';
/*Data for the table `xiaoyoushipin` */
insert into `xiaoyoushipin`(`id`,`addtime`,`biaoti`,`shipinfenlei`,`shipin`,`shipinfengmian`,`xiaoyouzhanghao`,`xiaoyouxingming`,`fabushijian`,`shipinjianjie`,`thumbsupnum`,`crazilynum`,`clicktime`,`clicknum`,`userid`) values
(41,'2021-03-12 12:05:54','标题1','视频分类1','http://localhost:8080/ssm5i1pf/upload/1615537498572.mp4','http://localhost:8080/ssm5i1pf/upload/xiaoyoushipin_shipinfengmian1.jpg','校友账号1','校友姓名1','2021-03-12 12:05:54','<p>视频简介1</p>',1,1,'2021-03-12 16:27:38',6,1),
(42,'2021-03-12 12:05:54','标题2','视频分类2','','http://localhost:8080/ssm5i1pf/upload/xiaoyoushipin_shipinfengmian2.jpg','校友账号2','校友姓名2','2021-03-12 12:05:54','视频简介2',2,2,'2021-03-12 12:05:54',2,2),
(43,'2021-03-12 12:05:54','标题3','视频分类3','','http://localhost:8080/ssm5i1pf/upload/xiaoyoushipin_shipinfengmian3.jpg','校友账号3','校友姓名3','2021-03-12 12:05:54','视频简介3',3,3,'2021-03-12 12:05:54',3,3),
(44,'2021-03-12 12:05:54','标题4','视频分类4','','http://localhost:8080/ssm5i1pf/upload/xiaoyoushipin_shipinfengmian4.jpg','校友账号4','校友姓名4','2021-03-12 12:05:54','视频简介4',4,4,'2021-03-12 12:05:54',4,4),
(45,'2021-03-12 12:05:54','标题5','视频分类5','','http://localhost:8080/ssm5i1pf/upload/xiaoyoushipin_shipinfengmian5.jpg','校友账号5','校友姓名5','2021-03-12 12:05:54','视频简介5',5,5,'2021-03-12 12:05:54',5,5),
(46,'2021-03-12 12:05:54','标题6','视频分类6','','http://localhost:8080/ssm5i1pf/upload/xiaoyoushipin_shipinfengmian6.jpg','校友账号6','校友姓名6','2021-03-12 12:05:54','视频简介6',6,6,'2021-03-12 12:05:54',6,6);
/*Table structure for table `yonghu` */
DROP TABLE IF EXISTS `yonghu`;
CREATE TABLE `yonghu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1615537424198 DEFAULT CHARSET=utf8 COMMENT='用户';
/*Data for the table `yonghu` */
insert into `yonghu`(`id`,`addtime`,`yonghuzhanghao`,`mima`,`yonghuxingming`,`xingbie`,`nianling`,`touxiang`) values
(11,'2021-03-12 12:05:54','用户1','123456','用户姓名1','男',1,'http://localhost:8080/ssm5i1pf/upload/yonghu_touxiang1.jpg'),
(12,'2021-03-12 12:05:54','用户2','123456','用户姓名2','男',2,'http://localhost:8080/ssm5i1pf/upload/yonghu_touxiang2.jpg'),
(13,'2021-03-12 12:05:54','用户3','123456','用户姓名3','男',3,'http://localhost:8080/ssm5i1pf/upload/yonghu_touxiang3.jpg'),
(14,'2021-03-12 12:05:54','用户4','123456','用户姓名4','男',4,'http://localhost:8080/ssm5i1pf/upload/yonghu_touxiang4.jpg'),
(15,'2021-03-12 12:05:54','用户5','123456','用户姓名5','男',5,'http://localhost:8080/ssm5i1pf/upload/yonghu_touxiang5.jpg'),
(16,'2021-03-12 12:05:54','用户6','123456','用户姓名6','男',6,'http://localhost:8080/ssm5i1pf/upload/yonghu_touxiang6.jpg'),
(1615537424197,'2021-03-12 16:23:44','2','2','xxx用户','男',22,NULL);
/*!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 */;
项目截图