首页 > 代码库 > 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复杂嵌套关联一例
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。