Mybatis一对多的问题使用collection以及select

• • 业务场景：用户关联教育中间表，用户会有多条教育经历，教育中间表再关联学校院系的信息，要求获取用户的教育信息
  • 实体类
  • • 用户实体类
    • 教育中间表实体类
    • 工作信息实体类
  • 对应的xml
  • • 教育信息中间表xml
    • 工作信息的xml
    • 用户的xml实现（重点）

public class RegAlumniuser implements Serializable {
    
    @Id
    @Column(name = "reg_alumniuserid")
    private Integer regAlumniuserid;
    //关联教育信息表
    @Transient
    private List regEducationinfos;

    
    @Transient
    public List regWorkinfos;


    
    @Transient
    public List honors;

}

package mobile.bean;

import lombok.Getter;
import lombok.Setter;

import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Transient;
import java.io.Serializable;

@Table(name = "reg_educationinfo")
@Getter
@Setter
public class RegEducationinfo implements Serializable {
    
    @Id
    @Column(name = "reg_edu_info_id")
    private Integer regEduInfoId;

    
    @Column(name = "reg_alumniuserid")
    private Integer regAlumniuserid;

    
    @Transient
    public School school;

    
    @Transient
    public Department department;

    
    @Transient
    public Major major;

    
    @Transient
    public Grade grade;

 
    
    @Transient
    public String[] SchoolList;

    
    @Transient
    public String[] CollegeList;

    
    @Transient
    public String[] MajorList;

    
    @Transient
    public String[] GradesList;
}

package mobile.bean;

import lombok.Getter;
import lombok.Setter;

import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
import java.util.Date;

@Table(name = "reg_workinfo")
@Setter
@Getter
public class RegWorkinfo implements Serializable {
    
    @Id
    @Column(name = "reg_work_info_id")
    private Integer regWorkInfoId;

    
    @Column(name = "reg_alumniuserid")
    private Integer regAlumniuserid;
}

  
    
    
   
    
    
    
    
  



  
  
    
  

  
  
    
  

  
  
   省略
  

  
  
     省略
  

  
    select edu.*,sch.sch_name,dept.dept_name,m.major_name,g.grade_name from reg_educationinfo edu
      LEFT JOIN school sch ON edu.sch_id=sch.sch_id
      LEFT JOIN department dept ON edu.dept_id=dept.dept_id
      LEFT JOIN major m ON edu.major_id=m.major_id
      LEFT JOIN grade g ON edu.grade_id=g.grade_id
    where edu.reg_alumniuserid = #{regAlumniuserid}
  

  
    
    
  


  
    select * from reg_workinfo
    where reg_alumniuserid = #{regAlumniuserid}
  

 
用户的xml实现（重点） 

    
        
        
       
        
        
    
    
    
        
      
    
    
    
        
       
    
    //根据用户id获取用户的信息
        
        select *
        from reg_alumniuser reg
        where  reg.reg_alumniuserid=#{regAlumniuserId}