<resultMap id="heroMap" type="Hero"> <id property="heroId" column="hero_id"/> <result property="heroName" column="hero_name"/> <result property="sLanguage" column="spoken_language"/> <association property="role" javaType="Role"> <id property="roleId" column="role_id"/> <result property="roleName" column="role_name"/> </association> </resultMap>
<resultMap id="categoryMap" type="Category"> <id property="categoryId" column="category_id"/> <result property="categoryName" column="category_name"/> <result property="num" column="num"/> <collection property="child" javaType="java.util.List" ofType="Category"> <id property="categoryId" column="cid" /> <result property="categoryName" column="cname"/> <result property="num" column="num"/> </collection> </resultMap>
association是在一对一的时候用的,collection是在一对多的时候用的
其中的id使用情况是对应的字段在表中是主键