List<BlogLink> links = blogLinkMapper.findLinkList(null); if (!CollectionUtils.isEmpty(links)) { Map<Byte, List<BlogLink>> linksMap = links.stream().collect(Collectors.groupingBy(BlogLink::getLinkType)); return linksMap; }

这段代码使用了MyBatis框架进行数据库查询，查询结果返回一个BlogLink对象的List。然后通过Java 8的Stream API对这个List进行操作，使用groupingBy方法将其按照BlogLink对象的linkType属性进行分组，最终得到一个Map对象，其中key为linkType属性值，value为相应的BlogLink对象List。如果links为空，则返回一个空Map对象。

相关问题

if (!StringUtil.isEmpty(idCard)) { LambdaQueryWrapper<UserExtend>queryWrapper=new LambdaQueryWrapper<>(); queryWrapper.eq(UserExtend::getIdcard,idCard); List<UserExtend> userList = userExtendMapper.selectList(queryWrapper); if (!CollectionUtils.isEmpty(userList)) { UserExtend userExtend = userList.get(0); String userId = userExtend.getUserId(); userExtend = queryExtendByUserId(userId); List<UserBase> userBases = userBaseMapper.selectUserBaseList(userId); if (!CollectionUtils.isEmpty(userBases)) { userExtend.setUserBase(userBases.get(0)); } return userExtend; } } 如何优化这段代码

根据代码的逻辑，可以将查询语句进行优化，减少查询次数，提高查询效率。可以将以下两个查询合并成一个：

LambdaQueryWrapper<UserExtend>queryWrapper=new LambdaQueryWrapper<>();
queryWrapper.eq(UserExtend::getIdcard,idCard);
List<UserExtend> userList = userExtendMapper.selectList(queryWrapper);

优化后的代码如下：

if (!StringUtil.isEmpty(idCard)) {
    LambdaQueryWrapper<UserExtend> queryWrapper = new LambdaQueryWrapper<>();
    queryWrapper.eq(UserExtend::getIdcard, idCard);
    List<UserExtend> userList = userExtendMapper.selectList(queryWrapper);
    if (!CollectionUtils.isEmpty(userList)) {
        UserExtend userExtend = userList.get(0);
        String userId = userExtend.getUserId();
        userExtend = queryExtendByUserId(userId);
        List<UserBase> userBases = userBaseMapper.selectUserBaseList(userId);
        if (!CollectionUtils.isEmpty(userBases)) {
            userExtend.setUserBase(userBases.get(0));
        }
        return userExtend;
    }
}

另外，可以考虑使用缓存来提高查询效率，如果用户数据不经常更新，可以将查询结果缓存到内存中，下一次查询时直接从内存中获取。

List<DataPermissionSchemaEo> dataPermissionSchemaEoList = comDataComponent.getDataPermissionSchemaList(); List<SchemaRowRuleEo> schemaRowRuleList = comDataComponent.getSchemaRowRuleList(); List<SchemaColumnRuleEo> schemaColumnRuleList = comDataComponent.getSchemaColumnRuleList(); //设置行权限 根据用户id和用户组织去获取 List<SchemaRowRule> userRowRuleList = schemaRowRuleList.stream() .filter(schemaRowRuleEo -> { List<String> userList = JSONObject.parseArray(schemaRowRuleEo.getRowPermissionUserList(), String.class); List<String> orgList = JSONObject.parseArray(schemaRowRuleEo.getRowPermissionOrgList(), String.class); return userList.contains(userUid) || orgList.contains(orgCode) || userList.contains(WILDCARD) || orgList.contains(WILDCARD); }) .map(schemaRowRuleEo -> { SchemaRowRule schemaRowRule = new SchemaRowRule(); BeanUtils.copyProperties(schemaRowRuleEo, schemaRowRule); return schemaRowRule; }) .collect(Collectors.toList());List<SchemaColumnRule> userColumnRuleList = schemaColumnRuleList.stream() .filter(rule -> { List<String> userList = Optional.ofNullable(rule.getColumnPermissionUserList()) .map(userListStr -> JSONObject.parseArray(userListStr, String.class)) .orElse(Collections.emptyList()); List<String> orgList = Optional.ofNullable(rule.getColumnPermissionOrgList()) .map(orgListStr -> JSONObject.parseArray(orgListStr, String.class)) .orElse(Collections.emptyList()); return userList.contains(userUid) || orgList.contains(orgCode) || userList.contains(WILDCARD) || orgList.contains(WILDCARD); }) .map(rule -> { SchemaColumnRule columnRule = new SchemaColumnRule(); BeanUtils.copyProperties(rule, columnRule); return columnRule; }) .collect(Collectors.toList()); List<DataPermissionSchema> dataPermissionSchemaList = dataPermissionSchemaEoList.stream().map(dataPermissionSchemaEo -> { List<SchemaRowRule> schemaRowRules = userRowRuleList.stream() .filter(schemaRule -> dataPermissionSchemaEo.getDatabaseCode().equals(schemaRule.getDatabaseCode()) && dataPermissionSchemaEo.getSchemaCode().equals(schemaRule.getSchemaCode())) .collect(Collectors.toList()); List<SchemaColumnRule> schemaColumnRules = userColumnRuleList.stream() .filter(schemaRule -> dataPermissionSchemaEo.getDatabaseCode().equals(schemaRule.getDatabaseCode()) && dataPermissionSchemaEo.getSchemaCode().equals(schemaRule.getSchemaCode())) .collect(Collectors.toList()); if(!schemaRowRules.isEmpty() || !schemaColumnRules.isEmpty()) { DataPermissionSchema dataPermissionSchema = new DataPermissionSchema(); dataPermissionSchema.setDatabaseCode(dataPermissionSchemaEo.getDatabaseCode()); dataPermissionSchema.setSchemaCode(dataPermissionSchemaEo.getSchemaCode()); dataPermissionSchema.setSchemaRowRuleList(schemaRowRules); dataPermissionSchema.setSchemaColumnRuleList(schemaColumnRules); return dataPermissionSchema; } return null; }).filter(Objects::nonNull).collect(Collectors.toList());把这段代码改造成每个用户拥有的行权限和列权限

可以将该代码封装成一个方法，接收用户ID和组织代码作为参数，返回该用户拥有的行权限和列权限，代码如下：

public List<DataPermissionSchema> getUserDataPermissionSchema(String userUid, String orgCode) {
    List<DataPermissionSchemaEo> dataPermissionSchemaEoList = comDataComponent.getDataPermissionSchemaList();
    List<SchemaRowRuleEo> schemaRowRuleList = comDataComponent.getSchemaRowRuleList();
    List<SchemaColumnRuleEo> schemaColumnRuleList = comDataComponent.getSchemaColumnRuleList();

    // 获取用户行权限
    List<SchemaRowRule> userRowRuleList = schemaRowRuleList.stream()
            .filter(schemaRowRuleEo -> {
                List<String> userList = JSONObject.parseArray(schemaRowRuleEo.getRowPermissionUserList(), String.class);
                List<String> orgList = JSONObject.parseArray(schemaRowRuleEo.getRowPermissionOrgList(), String.class);
                return userList.contains(userUid) || orgList.contains(orgCode) || userList.contains(WILDCARD) || orgList.contains(WILDCARD);
            })
            .map(schemaRowRuleEo -> {
                SchemaRowRule schemaRowRule = new SchemaRowRule();
                BeanUtils.copyProperties(schemaRowRuleEo, schemaRowRule);
                return schemaRowRule;
            })
            .collect(Collectors.toList());

    // 获取用户列权限
    List<SchemaColumnRule> userColumnRuleList = schemaColumnRuleList.stream()
            .filter(rule -> {
                List<String> userList = Optional.ofNullable(rule.getColumnPermissionUserList())
                        .map(userListStr -> JSONObject.parseArray(userListStr, String.class))
                        .orElse(Collections.emptyList());
                List<String> orgList = Optional.ofNullable(rule.getColumnPermissionOrgList())
                        .map(orgListStr -> JSONObject.parseArray(orgListStr, String.class))
                        .orElse(Collections.emptyList());
                return userList.contains(userUid) || orgList.contains(orgCode) || userList.contains(WILDCARD) || orgList.contains(WILDCARD);
            })
            .map(rule -> {
                SchemaColumnRule columnRule = new SchemaColumnRule();
                BeanUtils.copyProperties(rule, columnRule);
                return columnRule;
            })
            .collect(Collectors.toList());

    // 获取用户权限所在的数据权限模板
    List<DataPermissionSchema> dataPermissionSchemaList = dataPermissionSchemaEoList.stream().map(dataPermissionSchemaEo -> {
        List<SchemaRowRule> schemaRowRules = userRowRuleList.stream()
                .filter(schemaRule -> dataPermissionSchemaEo.getDatabaseCode().equals(schemaRule.getDatabaseCode())
                        && dataPermissionSchemaEo.getSchemaCode().equals(schemaRule.getSchemaCode()))
                .collect(Collectors.toList());
        List<SchemaColumnRule> schemaColumnRules = userColumnRuleList.stream()
                .filter(schemaRule -> dataPermissionSchemaEo.getDatabaseCode().equals(schemaRule.getDatabaseCode())
                        && dataPermissionSchemaEo.getSchemaCode().equals(schemaRule.getSchemaCode()))
                .collect(Collectors.toList());
        if(!schemaRowRules.isEmpty() || !schemaColumnRules.isEmpty()) {
            DataPermissionSchema dataPermissionSchema = new DataPermissionSchema();
            dataPermissionSchema.setDatabaseCode(dataPermissionSchemaEo.getDatabaseCode());
            dataPermissionSchema.setSchemaCode(dataPermissionSchemaEo.getSchemaCode());
            dataPermissionSchema.setSchemaRowRuleList(schemaRowRules);
            dataPermissionSchema.setSchemaColumnRuleList(schemaColumnRules);
            return dataPermissionSchema;
        }
        return null;
    }).filter(Objects::nonNull).collect(Collectors.toList());

    return dataPermissionSchemaList;
}