横沥网站建设,网站seo哪家好,网站的推广,西安seo黑1. 实体类字段上加 Excel(name xxx), 表示要导入的字段 Excel(name 用户名称)private String nickName; 2. controller (post请求) /*** 导入用户数据** param file 文件* param updateSupport 是否更新支持#xff0c;如果已存在#xff0c;则进… 1. 实体类字段上加 Excel(name xxx), 表示要导入的字段 Excel(name 用户名称)private String nickName; 2. controller (post请求) /*** 导入用户数据** param file 文件* param updateSupport 是否更新支持如果已存在则进行更新数据* return 结果*/ApiOperation(导入用户数据)PostMapping(/importData)public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception{ExcelUtilSysUser util new ExcelUtilSysUser(SysUser.class);ListSysUser userList util.importExcel(file.getInputStream());String operName getUsername();String message userService.importUser(userList, updateSupport, operName);return AjaxResult.success(message);} 3. service /*** 导入用户数据* * param userList 用户数据列表* param isUpdateSupport 是否更新支持如果已存在则进行更新数据* param operName 操作用户* return 结果*/Overridepublic String importUser(ListSysUser userList, Boolean isUpdateSupport, String operName){if (StringUtils.isNull(userList) || userList.size() 0){throw new ServiceException(导入用户数据不能为空);}int successNum 0;int failureNum 0;StringBuilder successMsg new StringBuilder();StringBuilder failureMsg new StringBuilder();String password configService.selectConfigByKey(sys.user.initPassword);for (SysUser user : userList){try{// 验证是否存在这个用户SysUser u userMapper.selectUserByUserName(user.getUserName());if (StringUtils.isNull(u)){BeanValidators.validateWithException(validator, user);user.setPassword(SecurityUtils.encryptPassword(password));user.setCreateBy(operName);this.insertUser(user);successNum;successMsg.append(br/ successNum 、账号 user.getUserName() 导入成功);}else if (isUpdateSupport){BeanValidators.validateWithException(validator, user);user.setUpdateBy(operName);this.updateUser(user);successNum;successMsg.append(br/ successNum 、账号 user.getUserName() 更新成功);}else{failureNum;failureMsg.append(br/ failureNum 、账号 user.getUserName() 已存在);}}catch (Exception e){failureNum;String msg br/ failureNum 、账号 user.getUserName() 导入失败;failureMsg.append(msg e.getMessage());log.error(msg, e);}}if (failureNum 0){failureMsg.insert(0, 很抱歉导入失败共 failureNum 条数据格式不正确错误如下);throw new ServiceException(failureMsg.toString());}else{successMsg.insert(0, 恭喜您数据已全部导入成功共 successNum 条数据如下);}return successMsg.toString();}
