81,122
社区成员




public void importBuildInfoExcel(@RequestParam(value = "uploadFile", required = false) MultipartFile file, HttpServletRequest request,HttpServletResponse response) throws IOException {
response.setContentType("text/xml;charset=utf-8");
List<Map<String, Object>> mapList=new ArrayList<Map<String, Object>>();
Map<String, Object> model = new HashMap<String, Object>();
List<BaseArena> modelList =new ArrayList<BaseArena>();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
try {
mapList=excelUtils.transFile2MapList(file);
for(int a =0; a < mapList.size(); a++){
BaseArena baseArena=new BaseArena();
baseArena=(BaseArena) excelUtils.transMap2Bean(mapList.get(a), baseArena);
String lastEditTime=formatter.format(new Date());//变更时间
baseArena.setLastEditTime(lastEditTime);
// baseArenaDAO.saveOrUpdate(baseArena);
modelList.add(baseArena);
}
baseArenaDAO.saveUpdate(modelList);
model.put( "status", "success");
model.put("message", "导入成功!");
} catch (Exception e) {
logger.error(e.getLocalizedMessage(), e);
model.put( "message", e.getLocalizedMessage());
model.put("status", "导入失败!");
e.printStackTrace();
}
JSONObject returnData = null;
returnData = JSONObject.fromObject(model);//转JSON
response.getWriter().print(returnData );//打印
}