Java编写一个文件导入接口，根据校验结果返回错误数据的Excel文件或正确时返回JSON报文。

Ryan James

于 2024-01-29 10:36:30 发布

阅读量699

点赞数 6

CC 4.0 BY-SA版权

文章标签： java

本文链接：https://blog.csdn.net/A_len/article/details/135906740

import org.apache.poi.ss.usermodel.*;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

@RestController
public class FileImportController {

    @PostMapping("/import")
    public ResponseEntity<?> importFile(@RequestParam("file") MultipartFile file) {
        // 进行文件校验
        boolean isValid = validateFile(file);

        if (isValid) {
            // 文件校验通过，返回JSON报文
            String jsonResponse = generateJsonResponse();
            HttpHeaders headers = new HttpHeaders();
            headers.setContentType(MediaType.APPLICATION_JSON);
            return new ResponseEntity<>(jsonRe