计算机毕业设计 基于SpringBoot的智慧党建系统的设计与实现 Java实战项目 附源码+文档+视频讲解

博主介绍:✌从事软件开发10年之余,专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌
🍅文末获取源码联系🍅
👇🏻 精彩专栏推荐订阅👇🏻 不然下次找不到哟
————————————————
计算机毕业设计题目《1000套》

目录

 1、项目介绍及开发技术

1.1 项目介绍

1.2 开发技术

2、系统功能设计结构图

3、功能截图

3.1 前台功能

3.2 后台功能

4、数据库表结构设计

5、关键代码

 5.1 党费缴纳管理Controller模块 

5.2 党费缴纳管理Service模块 

 5.3 党费缴纳管理ServiceImpl模块

 5.4  党费缴纳管理Dao模块

6、论文目录结构

7、源码获取


 1、项目介绍及开发技术

1.1 项目介绍

传统智慧党建管理采取了人工的管理方法,但这种管理方法存在着许多弊端,比如效率低下、安全性低以及信息传输的不准确等,同时由于管理信息系统中会形成众多的个人文档和信息系统数据,通过人工方法对智慧党建信息进行集中管理会形成检索、更改和维护等较为麻烦的管理问题,同时由于当下人民群众对智慧党建管理的需求也日益高涨,各级需要继续开展全新的改革以满足时代的需求。根据此问题,研发一套智慧党建系统,既能够大大提高信息的检索、变更与维护的工作效率,也能够方便信息系统的管理运用,从而减少信息管理成本,提高效率。

1.2 开发技术

Java开发语言、SpringBoot、MyBatisPlus、MySQL数据库、Maven、IDEA开发工具、JDK1.8+、Vue、HTML、CSS、JS。

2、系统功能设计结构图

本系统主要设计并完成了用户登录管理过程、个人信息修改、对党员管理、党支部管理、党建要闻管理、党建地图管理、党建学习管理、学习心得管理、党费缴纳管理、党建活动管理、活动报名管理、问卷调查管理、问卷回答管理、民主投票管理、投票信息管理、试题管理、学习测试管理、系统管理、考试管理等功能进行管理。

3、功能截图

3.1 前台功能

首先看到的就是首页界面。在这里,人们能够看到系统的导航条,通过导航条导航进入各功能展示页面进行操作。

 党建要闻:在党建要闻页面的输入栏中输入党建标题、简介进行查询,可以查看到党建要闻详细信息,并根据需要进行评论或收藏操作;

 党建学习:在党建学习页面的输入栏中输入资料名称进行查询,可以查看到党建学习详细信息。

 党建活动:在党建活动页面的输入栏中输入活动名称进行查询,可以查看到党建活动详细信息,并根据需要进行报名操作。

 问卷调查:在问卷调查页面的输入栏中输入问卷标题进行查询,可以查看到问卷调查详细信息,并进行问卷回答操作。

 民主投票:在民主投票页面的输入栏中输入投票主题进行查询,可以查看到民主投票详细信息,并进行投票操作。

 学习测试:在学习测试页面可以查看学习测试名称、考试时长、创建时间等信息,并进行考试操作。

 个人中心:在个人中心页面通过填写个人详细信息进行信息更新操作,还可以对考试管理、错题本、我的收藏进行详细操作。

3.2 后台功能

后台用户登录,在登录页面选择需要登录的角色,在正确输入用户名和密码后,进入操作系统进行操作。

 管理员进入主页面,主要功能包括对个人中心、党员管理、党支部管理、党建要闻管理、党建地图管理、党建学习管理、学习心得管理、党费缴纳管理、党建活动管理、活动报名管理、问卷调查管理、问卷回答管理、民主投票管理、投票信息管理、试题管理、学习测试管理、系统管理、考试管理等进行操作。

 管理员点击党员管理。在党员页面输入党员账号和选择性别进查询、新增、删除、年龄分析或学历统计党员列表,并根据需要对党员详情信息进行详情操作。

 管理员点击党支部管理。在党支部页面输入支部账号进行查询、新增或删除党支部列表,并根据需要对党支部详情信息进行详情、修改或删除操作。

 管理员点击党建要闻管理。在党建要闻页面输入党建标题、简介进行查询、新增或删除党建要闻列表,并根据需要对党建要闻详情信息进行详情、查看评论、修改或删除操作。

 管理员点击党建地图管理。在党建地图页面输入地图名称进行查询、新增或删除党建地图列表,并根据需要对党建地图详情信息进行详情、查看评论、修改或删除操作。

 管理员点击学习心得管理。在学习心得页面输入资料编号、资料名称进行查询或删除学习心得列表,并根据需要对学习心得详情信息进行详情、修改或删除操作。

 管理员点击活动报名管理。在活动报名页面输入活动名称、党员姓名、支部名称、是否通过进行查询或删除活动报名列表,并根据需要对活动报名详情信息进行详情操作。

 管理员点击问卷调查管理。在问卷调查页面输入问卷标题进查询、新增、删除、年龄分析或学历统计问卷调查列表,并根据需要对问卷调查详情信息进行详情操作。

 管理员点击问卷回答管理。在问卷回答页面输入问卷标题进查询、删除或问卷回答统计问卷回答列表,并根据需要对问卷回答详情信息进行详情、修改或删除操作。

 管理员点击党建活动管理。在党建活动页面输入活动名称进查询、新增或删除党建活动列表,并根据需要对党建活动详情信息进行详情操作。

 管理员点击民主投票管理。在民主投票页面输入投票主题进查询、新增或删除民主投票列表,并根据需要对民主投票详情信息进行详情、修改或删除操作。

 党员进入系统可以对个人中心、学习心得管理、党费缴纳管理、活动报名管理、问卷回答管理、投票信息管理等功能进行操作。

 党支部进入系统可以对个人中心、党员管理、党费缴纳管理、党建活动管理、活动报名管理等功能进行操作。

4、数据库表结构设计

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

USE `springboot1i659`;

--
-- 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 `dangfeijiaona`
--

DROP TABLE IF EXISTS `dangfeijiaona`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dangfeijiaona` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '党员账号',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '党员姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `zhibuzhanghao` varchar(200) DEFAULT NULL COMMENT '支部账号',
  `zhibumingcheng` varchar(200) DEFAULT NULL COMMENT '支部名称',
  `dangfei` float DEFAULT NULL COMMENT '党费',
  `yuefen` varchar(200) DEFAULT NULL COMMENT '月份',
  `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='党费缴纳';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dangfeijiaona`
--

LOCK TABLES `dangfeijiaona` WRITE;
/*!40000 ALTER TABLE `dangfeijiaona` DISABLE KEYS */;
INSERT INTO `dangfeijiaona` VALUES (71,'2023-03-08 14:48:26','党员账号1','党员姓名1','性别1','13823888881','支部账号1','支部名称1',1,'月份1','未支付'),(72,'2023-03-08 14:48:26','党员账号2','党员姓名2','性别2','13823888882','支部账号2','支部名称2',2,'月份2','未支付'),(73,'2023-03-08 14:48:26','党员账号3','党员姓名3','性别3','13823888883','支部账号3','支部名称3',3,'月份3','未支付'),(74,'2023-03-08 14:48:26','党员账号4','党员姓名4','性别4','13823888884','支部账号4','支部名称4',4,'月份4','未支付'),(75,'2023-03-08 14:48:26','党员账号5','党员姓名5','性别5','13823888885','支部账号5','支部名称5',5,'月份5','未支付'),(76,'2023-03-08 14:48:26','党员账号6','党员姓名6','性别6','13823888886','支部账号6','支部名称6',6,'月份6','未支付'),(77,'2023-03-08 14:48:26','党员账号7','党员姓名7','性别7','13823888887','支部账号7','支部名称7',7,'月份7','未支付'),(78,'2023-03-08 14:48:26','党员账号8','党员姓名8','性别8','13823888888','支部账号8','支部名称8',8,'月份8','未支付');
/*!40000 ALTER TABLE `dangfeijiaona` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dangjianditu`
--

DROP TABLE IF EXISTS `dangjianditu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dangjianditu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ditumingcheng` varchar(200) DEFAULT NULL COMMENT '地图名称',
  `fengmian` longtext COMMENT '封面',
  `dituxiangqing` longtext COMMENT '地图详情',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='党建地图';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dangjianditu`
--

LOCK TABLES `dangjianditu` WRITE;
/*!40000 ALTER TABLE `dangjianditu` DISABLE KEYS */;
INSERT INTO `dangjianditu` VALUES (41,'2023-03-08 14:48:26','地图名称1','upload/dangjianditu_fengmian1.jpg,upload/dangjianditu_fengmian2.jpg,upload/dangjianditu_fengmian3.jpg','地图详情1','2023-03-08 22:48:26'),(42,'2023-03-08 14:48:26','地图名称2','upload/dangjianditu_fengmian2.jpg,upload/dangjianditu_fengmian3.jpg,upload/dangjianditu_fengmian4.jpg','地图详情2','2023-03-08 22:48:26'),(43,'2023-03-08 14:48:26','地图名称3','upload/dangjianditu_fengmian3.jpg,upload/dangjianditu_fengmian4.jpg,upload/dangjianditu_fengmian5.jpg','地图详情3','2023-03-08 22:48:26'),(44,'2023-03-08 14:48:26','地图名称4','upload/dangjianditu_fengmian4.jpg,upload/dangjianditu_fengmian5.jpg,upload/dangjianditu_fengmian6.jpg','地图详情4','2023-03-08 22:48:26'),(45,'2023-03-08 14:48:26','地图名称5','upload/dangjianditu_fengmian5.jpg,upload/dangjianditu_fengmian6.jpg,upload/dangjianditu_fengmian7.jpg','地图详情5','2023-03-08 22:48:26'),(46,'2023-03-08 14:48:26','地图名称6','upload/dangjianditu_fengmian6.jpg,upload/dangjianditu_fengmian7.jpg,upload/dangjianditu_fengmian8.jpg','地图详情6','2023-03-08 22:48:26'),(47,'2023-03-08 14:48:26','地图名称7','upload/dangjianditu_fengmian7.jpg,upload/dangjianditu_fengmian8.jpg,upload/dangjianditu_fengmian9.jpg','地图详情7','2023-03-08 22:48:26'),(48,'2023-03-08 14:48:26','地图名称8','upload/dangjianditu_fengmian8.jpg,upload/dangjianditu_fengmian9.jpg,upload/dangjianditu_fengmian10.jpg','地图详情8','2023-03-08 22:48:26');
/*!40000 ALTER TABLE `dangjianditu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dangjianhuodong`
--

DROP TABLE IF EXISTS `dangjianhuodong`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dangjianhuodong` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活动名称',
  `huodongtupian` longtext COMMENT '活动图片',
  `huodongdidian` varchar(200) DEFAULT NULL COMMENT '活动地点',
  `huodongshijian` datetime DEFAULT NULL COMMENT '活动时间',
  `huodongrenshu` varchar(200) DEFAULT NULL COMMENT '活动人数',
  `huodongneirong` longtext COMMENT '活动内容',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  `zhibuzhanghao` varchar(200) DEFAULT NULL COMMENT '支部账号',
  `zhibumingcheng` varchar(200) DEFAULT NULL COMMENT '支部名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='党建活动';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dangjianhuodong`
--

LOCK TABLES `dangjianhuodong` WRITE;
/*!40000 ALTER TABLE `dangjianhuodong` DISABLE KEYS */;
INSERT INTO `dangjianhuodong` VALUES (81,'2023-03-08 14:48:26','活动名称1','upload/dangjianhuodong_huodongtupian1.jpg,upload/dangjianhuodong_huodongtupian2.jpg,upload/dangjianhuodong_huodongtupian3.jpg','活动地点1','2023-03-08 22:48:26','活动人数1','活动内容1','2023-03-08 22:48:26','支部账号1','支部名称1'),(82,'2023-03-08 14:48:26','活动名称2','upload/dangjianhuodong_huodongtupian2.jpg,upload/dangjianhuodong_huodongtupian3.jpg,upload/dangjianhuodong_huodongtupian4.jpg','活动地点2','2023-03-08 22:48:26','活动人数2','活动内容2','2023-03-08 22:48:26','支部账号2','支部名称2'),(83,'2023-03-08 14:48:26','活动名称3','upload/dangjianhuodong_huodongtupian3.jpg,upload/dangjianhuodong_huodongtupian4.jpg,upload/dangjianhuodong_huodongtupian5.jpg','活动地点3','2023-03-08 22:48:26','活动人数3','活动内容3','2023-03-08 22:48:26','支部账号3','支部名称3'),(84,'2023-03-08 14:48:26','活动名称4','upload/dangjianhuodong_huodongtupian4.jpg,upload/dangjianhuodong_huodongtupian5.jpg,upload/dangjianhuodong_huodongtupian6.jpg','活动地点4','2023-03-08 22:48:26','活动人数4','活动内容4','2023-03-08 22:48:26','支部账号4','支部名称4'),(85,'2023-03-08 14:48:26','活动名称5','upload/dangjianhuodong_huodongtupian5.jpg,upload/dangjianhuodong_huodongtupian6.jpg,upload/dangjianhuodong_huodongtupian7.jpg','活动地点5','2023-03-08 22:48:26','活动人数5','活动内容5','2023-03-08 22:48:26','支部账号5','支部名称5'),(86,'2023-03-08 14:48:26','活动名称6','upload/dangjianhuodong_huodongtupian6.jpg,upload/dangjianhuodong_huodongtupian7.jpg,upload/dangjianhuodong_huodongtupian8.jpg','活动地点6','2023-03-08 22:48:26','活动人数6','活动内容6','2023-03-08 22:48:26','支部账号6','支部名称6'),(87,'2023-03-08 14:48:26','活动名称7','upload/dangjianhuodong_huodongtupian7.jpg,upload/dangjianhuodong_huodongtupian8.jpg,upload/dangjianhuodong_huodongtupian9.jpg','活动地点7','2023-03-08 22:48:26','活动人数7','活动内容7','2023-03-08 22:48:26','支部账号7','支部名称7'),(88,'2023-03-08 14:48:26','活动名称8','upload/dangjianhuodong_huodongtupian8.jpg,upload/dangjianhuodong_huodongtupian9.jpg,upload/dangjianhuodong_huodongtupian10.jpg','活动地点8','2023-03-08 22:48:26','活动人数8','活动内容8','2023-03-08 22:48:26','支部账号8','支部名称8');
/*!40000 ALTER TABLE `dangjianhuodong` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dangjianxuexi`
--

DROP TABLE IF EXISTS `dangjianxuexi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dangjianxuexi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ziliaobianhao` varchar(200) NOT NULL COMMENT '资料编号',
  `ziliaomingcheng` varchar(200) NOT NULL COMMENT '资料名称',
  `tupian` longtext COMMENT '图片',
  `ziliaojianjie` longtext COMMENT '资料简介',
  `shipin` longtext COMMENT '视频',
  `fujianxiazai` longtext COMMENT '附件下载',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ziliaobianhao` (`ziliaobianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='党建学习';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dangjianxuexi`
--

LOCK TABLES `dangjianxuexi` WRITE;
/*!40000 ALTER TABLE `dangjianxuexi` DISABLE KEYS */;
INSERT INTO `dangjianxuexi` VALUES (51,'2023-03-08 14:48:26','1111111111','资料名称1','upload/dangjianxuexi_tupian1.jpg,upload/dangjianxuexi_tupian2.jpg,upload/dangjianxuexi_tupian3.jpg','资料简介1','','','2023-03-08 22:48:26'),(52,'2023-03-08 14:48:26','2222222222','资料名称2','upload/dangjianxuexi_tupian2.jpg,upload/dangjianxuexi_tupian3.jpg,upload/dangjianxuexi_tupian4.jpg','资料简介2','','','2023-03-08 22:48:26'),(53,'2023-03-08 14:48:26','3333333333','资料名称3','upload/dangjianxuexi_tupian3.jpg,upload/dangjianxuexi_tupian4.jpg,upload/dangjianxuexi_tupian5.jpg','资料简介3','','','2023-03-08 22:48:26'),(54,'2023-03-08 14:48:26','4444444444','资料名称4','upload/dangjianxuexi_tupian4.jpg,upload/dangjianxuexi_tupian5.jpg,upload/dangjianxuexi_tupian6.jpg','资料简介4','','','2023-03-08 22:48:26'),(55,'2023-03-08 14:48:26','5555555555','资料名称5','upload/dangjianxuexi_tupian5.jpg,upload/dangjianxuexi_tupian6.jpg,upload/dangjianxuexi_tupian7.jpg','资料简介5','','','2023-03-08 22:48:26'),(56,'2023-03-08 14:48:26','6666666666','资料名称6','upload/dangjianxuexi_tupian6.jpg,upload/dangjianxuexi_tupian7.jpg,upload/dangjianxuexi_tupian8.jpg','资料简介6','','','2023-03-08 22:48:26'),(57,'2023-03-08 14:48:26','7777777777','资料名称7','upload/dangjianxuexi_tupian7.jpg,upload/dangjianxuexi_tupian8.jpg,upload/dangjianxuexi_tupian9.jpg','资料简介7','','','2023-03-08 22:48:26'),(58,'2023-03-08 14:48:26','8888888888','资料名称8','upload/dangjianxuexi_tupian8.jpg,upload/dangjianxuexi_tupian9.jpg,upload/dangjianxuexi_tupian10.jpg','资料简介8','','','2023-03-08 22:48:26');
/*!40000 ALTER TABLE `dangjianxuexi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dangjianyaowen`
--

DROP TABLE IF EXISTS `dangjianyaowen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dangjianyaowen` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `dangjianbiaoti` varchar(200) NOT NULL COMMENT '党建标题',
  `fengmian` longtext COMMENT '封面',
  `jianjie` longtext COMMENT '简介',
  `shipin` longtext COMMENT '视频',
  `xiangqingneirong` longtext COMMENT '详情内容',
  `fabushijian` date DEFAULT NULL COMMENT '发布时间',
  `thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
  `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='党建要闻';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dangjianyaowen`
--

LOCK TABLES `dangjianyaowen` WRITE;
/*!40000 ALTER TABLE `dangjianyaowen` DISABLE KEYS */;
INSERT INTO `dangjianyaowen` VALUES (31,'2023-03-08 14:48:26','党建标题1','upload/dangjianyaowen_fengmian1.jpg,upload/dangjianyaowen_fengmian2.jpg,upload/dangjianyaowen_fengmian3.jpg','简介1','','详情内容1','2023-03-08',1,1),(32,'2023-03-08 14:48:26','党建标题2','upload/dangjianyaowen_fengmian2.jpg,upload/dangjianyaowen_fengmian3.jpg,upload/dangjianyaowen_fengmian4.jpg','简介2','','详情内容2','2023-03-08',2,2),(33,'2023-03-08 14:48:26','党建标题3','upload/dangjianyaowen_fengmian3.jpg,upload/dangjianyaowen_fengmian4.jpg,upload/dangjianyaowen_fengmian5.jpg','简介3','','详情内容3','2023-03-08',3,3),(34,'2023-03-08 14:48:26','党建标题4','upload/dangjianyaowen_fengmian4.jpg,upload/dangjianyaowen_fengmian5.jpg,upload/dangjianyaowen_fengmian6.jpg','简介4','','详情内容4','2023-03-08',4,4),(35,'2023-03-08 14:48:26','党建标题5','upload/dangjianyaowen_fengmian5.jpg,upload/dangjianyaowen_fengmian6.jpg,upload/dangjianyaowen_fengmian7.jpg','简介5','','详情内容5','2023-03-08',5,5),(36,'2023-03-08 14:48:26','党建标题6','upload/dangjianyaowen_fengmian6.jpg,upload/dangjianyaowen_fengmian7.jpg,upload/dangjianyaowen_fengmian8.jpg','简介6','','详情内容6','2023-03-08',6,6),(37,'2023-03-08 14:48:26','党建标题7','upload/dangjianyaowen_fengmian7.jpg,upload/dangjianyaowen_fengmian8.jpg,upload/dangjianyaowen_fengmian9.jpg','简介7','','详情内容7','2023-03-08',7,7),(38,'2023-03-08 14:48:26','党建标题8','upload/dangjianyaowen_fengmian8.jpg,upload/dangjianyaowen_fengmian9.jpg,upload/dangjianyaowen_fengmian10.jpg','简介8','','详情内容8','2023-03-08',8,8);
/*!40000 ALTER TABLE `dangjianyaowen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dangyuan`
--

DROP TABLE IF EXISTS `dangyuan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dangyuan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `dangyuanzhanghao` varchar(200) NOT NULL COMMENT '党员账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '党员姓名',
  `touxiang` longtext COMMENT '头像',
  `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `nianling` int(11) DEFAULT NULL COMMENT '年龄',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `xueli` varchar(200) DEFAULT NULL COMMENT '学历',
  `shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份证号',
  `rudangshijian` date DEFAULT NULL COMMENT '入党时间',
  `zhibuzhanghao` varchar(200) DEFAULT NULL COMMENT '支部账号',
  `zhibumingcheng` varchar(200) DEFAULT NULL COMMENT '支部名称',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dangyuanzhanghao` (`dangyuanzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='党员';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dangyuan`
--

LOCK TABLES `dangyuan` WRITE;
/*!40000 ALTER TABLE `dangyuan` DISABLE KEYS */;
INSERT INTO `dangyuan` VALUES (11,'2023-03-08 14:48:26','党员账号1','123456','党员姓名1','upload/dangyuan_touxiang1.jpg','13823888881',1,'男','学历1','440300199101010001','2023-03-08','支部账号1','支部名称1'),(12,'2023-03-08 14:48:26','党员账号2','123456','党员姓名2','upload/dangyuan_touxiang2.jpg','13823888882',2,'男','学历2','440300199202020002','2023-03-08','支部账号2','支部名称2'),(13,'2023-03-08 14:48:26','党员账号3','123456','党员姓名3','upload/dangyuan_touxiang3.jpg','13823888883',3,'男','学历3','440300199303030003','2023-03-08','支部账号3','支部名称3'),(14,'2023-03-08 14:48:26','党员账号4','123456','党员姓名4','upload/dangyuan_touxiang4.jpg','13823888884',4,'男','学历4','440300199404040004','2023-03-08','支部账号4','支部名称4'),(15,'2023-03-08 14:48:26','党员账号5','123456','党员姓名5','upload/dangyuan_touxiang5.jpg','13823888885',5,'男','学历5','440300199505050005','2023-03-08','支部账号5','支部名称5'),(16,'2023-03-08 14:48:26','党员账号6','123456','党员姓名6','upload/dangyuan_touxiang6.jpg','13823888886',6,'男','学历6','440300199606060006','2023-03-08','支部账号6','支部名称6'),(17,'2023-03-08 14:48:26','党员账号7','123456','党员姓名7','upload/dangyuan_touxiang7.jpg','13823888887',7,'男','学历7','440300199707070007','2023-03-08','支部账号7','支部名称7'),(18,'2023-03-08 14:48:26','党员账号8','123456','党员姓名8','upload/dangyuan_touxiang8.jpg','13823888888',8,'男','学历8','440300199808080008','2023-03-08','支部账号8','支部名称8');
/*!40000 ALTER TABLE `dangyuan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dangzhibu`
--

DROP TABLE IF EXISTS `dangzhibu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dangzhibu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhibuzhanghao` varchar(200) NOT NULL COMMENT '支部账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `zhibumingcheng` varchar(200) NOT NULL COMMENT '支部名称',
  `fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `zhibudizhi` varchar(200) DEFAULT NULL COMMENT '支部地址',
  PRIMARY KEY (`id`),
  UNIQUE KEY `zhibuzhanghao` (`zhibuzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='党支部';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dangzhibu`
--

LOCK TABLES `dangzhibu` WRITE;
/*!40000 ALTER TABLE `dangzhibu` DISABLE KEYS */;
INSERT INTO `dangzhibu` VALUES (21,'2023-03-08 14:48:26','支部账号1','123456','支部名称1','负责人1','13823888881','支部地址1'),(22,'2023-03-08 14:48:26','支部账号2','123456','支部名称2','负责人2','13823888882','支部地址2'),(23,'2023-03-08 14:48:26','支部账号3','123456','支部名称3','负责人3','13823888883','支部地址3'),(24,'2023-03-08 14:48:26','支部账号4','123456','支部名称4','负责人4','13823888884','支部地址4'),(25,'2023-03-08 14:48:26','支部账号5','123456','支部名称5','负责人5','13823888885','支部地址5'),(26,'2023-03-08 14:48:26','支部账号6','123456','支部名称6','负责人6','13823888886','支部地址6'),(27,'2023-03-08 14:48:26','支部账号7','123456','支部名称7','负责人7','13823888887','支部地址7'),(28,'2023-03-08 14:48:26','支部账号8','123456','支部名称8','负责人8','13823888888','支部地址8');
/*!40000 ALTER TABLE `dangzhibu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussdangjianditu`
--

DROP TABLE IF EXISTS `discussdangjianditu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdangjianditu` (
  `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',
  `avatarurl` longtext COMMENT '头像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='党建地图评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussdangjianditu`
--

LOCK TABLES `discussdangjianditu` WRITE;
/*!40000 ALTER TABLE `discussdangjianditu` DISABLE KEYS */;
/*!40000 ALTER TABLE `discussdangjianditu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussdangjianxuexi`
--

DROP TABLE IF EXISTS `discussdangjianxuexi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdangjianxuexi` (
  `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',
  `avatarurl` longtext COMMENT '头像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='党建学习评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussdangjianxuexi`
--

LOCK TABLES `discussdangjianxuexi` WRITE;
/*!40000 ALTER TABLE `discussdangjianxuexi` DISABLE KEYS */;
/*!40000 ALTER TABLE `discussdangjianxuexi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussdangjianyaowen`
--

DROP TABLE IF EXISTS `discussdangjianyaowen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdangjianyaowen` (
  `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',
  `avatarurl` longtext COMMENT '头像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='党建要闻评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussdangjianyaowen`
--

LOCK TABLES `discussdangjianyaowen` WRITE;
/*!40000 ALTER TABLE `discussdangjianyaowen` DISABLE KEYS */;
/*!40000 ALTER TABLE `discussdangjianyaowen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `exampaper`
--

DROP TABLE IF EXISTS `exampaper`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `exampaper` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `name` varchar(200) NOT NULL COMMENT '学习测试名称',
  `time` int(11) NOT NULL COMMENT '考试时长(分钟)',
  `status` int(11) NOT NULL DEFAULT '0' 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 `exampaper`
--

LOCK TABLES `exampaper` WRITE;
/*!40000 ALTER TABLE `exampaper` DISABLE KEYS */;
INSERT INTO `exampaper` VALUES (1,'2023-03-08 14:48:27','十万个为什么',60,1);
/*!40000 ALTER TABLE `exampaper` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `examquestion`
--

DROP TABLE IF EXISTS `examquestion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `examquestion` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `paperid` bigint(20) NOT NULL COMMENT '所属学习测试id(外键)',
  `papername` varchar(200) NOT NULL COMMENT '学习测试名称',
  `questionname` varchar(200) NOT NULL COMMENT '试题名称',
  `options` longtext COMMENT '选项,json字符串',
  `score` bigint(20) DEFAULT '0' COMMENT '分值',
  `answer` varchar(200) DEFAULT NULL COMMENT '正确答案',
  `analysis` longtext COMMENT '答案解析',
  `type` bigint(20) DEFAULT '0' COMMENT '试题类型,0:单选题 1:多选题 2:判断题 3:填空题(暂不考虑多项填空)',
  `sequence` bigint(20) DEFAULT '100' COMMENT '试题排序,值越大排越前面',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='试题表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `examquestion`
--

LOCK TABLES `examquestion` WRITE;
/*!40000 ALTER TABLE `examquestion` DISABLE KEYS */;
INSERT INTO `examquestion` VALUES (1,'2023-03-08 14:48:27',1,'十万个为什么','下面动物不属于昆虫的是()。','[{\"text\":\"A.苍蝇\",\"code\":\"A\"},{\"text\":\"B.蜜蜂\",\"code\":\"B\"},{\"text\":\"C.蜂鸟\",\"code\":\"C\"}]',20,'C','蜂鸟',0,1),(2,'2023-03-08 14:48:27',1,'十万个为什么','油着火后可以用水扑灭。','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',20,'B','油着火后不可以用水扑灭',2,2),(3,'2023-03-08 14:48:27',1,'十万个为什么','地球是个球体,中间是( )。','[]',30,'赤道','赤道',3,3),(4,'2023-03-08 14:48:27',1,'十万个为什么','下面动物中会流汗的有( )。','[{\"text\":\"A.马\",\"code\":\"A\"},{\"text\":\"B.猫\",\"code\":\"B\"},{\"text\":\"C.狗\",\"code\":\"C\"}]',30,'A,B','狗不会流汗',1,4);
/*!40000 ALTER TABLE `examquestion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `examrecord`
--

DROP TABLE IF EXISTS `examrecord`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `examrecord` (
  `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 '用户名',
  `paperid` bigint(20) NOT NULL COMMENT '学习测试id(外键)',
  `papername` varchar(200) NOT NULL COMMENT '学习测试名称',
  `questionid` bigint(20) NOT NULL COMMENT '试题id(外键)',
  `questionname` varchar(200) NOT NULL COMMENT '试题名称',
  `options` longtext COMMENT '选项,json字符串',
  `score` bigint(20) DEFAULT '0' COMMENT '分值',
  `answer` varchar(200) DEFAULT NULL COMMENT '正确答案',
  `analysis` longtext COMMENT '答案解析',
  `myscore` bigint(20) NOT NULL DEFAULT '0' COMMENT '试题得分',
  `myanswer` 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 `examrecord`
--

LOCK TABLES `examrecord` WRITE;
/*!40000 ALTER TABLE `examrecord` DISABLE KEYS */;
/*!40000 ALTER TABLE `examrecord` 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 '活动名称',
  `huodongdidian` varchar(200) DEFAULT NULL COMMENT '活动地点',
  `huodongshijian` varchar(200) DEFAULT NULL COMMENT '活动时间',
  `baomingshijian` datetime DEFAULT NULL COMMENT '报名时间',
  `beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '党员账号',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '党员姓名',
  `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `zhibuzhanghao` varchar(200) DEFAULT NULL COMMENT '支部账号',
  `zhibumingcheng` varchar(200) DEFAULT NULL COMMENT '支部名称',
  `crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
  `crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
  `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 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 (91,'2023-03-08 14:48:26','活动名称1','活动地点1','活动时间1','2023-03-08 22:48:26','备注1','党员账号1','党员姓名1','联系方式1','支部账号1','支部名称1',1,1,'是',''),(92,'2023-03-08 14:48:26','活动名称2','活动地点2','活动时间2','2023-03-08 22:48:26','备注2','党员账号2','党员姓名2','联系方式2','支部账号2','支部名称2',2,2,'是',''),(93,'2023-03-08 14:48:26','活动名称3','活动地点3','活动时间3','2023-03-08 22:48:26','备注3','党员账号3','党员姓名3','联系方式3','支部账号3','支部名称3',3,3,'是',''),(94,'2023-03-08 14:48:26','活动名称4','活动地点4','活动时间4','2023-03-08 22:48:26','备注4','党员账号4','党员姓名4','联系方式4','支部账号4','支部名称4',4,4,'是',''),(95,'2023-03-08 14:48:26','活动名称5','活动地点5','活动时间5','2023-03-08 22:48:26','备注5','党员账号5','党员姓名5','联系方式5','支部账号5','支部名称5',5,5,'是',''),(96,'2023-03-08 14:48:26','活动名称6','活动地点6','活动时间6','2023-03-08 22:48:26','备注6','党员账号6','党员姓名6','联系方式6','支部账号6','支部名称6',6,6,'是',''),(97,'2023-03-08 14:48:26','活动名称7','活动地点7','活动时间7','2023-03-08 22:48:26','备注7','党员账号7','党员姓名7','联系方式7','支部账号7','支部名称7',7,7,'是',''),(98,'2023-03-08 14:48:26','活动名称8','活动地点8','活动时间8','2023-03-08 22:48:26','备注8','党员账号8','党员姓名8','联系方式8','支部账号8','支部名称8',8,8,'是','');
/*!40000 ALTER TABLE `huodongbaoming` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `minzhutoupiao`
--

DROP TABLE IF EXISTS `minzhutoupiao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `minzhutoupiao` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `toupiaozhuti` varchar(200) NOT NULL COMMENT '投票主题',
  `fengmian` longtext COMMENT '封面',
  `xuanxianga` int(11) DEFAULT NULL COMMENT '选项a',
  `xuanxiangb` int(11) DEFAULT NULL COMMENT '选项b',
  `xuanxiangc` int(11) DEFAULT NULL COMMENT '选项c',
  `xuanxiangd` int(11) DEFAULT NULL COMMENT '选项d',
  `toupiaoneirong` longtext COMMENT '投票内容',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  `reversetime` datetime DEFAULT NULL COMMENT '倒计结束时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COMMENT='民主投票';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `minzhutoupiao`
--

LOCK TABLES `minzhutoupiao` WRITE;
/*!40000 ALTER TABLE `minzhutoupiao` DISABLE KEYS */;
INSERT INTO `minzhutoupiao` VALUES (121,'2023-03-08 14:48:26','投票主题1','upload/minzhutoupiao_fengmian1.jpg,upload/minzhutoupiao_fengmian2.jpg,upload/minzhutoupiao_fengmian3.jpg',1,1,1,1,'投票内容1','2023-03-08 22:48:26','2023-03-09 00:00:00'),(122,'2023-03-08 14:48:26','投票主题2','upload/minzhutoupiao_fengmian2.jpg,upload/minzhutoupiao_fengmian3.jpg,upload/minzhutoupiao_fengmian4.jpg',2,2,2,2,'投票内容2','2023-03-08 22:48:26','2023-03-09 00:00:00'),(123,'2023-03-08 14:48:26','投票主题3','upload/minzhutoupiao_fengmian3.jpg,upload/minzhutoupiao_fengmian4.jpg,upload/minzhutoupiao_fengmian5.jpg',3,3,3,3,'投票内容3','2023-03-08 22:48:26','2023-03-09 00:00:00'),(124,'2023-03-08 14:48:26','投票主题4','upload/minzhutoupiao_fengmian4.jpg,upload/minzhutoupiao_fengmian5.jpg,upload/minzhutoupiao_fengmian6.jpg',4,4,4,4,'投票内容4','2023-03-08 22:48:26','2023-03-09 00:00:00'),(125,'2023-03-08 14:48:26','投票主题5','upload/minzhutoupiao_fengmian5.jpg,upload/minzhutoupiao_fengmian6.jpg,upload/minzhutoupiao_fengmian7.jpg',5,5,5,5,'投票内容5','2023-03-08 22:48:26','2023-03-09 00:00:00'),(126,'2023-03-08 14:48:26','投票主题6','upload/minzhutoupiao_fengmian6.jpg,upload/minzhutoupiao_fengmian7.jpg,upload/minzhutoupiao_fengmian8.jpg',6,6,6,6,'投票内容6','2023-03-08 22:48:26','2023-03-09 00:00:00'),(127,'2023-03-08 14:48:26','投票主题7','upload/minzhutoupiao_fengmian7.jpg,upload/minzhutoupiao_fengmian8.jpg,upload/minzhutoupiao_fengmian9.jpg',7,7,7,7,'投票内容7','2023-03-08 22:48:26','2023-03-09 00:00:00'),(128,'2023-03-08 14:48:26','投票主题8','upload/minzhutoupiao_fengmian8.jpg,upload/minzhutoupiao_fengmian9.jpg,upload/minzhutoupiao_fengmian10.jpg',8,8,8,8,'投票内容8','2023-03-08 22:48:26','2023-03-09 00:00:00');
/*!40000 ALTER TABLE `minzhutoupiao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- 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` longtext NOT NULL COMMENT '图片',
  `type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩,31:竞拍参与,41:关注)',
  `inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
  `remark` 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 `toupiaoxinxi`
--

DROP TABLE IF EXISTS `toupiaoxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `toupiaoxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '党员账号',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '党员姓名',
  `toupiaozhuti` varchar(200) DEFAULT NULL COMMENT '投票主题',
  `xuanxianga` int(11) DEFAULT NULL COMMENT '选项a',
  `xuanxiangb` int(11) DEFAULT NULL COMMENT '选项b',
  `xuanxiangc` int(11) DEFAULT NULL COMMENT '选项c',
  `xuanxiangd` int(11) DEFAULT NULL COMMENT '选项d',
  `toupiaoshijian` datetime DEFAULT NULL COMMENT '投票时间',
  `crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
  `crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8 COMMENT='投票信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `toupiaoxinxi`
--

LOCK TABLES `toupiaoxinxi` WRITE;
/*!40000 ALTER TABLE `toupiaoxinxi` DISABLE KEYS */;
INSERT INTO `toupiaoxinxi` VALUES (131,'2023-03-08 14:48:26','党员账号1','党员姓名1','投票主题1',1,1,1,1,'2023-03-08 22:48:26',1,1),(132,'2023-03-08 14:48:26','党员账号2','党员姓名2','投票主题2',1,1,1,1,'2023-03-08 22:48:26',2,2),(133,'2023-03-08 14:48:26','党员账号3','党员姓名3','投票主题3',1,1,1,1,'2023-03-08 22:48:26',3,3),(134,'2023-03-08 14:48:26','党员账号4','党员姓名4','投票主题4',1,1,1,1,'2023-03-08 22:48:26',4,4),(135,'2023-03-08 14:48:26','党员账号5','党员姓名5','投票主题5',1,1,1,1,'2023-03-08 22:48:26',5,5),(136,'2023-03-08 14:48:26','党员账号6','党员姓名6','投票主题6',1,1,1,1,'2023-03-08 22:48:26',6,6),(137,'2023-03-08 14:48:26','党员账号7','党员姓名7','投票主题7',1,1,1,1,'2023-03-08 22:48:26',7,7),(138,'2023-03-08 14:48:26','党员账号8','党员姓名8','投票主题8',1,1,1,1,'2023-03-08 22:48:26',8,8);
/*!40000 ALTER TABLE `toupiaoxinxi` 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,'admin','admin','管理员','2023-03-08 14:48:27');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wenjuandiaocha`
--

DROP TABLE IF EXISTS `wenjuandiaocha`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wenjuandiaocha` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `wenjuanbiaoti` varchar(200) NOT NULL COMMENT '问卷标题',
  `tupian` longtext COMMENT '图片',
  `wenjuanneirong` longtext NOT NULL COMMENT '问卷内容',
  `daanyi` varchar(200) NOT NULL COMMENT '答案一',
  `daaner` varchar(200) NOT NULL COMMENT '答案二',
  `daansan` varchar(200) NOT NULL COMMENT '答案三',
  `daansi` varchar(200) NOT NULL COMMENT '答案四',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='问卷调查';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wenjuandiaocha`
--

LOCK TABLES `wenjuandiaocha` WRITE;
/*!40000 ALTER TABLE `wenjuandiaocha` DISABLE KEYS */;
INSERT INTO `wenjuandiaocha` VALUES (101,'2023-03-08 14:48:26','问卷标题1','upload/wenjuandiaocha_tupian1.jpg,upload/wenjuandiaocha_tupian2.jpg,upload/wenjuandiaocha_tupian3.jpg','问卷内容1','答案一1','答案二1','答案三1','答案四1','2023-03-08 22:48:26'),(102,'2023-03-08 14:48:26','问卷标题2','upload/wenjuandiaocha_tupian2.jpg,upload/wenjuandiaocha_tupian3.jpg,upload/wenjuandiaocha_tupian4.jpg','问卷内容2','答案一2','答案二2','答案三2','答案四2','2023-03-08 22:48:26'),(103,'2023-03-08 14:48:26','问卷标题3','upload/wenjuandiaocha_tupian3.jpg,upload/wenjuandiaocha_tupian4.jpg,upload/wenjuandiaocha_tupian5.jpg','问卷内容3','答案一3','答案二3','答案三3','答案四3','2023-03-08 22:48:26'),(104,'2023-03-08 14:48:26','问卷标题4','upload/wenjuandiaocha_tupian4.jpg,upload/wenjuandiaocha_tupian5.jpg,upload/wenjuandiaocha_tupian6.jpg','问卷内容4','答案一4','答案二4','答案三4','答案四4','2023-03-08 22:48:26'),(105,'2023-03-08 14:48:26','问卷标题5','upload/wenjuandiaocha_tupian5.jpg,upload/wenjuandiaocha_tupian6.jpg,upload/wenjuandiaocha_tupian7.jpg','问卷内容5','答案一5','答案二5','答案三5','答案四5','2023-03-08 22:48:26'),(106,'2023-03-08 14:48:26','问卷标题6','upload/wenjuandiaocha_tupian6.jpg,upload/wenjuandiaocha_tupian7.jpg,upload/wenjuandiaocha_tupian8.jpg','问卷内容6','答案一6','答案二6','答案三6','答案四6','2023-03-08 22:48:26'),(107,'2023-03-08 14:48:26','问卷标题7','upload/wenjuandiaocha_tupian7.jpg,upload/wenjuandiaocha_tupian8.jpg,upload/wenjuandiaocha_tupian9.jpg','问卷内容7','答案一7','答案二7','答案三7','答案四7','2023-03-08 22:48:26'),(108,'2023-03-08 14:48:26','问卷标题8','upload/wenjuandiaocha_tupian8.jpg,upload/wenjuandiaocha_tupian9.jpg,upload/wenjuandiaocha_tupian10.jpg','问卷内容8','答案一8','答案二8','答案三8','答案四8','2023-03-08 22:48:26');
/*!40000 ALTER TABLE `wenjuandiaocha` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wenjuanhuida`
--

DROP TABLE IF EXISTS `wenjuanhuida`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wenjuanhuida` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `wenjuanbiaoti` varchar(200) DEFAULT NULL COMMENT '问卷标题',
  `wenjuanhuida` varchar(200) NOT NULL COMMENT '问卷回答',
  `diaochashijian` datetime DEFAULT NULL COMMENT '调查时间',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '党员账号',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '党员姓名',
  `crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
  `crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COMMENT='问卷回答';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wenjuanhuida`
--

LOCK TABLES `wenjuanhuida` WRITE;
/*!40000 ALTER TABLE `wenjuanhuida` DISABLE KEYS */;
INSERT INTO `wenjuanhuida` VALUES (111,'2023-03-08 14:48:26','问卷标题1','答案一','2023-03-08 22:48:26','党员账号1','党员姓名1',1,1),(112,'2023-03-08 14:48:26','问卷标题2','答案一','2023-03-08 22:48:26','党员账号2','党员姓名2',2,2),(113,'2023-03-08 14:48:26','问卷标题3','答案一','2023-03-08 22:48:26','党员账号3','党员姓名3',3,3),(114,'2023-03-08 14:48:26','问卷标题4','答案一','2023-03-08 22:48:26','党员账号4','党员姓名4',4,4),(115,'2023-03-08 14:48:26','问卷标题5','答案一','2023-03-08 22:48:26','党员账号5','党员姓名5',5,5),(116,'2023-03-08 14:48:26','问卷标题6','答案一','2023-03-08 22:48:26','党员账号6','党员姓名6',6,6),(117,'2023-03-08 14:48:26','问卷标题7','答案一','2023-03-08 22:48:26','党员账号7','党员姓名7',7,7),(118,'2023-03-08 14:48:26','问卷标题8','答案一','2023-03-08 22:48:26','党员账号8','党员姓名8',8,8);
/*!40000 ALTER TABLE `wenjuanhuida` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xuexixinde`
--

DROP TABLE IF EXISTS `xuexixinde`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuexixinde` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ziliaobianhao` varchar(200) DEFAULT NULL COMMENT '资料编号',
  `ziliaomingcheng` varchar(200) DEFAULT NULL COMMENT '资料名称',
  `xuexixinde` longtext NOT NULL COMMENT '学习心得',
  `xuexishijian` datetime DEFAULT NULL COMMENT '学习时间',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '党员账号',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '党员姓名',
  `crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
  `crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='学习心得';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xuexixinde`
--

LOCK TABLES `xuexixinde` WRITE;
/*!40000 ALTER TABLE `xuexixinde` DISABLE KEYS */;
INSERT INTO `xuexixinde` VALUES (61,'2023-03-08 14:48:26','资料编号1','资料名称1','学习心得1','2023-03-08 22:48:26','党员账号1','党员姓名1',1,1),(62,'2023-03-08 14:48:26','资料编号2','资料名称2','学习心得2','2023-03-08 22:48:26','党员账号2','党员姓名2',2,2),(63,'2023-03-08 14:48:26','资料编号3','资料名称3','学习心得3','2023-03-08 22:48:26','党员账号3','党员姓名3',3,3),(64,'2023-03-08 14:48:26','资料编号4','资料名称4','学习心得4','2023-03-08 22:48:26','党员账号4','党员姓名4',4,4),(65,'2023-03-08 14:48:26','资料编号5','资料名称5','学习心得5','2023-03-08 22:48:26','党员账号5','党员姓名5',5,5),(66,'2023-03-08 14:48:26','资料编号6','资料名称6','学习心得6','2023-03-08 22:48:26','党员账号6','党员姓名6',6,6),(67,'2023-03-08 14:48:26','资料编号7','资料名称7','学习心得7','2023-03-08 22:48:26','党员账号7','党员姓名7',7,7),(68,'2023-03-08 14:48:26','资料编号8','资料名称8','学习心得8','2023-03-08 22:48:26','党员账号8','党员姓名8',8,8);
/*!40000 ALTER TABLE `xuexixinde` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-10-15 20:21:50

5、关键代码

 5.1 党费缴纳管理Controller模块 

package com.controller;
import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
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.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;
import com.entity.DangfeijiaonaEntity;
import com.entity.view.DangfeijiaonaView;
import com.service.DangfeijiaonaService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
import java.io.IOException;

/**
 * 党费缴纳
 * 后端接口
 * @author 
 * @email 
 */
@RestController
@RequestMapping("/dangfeijiaona")
public class DangfeijiaonaController {
    @Autowired
    private DangfeijiaonaService dangfeijiaonaService;
/**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,DangfeijiaonaEntity dangfeijiaona,
		HttpServletRequest request){
		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("dangyuan")) {
			dangfeijiaona.setDangyuanzhanghao((String)request.getSession().getAttribute("username"));
		}
		if(tableName.equals("dangzhibu")) {
			dangfeijiaona.setZhibuzhanghao((String)request.getSession().getAttribute("username"));
		}
        EntityWrapper<DangfeijiaonaEntity> ew = new EntityWrapper<DangfeijiaonaEntity>();

		PageUtils page = dangfeijiaonaService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, dangfeijiaona), params), params));

        return R.ok().put("data", page);
    }
    
    /**
     * 前端列表
     */
	@IgnoreAuth
    @RequestMapping("/list")
    public R list(@RequestParam Map<String, Object> params,DangfeijiaonaEntity dangfeijiaona, 
		HttpServletRequest request){
        EntityWrapper<DangfeijiaonaEntity> ew = new EntityWrapper<DangfeijiaonaEntity>();

		PageUtils page = dangfeijiaonaService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, dangfeijiaona), params), params));
        return R.ok().put("data", page);
    }

	/**
     * 列表
     */
    @RequestMapping("/lists")
    public R list( DangfeijiaonaEntity dangfeijiaona){
       	EntityWrapper<DangfeijiaonaEntity> ew = new EntityWrapper<DangfeijiaonaEntity>();
      	ew.allEq(MPUtil.allEQMapPre( dangfeijiaona, "dangfeijiaona")); 
        return R.ok().put("data", dangfeijiaonaService.selectListView(ew));
    }

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(DangfeijiaonaEntity dangfeijiaona){
        EntityWrapper< DangfeijiaonaEntity> ew = new EntityWrapper< DangfeijiaonaEntity>();
 		ew.allEq(MPUtil.allEQMapPre( dangfeijiaona, "dangfeijiaona")); 
		DangfeijiaonaView dangfeijiaonaView =  dangfeijiaonaService.selectView(ew);
		return R.ok("查询党费缴纳成功").put("data", dangfeijiaonaView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        DangfeijiaonaEntity dangfeijiaona = dangfeijiaonaService.selectById(id);
        return R.ok().put("data", dangfeijiaona);
    }

    /**
     * 前端详情
     */
	@IgnoreAuth
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") Long id){
        DangfeijiaonaEntity dangfeijiaona = dangfeijiaonaService.selectById(id);
        return R.ok().put("data", dangfeijiaona);
    }
 /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody DangfeijiaonaEntity dangfeijiaona, HttpServletRequest request){
    	dangfeijiaona.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(dangfeijiaona);
        dangfeijiaonaService.insert(dangfeijiaona);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody DangfeijiaonaEntity dangfeijiaona, HttpServletRequest request){
    	dangfeijiaona.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(dangfeijiaona);
        dangfeijiaonaService.insert(dangfeijiaona);
        return R.ok();
    }



    /**
     * 修改
     */
    @RequestMapping("/update")
    @Transactional
    public R update(@RequestBody DangfeijiaonaEntity dangfeijiaona, HttpServletRequest request){
        //ValidatorUtils.validateEntity(dangfeijiaona);
        dangfeijiaonaService.updateById(dangfeijiaona);//全部更新
        return R.ok();
    }
 /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        dangfeijiaonaService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
    
    /**
     * 提醒接口
     */
	@RequestMapping("/remind/{columnName}/{type}")
	public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, 
						 @PathVariable("type") String type,@RequestParam Map<String, Object> map) {
		map.put("column", columnName);
		map.put("type", type);
		
		if(type.equals("2")) {
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			Calendar c = Calendar.getInstance();
			Date remindStartDate = null;
			Date remindEndDate = null;
			if(map.get("remindstart")!=null) {
				Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
				c.setTime(new Date()); 
				c.add(Calendar.DAY_OF_MONTH,remindStart);
				remindStartDate = c.getTime();
				map.put("remindstart", sdf.format(remindStartDate));
			}
			if(map.get("remindend")!=null) {
				Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
				c.setTime(new Date());
				c.add(Calendar.DAY_OF_MONTH,remindEnd);
				remindEndDate = c.getTime();
				map.put("remindend", sdf.format(remindEndDate));
			}
		}
		
		Wrapper<DangfeijiaonaEntity> wrapper = new EntityWrapper<DangfeijiaonaEntity>();
		if(map.get("remindstart")!=null) {
			wrapper.ge(columnName, map.get("remindstart"));
		}
		if(map.get("remindend")!=null) {
			wrapper.le(columnName, map.get("remindend"));
		}

		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("dangyuan")) {
			wrapper.eq("dangyuanzhanghao", (String)request.getSession().getAttribute("username"));
		}
		if(tableName.equals("dangzhibu")) {
			wrapper.eq("zhibuzhanghao", (String)request.getSession().getAttribute("username"));
		}

		int count = dangfeijiaonaService.selectCount(wrapper);
		return R.ok().put("count", count);
	}
}

5.2 党费缴纳管理Service模块 

package com.service;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.service.IService;
import com.utils.PageUtils;
import com.entity.DangfeijiaonaEntity;
import java.util.List;
import java.util.Map;
import com.entity.vo.DangfeijiaonaVO;
import org.apache.ibatis.annotations.Param;
import com.entity.view.DangfeijiaonaView;

/**
 * 党费缴纳
 *
 * @author 
 * @email 
 */
public interface DangfeijiaonaService extends IService<DangfeijiaonaEntity> {

    PageUtils queryPage(Map<String, Object> params);
    
   	List<DangfeijiaonaVO> selectListVO(Wrapper<DangfeijiaonaEntity> wrapper);
   	
   	DangfeijiaonaVO selectVO(@Param("ew") Wrapper<DangfeijiaonaEntity> wrapper);
   	
   	List<DangfeijiaonaView> selectListView(Wrapper<DangfeijiaonaEntity> wrapper);
   	
   	DangfeijiaonaView selectView(@Param("ew") Wrapper<DangfeijiaonaEntity> wrapper);
   	
   	PageUtils queryPage(Map<String, Object> params,Wrapper<DangfeijiaonaEntity> wrapper);
  
}

 5.3 党费缴纳管理ServiceImpl模块

package com.service.impl;
import org.springframework.stereotype.Service;
import java.util.Map;
import java.util.List;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.utils.PageUtils;
import com.utils.Query;
import com.dao.DangfeijiaonaDao;
import com.entity.DangfeijiaonaEntity;
import com.service.DangfeijiaonaService;
import com.entity.vo.DangfeijiaonaVO;
import com.entity.view.DangfeijiaonaView;
@Service("dangfeijiaonaService")
public class DangfeijiaonaServiceImpl extends ServiceImpl<DangfeijiaonaDao, DangfeijiaonaEntity> implements DangfeijiaonaService {
		
    @Override
    public PageUtils queryPage(Map<String, Object> params) {
        Page<DangfeijiaonaEntity> page = this.selectPage(
                new Query<DangfeijiaonaEntity>(params).getPage(),
                new EntityWrapper<DangfeijiaonaEntity>()
        );
        return new PageUtils(page);
    }
    
    @Override
	public PageUtils queryPage(Map<String, Object> params, Wrapper<DangfeijiaonaEntity> wrapper) {
		  Page<DangfeijiaonaView> page =new Query<DangfeijiaonaView>(params).getPage();
	        page.setRecords(baseMapper.selectListView(page,wrapper));
	    	PageUtils pageUtil = new PageUtils(page);
	    	return pageUtil;
 	}
    
    @Override
	public List<DangfeijiaonaVO> selectListVO(Wrapper<DangfeijiaonaEntity> wrapper) {
 		return baseMapper.selectListVO(wrapper);
	}
	
	@Override
	public DangfeijiaonaVO selectVO(Wrapper<DangfeijiaonaEntity> wrapper) {
 		return baseMapper.selectVO(wrapper);
	}
	
	@Override
	public List<DangfeijiaonaView> selectListView(Wrapper<DangfeijiaonaEntity> wrapper) {
		return baseMapper.selectListView(wrapper);
	}

	@Override
	public DangfeijiaonaView selectView(Wrapper<DangfeijiaonaEntity> wrapper) {
		return baseMapper.selectView(wrapper);
	}
}

 5.4  党费缴纳管理Dao模块

package com.dao;
import com.entity.DangfeijiaonaEntity;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import java.util.List;
import java.util.Map;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.plugins.pagination.Pagination;
import org.apache.ibatis.annotations.Param;
import com.entity.vo.DangfeijiaonaVO;
import com.entity.view.DangfeijiaonaView;
/**
 * 党费缴纳
 * 
 * @author 
 * @email 
 */
public interface DangfeijiaonaDao extends BaseMapper<DangfeijiaonaEntity> {
	
	List<DangfeijiaonaVO> selectListVO(@Param("ew") Wrapper<DangfeijiaonaEntity> wrapper);
	
	DangfeijiaonaVO selectVO(@Param("ew") Wrapper<DangfeijiaonaEntity> wrapper);
	
	List<DangfeijiaonaView> selectListView(@Param("ew") Wrapper<DangfeijiaonaEntity> wrapper);

	List<DangfeijiaonaView> selectListView(Pagination page,@Param("ew") Wrapper<DangfeijiaonaEntity> wrapper);
	
	DangfeijiaonaView selectView(@Param("ew") Wrapper<DangfeijiaonaEntity> wrapper);
	
}

6、论文目录结构

7、源码获取

感谢大家的阅读,如有不懂的问题可以评论区交流或私聊!

喜欢文章可以点赞、收藏、关注、评论

获取源码请私信

  • 14
    点赞
  • 16
    收藏
    觉得还不错? 一键收藏
  • 11
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 11
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值