MyBatis-多表查询（一对多）

private StudentsNew students;
public StudentsNew getStudents() {
        return students;
}

public void setStudents(StudentsNew students) {
        this.students = students;
}

import com.tyschool.mb005.javabean.Classes;

import java.util.List;

public interface IClassesDao {
    List<Classes> findAll();
}

<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.tyschool.mb005.students.dao.IClassesDao">
    <resultMap id="classesMap" type="com.tyschool.mb005.javabean.Classes">
        <id column="cid" property="cid"></id>
        <result column="cname" property="cname"></result>
        <collection property="students" ofType="com.tyschool.mb005.javabean.StudentsNew">
            <id column="s_id" property="sid"></id>
            <result column="sname" property="sname"></result>
            <result column="ssex" property="ssex"></result>
            <result column="sage" property="sage"></result>
        </collection>
    </resultMap>
    <select id="findAll" resultMap="classesMap">
      select c.cname,s.sid as s_id,s.sname,s.ssex,s.sage from classes c left join students s  on c.cid=s.cid order by s.cid
    </select>
</mapper>

import com.tyschool.mb005.javabean.Classes;
import com.tyschool.mb005.students.dao.IClassesDao;
import com.tyschool.mb005.students.dao.IStudentsDao;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class MbClassesTest {
    private InputStream in;
    private SqlSession session;
    private IClassesDao classesDao;
    @Test
    public void findAll(){
        List<Classes> list=classesDao.findAll();
        for(Classes c:list){
            System.out.println(c+":"+c.getStudents());
        }
    }
    @Before
    public void init()throws IOException {
        in= Resources.getResourceAsStream("SqlMapConfig.xml");
        SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
        SqlSessionFactory factory=builder.build(in);
        session=factory.openSession();
        classesDao=session.getMapper(IClassesDao.class);
    }
    @After
    public void destroy() throws IOException {
        session.commit();;
        session.close();
        in.close();
    }
}