java怎么制作放置游戏_从零开始实现放置游戏（六）：Excel批量导入

@ResponseBody

@RequestMapping(value = "/importExcel", method = RequestMethod.POST)

public Object importExcel(HttpServletRequest request) {

try {

ServletContext servletContext = request.getServletContext();

String uploadPath = servletContext.getRealPath("/upload");

File dir = new File(uploadPath);

if (!dir.exists()) {

dir.mkdir();

}

CommonsMultipartResolver multipartResolver = new CommonsMultipartResolver(servletContext);

if (multipartResolver.isMultipart(request)) {

MultipartHttpServletRequest multiRequest = (MultipartHttpServletRequest) request;

Iterator iter = multiRequest.getFileNames();

while (iter.hasNext()) {

MultipartFile file = multiRequest.getFile(iter.next());

if (file.getSize() > 0) {

String fileName = file.getOriginalFilename();

String extension = fileName.substring(fileName.lastIndexOf("."));

if (!extension.toLowerCase().equals(".xls") && !extension.toLowerCase().equals(".xlsx")) {

throw new Exception("不支持的文档格式！请上传.xls或.xlsx格式的文档！");

}

String destFileName = fileName + "_" + System.currentTimeMillis() + extension;

File destFile = new File(uploadPath, destFileName);

file.transferTo(destFile);

List dataList = this.loadExcelData(destFile.getPath());

this.saveExcelData(dataList);

if (!destFile.delete()) {

logger.warn("临时文件删除失败：" + destFile.getAbsolutePath());

}

}

}

}

return CommonResult.success();

} catch (Exception ex) {

logger.error(ex.getMessage(), ex);

return CommonResult.fail();

}

}

protected List loadExcelData(String excelPath) throws Exception {

FileInputStream fileInputStream = new FileInputStream(excelPath);

XSSFWorkbook workbook = new XSSFWorkbook(fileInputStream);

Sheet sheet = workbook.getSheet("地图");

List wowMapList = new ArrayList<>();

// 处理当前页，循环读取每一行

String createUser = this.currentUserName();

for (int rowNum = 2; rowNum <= sheet.getLastRowNum(); rowNum++) {

XSSFRow row = (XSSFRow) sheet.getRow(rowNum);

String name = PoiUtil.getCellValue(row.getCell(2));

DataDict.Occupy occupy = DataDict.Occupy.getByDesc(PoiUtil.getCellValue(row.getCell(4)));

WowMap wowMap = new WowMap();

wowMap.setName(name);

wowMap.setOccupy(occupy.getCode());

wowMap.setDescription("");

wowMap.setCreateUser(createUser);

wowMapList.add(wowMap);

}

fileInputStream.close();

return wowMapList;

}

protected void saveExcelData(List dataList) {

wowMapManager.batchInsert(dataList);

}