//action的方法
public String getExcel() {
String realPath = ServletActionContext.getServletContext().getRealPath(
"/upload");
System.out.println("realpath: " + realPath);
try {
java.io.File savefile = new java.io.File(new java.io.File(realPath), exclFileName);
if (!savefile.getParentFile().exists()) {
savefile.getParentFile().mkdirs();
}
if(excl!=null){
FileUtils.copyFile(excl, savefile);
}
List<Informations> infos=Inputone.import_excel(realPath+"/"+exclFileName);//调用导入方法(前面文章提到过这个方法)
System.out.println(infos);
if(infos!=null){
for(Informations m:infos){
try {
//这里做只是我的项目要求,可自行处理入库
if(!StringUtils.isEmpty(m.getAgnlicense())){
Organization orag = new Organization();
BeanUtils.copyProperties(m, orag);
this.oragService.saveEntry(orag);
}
if(m.getPricinpal()!=null && !"".equals(m.getPricinpal())){
Branchs br = new Branchs();
BeanUtils.copyProperties(m, br);
this.branchService.saveEntry(br);
}
if(m.getTeachername()!=null && !"".equals(m.getTeachername())){
Teachers te = new Teachers();
BeanUtils.copyProperties(m, te);
this.teaService.saveEntry(te);
}
} catch (Exception e) {
continue;
}
}
}
} catch (IOException e) {
e.printStackTrace();
}
ActionContext.getContext().put("message", "文件上传成功!");
return "getExcel";
}
//struts2 配置,加上如下到struts.xml 中
<constant name="struts.multipart.saveDir" value="d:/tmp"/>
<constant name="struts.multipart.maxSize" value="10485760" />
Struts2 实现上传整合excl导入
最新推荐文章于 2019-05-24 09:51:24 发布