public String uploadtable() {
/*
* if(StringUtils.isEmpty(training_id)){ addActionMessage("请选择授课计划!"); }
*/
String fileExtension = StringUtils.substringAfterLast(uploadxlsFileName, ".").toLowerCase();
if (uploadxls != null) {
String[] fileExtensionArray = { "xls" };
if (!ArrayUtils.contains(fileExtensionArray, fileExtension)) {
addActionError("只允许上传xls文件类型");
return ERROR;
}
int uploadLimit = 2 * 1024 * 1024;
if (uploadLimit != 0 && uploadxls.length() > uploadLimit) {
addActionError("文件大小超出限制");
return ERROR;
}
} else {
addActionError("你没有上传文件");
return ERROR;
}
if (StringUtils.equalsIgnoreCase("xls", fileExtension)) {
try {
HSSFSheet sheet = ExcelOpt.getSheet(uploadxls);
int i = 2;
while (true) {
HSSFRow row = sheet.getRow(i);
i++;
if (row == null)
break;
// 设备组信息---BEGIN----------------
String unitcode = ExcelOpt.getCell(row, 0);// 统一社会信用代码
if (StringUtils.isEmpty(unitcode)) {
continue;
}
String unitname = ExcelOpt.getCell(row, 1);// 单位名称
if (StringUtils.isEmpty(unitname)) {
return ajaxJsonErrorMessage("单位名称为空,在第" + i + "行");
}
String projectname = ExcelOpt.getCell(row, 2);// 项目工程名称
if (StringUtils.isEmpty(projectname)) {
return ajaxJsonErrorMessage("项目工程名称,在第" + i + "行");
}
String licesence = ExcelOpt.getCell(row, 3);// 营业执照
String orno = ExcelOpt.getCell(row, 4);// 组织机构代码
if (StringUtils.isEmpty(orno)) {
return ajaxJsonErrorMessage("组织机构代码,在第" + i + "行");
}
String liceno = ExcelOpt.getCell(row, 5);// 税务登记证号
if (StringUtils.isEmpty(liceno)) {
return ajaxJsonErrorMessage("税务登记证号,在第" + i + "行");
}
String agreeno = ExcelOpt.getCell(row, 6);// 开户许可证编号
if (StringUtils.isEmpty(agreeno)) {
return ajaxJsonErrorMessage("开户许可证编号,在第" + i + "行");
}
String card = ExcelOpt.getCell(row, 7);// 法人身份证
if (StringUtils.isEmpty(card)) {
return ajaxJsonErrorMessage("法人身份证,在第" + i + "行");
}
String number = ExcelOpt.getCell(row, 8);// 基础合同编号
if (StringUtils.isEmpty(number)) {
return ajaxJsonErrorMessage("基础合同编号,在第" + i + "行");
}
String bz = ExcelOpt.getCell(row, 9);// 备注
if (StringUtils.isEmpty(bz)) {
return ajaxJsonErrorMessage("备注,在第" + i + "行");
}
String address = ExcelOpt.getCell(row, 10);// 项目工程所在地
if (StringUtils.isEmpty(address)) {
return ajaxJsonErrorMessage("项目工程所在地,在第" + i + "行");
}
Boolean isAdd = true;
List<Sqkhxxfk> sqkhxxfkList = sqkhxxfkService.getSqkhxxfkList(unitcode, projectname);
if (sqkhxxfkList != null && sqkhxxfkList.size() > 0) {
isAdd = false;
sqkhxxfk = sqkhxxfkList.get(0);
} else {
sqkhxxfk = new Sqkhxxfk();
}
// Sqkhxxfk sk = sqkhxxfkService.get(sqkhxxfk_id);
// if (sk == null) {
// return ajaxJsonErrorMessage("开户信息为空");
// }
sqkhxxfk.setUnitCode(unitcode);
sqkhxxfk.setUnitName(unitname);
sqkhxxfk.setItemMsg(projectname);
sqkhxxfk.setBusinessLicense(licesence);
sqkhxxfk.setOrgId(orno);
sqkhxxfk.setTaxNo(liceno);
sqkhxxfk.setLicenseNo(agreeno);
sqkhxxfk.setLegalId(card);
sqkhxxfk.setCtrlNo(number);
sqkhxxfk.setDgst(bz);
sqkhxxfk.setItemAddress(address);
if (isAdd)
sqkhxxfkService.save(sqkhxxfk);
else {
sqkhxxfkService.update(sqkhxxfk);
}
}
} catch (Exception e) {
log.error(e.getMessage(), e);
redirectionUrl = "sqkhxxfk!list.action";
return ajaxJsonErrorMessage("操作失败!");
}
}
addActionMessage("操作成功!");
redirectionUrl = "sqkhxxfk!list.action";
return ajaxJsonSuccessMessage("操作成功");
}
前端
<form id="form1" name="form1" method="post" action="sfjgxy!uploadtable.action" enctype="multipart/form-data" >
<div>选择上传文件:<input id="upload" type="file" name="upload"></div>
<div style="text-align:center">
<button class="layui-btn
layui-btn-normal" >开始上传</button>
</div>
</form>