避免数据库多表查询

野生_奥特曼

于 2022-09-14 16:37:34 发布

阅读量319

点赞数

文章标签： java

本文链接：https://blog.youkuaiyun.com/weixin_52081841/article/details/126855331

版权

    /**
     * 根据城市code查询GPS信息
     *
     * @param request
     * @param code
     */
    @Override
    public GResponse getExplainGPSByCode(HttpServletRequest request, String code) {
        //1
        List<Facility> facilities = facilityMapper.selectList(new LambdaQueryWrapper<Facility>().eq(Facility::getIsDel, 0).eq(Facility::getStatus,1));
        //2
        List<Long> id1 = facilities.stream().map(Facility::getLabelId).distinct().filter(data-> ObjectUtils.isNotEmpty(data)).collect(Collectors.toList());
        List<ExplainLabel> explainLabels = explainLabelMapper.selectList(new LambdaQueryWrapper<ExplainLabel>().in(ExplainLabel::getId, id1).ne(ExplainLabel::getType,1));
        //3
        List<Long> id2 = facilities.stream().map(Facility::getId).distinct().filter(data-> ObjectUtils.isNotEmpty(data)).collect(Collectors.toList());
        //4
        List<ExpainLocation>