mybatis映射文件 一对一 and 一对多的查询

mybatis映射文件 一对一 and 一对多的查询

实体类里面的属性

private String id;
    private String name;
    private int sex;
    private int age;
    private int classNo;
    private List<Achievement> achievements;
    private Achievement achievement;

xml的配置

<resultMap id="personMap" type="springcloudentity.springcloudentity.entity.Person">
        <id column="id" property="id"></id>
        <result column="name" property="name"></result>
        <result column="sex" property="sex"></result>
        <result column="age" property="age"></result>
        <result column="classNo" property="classNo"></result>
        
        <association property="achievement" javaType="springcloudentity.springcloudentity.entity.Achievement">
            <id column="p_id" property="pId"></id>
            <result column="perId" property="perId"></result>
            <result column="subjectName" property="subjectName"></result>
            <result column="achievement" property="achievement"></result>
            <result column="workTime" property="workTime"></result>
        </association>

		<collection property="achievements" ofType="springcloudentity.springcloudentity.entity.Achievement">
            <id column="p_id" property="pId"></id>
            <result column="perId" property="perId"></result>
            <result column="subjectName" property="subjectName"></result>
            <result column="achievement" property="achievement"></result>
            <result column="workTime" property="workTime"></result>
        </collection>
    </resultMap>

一对一   association 
property="achievement" 中的 achievement 对应的是   private Achievement achievement;  中的属性名

javaType="springcloudentity.springcloudentity.entity.Achievement"指向的是属性的类型  也就是这个属性的实体类全路径

一对多   collection 
property="achievements" 中的 achievements 对应  private List<Achievement> achievements; 的属性名称

ofType="springcloudentity.springcloudentity.entity.Achievement"  指向集合里面的类型 集合里面泛型的包名全路径