博主介绍:
✌我是阿龙,一名专注于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等多个平台推荐,成为各大平台的优质作者。
已经为上百名同学获得优秀毕业生!!
源码获取:
大家点赞、收藏、关注、评论啦 、查看👇🏻获取联系方式👇🏻
精彩专栏推荐订阅:在下方专栏👇🏻