MyBatis类型关联多对多

DAO层

ICategoryDAO接口

package cn.happy.dao;

import cn.happy.entity.Category;

import java.util.List;

/**
 * Created by Happy on 2017-07-14.
 */
public interface ICategoryDAO {
    //01.根据pid=查找所有子分类的集合
    public List<Category> getChildrenByPid(int pid);
}

ITeacherDAO.xml小配置

<?xml version="1.0" encoding="UTF-8" ?>
<!--头文件-->
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.happy.dao.ITeacherDAO">
     <resultMap id="teacherMapper" type="Teacher">
          <id column="tid" property="tid"></id>
         <result column="tname" property="tname"/>
         <!--集合-->
         <collection property="stus" ofType="Student">
             <id column="sid" property="sid"></id>
             <result column="sname" property="sname"/>
         </collection>
     </resultMap>

    <select id="getStudentsByTeaderId" resultMap="teacherMapper">
         select student.sid,sname,teacher.tid,tname
        from student,teacher_student,teacher
        where student.sid=teacher_student.sid
         and  teacher.tid=teacher_student.tid
         and  teacher.tid=#{tid}
    </select>
</mapper>

单侧

public class MyBatisTest0716 {
@Test
    public void testSelf() {
        SqlSession session = MyBatisUtil.getSession();
        ITeacherDAO dao = session.getMapper(ITeacherDAO.class);
        Teacher teacher = dao.getStudentsByTeaderId(1);
        System.out.println(teacher.getTname());
        for (Student stu:teacher.getStus()) {
            System.out.println(stu.getSname());
        }
    }

}