基于SpringBoot高校校外实训基地管理系统的设计与实现(源码+定制+开发)实训基地管理信息化、校外实训管理系统设计与开发、实训基地系统开发与应用、智慧校外实训基地管理

博主介绍:
    ✌我是阿龙,一名专注于Java技术领域的程序员,全网拥有10W+粉丝。作为CSDN特邀作者、博客专家、新星计划导师,我在计算机毕业设计开发方面积累了丰富的经验。同时,我也是掘金、华为云、阿里云、InfoQ等平台的优质作者。通过长期分享和实战指导,我致力于帮助更多学生完成毕业项目和技术提升。

技术范围:
    我熟悉的技术领域涵盖SpringBoot、Vue、SSM、HLMT、Jsp、PHP、Nodejs、Python、爬虫、数据可视化、小程序、安卓app、大数据、物联网、机器学习等方面的设计与开发。如果你有任何技术难题,我都乐意与你分享解决方案。

 主要内容:
     我的服务内容包括:免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文撰写与辅导、论文降重、长期答辩答疑辅导。此外,我还提供腾讯会议一对一的专业讲解和模拟答辩演练,帮助你全面掌握答辩技巧与代码逻辑。

🍅获取源码请在文末联系我🍅
如果你对我的内容感兴趣,记得先收藏!对于毕设选题、项目开发或论文撰写等相关问题,随时欢迎留言咨询,我会尽力帮助更多同学顺利完成学业。

最主要的是免费咨询相关问题!

一、详细操作演示视频
       在文章的尾声,您会发现一张电子名片👤,欢迎通过名片上的联系方式与我取得联系,以获取更多关于项目演示的详尽视频内容。视频将帮助您全面理解项目的关键点和操作流程。期待与您的进一步交流!
        承诺所有开发的项目,全程售后陪伴!!!文章下方有将近100人的好评(部分)!!

功能描述:

课题名称:

高校校外实训基地管理系统的设计与实现

开发语言:

JAVA

数据库:

MySQL

框架:

 Spring Boot

前端用VUE

客户备注:注意核对一下功能。

详细功能需求描述:

企业角色

1.基地建设申请(管理员审核)(增删改查)

(基地名称、图像、单位性质、基地级别、地址、面向专业、创建人、申请时间、经费投入、可接纳人数、审核状态、上传基地信息(以文档形式可下载))

2、基地建设过程(基地名称、图像、施工单位、预计工期)(增删改查)

3、基地设备管理(增删改查)(企业自己能看就行)生成统计报表

(基地名称、图像、设备名称、设备类型、资金投入、设备数量、地址)

4.基地岗位管理(发布到学生端)(增删改查)

(基地各称,图像、岗位名称、发布时间、结束时间、工作地点、岗位需求人数、点击数、收藏数、简介)

5、基地项目管理(同步到管理员端审核)(增删改查)(以项目类型生成统计报表)

(基地名称、图像、项目名称、项目类型,负责人、发布时间、结束时间、实训接纳人数、面向专业、上传项目信息(以文档形式可下载))

6、合作成果(增删改查)(发布到学生之端)以公告资讯的形式展示出来

(基地名称、图像、项目名称、项目类型,负责人、发布时间、结束时间、取得成果)

7、学生打卡功能(增删改查)

角色:管理员

1.加基地建设申请(管理员审核)(增删改查)

(基地名称、图像、单位性质、基地级别、地址、面向专业、创建人、申请时间、经费投入、可接纳人数、审核状态、上传基地信息(以文档形式可下载))

2、加基地项目管理(管理员审核)(增删改查)(基地名称、图像、项目名称、项目类型,负责人、发布时间、结束时间、实训接纳人数、面向专业、审核状态、上传项目信息(以文档形式可下载))

4、实训报告的审核

5、学生打卡记录

6,企业账号管理

7、学生账号管理

8、建设过程

9、校企合作成果

(基地名称、图像、项目名称、项目类型,负责人、发布时间、结束时间、取得成果)

角色:学生

1.企业岗位管理(发布到学生端)(类似于企业就业管理形式)

(基地各称,岗位名称、发布时间、图像、工作地点、岗位需求人数、点击数、收藏数、简介)

2、校企合作成果(发布到学生之端)以公告资讯的形式展示出来

(基地名称、图像、项目名称、项目类型,负责人、发布时间、结束时间、取得成果)

3、实训报告的上传

4、学生打卡功能

实现界面:
 

核心实现代码:
 

package com.service;

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


/**
 * 学生打卡
 *
 * @author 
 * @email 
 * @date 2024-05-19 20:38:52
 */
public interface XueshengdakaService extends IService<XueshengdakaEntity> {

    PageUtils queryPage(Map<String, Object> params);
    
   	List<XueshengdakaVO> selectListVO(Wrapper<XueshengdakaEntity> wrapper);
   	
   	XueshengdakaVO selectVO(@Param("ew") Wrapper<XueshengdakaEntity> wrapper);
   	
   	List<XueshengdakaView> selectListView(Wrapper<XueshengdakaEntity> wrapper);
   	
   	XueshengdakaView selectView(@Param("ew") Wrapper<XueshengdakaEntity> wrapper);
   	
   	PageUtils queryPage(Map<String, Object> params,Wrapper<XueshengdakaEntity> wrapper);

   	

}

数据库核心代码:
 

--
-- Current Database: `springboot4r7ktg2j`
--

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

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

USE `springboot4r7ktg2j`;

--
-- 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 '配置参数值',
  `url` varchar(500) DEFAULT NULL COMMENT 'url',
  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',NULL),(2,'picture2','upload/picture2.jpg',NULL),(3,'picture3','upload/picture3.jpg',NULL);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussjidigangweiguanli`
--

DROP TABLE IF EXISTS `discussjidigangweiguanli`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussjidigangweiguanli` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `avatarurl` longtext COMMENT '头像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='基地岗位管理评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussjidigangweiguanli`
--

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

--
-- Table structure for table `jidigangweiguanli`
--

DROP TABLE IF EXISTS `jidigangweiguanli`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jidigangweiguanli` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jidimingcheng` varchar(200) DEFAULT NULL COMMENT '基地名称',
  `jiditupian` longtext COMMENT '基地图片',
  `gangweimingcheng` varchar(200) DEFAULT NULL COMMENT '岗位名称',
  `gongzuodidian` varchar(200) DEFAULT NULL COMMENT '工作地点',
  `gangweixuqiurenshu` int(11) DEFAULT NULL COMMENT '岗位需求人数',
  `fabushijian` date DEFAULT NULL COMMENT '发布时间',
  `jieshushijian` date DEFAULT NULL COMMENT '结束时间',
  `gangweijianjie` longtext COMMENT '岗位简介',
  `danweimingcheng` varchar(200) DEFAULT NULL COMMENT '单位名称',
  `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
  `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
  `discussnum` int(11) DEFAULT '0' COMMENT '评论数',
  `storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='基地岗位管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jidigangweiguanli`
--

LOCK TABLES `jidigangweiguanli` WRITE;
/*!40000 ALTER TABLE `jidigangweiguanli` DISABLE KEYS */;
INSERT INTO `jidigangweiguanli` VALUES (61,'2024-05-19 12:39:12','基地名称1','upload/jidigangweiguanli_jiditupian1.jpg,upload/jidigangweiguanli_jiditupian2.jpg,upload/jidigangweiguanli_jiditupian3.jpg','岗位名称1','工作地点1',1,'2024-05-19','2024-05-19','岗位简介1','单位名称1','2024-05-19 20:39:12',1,0,1),(62,'2024-05-19 12:39:12','基地名称2','upload/jidigangweiguanli_jiditupian2.jpg,upload/jidigangweiguanli_jiditupian3.jpg,upload/jidigangweiguanli_jiditupian4.jpg','岗位名称2','工作地点2',2,'2024-05-19','2024-05-19','岗位简介2','单位名称2','2024-05-19 20:39:12',2,0,2),(63,'2024-05-19 12:39:12','基地名称3','upload/jidigangweiguanli_jiditupian3.jpg,upload/jidigangweiguanli_jiditupian4.jpg,upload/jidigangweiguanli_jiditupian5.jpg','岗位名称3','工作地点3',3,'2024-05-19','2024-05-19','岗位简介3','单位名称3','2024-05-19 20:39:12',3,0,3),(64,'2024-05-19 12:39:12','基地名称4','upload/jidigangweiguanli_jiditupian4.jpg,upload/jidigangweiguanli_jiditupian5.jpg,upload/jidigangweiguanli_jiditupian6.jpg','岗位名称4','工作地点4',4,'2024-05-19','2024-05-19','岗位简介4','单位名称4','2024-05-19 20:39:12',4,0,4),(65,'2024-05-19 12:39:12','基地名称5','upload/jidigangweiguanli_jiditupian5.jpg,upload/jidigangweiguanli_jiditupian6.jpg,upload/jidigangweiguanli_jiditupian7.jpg','岗位名称5','工作地点5',5,'2024-05-19','2024-05-19','岗位简介5','单位名称5','2024-05-19 20:39:12',5,0,5),(66,'2024-05-19 12:39:12','基地名称6','upload/jidigangweiguanli_jiditupian6.jpg,upload/jidigangweiguanli_jiditupian7.jpg,upload/jidigangweiguanli_jiditupian8.jpg','岗位名称6','工作地点6',6,'2024-05-19','2024-05-19','岗位简介6','单位名称6','2024-05-19 20:39:12',6,0,6),(67,'2024-05-19 12:39:12','基地名称7','upload/jidigangweiguanli_jiditupian7.jpg,upload/jidigangweiguanli_jiditupian8.jpg,upload/jidigangweiguanli_jiditupian9.jpg','岗位名称7','工作地点7',7,'2024-05-19','2024-05-19','岗位简介7','单位名称7','2024-05-19 20:39:12',7,0,7),(68,'2024-05-19 12:39:12','基地名称8','upload/jidigangweiguanli_jiditupian8.jpg,upload/jidigangweiguanli_jiditupian9.jpg,upload/jidigangweiguanli_jiditupian10.jpg','岗位名称8','工作地点8',8,'2024-05-19','2024-05-19','岗位简介8','单位名称8','2024-05-19 20:39:12',8,0,8);
/*!40000 ALTER TABLE `jidigangweiguanli` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jidijiansheguocheng`
--

DROP TABLE IF EXISTS `jidijiansheguocheng`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jidijiansheguocheng` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jidimingcheng` varchar(200) DEFAULT NULL COMMENT '基地名称',
  `jiditupian` longtext COMMENT '基地图片',
  `shigongdanwei` varchar(200) DEFAULT NULL COMMENT '施工单位',
  `yujigongqi` varchar(200) DEFAULT NULL COMMENT '预计工期',
  `danweimingcheng` varchar(200) DEFAULT NULL COMMENT '单位名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='基地建设过程';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jidijiansheguocheng`
--

LOCK TABLES `jidijiansheguocheng` WRITE;
/*!40000 ALTER TABLE `jidijiansheguocheng` DISABLE KEYS */;
INSERT INTO `jidijiansheguocheng` VALUES (41,'2024-05-19 12:39:12','基地名称1','upload/jidijiansheguocheng_jiditupian1.jpg,upload/jidijiansheguocheng_jiditupian2.jpg,upload/jidijiansheguocheng_jiditupian3.jpg','施工单位1','预计工期1','单位名称1'),(42,'2024-05-19 12:39:12','基地名称2','upload/jidijiansheguocheng_jiditupian2.jpg,upload/jidijiansheguocheng_jiditupian3.jpg,upload/jidijiansheguocheng_jiditupian4.jpg','施工单位2','预计工期2','单位名称2'),(43,'2024-05-19 12:39:12','基地名称3','upload/jidijiansheguocheng_jiditupian3.jpg,upload/jidijiansheguocheng_jiditupian4.jpg,upload/jidijiansheguocheng_jiditupian5.jpg','施工单位3','预计工期3','单位名称3'),(44,'2024-05-19 12:39:12','基地名称4','upload/jidijiansheguocheng_jiditupian4.jpg,upload/jidijiansheguocheng_jiditupian5.jpg,upload/jidijiansheguocheng_jiditupian6.jpg','施工单位4','预计工期4','单位名称4'),(45,'2024-05-19 12:39:12','基地名称5','upload/jidijiansheguocheng_jiditupian5.jpg,upload/jidijiansheguocheng_jiditupian6.jpg,upload/jidijiansheguocheng_jiditupian7.jpg','施工单位5','预计工期5','单位名称5'),(46,'2024-05-19 12:39:12','基地名称6','upload/jidijiansheguocheng_jiditupian6.jpg,upload/jidijiansheguocheng_jiditupian7.jpg,upload/jidijiansheguocheng_jiditupian8.jpg','施工单位6','预计工期6','单位名称6'),(47,'2024-05-19 12:39:12','基地名称7','upload/jidijiansheguocheng_jiditupian7.jpg,upload/jidijiansheguocheng_jiditupian8.jpg,upload/jidijiansheguocheng_jiditupian9.jpg','施工单位7','预计工期7','单位名称7'),(48,'2024-05-19 12:39:12','基地名称8','upload/jidijiansheguocheng_jiditupian8.jpg,upload/jidijiansheguocheng_jiditupian9.jpg,upload/jidijiansheguocheng_jiditupian10.jpg','施工单位8','预计工期8','单位名称8');
/*!40000 ALTER TABLE `jidijiansheguocheng` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jidijiansheshenqing`
--

DROP TABLE IF EXISTS `jidijiansheshenqing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jidijiansheshenqing` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jidimingcheng` varchar(200) DEFAULT NULL COMMENT '基地名称',
  `jiditupian` longtext COMMENT '基地图片',
  `jididizhi` varchar(200) DEFAULT NULL COMMENT '基地地址',
  `jidijibie` varchar(200) DEFAULT NULL COMMENT '基地级别',
  `mianxiangzhuanye` varchar(200) DEFAULT NULL COMMENT '面向专业',
  `jingfeitouru` varchar(200) DEFAULT NULL COMMENT '经费投入',
  `kejienarenshu` varchar(200) DEFAULT NULL COMMENT '可接纳人数',
  `jidifujian` longtext COMMENT '基地附件',
  `shenqingshijian` date DEFAULT NULL COMMENT '申请时间',
  `danweimingcheng` varchar(200) DEFAULT NULL COMMENT '单位名称',
  `danweixingzhi` varchar(200) DEFAULT NULL COMMENT '单位性质',
  `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
  `shhf` longtext 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 `jidijiansheshenqing`
--

LOCK TABLES `jidijiansheshenqing` WRITE;
/*!40000 ALTER TABLE `jidijiansheshenqing` DISABLE KEYS */;
INSERT INTO `jidijiansheshenqing` VALUES (31,'2024-05-19 12:39:12','基地名称1','upload/jidijiansheshenqing_jiditupian1.jpg,upload/jidijiansheshenqing_jiditupian2.jpg,upload/jidijiansheshenqing_jiditupian3.jpg','基地地址1','基地级别1','面向专业1','经费投入1','可接纳人数1','','2024-05-19','单位名称1','单位性质1','是',''),(32,'2024-05-19 12:39:12','基地名称2','upload/jidijiansheshenqing_jiditupian2.jpg,upload/jidijiansheshenqing_jiditupian3.jpg,upload/jidijiansheshenqing_jiditupian4.jpg','基地地址2','基地级别2','面向专业2','经费投入2','可接纳人数2','','2024-05-19','单位名称2','单位性质2','是',''),(33,'2024-05-19 12:39:12','基地名称3','upload/jidijiansheshenqing_jiditupian3.jpg,upload/jidijiansheshenqing_jiditupian4.jpg,upload/jidijiansheshenqing_jiditupian5.jpg','基地地址3','基地级别3','面向专业3','经费投入3','可接纳人数3','','2024-05-19','单位名称3','单位性质3','是',''),(34,'2024-05-19 12:39:12','基地名称4','upload/jidijiansheshenqing_jiditupian4.jpg,upload/jidijiansheshenqing_jiditupian5.jpg,upload/jidijiansheshenqing_jiditupian6.jpg','基地地址4','基地级别4','面向专业4','经费投入4','可接纳人数4','','2024-05-19','单位名称4','单位性质4','是',''),(35,'2024-05-19 12:39:12','基地名称5','upload/jidijiansheshenqing_jiditupian5.jpg,upload/jidijiansheshenqing_jiditupian6.jpg,upload/jidijiansheshenqing_jiditupian7.jpg','基地地址5','基地级别5','面向专业5','经费投入5','可接纳人数5','','2024-05-19','单位名称5','单位性质5','是',''),(36,'2024-05-19 12:39:12','基地名称6','upload/jidijiansheshenqing_jiditupian6.jpg,upload/jidijiansheshenqing_jiditupian7.jpg,upload/jidijiansheshenqing_jiditupian8.jpg','基地地址6','基地级别6','面向专业6','经费投入6','可接纳人数6','','2024-05-19','单位名称6','单位性质6','是',''),(37,'2024-05-19 12:39:12','基地名称7','upload/jidijiansheshenqing_jiditupian7.jpg,upload/jidijiansheshenqing_jiditupian8.jpg,upload/jidijiansheshenqing_jiditupian9.jpg','基地地址7','基地级别7','面向专业7','经费投入7','可接纳人数7','','2024-05-19','单位名称7','单位性质7','是',''),(38,'2024-05-19 12:39:12','基地名称8','upload/jidijiansheshenqing_jiditupian8.jpg,upload/jidijiansheshenqing_jiditupian9.jpg,upload/jidijiansheshenqing_jiditupian10.jpg','基地地址8','基地级别8','面向专业8','经费投入8','可接纳人数8','','2024-05-19','单位名称8','单位性质8','是','');
/*!40000 ALTER TABLE `jidijiansheshenqing` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jidishebeiguanli`
--

DROP TABLE IF EXISTS `jidishebeiguanli`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jidishebeiguanli` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jidimingcheng` varchar(200) DEFAULT NULL COMMENT '基地名称',
  `jiditupian` longtext COMMENT '基地图片',
  `shebeimingcheng` varchar(200) DEFAULT NULL COMMENT '设备名称',
  `shebeileixing` varchar(200) DEFAULT NULL COMMENT '设备类型',
  `shebeishuliang` int(11) DEFAULT NULL COMMENT '设备数量',
  `zijintouru` varchar(200) DEFAULT NULL COMMENT '资金投入',
  `shebeidizhi` varchar(200) DEFAULT NULL COMMENT '设备地址',
  `danweimingcheng` varchar(200) DEFAULT NULL COMMENT '单位名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='基地设备管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jidishebeiguanli`
--

LOCK TABLES `jidishebeiguanli` WRITE;
/*!40000 ALTER TABLE `jidishebeiguanli` DISABLE KEYS */;
INSERT INTO `jidishebeiguanli` VALUES (51,'2024-05-19 12:39:12','基地名称1','upload/jidishebeiguanli_jiditupian1.jpg,upload/jidishebeiguanli_jiditupian2.jpg,upload/jidishebeiguanli_jiditupian3.jpg','设备名称1','设备类型1',1,'资金投入1','设备地址1','单位名称1'),(52,'2024-05-19 12:39:12','基地名称2','upload/jidishebeiguanli_jiditupian2.jpg,upload/jidishebeiguanli_jiditupian3.jpg,upload/jidishebeiguanli_jiditupian4.jpg','设备名称2','设备类型2',2,'资金投入2','设备地址2','单位名称2'),(53,'2024-05-19 12:39:12','基地名称3','upload/jidishebeiguanli_jiditupian3.jpg,upload/jidishebeiguanli_jiditupian4.jpg,upload/jidishebeiguanli_jiditupian5.jpg','设备名称3','设备类型3',3,'资金投入3','设备地址3','单位名称3'),(54,'2024-05-19 12:39:12','基地名称4','upload/jidishebeiguanli_jiditupian4.jpg,upload/jidishebeiguanli_jiditupian5.jpg,upload/jidishebeiguanli_jiditupian6.jpg','设备名称4','设备类型4',4,'资金投入4','设备地址4','单位名称4'),(55,'2024-05-19 12:39:12','基地名称5','upload/jidishebeiguanli_jiditupian5.jpg,upload/jidishebeiguanli_jiditupian6.jpg,upload/jidishebeiguanli_jiditupian7.jpg','设备名称5','设备类型5',5,'资金投入5','设备地址5','单位名称5'),(56,'2024-05-19 12:39:12','基地名称6','upload/jidishebeiguanli_jiditupian6.jpg,upload/jidishebeiguanli_jiditupian7.jpg,upload/jidishebeiguanli_jiditupian8.jpg','设备名称6','设备类型6',6,'资金投入6','设备地址6','单位名称6'),(57,'2024-05-19 12:39:12','基地名称7','upload/jidishebeiguanli_jiditupian7.jpg,upload/jidishebeiguanli_jiditupian8.jpg,upload/jidishebeiguanli_jiditupian9.jpg','设备名称7','设备类型7',7,'资金投入7','设备地址7','单位名称7'),(58,'2024-05-19 12:39:12','基地名称8','upload/jidishebeiguanli_jiditupian8.jpg,upload/jidishebeiguanli_jiditupian9.jpg,upload/jidishebeiguanli_jiditupian10.jpg','设备名称8','设备类型8',8,'资金投入8','设备地址8','单位名称8');
/*!40000 ALTER TABLE `jidishebeiguanli` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jidixiangmuguanli`
--

DROP TABLE IF EXISTS `jidixiangmuguanli`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jidixiangmuguanli` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jidimingcheng` varchar(200) DEFAULT NULL COMMENT '基地名称',
  `jiditupian` longtext COMMENT '基地图片',
  `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '项目名称',
  `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '项目类型',
  `mianxiangzhuanye` varchar(200) DEFAULT NULL COMMENT '面向专业',
  `shixunjienarenshu` int(11) DEFAULT NULL COMMENT '实训接纳人数',
  `fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
  `fabushijian` date DEFAULT NULL COMMENT '发布时间',
  `jieshushijian` date DEFAULT NULL COMMENT '结束时间',
  `xiangmufujian` longtext COMMENT '项目附件',
  `danweimingcheng` varchar(200) DEFAULT NULL COMMENT '单位名称',
  `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='基地项目管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jidixiangmuguanli`
--

LOCK TABLES `jidixiangmuguanli` WRITE;
/*!40000 ALTER TABLE `jidixiangmuguanli` DISABLE KEYS */;
INSERT INTO `jidixiangmuguanli` VALUES (71,'2024-05-19 12:39:12','基地名称1','upload/jidixiangmuguanli_jiditupian1.jpg,upload/jidixiangmuguanli_jiditupian2.jpg,upload/jidixiangmuguanli_jiditupian3.jpg','项目名称1','项目类型1','面向专业1',1,'负责人1','2024-05-19','2024-05-19','','单位名称1','是',''),(72,'2024-05-19 12:39:12','基地名称2','upload/jidixiangmuguanli_jiditupian2.jpg,upload/jidixiangmuguanli_jiditupian3.jpg,upload/jidixiangmuguanli_jiditupian4.jpg','项目名称2','项目类型2','面向专业2',2,'负责人2','2024-05-19','2024-05-19','','单位名称2','是',''),(73,'2024-05-19 12:39:12','基地名称3','upload/jidixiangmuguanli_jiditupian3.jpg,upload/jidixiangmuguanli_jiditupian4.jpg,upload/jidixiangmuguanli_jiditupian5.jpg','项目名称3','项目类型3','面向专业3',3,'负责人3','2024-05-19','2024-05-19','','单位名称3','是',''),(74,'2024-05-19 12:39:12','基地名称4','upload/jidixiangmuguanli_jiditupian4.jpg,upload/jidixiangmuguanli_jiditupian5.jpg,upload/jidixiangmuguanli_jiditupian6.jpg','项目名称4','项目类型4','面向专业4',4,'负责人4','2024-05-19','2024-05-19','','单位名称4','是',''),(75,'2024-05-19 12:39:12','基地名称5','upload/jidixiangmuguanli_jiditupian5.jpg,upload/jidixiangmuguanli_jiditupian6.jpg,upload/jidixiangmuguanli_jiditupian7.jpg','项目名称5','项目类型5','面向专业5',5,'负责人5','2024-05-19','2024-05-19','','单位名称5','是',''),(76,'2024-05-19 12:39:12','基地名称6','upload/jidixiangmuguanli_jiditupian6.jpg,upload/jidixiangmuguanli_jiditupian7.jpg,upload/jidixiangmuguanli_jiditupian8.jpg','项目名称6','项目类型6','面向专业6',6,'负责人6','2024-05-19','2024-05-19','','单位名称6','是',''),(77,'2024-05-19 12:39:12','基地名称7','upload/jidixiangmuguanli_jiditupian7.jpg,upload/jidixiangmuguanli_jiditupian8.jpg,upload/jidixiangmuguanli_jiditupian9.jpg','项目名称7','项目类型7','面向专业7',7,'负责人7','2024-05-19','2024-05-19','','单位名称7','是',''),(78,'2024-05-19 12:39:12','基地名称8','upload/jidixiangmuguanli_jiditupian8.jpg,upload/jidixiangmuguanli_jiditupian9.jpg,upload/jidixiangmuguanli_jiditupian10.jpg','项目名称8','项目类型8','面向专业8',8,'负责人8','2024-05-19','2024-05-19','','单位名称8','是','');
/*!40000 ALTER TABLE `jidixiangmuguanli` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qiye`
--

DROP TABLE IF EXISTS `qiye`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qiye` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `danweimingcheng` varchar(200) NOT NULL COMMENT '单位名称',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `danweidizhi` varchar(200) NOT NULL COMMENT '单位地址',
  `danweixingzhi` varchar(200) DEFAULT NULL COMMENT '单位性质',
  `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `danweitupian` longtext COMMENT '单位图片',
  PRIMARY KEY (`id`),
  UNIQUE KEY `danweimingcheng` (`danweimingcheng`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='企业';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qiye`
--

LOCK TABLES `qiye` WRITE;
/*!40000 ALTER TABLE `qiye` DISABLE KEYS */;
INSERT INTO `qiye` VALUES (21,'2024-05-19 12:39:12','单位名称1','123456','单位地址1','单位性质1','13823888881','upload/qiye_danweitupian1.jpg'),(22,'2024-05-19 12:39:12','单位名称2','123456','单位地址2','单位性质2','13823888882','upload/qiye_danweitupian2.jpg'),(23,'2024-05-19 12:39:12','单位名称3','123456','单位地址3','单位性质3','13823888883','upload/qiye_danweitupian3.jpg'),(24,'2024-05-19 12:39:12','单位名称4','123456','单位地址4','单位性质4','13823888884','upload/qiye_danweitupian4.jpg'),(25,'2024-05-19 12:39:12','单位名称5','123456','单位地址5','单位性质5','13823888885','upload/qiye_danweitupian5.jpg'),(26,'2024-05-19 12:39:12','单位名称6','123456','单位地址6','单位性质6','13823888886','upload/qiye_danweitupian6.jpg'),(27,'2024-05-19 12:39:12','单位名称7','123456','单位地址7','单位性质7','13823888887','upload/qiye_danweitupian7.jpg'),(28,'2024-05-19 12:39:12','单位名称8','123456','单位地址8','单位性质8','13823888888','upload/qiye_danweitupian8.jpg');
/*!40000 ALTER TABLE `qiye` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shixunbaogao`
--

DROP TABLE IF EXISTS `shixunbaogao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shixunbaogao` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jidigecheng` varchar(200) DEFAULT NULL COMMENT '基地各称',
  `jiditupian` longtext COMMENT '基地图片',
  `gangweimingcheng` varchar(200) DEFAULT NULL COMMENT '岗位名称',
  `shixunshijian` date DEFAULT NULL COMMENT '实训时间',
  `shixunbaogao` longtext COMMENT '实训报告',
  `shixunchengguo` longtext COMMENT '实训成果',
  `danweimingcheng` varchar(200) DEFAULT NULL COMMENT '单位名称',
  `xueshengxuehao` varchar(200) DEFAULT NULL COMMENT '学生学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='实训报告';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shixunbaogao`
--

LOCK TABLES `shixunbaogao` WRITE;
/*!40000 ALTER TABLE `shixunbaogao` DISABLE KEYS */;
INSERT INTO `shixunbaogao` VALUES (91,'2024-05-19 12:39:12','基地各称1','upload/shixunbaogao_jiditupian1.jpg,upload/shixunbaogao_jiditupian2.jpg,upload/shixunbaogao_jiditupian3.jpg','岗位名称1','2024-05-19','','实训成果1','单位名称1','学生学号1','学生姓名1','是',''),(92,'2024-05-19 12:39:12','基地各称2','upload/shixunbaogao_jiditupian2.jpg,upload/shixunbaogao_jiditupian3.jpg,upload/shixunbaogao_jiditupian4.jpg','岗位名称2','2024-05-19','','实训成果2','单位名称2','学生学号2','学生姓名2','是',''),(93,'2024-05-19 12:39:12','基地各称3','upload/shixunbaogao_jiditupian3.jpg,upload/shixunbaogao_jiditupian4.jpg,upload/shixunbaogao_jiditupian5.jpg','岗位名称3','2024-05-19','','实训成果3','单位名称3','学生学号3','学生姓名3','是',''),(94,'2024-05-19 12:39:12','基地各称4','upload/shixunbaogao_jiditupian4.jpg,upload/shixunbaogao_jiditupian5.jpg,upload/shixunbaogao_jiditupian6.jpg','岗位名称4','2024-05-19','','实训成果4','单位名称4','学生学号4','学生姓名4','是',''),(95,'2024-05-19 12:39:12','基地各称5','upload/shixunbaogao_jiditupian5.jpg,upload/shixunbaogao_jiditupian6.jpg,upload/shixunbaogao_jiditupian7.jpg','岗位名称5','2024-05-19','','实训成果5','单位名称5','学生学号5','学生姓名5','是',''),(96,'2024-05-19 12:39:12','基地各称6','upload/shixunbaogao_jiditupian6.jpg,upload/shixunbaogao_jiditupian7.jpg,upload/shixunbaogao_jiditupian8.jpg','岗位名称6','2024-05-19','','实训成果6','单位名称6','学生学号6','学生姓名6','是',''),(97,'2024-05-19 12:39:12','基地各称7','upload/shixunbaogao_jiditupian7.jpg,upload/shixunbaogao_jiditupian8.jpg,upload/shixunbaogao_jiditupian9.jpg','岗位名称7','2024-05-19','','实训成果7','单位名称7','学生学号7','学生姓名7','是',''),(98,'2024-05-19 12:39:12','基地各称8','upload/shixunbaogao_jiditupian8.jpg,upload/shixunbaogao_jiditupian9.jpg,upload/shixunbaogao_jiditupian10.jpg','岗位名称8','2024-05-19','','实训成果8','单位名称8','学生学号8','学生姓名8','是','');
/*!40000 ALTER TABLE `shixunbaogao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `storeup`
--

DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `refid` bigint(20) DEFAULT NULL COMMENT '商品id',
  `tablename` varchar(200) DEFAULT NULL COMMENT '表名',
  `name` varchar(200) NOT NULL COMMENT '名称',
  `picture` longtext COMMENT '图片',
  `type` varchar(200) DEFAULT '1' COMMENT '类型',
  `inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `storeup`
--

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

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

DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(200) NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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,1,'admin','users','管理员','64zi8n2qi3l8488r9bwfcxl8r9ktj2we','2024-05-19 12:40:56','2024-05-19 13:40:57');
/*!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 '密码',
  `image` varchar(200) DEFAULT 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','upload/image1.jpg','管理员','2024-05-19 12:39:12');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xiaoqihezuochengguo`
--

DROP TABLE IF EXISTS `xiaoqihezuochengguo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xiaoqihezuochengguo` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jidimingcheng` varchar(200) DEFAULT NULL COMMENT '基地名称',
  `jiditupian` longtext COMMENT '基地图片',
  `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '项目名称',
  `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '项目类型',
  `fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
  `fabushijian` date DEFAULT NULL COMMENT '发布时间',
  `jieshushijian` date DEFAULT NULL COMMENT '结束时间',
  `qudechengguo` longtext COMMENT '取得成果',
  `danweimingcheng` varchar(200) DEFAULT NULL COMMENT '单位名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='校企合作成果';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xiaoqihezuochengguo`
--

开发案例(自己开发界面,做不同风格的尝试!只为服务好客户):

为什么选择我

我是程序员阿龙,专注于软件开发,拥有丰富的编程能力和实战经验。在过去的几年里,我辅导了上千名学生,帮助他们顺利完成毕业项目,同时我的技术分享也吸引了超过50W+的粉丝。我是CSDN特邀作者、博客专家、新星计划导师,并在Java领域内获得了多项荣誉,如博客之星。我的作品也被掘金、华为云、阿里云、InfoQ等多个平台推荐,成为各大平台的优质作者。
已经为上百名同学获得优秀毕业生!!

源码获取:
大家点赞、收藏、关注、评论啦 、查看👇🏻获取联系方式👇🏻

 精彩专栏推荐订阅:在下方专栏👇🏻

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

程序员阿龙

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值