• 计算机毕业设计 基于SpringBoot的企业内部网络管理系统的设计与实现 Java实战项目 附源码+文档+视频讲解

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

     目录

    1、项目介绍及开发技术

    1.1 项目介绍

    1.2 开发技术

    2、系统功能模块设计

    3、功能截图

    4、数据库表结构设计

    5、关键代码

    5.1 接入管理Controller模块 

    5.2 接入管理Service模块 

    5.3 接入管理ServiceImpl模块

    5.4 接入管理Dao模块

    6、源码获取

    1、项目介绍及开发技术

    1.1 项目介绍

    随着信息技术的不断发展，企业内部网络管理系统已经成为企业信息化建设的重要组成部分。为了提高企业的管理效率和降低运营成本，越来越多的企业开始采用基于SpringBoot的企业内部网络管理系统。本文将对基于SpringBoot的企业内部网络管理系统进行详细的介绍和分析。

    首先，本文介绍了企业内部网络管理系统的基本概念和功能。企业内部网络管理系统是一种基于网络的企业级应用系统，主要用于实现企业内部各种业务信息的集中管理和共享。其主要功能包括接入管理、用户管理、用户组管理、单位组织管理、业务流程管理等。通过企业内部网络管理系统，企业可以实现对内部资源的高效利用，提高工作效率，降低运营成本。

    1.2 开发技术

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

    2、系统功能模块设计

    管理员：登录、首页、个人中心（修改密码、个人信息）、运营商管管理、接入管理、用户管理、用户组管理、单位组织管理。

    运营商管:注册、登录、首页、个人中心（修改密码、个人信息）、接入管理。

    接入管理：注册、登录、首页、个人中心（修改密码、个人信息）、用户管理、用户组管理、单位组织管理。

    用户：注册、登录、首页、个人中心（修改密码、个人信息）。

    3、功能截图

    登录 

    首页

     个人中心

     运营商管管理

     接入管理

     用户管理

     用户组管理

    单位组织管理

    4、数据库表结构设计

    1. -- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
    2. --
    3. -- Host: localhost    Database: springboot2mxd5
    4. -- ------------------------------------------------------
    5. -- Server version	5.7.31
    6.  
    7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    10. /*!40101 SET NAMES utf8 */;
    11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    12. /*!40103 SET TIME_ZONE='+00:00' */;
    13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    17.  
    18. --
    19. -- Current Database: `springboot2mxd5`
    20. --
    21.  
    22. /*!40000 DROP DATABASE IF EXISTS `springboot2mxd5`*/;
    23.  
    24. CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springboot2mxd5` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
    25.  
    26. USE `springboot2mxd5`;
    27.  
    28. --
    29. -- Table structure for table `config`
    30. --
    31.  
    32. DROP TABLE IF EXISTS `config`;
    33. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    34. /*!40101 SET character_set_client = utf8 */;
    35. CREATE TABLE `config` (
    36.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    37.   `name` varchar(100) NOT NULL COMMENT '配置参数名称',
    38.   `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
    39.   PRIMARY KEY (`id`)
    40. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
    41. /*!40101 SET character_set_client = @saved_cs_client */;
    42.  
    43. --
    44. -- Dumping data for table `config`
    45. --
    46.  
    47. LOCK TABLES `config` WRITE;
    48. /*!40000 ALTER TABLE `config` DISABLE KEYS */;
    49. INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
    50. /*!40000 ALTER TABLE `config` ENABLE KEYS */;
    51. UNLOCK TABLES;
    52.  
    53. --
    54. -- Table structure for table `danweizuzhi`
    55. --
    56.  
    57. DROP TABLE IF EXISTS `danweizuzhi`;
    58. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    59. /*!40101 SET character_set_client = utf8 */;
    60. CREATE TABLE `danweizuzhi` (
    61.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    62.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    63.   `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
    64.   `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
    65.   `yonghuzu` varchar(200) DEFAULT NULL COMMENT '用户组',
    66.   `danweimingcheng` varchar(200) DEFAULT NULL COMMENT '单位名称',
    67.   `danweileixing` varchar(200) DEFAULT NULL COMMENT '单位类型',
    68.   `danweiweizhi` varchar(200) DEFAULT NULL COMMENT '单位位置',
    69.   `danweitupian` longtext COMMENT '单位图片',
    70.   `suoshuguanxi` varchar(200) DEFAULT NULL COMMENT '所属关系',
    71.   `macdizhi` varchar(200) DEFAULT NULL COMMENT 'mac地址',
    72.   `dengjiriqi` date DEFAULT NULL COMMENT '登记日期',
    73.   PRIMARY KEY (`id`)
    74. ) ENGINE=InnoDB AUTO_INCREMENT=1672307103221 DEFAULT CHARSET=utf8 COMMENT='单位组织';
    75. /*!40101 SET character_set_client = @saved_cs_client */;
    76.  
    77. --
    78. -- Dumping data for table `danweizuzhi`
    79. --
    80.  
    81. LOCK TABLES `danweizuzhi` WRITE;
    82. /*!40000 ALTER TABLE `danweizuzhi` DISABLE KEYS */;
    83. INSERT INTO `danweizuzhi` VALUES (51,'2022-12-29 09:38:15','用户账号1','用户姓名1','用户组1','单位名称1','小型','单位位置1','upload/danweizuzhi_danweitupian1.jpg,upload/danweizuzhi_danweitupian2.jpg,upload/danweizuzhi_danweitupian3.jpg','所属关系1','mac地址1','2022-12-29'),(52,'2022-12-29 09:38:15','用户账号2','用户姓名2','用户组2','单位名称2','小型','单位位置2','upload/danweizuzhi_danweitupian2.jpg,upload/danweizuzhi_danweitupian3.jpg,upload/danweizuzhi_danweitupian4.jpg','所属关系2','mac地址2','2022-12-29'),(53,'2022-12-29 09:38:15','用户账号3','用户姓名3','用户组3','单位名称3','小型','单位位置3','upload/danweizuzhi_danweitupian3.jpg,upload/danweizuzhi_danweitupian4.jpg,upload/danweizuzhi_danweitupian5.jpg','所属关系3','mac地址3','2022-12-29'),(54,'2022-12-29 09:38:15','用户账号4','用户姓名4','用户组4','单位名称4','小型','单位位置4','upload/danweizuzhi_danweitupian4.jpg,upload/danweizuzhi_danweitupian5.jpg,upload/danweizuzhi_danweitupian6.jpg','所属关系4','mac地址4','2022-12-29'),(55,'2022-12-29 09:38:15','用户账号5','用户姓名5','用户组5','单位名称5','小型','单位位置5','upload/danweizuzhi_danweitupian5.jpg,upload/danweizuzhi_danweitupian6.jpg,upload/danweizuzhi_danweitupian7.jpg','所属关系5','mac地址5','2022-12-29'),(56,'2022-12-29 09:38:15','用户账号6','用户姓名6','用户组6','单位名称6','小型','单位位置6','upload/danweizuzhi_danweitupian6.jpg,upload/danweizuzhi_danweitupian7.jpg,upload/danweizuzhi_danweitupian8.jpg','所属关系6','mac地址6','2022-12-29'),(57,'2022-12-29 09:38:15','用户账号7','用户姓名7','用户组7','单位名称7','小型','单位位置7','upload/danweizuzhi_danweitupian7.jpg,upload/danweizuzhi_danweitupian8.jpg,upload/danweizuzhi_danweitupian9.jpg','所属关系7','mac地址7','2022-12-29'),(58,'2022-12-29 09:38:15','用户账号8','用户姓名8','用户组8','单位名称8','小型','单位位置8','upload/danweizuzhi_danweitupian8.jpg,upload/danweizuzhi_danweitupian9.jpg,upload/danweizuzhi_danweitupian10.jpg','所属关系8','mac地址8','2022-12-29'),(1672307103220,'2022-12-29 09:45:02','3','3','个人','单位111','小型','xxx','upload/1672307092108.jpg','合作','12.12.1111','2022-12-29');
    84. /*!40000 ALTER TABLE `danweizuzhi` ENABLE KEYS */;
    85. UNLOCK TABLES;
    86.  
    87. --
    88. -- Table structure for table `jieruguanli`
    89. --
    90.  
    91. DROP TABLE IF EXISTS `jieruguanli`;
    92. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    93. /*!40101 SET character_set_client = utf8 */;
    94. CREATE TABLE `jieruguanli` (
    95.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    96.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    97.   `jieruzhanghao` varchar(200) NOT NULL COMMENT '接入账号',
    98.   `mima` varchar(200) NOT NULL COMMENT '密码',
    99.   `jieruxingming` varchar(200) DEFAULT NULL COMMENT '接入姓名',
    100.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    101.   `dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
    102.   `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
    103.   `guanlifanwei` varchar(200) DEFAULT NULL COMMENT '管理范围',
    104.   `touxiang` longtext COMMENT '头像',
    105.   PRIMARY KEY (`id`),
    106.   UNIQUE KEY `jieruzhanghao` (`jieruzhanghao`)
    107. ) ENGINE=InnoDB AUTO_INCREMENT=1672306937719 DEFAULT CHARSET=utf8 COMMENT='接入管理';
    108. /*!40101 SET character_set_client = @saved_cs_client */;
    109.  
    110. --
    111. -- Dumping data for table `jieruguanli`
    112. --
    113.  
    114. LOCK TABLES `jieruguanli` WRITE;
    115. /*!40000 ALTER TABLE `jieruguanli` DISABLE KEYS */;
    116. INSERT INTO `jieruguanli` VALUES (21,'2022-12-29 09:38:15','接入账号1','123456','接入姓名1','男','13823888881','773890001@qq.com','管理范围1','upload/jieruguanli_touxiang1.jpg'),(22,'2022-12-29 09:38:15','接入账号2','123456','接入姓名2','男','13823888882','773890002@qq.com','管理范围2','upload/jieruguanli_touxiang2.jpg'),(23,'2022-12-29 09:38:15','接入账号3','123456','接入姓名3','男','13823888883','773890003@qq.com','管理范围3','upload/jieruguanli_touxiang3.jpg'),(24,'2022-12-29 09:38:15','接入账号4','123456','接入姓名4','男','13823888884','773890004@qq.com','管理范围4','upload/jieruguanli_touxiang4.jpg'),(25,'2022-12-29 09:38:15','接入账号5','123456','接入姓名5','男','13823888885','773890005@qq.com','管理范围5','upload/jieruguanli_touxiang5.jpg'),(26,'2022-12-29 09:38:15','接入账号6','123456','接入姓名6','男','13823888886','773890006@qq.com','管理范围6','upload/jieruguanli_touxiang6.jpg'),(27,'2022-12-29 09:38:15','接入账号7','123456','接入姓名7','男','13823888887','773890007@qq.com','管理范围7','upload/jieruguanli_touxiang7.jpg'),(28,'2022-12-29 09:38:15','接入账号8','123456','接入姓名8','男','13823888888','773890008@qq.com','管理范围8','upload/jieruguanli_touxiang8.jpg'),(1672306937718,'2022-12-29 09:42:17','2','2','2','男','13012312311','222@qq.com','北京','upload/1672306936887.jpeg');
    117. /*!40000 ALTER TABLE `jieruguanli` ENABLE KEYS */;
    118. UNLOCK TABLES;
    119.  
    120. --
    121. -- Table structure for table `token`
    122. --
    123.  
    124. DROP TABLE IF EXISTS `token`;
    125. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    126. /*!40101 SET character_set_client = utf8 */;
    127. CREATE TABLE `token` (
    128.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    129.   `userid` bigint(20) NOT NULL COMMENT '用户id',
    130.   `username` varchar(100) NOT NULL COMMENT '用户名',
    131.   `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
    132.   `role` varchar(100) DEFAULT NULL COMMENT '角色',
    133.   `token` varchar(200) NOT NULL COMMENT '密码',
    134.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
    135.   `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
    136.   PRIMARY KEY (`id`)
    137. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='token表';
    138. /*!40101 SET character_set_client = @saved_cs_client */;
    139.  
    140. --
    141. -- Dumping data for table `token`
    142. --
    143.  
    144. LOCK TABLES `token` WRITE;
    145. /*!40000 ALTER TABLE `token` DISABLE KEYS */;
    146. INSERT INTO `token` VALUES (1,1,'admin','users','管理员','gm2d1zfpjklovb0380nm74cu6o82p8sa','2022-12-29 09:39:18','2022-12-29 10:41:00'),(2,1672306900696,'1','yunyingshangguan','运营商管','xf99mcdnxf12bt2x0m50f31rmnhjcez2','2022-12-29 09:41:56','2022-12-29 10:41:57'),(3,1672306937718,'2','jieruguanli','接入管理','mdy1gystahp86ny159e4xolln3feibkq','2022-12-29 09:42:32','2022-12-29 10:43:54'),(4,1672307000319,'3','yonghu','用户','zbht44k3jeji8qbrxfnvd722h1kxdlpg','2022-12-29 09:45:12','2022-12-29 10:45:12');
    147. /*!40000 ALTER TABLE `token` ENABLE KEYS */;
    148. UNLOCK TABLES;
    149.  
    150. --
    151. -- Table structure for table `users`
    152. --
    153.  
    154. DROP TABLE IF EXISTS `users`;
    155. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    156. /*!40101 SET character_set_client = utf8 */;
    157. CREATE TABLE `users` (
    158.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    159.   `username` varchar(100) NOT NULL COMMENT '用户名',
    160.   `password` varchar(100) NOT NULL COMMENT '密码',
    161.   `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
    162.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
    163.   PRIMARY KEY (`id`)
    164. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
    165. /*!40101 SET character_set_client = @saved_cs_client */;
    166.  
    167. --
    168. -- Dumping data for table `users`
    169. --
    170.  
    171. LOCK TABLES `users` WRITE;
    172. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
    173. INSERT INTO `users` VALUES (1,'admin','admin','管理员','2022-12-29 09:38:15');
    174. /*!40000 ALTER TABLE `users` ENABLE KEYS */;
    175. UNLOCK TABLES;
    176.  
    177. --
    178. -- Table structure for table `yonghu`
    179. --
    180.  
    181. DROP TABLE IF EXISTS `yonghu`;
    182. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    183. /*!40101 SET character_set_client = utf8 */;
    184. CREATE TABLE `yonghu` (
    185.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    186.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    187.   `yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',
    188.   `mima` varchar(200) NOT NULL COMMENT '密码',
    189.   `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
    190.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    191.   `dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
    192.   `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
    193.   `zhuzhi` varchar(200) DEFAULT NULL COMMENT '住址',
    194.   `ipdizhi` varchar(200) DEFAULT NULL COMMENT 'ip地址',
    195.   `yonghuzu` varchar(200) DEFAULT NULL COMMENT '用户组',
    196.   `yonghuleixing` varchar(200) DEFAULT NULL COMMENT '用户类型',
    197.   `touxiang` longtext COMMENT '头像',
    198.   `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
    199.   `shhf` longtext COMMENT '审核回复',
    200.   PRIMARY KEY (`id`),
    201.   UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)
    202. ) ENGINE=InnoDB AUTO_INCREMENT=1672307000320 DEFAULT CHARSET=utf8 COMMENT='用户';
    203. /*!40101 SET character_set_client = @saved_cs_client */;
    204.  
    205. --
    206. -- Dumping data for table `yonghu`
    207. --
    208.  
    209. LOCK TABLES `yonghu` WRITE;
    210. /*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
    211. INSERT INTO `yonghu` VALUES (31,'2022-12-29 09:38:15','用户账号1','123456','用户姓名1','男','13823888881','773890001@qq.com','住址1','ip地址1','用户组1','普通用户','upload/yonghu_touxiang1.jpg','是',''),(32,'2022-12-29 09:38:15','用户账号2','123456','用户姓名2','男','13823888882','773890002@qq.com','住址2','ip地址2','用户组2','普通用户','upload/yonghu_touxiang2.jpg','是',''),(33,'2022-12-29 09:38:15','用户账号3','123456','用户姓名3','男','13823888883','773890003@qq.com','住址3','ip地址3','用户组3','普通用户','upload/yonghu_touxiang3.jpg','是',''),(34,'2022-12-29 09:38:15','用户账号4','123456','用户姓名4','男','13823888884','773890004@qq.com','住址4','ip地址4','用户组4','普通用户','upload/yonghu_touxiang4.jpg','是',''),(35,'2022-12-29 09:38:15','用户账号5','123456','用户姓名5','男','13823888885','773890005@qq.com','住址5','ip地址5','用户组5','普通用户','upload/yonghu_touxiang5.jpg','是',''),(36,'2022-12-29 09:38:15','用户账号6','123456','用户姓名6','男','13823888886','773890006@qq.com','住址6','ip地址6','用户组6','普通用户','upload/yonghu_touxiang6.jpg','是',''),(37,'2022-12-29 09:38:15','用户账号7','123456','用户姓名7','男','13823888887','773890007@qq.com','住址7','ip地址7','用户组7','普通用户','upload/yonghu_touxiang7.jpg','是',''),(38,'2022-12-29 09:38:15','用户账号8','123456','用户姓名8','男','13823888888','773890008@qq.com','住址8','ip地址8','用户组8','普通用户','upload/yonghu_touxiang8.jpg','是',''),(1672307000319,'2022-12-29 09:43:20','3','3','3','男','13012312311','222@qq.com','xxx','12.121.121','个人','认证用户','upload/1672306998702.jpeg','是','1');
    212. /*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
    213. UNLOCK TABLES;
    214.  
    215. --
    216. -- Table structure for table `yonghuzu`
    217. --
    218.  
    219. DROP TABLE IF EXISTS `yonghuzu`;
    220. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    221. /*!40101 SET character_set_client = utf8 */;
    222. CREATE TABLE `yonghuzu` (
    223.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    224.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    225.   `yonghuzu` varchar(200) DEFAULT NULL COMMENT '用户组',
    226.   PRIMARY KEY (`id`),
    227.   UNIQUE KEY `yonghuzu` (`yonghuzu`)
    228. ) ENGINE=InnoDB AUTO_INCREMENT=1672306963194 DEFAULT CHARSET=utf8 COMMENT='用户组';
    229. /*!40101 SET character_set_client = @saved_cs_client */;
    230.  
    231. --
    232. -- Dumping data for table `yonghuzu`
    233. --
    234.  
    235. LOCK TABLES `yonghuzu` WRITE;
    236. /*!40000 ALTER TABLE `yonghuzu` DISABLE KEYS */;
    237. INSERT INTO `yonghuzu` VALUES (41,'2022-12-29 09:38:15','用户组1'),(42,'2022-12-29 09:38:15','用户组2'),(43,'2022-12-29 09:38:15','用户组3'),(44,'2022-12-29 09:38:15','用户组4'),(45,'2022-12-29 09:38:15','用户组5'),(46,'2022-12-29 09:38:15','用户组6'),(47,'2022-12-29 09:38:15','用户组7'),(48,'2022-12-29 09:38:15','一组'),(1672306963193,'2022-12-29 09:42:42','个人');
    238. /*!40000 ALTER TABLE `yonghuzu` ENABLE KEYS */;
    239. UNLOCK TABLES;
    240.  
    241. --
    242. -- Table structure for table `yunyingshangguan`
    243. --
    244.  
    245. DROP TABLE IF EXISTS `yunyingshangguan`;
    246. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    247. /*!40101 SET character_set_client = utf8 */;
    248. CREATE TABLE `yunyingshangguan` (
    249.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    250.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    251.   `yunyingzhanghao` varchar(200) NOT NULL COMMENT '运营账号',
    252.   `mima` varchar(200) NOT NULL COMMENT '密码',
    253.   `yunyingxingming` varchar(200) DEFAULT NULL COMMENT '运营姓名',
    254.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    255.   `dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
    256.   `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
    257.   `touxiang` longtext COMMENT '头像',
    258.   PRIMARY KEY (`id`),
    259.   UNIQUE KEY `yunyingzhanghao` (`yunyingzhanghao`)
    260. ) ENGINE=InnoDB AUTO_INCREMENT=1672306900697 DEFAULT CHARSET=utf8 COMMENT='运营商管';
    261. /*!40101 SET character_set_client = @saved_cs_client */;
    262.  
    263. --
    264. -- Dumping data for table `yunyingshangguan`
    265. --
    266.  
    267. LOCK TABLES `yunyingshangguan` WRITE;
    268. /*!40000 ALTER TABLE `yunyingshangguan` DISABLE KEYS */;
    269. INSERT INTO `yunyingshangguan` VALUES (11,'2022-12-29 09:38:15','运营账号1','123456','运营姓名1','男','13823888881','773890001@qq.com','upload/yunyingshangguan_touxiang1.jpg'),(12,'2022-12-29 09:38:15','运营账号2','123456','运营姓名2','男','13823888882','773890002@qq.com','upload/yunyingshangguan_touxiang2.jpg'),(13,'2022-12-29 09:38:15','运营账号3','123456','运营姓名3','男','13823888883','773890003@qq.com','upload/yunyingshangguan_touxiang3.jpg'),(14,'2022-12-29 09:38:15','运营账号4','123456','运营姓名4','男','13823888884','773890004@qq.com','upload/yunyingshangguan_touxiang4.jpg'),(15,'2022-12-29 09:38:15','运营账号5','123456','运营姓名5','男','13823888885','773890005@qq.com','upload/yunyingshangguan_touxiang5.jpg'),(16,'2022-12-29 09:38:15','运营账号6','123456','运营姓名6','男','13823888886','773890006@qq.com','upload/yunyingshangguan_touxiang6.jpg'),(17,'2022-12-29 09:38:15','运营账号7','123456','运营姓名7','男','13823888887','773890007@qq.com','upload/yunyingshangguan_touxiang7.jpg'),(18,'2022-12-29 09:38:15','运营账号8','123456','运营姓名8','男','13823888888','773890008@qq.com','upload/yunyingshangguan_touxiang8.jpg'),(1672306900696,'2022-12-29 09:41:40','1','1','1','男','13012312311','222@qq.com','upload/1672306899829.jpeg');
    270. /*!40000 ALTER TABLE `yunyingshangguan` ENABLE KEYS */;
    271. UNLOCK TABLES;
    272. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    273.  
    274. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    275. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    276. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    277. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    278. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    279. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    280. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    281.  
    282. -- Dump completed on

    5、关键代码

    5.1 接入管理Controller模块 

    1. package com.controller;
    2.  
    3. import java.text.SimpleDateFormat;
    4. import java.util.ArrayList;
    5. import java.util.Arrays;
    6. import java.util.Calendar;
    7. import java.util.Map;
    8. import java.util.HashMap;
    9. import java.util.Iterator;
    10. import java.util.Date;
    11. import java.util.List;
    12. import javax.servlet.http.HttpServletRequest;
    13.  
    14. import com.utils.ValidatorUtils;
    15. import org.apache.commons.lang3.StringUtils;
    16. import org.springframework.beans.factory.annotation.Autowired;
    17. import org.springframework.transaction.annotation.Transactional;
    18. import org.springframework.format.annotation.DateTimeFormat;
    19. import org.springframework.web.bind.annotation.PathVariable;
    20. import org.springframework.web.bind.annotation.RequestBody;
    21. import org.springframework.web.bind.annotation.RequestMapping;
    22. import org.springframework.web.bind.annotation.RequestParam;
    23. import org.springframework.web.bind.annotation.RestController;
    24. import com.baomidou.mybatisplus.mapper.EntityWrapper;
    25. import com.baomidou.mybatisplus.mapper.Wrapper;
    26. import com.annotation.IgnoreAuth;
    27.  
    28. import com.entity.JieruguanliEntity;
    29. import com.entity.view.JieruguanliView;
    30.  
    31. import com.service.JieruguanliService;
    32. import com.service.TokenService;
    33. import com.utils.PageUtils;
    34. import com.utils.R;
    35. import com.utils.MD5Util;
    36. import com.utils.MPUtil;
    37. import com.utils.CommonUtil;
    38. import java.io.IOException;
    39.  
    40. /**
    41.  * 接入管理
    42.  * 后端接口
    43.  * @author 
    44.  * @email 
    45.  * @date 
    46.  */
    47. @RestController
    48. @RequestMapping("/jieruguanli")
    49. public class JieruguanliController {
    50.     @Autowired
    51.     private JieruguanliService jieruguanliService;
    52.  
    53. 	@Autowired
    54. 	private TokenService tokenService;
    55. 	
    56. 	/**
    57. 	 * 登录
    58. 	 */
    59. 	@IgnoreAuth
    60. 	@RequestMapping(value = "/login")
    61. 	public R login(String username, String password, String captcha, HttpServletRequest request) {
    62. 		JieruguanliEntity u = jieruguanliService.selectOne(new EntityWrapper().eq("jieruzhanghao", username));
    63. 		if(u==null || !u.getMima().equals(password)) {
    64. 			return R.error("账号或密码不正确");
    65. 		}
    66. 		
    67. 		String token = tokenService.generateToken(u.getId(), username,"jieruguanli",  "接入管理" );
    68. 		return R.ok().put("token", token);
    69. 	}
    70. 	
    71. 	/**
    72.      * 注册
    73.      */
    74. 	@IgnoreAuth
    75.     @RequestMapping("/register")
    76.     public R register(@RequestBody JieruguanliEntity jieruguanli){
    77.     	//ValidatorUtils.validateEntity(jieruguanli);
    78.     	JieruguanliEntity u = jieruguanliService.selectOne(new EntityWrapper().eq("jieruzhanghao", jieruguanli.getJieruzhanghao()));
    79. 		if(u!=null) {
    80. 			return R.error("注册用户已存在");
    81. 		}
    82. 		Long uId = new Date().getTime();
    83. 		jieruguanli.setId(uId);
    84.         jieruguanliService.insert(jieruguanli);
    85.         return R.ok();
    86.     }
    87.  
    88. 	/**
    89. 	 * 退出
    90. 	 */
    91. 	@RequestMapping("/logout")
    92. 	public R logout(HttpServletRequest request) {
    93. 		request.getSession().invalidate();
    94. 		return R.ok("退出成功");
    95. 	}
    96. 	
    97. 	/**
    98.      * 获取用户的session用户信息
    99.      */
    100.     @RequestMapping("/session")
    101.     public R getCurrUser(HttpServletRequest request){
    102.     	Long id = (Long)request.getSession().getAttribute("userId");
    103.         JieruguanliEntity u = jieruguanliService.selectById(id);
    104.         return R.ok().put("data", u);
    105.     }
    106.     
    107.     /**
    108.      * 密码重置
    109.      */
    110.     @IgnoreAuth
    111. 	@RequestMapping(value = "/resetPass")
    112.     public R resetPass(String username, HttpServletRequest request){
    113.     	JieruguanliEntity u = jieruguanliService.selectOne(new EntityWrapper().eq("jieruzhanghao", username));
    114.     	if(u==null) {
    115.     		return R.error("账号不存在");
    116.     	}
    117.         u.setMima("123456");
    118.         jieruguanliService.updateById(u);
    119.         return R.ok("密码已重置为：123456");
    120.     }
    121.  
    122.     /**
    123.      * 后端列表
    124.      */
    125.     @RequestMapping("/page")
    126.     public R page(@RequestParam Map params,JieruguanliEntity jieruguanli,
    127. 		HttpServletRequest request){
    128.         EntityWrapper ew = new EntityWrapper();
    129.  
    130. 		PageUtils page = jieruguanliService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jieruguanli), params), params));
    131.  
    132.         return R.ok().put("data", page);
    133.     }
    134.     
    135.     /**
    136.      * 前端列表
    137.      */
    138. 	@IgnoreAuth
    139.     @RequestMapping("/list")
    140.     public R list(@RequestParam Map params,JieruguanliEntity jieruguanli, 
    141. 		HttpServletRequest request){
    142.         EntityWrapper ew = new EntityWrapper();
    143.  
    144. 		PageUtils page = jieruguanliService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jieruguanli), params), params));
    145.         return R.ok().put("data", page);
    146.     }
    147.  
    148. 	/**
    149.      * 列表
    150.      */
    151.     @RequestMapping("/lists")
    152.     public R list( JieruguanliEntity jieruguanli){
    153.        	EntityWrapper ew = new EntityWrapper();
    154.       	ew.allEq(MPUtil.allEQMapPre( jieruguanli, "jieruguanli")); 
    155.         return R.ok().put("data", jieruguanliService.selectListView(ew));
    156.     }
    157.  
    158. 	 /**
    159.      * 查询
    160.      */
    161.     @RequestMapping("/query")
    162.     public R query(JieruguanliEntity jieruguanli){
    163.         EntityWrapper< JieruguanliEntity> ew = new EntityWrapper< JieruguanliEntity>();
    164.  		ew.allEq(MPUtil.allEQMapPre( jieruguanli, "jieruguanli")); 
    165. 		JieruguanliView jieruguanliView =  jieruguanliService.selectView(ew);
    166. 		return R.ok("查询接入管理成功").put("data", jieruguanliView);
    167.     }
    168. 	
    169.     /**
    170.      * 后端详情
    171.      */
    172.     @RequestMapping("/info/{id}")
    173.     public R info(@PathVariable("id") Long id){
    174.         JieruguanliEntity jieruguanli = jieruguanliService.selectById(id);
    175.         return R.ok().put("data", jieruguanli);
    176.     }
    177.  
    178.     /**
    179.      * 前端详情
    180.      */
    181. 	@IgnoreAuth
    182.     @RequestMapping("/detail/{id}")
    183.     public R detail(@PathVariable("id") Long id){
    184.         JieruguanliEntity jieruguanli = jieruguanliService.selectById(id);
    185.         return R.ok().put("data", jieruguanli);
    186.     }
    187.     
    188.     /**
    189.      * 后端保存
    190.      */
    191.     @RequestMapping("/save")
    192.     public R save(@RequestBody JieruguanliEntity jieruguanli, HttpServletRequest request){
    193.     	jieruguanli.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    194.     	//ValidatorUtils.validateEntity(jieruguanli);
    195.     	JieruguanliEntity u = jieruguanliService.selectOne(new EntityWrapper().eq("jieruzhanghao", jieruguanli.getJieruzhanghao()));
    196. 		if(u!=null) {
    197. 			return R.error("用户已存在");
    198. 		}
    199. 		jieruguanli.setId(new Date().getTime());
    200.         jieruguanliService.insert(jieruguanli);
    201.         return R.ok();
    202.     }
    203.     
    204.     /**
    205.      * 前端保存
    206.      */
    207.     @RequestMapping("/add")
    208.     public R add(@RequestBody JieruguanliEntity jieruguanli, HttpServletRequest request){
    209.     	jieruguanli.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    210.     	//ValidatorUtils.validateEntity(jieruguanli);
    211.     	JieruguanliEntity u = jieruguanliService.selectOne(new EntityWrapper().eq("jieruzhanghao", jieruguanli.getJieruzhanghao()));
    212. 		if(u!=null) {
    213. 			return R.error("用户已存在");
    214. 		}
    215. 		jieruguanli.setId(new Date().getTime());
    216.         jieruguanliService.insert(jieruguanli);
    217.         return R.ok();
    218.     }
    219.  
    220.     /**
    221.      * 修改
    222.      */
    223.     @RequestMapping("/update")
    224.     @Transactional
    225.     public R update(@RequestBody JieruguanliEntity jieruguanli, HttpServletRequest request){
    226.         //ValidatorUtils.validateEntity(jieruguanli);
    227.         jieruguanliService.updateById(jieruguanli);//全部更新
    228.         return R.ok();
    229.     }
    230.     
    231.     /**
    232.      * 删除
    233.      */
    234.     @RequestMapping("/delete")
    235.     public R delete(@RequestBody Long[] ids){
    236.         jieruguanliService.deleteBatchIds(Arrays.asList(ids));
    237.         return R.ok();
    238.     }
    239.     
    240.     /**
    241.      * 提醒接口
    242.      */
    243. 	@RequestMapping("/remind/{columnName}/{type}")
    244. 	public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, 
    245. 						 @PathVariable("type") String type,@RequestParam Map map) {
    246. 		map.put("column", columnName);
    247. 		map.put("type", type);
    248. 		
    249. 		if(type.equals("2")) {
    250. 			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
    251. 			Calendar c = Calendar.getInstance();
    252. 			Date remindStartDate = null;
    253. 			Date remindEndDate = null;
    254. 			if(map.get("remindstart")!=null) {
    255. 				Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
    256. 				c.setTime(new Date()); 
    257. 				c.add(Calendar.DAY_OF_MONTH,remindStart);
    258. 				remindStartDate = c.getTime();
    259. 				map.put("remindstart", sdf.format(remindStartDate));
    260. 			}
    261. 			if(map.get("remindend")!=null) {
    262. 				Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
    263. 				c.setTime(new Date());
    264. 				c.add(Calendar.DAY_OF_MONTH,remindEnd);
    265. 				remindEndDate = c.getTime();
    266. 				map.put("remindend", sdf.format(remindEndDate));
    267. 			}
    268. 		}
    269. 		
    270. 		Wrapper wrapper = new EntityWrapper();
    271. 		if(map.get("remindstart")!=null) {
    272. 			wrapper.ge(columnName, map.get("remindstart"));
    273. 		}
    274. 		if(map.get("remindend")!=null) {
    275. 			wrapper.le(columnName, map.get("remindend"));
    276. 		}
    277.  
    278. 		int count = jieruguanliService.selectCount(wrapper);
    279. 		return R.ok().put("count", count);
    280. 	}
    281.  
    282. }

    5.2 接入管理Service模块 

    1. package com.service;
    2.  
    3. import com.baomidou.mybatisplus.mapper.Wrapper;
    4. import com.baomidou.mybatisplus.service.IService;
    5. import com.utils.PageUtils;
    6. import com.entity.JieruguanliEntity;
    7. import java.util.List;
    8. import java.util.Map;
    9. import com.entity.vo.JieruguanliVO;
    10. import org.apache.ibatis.annotations.Param;
    11. import com.entity.view.JieruguanliView;
    12.  
    13. /**
    14.  * 接入管理
    15.  *
    16.  * @author 
    17.  * @email 
    18.  * @date 
    19.  */
    20. public interface JieruguanliService extends IService {
    21.  
    22.     PageUtils queryPage(Map params);
    23.     
    24.    	List selectListVO(Wrapper wrapper);
    25.    	
    26.    	JieruguanliVO selectVO(@Param("ew") Wrapper wrapper);
    27.    	
    28.    	List selectListView(Wrapper wrapper);
    29.    	
    30.    	JieruguanliView selectView(@Param("ew") Wrapper wrapper);
    31.    	
    32.    	PageUtils queryPage(Map params,Wrapper wrapper);
    33.  	
    34. }
    35.

    5.3 接入管理ServiceImpl模块

    1. package com.service;
    2.  
    3. import com.baomidou.mybatisplus.mapper.Wrapper;
    4. import com.baomidou.mybatisplus.service.IService;
    5. import com.utils.PageUtils;
    6. import com.entity.JieruguanliEntity;
    7. import java.util.List;
    8. import java.util.Map;
    9. import com.entity.vo.JieruguanliVO;
    10. import org.apache.ibatis.annotations.Param;
    11. import com.entity.view.JieruguanliView;
    12.  
    13. /**
    14.  * 接入管理
    15.  *
    16.  * @author 
    17.  * @email 
    18.  * @date 
    19.  */
    20. public interface JieruguanliService extends IService {
    21.  
    22.     PageUtils queryPage(Map params);
    23.     
    24.    	List selectListVO(Wrapper wrapper);
    25.    	
    26.    	JieruguanliVO selectVO(@Param("ew") Wrapper wrapper);
    27.    	
    28.    	List selectListView(Wrapper wrapper);
    29.    	
    30.    	JieruguanliView selectView(@Param("ew") Wrapper wrapper);
    31.    	
    32.    	PageUtils queryPage(Map params,Wrapper wrapper);
    33.    	
    34. }
    35.

    5.4 接入管理Dao模块

    1. package com.dao;
    2.  
    3. import com.entity.JieruguanliEntity;
    4. import com.baomidou.mybatisplus.mapper.BaseMapper;
    5. import java.util.List;
    6. import java.util.Map;
    7. import com.baomidou.mybatisplus.mapper.Wrapper;
    8. import com.baomidou.mybatisplus.plugins.pagination.Pagination;
    9.  
    10. import org.apache.ibatis.annotations.Param;
    11. import com.entity.vo.JieruguanliVO;
    12. import com.entity.view.JieruguanliView;
    13.  
    14. /**
    15.  * 接入管理
    16.  * 
    17.  * @author 
    18.  * @email 
    19.  * @date 
    20.  */
    21. public interface JieruguanliDao extends BaseMapper {
    22. 	
    23. 	List selectListVO(@Param("ew") Wrapper wrapper);
    24. 	
    25. 	JieruguanliVO selectVO(@Param("ew") Wrapper wrapper);
    26. 	
    27. 	List selectListView(@Param("ew") Wrapper wrapper);
    28.  
    29. 	List selectListView(Pagination page,@Param("ew") Wrapper wrapper);
    30. 	
    31. 	JieruguanliView selectView(@Param("ew") Wrapper wrapper);
    32. 	
    33. }

    6、源码获取

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

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

    →获取源码请私信←

  • 相关阅读:
    Java数据结构算法：算法的空间复杂度分析
    [2023 java毕业设计源码]基于SpringBoot的在线交友系统包运行成功]
    QT控件 — QScrollArea
    CMake输出编译时间信息
    Maven私服搭建与使用：nexus，repository，mirror，distributionManagement
    中台深入剖析和实现技巧
    LeetCode题解—260.只出现一次的数字Ⅲ
    15：00面试，15：08就出来了，问的问题有点变态。。。
    【Java】抽象类和接口
    Sui Lutris：Sui核心的分布式系统协议
  • 原文地址：https://blog.csdn.net/m0_74181697/article/details/134520818