1对多（1个班级有多个学生）

1.

import com.java1234.model.Grade;

public interface GradeMapper {

    public Grade findById(Integer id);

}

2.<?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.java1234.mappers.GradeMapper">

    <resultMap type="Grade" id="GradeResult">

        <result property="id" column="id"/>

        <result property="gradeName" column="gradeName"/>

        <collection property="students" column="id" select="com.java1234.mappers.StudentMapper.findByGradeId"></collection>

    </resultMap>

    <select id="findById" parameterType="Integer" resultMap="GradeResult">

        select * from t_grade where id=#{id}

    </select>

</mapper>

3.import java.util.List;

import com.java1234.model.Student;

public interface StudentMapper {

    public Student findByGradeId(Integer gradeId);

} 

4.<resultMap type="Student" id="StudentResult">

        <id property="id" column="id"/>

        <result property="name" column="name"/>

        <result property="age" column="age"/>

        <association property="address" column="addressId" select="com.java1234.mappers.AddressMapper.findById"></association>

        <association property="grade" column="gradeId" select="com.java1234.mappers.GradeMapper.findById"></association>

    </resultMap>

    <select id="findStudentWithAddress" resultMap="StudentResult" parameterType="Integer">

        select * from t_student t1,t_address t2 where t1.addressId=t2.id and t1.id=#{id}

    </select>

其中多对一同一