java - 从 React 和 Spring Boot 上传 CSV 文件
问题描述
也许有人知道如何解决将文件上传到后端的问题。 从 Postman 发送文件看起来像 但是从 React 上传后,我有这样的异常:
2020-11-09 18:17:38.829 调试 10764 --- [nio-8081-exec-7] osweb.servlet.DispatcherServlet:发布“/api/employees/save-from-csv”,参数={masked} 2020 -11-09 18:17:38.829 调试 10764 --- [nio-8081-exec-7] swsmmaRequestMappingHandlerMapping:映射到 com.bank.controller.EmployeeController#uploadFile(MultipartFile, Model) 2020-11-09 18:17: 38.831 调试 10764 --- [nio-8081-exec-7] .wsmmaServletInvocableHandlerMethod:无法解析公共 org.springframework.http.ResponseEntity<com.bank.message.ResponseMessage> com.bank.controller.EmployeeController 中的参数 [0] .uploadFile(org.springframework.web.multipart.MultipartFile,org.springframework.ui.Model) throws java.io.IOException: required request part 'file' is not present 2020-11-09 18:17:38.831 DEBUG 10764 - -- [nio-8081-exec-7] .mmaExceptionHandlerExceptionResolver:使用@ExceptionHandler com.bank.exceptions.FileUploadExceptionAdvice#handleException(Exception, WebRequest) 2020-11-09 18:17:38.832 DEBUG 10764 --- [nio-8081-exec-7] oswsmmaHttpEntityMethodProcessor:不匹配 [application /json,text/plain,/],支持:[] 2020-11-09 18:17:38.833 WARN 10764 --- [nio-8081-exec-7] .mmaExceptionHandlerExceptionResolver:已解决 [org.springframework.web.multipart .support.MissingServletRequestPartException:所需的请求部分“文件”不存在] 2020-11-09 18:17:38.837 DEBUG 10764 --- [nio-8081-exec-7] osweb.servlet.DispatcherServlet:已完成 400 BAD_REQUESTmaHttpEntityMethodProcessor:[application/json,text/plain,/] 不匹配,支持:[] 2020-11-09 18:17:38.833 WARN 10764 --- [nio-8081-exec-7] .mmaExceptionHandlerExceptionResolver:已解决 [ org.springframework.web.multipart.support.MissingServletRequestPartException:所需的请求部分“文件”不存在] 2020-11-09 18:17:38.837 DEBUG 10764 --- [nio-8081-exec-7] osweb.servlet。 DispatcherServlet:已完成 400 BAD_REQUESTmaHttpEntityMethodProcessor:[application/json,text/plain,/] 不匹配,支持:[] 2020-11-09 18:17:38.833 WARN 10764 --- [nio-8081-exec-7] .mmaExceptionHandlerExceptionResolver:已解决 [ org.springframework.web.multipart.support.MissingServletRequestPartException:所需的请求部分“文件”不存在] 2020-11-09 18:17:38.837 DEBUG 10764 --- [nio-8081-exec-7] osweb.servlet。 DispatcherServlet:已完成 400 BAD_REQUESTservlet.DispatcherServlet:已完成 400 BAD_REQUESTservlet.DispatcherServlet:已完成 400 BAD_REQUEST
此代码用于从 React 表单发送文件:
class UploadFiles extends Component{
state = {
file : ''
};
componentDidMount = () => {
const {file} = this.props;
this.setState({ file })
};
uploadFile = ({target : {files}}) => {
console.log(files[0]);
let data = new FormData();
data.append('file', files);
axios.post("/api/employees/save-from-csv", data)
.then(res => {console.log(res)})
};
render(){
return(
<div className="container">
<div className="row">
<div className="col-md-6">
<div className="form-group files color">
<label>Upload Your File </label>
<input type="file" onChange={this.uploadFile}/>
</div>
</div>
</div>
</div>
)
}}
服务
public void csvToEmployees(@RequestParam("file") MultipartFile file, Model model) {
// validate file
if (file.isEmpty()) {
model.addAttribute("message", "Please select a CSV file to upload.");
model.addAttribute("status", false);
} else {
try (Reader reader = new BufferedReader(new InputStreamReader(file.getInputStream()))) {
CsvToBean csvToBean = new CsvToBeanBuilder(reader)
.withType(Employee.class)
.withIgnoreLeadingWhiteSpace(true)
.build();
List users = csvToBean.parse();
employeeRepository.saveAll(users);
model.addAttribute("users", users);
model.addAttribute("status", true);
} catch (Exception ex) {
model.addAttribute("message", "An error occurred while processing the CSV file.");
model.addAttribute("status", false);
}
}
}
控制器
@PostMapping("/employees/save-from-csv")
public ResponseEntity<ResponseMessage> uploadFile(@RequestParam("file") MultipartFile file, Model model) throws IOException {
ResponseEntity<ResponseMessage> result = null;
boolean finished = false;
String message = "";
if (CSVHelper.hasCSVFormat(file)) {
try {
service.csvToEmployees(file, model);
message = "Uploaded the file successfully: " + file.getOriginalFilename();
result = ResponseEntity.status(HttpStatus.OK).body(new ResponseMessage(message));
finished = true;
} catch (Exception e) {
message = "Could not upload the file: " + file.getOriginalFilename() + "!";
message += e;
result = ResponseEntity.status(HttpStatus.UNPROCESSABLE_ENTITY).body(new ResponseMessage(message));
finished = true;
}
}
if (!CSVHelper.hasCSVFormat(file)){
message = "File is empty!";
result = ResponseEntity.status(HttpStatus.NOT_FOUND).body(new ResponseMessage(message));
}
if (!finished) {
message = "Please upload a csv file!";
result = ResponseEntity.status(HttpStatus.BAD_REQUEST).body(new ResponseMessage(message));
}
return result;
}
CSV 助手
public class CSVHelper {
public static boolean hasCSVFormat(MultipartFile file) {
String TYPE = "text/csv";
return TYPE.equals(file.getContentType());
}
public static List<Employee> csvToEmployees(InputStream is) {
try (BufferedReader fileReader = new BufferedReader(new InputStreamReader(is, "UTF-8"));
CSVParser csvParser = new CSVParser(fileReader,
CSVFormat.DEFAULT.withFirstRecordAsHeader().withIgnoreHeaderCase().withTrim());) {
List<Employee> employees = new ArrayList<>();
Iterable<CSVRecord> csvRecords = csvParser.getRecords();
for (CSVRecord csvRecord : csvRecords) {
Employee employee = new Employee(
Long.parseLong(csvRecord.get("Id")),
csvRecord.get("Name"),
Long.parseLong(csvRecord.get("DepartmentId")),
Double.parseDouble(csvRecord.get("Salary")),
csvRecord.get("City"),
csvRecord.get("Street"),
csvRecord.get("BankName"),
csvRecord.get("CardNumber")
);
employees.add(employee);
}
return employees;
} catch (IOException e) {
throw new RuntimeException("fail to parse CSV file: " + e.getMessage());
}
}
}
单元测试
@Test
public void saveEmployeesFromCSV() throws Exception {
String url = "/api/employees/save-from-csv";
String csvBuilder = "name,departmentId,salary,city,street,bankName,cardNumber\n" +
"Maxim,1,3855,Madrid,Street,Bank York,NY98675432100\n";
InputStream is = new ByteArrayInputStream(csvBuilder.getBytes());
MockMultipartFile mockFile = new MockMultipartFile("file", "employees.csv", "text/csv", is);
MockHttpServletResponse responseMessage = mvc.perform(MockMvcRequestBuilders.multipart(url)
.file(mockFile)
.param("file", "employees2.csv"))
.andReturn()
.getResponse();
assertEquals(responseMessage.getStatus(), 200);
}
解决方案
好的,这花了我一些时间,虽然这是你犯的一个很小的错误。
在您的反应代码中,您设置文件数组,就像file
在您的FormData
.
正确的做法是只将数组的一个文件设置为以下内容FormData
:
uploadFile = ({target : {files}}) => {
console.log(files[0]);
let data = new FormData();
data.append('file', files[0]); <- this here is where the error was
axios.post("/api/employees/save-from-csv", data)
.then(res => {console.log(res)})
};
推荐阅读
- javascript - 无法使用 express puppeteer 打开具有相同链接的多个选项卡
- android - 如何在不影响描边颜色的情况下从 ImageView 设置形状的填充颜色?
- java - ActiveMQ ObjectMessage 中的映射抛出 ClassCastException:无法分配 java.util.CollSer 的实例?
- sharepoint - 打开后在 mgt-person-card 中呈现其他详细信息
- android-studio - Android Studio 2020.3.1 (Canary) : Cmake 找不到与“Ninja”对应的构建程序
- jhipster - 应用初始化后如何生成代码(JHipster)?
- python - Django 类别和子类别的产品过滤器
- python - 熊猫按不同列中的相同值分组
- c - 如何使用 UIautomation 和纯 C 从浏览器中检索 URL
- javascript - 在 AWS lambda(Nodejs 运行时)中运行 git 命令