功能介绍
有管理员,社长,社员三个角色。
管理员功能有个人中心,学生管理,社长管理,社团分类管理,社团信息管理,社团加入管理,社团活动管理,活动报名管理,社团成员管理,系统管理。
社长和社员都可以在微信小程序上面进行注册和登录。社长可以在微信小程序上面对社团信息进行管理,对社团加入进行审核,对社团活动进行管理,对活动报名进行审核,对社团成员进行管理。社员可以在微信小程序上面查看和参加社团,查看和报名活动信息等。
数据库脚本
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssmt05hb` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `ssmt05hb`;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussshetuanxinxi`
--
DROP TABLE IF EXISTS `discussshetuanxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussshetuanxinxi` (
`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=117 DEFAULT CHARSET=utf8 COMMENT='社团信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussshetuanxinxi`
--
LOCK TABLES `discussshetuanxinxi` WRITE;
/*!40000 ALTER TABLE `discussshetuanxinxi` DISABLE KEYS */;
INSERT INTO `discussshetuanxinxi` VALUES (111,'2022-04-21 10:10:05',1,1,'用户名1','评论内容1','回复内容1'),(112,'2022-04-21 10:10:05',2,2,'用户名2','评论内容2','回复内容2'),(113,'2022-04-21 10:10:05',3,3,'用户名3','评论内容3','回复内容3'),(114,'2022-04-21 10:10:05',4,4,'用户名4','评论内容4','回复内容4'),(115,'2022-04-21 10:10:05',5,5,'用户名5','评论内容5','回复内容5'),(116,'2022-04-21 10:10:05',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussshetuanxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huodongbaoming`
--
DROP TABLE IF EXISTS `huodongbaoming`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huodongbaoming` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活动名称',
`shetuanmingcheng` varchar(200) DEFAULT NULL COMMENT '社团名称',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`baomingneirong` longtext COMMENT '报名内容',
`baomingriqi` date DEFAULT NULL COMMENT '报名日期',
`xuehao` varchar(200) NOT NULL COMMENT '学号',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`shouji` varchar(200) NOT NULL COMMENT '手机',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='活动报名';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huodongbaoming`
--
LOCK TABLES `huodongbaoming` WRITE;
/*!40000 ALTER TABLE `huodongbaoming` DISABLE KEYS */;
INSERT INTO `huodongbaoming` VALUES (71,'2022-04-21 10:10:05','活动名称1','社团名称1','upload/huodongbaoming_tupian1.jpg','账号1','报名内容1','2022-04-21','学号1','姓名1','13823888881','是',''),(72,'2022-04-21 10:10:05','活动名称2','社团名称2','upload/huodongbaoming_tupian2.jpg','账号2','报名内容2','2022-04-21','学号2','姓名2','13823888882','是',''),(73,'2022-04-21 10:10:05','活动名称3','社团名称3','upload/huodongbaoming_tupian3.jpg','账号3','报名内容3','2022-04-21','学号3','姓名3','13823888883','是',''),(74,'2022-04-21 10:10:05','活动名称4','社团名称4','upload/huodongbaoming_tupian4.jpg','账号4','报名内容4','2022-04-21','学号4','姓名4','13823888884','是',''),(75,'2022-04-21 10:10:05','活动名称5','社团名称5','upload/huodongbaoming_tupian5.jpg','账号5','报名内容5','2022-04-21','学号5','姓名5','13823888885','是',''),(76,'2022-04-21 10:10:05','活动名称6','社团名称6','upload/huodongbaoming_tupian6.jpg','账号6','报名内容6','2022-04-21','学号6','姓名6','13823888886','是','');
/*!40000 ALTER TABLE `huodongbaoming` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`picture` varchar(200) NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='公告资讯';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `shetuanchengyuan`
--
DROP TABLE IF EXISTS `shetuanchengyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shetuanchengyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`chengyuanbianhao` varchar(200) NOT NULL COMMENT '成员编号',
`shetuanmingcheng` varchar(200) DEFAULT NULL COMMENT '社团名称',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`xingbie` varchar(200) NOT NULL COMMENT '性别',
`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
`zhuzhi` varchar(200) DEFAULT NULL COMMENT '住址',
`beizhu` longtext COMMENT '备注',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
PRIMARY KEY (`id`),
UNIQUE KEY `chengyuanbianhao` (`chengyuanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='社团成员';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shetuanchengyuan`
--
--
-- Table structure for table `shetuanfenlei`
--
DROP TABLE IF EXISTS `shetuanfenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shetuanfenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shetuanfenlei` varchar(200) NOT NULL COMMENT '社团分类',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='社团分类';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shetuanfenlei`
--
LOCK TABLES `shetuanfenlei` WRITE;
/*!40000 ALTER TABLE `shetuanfenlei` DISABLE KEYS */;
INSERT INTO `shetuanfenlei` VALUES (31,'2022-04-21 10:10:05','社团分类1'),(32,'2022-04-21 10:10:05','社团分类2'),(33,'2022-04-21 10:10:05','社团分类3'),(34,'2022-04-21 10:10:05','社团分类4'),(35,'2022-04-21 10:10:05','社团分类5'),(36,'2022-04-21 10:10:05','社团分类6');
/*!40000 ALTER TABLE `shetuanfenlei` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shetuanhuodong`
--
DROP TABLE IF EXISTS `shetuanhuodong`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shetuanhuodong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活动名称',
`shetuanmingcheng` varchar(200) DEFAULT NULL COMMENT '社团名称',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`kaishishijian` date DEFAULT NULL COMMENT '开始时间',
`jieshushijian` date DEFAULT NULL COMMENT '结束时间',
`huodongrenshu` int(11) NOT NULL COMMENT '活动人数',
`huodongdidian` varchar(200) DEFAULT NULL COMMENT '活动地点',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`huodongyaoqiu` longtext COMMENT '活动要求',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='社团活动';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shetuanhuodong`
--
LOCK TABLES `shetuanhuodong` WRITE;
/*!40000 ALTER TABLE `shetuanhuodong` DISABLE KEYS */;
INSERT INTO `shetuanhuodong` VALUES (61,'2022-04-21 10:10:05','活动名称1','社团名称1','upload/shetuanhuodong_tupian1.jpg','2022-04-21','2022-04-21',1,'活动地点1','账号1','活动要求1'),(62,'2022-04-21 10:10:05','活动名称2','社团名称2','upload/shetuanhuodong_tupian2.jpg','2022-04-21','2022-04-21',2,'活动地点2','账号2','活动要求2'),(63,'2022-04-21 10:10:05','活动名称3','社团名称3','upload/shetuanhuodong_tupian3.jpg','2022-04-21','2022-04-21',3,'活动地点3','账号3','活动要求3'),(64,'2022-04-21 10:10:05','活动名称4','社团名称4','upload/shetuanhuodong_tupian4.jpg','2022-04-21','2022-04-21',4,'活动地点4','账号4','活动要求4'),(65,'2022-04-21 10:10:05','活动名称5','社团名称5','upload/shetuanhuodong_tupian5.jpg','2022-04-21','2022-04-21',5,'活动地点5','账号5','活动要求5'),(66,'2022-04-21 10:10:05','活动名称6','社团名称6','upload/shetuanhuodong_tupian6.jpg','2022-04-21','2022-04-21',6,'活动地点6','账号6','活动要求6');
/*!40000 ALTER TABLE `shetuanhuodong` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shetuanjiaru`
--
DROP TABLE IF EXISTS `shetuanjiaru`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shetuanjiaru` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shetuanmingcheng` varchar(200) DEFAULT NULL COMMENT '社团名称',
`shetuanfenlei` varchar(200) DEFAULT NULL COMMENT '社团分类',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`shenqingliyou` longtext COMMENT '申请理由',
`shenqingriqi` datetime DEFAULT NULL COMMENT '申请日期',
`xuehao` varchar(200) NOT NULL COMMENT '学号',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`shouji` varchar(200) NOT NULL COMMENT '手机',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='社团加入';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `shetuanxinxi`
--
DROP TABLE IF EXISTS `shetuanxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shetuanxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shetuanmingcheng` varchar(200) NOT NULL COMMENT '社团名称',
`shetuanfenlei` varchar(200) NOT NULL COMMENT '社团分类',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`shetuanrenshu` varchar(200) DEFAULT NULL COMMENT '社团人数',
`chuangjianshijian` date DEFAULT NULL COMMENT '创建时间',
`shezhangxingming` varchar(200) DEFAULT NULL COMMENT '社长姓名',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
`shetuanjianjie` longtext COMMENT '社团简介',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='社团信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `shezhang`
--
DROP TABLE IF EXISTS `shezhang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shezhang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhanghao` varchar(200) NOT NULL COMMENT '账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`shezhangxingming` varchar(200) DEFAULT NULL COMMENT '社长姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`shetuanmingcheng` varchar(200) DEFAULT NULL COMMENT '社团名称',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY (`id`),
UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='社长';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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 '收藏图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-04-21 10:10:05');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xuesheng`
--
DROP TABLE IF EXISTS `xuesheng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuesheng` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) NOT NULL COMMENT '学号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`xueyuan` varchar(200) DEFAULT NULL COMMENT '学院',
`banji` varchar(200) DEFAULT NULL COMMENT '班级',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
PRIMARY KEY (`id`),
UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='学生';
/*!40101 SET character_set_client = @saved_cs_client */;
项目截图