java 合并sql查询出来的数据

mybatis.xml配置：

SELECT
   
   c.fruitid AS fruitId,
   c.`name`,
   c.price,
   c.locality,
   o.contractid
FROM
   
   commodities c,
   middle_tab m,
   contract o
WHERe
   c.fruitid = m.fruitid and o.contractid = m.contractid
    

    
        select r.retailerId,r.name,c.barcode,c.contractid from contract c ,retailer r where c.retailerid = r.retailerid
    

controller代码：

@Controller
public class SelectController extends BaseController {
    @Autowired
    SelectService selectService;
    @RequestMapping("/select/select.action")
    public String select(Model model,String name){
        List commoditiesList = selectService.find(name);
        List retailerList = selectService.finduser(name);
        Map map = new HashMap<>();
        for (CommoditiesRetailerVo cvo:commoditiesList){
           for (RetailerVo rvo:retailerList){
               if (cvo.getContractId().equals(rvo.getContractId())) {
                   map.put(cvo,rvo);
               }
           }
       }
       model.addAttribute("map",map);
        System.out.println(map);
        System.out.println("CommoditiesList:"+ commoditiesList);
        System.out.println("commoditiesList="+commoditiesList.size());
        return "/select/select";
    }
}

Dao：

public List find(@Param("name") String name);
public List finduser(@Param("name") String name);

Service：

public List find(String name);
public List finduser(String  name);