1、单条关联信息:
<resultMap type="orders" id="ordersResultMap">
<id column="id" property="id"/>
<result column="user_id" property="user_id"/>
<result column="number" property="number"/>
<result column="createtime" property="createtime"/>
<result column="note" property="note"/>
<association property="user" javaType="user">
<result column="username" property="username"/>
<result column="sex" property="sex"/>
</association>
</resultMap>
association:对于关联信息映射到单个pojo。
property:将关联信息映射到orders的哪个属性中。
javaType:关联信息映射到的这个属性是什么类型。
2、多条关联信息
<resultMap type="orders" id="ordersAndOrderdetailsMap">
<id column="id" property="id"/>
<result column="user_id" property="user_id"/>
<result column="number" property="number"/>
<result column="createtime" property="createtime"/>
<result column="note" property="note"/>
<collection property="orderdetails" ofType="orderdetail">
<result column="items_id" property="itemsId"/>
<result column="items_num" property="itemsNum"/>
</collection>
</resultMap>
collection:关联映射多条信息