Mybatis嵌套查询映射Java bean的集合属性

        
        
        
        
        
        
        
        
        
        
        
        
        
            
            
            
            
            
            
            
            
            
            
        
    


        select
            p.id,
            p.device_num,
            p.serial_num,
            p.region_code,
            p.project_name,
            p.mac0,
            p.mac1,
            p.used,
            p.type,
            p.create_time,
            p.update_time,
            r.region_name,
            d.id as did,
            d.project_id,
            d.ip,
            d.project_name as d_project_name,
            d.used as d_used,
            d.mac,
            d.device_type,
            d.region_code as d_region_code,
            d.create_time as d_create_time,
            d.update_time as d_update_time
        FROM dam_project_info p
        left join dam_device_info d on p.id = d.project_id
        left join t_sys_region r on p.region_code = r.region_code
 

注意resultmap的column和collection的column名称不能重复，否则会忽略collection的查询结果而是用父结果集的重名字段