【精选】基于微信小程序的高校师生工作室管理系统设计任务跟踪、资源调度、协作管理与进度追踪资源共享、项目管理、任务分配与师生沟通交流平台资源管理、协作任务管理与实时沟通功能-优快云博客

本文链接：https://blog.youkuaiyun.com/m0_64148096/article/details/145412870

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

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

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

🍅获取源码请在文末联系我🍅

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

系统实现界面（具体的功能和技术难点可以咨询阿龙）

8. 开发软件：Eclipse / MyEclipse / IDEA

9. Maven包：Maven 3.3.9

为什么选择我（我可以给你的定制项目推荐核心功能，一对一推荐）实现定制！！！

博主提供的项目均为博主自己收集和开发的！所有的源码都经由博主检验过，能过正常启动并且功能都没有问题！同学们拿到后就能使用！且博主自身就是高级开发，可以将所有的代码都清晰讲解出来。编辑编辑编辑编辑编辑

源码获取

文章下方名片联系我即可~大家点赞、收藏、关注、评论啦、查看👇🏻获取联系方式👇🏻精彩专栏推荐订阅：在下方专栏

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

系统实现界面（具体的功能和技术难点可以咨询阿龙）

核心代码介绍：

package com.service;

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


/**
 * 公告信息
 *
 * @author 
 * @email 
 * @date 2024-04-18 17:31:44
 */
public interface GonggaoxinxiService extends IService<GonggaoxinxiEntity> {

    PageUtils queryPage(Map<String, Object> params);
    
   	List<GonggaoxinxiVO> selectListVO(Wrapper<GonggaoxinxiEntity> wrapper);
   	
   	GonggaoxinxiVO selectVO(@Param("ew") Wrapper<GonggaoxinxiEntity> wrapper);
   	
   	List<GonggaoxinxiView> selectListView(Wrapper<GonggaoxinxiEntity> wrapper);
   	
   	GonggaoxinxiView selectView(@Param("ew") Wrapper<GonggaoxinxiEntity> wrapper);
   	
   	PageUtils queryPage(Map<String, Object> params,Wrapper<GonggaoxinxiEntity> wrapper);

   	

}

核心代码介绍：

--
-- Current Database: `springcloud1x1z4lu8`
--

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

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

USE `springcloud1x1z4lu8`;

--
-- Table structure for table `chengyuanpingfen`
--

DROP TABLE IF EXISTS `chengyuanpingfen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chengyuanpingfen` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jiaoshizhanghao` varchar(200) DEFAULT NULL COMMENT '教师账号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',
  `gongzuoshibianhao` varchar(200) DEFAULT NULL COMMENT '工作室编号',
  `gongzuoshimingcheng` varchar(200) DEFAULT NULL COMMENT '工作室名称',
  `fengmian` longtext COMMENT '封面',
  `xueshengxuehao` varchar(200) DEFAULT NULL COMMENT '学生学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `pingfenshijian` datetime DEFAULT NULL COMMENT '评分时间',
  `chengyuanpingfen` varchar(200) DEFAULT NULL COMMENT '成员评分',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='成员评分';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chengyuanpingfen`
--

LOCK TABLES `chengyuanpingfen` WRITE;
/*!40000 ALTER TABLE `chengyuanpingfen` DISABLE KEYS */;
INSERT INTO `chengyuanpingfen` VALUES (101,'2024-04-18 09:32:14','教师账号1','教师姓名1','手机号1','工作室编号1','工作室名称1','upload/chengyuanpingfen_fengmian1.jpg,upload/chengyuanpingfen_fengmian2.jpg,upload/chengyuanpingfen_fengmian3.jpg','学生学号1','学生姓名1','2024-04-18 17:32:14','成员评分1'),(102,'2024-04-18 09:32:14','教师账号2','教师姓名2','手机号2','工作室编号2','工作室名称2','upload/chengyuanpingfen_fengmian2.jpg,upload/chengyuanpingfen_fengmian3.jpg,upload/chengyuanpingfen_fengmian4.jpg','学生学号2','学生姓名2','2024-04-18 17:32:14','成员评分2'),(103,'2024-04-18 09:32:14','教师账号3','教师姓名3','手机号3','工作室编号3','工作室名称3','upload/chengyuanpingfen_fengmian3.jpg,upload/chengyuanpingfen_fengmian4.jpg,upload/chengyuanpingfen_fengmian5.jpg','学生学号3','学生姓名3','2024-04-18 17:32:14','成员评分3'),(104,'2024-04-18 09:32:14','教师账号4','教师姓名4','手机号4','工作室编号4','工作室名称4','upload/chengyuanpingfen_fengmian4.jpg,upload/chengyuanpingfen_fengmian5.jpg,upload/chengyuanpingfen_fengmian6.jpg','学生学号4','学生姓名4','2024-04-18 17:32:14','成员评分4'),(105,'2024-04-18 09:32:14','教师账号5','教师姓名5','手机号5','工作室编号5','工作室名称5','upload/chengyuanpingfen_fengmian5.jpg,upload/chengyuanpingfen_fengmian6.jpg,upload/chengyuanpingfen_fengmian7.jpg','学生学号5','学生姓名5','2024-04-18 17:32:14','成员评分5'),(106,'2024-04-18 09:32:14','教师账号6','教师姓名6','手机号6','工作室编号6','工作室名称6','upload/chengyuanpingfen_fengmian6.jpg,upload/chengyuanpingfen_fengmian7.jpg,upload/chengyuanpingfen_fengmian8.jpg','学生学号6','学生姓名6','2024-04-18 17:32:14','成员评分6'),(107,'2024-04-18 09:32:14','教师账号7','教师姓名7','手机号7','工作室编号7','工作室名称7','upload/chengyuanpingfen_fengmian7.jpg,upload/chengyuanpingfen_fengmian8.jpg,upload/chengyuanpingfen_fengmian9.jpg','学生学号7','学生姓名7','2024-04-18 17:32:14','成员评分7'),(108,'2024-04-18 09:32:14','教师账号8','教师姓名8','手机号8','工作室编号8','工作室名称8','upload/chengyuanpingfen_fengmian8.jpg,upload/chengyuanpingfen_fengmian9.jpg,upload/chengyuanpingfen_fengmian10.jpg','学生学号8','学生姓名8','2024-04-18 17:32:14','成员评分8');
/*!40000 ALTER TABLE `chengyuanpingfen` 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 '配置参数值',
  `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 `faburenwu`
--

DROP TABLE IF EXISTS `faburenwu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faburenwu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jiaoshizhanghao` varchar(200) DEFAULT NULL COMMENT '教师账号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',
  `gongzuoshibianhao` varchar(200) DEFAULT NULL COMMENT '工作室编号',
  `gongzuoshimingcheng` varchar(200) DEFAULT NULL COMMENT '工作室名称',
  `fengmian` longtext COMMENT '封面',
  `xueshengxuehao` varchar(200) DEFAULT NULL COMMENT '学生学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `renwubiaoti` varchar(200) DEFAULT NULL COMMENT '任务标题',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  `renwufujian` longtext COMMENT '任务附件',
  `renwuzhuangtai` varchar(200) DEFAULT NULL COMMENT '任务状态',
  `renwushuoming` longtext COMMENT '任务说明',
  `reversetime` datetime DEFAULT NULL 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 `faburenwu`
--

LOCK TABLES `faburenwu` WRITE;
/*!40000 ALTER TABLE `faburenwu` DISABLE KEYS */;
INSERT INTO `faburenwu` VALUES (61,'2024-04-18 09:32:13','教师账号1','教师姓名1','手机号1','工作室编号1','工作室名称1','upload/faburenwu_fengmian1.jpg,upload/faburenwu_fengmian2.jpg,upload/faburenwu_fengmian3.jpg','学生学号1','学生姓名1','任务标题1','2024-04-18 17:32:13','','已完成','任务说明1','2024-04-19 00:00:00'),(62,'2024-04-18 09:32:13','教师账号2','教师姓名2','手机号2','工作室编号2','工作室名称2','upload/faburenwu_fengmian2.jpg,upload/faburenwu_fengmian3.jpg,upload/faburenwu_fengmian4.jpg','学生学号2','学生姓名2','任务标题2','2024-04-18 17:32:13','','已完成','任务说明2','2024-04-19 00:00:00'),(63,'2024-04-18 09:32:13','教师账号3','教师姓名3','手机号3','工作室编号3','工作室名称3','upload/faburenwu_fengmian3.jpg,upload/faburenwu_fengmian4.jpg,upload/faburenwu_fengmian5.jpg','学生学号3','学生姓名3','任务标题3','2024-04-18 17:32:13','','已完成','任务说明3','2024-04-19 00:00:00'),(64,'2024-04-18 09:32:13','教师账号4','教师姓名4','手机号4','工作室编号4','工作室名称4','upload/faburenwu_fengmian4.jpg,upload/faburenwu_fengmian5.jpg,upload/faburenwu_fengmian6.jpg','学生学号4','学生姓名4','任务标题4','2024-04-18 17:32:13','','已完成','任务说明4','2024-04-19 00:00:00'),(65,'2024-04-18 09:32:13','教师账号5','教师姓名5','手机号5','工作室编号5','工作室名称5','upload/faburenwu_fengmian5.jpg,upload/faburenwu_fengmian6.jpg,upload/faburenwu_fengmian7.jpg','学生学号5','学生姓名5','任务标题5','2024-04-18 17:32:13','','已完成','任务说明5','2024-04-19 00:00:00'),(66,'2024-04-18 09:32:14','教师账号6','教师姓名6','手机号6','工作室编号6','工作室名称6','upload/faburenwu_fengmian6.jpg,upload/faburenwu_fengmian7.jpg,upload/faburenwu_fengmian8.jpg','学生学号6','学生姓名6','任务标题6','2024-04-18 17:32:14','','已完成','任务说明6','2024-04-19 00:00:00'),(67,'2024-04-18 09:32:14','教师账号7','教师姓名7','手机号7','工作室编号7','工作室名称7','upload/faburenwu_fengmian7.jpg,upload/faburenwu_fengmian8.jpg,upload/faburenwu_fengmian9.jpg','学生学号7','学生姓名7','任务标题7','2024-04-18 17:32:14','','已完成','任务说明7','2024-04-19 00:00:00'),(68,'2024-04-18 09:32:14','教师账号8','教师姓名8','手机号8','工作室编号8','工作室名称8','upload/faburenwu_fengmian8.jpg,upload/faburenwu_fengmian9.jpg,upload/faburenwu_fengmian10.jpg','学生学号8','学生姓名8','任务标题8','2024-04-18 17:32:14','','已完成','任务说明8','2024-04-19 00:00:00');
/*!40000 ALTER TABLE `faburenwu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gonggaoxinxi`
--

DROP TABLE IF EXISTS `gonggaoxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gonggaoxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gonggaobianhao` varchar(200) DEFAULT NULL COMMENT '公告编号',
  `gonggaobiaoti` varchar(200) DEFAULT NULL COMMENT '公告标题',
  `gonggaofengmian` longtext COMMENT '公告封面',
  `gonggaoneirong` longtext COMMENT '公告内容',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `gonggaobianhao` (`gonggaobianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gonggaoxinxi`
--

LOCK TABLES `gonggaoxinxi` WRITE;
/*!40000 ALTER TABLE `gonggaoxinxi` DISABLE KEYS */;
INSERT INTO `gonggaoxinxi` VALUES (141,'2024-04-18 09:32:14','1111111111','公告标题1','upload/gonggaoxinxi_gonggaofengmian1.jpg,upload/gonggaoxinxi_gonggaofengmian2.jpg,upload/gonggaoxinxi_gonggaofengmian3.jpg','公告内容1','2024-04-18 17:32:14'),(142,'2024-04-18 09:32:14','2222222222','公告标题2','upload/gonggaoxinxi_gonggaofengmian2.jpg,upload/gonggaoxinxi_gonggaofengmian3.jpg,upload/gonggaoxinxi_gonggaofengmian4.jpg','公告内容2','2024-04-18 17:32:14'),(143,'2024-04-18 09:32:14','3333333333','公告标题3','upload/gonggaoxinxi_gonggaofengmian3.jpg,upload/gonggaoxinxi_gonggaofengmian4.jpg,upload/gonggaoxinxi_gonggaofengmian5.jpg','公告内容3','2024-04-18 17:32:14'),(144,'2024-04-18 09:32:14','4444444444','公告标题4','upload/gonggaoxinxi_gonggaofengmian4.jpg,upload/gonggaoxinxi_gonggaofengmian5.jpg,upload/gonggaoxinxi_gonggaofengmian6.jpg','公告内容4','2024-04-18 17:32:14'),(145,'2024-04-18 09:32:14','5555555555','公告标题5','upload/gonggaoxinxi_gonggaofengmian5.jpg,upload/gonggaoxinxi_gonggaofengmian6.jpg,upload/gonggaoxinxi_gonggaofengmian7.jpg','公告内容5','2024-04-18 17:32:14'),(146,'2024-04-18 09:32:14','6666666666','公告标题6','upload/gonggaoxinxi_gonggaofengmian6.jpg,upload/gonggaoxinxi_gonggaofengmian7.jpg,upload/gonggaoxinxi_gonggaofengmian8.jpg','公告内容6','2024-04-18 17:32:14'),(147,'2024-04-18 09:32:14','7777777777','公告标题7','upload/gonggaoxinxi_gonggaofengmian7.jpg,upload/gonggaoxinxi_gonggaofengmian8.jpg,upload/gonggaoxinxi_gonggaofengmian9.jpg','公告内容7','2024-04-18 17:32:14'),(148,'2024-04-18 09:32:14','8888888888','公告标题8','upload/gonggaoxinxi_gonggaofengmian8.jpg,upload/gonggaoxinxi_gonggaofengmian9.jpg,upload/gonggaoxinxi_gonggaofengmian10.jpg','公告内容8','2024-04-18 17:32:14');
/*!40000 ALTER TABLE `gonggaoxinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gongzuoshi`
--

DROP TABLE IF EXISTS `gongzuoshi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gongzuoshi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jiaoshizhanghao` varchar(200) DEFAULT NULL COMMENT '教师账号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',
  `gongzuoshibianhao` varchar(200) DEFAULT NULL COMMENT '工作室编号',
  `gongzuoshimingcheng` varchar(200) NOT NULL COMMENT '工作室名称',
  `fengmian` longtext COMMENT '封面',
  `chuangjianshijian` datetime DEFAULT NULL COMMENT '创建时间',
  `gongzuoshiziliao` longtext NOT NULL COMMENT '工作室资料',
  `gongzuoshixiangqing` longtext NOT NULL COMMENT '工作室详情',
  `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
  `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
  `storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
  PRIMARY KEY (`id`),
  UNIQUE KEY `gongzuoshibianhao` (`gongzuoshibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='工作室';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gongzuoshi`
--

LOCK TABLES `gongzuoshi` WRITE;
/*!40000 ALTER TABLE `gongzuoshi` DISABLE KEYS */;
INSERT INTO `gongzuoshi` VALUES (31,'2024-04-18 09:32:13','教师账号1','教师姓名1','手机号1','1111111111','工作室名称1','upload/gongzuoshi_fengmian1.jpg,upload/gongzuoshi_fengmian2.jpg,upload/gongzuoshi_fengmian3.jpg','2024-04-18 17:32:13','','工作室详情1','2024-04-18 17:32:13',1,1),(32,'2024-04-18 09:32:13','教师账号2','教师姓名2','手机号2','2222222222','工作室名称2','upload/gongzuoshi_fengmian2.jpg,upload/gongzuoshi_fengmian3.jpg,upload/gongzuoshi_fengmian4.jpg','2024-04-18 17:32:13','','工作室详情2','2024-04-18 17:32:13',2,2),(33,'2024-04-18 09:32:13','教师账号3','教师姓名3','手机号3','3333333333','工作室名称3','upload/gongzuoshi_fengmian3.jpg,upload/gongzuoshi_fengmian4.jpg,upload/gongzuoshi_fengmian5.jpg','2024-04-18 17:32:13','','工作室详情3','2024-04-18 17:32:13',3,3),(34,'2024-04-18 09:32:13','教师账号4','教师姓名4','手机号4','4444444444','工作室名称4','upload/gongzuoshi_fengmian4.jpg,upload/gongzuoshi_fengmian5.jpg,upload/gongzuoshi_fengmian6.jpg','2024-04-18 17:32:13','','工作室详情4','2024-04-18 17:32:13',4,4),(35,'2024-04-18 09:32:13','教师账号5','教师姓名5','手机号5','5555555555','工作室名称5','upload/gongzuoshi_fengmian5.jpg,upload/gongzuoshi_fengmian6.jpg,upload/gongzuoshi_fengmian7.jpg','2024-04-18 17:32:13','','工作室详情5','2024-04-18 17:32:13',5,5),(36,'2024-04-18 09:32:13','教师账号6','教师姓名6','手机号6','6666666666','工作室名称6','upload/gongzuoshi_fengmian6.jpg,upload/gongzuoshi_fengmian7.jpg,upload/gongzuoshi_fengmian8.jpg','2024-04-18 17:32:13','','工作室详情6','2024-04-18 17:32:13',6,6),(37,'2024-04-18 09:32:13','教师账号7','教师姓名7','手机号7','7777777777','工作室名称7','upload/gongzuoshi_fengmian7.jpg,upload/gongzuoshi_fengmian8.jpg,upload/gongzuoshi_fengmian9.jpg','2024-04-18 17:32:13','','工作室详情7','2024-04-18 17:32:13',7,7),(38,'2024-04-18 09:32:13','教师账号8','教师姓名8','手机号8','8888888888','工作室名称8','upload/gongzuoshi_fengmian8.jpg,upload/gongzuoshi_fengmian9.jpg,upload/gongzuoshi_fengmian10.jpg','2024-04-18 17:32:13','','工作室详情8','2024-04-18 17:32:13',8,8);
/*!40000 ALTER TABLE `gongzuoshi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `guzhangbaoxiu`
--

DROP TABLE IF EXISTS `guzhangbaoxiu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guzhangbaoxiu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `baoxiuwenti` varchar(200) DEFAULT NULL COMMENT '报修问题',
  `baoxiutupian` longtext COMMENT '报修图片',
  `baoxiushijian` datetime DEFAULT NULL COMMENT '报修时间',
  `baoxiuneirong` longtext COMMENT '报修内容',
  `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COMMENT='故障报修';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `guzhangbaoxiu`
--

LOCK TABLES `guzhangbaoxiu` WRITE;
/*!40000 ALTER TABLE `guzhangbaoxiu` DISABLE KEYS */;
INSERT INTO `guzhangbaoxiu` VALUES (121,'2024-04-18 09:32:14','报修问题1','upload/guzhangbaoxiu_baoxiutupian1.jpg,upload/guzhangbaoxiu_baoxiutupian2.jpg,upload/guzhangbaoxiu_baoxiutupian3.jpg','2024-04-18 17:32:14','报修内容1','是','',1),(122,'2024-04-18 09:32:14','报修问题2','upload/guzhangbaoxiu_baoxiutupian2.jpg,upload/guzhangbaoxiu_baoxiutupian3.jpg,upload/guzhangbaoxiu_baoxiutupian4.jpg','2024-04-18 17:32:14','报修内容2','是','',2),(123,'2024-04-18 09:32:14','报修问题3','upload/guzhangbaoxiu_baoxiutupian3.jpg,upload/guzhangbaoxiu_baoxiutupian4.jpg,upload/guzhangbaoxiu_baoxiutupian5.jpg','2024-04-18 17:32:14','报修内容3','是','',3),(124,'2024-04-18 09:32:14','报修问题4','upload/guzhangbaoxiu_baoxiutupian4.jpg,upload/guzhangbaoxiu_baoxiutupian5.jpg,upload/guzhangbaoxiu_baoxiutupian6.jpg','2024-04-18 17:32:14','报修内容4','是','',4),(125,'2024-04-18 09:32:14','报修问题5','upload/guzhangbaoxiu_baoxiutupian5.jpg,upload/guzhangbaoxiu_baoxiutupian6.jpg,upload/guzhangbaoxiu_baoxiutupian7.jpg','2024-04-18 17:32:14','报修内容5','是','',5),(126,'2024-04-18 09:32:14','报修问题6','upload/guzhangbaoxiu_baoxiutupian6.jpg,upload/guzhangbaoxiu_baoxiutupian7.jpg,upload/guzhangbaoxiu_baoxiutupian8.jpg','2024-04-18 17:32:14','报修内容6','是','',6),(127,'2024-04-18 09:32:14','报修问题7','upload/guzhangbaoxiu_baoxiutupian7.jpg,upload/guzhangbaoxiu_baoxiutupian8.jpg,upload/guzhangbaoxiu_baoxiutupian9.jpg','2024-04-18 17:32:14','报修内容7','是','',7),(128,'2024-04-18 09:32:14','报修问题8','upload/guzhangbaoxiu_baoxiutupian8.jpg,upload/guzhangbaoxiu_baoxiutupian9.jpg,upload/guzhangbaoxiu_baoxiutupian10.jpg','2024-04-18 17:32:14','报修内容8','是','',8);
/*!40000 ALTER TABLE `guzhangbaoxiu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jiaoshi`
--

DROP TABLE IF EXISTS `jiaoshi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaoshi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jiaoshizhanghao` varchar(200) NOT NULL COMMENT '教师账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `nianling` varchar(200) DEFAULT NULL COMMENT '年龄',
  `gongzuoshimingcheng` varchar(200) DEFAULT NULL COMMENT '工作室名称',
  `shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',
  `touxiang` longtext COMMENT '头像',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jiaoshizhanghao` (`jiaoshizhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='教师';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jiaoshi`
--

LOCK TABLES `jiaoshi` WRITE;
/*!40000 ALTER TABLE `jiaoshi` DISABLE KEYS */;
INSERT INTO `jiaoshi` VALUES (21,'2024-04-18 09:32:13','教师账号1','123456','教师姓名1','男','年龄1','工作室名称1','13823888881','upload/jiaoshi_touxiang1.jpg'),(22,'2024-04-18 09:32:13','教师账号2','123456','教师姓名2','男','年龄2','工作室名称2','13823888882','upload/jiaoshi_touxiang2.jpg'),(23,'2024-04-18 09:32:13','教师账号3','123456','教师姓名3','男','年龄3','工作室名称3','13823888883','upload/jiaoshi_touxiang3.jpg'),(24,'2024-04-18 09:32:13','教师账号4','123456','教师姓名4','男','年龄4','工作室名称4','13823888884','upload/jiaoshi_touxiang4.jpg'),(25,'2024-04-18 09:32:13','教师账号5','123456','教师姓名5','男','年龄5','工作室名称5','13823888885','upload/jiaoshi_touxiang5.jpg'),(26,'2024-04-18 09:32:13','教师账号6','123456','教师姓名6','男','年龄6','工作室名称6','13823888886','upload/jiaoshi_touxiang6.jpg'),(27,'2024-04-18 09:32:13','教师账号7','123456','教师姓名7','男','年龄7','工作室名称7','13823888887','upload/jiaoshi_touxiang7.jpg'),(28,'2024-04-18 09:32:13','教师账号8','123456','教师姓名8','男','年龄8','工作室名称8','13823888888','upload/jiaoshi_touxiang8.jpg');
/*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jiaruxinxi`
--

DROP TABLE IF EXISTS `jiaruxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaruxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jiaoshizhanghao` varchar(200) DEFAULT NULL COMMENT '教师账号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',
  `gongzuoshibianhao` varchar(200) DEFAULT NULL COMMENT '工作室编号',
  `gongzuoshimingcheng` varchar(200) DEFAULT NULL COMMENT '工作室名称',
  `fengmian` longtext COMMENT '封面',
  `jiarushijian` datetime DEFAULT NULL COMMENT '加入时间',
  `xueshengxuehao` varchar(200) DEFAULT NULL COMMENT '学生学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `jiarushuoming` longtext 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 `jiaruxinxi`
--

LOCK TABLES `jiaruxinxi` WRITE;
/*!40000 ALTER TABLE `jiaruxinxi` DISABLE KEYS */;
INSERT INTO `jiaruxinxi` VALUES (51,'2024-04-18 09:32:13','教师账号1','教师姓名1','手机号1','工作室编号1','工作室名称1','upload/jiaruxinxi_fengmian1.jpg,upload/jiaruxinxi_fengmian2.jpg,upload/jiaruxinxi_fengmian3.jpg','2024-04-18 17:32:13','学生学号1','学生姓名1','加入说明1'),(52,'2024-04-18 09:32:13','教师账号2','教师姓名2','手机号2','工作室编号2','工作室名称2','upload/jiaruxinxi_fengmian2.jpg,upload/jiaruxinxi_fengmian3.jpg,upload/jiaruxinxi_fengmian4.jpg','2024-04-18 17:32:13','学生学号2','学生姓名2','加入说明2'),(53,'2024-04-18 09:32:13','教师账号3','教师姓名3','手机号3','工作室编号3','工作室名称3','upload/jiaruxinxi_fengmian3.jpg,upload/jiaruxinxi_fengmian4.jpg,upload/jiaruxinxi_fengmian5.jpg','2024-04-18 17:32:13','学生学号3','学生姓名3','加入说明3'),(54,'2024-04-18 09:32:13','教师账号4','教师姓名4','手机号4','工作室编号4','工作室名称4','upload/jiaruxinxi_fengmian4.jpg,upload/jiaruxinxi_fengmian5.jpg,upload/jiaruxinxi_fengmian6.jpg','2024-04-18 17:32:13','学生学号4','学生姓名4','加入说明4'),(55,'2024-04-18 09:32:13','教师账号5','教师姓名5','手机号5','工作室编号5','工作室名称5','upload/jiaruxinxi_fengmian5.jpg,upload/jiaruxinxi_fengmian6.jpg,upload/jiaruxinxi_fengmian7.jpg','2024-04-18 17:32:13','学生学号5','学生姓名5','加入说明5'),(56,'2024-04-18 09:32:13','教师账号6','教师姓名6','手机号6','工作室编号6','工作室名称6','upload/jiaruxinxi_fengmian6.jpg,upload/jiaruxinxi_fengmian7.jpg,upload/jiaruxinxi_fengmian8.jpg','2024-04-18 17:32:13','学生学号6','学生姓名6','加入说明6'),(57,'2024-04-18 09:32:13','教师账号7','教师姓名7','手机号7','工作室编号7','工作室名称7','upload/jiaruxinxi_fengmian7.jpg,upload/jiaruxinxi_fengmian8.jpg,upload/jiaruxinxi_fengmian9.jpg','2024-04-18 17:32:13','学生学号7','学生姓名7','加入说明7'),(58,'2024-04-18 09:32:13','教师账号8','教师姓名8','手机号8','工作室编号8','工作室名称8','upload/jiaruxinxi_fengmian8.jpg,upload/jiaruxinxi_fengmian9.jpg,upload/jiaruxinxi_fengmian10.jpg','2024-04-18 17:32:13','学生学号8','学生姓名8','加入说明8');
/*!40000 ALTER TABLE `jiaruxinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `richengxinxi`
--

DROP TABLE IF EXISTS `richengxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `richengxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jiaoshizhanghao` varchar(200) DEFAULT NULL COMMENT '教师账号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `gongzuoshimingcheng` varchar(200) DEFAULT NULL COMMENT '工作室名称',
  `richengbiaoti` varchar(200) DEFAULT NULL COMMENT '日程标题',
  `fengmian` longtext COMMENT '封面',
  `richengshijian` datetime DEFAULT NULL COMMENT '日程时间',
  `richengxiangqing` longtext 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 `richengxinxi`
--

LOCK TABLES `richengxinxi` WRITE;
/*!40000 ALTER TABLE `richengxinxi` DISABLE KEYS */;
INSERT INTO `richengxinxi` VALUES (81,'2024-04-18 09:32:14','教师账号1','教师姓名1','工作室名称1','日程标题1','upload/richengxinxi_fengmian1.jpg,upload/richengxinxi_fengmian2.jpg,upload/richengxinxi_fengmian3.jpg','2024-04-18 17:32:14','日程详情1'),(82,'2024-04-18 09:32:14','教师账号2','教师姓名2','工作室名称1','日程标题2','upload/richengxinxi_fengmian2.jpg,upload/richengxinxi_fengmian3.jpg,upload/richengxinxi_fengmian4.jpg','2024-04-18 17:32:14','<p>日程详情2</p>'),(83,'2024-04-18 09:32:14','教师账号3','教师姓名3','工作室名称3','日程标题3','upload/richengxinxi_fengmian3.jpg,upload/richengxinxi_fengmian4.jpg,upload/richengxinxi_fengmian5.jpg','2024-04-18 17:32:14','日程详情3'),(84,'2024-04-18 09:32:14','教师账号4','教师姓名4','工作室名称4','日程标题4','upload/richengxinxi_fengmian4.jpg,upload/richengxinxi_fengmian5.jpg,upload/richengxinxi_fengmian6.jpg','2024-04-18 17:32:14','日程详情4'),(85,'2024-04-18 09:32:14','教师账号5','教师姓名5','工作室名称5','日程标题5','upload/richengxinxi_fengmian5.jpg,upload/richengxinxi_fengmian6.jpg,upload/richengxinxi_fengmian7.jpg','2024-04-18 17:32:14','日程详情5'),(86,'2024-04-18 09:32:14','教师账号6','教师姓名6','工作室名称6','日程标题6','upload/richengxinxi_fengmian6.jpg,upload/richengxinxi_fengmian7.jpg,upload/richengxinxi_fengmian8.jpg','2024-04-18 17:32:14','日程详情6'),(87,'2024-04-18 09:32:14','教师账号7','教师姓名7','工作室名称7','日程标题7','upload/richengxinxi_fengmian7.jpg,upload/richengxinxi_fengmian8.jpg,upload/richengxinxi_fengmian9.jpg','2024-04-18 17:32:14','日程详情7'),(88,'2024-04-18 09:32:14','教师账号8','教师姓名8','工作室名称8','日程标题8','upload/richengxinxi_fengmian8.jpg,upload/richengxinxi_fengmian9.jpg,upload/richengxinxi_fengmian10.jpg','2024-04-18 17:32:14','日程详情8');
/*!40000 ALTER TABLE `richengxinxi` 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 `tiwenxinxi`
--

DROP TABLE IF EXISTS `tiwenxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tiwenxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jiaoshizhanghao` varchar(200) DEFAULT NULL COMMENT '教师账号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',
  `gongzuoshibianhao` varchar(200) DEFAULT NULL COMMENT '工作室编号',
  `gongzuoshimingcheng` varchar(200) DEFAULT NULL COMMENT '工作室名称',
  `fengmian` longtext COMMENT '封面',
  `xueshengxuehao` varchar(200) DEFAULT NULL COMMENT '学生学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `tiwenshijian` datetime DEFAULT NULL COMMENT '提问时间',
  `tiwenneirong` longtext COMMENT '提问内容',
  `shhf` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COMMENT='提问信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tiwenxinxi`
--

LOCK TABLES `tiwenxinxi` WRITE;
/*!40000 ALTER TABLE `tiwenxinxi` DISABLE KEYS */;
INSERT INTO `tiwenxinxi` VALUES (111,'2024-04-18 09:32:14','教师账号1','教师姓名1','手机号1','工作室编号1','工作室名称1','upload/tiwenxinxi_fengmian1.jpg,upload/tiwenxinxi_fengmian2.jpg,upload/tiwenxinxi_fengmian3.jpg','学生学号1','学生姓名1','2024-04-18 17:32:14','提问内容1',''),(112,'2024-04-18 09:32:14','教师账号2','教师姓名2','手机号2','工作室编号2','工作室名称2','upload/tiwenxinxi_fengmian2.jpg,upload/tiwenxinxi_fengmian3.jpg,upload/tiwenxinxi_fengmian4.jpg','学生学号2','学生姓名2','2024-04-18 17:32:14','提问内容2',''),(113,'2024-04-18 09:32:14','教师账号3','教师姓名3','手机号3','工作室编号3','工作室名称3','upload/tiwenxinxi_fengmian3.jpg,upload/tiwenxinxi_fengmian4.jpg,upload/tiwenxinxi_fengmian5.jpg','学生学号3','学生姓名3','2024-04-18 17:32:14','提问内容3',''),(114,'2024-04-18 09:32:14','教师账号4','教师姓名4','手机号4','工作室编号4','工作室名称4','upload/tiwenxinxi_fengmian4.jpg,upload/tiwenxinxi_fengmian5.jpg,upload/tiwenxinxi_fengmian6.jpg','学生学号4','学生姓名4','2024-04-18 17:32:14','提问内容4',''),(115,'2024-04-18 09:32:14','教师账号5','教师姓名5','手机号5','工作室编号5','工作室名称5','upload/tiwenxinxi_fengmian5.jpg,upload/tiwenxinxi_fengmian6.jpg,upload/tiwenxinxi_fengmian7.jpg','学生学号5','学生姓名5','2024-04-18 17:32:14','提问内容5',''),(116,'2024-04-18 09:32:14','教师账号6','教师姓名6','手机号6','工作室编号6','工作室名称6','upload/tiwenxinxi_fengmian6.jpg,upload/tiwenxinxi_fengmian7.jpg,upload/tiwenxinxi_fengmian8.jpg','学生学号6','学生姓名6','2024-04-18 17:32:14','提问内容6',''),(117,'2024-04-18 09:32:14','教师账号7','教师姓名7','手机号7','工作室编号7','工作室名称7','upload/tiwenxinxi_fengmian7.jpg,upload/tiwenxinxi_fengmian8.jpg,upload/tiwenxinxi_fengmian9.jpg','学生学号7','学生姓名7','2024-04-18 17:32:14','提问内容7',''),(118,'2024-04-18 09:32:14','教师账号8','教师姓名8','手机号8','工作室编号8','工作室名称8','upload/tiwenxinxi_fengmian8.jpg,upload/tiwenxinxi_fengmian9.jpg,upload/tiwenxinxi_fengmian10.jpg','学生学号8','学生姓名8','2024-04-18 17:32:14','提问内容8','');
/*!40000 ALTER TABLE `tiwenxinxi` 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,12,'学生学号2','xuesheng','学生','vjovip5ipj3pso5qvvtlzbhfk2zfctk4','2024-04-18 09:36:25','2024-04-18 10:36:25'),(2,1,'admin','users','管理员','4xqvkltoar31u957osztkw4k4jte9031','2024-04-18 09:36:57','2024-04-18 10:36:57'),(3,21,'教师账号1','jiaoshi','教师','ipyrd6nxqzcgvnlw4mny8r0xrxnpt0r1','2024-04-18 09:37:42','2024-04-18 10:37:42'),(4,11,'学生学号1','xuesheng','学生','wovx2qc5qavp44rndjkyh9g2hofp7t1h','2024-04-18 09:37:55','2024-04-18 10:37:56');
/*!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-04-18 09:32:14');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wanchengrenwu`
--

DROP TABLE IF EXISTS `wanchengrenwu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wanchengrenwu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jiaoshizhanghao` varchar(200) DEFAULT NULL COMMENT '教师账号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',
  `gongzuoshibianhao` varchar(200) DEFAULT NULL COMMENT '工作室编号',
  `gongzuoshimingcheng` varchar(200) DEFAULT NULL COMMENT '工作室名称',
  `fengmian` longtext COMMENT '封面',
  `renwubiaoti` varchar(200) DEFAULT NULL COMMENT '任务标题',
  `xueshengxuehao` varchar(200) DEFAULT NULL COMMENT '学生学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `wanchengshijian` datetime DEFAULT NULL COMMENT '完成时间',
  `wanchengfujian` 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 `wanchengrenwu`
--

LOCK TABLES `wanchengrenwu` WRITE;
/*!40000 ALTER TABLE `wanchengrenwu` DISABLE KEYS */;
INSERT INTO `wanchengrenwu` VALUES (71,'2024-04-18 09:32:14','教师账号1','教师姓名1','手机号1','工作室编号1','工作室名称1','upload/wanchengrenwu_fengmian1.jpg,upload/wanchengrenwu_fengmian2.jpg,upload/wanchengrenwu_fengmian3.jpg','任务标题1','学生学号1','学生姓名1','2024-04-18 17:32:14',''),(72,'2024-04-18 09:32:14','教师账号2','教师姓名2','手机号2','工作室编号2','工作室名称2','upload/wanchengrenwu_fengmian2.jpg,upload/wanchengrenwu_fengmian3.jpg,upload/wanchengrenwu_fengmian4.jpg','任务标题2','学生学号2','学生姓名2','2024-04-18 17:32:14',''),(73,'2024-04-18 09:32:14','教师账号3','教师姓名3','手机号3','工作室编号3','工作室名称3','upload/wanchengrenwu_fengmian3.jpg,upload/wanchengrenwu_fengmian4.jpg,upload/wanchengrenwu_fengmian5.jpg','任务标题3','学生学号3','学生姓名3','2024-04-18 17:32:14',''),(74,'2024-04-18 09:32:14','教师账号4','教师姓名4','手机号4','工作室编号4','工作室名称4','upload/wanchengrenwu_fengmian4.jpg,upload/wanchengrenwu_fengmian5.jpg,upload/wanchengrenwu_fengmian6.jpg','任务标题4','学生学号4','学生姓名4','2024-04-18 17:32:14',''),(75,'2024-04-18 09:32:14','教师账号5','教师姓名5','手机号5','工作室编号5','工作室名称5','upload/wanchengrenwu_fengmian5.jpg,upload/wanchengrenwu_fengmian6.jpg,upload/wanchengrenwu_fengmian7.jpg','任务标题5','学生学号5','学生姓名5','2024-04-18 17:32:14',''),(76,'2024-04-18 09:32:14','教师账号6','教师姓名6','手机号6','工作室编号6','工作室名称6','upload/wanchengrenwu_fengmian6.jpg,upload/wanchengrenwu_fengmian7.jpg,upload/wanchengrenwu_fengmian8.jpg','任务标题6','学生学号6','学生姓名6','2024-04-18 17:32:14',''),(77,'2024-04-18 09:32:14','教师账号7','教师姓名7','手机号7','工作室编号7','工作室名称7','upload/wanchengrenwu_fengmian7.jpg,upload/wanchengrenwu_fengmian8.jpg,upload/wanchengrenwu_fengmian9.jpg','任务标题7','学生学号7','学生姓名7','2024-04-18 17:32:14',''),(78,'2024-04-18 09:32:14','教师账号8','教师姓名8','手机号8','工作室编号8','工作室名称8','upload/wanchengrenwu_fengmian8.jpg,upload/wanchengrenwu_fengmian9.jpg,upload/wanchengrenwu_fengmian10.jpg','任务标题8','学生学号8','学生姓名8','2024-04-18 17:32:14','');
/*!40000 ALTER TABLE `wanchengrenwu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wenjianxinxi`
--

DROP TABLE IF EXISTS `wenjianxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wenjianxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gongzuoshimingcheng` varchar(200) DEFAULT NULL COMMENT '工作室名称',
  `wenjianbiaoti` varchar(200) DEFAULT NULL COMMENT '文件标题',
  `fengmian` longtext COMMENT '封面',
  `wenjian` longtext COMMENT '文件',
  `shangchuanshijian` datetime DEFAULT NULL COMMENT '上传时间',
  `wenjianjianjie` 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 `wenjianxinxi`
--

1. 微信小程序

微信小程序作为本系统前端的重要组成部分，为高校师生提供了便捷、高效的移动应用体验。通过微信小程序，用户无需下载安装额外APP，即可直接在微信生态内完成工作室管理、信息查询、在线交流等功能。借助微信开发者工具，开发团队能够快速构建、调试和发布小程序，同时利用微信平台成熟的用户基础和支付、社交等功能，实现系统与微信生态的无缝集成。

2. 开发语言：Java

Java作为本系统后端开发的主要编程语言，以其跨平台性、稳定性以及成熟的生态系统为系统提供了强有力的支持。通过Java，开发人员能够构建高性能、可维护且扩展性强的服务。其面向对象的特性和丰富的第三方类库，使得业务逻辑处理和数据交互更为高效，为高校师生工作室管理系统提供坚实的技术保障。

3. 框架：Spring Boot

Spring Boot基于Spring生态系统，极大地简化了项目的初始搭建和开发配置。它采用“约定优于配置”的理念，使得开发者能够快速构建独立、生产级别的应用。对于本系统，Spring Boot不仅加速了后端服务的开发，还通过自动化配置和内嵌Tomcat等特性，实现了高效的微服务架构和轻量级部署，降低了系统的维护难度。

4. JDK版本：JDK 1.8

JDK 1.8是Java的一次重要更新，引入了Lambda表达式、Stream API以及默认方法等新特性。这些特性使得代码更为简洁、易读，同时大幅提高了并行数据处理能力。在高校师生工作室管理系统中，使用JDK 1.8不仅优化了数据处理流程，还提升了整体系统性能，为后续功能扩展奠定了良好基础。

5. 服务器：Tomcat 7

Tomcat 7作为一个成熟且稳定的Servlet容器，专注于Java Web应用的运行与管理。它对Servlet和JSP规范的良好支持，确保了系统在处理大量并发请求时依然保持高效稳定的表现。基于Tomcat 7的部署环境，为系统提供了坚实的运行保障，使高校师生工作室管理系统在实际使用中能够满足高并发、高访问量的需求。

6. 数据库：MySQL 5.7

MySQL 5.7是一款高效且广泛应用的开源关系型数据库管理系统，专注于数据存储和高并发访问的优化。该版本在查询性能、存储引擎优化以及对JSON数据类型的支持方面都有显著提升。高校师生工作室管理系统利用MySQL 5.7作为核心数据存储方案，有效管理用户信息、工作室资源及各类交互数据，确保数据安全和快速响应。

7. 数据库工具：Navicat 11

Navicat 11提供了一套直观的图形化数据库管理界面，支持包括MySQL在内的多种数据库管理系统。开发人员可以借助Navicat 11进行数据库设计、SQL语句编写、数据备份与恢复等操作，大幅提升数据库管理的效率和准确性。在本系统的开发过程中，该工具帮助团队高效完成数据库的维护和优化工作。

8. 开发软件：Eclipse / MyEclipse / IDEA

Eclipse、MyEclipse和IntelliJ IDEA都是目前流行的Java集成开发环境（IDE），各具特色。Eclipse和MyEclipse拥有丰富的插件生态，适用于多种Web应用开发；而IDEA以其智能代码提示、强大的重构工具及高效调试功能闻名，为开发者提供了极佳的编码体验。开发团队可以根据个人习惯选择合适的IDE，确保系统开发过程高效而顺畅。