mybatis 基础

collocation ：多对一   association ：一对多

类似于一个班级对应多个学生 ，多个学生对应一个班级

public class Student implements Serializable {
	private Integer id;
	private String name;
	private String sex;
	private Integer age;
        //学生与班级是多对一的关系
	private Clazz clazz;
}

public class Clazz implements Serializable{
	private Integer id;
	private String code;
	private String name;
        //班级与学生是一对多的关系
	private List<Student> students;
}

<select id="selectClazzById" parameterType="int" resultMap="clazzResultMap">
		select * from tb_clazz where id = #{id}
	</select>
	<resultMap type="com.glj.pojo.Clazz" id="clazzResultMap">
		<id property="id" column="id"/>
		<result property="code" column="code"/>
		<result property="name" column="name"/>
		<!-- property: 指的是集合属性的值, ofType：指的是集合中元素的类型  -->
		<collection property="students" ofType="com.glj.pojo.Student"
		column="id" javaType="ArrayList"
		fetchType="lazy" select="com.glj.mapper.StudentMapper.selectStudentByClazzId">
			<id property="id" column="id"/>
			<result property="name" column="name"/>
			<result property="sex" column="sex"/>
			<result property="age" column="age"/>
		</collection>
	</resultMap>

<select id="selectStudentById" parameterType="int" resultMap="studentResultMap">
		select * from tb_clazz c,tb_student s where c.id = s.id and s.id = #{id}
	</select>
	<select id="selectStudentByClazzId" parameterType="int" resultMap="studentResultMap">
		select * from tb_student where clazz_id = #{id}
	</select>
	<resultMap type="com.glj.pojo.Student" id="studentResultMap">
		<id property="id" column="id"/>
		<result property="name" column="name"/>
		<result property="sex" column="sex"/>
		<result property="age" column="age"/>
		<association property="clazz" javaType="com.glj.pojo.Clazz">
			<id property="id" column="id"/>
			<result property="code" column="code"/>
			<result property="name" column="name"/>
		</association>
	</resultMap>