Mybatis中实体类映射时用collection进行分表查询和对象属性映射

我们在用Mybatis开发时会遇到类似于对象内包含对象属性的情况，我们编辑班级时需要将本班教师封装为List一并返回，诸如类似情况我们可以使用collection进行分表操作

现有表如下:

//Class.java
package com.demo.domain;

import java.util.List;

public class Class {
    private Long id;
    private String className;
    private List teacherList;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getClassName() {
        return className;
    }

    public void setClassName(String className) {
        this.className = className;
    }

    public List getTeacherList() {
        return teacherList;
    }

    public void setTeacherList(List teacherList) {
        this.teacherList = teacherList;
    }
}

//Teacher.java
package com.demo.domain;

public class Teacher {
    private Long id;
    private String name;
    private String sex;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }
}

//ClassService.java
package com.demo.service;

import java.util.List;
import com.demo.domain.Class;
public interface ClassService {
    List listAll();
}

//ClassServiceImp.java
package com.demo.service.imp;

import com.demo.domain.Class;
import com.demo.mapper.ClassMapper;
import com.demo.service.ClassService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class ClassServiceImp implements ClassService {
    @Autowired
    private ClassMapper classMapper;
    @Override
    public List listAll() {
        return classMapper.listAll();
    }
}

//ClassMapper.java
package com.demo.mapper;

import com.demo.domain.Class;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface ClassMapper {
    List listAll();
}

  ClassMapper.xml 

    
        
        
        
        
    
    
        select *
        from class;
    
    
        select t.*
        from teacher t,
             ref_class_teacher r
        where t.id = r.class_id
          and t.id = #{id};
    

[
    {
        "id": 1,
        "className": "一班",
        "teacherList": [
            {
                "id": 1,
                "name": "赵老师",
                "sex": "男"
            },
            {
                "id": 1,
                "name": "赵老师",
                "sex": "男"
            },
            {
                "id": 1,
                "name": "赵老师",
                "sex": "男"
            }
        ]
    },
    {
        "id": 2,
        "className": "二班",
        "teacherList": [
            {
                "id": 2,
                "name": "钱老师",
                "sex": "女"
            },
            {
                "id": 2,
                "name": "钱老师",
                "sex": "女"
            }
        ]
    },
    {
        "id": 3,
        "className": "三班",
        "teacherList": [
            {
                "id": 3,
                "name": "孙老师",
                "sex": "男"
            },
            {
                "id": 3,
                "name": "孙老师",
                "sex": "男"
            },
            {
                "id": 3,
                "name": "孙老师",
                "sex": "男"
            }
        ]
    }
]