首页 > 代码库 > Mybatis复杂嵌套关联一例

Mybatis复杂嵌套关联一例

Mybatis  three entity relation:association in collection

PatentMapper.xml

   <resultMap id="BaseResultMap" type="com.yuanchuangyun.libra.entity.Patent" >     <collection property="lawStates" resultMap="com.yuanchuangyun.libra.mapper.LawStateMapper.BaseResultMap"/>  </resultMap>
  <select id="getById" resultMap="BaseResultMap" parameterType="java.lang.String" >    select   <include refid="Base_Column_List" />,             <include refid="com.yuanchuangyun.libra.mapper.LawStateMapper.Base_Column_List"/>,             <include refid="com.yuanchuangyun.framework.mapper.system.UserMapper.Base_Column_List"/>    from BIZ_OBJECT_PATENT PET    left join BIZ_LAWSTATE LS on LS.OBJECT_ID = PET.ID AND LS.WHICH_OBJECT = ‘2‘    left join PF_USER SU on SU.ID = LS.CREATE_USER_ID  </select>

LawStateMapper.xml

  <resultMap id="BaseResultMap" type="com.yuanchuangyun.libra.entity.LawState" >    <association property="createUser" resultMap="com.yuanchuangyun.framework.mapper.system.UserMapper.BaseResultMap"/>  </resultMap>

Patent.java

    private List<LawState> lawStates;

 

LawState.java

    private User createUser;

Mybatis复杂嵌套关联一例