如何多次上传一个文件?

Question

这是我的代码，我在这里接受excel文件并读取它。然后我读取excel文件的行值并将它们插入到数据库中，这到适当的列。最后，我把文件放入我在电脑上确定的文件夹中。但是我在这里遇到了一个问题，当我想在api中下载具有相同名称的文件几次时，它显示我只在第一次将其上传到文件夹，但它将值打印到数据库。我对此毫无逻辑可言，你觉得我该怎么办?

@Override
public ResponseEntity<? extends Response> acceptExcelFileAndSenderName(MultipartFile filePath, String senderName) throws IOException {
String fileName = filePath.getOriginalFilename();
if (fileName.substring(fileName.length() - 5).equals(".xlsx")) {
try (InputStream excelFile = filePath.getInputStream()) {
String phoneNumber = "";
String textMessage = "";
Workbook workbook = new XSSFWorkbook(excelFile);
Sheet datatypeSheet = workbook.getSheetAt(0);
Iterator<Row> iterator = datatypeSheet.iterator();
while (iterator.hasNext()) {
Row currentRow = iterator.next();
Iterator<Cell> cellIterator = currentRow.iterator();
while (cellIterator.hasNext()) {
Cell currentCell = cellIterator.next();
if (currentCell.getCellType() == CellType.NUMERIC) {
phoneNumber = NumberToTextConverter.toText(currentCell.getNumericCellValue());
} else if (currentCell.getCellType() == CellType.STRING) {
textMessage = String.valueOf(currentCell.getStringCellValue());
}
}
FileDetail fileDetail = new FileDetail();
fileDetail.setPhoneNumber(phoneNumber);
fileDetail.setTextMessage(textMessage);
fileDetail.setSender(senderName);
this.fileDetailRepository.save(fileDetail);
}
excelFile.close();
String destination = "C:\Users\anar.memmedov\Desktop\app\" + filePath.getOriginalFilename();
File file1 = new File(destination);
filePath.transferTo(file1);
return new ResponseEntity<>(new SuccessResponse(MessageCase.FILE_SUCCESSFULLY_WRITTEN_TO_DATABASE.getMessage(), 200), HttpStatus.OK);
} catch (IOException e) {
e.printStackTrace();
}
}
return new ResponseEntity<>(new ErrorResponse(MessageCase.FAILED_HAPPEND_WHEN_FILE_WRITTEN_TO_DATABASE.getMessage(), 400), HttpStatus.BAD_REQUEST);
}

Answer 1

尝试为每个文件创建一个唯一的文件名，例如:

String destination = "C:\Users\anar.memmedov\Desktop\app\" + System.nanoTime()+"_"+filePath.getOriginalFilename();

Answer 2

我改变了一些东西并工作了，它看起来像这样

DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd-HH-mm-ss");

String destination = "C:\Users\anar.memmedov\Desktop\app\" + "_" + LocalDateTime.now().format(dateTimeFormatter) + "_" + filePath.getOriginalFilename();