Mybatis复杂嵌套关联一例

最新推荐文章于 2025-06-05 17:17:02 发布

转载最新推荐文章于 2025-06-05 17:17:02 发布 · 440 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/rgqancy/p/6165483.html

文章标签：

#java #区块链

本文介绍了一个使用MyBatis进行多表关联查询的例子，包括Patent与LawState之间的关联，以及LawState与User之间的关联。通过XML映射文件定义了resultMap，实现了将查询结果映射到Java对象中。

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>