博主介紹：?從事軟件開發(fā)10年之余，專注于Java技術(shù)領(lǐng)域、Python人工智能及數(shù)據(jù)挖掘、小程序項(xiàng)目開發(fā)和Android項(xiàng)目開發(fā)等。CSDN、掘金、華為云、InfoQ、阿里云等平臺(tái)優(yōu)質(zhì)作者?
??文末獲取源碼聯(lián)系??
???? 精彩專欄推薦訂閱???? 不然下次找不到喲
————————————————
計(jì)算機(jī)畢業(yè)設(shè)計(jì)題目《1000套》?

目錄

?1、項(xiàng)目介紹及開發(fā)技術(shù)

1.1 項(xiàng)目介紹

1.2 開發(fā)技術(shù)

2、系統(tǒng)功能設(shè)計(jì)結(jié)構(gòu)圖

3、功能截圖

3.1 前臺(tái)功能

3.2 后臺(tái)功能

4、數(shù)據(jù)庫(kù)表結(jié)構(gòu)設(shè)計(jì)

5、關(guān)鍵代碼

?5.1 黨費(fèi)繳納管理Controller模塊?

5.2 黨費(fèi)繳納管理Service模塊?

?5.3 黨費(fèi)繳納管理ServiceImpl模塊

?5.4? 黨費(fèi)繳納管理Dao模塊

6、論文目錄結(jié)構(gòu)

7、源碼獲取

?1、項(xiàng)目介紹及開發(fā)技術(shù)

1.1 項(xiàng)目介紹

傳統(tǒng)智慧黨建管理采取了人工的管理方法，但這種管理方法存在著許多弊端，比如效率低下、安全性低以及信息傳輸?shù)牟粶?zhǔn)確等，同時(shí)由于管理信息系統(tǒng)中會(huì)形成眾多的個(gè)人文檔和信息系統(tǒng)數(shù)據(jù)，通過人工方法對(duì)智慧黨建信息進(jìn)行集中管理會(huì)形成檢索、更改和維護(hù)等較為麻煩的管理問題，同時(shí)由于當(dāng)下人民群眾對(duì)智慧黨建管理的需求也日益高漲，各級(jí)需要繼續(xù)開展全新的改革以滿足時(shí)代的需求。根據(jù)此問題，研發(fā)一套智慧黨建系統(tǒng)，既能夠大大提高信息的檢索、變更與維護(hù)的工作效率，也能夠方便信息系統(tǒng)的管理運(yùn)用，從而減少信息管理成本，提高效率。

1.2 開發(fā)技術(shù)

Java開發(fā)語(yǔ)言、SpringBoot、MyBatisPlus、MySQL數(shù)據(jù)庫(kù)、Maven、IDEA開發(fā)工具、JDK1.8+、Vue、HTML、CSS、JS。

2、系統(tǒng)功能設(shè)計(jì)結(jié)構(gòu)圖

本系統(tǒng)主要設(shè)計(jì)并完成了用戶登錄管理過程、個(gè)人信息修改、對(duì)黨員管理、黨支部管理、黨建要聞管理、黨建地圖管理、黨建學(xué)習(xí)管理、學(xué)習(xí)心得管理、黨費(fèi)繳納管理、黨建活動(dòng)管理、活動(dòng)報(bào)名管理、問卷調(diào)查管理、問卷回答管理、民主投票管理、投票信息管理、試題管理、學(xué)習(xí)測(cè)試管理、系統(tǒng)管理、考試管理等功能進(jìn)行管理。

3、功能截圖

3.1 前臺(tái)功能

首先看到的就是首頁(yè)界面。在這里，人們能夠看到系統(tǒng)的導(dǎo)航條，通過導(dǎo)航條導(dǎo)航進(jìn)入各功能展示頁(yè)面進(jìn)行操作。

?黨建要聞：在黨建要聞頁(yè)面的輸入欄中輸入黨建標(biāo)題、簡(jiǎn)介進(jìn)行查詢，可以查看到黨建要聞詳細(xì)信息，并根據(jù)需要進(jìn)行評(píng)論或收藏操作；

?黨建學(xué)習(xí)：在黨建學(xué)習(xí)頁(yè)面的輸入欄中輸入資料名稱進(jìn)行查詢，可以查看到黨建學(xué)習(xí)詳細(xì)信息。

?黨建活動(dòng)：在黨建活動(dòng)頁(yè)面的輸入欄中輸入活動(dòng)名稱進(jìn)行查詢，可以查看到黨建活動(dòng)詳細(xì)信息，并根據(jù)需要進(jìn)行報(bào)名操作。

?問卷調(diào)查：在問卷調(diào)查頁(yè)面的輸入欄中輸入問卷標(biāo)題進(jìn)行查詢，可以查看到問卷調(diào)查詳細(xì)信息，并進(jìn)行問卷回答操作。

?民主投票：在民主投票頁(yè)面的輸入欄中輸入投票主題進(jìn)行查詢，可以查看到民主投票詳細(xì)信息，并進(jìn)行投票操作。

?學(xué)習(xí)測(cè)試：在學(xué)習(xí)測(cè)試頁(yè)面可以查看學(xué)習(xí)測(cè)試名稱、考試時(shí)長(zhǎng)、創(chuàng)建時(shí)間等信息，并進(jìn)行考試操作。

?個(gè)人中心：在個(gè)人中心頁(yè)面通過填寫個(gè)人詳細(xì)信息進(jìn)行信息更新操作，還可以對(duì)考試管理、錯(cuò)題本、我的收藏進(jìn)行詳細(xì)操作。

3.2 后臺(tái)功能

后臺(tái)用戶登錄，在登錄頁(yè)面選擇需要登錄的角色，在正確輸入用戶名和密碼后，進(jìn)入操作系統(tǒng)進(jìn)行操作。

?管理員進(jìn)入主頁(yè)面，主要功能包括對(duì)個(gè)人中心、黨員管理、黨支部管理、黨建要聞管理、黨建地圖管理、黨建學(xué)習(xí)管理、學(xué)習(xí)心得管理、黨費(fèi)繳納管理、黨建活動(dòng)管理、活動(dòng)報(bào)名管理、問卷調(diào)查管理、問卷回答管理、民主投票管理、投票信息管理、試題管理、學(xué)習(xí)測(cè)試管理、系統(tǒng)管理、考試管理等進(jìn)行操作。

?管理員點(diǎn)擊黨員管理。在黨員頁(yè)面輸入黨員賬號(hào)和選擇性別進(jìn)查詢、新增、刪除、年齡分析或?qū)W歷統(tǒng)計(jì)黨員列表，并根據(jù)需要對(duì)黨員詳情信息進(jìn)行詳情操作。

?管理員點(diǎn)擊黨支部管理。在黨支部頁(yè)面輸入支部賬號(hào)進(jìn)行查詢、新增或刪除黨支部列表，并根據(jù)需要對(duì)黨支部詳情信息進(jìn)行詳情、修改或刪除操作。

?管理員點(diǎn)擊黨建要聞管理。在黨建要聞頁(yè)面輸入黨建標(biāo)題、簡(jiǎn)介進(jìn)行查詢、新增或刪除黨建要聞列表，并根據(jù)需要對(duì)黨建要聞詳情信息進(jìn)行詳情、查看評(píng)論、修改或刪除操作。

?管理員點(diǎn)擊黨建地圖管理。在黨建地圖頁(yè)面輸入地圖名稱進(jìn)行查詢、新增或刪除黨建地圖列表，并根據(jù)需要對(duì)黨建地圖詳情信息進(jìn)行詳情、查看評(píng)論、修改或刪除操作。

?管理員點(diǎn)擊學(xué)習(xí)心得管理。在學(xué)習(xí)心得頁(yè)面輸入資料編號(hào)、資料名稱進(jìn)行查詢或刪除學(xué)習(xí)心得列表，并根據(jù)需要對(duì)學(xué)習(xí)心得詳情信息進(jìn)行詳情、修改或刪除操作。

?管理員點(diǎn)擊活動(dòng)報(bào)名管理。在活動(dòng)報(bào)名頁(yè)面輸入活動(dòng)名稱、黨員姓名、支部名稱、是否通過進(jìn)行查詢或刪除活動(dòng)報(bào)名列表，并根據(jù)需要對(duì)活動(dòng)報(bào)名詳情信息進(jìn)行詳情操作。

?管理員點(diǎn)擊問卷調(diào)查管理。在問卷調(diào)查頁(yè)面輸入問卷標(biāo)題進(jìn)查詢、新增、刪除、年齡分析或?qū)W歷統(tǒng)計(jì)問卷調(diào)查列表，并根據(jù)需要對(duì)問卷調(diào)查詳情信息進(jìn)行詳情操作。

?管理員點(diǎn)擊問卷回答管理。在問卷回答頁(yè)面輸入問卷標(biāo)題進(jìn)查詢、刪除或問卷回答統(tǒng)計(jì)問卷回答列表，并根據(jù)需要對(duì)問卷回答詳情信息進(jìn)行詳情、修改或刪除操作。

?管理員點(diǎn)擊黨建活動(dòng)管理。在黨建活動(dòng)頁(yè)面輸入活動(dòng)名稱進(jìn)查詢、新增或刪除黨建活動(dòng)列表，并根據(jù)需要對(duì)黨建活動(dòng)詳情信息進(jìn)行詳情操作。

?管理員點(diǎn)擊民主投票管理。在民主投票頁(yè)面輸入投票主題進(jìn)查詢、新增或刪除民主投票列表，并根據(jù)需要對(duì)民主投票詳情信息進(jìn)行詳情、修改或刪除操作。

?黨員進(jìn)入系統(tǒng)可以對(duì)個(gè)人中心、學(xué)習(xí)心得管理、黨費(fèi)繳納管理、活動(dòng)報(bào)名管理、問卷回答管理、投票信息管理等功能進(jìn)行操作。

?黨支部進(jìn)入系統(tǒng)可以對(duì)個(gè)人中心、黨員管理、黨費(fèi)繳納管理、黨建活動(dòng)管理、活動(dòng)報(bào)名管理等功能進(jìn)行操作。

4、數(shù)據(jù)庫(kù)表結(jié)構(gòu)設(shè)計(jì)

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 '配置參數(shù)名稱',
  `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
  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 '創(chuàng)建時(shí)間',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '黨員賬號(hào)',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '黨員姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
  `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '聯(lián)系方式',
  `zhibuzhanghao` varchar(200) DEFAULT NULL COMMENT '支部賬號(hào)',
  `zhibumingcheng` varchar(200) DEFAULT NULL COMMENT '支部名稱',
  `dangfei` float DEFAULT NULL COMMENT '黨費(fèi)',
  `yuefen` varchar(200) DEFAULT NULL COMMENT '月份',
  `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='黨費(fèi)繳納';
/*!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','黨員賬號(hào)1','黨員姓名1','性別1','13823888881','支部賬號(hào)1','支部名稱1',1,'月份1','未支付'),(72,'2023-03-08 14:48:26','黨員賬號(hào)2','黨員姓名2','性別2','13823888882','支部賬號(hào)2','支部名稱2',2,'月份2','未支付'),(73,'2023-03-08 14:48:26','黨員賬號(hào)3','黨員姓名3','性別3','13823888883','支部賬號(hào)3','支部名稱3',3,'月份3','未支付'),(74,'2023-03-08 14:48:26','黨員賬號(hào)4','黨員姓名4','性別4','13823888884','支部賬號(hào)4','支部名稱4',4,'月份4','未支付'),(75,'2023-03-08 14:48:26','黨員賬號(hào)5','黨員姓名5','性別5','13823888885','支部賬號(hào)5','支部名稱5',5,'月份5','未支付'),(76,'2023-03-08 14:48:26','黨員賬號(hào)6','黨員姓名6','性別6','13823888886','支部賬號(hào)6','支部名稱6',6,'月份6','未支付'),(77,'2023-03-08 14:48:26','黨員賬號(hào)7','黨員姓名7','性別7','13823888887','支部賬號(hào)7','支部名稱7',7,'月份7','未支付'),(78,'2023-03-08 14:48:26','黨員賬號(hào)8','黨員姓名8','性別8','13823888888','支部賬號(hào)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 '創(chuàng)建時(shí)間',
  `ditumingcheng` varchar(200) DEFAULT NULL COMMENT '地圖名稱',
  `fengmian` longtext COMMENT '封面',
  `dituxiangqing` longtext COMMENT '地圖詳情',
  `fabushijian` datetime DEFAULT NULL COMMENT '發(fā)布時(shí)間',
  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 '創(chuàng)建時(shí)間',
  `huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活動(dòng)名稱',
  `huodongtupian` longtext COMMENT '活動(dòng)圖片',
  `huodongdidian` varchar(200) DEFAULT NULL COMMENT '活動(dòng)地點(diǎn)',
  `huodongshijian` datetime DEFAULT NULL COMMENT '活動(dòng)時(shí)間',
  `huodongrenshu` varchar(200) DEFAULT NULL COMMENT '活動(dòng)人數(shù)',
  `huodongneirong` longtext COMMENT '活動(dòng)內(nèi)容',
  `fabushijian` datetime DEFAULT NULL COMMENT '發(fā)布時(shí)間',
  `zhibuzhanghao` varchar(200) DEFAULT NULL COMMENT '支部賬號(hào)',
  `zhibumingcheng` varchar(200) DEFAULT NULL COMMENT '支部名稱',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='黨建活動(dòng)';
/*!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','活動(dòng)名稱1','upload/dangjianhuodong_huodongtupian1.jpg,upload/dangjianhuodong_huodongtupian2.jpg,upload/dangjianhuodong_huodongtupian3.jpg','活動(dòng)地點(diǎn)1','2023-03-08 22:48:26','活動(dòng)人數(shù)1','活動(dòng)內(nèi)容1','2023-03-08 22:48:26','支部賬號(hào)1','支部名稱1'),(82,'2023-03-08 14:48:26','活動(dòng)名稱2','upload/dangjianhuodong_huodongtupian2.jpg,upload/dangjianhuodong_huodongtupian3.jpg,upload/dangjianhuodong_huodongtupian4.jpg','活動(dòng)地點(diǎn)2','2023-03-08 22:48:26','活動(dòng)人數(shù)2','活動(dòng)內(nèi)容2','2023-03-08 22:48:26','支部賬號(hào)2','支部名稱2'),(83,'2023-03-08 14:48:26','活動(dòng)名稱3','upload/dangjianhuodong_huodongtupian3.jpg,upload/dangjianhuodong_huodongtupian4.jpg,upload/dangjianhuodong_huodongtupian5.jpg','活動(dòng)地點(diǎn)3','2023-03-08 22:48:26','活動(dòng)人數(shù)3','活動(dòng)內(nèi)容3','2023-03-08 22:48:26','支部賬號(hào)3','支部名稱3'),(84,'2023-03-08 14:48:26','活動(dòng)名稱4','upload/dangjianhuodong_huodongtupian4.jpg,upload/dangjianhuodong_huodongtupian5.jpg,upload/dangjianhuodong_huodongtupian6.jpg','活動(dòng)地點(diǎn)4','2023-03-08 22:48:26','活動(dòng)人數(shù)4','活動(dòng)內(nèi)容4','2023-03-08 22:48:26','支部賬號(hào)4','支部名稱4'),(85,'2023-03-08 14:48:26','活動(dòng)名稱5','upload/dangjianhuodong_huodongtupian5.jpg,upload/dangjianhuodong_huodongtupian6.jpg,upload/dangjianhuodong_huodongtupian7.jpg','活動(dòng)地點(diǎn)5','2023-03-08 22:48:26','活動(dòng)人數(shù)5','活動(dòng)內(nèi)容5','2023-03-08 22:48:26','支部賬號(hào)5','支部名稱5'),(86,'2023-03-08 14:48:26','活動(dòng)名稱6','upload/dangjianhuodong_huodongtupian6.jpg,upload/dangjianhuodong_huodongtupian7.jpg,upload/dangjianhuodong_huodongtupian8.jpg','活動(dòng)地點(diǎn)6','2023-03-08 22:48:26','活動(dòng)人數(shù)6','活動(dòng)內(nèi)容6','2023-03-08 22:48:26','支部賬號(hào)6','支部名稱6'),(87,'2023-03-08 14:48:26','活動(dòng)名稱7','upload/dangjianhuodong_huodongtupian7.jpg,upload/dangjianhuodong_huodongtupian8.jpg,upload/dangjianhuodong_huodongtupian9.jpg','活動(dòng)地點(diǎn)7','2023-03-08 22:48:26','活動(dòng)人數(shù)7','活動(dòng)內(nèi)容7','2023-03-08 22:48:26','支部賬號(hào)7','支部名稱7'),(88,'2023-03-08 14:48:26','活動(dòng)名稱8','upload/dangjianhuodong_huodongtupian8.jpg,upload/dangjianhuodong_huodongtupian9.jpg,upload/dangjianhuodong_huodongtupian10.jpg','活動(dòng)地點(diǎn)8','2023-03-08 22:48:26','活動(dòng)人數(shù)8','活動(dòng)內(nèi)容8','2023-03-08 22:48:26','支部賬號(hào)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 '創(chuàng)建時(shí)間',
  `ziliaobianhao` varchar(200) NOT NULL COMMENT '資料編號(hào)',
  `ziliaomingcheng` varchar(200) NOT NULL COMMENT '資料名稱',
  `tupian` longtext COMMENT '圖片',
  `ziliaojianjie` longtext COMMENT '資料簡(jiǎn)介',
  `shipin` longtext COMMENT '視頻',
  `fujianxiazai` longtext COMMENT '附件下載',
  `fabushijian` datetime DEFAULT NULL COMMENT '發(fā)布時(shí)間',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ziliaobianhao` (`ziliaobianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='黨建學(xué)習(xí)';
/*!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','資料簡(jiǎn)介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','資料簡(jiǎn)介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','資料簡(jiǎn)介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','資料簡(jiǎn)介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','資料簡(jiǎn)介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','資料簡(jiǎn)介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','資料簡(jiǎn)介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','資料簡(jiǎn)介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 '創(chuàng)建時(shí)間',
  `dangjianbiaoti` varchar(200) NOT NULL COMMENT '黨建標(biāo)題',
  `fengmian` longtext COMMENT '封面',
  `jianjie` longtext COMMENT '簡(jiǎn)介',
  `shipin` longtext COMMENT '視頻',
  `xiangqingneirong` longtext COMMENT '詳情內(nèi)容',
  `fabushijian` date DEFAULT NULL COMMENT '發(fā)布時(shí)間',
  `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','黨建標(biāo)題1','upload/dangjianyaowen_fengmian1.jpg,upload/dangjianyaowen_fengmian2.jpg,upload/dangjianyaowen_fengmian3.jpg','簡(jiǎn)介1','','詳情內(nèi)容1','2023-03-08',1,1),(32,'2023-03-08 14:48:26','黨建標(biāo)題2','upload/dangjianyaowen_fengmian2.jpg,upload/dangjianyaowen_fengmian3.jpg,upload/dangjianyaowen_fengmian4.jpg','簡(jiǎn)介2','','詳情內(nèi)容2','2023-03-08',2,2),(33,'2023-03-08 14:48:26','黨建標(biāo)題3','upload/dangjianyaowen_fengmian3.jpg,upload/dangjianyaowen_fengmian4.jpg,upload/dangjianyaowen_fengmian5.jpg','簡(jiǎn)介3','','詳情內(nèi)容3','2023-03-08',3,3),(34,'2023-03-08 14:48:26','黨建標(biāo)題4','upload/dangjianyaowen_fengmian4.jpg,upload/dangjianyaowen_fengmian5.jpg,upload/dangjianyaowen_fengmian6.jpg','簡(jiǎn)介4','','詳情內(nèi)容4','2023-03-08',4,4),(35,'2023-03-08 14:48:26','黨建標(biāo)題5','upload/dangjianyaowen_fengmian5.jpg,upload/dangjianyaowen_fengmian6.jpg,upload/dangjianyaowen_fengmian7.jpg','簡(jiǎn)介5','','詳情內(nèi)容5','2023-03-08',5,5),(36,'2023-03-08 14:48:26','黨建標(biāo)題6','upload/dangjianyaowen_fengmian6.jpg,upload/dangjianyaowen_fengmian7.jpg,upload/dangjianyaowen_fengmian8.jpg','簡(jiǎn)介6','','詳情內(nèi)容6','2023-03-08',6,6),(37,'2023-03-08 14:48:26','黨建標(biāo)題7','upload/dangjianyaowen_fengmian7.jpg,upload/dangjianyaowen_fengmian8.jpg,upload/dangjianyaowen_fengmian9.jpg','簡(jiǎn)介7','','詳情內(nèi)容7','2023-03-08',7,7),(38,'2023-03-08 14:48:26','黨建標(biāo)題8','upload/dangjianyaowen_fengmian8.jpg,upload/dangjianyaowen_fengmian9.jpg,upload/dangjianyaowen_fengmian10.jpg','簡(jiǎn)介8','','詳情內(nèi)容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 '創(chuàng)建時(shí)間',
  `dangyuanzhanghao` varchar(200) NOT NULL COMMENT '黨員賬號(hào)',
  `mima` varchar(200) NOT NULL COMMENT '密碼',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '黨員姓名',
  `touxiang` longtext COMMENT '頭像',
  `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '聯(lián)系方式',
  `nianling` int(11) DEFAULT NULL COMMENT '年齡',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
  `xueli` varchar(200) DEFAULT NULL COMMENT '學(xué)歷',
  `shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份證號(hào)',
  `rudangshijian` date DEFAULT NULL COMMENT '入黨時(shí)間',
  `zhibuzhanghao` varchar(200) DEFAULT NULL COMMENT '支部賬號(hào)',
  `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','黨員賬號(hào)1','123456','黨員姓名1','upload/dangyuan_touxiang1.jpg','13823888881',1,'男','學(xué)歷1','440300199101010001','2023-03-08','支部賬號(hào)1','支部名稱1'),(12,'2023-03-08 14:48:26','黨員賬號(hào)2','123456','黨員姓名2','upload/dangyuan_touxiang2.jpg','13823888882',2,'男','學(xué)歷2','440300199202020002','2023-03-08','支部賬號(hào)2','支部名稱2'),(13,'2023-03-08 14:48:26','黨員賬號(hào)3','123456','黨員姓名3','upload/dangyuan_touxiang3.jpg','13823888883',3,'男','學(xué)歷3','440300199303030003','2023-03-08','支部賬號(hào)3','支部名稱3'),(14,'2023-03-08 14:48:26','黨員賬號(hào)4','123456','黨員姓名4','upload/dangyuan_touxiang4.jpg','13823888884',4,'男','學(xué)歷4','440300199404040004','2023-03-08','支部賬號(hào)4','支部名稱4'),(15,'2023-03-08 14:48:26','黨員賬號(hào)5','123456','黨員姓名5','upload/dangyuan_touxiang5.jpg','13823888885',5,'男','學(xué)歷5','440300199505050005','2023-03-08','支部賬號(hào)5','支部名稱5'),(16,'2023-03-08 14:48:26','黨員賬號(hào)6','123456','黨員姓名6','upload/dangyuan_touxiang6.jpg','13823888886',6,'男','學(xué)歷6','440300199606060006','2023-03-08','支部賬號(hào)6','支部名稱6'),(17,'2023-03-08 14:48:26','黨員賬號(hào)7','123456','黨員姓名7','upload/dangyuan_touxiang7.jpg','13823888887',7,'男','學(xué)歷7','440300199707070007','2023-03-08','支部賬號(hào)7','支部名稱7'),(18,'2023-03-08 14:48:26','黨員賬號(hào)8','123456','黨員姓名8','upload/dangyuan_touxiang8.jpg','13823888888',8,'男','學(xué)歷8','440300199808080008','2023-03-08','支部賬號(hào)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 '創(chuàng)建時(shí)間',
  `zhibuzhanghao` varchar(200) NOT NULL COMMENT '支部賬號(hào)',
  `mima` varchar(200) NOT NULL COMMENT '密碼',
  `zhibumingcheng` varchar(200) NOT NULL COMMENT '支部名稱',
  `fuzeren` varchar(200) DEFAULT NULL COMMENT '負(fù)責(zé)人',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
  `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','支部賬號(hào)1','123456','支部名稱1','負(fù)責(zé)人1','13823888881','支部地址1'),(22,'2023-03-08 14:48:26','支部賬號(hào)2','123456','支部名稱2','負(fù)責(zé)人2','13823888882','支部地址2'),(23,'2023-03-08 14:48:26','支部賬號(hào)3','123456','支部名稱3','負(fù)責(zé)人3','13823888883','支部地址3'),(24,'2023-03-08 14:48:26','支部賬號(hào)4','123456','支部名稱4','負(fù)責(zé)人4','13823888884','支部地址4'),(25,'2023-03-08 14:48:26','支部賬號(hào)5','123456','支部名稱5','負(fù)責(zé)人5','13823888885','支部地址5'),(26,'2023-03-08 14:48:26','支部賬號(hào)6','123456','支部名稱6','負(fù)責(zé)人6','13823888886','支部地址6'),(27,'2023-03-08 14:48:26','支部賬號(hào)7','123456','支部名稱7','負(fù)責(zé)人7','13823888887','支部地址7'),(28,'2023-03-08 14:48:26','支部賬號(hào)8','123456','支部名稱8','負(fù)責(zé)人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 '創(chuàng)建時(shí)間',
  `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
  `userid` bigint(20) NOT NULL COMMENT '用戶id',
  `avatarurl` longtext COMMENT '頭像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
  `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
  `reply` longtext COMMENT '回復(fù)內(nèi)容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='黨建地圖評(píng)論表';
/*!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 '創(chuàng)建時(shí)間',
  `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
  `userid` bigint(20) NOT NULL COMMENT '用戶id',
  `avatarurl` longtext COMMENT '頭像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
  `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
  `reply` longtext COMMENT '回復(fù)內(nèi)容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='黨建學(xué)習(xí)評(píng)論表';
/*!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 '創(chuàng)建時(shí)間',
  `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
  `userid` bigint(20) NOT NULL COMMENT '用戶id',
  `avatarurl` longtext COMMENT '頭像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
  `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
  `reply` longtext COMMENT '回復(fù)內(nèi)容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='黨建要聞評(píng)論表';
/*!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 '創(chuàng)建時(shí)間',
  `name` varchar(200) NOT NULL COMMENT '學(xué)習(xí)測(cè)試名稱',
  `time` int(11) NOT NULL COMMENT '考試時(shí)長(zhǎng)(分鐘)',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '學(xué)習(xí)測(cè)試狀態(tài)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='學(xué)習(xí)測(cè)試表';
/*!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','十萬(wàn)個(gè)為什么',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 '創(chuàng)建時(shí)間',
  `paperid` bigint(20) NOT NULL COMMENT '所屬學(xué)習(xí)測(cè)試id（外鍵）',
  `papername` varchar(200) NOT NULL COMMENT '學(xué)習(xí)測(cè)試名稱',
  `questionname` varchar(200) NOT NULL COMMENT '試題名稱',
  `options` longtext COMMENT '選項(xiàng)，json字符串',
  `score` bigint(20) DEFAULT '0' COMMENT '分值',
  `answer` varchar(200) DEFAULT NULL COMMENT '正確答案',
  `analysis` longtext COMMENT '答案解析',
  `type` bigint(20) DEFAULT '0' COMMENT '試題類型，0：?jiǎn)芜x題 1：多選題 2：判斷題 3：填空題（暫不考慮多項(xiàng)填空）',
  `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,'十萬(wàn)個(gè)為什么','下面動(dòng)物不屬于昆蟲的是（）。','[{\"text\":\"A.蒼蠅\",\"code\":\"A\"},{\"text\":\"B.蜜蜂\",\"code\":\"B\"},{\"text\":\"C.蜂鳥\",\"code\":\"C\"}]',20,'C','蜂鳥',0,1),(2,'2023-03-08 14:48:27',1,'十萬(wàn)個(gè)為什么','油著火后可以用水撲滅。','[{\"text\":\"A.對(duì)\",\"code\":\"A\"},{\"text\":\"B.錯(cuò)\",\"code\":\"B\"}]',20,'B','油著火后不可以用水撲滅',2,2),(3,'2023-03-08 14:48:27',1,'十萬(wàn)個(gè)為什么','地球是個(gè)球體，中間是（ ）。','[]',30,'赤道','赤道',3,3),(4,'2023-03-08 14:48:27',1,'十萬(wàn)個(gè)為什么','下面動(dòng)物中會(huì)流汗的有（ ）。','[{\"text\":\"A.馬\",\"code\":\"A\"},{\"text\":\"B.貓\",\"code\":\"B\"},{\"text\":\"C.狗\",\"code\":\"C\"}]',30,'A,B','狗不會(huì)流汗',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 '創(chuàng)建時(shí)間',
  `userid` bigint(20) NOT NULL COMMENT '用戶id',
  `username` varchar(200) DEFAULT NULL COMMENT '用戶名',
  `paperid` bigint(20) NOT NULL COMMENT '學(xué)習(xí)測(cè)試id（外鍵）',
  `papername` varchar(200) NOT NULL COMMENT '學(xué)習(xí)測(cè)試名稱',
  `questionid` bigint(20) NOT NULL COMMENT '試題id（外鍵）',
  `questionname` varchar(200) NOT NULL COMMENT '試題名稱',
  `options` longtext COMMENT '選項(xiàng)，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 '創(chuàng)建時(shí)間',
  `huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活動(dòng)名稱',
  `huodongdidian` varchar(200) DEFAULT NULL COMMENT '活動(dòng)地點(diǎn)',
  `huodongshijian` varchar(200) DEFAULT NULL COMMENT '活動(dòng)時(shí)間',
  `baomingshijian` datetime DEFAULT NULL COMMENT '報(bào)名時(shí)間',
  `beizhu` varchar(200) DEFAULT NULL COMMENT '備注',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '黨員賬號(hào)',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '黨員姓名',
  `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '聯(lián)系方式',
  `zhibuzhanghao` varchar(200) DEFAULT NULL COMMENT '支部賬號(hào)',
  `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 '審核回復(fù)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='活動(dòng)報(bào)名';
/*!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','活動(dòng)名稱1','活動(dòng)地點(diǎn)1','活動(dòng)時(shí)間1','2023-03-08 22:48:26','備注1','黨員賬號(hào)1','黨員姓名1','聯(lián)系方式1','支部賬號(hào)1','支部名稱1',1,1,'是',''),(92,'2023-03-08 14:48:26','活動(dòng)名稱2','活動(dòng)地點(diǎn)2','活動(dòng)時(shí)間2','2023-03-08 22:48:26','備注2','黨員賬號(hào)2','黨員姓名2','聯(lián)系方式2','支部賬號(hào)2','支部名稱2',2,2,'是',''),(93,'2023-03-08 14:48:26','活動(dòng)名稱3','活動(dòng)地點(diǎn)3','活動(dòng)時(shí)間3','2023-03-08 22:48:26','備注3','黨員賬號(hào)3','黨員姓名3','聯(lián)系方式3','支部賬號(hào)3','支部名稱3',3,3,'是',''),(94,'2023-03-08 14:48:26','活動(dòng)名稱4','活動(dòng)地點(diǎn)4','活動(dòng)時(shí)間4','2023-03-08 22:48:26','備注4','黨員賬號(hào)4','黨員姓名4','聯(lián)系方式4','支部賬號(hào)4','支部名稱4',4,4,'是',''),(95,'2023-03-08 14:48:26','活動(dòng)名稱5','活動(dòng)地點(diǎn)5','活動(dòng)時(shí)間5','2023-03-08 22:48:26','備注5','黨員賬號(hào)5','黨員姓名5','聯(lián)系方式5','支部賬號(hào)5','支部名稱5',5,5,'是',''),(96,'2023-03-08 14:48:26','活動(dòng)名稱6','活動(dòng)地點(diǎn)6','活動(dòng)時(shí)間6','2023-03-08 22:48:26','備注6','黨員賬號(hào)6','黨員姓名6','聯(lián)系方式6','支部賬號(hào)6','支部名稱6',6,6,'是',''),(97,'2023-03-08 14:48:26','活動(dòng)名稱7','活動(dòng)地點(diǎn)7','活動(dòng)時(shí)間7','2023-03-08 22:48:26','備注7','黨員賬號(hào)7','黨員姓名7','聯(lián)系方式7','支部賬號(hào)7','支部名稱7',7,7,'是',''),(98,'2023-03-08 14:48:26','活動(dòng)名稱8','活動(dòng)地點(diǎn)8','活動(dòng)時(shí)間8','2023-03-08 22:48:26','備注8','黨員賬號(hào)8','黨員姓名8','聯(lián)系方式8','支部賬號(hào)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 '創(chuàng)建時(shí)間',
  `toupiaozhuti` varchar(200) NOT NULL COMMENT '投票主題',
  `fengmian` longtext COMMENT '封面',
  `xuanxianga` int(11) DEFAULT NULL COMMENT '選項(xiàng)a',
  `xuanxiangb` int(11) DEFAULT NULL COMMENT '選項(xiàng)b',
  `xuanxiangc` int(11) DEFAULT NULL COMMENT '選項(xiàng)c',
  `xuanxiangd` int(11) DEFAULT NULL COMMENT '選項(xiàng)d',
  `toupiaoneirong` longtext COMMENT '投票內(nèi)容',
  `fabushijian` datetime DEFAULT NULL COMMENT '發(fā)布時(shí)間',
  `reversetime` datetime DEFAULT NULL COMMENT '倒計(jì)結(jié)束時(shí)間',
  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,'投票內(nèi)容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,'投票內(nèi)容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,'投票內(nèi)容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,'投票內(nèi)容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,'投票內(nèi)容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,'投票內(nèi)容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,'投票內(nèi)容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,'投票內(nèi)容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 '創(chuàng)建時(shí)間',
  `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:競(jìng)拍參與,41:關(guān)注)',
  `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 '新增時(shí)間',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '過期時(shí)間',
  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 '創(chuàng)建時(shí)間',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '黨員賬號(hào)',
  `dangyuanxingming` varchar(200) DEFAULT NULL COMMENT '黨員姓名',
  `toupiaozhuti` varchar(200) DEFAULT NULL COMMENT '投票主題',
  `xuanxianga` int(11) DEFAULT NULL COMMENT '選項(xiàng)a',
  `xuanxiangb` int(11) DEFAULT NULL COMMENT '選項(xiàng)b',
  `xuanxiangc` int(11) DEFAULT NULL COMMENT '選項(xiàng)c',
  `xuanxiangd` int(11) DEFAULT NULL COMMENT '選項(xiàng)d',
  `toupiaoshijian` datetime DEFAULT NULL COMMENT '投票時(shí)間',
  `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','黨員賬號(hào)1','黨員姓名1','投票主題1',1,1,1,1,'2023-03-08 22:48:26',1,1),(132,'2023-03-08 14:48:26','黨員賬號(hào)2','黨員姓名2','投票主題2',1,1,1,1,'2023-03-08 22:48:26',2,2),(133,'2023-03-08 14:48:26','黨員賬號(hào)3','黨員姓名3','投票主題3',1,1,1,1,'2023-03-08 22:48:26',3,3),(134,'2023-03-08 14:48:26','黨員賬號(hào)4','黨員姓名4','投票主題4',1,1,1,1,'2023-03-08 22:48:26',4,4),(135,'2023-03-08 14:48:26','黨員賬號(hào)5','黨員姓名5','投票主題5',1,1,1,1,'2023-03-08 22:48:26',5,5),(136,'2023-03-08 14:48:26','黨員賬號(hào)6','黨員姓名6','投票主題6',1,1,1,1,'2023-03-08 22:48:26',6,6),(137,'2023-03-08 14:48:26','黨員賬號(hào)7','黨員姓名7','投票主題7',1,1,1,1,'2023-03-08 22:48:26',7,7),(138,'2023-03-08 14:48:26','黨員賬號(hào)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 '新增時(shí)間',
  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 '創(chuàng)建時(shí)間',
  `wenjuanbiaoti` varchar(200) NOT NULL COMMENT '問卷標(biāo)題',
  `tupian` longtext COMMENT '圖片',
  `wenjuanneirong` longtext NOT NULL COMMENT '問卷內(nèi)容',
  `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 '發(fā)布時(shí)間',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='問卷調(diào)查';
/*!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','問卷標(biāo)題1','upload/wenjuandiaocha_tupian1.jpg,upload/wenjuandiaocha_tupian2.jpg,upload/wenjuandiaocha_tupian3.jpg','問卷內(nèi)容1','答案一1','答案二1','答案三1','答案四1','2023-03-08 22:48:26'),(102,'2023-03-08 14:48:26','問卷標(biāo)題2','upload/wenjuandiaocha_tupian2.jpg,upload/wenjuandiaocha_tupian3.jpg,upload/wenjuandiaocha_tupian4.jpg','問卷內(nèi)容2','答案一2','答案二2','答案三2','答案四2','2023-03-08 22:48:26'),(103,'2023-03-08 14:48:26','問卷標(biāo)題3','upload/wenjuandiaocha_tupian3.jpg,upload/wenjuandiaocha_tupian4.jpg,upload/wenjuandiaocha_tupian5.jpg','問卷內(nèi)容3','答案一3','答案二3','答案三3','答案四3','2023-03-08 22:48:26'),(104,'2023-03-08 14:48:26','問卷標(biāo)題4','upload/wenjuandiaocha_tupian4.jpg,upload/wenjuandiaocha_tupian5.jpg,upload/wenjuandiaocha_tupian6.jpg','問卷內(nèi)容4','答案一4','答案二4','答案三4','答案四4','2023-03-08 22:48:26'),(105,'2023-03-08 14:48:26','問卷標(biāo)題5','upload/wenjuandiaocha_tupian5.jpg,upload/wenjuandiaocha_tupian6.jpg,upload/wenjuandiaocha_tupian7.jpg','問卷內(nèi)容5','答案一5','答案二5','答案三5','答案四5','2023-03-08 22:48:26'),(106,'2023-03-08 14:48:26','問卷標(biāo)題6','upload/wenjuandiaocha_tupian6.jpg,upload/wenjuandiaocha_tupian7.jpg,upload/wenjuandiaocha_tupian8.jpg','問卷內(nèi)容6','答案一6','答案二6','答案三6','答案四6','2023-03-08 22:48:26'),(107,'2023-03-08 14:48:26','問卷標(biāo)題7','upload/wenjuandiaocha_tupian7.jpg,upload/wenjuandiaocha_tupian8.jpg,upload/wenjuandiaocha_tupian9.jpg','問卷內(nèi)容7','答案一7','答案二7','答案三7','答案四7','2023-03-08 22:48:26'),(108,'2023-03-08 14:48:26','問卷標(biāo)題8','upload/wenjuandiaocha_tupian8.jpg,upload/wenjuandiaocha_tupian9.jpg,upload/wenjuandiaocha_tupian10.jpg','問卷內(nèi)容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 '創(chuàng)建時(shí)間',
  `wenjuanbiaoti` varchar(200) DEFAULT NULL COMMENT '問卷標(biāo)題',
  `wenjuanhuida` varchar(200) NOT NULL COMMENT '問卷回答',
  `diaochashijian` datetime DEFAULT NULL COMMENT '調(diào)查時(shí)間',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '黨員賬號(hào)',
  `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','問卷標(biāo)題1','答案一','2023-03-08 22:48:26','黨員賬號(hào)1','黨員姓名1',1,1),(112,'2023-03-08 14:48:26','問卷標(biāo)題2','答案一','2023-03-08 22:48:26','黨員賬號(hào)2','黨員姓名2',2,2),(113,'2023-03-08 14:48:26','問卷標(biāo)題3','答案一','2023-03-08 22:48:26','黨員賬號(hào)3','黨員姓名3',3,3),(114,'2023-03-08 14:48:26','問卷標(biāo)題4','答案一','2023-03-08 22:48:26','黨員賬號(hào)4','黨員姓名4',4,4),(115,'2023-03-08 14:48:26','問卷標(biāo)題5','答案一','2023-03-08 22:48:26','黨員賬號(hào)5','黨員姓名5',5,5),(116,'2023-03-08 14:48:26','問卷標(biāo)題6','答案一','2023-03-08 22:48:26','黨員賬號(hào)6','黨員姓名6',6,6),(117,'2023-03-08 14:48:26','問卷標(biāo)題7','答案一','2023-03-08 22:48:26','黨員賬號(hào)7','黨員姓名7',7,7),(118,'2023-03-08 14:48:26','問卷標(biāo)題8','答案一','2023-03-08 22:48:26','黨員賬號(hào)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 '創(chuàng)建時(shí)間',
  `ziliaobianhao` varchar(200) DEFAULT NULL COMMENT '資料編號(hào)',
  `ziliaomingcheng` varchar(200) DEFAULT NULL COMMENT '資料名稱',
  `xuexixinde` longtext NOT NULL COMMENT '學(xué)習(xí)心得',
  `xuexishijian` datetime DEFAULT NULL COMMENT '學(xué)習(xí)時(shí)間',
  `dangyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '黨員賬號(hào)',
  `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='學(xué)習(xí)心得';
/*!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','資料編號(hào)1','資料名稱1','學(xué)習(xí)心得1','2023-03-08 22:48:26','黨員賬號(hào)1','黨員姓名1',1,1),(62,'2023-03-08 14:48:26','資料編號(hào)2','資料名稱2','學(xué)習(xí)心得2','2023-03-08 22:48:26','黨員賬號(hào)2','黨員姓名2',2,2),(63,'2023-03-08 14:48:26','資料編號(hào)3','資料名稱3','學(xué)習(xí)心得3','2023-03-08 22:48:26','黨員賬號(hào)3','黨員姓名3',3,3),(64,'2023-03-08 14:48:26','資料編號(hào)4','資料名稱4','學(xué)習(xí)心得4','2023-03-08 22:48:26','黨員賬號(hào)4','黨員姓名4',4,4),(65,'2023-03-08 14:48:26','資料編號(hào)5','資料名稱5','學(xué)習(xí)心得5','2023-03-08 22:48:26','黨員賬號(hào)5','黨員姓名5',5,5),(66,'2023-03-08 14:48:26','資料編號(hào)6','資料名稱6','學(xué)習(xí)心得6','2023-03-08 22:48:26','黨員賬號(hào)6','黨員姓名6',6,6),(67,'2023-03-08 14:48:26','資料編號(hào)7','資料名稱7','學(xué)習(xí)心得7','2023-03-08 22:48:26','黨員賬號(hào)7','黨員姓名7',7,7),(68,'2023-03-08 14:48:26','資料編號(hào)8','資料名稱8','學(xué)習(xí)心得8','2023-03-08 22:48:26','黨員賬號(hào)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、關(guān)鍵代碼

?5.1 黨費(fèi)繳納管理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;

/**
 * 黨費(fèi)繳納
 * 后端接口
 * @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("查詢黨費(fèi)繳納成功").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 黨費(fèi)繳納管理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;

/**
 * 黨費(fèi)繳納
 *
 * @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 黨費(fèi)繳納管理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? 黨費(fèi)繳納管理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;
/**
 * 黨費(fèi)繳納
 * 
 * @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、論文目錄結(jié)構(gòu)

7、源碼獲取

感謝大家的閱讀，如有不懂的問題可以評(píng)論區(qū)交流或私聊!

喜歡文章可以點(diǎn)贊、收藏、關(guān)注、評(píng)論啦

→獲取源碼請(qǐng)私信←文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-843734.html

到了這里，關(guān)于計(jì)算機(jī)畢業(yè)設(shè)計(jì) 基于SpringBoot的智慧黨建系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) Java實(shí)戰(zhàn)項(xiàng)目 附源碼+文檔+視頻講解的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！