我有一个大的excel文件，有32k行，还有一个javaspring代码将excel数据持久化到mysql数据库。我的代码适用于大约6k行，但由于jpa的限制，不能适用于整个excel。我读到可以用jpa分页来完成，但到目前为止，我只找到了从db收集数据（已经用数据持久化）并呈现到ui的信息。excel文件包含32k个药品，这些行将被保存到db中。
我使用以下方法创建此控制器层：

public ResponseEntity<ResponseMessage> uploadFile(@RequestParam("file") MultipartFile file,
                                                    @RequestParam(defaultValue = "0") int page,
                                                    @RequestParam(defaultValue = "6000") int size) {

        String message = "";

        if (ExcelHelper.hasExcelFormat(file)) {
            try {
// the following 6 row are my patetic attempt to resolve with pagination
               List<Medicine> medicines = new ArrayList<>();
                Pageable paging = PageRequest.of(page, size);
                Page<Medicine> pageMedicamente = medicineRepositoryDao.save(paging);

                medicines = pageMedicamente.getContent();
                medicineService.save(file);

                message = "Uploaded the file successfully: " + file.getOriginalFilename();
                return ResponseEntity.status(HttpStatus.OK).body(new ResponseMessage(message));
            } catch (Exception e) {
                message = "Could not upload the file: " + file.getOriginalFilename() + "!";
                return ResponseEntity.status(HttpStatus.EXPECTATION_FAILED).body(new ResponseMessage(message));
            }
        }

以及存储库层：

@Repository
public interface MedicineRepositoryDao extends JpaRepository<Medicine, Long> {

    Page<Medicine> save( Pageable pageable);

}

以及服务层：

try {
            List<Medicine> medicines = ExcelHelper.excelToMedicine(file.getInputStream());
            medicineRepositoryDao.saveAll(medicines);
        } catch (IOException e) {
            throw new RuntimeException("fail to store excel data: " + e.getMessage());
        }
    }