java读取postman数据_postman上传excel，java后台读取excel生成到指定位置进行备份，并且把excel中的数据添加到数据库...

@Servicepublic class ExcelServiceImpl implementsExcelService {

@AutowiredprivateCorpTaxService corpTaxService;

@Overridepublic voidread(HttpServletRequest request, HttpServletResponse response, MultipartFile file) {

String fileName= "";

String filePath= "D://";if (file != null && !file.isEmpty()){

fileName=file.getOriginalFilename();

}else{throw new CECException(501, "上传的文件为空，请重新选择。");

}

BigDecimal tenThsoud= new BigDecimal(10000);

ArrayList list = new ArrayList<>();//excel文件路径//String excelPath2 = "F:\\工作簿2.xlsx";

try{

FileInputStream fis= null;if (file != null && !file.isEmpty()) { //判断文件是否存在

String[] split= file.getOriginalFilename().split("\\."); //.是特殊字符，需要转义！！！！！

Workbook wb;//根据文件后缀(xls/xlsx)进行判断

if ( "xls".equals(split[1])){//fis = new FileInputStream(excel);//文件流对象

wb = newHSSFWorkbook(file.getInputStream());

}else if ("xlsx".equals(split[1])){

wb= newXSSFWorkbook(file.getInputStream());

}else{

System.out.println("文件类型错误!");throw new CECException(501, "文件类型错误"