mybits一对多 多对一映射关系

<?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="com.dao.StudentinfoDao">

    <resultMap id="c" type="Classinfo">
        <result property="cid" column="cid"></result>
        <result property="cname" column="cname"></result>
    </resultMap>


    <resultMap id="stu" type="Studentinfo">
        <result property="stuid" column="stuid"></result>
        <result property="stuName" column="stuName"></result>
        <result property="stuSex" column="stuSex"></result>
        <result property="stuAge" column="stuAge"></result>
        <result property="class_cid" column="class_cid"></result>
        <association property="classinfo" javaType="Classinfo" resultMap="c"></association>
    </resultMap>

    <resultMap id="classs" type="classinfo">
        <result property="cid" column="cid"></result>
        <result property="cname" column="cname"></result>
        <collection property="studentinfoList" ofType="studentinfo">
            <result property="stuid" column="stuid"></result>
            <result property="stuName" column="stuName"></result>
            <result property="stuSex" column="stuSex"></result>
            <result property="stuAge" column="stuAge"></result>
            <result property="class_cid" column="class_cid"></result>
        </collection>
    </resultMap>



    <select id="findAll" resultMap="stu">
        select s.*, c.cname
        from studentinfo s,
             classinfo c
        where s.class_cid = c.cid
    </select>

    <select id="findByAge" resultType="Studentinfo">
        select *
        from studentinfo
        where stuAge > #{stuAge}
    </select>

    <select id="findByCid" resultMap="classs">
        select s.*, c.cname
        from studentinfo s,
             classinfo c
        where s.class_cid = c.cid
          and c.cid = #{cid}
    </select>

</mapper>