基于ssm的班级事务管理系统设计与实现-计算机毕业设计源码+LW文档

原创

毕设大神 2022-09-17 21:54:55 ©著作权

文章标签 sql 主键数据库 文章分类 Java 后端开发

©著作权归作者所有：来自51CTO博客作者毕设大神的原创作品，请联系作者获取转载授权，否则将追究法律责任

开发语言：Java

框架：ssm

JDK版本：JDK1.8

服务器：tomcat7

数据库：mysql 5.7（一定要5.7版本）

数据库工具：Navicat11

开发软件：eclipse/myeclipse/idea

Maven包：Maven3.3.9

浏览器：谷歌浏览器

数据库脚本：

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)

-- Host: localhost Database: ssmn2tzw

-- ------------------------------------------------------

-- Server version 5.7.31

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!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 */;

-- Current Database: `ssmn2tzw`

/*!40000 DROP DATABASE IF EXISTS `ssmn2tzw`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssmn2tzw` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `ssmn2tzw`;

-- Table structure for table `banfeitongzhi`

DROP TABLE IF EXISTS `banfeitongzhi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `banfeitongzhi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',

`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',

`banji` varchar(200) DEFAULT NULL COMMENT '班级',

`banfei` float DEFAULT NULL COMMENT '班费',

`shoujiaoyuanyin` longtext COMMENT '收缴原因',

`banweizhanghao` varchar(200) DEFAULT NULL COMMENT '班委账号',

`banweixingming` varchar(200) DEFAULT NULL COMMENT '班委姓名',

`tongzhiriqi` date DEFAULT NULL COMMENT '通知日期',

`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1646834134872 DEFAULT CHARSET=utf8 COMMENT='班费通知';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `banfeitongzhi`

LOCK TABLES `banfeitongzhi` WRITE;

/*!40000 ALTER TABLE `banfeitongzhi` DISABLE KEYS */;

INSERT INTO `banfeitongzhi` VALUES (91,'2022-03-09 13:40:42','学号1','姓名1','班级1',1,'收缴原因1','班委账号1','班委姓名1','2022-03-09','未支付'),(92,'2022-03-09 13:40:42','学号2','姓名2','班级2',2,'收缴原因2','班委账号2','班委姓名2','2022-03-09','未支付'),(93,'2022-03-09 13:40:42','学号3','姓名3','班级3',3,'收缴原因3','班委账号3','班委姓名3','2022-03-09','未支付'),(94,'2022-03-09 13:40:42','学号4','姓名4','班级4',4,'收缴原因4','班委账号4','班委姓名4','2022-03-09','未支付'),(95,'2022-03-09 13:40:42','学号5','姓名5','班级5',5,'收缴原因5','班委账号5','班委姓名5','2022-03-09','未支付'),(96,'2022-03-09 13:40:42','学号6','姓名6','班级6',6,'收缴原因6','班委账号6','班委姓名6','2022-03-09','未支付'),(1646834134871,'2022-03-09 13:55:34','11','时代','2班',33,'地方第三方时代发送到发多少','22','地方','2022-03-09','已支付');

/*!40000 ALTER TABLE `banfeitongzhi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `banhuizuzhi`

DROP TABLE IF EXISTS `banhuizuzhi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `banhuizuzhi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`zuzhibianhao` varchar(200) DEFAULT NULL COMMENT '组织编号',

`zuzhimingcheng` varchar(200) DEFAULT NULL COMMENT '组织名称',

`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',

`chuangjianriqi` date DEFAULT NULL COMMENT '创建日期',

`chuangjianren` varchar(200) DEFAULT NULL COMMENT '创建人',

`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',

`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',

`zuzhijieshao` 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 '点击次数',

PRIMARY KEY (`id`),

UNIQUE KEY `zuzhibianhao` (`zuzhibianhao`)

) ENGINE=InnoDB AUTO_INCREMENT=1646834210841 DEFAULT CHARSET=utf8 COMMENT='班会组织';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `banhuizuzhi`

LOCK TABLES `banhuizuzhi` WRITE;

/*!40000 ALTER TABLE `banhuizuzhi` DISABLE KEYS */;

INSERT INTO `banhuizuzhi` VALUES (31,'2022-03-09 13:40:42','1111111111','组织名称1','upload/banhuizuzhi_fengmian1.jpg','2022-03-03','创建人1','联系电话1','邮箱1','组织介绍1',1,1,'2022-03-09 21:58:42',3),(32,'2022-03-09 13:40:42','2222222222','组织名称2','upload/banhuizuzhi_fengmian2.jpg','2022-03-09','创建人2','联系电话2','邮箱2','组织介绍2',2,2,'2022-03-09 21:40:42',2),(33,'2022-03-09 13:40:42','3333333333','组织名称3','upload/banhuizuzhi_fengmian3.jpg','2022-03-09','创建人3','联系电话3','邮箱3','组织介绍3',3,3,'2022-03-09 21:40:42',3),(34,'2022-03-09 13:40:42','4444444444','组织名称4','upload/banhuizuzhi_fengmian4.jpg','2022-03-09','创建人4','联系电话4','邮箱4','组织介绍4',4,4,'2022-03-09 21:58:44',5),(35,'2022-03-09 13:40:42','5555555555','组织名称5','upload/banhuizuzhi_fengmian5.jpg','2022-03-09','创建人5','联系电话5','邮箱5','组织介绍5',5,5,'2022-03-09 21:40:42',5),(36,'2022-03-09 13:40:42','6666666666','组织名称6','upload/banhuizuzhi_fengmian6.jpg','2022-03-09','创建人6','联系电话6','邮箱6','组织介绍6',6,6,'2022-03-09 21:40:42',6),(1646834210840,'2022-03-09 13:56:50','1646834195177','水电费时代','upload/1646834197819.jpg','2022-03-09','地方给对方','1112223333','33@qq.com','水电费时代发送到发送到发送到发送到发送到发送到水电费时代发送到发送到发送到发送到发送到发送到水电费时代发送到发送到发送到发送到发送到发送到',1,0,'2022-03-09 22:00:16',6);

/*!40000 ALTER TABLE `banhuizuzhi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `banwei`

DROP TABLE IF EXISTS `banwei`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `banwei` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`banweizhanghao` varchar(200) NOT NULL COMMENT '班委账号',

`mima` varchar(200) NOT NULL COMMENT '密码',

`banweixingming` varchar(200) NOT NULL COMMENT '班委姓名',

`nianling` int(11) DEFAULT NULL COMMENT '年龄',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`shouji` varchar(200) DEFAULT NULL COMMENT '手机',

`banji` varchar(200) NOT NULL COMMENT '班级',

`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',

PRIMARY KEY (`id`),

UNIQUE KEY `banweizhanghao` (`banweizhanghao`)

) ENGINE=InnoDB AUTO_INCREMENT=1646833997855 DEFAULT CHARSET=utf8 COMMENT='班委';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `banwei`

LOCK TABLES `banwei` WRITE;

/*!40000 ALTER TABLE `banwei` DISABLE KEYS */;

INSERT INTO `banwei` VALUES (21,'2022-03-09 13:40:42','班委账号1','123456','班委姓名1',1,'男','13823888881','班级1','upload/banwei_zhaopian1.jpg'),(22,'2022-03-09 13:40:42','班委账号2','123456','班委姓名2',2,'男','13823888882','班级2','upload/banwei_zhaopian2.jpg'),(23,'2022-03-09 13:40:42','班委账号3','123456','班委姓名3',3,'男','13823888883','班级3','upload/banwei_zhaopian3.jpg'),(24,'2022-03-09 13:40:42','班委账号4','123456','班委姓名4',4,'男','13823888884','班级4','upload/banwei_zhaopian4.jpg'),(25,'2022-03-09 13:40:42','班委账号5','123456','班委姓名5',5,'男','13823888885','班级5','upload/banwei_zhaopian5.jpg'),(26,'2022-03-09 13:40:42','班委账号6','123456','班委姓名6',6,'男','13823888886','班级6','upload/banwei_zhaopian6.jpg'),(1646833997854,'2022-03-09 13:53:17','22','22','地方',22,'女','11122233334','2班','upload/1646834045852.jpg');

/*!40000 ALTER TABLE `banwei` ENABLE KEYS */;

UNLOCK TABLES;

-- 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/1646834300699.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');

/*!40000 ALTER TABLE `config` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `dangyuanfazhan`

DROP TABLE IF EXISTS `dangyuanfazhan`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `dangyuanfazhan` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`biaoti` varchar(200) NOT NULL COMMENT '标题',

`jianjie` longtext COMMENT '简介',

`fabushijian` date DEFAULT NULL COMMENT '发布时间',

`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',

`neirong` 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 '点击次数',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1646834233551 DEFAULT CHARSET=utf8 COMMENT='党员发展';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `dangyuanfazhan`

LOCK TABLES `dangyuanfazhan` WRITE;

/*!40000 ALTER TABLE `dangyuanfazhan` DISABLE KEYS */;

INSERT INTO `dangyuanfazhan` VALUES (51,'2022-03-09 13:40:42','标题1','简介1','2022-03-09','upload/dangyuanfazhan_fengmian1.jpg','内容1',1,1,'2022-03-09 21:40:42',1),(52,'2022-03-09 13:40:42','标题2','简介2','2022-03-09','upload/dangyuanfazhan_fengmian2.jpg','内容2',2,2,'2022-03-09 21:59:06',4),(53,'2022-03-09 13:40:42','标题3','简介3','2022-03-09','upload/dangyuanfazhan_fengmian3.jpg','内容3',3,3,'2022-03-09 21:40:42',3),(54,'2022-03-09 13:40:42','标题4','简介4','2022-03-09','upload/dangyuanfazhan_fengmian4.jpg','内容4',4,4,'2022-03-09 21:40:42',4),(55,'2022-03-09 13:40:42','标题5','简介5','2022-03-09','upload/dangyuanfazhan_fengmian5.jpg','内容5',5,5,'2022-03-09 21:40:42',5),(56,'2022-03-09 13:40:42','标题6','简介6','2022-03-09','upload/dangyuanfazhan_fengmian6.jpg','内容6',6,6,'2022-03-09 21:40:42',6),(1646834233550,'2022-03-09 13:57:13','水电费时代','地方的鬼地方个的郭德纲地方给对方固定刚发的地方的鬼地方个的郭德纲地方给对方固定刚发的','2022-03-09','upload/1646834226362.jpeg','地方的鬼地方个的郭德纲地方给对方固定刚发的地方的鬼地方个的郭德纲地方给对方固定刚发的地方的鬼地方个的郭德纲地方给对方固定刚发的地方的鬼地方个的郭德纲地方给对方固定刚发的地方的鬼地方个的郭德纲地方给对方固定刚发的地方的鬼地方个的郭德纲地方给对方固定刚发的地方的鬼地方个的郭德纲地方给对方固定刚发的',0,0,'2022-03-09 21:59:12',2);

/*!40000 ALTER TABLE `dangyuanfazhan` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `dangyuanpeixun`

DROP TABLE IF EXISTS `dangyuanpeixun`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `dangyuanpeixun` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`peixunbiaoti` varchar(200) NOT NULL COMMENT '培训标题',

`tupian` varchar(200) DEFAULT NULL COMMENT '图片',

`peixunshijian` datetime DEFAULT NULL COMMENT '培训时间',

`jieshushijian` datetime DEFAULT NULL COMMENT '结束时间',

`peixuntianshu` int(11) DEFAULT NULL COMMENT '培训天数',

`fabushijian` date DEFAULT NULL COMMENT '发布时间',

`peixunneirong` 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 '点击次数',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='党员培训';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `dangyuanpeixun`

LOCK TABLES `dangyuanpeixun` WRITE;

/*!40000 ALTER TABLE `dangyuanpeixun` DISABLE KEYS */;

INSERT INTO `dangyuanpeixun` VALUES (61,'2022-03-09 13:40:42','培训标题1','upload/dangyuanpeixun_tupian1.jpg','2022-03-09 21:40:42','2022-03-09 22:40:42',1,'2022-03-08','培训内容1水电费时代发送到发多少发多少培训内容1水电费时代发送到发多少发多少培训内容1水电费时代发送到发多少发多少',1,1,'2022-03-09 21:59:16',4),(62,'2022-03-09 13:40:42','培训标题2','upload/dangyuanpeixun_tupian2.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',2,'2022-03-09','培训内容2',2,2,'2022-03-09 21:40:42',2),(63,'2022-03-09 13:40:42','培训标题3','upload/dangyuanpeixun_tupian3.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',3,'2022-03-09','培训内容3',3,3,'2022-03-09 21:40:42',3),(64,'2022-03-09 13:40:42','培训标题4','upload/dangyuanpeixun_tupian4.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',4,'2022-03-09','培训内容4',4,4,'2022-03-09 21:40:42',4),(65,'2022-03-09 13:40:42','培训标题5','upload/dangyuanpeixun_tupian5.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',5,'2022-03-09','培训内容5',5,5,'2022-03-09 21:40:42',5),(66,'2022-03-09 13:40:42','培训标题6','upload/dangyuanpeixun_tupian6.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',6,'2022-03-09','培训内容6',6,6,'2022-03-09 21:40:42',6);

/*!40000 ALTER TABLE `dangyuanpeixun` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `discussbanhuizuzhi`

DROP TABLE IF EXISTS `discussbanhuizuzhi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discussbanhuizuzhi` (

`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=1646834339716 DEFAULT CHARSET=utf8 COMMENT='班会组织评论表';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `discussbanhuizuzhi`

LOCK TABLES `discussbanhuizuzhi` WRITE;

/*!40000 ALTER TABLE `discussbanhuizuzhi` DISABLE KEYS */;

INSERT INTO `discussbanhuizuzhi` VALUES (131,'2022-03-09 13:40:42',1,1,'用户名1','评论内容1','回复内容1'),(132,'2022-03-09 13:40:42',2,2,'用户名2','评论内容2','回复内容2'),(133,'2022-03-09 13:40:42',3,3,'用户名3','评论内容3','回复内容3'),(134,'2022-03-09 13:40:42',4,4,'用户名4','评论内容4','回复内容4'),(135,'2022-03-09 13:40:42',5,5,'用户名5','评论内容5','回复内容5'),(136,'2022-03-09 13:40:42',6,6,'用户名6','评论内容6','回复内容6'),(1646834339715,'2022-03-09 13:58:58',1646834210840,1646833986396,'11','时代发送到','水电费时代');

/*!40000 ALTER TABLE `discussbanhuizuzhi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `discussdangyuanfazhan`

DROP TABLE IF EXISTS `discussdangyuanfazhan`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discussdangyuanfazhan` (

`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=147 DEFAULT CHARSET=utf8 COMMENT='党员发展评论表';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `discussdangyuanfazhan`

LOCK TABLES `discussdangyuanfazhan` WRITE;

/*!40000 ALTER TABLE `discussdangyuanfazhan` DISABLE KEYS */;

INSERT INTO `discussdangyuanfazhan` VALUES (141,'2022-03-09 13:40:42',1,1,'用户名1','评论内容1','回复内容1'),(142,'2022-03-09 13:40:42',2,2,'用户名2','评论内容2','回复内容2'),(143,'2022-03-09 13:40:42',3,3,'用户名3','评论内容3','回复内容3'),(144,'2022-03-09 13:40:42',4,4,'用户名4','评论内容4','回复内容4'),(145,'2022-03-09 13:40:42',5,5,'用户名5','评论内容5','回复内容5'),(146,'2022-03-09 13:40:42',6,6,'用户名6','评论内容6','回复内容6');

/*!40000 ALTER TABLE `discussdangyuanfazhan` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `discussdangyuanpeixun`

DROP TABLE IF EXISTS `discussdangyuanpeixun`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discussdangyuanpeixun` (

`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=157 DEFAULT CHARSET=utf8 COMMENT='党员培训评论表';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `discussdangyuanpeixun`

LOCK TABLES `discussdangyuanpeixun` WRITE;

/*!40000 ALTER TABLE `discussdangyuanpeixun` DISABLE KEYS */;

INSERT INTO `discussdangyuanpeixun` VALUES (151,'2022-03-09 13:40:42',1,1,'用户名1','评论内容1','回复内容1'),(152,'2022-03-09 13:40:42',2,2,'用户名2','评论内容2','回复内容2'),(153,'2022-03-09 13:40:42',3,3,'用户名3','评论内容3','回复内容3'),(154,'2022-03-09 13:40:42',4,4,'用户名4','评论内容4','回复内容4'),(155,'2022-03-09 13:40:42',5,5,'用户名5','评论内容5','回复内容5'),(156,'2022-03-09 13:40:42',6,6,'用户名6','评论内容6','回复内容6');

/*!40000 ALTER TABLE `discussdangyuanpeixun` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `discusshuodongxinxi`

DROP TABLE IF EXISTS `discusshuodongxinxi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discusshuodongxinxi` (

`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=167 DEFAULT CHARSET=utf8 COMMENT='活动信息评论表';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `discusshuodongxinxi`

LOCK TABLES `discusshuodongxinxi` WRITE;

/*!40000 ALTER TABLE `discusshuodongxinxi` DISABLE KEYS */;

INSERT INTO `discusshuodongxinxi` VALUES (161,'2022-03-09 13:40:42',1,1,'用户名1','评论内容1','回复内容1'),(162,'2022-03-09 13:40:42',2,2,'用户名2','评论内容2','回复内容2'),(163,'2022-03-09 13:40:42',3,3,'用户名3','评论内容3','回复内容3'),(164,'2022-03-09 13:40:42',4,4,'用户名4','评论内容4','回复内容4'),(165,'2022-03-09 13:40:42',5,5,'用户名5','评论内容5','回复内容5'),(166,'2022-03-09 13:40:42',6,6,'用户名6','评论内容6','回复内容6');

/*!40000 ALTER TABLE `discusshuodongxinxi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `discusswenhuaxuexi`

DROP TABLE IF EXISTS `discusswenhuaxuexi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discusswenhuaxuexi` (

`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=177 DEFAULT CHARSET=utf8 COMMENT='文化学习评论表';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `discusswenhuaxuexi`

LOCK TABLES `discusswenhuaxuexi` WRITE;

/*!40000 ALTER TABLE `discusswenhuaxuexi` DISABLE KEYS */;

INSERT INTO `discusswenhuaxuexi` VALUES (171,'2022-03-09 13:40:42',1,1,'用户名1','评论内容1','回复内容1'),(172,'2022-03-09 13:40:42',2,2,'用户名2','评论内容2','回复内容2'),(173,'2022-03-09 13:40:42',3,3,'用户名3','评论内容3','回复内容3'),(174,'2022-03-09 13:40:42',4,4,'用户名4','评论内容4','回复内容4'),(175,'2022-03-09 13:40:42',5,5,'用户名5','评论内容5','回复内容5'),(176,'2022-03-09 13:40:42',6,6,'用户名6','评论内容6','回复内容6');

/*!40000 ALTER TABLE `discusswenhuaxuexi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `huodongxinxi`

DROP TABLE IF EXISTS `huodongxinxi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `huodongxinxi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`huodongmingcheng` varchar(200) NOT NULL COMMENT '活动名称',

`huodongleixing` varchar(200) NOT NULL COMMENT '活动类型',

`kaishishijian` date DEFAULT NULL COMMENT '开始时间',

`jieshushijian` date DEFAULT NULL COMMENT '结束时间',

`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',

`huodongxiangqing` 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 '点击次数',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='活动信息';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `huodongxinxi`

LOCK TABLES `huodongxinxi` WRITE;

/*!40000 ALTER TABLE `huodongxinxi` DISABLE KEYS */;

INSERT INTO `huodongxinxi` VALUES (81,'2022-03-09 13:40:42','活动名称1','班费收集','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian1.jpg','活动详情1水电费三房时代发送到发送到',1,1,'2022-03-09 21:59:29',4),(82,'2022-03-09 13:40:42','活动名称2','学员党史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian2.jpg','活动详情2',2,2,'2022-03-09 21:40:42',2),(83,'2022-03-09 13:40:42','水电费时代发送到','学员党史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian3.jpg','活动详情3水电费发送到发送到发送到',3,3,'2022-03-09 21:57:54',4),(84,'2022-03-09 13:40:42','活动名称4','学员党史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian4.jpg','活动详情4',4,4,'2022-03-09 21:40:42',4),(85,'2022-03-09 13:40:42','活动名称5','学员党史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian5.jpg','活动详情5',5,5,'2022-03-09 21:40:42',5),(86,'2022-03-09 13:40:42','活动名称6','学员党史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian6.jpg','活动详情6',6,6,'2022-03-09 21:40:42',6);

/*!40000 ALTER TABLE `huodongxinxi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `jiankangdangan`

DROP TABLE IF EXISTS `jiankangdangan`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `jiankangdangan` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',

`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',

`nianling` varchar(200) DEFAULT NULL COMMENT '年龄',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`manxingjibing` varchar(200) DEFAULT NULL COMMENT '慢性急病',

`jiazubingshi` varchar(200) DEFAULT NULL COMMENT '家族病史',

`yaowuguomin` varchar(200) DEFAULT NULL COMMENT '药物过敏',

`zhongdabingshi` varchar(200) DEFAULT NULL COMMENT '重大病史',

`richangyinshi` longtext COMMENT '日常饮食',

`beizhu` longtext COMMENT '备注',

`dengjiriqi` date DEFAULT NULL COMMENT '登记日期',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1646834032330 DEFAULT CHARSET=utf8 COMMENT='健康档案';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `jiankangdangan`

LOCK TABLES `jiankangdangan` WRITE;

/*!40000 ALTER TABLE `jiankangdangan` DISABLE KEYS */;

INSERT INTO `jiankangdangan` VALUES (41,'2022-03-09 13:40:42','学号1','姓名1','年龄1','性别1','有','有','有','有','日常饮食1','备注1','2022-03-09'),(42,'2022-03-09 13:40:42','学号2','姓名2','年龄2','性别2','有','有','有','有','日常饮食2','备注2','2022-03-09'),(43,'2022-03-09 13:40:42','学号3','姓名3','年龄3','性别3','有','有','有','有','日常饮食3','备注3','2022-03-09'),(44,'2022-03-09 13:40:42','学号4','姓名4','年龄4','性别4','有','有','有','有','日常饮食4','备注4','2022-03-09'),(45,'2022-03-09 13:40:42','学号5','姓名5','年龄5','性别5','有','有','有','有','日常饮食5','备注5','2022-03-09'),(46,'2022-03-09 13:40:42','学号6','姓名6','年龄6','性别6','有','有','有','有','日常饮食6','备注6','2022-03-09'),(1646834032329,'2022-03-09 13:53:51','11','时代','11','女','无','无','无','无','蓄势待发时代发生发送到发送到发送到','水电费时代发送到发送到发送到发送到发送到发送到','2022-03-09');

/*!40000 ALTER TABLE `jiankangdangan` 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=127 DEFAULT CHARSET=utf8 COMMENT='通知公告';

/*!40101 SET character_set_client = @saved_cs_client */;

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 AUTO_INCREMENT=1646834377884 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 */;

INSERT INTO `storeup` VALUES (1646834332800,'2022-03-09 13:58:51',1646833986396,1646834210840,'banhuizuzhi','水电费时代','upload/1646834197819.jpg','1',NULL),(1646834335064,'2022-03-09 13:58:54',1646833986396,1646834210840,'banhuizuzhi','水电费时代','upload/1646834197819.jpg','21',NULL);

/*!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 AUTO_INCREMENT=4 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 */;

INSERT INTO `token` VALUES (1,1646833986396,'11','xuesheng','学生','owzzm9q08c49r3obpypyciq05stz1do2','2022-03-09 13:53:22','2022-03-09 15:00:16'),(2,1646833997854,'22','banwei','班委','w7b7dffr5soy2d28teg5e5ax9z3pexa4','2022-03-09 13:53:59','2022-03-09 15:00:23'),(3,1,'abo','users','管理员','vado10mi85khwkt0loep2xrrhfqfolzv','2022-03-09 13:56:01','2022-03-09 15:00:00');

/*!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-03-09 13:40:42');

/*!40000 ALTER TABLE `users` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `wenhuaxuexi`

DROP TABLE IF EXISTS `wenhuaxuexi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `wenhuaxuexi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`biaoti` varchar(200) NOT NULL COMMENT '标题',

`jianjie` longtext COMMENT '简介',

`fabushijian` date DEFAULT NULL COMMENT '发布时间',

`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',

`neirong` 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 '点击次数',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1646834293408 DEFAULT CHARSET=utf8 COMMENT='文化学习';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `wenhuaxuexi`

LOCK TABLES `wenhuaxuexi` WRITE;

/*!40000 ALTER TABLE `wenhuaxuexi` DISABLE KEYS */;

INSERT INTO `wenhuaxuexi` VALUES (101,'2022-03-09 13:40:42','标题1','简介1','2022-03-09','upload/wenhuaxuexi_fengmian1.jpg','内容1',1,1,'2022-03-09 21:40:42',1),(102,'2022-03-09 13:40:42','标题2','简介2','2022-03-09','upload/wenhuaxuexi_fengmian2.jpg','内容2',2,2,'2022-03-09 21:40:42',2),(103,'2022-03-09 13:40:42','标题3','简介3','2022-03-09','upload/wenhuaxuexi_fengmian3.jpg','内容3',3,3,'2022-03-09 21:40:42',3),(104,'2022-03-09 13:40:42','标题4','简介4','2022-03-09','upload/wenhuaxuexi_fengmian4.jpg','内容4',4,4,'2022-03-09 21:40:42',4),(105,'2022-03-09 13:40:42','标题5','简介5','2022-03-09','upload/wenhuaxuexi_fengmian5.jpg','内容5',5,5,'2022-03-09 21:40:42',5),(106,'2022-03-09 13:40:42','标题6','简介6','2022-03-09','upload/wenhuaxuexi_fengmian6.jpg','内容6',6,6,'2022-03-09 21:40:42',6),(1646834293407,'2022-03-09 13:58:12','水电费时代','时代发多少发送到发送到发送到','2022-03-09','upload/1646834288628.jpeg','时代发多少发多少发送到发送到发送到时代',0,0,'2022-03-09 21:59:53',4);

/*!40000 ALTER TABLE `wenhuaxuexi` 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) NOT NULL COMMENT '姓名',

`nianling` int(11) DEFAULT NULL COMMENT '年龄',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`shouji` varchar(200) DEFAULT NULL COMMENT '手机',

`banji` varchar(200) NOT NULL COMMENT '班级',

`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',

PRIMARY KEY (`id`),

UNIQUE KEY `xuehao` (`xuehao`)

) ENGINE=InnoDB AUTO_INCREMENT=1646833986397 DEFAULT CHARSET=utf8 COMMENT='学生';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `xuesheng`

LOCK TABLES `xuesheng` WRITE;

/*!40000 ALTER TABLE `xuesheng` DISABLE KEYS */;

INSERT INTO `xuesheng` VALUES (11,'2022-03-09 13:40:42','学号1','123456','姓名1',1,'男','13823888881','班级1','upload/xuesheng_zhaopian1.jpg'),(12,'2022-03-09 13:40:42','学号2','123456','姓名2',2,'男','13823888882','班级2','upload/xuesheng_zhaopian2.jpg'),(13,'2022-03-09 13:40:42','学号3','123456','姓名3',3,'男','13823888883','班级3','upload/xuesheng_zhaopian3.jpg'),(14,'2022-03-09 13:40:42','学号4','123456','姓名4',4,'男','13823888884','班级4','upload/xuesheng_zhaopian4.jpg'),(15,'2022-03-09 13:40:42','学号5','123456','姓名5',5,'男','13823888885','班级5','upload/xuesheng_zhaopian5.jpg'),(16,'2022-03-09 13:40:42','学号6','123456','姓名6',6,'男','13823888886','班级6','upload/xuesheng_zhaopian6.jpg'),(1646833986396,'2022-03-09 13:53:06','11','11','时代',11,'女','11122211111','2班','upload/1646834009640.jpg');

/*!40000 ALTER TABLE `xuesheng` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `xueshengchengji`

DROP TABLE IF EXISTS `xueshengchengji`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `xueshengchengji` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',

`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',

`banji` varchar(200) DEFAULT NULL COMMENT '班级',