spring boot 整合MultipartFile 上传 xlsx文件教程

最新推荐文章于 2025-11-25 12:11:25 发布

原创最新推荐文章于 2025-11-25 12:11:25 发布 · 133 阅读

CC 4.0 BY-SA版权

文章标签：

package com.example.login;
import com.example.util.DateUtilS;
import com.example.util.EasyExcelUtil;
import com.example.util.ReSultMapUtil;
import org.apache.commons.io.IOUtils;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;

import org.springframework.beans.factory.annotation.Value;

import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import java.io.*;
import java.util.HashMap;
import java.util.Map;

@RestController
public class FileuploadController {
    
    @Value("${file.upload-dir}")
    private String uploadDir;
    Logger log= LogManager.getLogger(FileuploadController.class);
    
    @RequestMapping("/api/public/importstudent")
    public String importstudent(@RequestParam("file") MultipartFile[] files ){
        StringBuilder result = new StringBuilder();
        FileOutputStream out = null;
        InputStream inputStream=null;
        for (MultipartFile file : files) {
            if (!file.isEmpty()) {
                try {


                     inputStream=file.getInputStream();
                    String fileName =   uploadDir+File.separator+ DateUtilS.createDateStr()+".xlsx";

                    out = new FileOutputStream(fileName); // 本地目标文件
                    IOUtils.copy(inputStream, out);
                    Map map=new HashMap();

                    return  ReSultMapUtil.buildSuccessMesage(map);
                } catch (IOException e) {
                    result.append("文件 '").append(file.getOriginalFilename()).append("' 上传失败（").append(e.getMessage()).append("）；");
                }finally {
                    try {
                        out.close();
                        inputStream.close();

                    } catch (IOException e) {
                        Map map=new HashMap();
                        e.printStackTrace();
                        return  ReSultMapUtil.builderrorMesage(map);

                    }
                }
            }
        }
        return result.toString();

    }
}

application.yml

# 服务器端口
server:
  port: 8081


file:
   upload-dir: D://path//to
servlet:
   multipart:
       max-file-size: 10MB  # 单个文件上传的最大大小，这里设置为10MB
       max-request-size: 20MB  # 整个请求（包含所有文件和其他表单数据）的最大大小，这里设置为20MB



# 日志级别
logging:
  level:
    root: DEBUG
    com.example.dao: DEBUG