计算机毕业设计 基于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、论文目录结构

7、源码获取


1、项目介绍及开发技术

1.1 项目介绍

当前大学生双创竞赛项目申报与路演管理存在一些问题,如信息不对称、流程繁琐等。学生和专家在申报和管理过程中需要花费大量时间和精力,而管理员则需要处理大量的数据和信息。本课题旨在设计并实现一个基于SpringBoot的大学生双创竞赛项目申报与路演管理系统,以提高申报和管理的效率,减轻学生、专家和管理员的工作负担。该系统的实现会帮助学生更好地参与创新创业活动,提高他们的实践能力和创新意识。同时,专家可以通过系统快速了解学生的项目情况,为评审提供便利。管理员则可以更加高效地管理学生、专家和项目信息,提高工作效率。

在需求分析阶段,我了解到学生、专家和管理员的功能需求,包括注册登录、首页、个人中心(修改密码、个人信息)、创新企业管理、路演项目管理、创新创业评审管理、路演项目评审管理等。在系统设计阶段,我们采用了分层架构设计,包括表示层、业务逻辑层和数据访问层。在数据库设计阶段,我们选择了MySQL数据库来存储和管理数据。在系统实现阶段,我们使用Java编程语言和SpringBoot框架来实现系统的全部功能。我们按照模块化的开发方式,将系统划分为多个模块,并实现了各个模块之间的协同工作。在系统测试阶段,我们对系统进行了全面的功能测试和性能测试,确保系统的稳定性和可靠性。

1.2 开发技术

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

2、系统功能模块设计

学生:注册登录、首页、个人中心(修改密码、个人信息)、创新企业管理、路演项目管理、创新创业评审管理、路演项目评审管理。

专家:注册登录、首页、个人中心(修改密码、个人信息)、创新企业管理、路演项目管理、创新创业评审管理、路演项目评审管理。

管理员:登录、首页、个人中心(修改密码、个人信息)、学生管理、专家管理、创新企业管理、路演项目管理、创新创业评审管理、路演项目评审管理。

3、功能截图

登录

注册

 首页

个人中心

学生管理

专家管理

创新创业管理

路演项目管理

创新创业评审管理

路演项目评审管理

4、数据库表结构设计

-- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost    Database: springboot0f6p9
-- ------------------------------------------------------
-- Server version	5.7.31

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `springboot0f6p9`
--

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

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

USE `springboot0f6p9`;

--
-- Table structure for table `chuangxinchuangye`
--

DROP TABLE IF EXISTS `chuangxinchuangye`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chuangxinchuangye` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '项目名称',
  `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '项目类型',
  `xiangmudengji` varchar(200) DEFAULT NULL COMMENT '项目等级',
  `xiangmufujian` longtext COMMENT '项目附件',
  `shenbaoshijian` datetime DEFAULT NULL COMMENT '申报时间',
  `shenbaoshuoming` longtext COMMENT '申报说明',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1680185448649 DEFAULT CHARSET=utf8 COMMENT='创新创业';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chuangxinchuangye`
--

LOCK TABLES `chuangxinchuangye` WRITE;
/*!40000 ALTER TABLE `chuangxinchuangye` DISABLE KEYS */;
INSERT INTO `chuangxinchuangye` VALUES (31,'2023-03-30 14:04:00','项目名称1','项目类型1','项目等级1','','2023-03-30 22:04:00','申报说明1','学号1','姓名1'),(32,'2023-03-30 14:04:00','项目名称2','项目类型2','项目等级2','','2023-03-30 22:04:00','申报说明2','学号2','姓名2'),(33,'2023-03-30 14:04:00','项目名称3','项目类型3','项目等级3','','2023-03-30 22:04:00','申报说明3','学号3','姓名3'),(34,'2023-03-30 14:04:00','项目名称4','项目类型4','项目等级4','','2023-03-30 22:04:00','申报说明4','学号4','姓名4'),(35,'2023-03-30 14:04:00','项目名称5','项目类型5','项目等级5','','2023-03-30 22:04:00','申报说明5','学号5','姓名5'),(36,'2023-03-30 14:04:00','项目名称6','项目类型6','项目等级6','','2023-03-30 22:04:00','申报说明6','学号6','姓名6'),(37,'2023-03-30 14:04:00','项目名称7','项目类型7','项目等级7','','2023-03-30 22:04:00','申报说明7','学号7','姓名7'),(38,'2023-03-30 14:04:00','项目名称8','项目类型8','项目等级8','','2023-03-30 22:04:00','申报说明8','学号8','姓名8'),(1680185448648,'2023-03-30 14:10:48','XX项目','XX类型','XX等级','upload/1680185435850.jpg','2023-03-30 22:10:00','XXXXXX','111','张三');
/*!40000 ALTER TABLE `chuangxinchuangye` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chuangxinchuangyepingshen`
--

DROP TABLE IF EXISTS `chuangxinchuangyepingshen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chuangxinchuangyepingshen` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '项目名称',
  `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '项目类型',
  `xiangmudengji` varchar(200) DEFAULT NULL COMMENT '项目等级',
  `pingshenshijian` datetime DEFAULT NULL COMMENT '评审时间',
  `pingshenfenshu` int(11) DEFAULT NULL COMMENT '评审分数',
  `pingshenyijian` longtext COMMENT '评审意见',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `zhuanjiazhanghao` varchar(200) DEFAULT NULL COMMENT '专家账号',
  `zhuanjiaxingming` varchar(200) DEFAULT NULL COMMENT '专家姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1680185541548 DEFAULT CHARSET=utf8 COMMENT='创新创业评审';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chuangxinchuangyepingshen`
--

LOCK TABLES `chuangxinchuangyepingshen` WRITE;
/*!40000 ALTER TABLE `chuangxinchuangyepingshen` DISABLE KEYS */;
INSERT INTO `chuangxinchuangyepingshen` VALUES (51,'2023-03-30 14:04:00','项目名称1','项目类型1','项目等级1','2023-03-30 22:04:00',1,'评审意见1','学号1','姓名1','专家账号1','专家姓名1'),(52,'2023-03-30 14:04:00','项目名称2','项目类型2','项目等级2','2023-03-30 22:04:00',2,'评审意见2','学号2','姓名2','专家账号2','专家姓名2'),(53,'2023-03-30 14:04:00','项目名称3','项目类型3','项目等级3','2023-03-30 22:04:00',3,'评审意见3','学号3','姓名3','专家账号3','专家姓名3'),(54,'2023-03-30 14:04:00','项目名称4','项目类型4','项目等级4','2023-03-30 22:04:00',4,'评审意见4','学号4','姓名4','专家账号4','专家姓名4'),(55,'2023-03-30 14:04:00','项目名称5','项目类型5','项目等级5','2023-03-30 22:04:00',5,'评审意见5','学号5','姓名5','专家账号5','专家姓名5'),(56,'2023-03-30 14:04:00','项目名称6','项目类型6','项目等级6','2023-03-30 22:04:00',6,'评审意见6','学号6','姓名6','专家账号6','专家姓名6'),(57,'2023-03-30 14:04:00','项目名称7','项目类型7','项目等级7','2023-03-30 22:04:00',7,'评审意见7','学号7','姓名7','专家账号7','专家姓名7'),(58,'2023-03-30 14:04:00','项目名称8','项目类型8','项目等级8','2023-03-30 22:04:00',8,'评审意见8','学号8','姓名8','专家账号8','专家姓名8'),(1680185500489,'2023-03-30 14:11:40','XX项目','XX类型','XX等级','2023-03-30 22:11:14',90,'xxxx','111','张三','222','李四'),(1680185541547,'2023-03-30 14:12:20','XX项目','XX类型','XX等级','2023-03-30 22:11:55',85,'xxxx','111','张三','专家账号1','专家姓名1');
/*!40000 ALTER TABLE `chuangxinchuangyepingshen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config`
--

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config`
--

LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `luyanxiangmu`
--

DROP TABLE IF EXISTS `luyanxiangmu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `luyanxiangmu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `luyanmingcheng` varchar(200) DEFAULT NULL COMMENT '路演名称',
  `luyandidian` varchar(200) DEFAULT NULL COMMENT '路演地点',
  `luyanfangshi` varchar(200) DEFAULT NULL COMMENT '路演方式',
  `luyanshipin` longtext COMMENT '路演视频',
  `luyanjianjie` longtext COMMENT '路演简介',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1680185471924 DEFAULT CHARSET=utf8 COMMENT='路演项目';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `luyanxiangmu`
--

LOCK TABLES `luyanxiangmu` WRITE;
/*!40000 ALTER TABLE `luyanxiangmu` DISABLE KEYS */;
INSERT INTO `luyanxiangmu` VALUES (41,'2023-03-30 14:04:00','路演名称1','路演地点1','路演方式1','','路演简介1','学号1','姓名1'),(42,'2023-03-30 14:04:00','路演名称2','路演地点2','路演方式2','','路演简介2','学号2','姓名2'),(43,'2023-03-30 14:04:00','路演名称3','路演地点3','路演方式3','','路演简介3','学号3','姓名3'),(44,'2023-03-30 14:04:00','路演名称4','路演地点4','路演方式4','','路演简介4','学号4','姓名4'),(45,'2023-03-30 14:04:00','路演名称5','路演地点5','路演方式5','','路演简介5','学号5','姓名5'),(46,'2023-03-30 14:04:00','路演名称6','路演地点6','路演方式6','','路演简介6','学号6','姓名6'),(47,'2023-03-30 14:04:00','路演名称7','路演地点7','路演方式7','','路演简介7','学号7','姓名7'),(48,'2023-03-30 14:04:00','路演名称8','路演地点8','路演方式8','','路演简介8','学号8','姓名8'),(1680185471923,'2023-03-30 14:11:11','XX路演','XX地点','XX方式','upload/1680185468848.mp4','XXXX','111','张三');
/*!40000 ALTER TABLE `luyanxiangmu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `luyanxiangmupingshen`
--

DROP TABLE IF EXISTS `luyanxiangmupingshen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `luyanxiangmupingshen` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `luyanmingcheng` varchar(200) DEFAULT NULL COMMENT '路演名称',
  `luyandidian` varchar(200) DEFAULT NULL COMMENT '路演地点',
  `luyanfangshi` varchar(200) DEFAULT NULL COMMENT '路演方式',
  `pingshenshijian` datetime DEFAULT NULL COMMENT '评审时间',
  `pingshenfenshu` int(11) DEFAULT NULL COMMENT '评审分数',
  `pingshenyijian` longtext COMMENT '评审意见',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `zhuanjiazhanghao` varchar(200) DEFAULT NULL COMMENT '专家账号',
  `zhuanjiaxingming` varchar(200) DEFAULT NULL COMMENT '专家姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1680185546940 DEFAULT CHARSET=utf8 COMMENT='路演项目评审';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `luyanxiangmupingshen`
--

LOCK TABLES `luyanxiangmupingshen` WRITE;
/*!40000 ALTER TABLE `luyanxiangmupingshen` DISABLE KEYS */;
INSERT INTO `luyanxiangmupingshen` VALUES (61,'2023-03-30 14:04:00','路演名称1','路演地点1','路演方式1','2023-03-30 22:04:00',1,'评审意见1','学号1','姓名1','专家账号1','专家姓名1'),(62,'2023-03-30 14:04:00','路演名称2','路演地点2','路演方式2','2023-03-30 22:04:00',2,'评审意见2','学号2','姓名2','专家账号2','专家姓名2'),(63,'2023-03-30 14:04:00','路演名称3','路演地点3','路演方式3','2023-03-30 22:04:00',3,'评审意见3','学号3','姓名3','专家账号3','专家姓名3'),(64,'2023-03-30 14:04:00','路演名称4','路演地点4','路演方式4','2023-03-30 22:04:00',4,'评审意见4','学号4','姓名4','专家账号4','专家姓名4'),(65,'2023-03-30 14:04:00','路演名称5','路演地点5','路演方式5','2023-03-30 22:04:00',5,'评审意见5','学号5','姓名5','专家账号5','专家姓名5'),(66,'2023-03-30 14:04:00','路演名称6','路演地点6','路演方式6','2023-03-30 22:04:00',6,'评审意见6','学号6','姓名6','专家账号6','专家姓名6'),(67,'2023-03-30 14:04:00','路演名称7','路演地点7','路演方式7','2023-03-30 22:04:00',7,'评审意见7','学号7','姓名7','专家账号7','专家姓名7'),(68,'2023-03-30 14:04:00','路演名称8','路演地点8','路演方式8','2023-03-30 22:04:00',8,'评审意见8','学号8','姓名8','专家账号8','专家姓名8'),(1680185511042,'2023-03-30 14:11:50','XX路演','XX地点','XX方式','2023-03-30 22:11:25',90,'xxxx','111','张三','222','李四'),(1680185546939,'2023-03-30 14:12:26','XX路演','XX地点','XX方式','2023-03-30 22:12:02',85,'xxxx','111','张三','专家账号1','专家姓名1');
/*!40000 ALTER TABLE `luyanxiangmupingshen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `token`
--

DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(200) NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `token`
--

LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,1680185395817,'111','xuesheng','学生','i4wtznb98i2wt008ecg5z1s73mel8702','2023-03-30 14:10:15','2023-03-30 15:12:35'),(2,1680185410373,'222','zhuanjia','专家','wvael690jszlz9medbc10irg4j15esnx','2023-03-30 14:11:24','2023-03-30 15:11:24'),(3,21,'专家账号1','zhuanjia','专家','g87gcuyr2e6mzboednvk7lpxayzxxu0x','2023-03-30 14:12:13','2023-03-30 15:12:13'),(4,1,'admin','users','管理员','u01sis1qcd2u3j1gbflv8x6jqom30i3d','2023-03-30 14:12:45','2023-03-30 15:12:45');
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','admin','管理员','2023-03-30 14:04:00');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xuesheng`
--

DROP TABLE IF EXISTS `xuesheng`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuesheng` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xuehao` varchar(200) NOT NULL COMMENT '学号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `xingming` varchar(200) NOT NULL COMMENT '姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `xueyuan` varchar(200) DEFAULT NULL COMMENT '学院',
  `nianji` varchar(200) DEFAULT NULL COMMENT '年级',
  `banji` varchar(200) DEFAULT NULL COMMENT '班级',
  `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `touxiang` longtext COMMENT '头像',
  PRIMARY KEY (`id`),
  UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=1680185395818 DEFAULT CHARSET=utf8 COMMENT='学生';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xuesheng`
--

LOCK TABLES `xuesheng` WRITE;
/*!40000 ALTER TABLE `xuesheng` DISABLE KEYS */;
INSERT INTO `xuesheng` VALUES (11,'2023-03-30 14:04:00','学号1','123456','姓名1','男','学院1','年级1','班级1','13823888881','upload/xuesheng_touxiang1.jpg'),(12,'2023-03-30 14:04:00','学号2','123456','姓名2','男','学院2','年级2','班级2','13823888882','upload/xuesheng_touxiang2.jpg'),(13,'2023-03-30 14:04:00','学号3','123456','姓名3','男','学院3','年级3','班级3','13823888883','upload/xuesheng_touxiang3.jpg'),(14,'2023-03-30 14:04:00','学号4','123456','姓名4','男','学院4','年级4','班级4','13823888884','upload/xuesheng_touxiang4.jpg'),(15,'2023-03-30 14:04:00','学号5','123456','姓名5','男','学院5','年级5','班级5','13823888885','upload/xuesheng_touxiang5.jpg'),(16,'2023-03-30 14:04:00','学号6','123456','姓名6','男','学院6','年级6','班级6','13823888886','upload/xuesheng_touxiang6.jpg'),(17,'2023-03-30 14:04:00','学号7','123456','姓名7','男','学院7','年级7','班级7','13823888887','upload/xuesheng_touxiang7.jpg'),(18,'2023-03-30 14:04:00','学号8','123456','姓名8','男','学院8','年级8','班级8','13823888888','upload/xuesheng_touxiang8.jpg'),(1680185395817,'2023-03-30 14:09:55','111','111','张三','男','XX学院','XX年级','XX班级','18156541454','upload/1680185394832.jpg');
/*!40000 ALTER TABLE `xuesheng` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zhuanjia`
--

DROP TABLE IF EXISTS `zhuanjia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zhuanjia` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhuanjiazhanghao` varchar(200) NOT NULL COMMENT '专家账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `zhuanjiaxingming` varchar(200) NOT NULL COMMENT '专家姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `touxiang` longtext COMMENT '头像',
  PRIMARY KEY (`id`),
  UNIQUE KEY `zhuanjiazhanghao` (`zhuanjiazhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1680185410374 DEFAULT CHARSET=utf8 COMMENT='专家';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zhuanjia`
--

LOCK TABLES `zhuanjia` WRITE;
/*!40000 ALTER TABLE `zhuanjia` DISABLE KEYS */;
INSERT INTO `zhuanjia` VALUES (21,'2023-03-30 14:04:00','专家账号1','123456','专家姓名1','男','13823888881','upload/zhuanjia_touxiang1.jpg'),(22,'2023-03-30 14:04:00','专家账号2','123456','专家姓名2','男','13823888882','upload/zhuanjia_touxiang2.jpg'),(23,'2023-03-30 14:04:00','专家账号3','123456','专家姓名3','男','13823888883','upload/zhuanjia_touxiang3.jpg'),(24,'2023-03-30 14:04:00','专家账号4','123456','专家姓名4','男','13823888884','upload/zhuanjia_touxiang4.jpg'),(25,'2023-03-30 14:04:00','专家账号5','123456','专家姓名5','男','13823888885','upload/zhuanjia_touxiang5.jpg'),(26,'2023-03-30 14:04:00','专家账号6','123456','专家姓名6','男','13823888886','upload/zhuanjia_touxiang6.jpg'),(27,'2023-03-30 14:04:00','专家账号7','123456','专家姓名7','男','13823888887','upload/zhuanjia_touxiang7.jpg'),(28,'2023-03-30 14:04:00','专家账号8','123456','专家姓名8','男','13823888888','upload/zhuanjia_touxiang8.jpg'),(1680185410373,'2023-03-30 14:10:10','222','222','李四','男','18156541454','upload/1680185409123.jpg');
/*!40000 ALTER TABLE `zhuanjia` 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-04-05 15:45:04

5、关键代码

5.1 创新创业管理Controller模块 

package com.controller;

import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;

import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;

import com.entity.ChuangxinchuangyeEntity;
import com.entity.view.ChuangxinchuangyeView;

import com.service.ChuangxinchuangyeService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
import java.io.IOException;

/**
 * 创新创业
 * 后端接口
 * @author 
 * @email 
 * @date 2023-03-30 22:03:49
 */
@RestController
@RequestMapping("/chuangxinchuangye")
public class ChuangxinchuangyeController {
    @Autowired
    private ChuangxinchuangyeService chuangxinchuangyeService;

    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,ChuangxinchuangyeEntity chuangxinchuangye,
		HttpServletRequest request){
		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("xuesheng")) {
			chuangxinchuangye.setXuehao((String)request.getSession().getAttribute("username"));
		}
        EntityWrapper<ChuangxinchuangyeEntity> ew = new EntityWrapper<ChuangxinchuangyeEntity>();

		PageUtils page = chuangxinchuangyeService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, chuangxinchuangye), params), params));

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

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

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

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(ChuangxinchuangyeEntity chuangxinchuangye){
        EntityWrapper< ChuangxinchuangyeEntity> ew = new EntityWrapper< ChuangxinchuangyeEntity>();
 		ew.allEq(MPUtil.allEQMapPre( chuangxinchuangye, "chuangxinchuangye")); 
		ChuangxinchuangyeView chuangxinchuangyeView =  chuangxinchuangyeService.selectView(ew);
		return R.ok("查询创新创业成功").put("data", chuangxinchuangyeView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        ChuangxinchuangyeEntity chuangxinchuangye = chuangxinchuangyeService.selectById(id);
        return R.ok().put("data", chuangxinchuangye);
    }

    /**
     * 前端详情
     */
	@IgnoreAuth
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") Long id){
        ChuangxinchuangyeEntity chuangxinchuangye = chuangxinchuangyeService.selectById(id);
        return R.ok().put("data", chuangxinchuangye);
    }

    /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody ChuangxinchuangyeEntity chuangxinchuangye, HttpServletRequest request){
    	chuangxinchuangye.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(chuangxinchuangye);
        chuangxinchuangyeService.insert(chuangxinchuangye);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody ChuangxinchuangyeEntity chuangxinchuangye, HttpServletRequest request){
    	chuangxinchuangye.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(chuangxinchuangye);
        chuangxinchuangyeService.insert(chuangxinchuangye);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    @Transactional
    public R update(@RequestBody ChuangxinchuangyeEntity chuangxinchuangye, HttpServletRequest request){
        //ValidatorUtils.validateEntity(chuangxinchuangye);
        chuangxinchuangyeService.updateById(chuangxinchuangye);//全部更新
        return R.ok();
    }

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        chuangxinchuangyeService.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<ChuangxinchuangyeEntity> wrapper = new EntityWrapper<ChuangxinchuangyeEntity>();
		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("xuesheng")) {
			wrapper.eq("xuehao", (String)request.getSession().getAttribute("username"));
		}

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

5.2 创新创业管理Service模块 

package com.service;

import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.service.IService;
import com.utils.PageUtils;
import com.entity.ChuangxinchuangyepingshenEntity;
import java.util.List;
import java.util.Map;
import com.entity.vo.ChuangxinchuangyepingshenVO;
import org.apache.ibatis.annotations.Param;
import com.entity.view.ChuangxinchuangyepingshenView;

/**
 * 创新创业评审
 *
 * @author 
 * @email 
 * @date 2023-03-30 22:03:49
 */
public interface ChuangxinchuangyepingshenService extends IService<ChuangxinchuangyepingshenEntity> {

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

5.3 创新创业管理ServiceImpl模块

package com.service.impl;

import org.springframework.stereotype.Service;
import java.util.Map;
import java.util.List;

import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.utils.PageUtils;
import com.utils.Query;

import com.dao.ChuangxinchuangyepingshenDao;
import com.entity.ChuangxinchuangyepingshenEntity;
import com.service.ChuangxinchuangyepingshenService;
import com.entity.vo.ChuangxinchuangyepingshenVO;
import com.entity.view.ChuangxinchuangyepingshenView;

@Service("chuangxinchuangyepingshenService")
public class ChuangxinchuangyepingshenServiceImpl extends ServiceImpl<ChuangxinchuangyepingshenDao, ChuangxinchuangyepingshenEntity> implements ChuangxinchuangyepingshenService {
	
    @Override
    public PageUtils queryPage(Map<String, Object> params) {
        Page<ChuangxinchuangyepingshenEntity> page = this.selectPage(
                new Query<ChuangxinchuangyepingshenEntity>(params).getPage(),
                new EntityWrapper<ChuangxinchuangyepingshenEntity>()
        );
        return new PageUtils(page);
    }
    
    @Override
	public PageUtils queryPage(Map<String, Object> params, Wrapper<ChuangxinchuangyepingshenEntity> wrapper) {
		  Page<ChuangxinchuangyepingshenView> page =new Query<ChuangxinchuangyepingshenView>(params).getPage();
	        page.setRecords(baseMapper.selectListView(page,wrapper));
	    	PageUtils pageUtil = new PageUtils(page);
	    	return pageUtil;
 	}
    
    @Override
	public List<ChuangxinchuangyepingshenVO> selectListVO(Wrapper<ChuangxinchuangyepingshenEntity> wrapper) {
 		return baseMapper.selectListVO(wrapper);
	}
	
	@Override
	public ChuangxinchuangyepingshenVO selectVO(Wrapper<ChuangxinchuangyepingshenEntity> wrapper) {
 		return baseMapper.selectVO(wrapper);
	}
	
	@Override
	public List<ChuangxinchuangyepingshenView> selectListView(Wrapper<ChuangxinchuangyepingshenEntity> wrapper) {
		return baseMapper.selectListView(wrapper);
	}

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

}

5.4 创新创业管理Dao模块

package com.dao;

import com.entity.ChuangxinchuangyeEntity;
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.ChuangxinchuangyeVO;
import com.entity.view.ChuangxinchuangyeView;

/**
 * 创新创业
 * 
 * @author 
 * @email 
 * @date 2023-03-30 22:03:49
 */
public interface ChuangxinchuangyeDao extends BaseMapper<ChuangxinchuangyeEntity> {
	
	List<ChuangxinchuangyeVO> selectListVO(@Param("ew") Wrapper<ChuangxinchuangyeEntity> wrapper);
	
	ChuangxinchuangyeVO selectVO(@Param("ew") Wrapper<ChuangxinchuangyeEntity> wrapper);
	
	List<ChuangxinchuangyeView> selectListView(@Param("ew") Wrapper<ChuangxinchuangyeEntity> wrapper);

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

6、论文目录结构

7、源码获取

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

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

获取源码请私信

  • 12
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值