<div style="padding: 8px 0; background: #f8fbff">
        <el-upload
          name="file"
          ref="uploadRef"
          class="upload-file-uploader"
          v-model:file-list="fileList"
          :action="uploadUrl"
          :http-request="httpRequest"
          :auto-upload="autoUpload"
          :before-upload="beforeUpload"
          :drag="drag"
          :limit="props.limit"
          :multiple="props.limit > 1"
          :on-error="excelUploadError"
          :on-exceed="handleExceed"
          :on-remove="handleRemove"
          :on-success="handleFileSuccess"
        >
          <el-button type="primary">
            <Icon icon="ep:upload-filled" />
            选取文件
          </el-button>
          <template v-if="isShowTip" #tip>
            <div style="font-size: 10px">
              1.格式为 <b style="color: #f56c6c">{{ fileType.join('/') }}</b> 的文件; 2.大小不超过 <b style="color: #f56c6c">{{ fileSize }}MB</b>
            </div>
          </template>
        </el-upload>
        
        <el-table ref="multipleTableRef" :data="uploadList" style="width: 100%; margin-top: 10px; height: 200px; width:660px">
          <el-table-column label="序号" type="index"  header-align="center" align="center" width="60px" fixed />
          <el-table-column label="文件名称" align="center" prop="name" :show-overflow-tooltip="true" />
          <el-table-column label="文件路径" align="center" prop="url" :show-overflow-tooltip="true" />
          <el-table-column label="操作" align="center" fixed="right" width="140px">
            <template #default="scope">
              <el-button
                size="small"
                link
                type="primary"
                @click.prevent="deleteFileRow(scope.$index, uploadList)"
                >删除</el-button
              >
            </template>
          </el-table-column>
        </el-table>
      </div>

js

import type { UploadInstance, UploadProps, UploadRawFile, UploadUserFile } from 'element-plus'
import { useNewUpload } from '@/components/UploadFile/src/useUpload'
import { CommonStatusEnum } from '@/utils/constants'
import { UploadFile } from 'element-plus/es/components/upload/src/upload'
import { propTypes } from '@/utils/propTypes'
// ========== 上传相关 ==========
const uploadRef = ref<UploadInstance>()
const uploadList = ref<UploadUserFile[]>([])
const fileList = ref<UploadUserFile[]>([])
const uploadNumber = ref<number>(0)
const props = defineProps({
  modelValue: propTypes.oneOfType<any>([]).isRequired,
  title: propTypes.string.def('文件上传'),
  fileType: propTypes.array.def(['doc', 'xls', 'ppt', 'txt', 'pdf']), // 文件类型, 例如['png', 'jpg', 'jpeg']
  fileSize: propTypes.number.def(5), // 大小限制(MB)
  limit: propTypes.number.def(5), // 数量限制
  autoUpload: propTypes.bool.def(true), // 自动上传
  drag: propTypes.bool.def(false), // 拖拽上传
  isShowTip: propTypes.bool.def(true) // 是否显示提示
})
const fileData = ref<any>([])
const formData = ref({
  id: undefined,
  courseType: undefined,
  subject: undefined,
  fileType: undefined,
  appendixName: undefined,
  creator:  userStore.user.id,
  appendixFile: undefined,
  createTime: undefined,
  title: undefined,
  remark: undefined,
  courseId: undefined,
  fileData: undefined,
  fileExists: undefined,
})
// 文件上传之前判断
const beforeUpload: UploadProps['beforeUpload'] = (file: UploadRawFile) => {
  if (fileList.value.length >= props.limit) {
    message.error(`上传文件数量不能超过${props.limit}个!`)
    return false
  }
  let fileExtension = ''
  if (file.name.lastIndexOf('.') > -1) {
    fileExtension = file.name.slice(file.name.lastIndexOf('.') + 1)
  }
  const isImg = props.fileType.some((type: string) => {
    if (file.type.indexOf(type) > -1) return true
    return !!(fileExtension && fileExtension.indexOf(type) > -1)
  })
  const isLimit = file.size < props.fileSize * 1024 * 1024
  if (!isImg) {
    message.error(`文件格式不正确, 请上传${props.fileType.join('/')}格式!`)
    return false
  }
  if (!isLimit) {
    message.error(`上传文件大小不能超过${props.fileSize}MB!`)
    return false
  }
  const existFile = fileList.value.slice(0, fileList.value.length - 1).find(f => f.name === file.name)
  if (existFile) {
    message.error(`当前文件已经存在!`)
    return false
  }
  message.success('正在上传文件，请稍候...')
  uploadNumber.value++
}
const deleteFileRow = (index, rows) => {
  rows.splice(index, 1)
}
// 文件上传成功
const handleFileSuccess: UploadProps['onSuccess'] = (res: any): void => {
  uploadList.value.push({ uid: res.data.id, name: res.data.name, url: res.data.url })
  message.success('上传成功')
}
// 文件数超出提示
const handleExceed: UploadProps['onExceed'] = (): void => {
  message.error(`上传文件数量不能超过${props.limit}个!`)
}
// 上传错误提示
const excelUploadError: UploadProps['onError'] = (): void => {
  message.error('导入数据失败，请您重新上传！')
}
// 删除上传文件
const handleRemove = (file: UploadFile) => {
  const index = fileList.value.map((f) => f.name).indexOf(file.name)
  if (index > -1) {
    fileList.value.splice(index, 1)
  }
}
/** 提交表单 */
const emit = defineEmits(['success']) // 定义 success 事件，用于操作成功后的回调
const submitForm = async () => {
  // 校验表单
  await formRef.value.validate()
  // 提交请求
  formLoading.value = true
  fileData.value = []
  for (let i = 0; i < uploadList.value.length; i++) {
    const UserCourse = {
      fileId: uploadList.value[i].uid
    }
    fileData.value.push(UserCourse)
  }
  try {
    const data = formData.value as unknown as ResearchingManageVO
    data.fileData = fileData.value
    if (uploadList && uploadList.value.length > 0) {
      data.fileExists = 97
    } else {
      data.fileExists = 98
    }
    // if (flag === 1) {
    //   data.status = CommonStatusEnum.DISABLE
    // } else {
    //   data.status = CommonStatusEnum.ENABLE
    // }
    if (formType.value === 'create') {
      await ResearchingManageApi.createResearchingManage(data)
      message.success(t('common.createSuccess'))
    } else {
      await ResearchingManageApi.updateResearchingManage(data)
      message.success(t('common.updateSuccess'))
    }
    dialogVisible.value = false
    // 发送操作成功的事件
    emit('success')
  } finally {
    formLoading.value = false
  }
}
/** 重置表单 */
const resetForm = () => {
  formData.value = {
    id: undefined,
  courseType: undefined,
  subject: undefined,
  fileType: undefined,
  appendixName: undefined,
  creator:  userStore.user.id,
  appendixFile: undefined,
  createTime: undefined,
  title: undefined,
  remark: undefined,
  courseId: undefined,
  fileData: undefined,
  fileExists: undefined,
  }
  formRef.value?.resetFields()
}

useNewUpload.ts

import * as FileApi from '@/api/infra/file'
import CryptoJS from 'crypto-js'
import { UploadRawFile, UploadRequestOptions } from 'element-plus/es/components/upload/src/upload'
import axios from 'axios'
export const useUpload = () => {
  // 后端上传地址
  const uploadUrl = import.meta.env.VITE_UPLOAD_URL
  // 是否使用前端直连上传
  const isClientUpload = UPLOAD_TYPE.CLIENT === import.meta.env.VITE_UPLOAD_TYPE
  // 重写ElUpload上传方法
  const httpRequest = async (options: UploadRequestOptions) => {
    // 模式一：前端上传
    if (isClientUpload) {
      // 1.1 生成文件名称
      const fileName = await generateFileName(options.file)
      // 1.2 获取文件预签名地址
      const presignedInfo = await FileApi.getFilePresignedUrl(fileName)
      // 1.3 上传文件（不能使用 ElUpload 的 ajaxUpload 方法的原因：其使用的是 FormData 上传，Minio 不支持）
      return axios.put(presignedInfo.uploadUrl, options.file).then(() => {
        // 1.4. 记录文件信息到后端（异步）
        createFile(presignedInfo, fileName, options.file)
        // 通知成功，数据格式保持与后端上传的返回结果一致
        return { data: presignedInfo.url }
      })
    } else {
      // 模式二：后端上传
      // 重写 el-upload httpRequest 文件上传成功会走成功的钩子，失败走失败的钩子
      return new Promise((resolve, reject) => {
        FileApi.updateFile({ file: options.file })
          .then((res) => {
            if (res.code === 0) {
              resolve(res)
            } else {
              reject(res)
            }
          })
          .catch((res) => {
            reject(res)
          })
      })
    }
  }
  return {
    uploadUrl,
    httpRequest
  }
}
/**
 * 创建文件信息
 * @param vo 文件预签名信息
 * @param name 文件名称
 * @param file 文件
 */
function createFile(vo: FileApi.FilePresignedUrlRespVO, name: string, file: UploadRawFile) {
  const fileVo = {
    configId: vo.configId,
    url: vo.url,
    path: name,
    name: file.name,
    type: file.type,
    size: file.size
  }
  FileApi.createFile(fileVo)
  return fileVo
}
/**
 * 生成文件名称（使用算法SHA256）
 * @param file 要上传的文件
 */
async function generateFileName(file: UploadRawFile) {
  // 读取文件内容
  const data = await file.arrayBuffer()
  const wordArray = CryptoJS.lib.WordArray.create(data)
  // 计算SHA256
  const sha256 = CryptoJS.SHA256(wordArray).toString()
  // 拼接后缀
  const ext = file.name.substring(file.name.lastIndexOf('.'))
  return `${sha256}${ext}`
}
/**
 * 上传类型
 */
enum UPLOAD_TYPE {
  // 客户端直接上传（只支持S3服务）
  CLIENT = 'client',
  // 客户端发送到后端上传
  SERVER = 'server'
}
export const useNewUpload = () => {
  // 后端上传地址
  const uploadUrl = import.meta.env.VITE_UPLOAD_URL
  // 是否使用前端直连上传
  const isClientUpload = UPLOAD_TYPE.CLIENT === import.meta.env.VITE_UPLOAD_TYPE
  // 重写ElUpload上传方法
  const httpRequest = async (options: UploadRequestOptions) => {
    // 模式一：前端上传
    if (isClientUpload) {
      // 1.1 生成文件名称
      const fileName = await generateFileName(options.file)
      // 1.2 获取文件预签名地址
      const presignedInfo = await FileApi.getFilePresignedUrl(fileName)
      // 1.3 上传文件（不能使用 ElUpload 的 ajaxUpload 方法的原因：其使用的是 FormData 上传，Minio 不支持）
      return axios.put(presignedInfo.uploadUrl, options.file).then(() => {
        // 1.4. 记录文件信息到后端（异步）
        createFile(presignedInfo, fileName, options.file)
        // 通知成功，数据格式保持与后端上传的返回结果一致
        return { data: presignedInfo.url }
      })
    } else {
      // 模式二：后端上传
      // 重写 el-upload httpRequest 文件上传成功会走成功的钩子，失败走失败的钩子
      return new Promise((resolve, reject) => {
        FileApi.uploadFile({ file: options.file })
          .then((res) => {
            if (res.code === 0) {
              resolve(res)
            } else {
              reject(res)
            }
          })
          .catch((res) => {
            reject(res)
          })
      })
    }
  }
  return {
    uploadUrl,
    httpRequest
  }
}

FileApi

import request from '@/config/axios'
export interface FilePageReqVO extends PageParam {
  path?: string
  type?: string
  createTime?: Date[]
}
// 文件预签名地址 Response VO
export interface FilePresignedUrlRespVO {
  // 文件配置编号
  configId: number
  // 文件上传 URL
  uploadUrl: string
  // 文件 URL
  url: string
}
// 查询文件列表
export const getFilePage = (params: FilePageReqVO) => {
  return request.get({ url: '/infra/file/page', params })
}
// 删除文件
export const deleteFile = (id: number) => {
  return request.delete({ url: '/infra/file/delete?id=' + id })
}
// 获取文件预签名地址
export const getFilePresignedUrl = (path: string) => {
  return request.get<FilePresignedUrlRespVO>({
    url: '/infra/file/presigned-url',
    params: { path }
  })
}
// 创建文件
export const createFile = (data: any) => {
  return request.post({ url: '/infra/file/create', data })
}
// 上传文件
export const updateFile = (data: any) => {
  return request.upload({ url: '/infra/file/upload', data })
}
// 上传文件
export const uploadFile = (data: any) => {
  return request.upload({ url: '/infra/file/uploadFile', data })
}

数据库

创建一个上传文件的子表，字段如下：

编辑

主表字段如下：

编辑

后端

项目构成

编辑

主表

实体类

package com.todod.education.module.teach.dal.dataobject.researchingmanage;
import lombok.*;
import java.util.*;
import java.time.LocalDateTime;
import java.time.LocalDateTime;
import com.baomidou.mybatisplus.annotation.*;
import com.todod.education.framework.mybatis.core.dataobject.BaseDO;
/**
 * 教研管理 DO
 *
 * @author 平台管理员
 */
@TableName("teach_researching_manage")
@KeySequence("teach_researching_manage_seq") // 用于 Oracle、PostgreSQL、Kingbase、DB2、H2 数据库的主键自增。如果是 MySQL 等数据库，可不写。
@Data
@EqualsAndHashCode(callSuper = true)
@ToString(callSuper = true)
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class ResearchingManageDO extends BaseDO {
    /**
     * 主键id
     */
    @TableId
    private Long id;
    /**
     * 课程产品 课程id
     */
    private Long courseId;
    /**
     * 标题
     */
    private String title;
    /**
     * 课程类型
     */
    private String courseType;
    /**
     * 课程名称
     */
    @TableField(exist = false)
    private String courseName;
    /**
     * 科目
     *
     */
    private String subject;
    /**
     * 文件类型
     */
    private String fileType;
    /**
     * 附件名称
     */
    private String appendixName;
    /**
     * 附件
     */
    private String appendixFile;
    /**
     * 附件(97:有/98:无)
     */
    private Short fileExists;
    /**
     * 备注
     */
    private String remark;
    /**
     * 教案管理附件id
     */
    @TableField(exist = false)
    private Long teachResearchingManageId;
}

ResearchingManageSaveReqVO

package com.todod.education.module.teach.controller.admin.researchingmanage.vo;
import com.alibaba.excel.annotation.ExcelProperty;
import com.todod.education.module.teach.dal.dataobject.researchingmanage.ResearchingManageFileDO;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.*;
import java.util.*;
import jakarta.validation.constraints.*;
import org.springframework.format.annotation.DateTimeFormat;
import java.time.LocalDateTime;
@Schema(description = "管理后台 - 教研管理新增/修改 Request VO")
@Data
public class ResearchingManageSaveReqVO {
    @Schema(description = "主键id", requiredMode = Schema.RequiredMode.REQUIRED, example = "13167")
    private Long id;
    @Schema(description = "课程产品 课程id", requiredMode = Schema.RequiredMode.REQUIRED, example = "13167")
    private Long courseId;
    @Schema(description = "标题", example = "2")
    private String title;
    @Schema(description = "课程类型", example = "2")
    private String courseType;
    @Schema(description = "科目")
    private String subject;
    @Schema(description = "文件类型", example = "2")
    private String fileType;
    @Schema(description = "附件名称", example = "芋艿")
    private String appendixName;
    @Schema(description = "创建人")
    private String creator;
    @Schema(description = "附件(97:有/98:无)", requiredMode = Schema.RequiredMode.REQUIRED)
    @ExcelProperty("附件(97:有/98:无)")
    private Short fileExists;
    @Schema(description = "创建时间")
    private LocalDateTime createTime;
//
//    @Schema(description = "附件")
//    private String appendixFile;
    @Schema(description = "备注")
    private String remark;
    @Schema(description = "备注")
    private String courseName;
//    @Schema(description = "附件子表数据", example = "测试")
//    private List<ResearchingManageFileDO> appendixFile;
    @Schema(description = "附件子表数据", example = "测试")
    private List<ResearchingManageFileDO> fileData;
}

ResearchingManageRespVO

package com.todod.education.module.teach.controller.admin.researchingmanage.vo;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.*;
import java.util.*;
import java.util.*;
import org.springframework.format.annotation.DateTimeFormat;
import java.time.LocalDateTime;
import com.alibaba.excel.annotation.*;
import com.todod.education.framework.excel.core.annotations.DictFormat;
import com.todod.education.framework.excel.core.convert.DictConvert;
@Schema(description = "管理后台 - 教研管理 Response VO")
@Data
@ExcelIgnoreUnannotated
public class ResearchingManageRespVO {
    @Schema(description = "主键id", requiredMode = Schema.RequiredMode.REQUIRED, example = "20302")
    private Long id;
    @Schema(description = "课程产品 课程id", requiredMode = Schema.RequiredMode.REQUIRED, example = "20302")
    private Long courseId;
    @Schema(description = "标题", example = "2")
    @ExcelProperty("标题")
    private String title;
    @Schema(description = "课程名称", example = "2")
    @ExcelProperty("课程名称")
    private String courseName;
    @Schema(description = "课程类型", example = "2")
    @ExcelProperty("课程类型")
    private String courseType;
    @Schema(description = "科目")
    @ExcelProperty(value = "科目", converter = DictConvert.class)
    @DictFormat("subject") // TODO 代码优化：建议设置到对应的 DictTypeConstants 枚举类中
    private String subject;
    @Schema(description = "文件类型", example = "2")
    @ExcelProperty("文件类型")
    private String fileType;
    @Schema(description = "附件名称", example = "芋艿")
    @ExcelProperty("附件名称")
    private String appendixName;
    @Schema(description = "创建人")
    private Long creator;
    @Schema(description = "创建时间")
    @ExcelProperty("创建时间")
    private LocalDateTime createTime;
    @Schema(description = "最后编辑人")
    private Long updater;
    @Schema(description = "最后编辑时间")
    @ExcelProperty("最后编辑时间")
    private LocalDateTime updateTime;
    @Schema(description = "附件")
    private String appendixFile;
    @Schema(description = "备注")
    private String remark;
    @Schema(description = "教研管理附件id", requiredMode = Schema.RequiredMode.REQUIRED, example = "20302")
    private Long teachResearchingManageId;
    @Schema(description = "附件(97:有/98:无)", requiredMode = Schema.RequiredMode.REQUIRED)
    @ExcelProperty("附件(97:有/98:无)")
    private Short fileExists;
}

Mapper

package com.todod.education.module.teach.dal.mysql.researchingmanage;
import com.todod.education.framework.mybatis.core.mapper.BaseMapperX;
import com.todod.education.framework.mybatis.core.query.LambdaQueryWrapperX;
import com.todod.education.module.teach.dal.dataobject.researchingmanage.ResearchingManageFileDO;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
/**
 * 教研管理文件 Mapper
 *
 * @author 平台管理员
 */
@Mapper
public interface ResearchingManageFileMapper extends BaseMapperX<ResearchingManageFileDO> {
    /**
     * 获得教研管理附件列表
     *
     * @param teacherResearchingManageId 公函明细
     * @return 教研管理文件明细列表
     */
    default List<ResearchingManageFileDO> getSimpleFileList(Long teacherResearchingManageId) {
        return selectList(new LambdaQueryWrapperX<ResearchingManageFileDO>()
                .eqIfPresent(ResearchingManageFileDO::getTeachResearchingManageId, teacherResearchingManageId)
        );
    }
}

service

package com.todod.education.module.teach.service.researchingmanage;
import java.util.*;
import jakarta.validation.*;
import com.todod.education.module.teach.controller.admin.researchingmanage.vo.*;
import com.todod.education.module.teach.dal.dataobject.researchingmanage.ResearchingManageDO;
import com.todod.education.framework.common.pojo.PageResult;
import com.todod.education.framework.common.pojo.PageParam;
/**
 * 教研管理 Service 接口
 *
 * @author 平台管理员
 */
public interface ResearchingManageService {
    /**
     * 创建教研管理
     *
     * @param createReqVO 创建信息
     * @return 编号
     */
    Long createResearchingManage(@Valid ResearchingManageSaveReqVO createReqVO);
    /**
     * 更新教研管理
     *
     * @param updateReqVO 更新信息
     */
    void updateResearchingManage(@Valid ResearchingManageSaveReqVO updateReqVO);
}

package com.todod.education.module.teach.service.researchingmanage;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.todod.education.module.teach.dal.dataobject.researchingmanage.ResearchingManageFileDO;
import com.todod.education.module.teach.dal.mysql.researchingmanage.ResearchingManageFileMapper;
import org.springframework.stereotype.Service;
import jakarta.annotation.Resource;
import org.springframework.validation.annotation.Validated;
import org.springframework.transaction.annotation.Transactional;
import java.util.*;
import com.todod.education.module.teach.controller.admin.researchingmanage.vo.*;
import com.todod.education.module.teach.dal.dataobject.researchingmanage.ResearchingManageDO;
import com.todod.education.framework.common.pojo.PageResult;
import com.todod.education.framework.common.pojo.PageParam;
import com.todod.education.framework.common.util.object.BeanUtils;
import com.todod.education.module.teach.dal.mysql.researchingmanage.ResearchingManageMapper;
import static com.todod.education.framework.common.exception.util.ServiceExceptionUtil.exception;
import static com.todod.education.module.teach.enums.ErrorCodeConstants.*;
/**
 * 教研管理 Service 实现类
 *
 * @author 平台管理员
 */
@Service
@Validated
public class ResearchingManageServiceImpl implements ResearchingManageService {
    @Resource
    private ResearchingManageMapper researchingManageMapper;
    @Resource
    private ResearchingManageFileMapper researchingManageFileMapper;
    @Override
    public Long createResearchingManage(ResearchingManageSaveReqVO createReqVO) {
        // 插入
        ResearchingManageDO researchingManage = BeanUtils.toBean(createReqVO, ResearchingManageDO.class);
        researchingManageMapper.insert(researchingManage);
        //往文件子表中插入数据
        for (ResearchingManageFileDO fileDO : createReqVO.getFileData()) {
            ResearchingManageFileDO researchingManageFileDO = new ResearchingManageFileDO();
            researchingManageFileDO.setTeachResearchingManageId(researchingManage.getId());
            researchingManageFileDO.setFileId(fileDO.getId());
            researchingManageFileMapper.insert(researchingManageFileDO);
        }
        // 返回
        return researchingManage.getId();
    }
    @Override
    public void updateResearchingManage(ResearchingManageSaveReqVO updateReqVO) {
        // 校验存在
        validateResearchingManageExists(updateReqVO.getId());
        // 更新
        ResearchingManageDO updateObj = BeanUtils.toBean(updateReqVO, ResearchingManageDO.class);
        researchingManageMapper.updateById(updateObj);
        //往文件子表中插入数据
        for (ResearchingManageFileDO fileDO : updateReqVO.getFileData()) {
            ResearchingManageFileDO researchingManageFileDO = new ResearchingManageFileDO();
            researchingManageFileDO.setTeachResearchingManageId(updateObj.getId());
            researchingManageFileDO.setFileId(fileDO.getId());
            researchingManageFileMapper.insert(researchingManageFileDO);
        }
    }
}

controller

package com.todod.education.module.teach.controller.admin.researchingmanage;
import org.springframework.web.bind.annotation.*;
import jakarta.annotation.Resource;
import org.springframework.validation.annotation.Validated;
import org.springframework.security.access.prepost.PreAuthorize;
import io.swagger.v3.oas.annotations.tags.Tag;
import io.swagger.v3.oas.annotations.Parameter;
import io.swagger.v3.oas.annotations.Operation;
import jakarta.validation.constraints.*;
import jakarta.validation.*;
import jakarta.servlet.http.*;
import java.util.*;
import java.io.IOException;
import com.todod.education.framework.common.pojo.PageParam;
import com.todod.education.framework.common.pojo.PageResult;
import com.todod.education.framework.common.pojo.CommonResult;
import com.todod.education.framework.common.util.object.BeanUtils;
import static com.todod.education.framework.common.pojo.CommonResult.success;
import com.todod.education.framework.excel.core.util.ExcelUtils;
import com.todod.education.framework.apilog.core.annotation.ApiAccessLog;
import static com.todod.education.framework.apilog.core.enums.OperateTypeEnum.*;
import com.todod.education.module.teach.controller.admin.researchingmanage.vo.*;
import com.todod.education.module.teach.dal.dataobject.researchingmanage.ResearchingManageDO;
import com.todod.education.module.teach.service.researchingmanage.ResearchingManageService;
@Tag(name = "管理后台 - 教研管理")
@RestController
@RequestMapping("/teach/researching-manage")
@Validated
public class ResearchingManageController {
    @Resource
    private ResearchingManageService researchingManageService;
    @PostMapping("/create")
    @Operation(summary = "创建教研管理")
    @PreAuthorize("@ss.hasPermission('teach:researching-manage:create')")
    public CommonResult<Long> createResearchingManage(@Valid @RequestBody ResearchingManageSaveReqVO createReqVO) {
        return success(researchingManageService.createResearchingManage(createReqVO));
    }
    @PutMapping("/update")
    @Operation(summary = "更新教研管理")
    @PreAuthorize("@ss.hasPermission('teach:researching-manage:update')")
    public CommonResult<Boolean> updateResearchingManage(@Valid @RequestBody ResearchingManageSaveReqVO updateReqVO) {
        researchingManageService.updateResearchingManage(updateReqVO);
        return success(true);
    }
}

子表

实体类

package com.todod.education.module.teach.dal.dataobject.researchingmanage;
import com.baomidou.mybatisplus.annotation.KeySequence;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.todod.education.framework.mybatis.core.dataobject.BaseDO;
import lombok.*;
/**
 * 教研管理文件 DO
 *
 * @author 平台管理员
 */
@TableName("teach_researching_manage_file")
@KeySequence("teach_researching_manage_file_seq") // 用于 Oracle、PostgreSQL、Kingbase、DB2、H2 数据库的主键自增。如果是 MySQL 等数据库，可不写。
@Data
@EqualsAndHashCode(callSuper = true)
@ToString(callSuper = true)
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class ResearchingManageFileDO extends BaseDO {
    /**
     * 主键id
     */
    @TableId
    private Long id;
    /**
     * 教研管理id
     */
    private Long teachResearchingManageId;
    /**
     * 附件id
     */
    private Long fileId;
}

Mapper

package com.todod.education.module.teach.dal.mysql.researchingmanage;
import com.todod.education.framework.mybatis.core.mapper.BaseMapperX;
import com.todod.education.framework.mybatis.core.query.LambdaQueryWrapperX;
import com.todod.education.module.teach.dal.dataobject.researchingmanage.ResearchingManageFileDO;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
/**
 * 教研管理文件 Mapper
 *
 * @author 平台管理员
 */
@Mapper
public interface ResearchingManageFileMapper extends BaseMapperX<ResearchingManageFileDO> {
    /**
     * 获得教研管理附件列表
     *
     * @param teacherResearchingManageId 公函明细
     * @return 教研管理文件明细列表
     */
    default List<ResearchingManageFileDO> getSimpleFileList(Long teacherResearchingManageId) {
        return selectList(new LambdaQueryWrapperX<ResearchingManageFileDO>()
                .eqIfPresent(ResearchingManageFileDO::getTeachResearchingManageId, teacherResearchingManageId)
        );
    }
}

多个文件上传

编辑

前端

html

js

useNewUpload.ts

FileApi

数据库

后端

项目构成

主表

实体类

ResearchingManageSaveReqVO

ResearchingManageRespVO

Mapper

service

controller

子表

实体类

Mapper

热门文章

最新文章

相关电子书

探索云世界

热门

云计算

大数据

云原生

人工智能

数据库

开发与运维

活动广场

任务中心

训练营

直播

乘风者计划

下载

镜像站

技术资料

多个文件上传

编辑

前端

html

js

useNewUpload.ts

FileApi

数据库

后端

项目构成

主表

实体类

ResearchingManageSaveReqVO

ResearchingManageRespVO

Mapper

service

controller

子表

实体类

Mapper

热门文章

最新文章

相关电子书