后台业务层对对象集合进行去重_后台下发数据去重-CSDN博客

本文链接：https://blog.csdn.net/sublime_k/article/details/126518526

本文介绍了一种在Oracle数据库中实现分组与去重的方法，通过Java代码示例展示了如何处理一个城市对应多个机场的数据场景，并利用MyBatis进行一对多的数据处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

【版权所有，文章允许转载，但须以链接方式注明源地址，否则追究法律责任】
【创作不易，点个赞就是对我最大的支持】

前言

仅作为学习笔记，供大家参考
总结的不错的话，记得点赞收藏关注哦！

背景：一个机场对应多个飞机
因oracle数据库不能进行分组，故用此方法进行去重
也可以用mybatis一对多解决

 List<City> newcityList=new ArrayList<>();
            List<City> cityList= cityMapper.selectCityListByJc(citys);
            List<Airport> airportList = new ArrayList<>();
for (int i =0;i<cityList.size();i++) {
               if(i!=0){
                  if(cityList.get(i).getId().equals(cityList.get(i-1).getId())){
                      Airport airport=new Airport();
                      airport.setSanzm(cityList.get(i).getSanzm());
                      airport.setSizm(cityList.get(i).getSizm());
                      airport.setJcmcCh(cityList.get(i).getJcmcCh());
                      airportList.add(airport);
                      if(i==cityList.size()-1){
                          cityList.get(i-1).setAirportList(airportList);
                          newcityList.add(cityList.get(i-1));
                      }
                  }else{
                      cityList.get(i-1).setAirportList(airportList);
                      newcityList.add(cityList.get(i-1));
                      airportList = new ArrayList<>();
                      Airport airport=new Airport();
                      airport.setSanzm(cityList.get(i).getSanzm());
                      airport.setSizm(cityList.get(i).getSizm());
                      airport.setJcmcCh(cityList.get(i).getJcmcCh());
                      airportList.add(airport);
                  }
               }else{
                   Airport airport=new Airport();
                   airport.setSanzm(cityList.get(i).getSanzm());
                   airport.setSizm(cityList.get(i).getSizm());
                   airport.setJcmcCh(cityList.get(i).getJcmcCh());
                   airportList.add(airport);
               }
             }
                if(newcityList.size()>0){
                 for (City item : newcityList) {
                     //根据城市的国家id查询国家信息
                     Country country = countryMapper.selectByPrimaryKey(item.getGjid());
                     item.setGjmc(country.getGjmcCh());
                     //根据城市id查询基地
                     FlightBaseModel flightBaseModel=new FlightBaseModel();
                     flightBaseModel.setCsid(item.getId());
                     List<FlightBase> flightBasesList=flightBaseMapper.selectList(tenantId,flightBaseModel);
                     if(flightBasesList!=null){
                         item.setFlightBasesList(flightBasesList);
                     }
                 }
                 //仅查看基地
               /*  Iterator<City> it = newcityList.iterator();
                 while (it.hasNext()){
                     if(Objects.nonNull(model.getJck()) && model.getJck()){
                         if (it.next().getFlightBasesList()==null){
                            it.remove();
                         }
                     }
                 }*/

             }