Mybatis注解实现一对多关联查询

bean

package com.bean;

public class Depment {
    public  int did;
    public String dname;

    public int getDid() {
        return did;
    }

    public void setDid(int did) {
        this.did = did;
    }

    public String getDname() {
        return dname;
    }

    public void setDname(String dname) {
        this.dname = dname;
    }
}

package com.bean;

public class Student {
    public int sid;
    public String sname;
    public Depment depment;

    public int getSid() {
        return sid;
    }

    public void setSid(int sid) {
        this.sid = sid;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public Depment getDepment() {
        return depment;
    }

    public void setDepment(Depment depment) {
        this.depment = depment;
    }
}

dao

package com.dao;

import com.bean.Student;
import org.apache.ibatis.annotations.*;
import org.apache.ibatis.mapping.FetchType;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
@Mapper
@Component (value ="studentdao")
public interface Studentdao{
    //查找所有学生
    @Select("select * " +
            "from student a,depment b " +
            "where a.did =b.did")
    @Results ({
            @Result(id=true,column="sid",property="sid"),
            @Result(column="sname",property="sname"),
            @Result(column="did",property="depment",one=@One(select="com.dao.Depmentdao.querydepmentbydid",fetchType= FetchType.EAGER))
    })
    public List<Student> queryallstudnet();
    //根据学号查找学生
    @Select("select * " +
            "from student a,depment b " +
            "where sid =#{sid} and a.did =b.did")
    public Student querystudnetbysid(Student student);
    //删除学生根据学生学号
    @Delete("delect * from student where sid =#{sid}")
    public void delectstudnetbysid(Student student);
    //增加学生
    @Insert("insert INTO student(sname,did) VALUES(#{sname},#{did})")
    public void addstudent(Student student);
}

package com.dao;

import com.bean.Depment;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
@Component(value = "depmentdao")
public interface Depmentdao {
    //根据编号查找学院
    @Select("select * from depment")
    public Depment querydepmentbydid(int did);

}