一对一
假设有User类、Order类,类关系:一个User关联一个Order:
<resultMap id="userMap" type="com.cn.User">
<id property="id" column="id"/>
<result property="name" column="name"/>
<association property="order" javaType="com.cn.Order">
<result property="id" column="oid"/>
<result property="total" column="total"/>
</association>
</resultMap>
一对多
假设有User类、Order类,类关系:一个User关联多个Order:
<resultMap id="userMap" type="com.cn.User">
<id property="id" column="id"/>
<result property="name" column="name"/>
<collection property="orderList" ofType="com.cn.Order">
<result property="id" column="oid"/>
<result property="total" column="total"/>
</collection>
</resultMap>
多对多
假设有User类、Role类,类关系:多个User关联多个Role:
User对应xml配置:
<resultMap id="user" type="com.cn.User">
<id property="id" column="uid"/>
<result property="name" column="name"/>
<collection property="roleList" ofType="com.cn.Role">
<result property="id" column="rid"/>
<result property="roleName" column="role_name"/>
</collection>
</resultMap>
Role对应的xml配置:
<resultMap id="roleMap" type="com.cn.Role">
<id property="id" column="rid"/>
<result property="roleName" column="role_name"/>
<collection property="userList" ofType="com.cn.User">
<result property="id" column="uid"/>
<result property="name" column="name"/>
</collection>
</resultMap>