1.下载文件,将文件保存到本地。(只试用excel);
2.对文件的标题进行检验;
3.获取导入的批次(取一个表的一个值,加1);
4.循环获取文件某一个行,某一列的值,set到对象中;
5.检验值的合法性;
6.循环保存到对象中。
7.用map将错误的信息和正确的信息,JSONObject.fromObject(map);
public String uploadFile() throws Exception {
logger.info("开始导入规则文件:" + fileInputFileName);
InputStream is = new FileInputStream(fileInput);
String uploadPath = ServletActionContext.getServletContext()
.getRealPath("/upload");
System.out.println(uploadPath);
File targetFile = new File(uploadPath, this.getFileInputFileName());
OutputStream os = new FileOutputStream(targetFile);
byte[] buffer = new byte[1024];
int length = 0;
while ((length = is.read(buffer)) > 0) {
os.write(buffer, 0, length);
}
is.close();
os.close();
Map<String, Object> map = personalKPIMonitorManualRuleService
.importRules(targetFile);
HttpServletResponse response = ServletActionContext.getResponse();
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println(JSONObject.fromObject(map));
// if(flag==true){
// logger.info("规则文件导入成功:"+fileInputFileName);
// out.println("规则文件导入成功:"+fileInputFileName);
// }else{
// logger.info("规则文件导入失败:"+fileInputFileName);
// out.println("规则文件导入失败,详见日志:"+fileInputFileName);
// }
out.flush();
out.close();
return null;
}