并在界面显示"/>
(Java)导入excel表格数据到数据库并在界面显示
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>
更多推荐
(Java)导入excel表格数据到数据库并在界面显示
发布评论