mybatis 多对多对多 字段名一致问题解决

Mybatis关联查询(一对多,多对一) - liqiangbk - 博客园 

通过起别名的方式解决

    
        
        
        
        
        
    
    
        
        

        
            
            
        
    
    
        bigcate.id as bid,
        bigcate.title as btitle,
        bigcate.sort as bsort,
        game.id as gid,
        game.title as gtitle,
        game_z.id as zid,
        game_z.title as ztitle
    
    
        select
            
        from dlq_game_bigcate bigcate
            left join dlq_game game on bigcate.id=game.bigcate_id
            left join dlq_game game_z on game.id=game_z.parent_id
    

package com.angen.springboot_test2.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;
import java.util.List;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class GameBigcate implements Serializable {
    private Integer id;
    private String title;
    private Integer sort;

    private List games;
}

package com.angen.springboot_test2.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;
import java.util.List;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Game implements Serializable {
    private Integer id;
    private Integer bigcate_id;
    private String smallcate_id;
    private Integer parent_id;
    private String title;
    private String route;
    private String alias;
    private String logo;
    private Integer temperature;
    private String seo_title;
    private String seo_keywords;
    private String seo_description;
    private String content;
    private String url;
    private Integer ads_type;
    private Integer status;
    private String search;
    private String official_url;
    private String download_url;
    private String operators;
    private String developers;
    private String theme;
    private String platform;
    private String letter;
    private Integer is_new;
    private Integer info_cate_id;
    private Integer sort;

    private List gamess;
}