mybatis关联查询为什么会出现无限循环的结果，急!!!

2016-12-05 01:48:25 822 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

MyBatis Collection小记—— 关联查询、递归查询、多字段关联经常会用到mybatis的Collection标签来做级联查询或递归查询，现通过一个伪例来简单的说明一下使用中的关键点：首先先列出三个表，给出一个场景：1，角色表t_role( id，name ) 2，菜单表t_menu( id, name, pid )菜单表是个有个pid，指向上级菜单的id，所以是个树形表3，角色菜单关联表t_role_menu( role_id, menu_i... 阅读详情

<resultMap id="BaseResultMap" type="com.jeeplus.modules.sys.entity.ldMenu" >
<id column="NODECODE" property="nodecode" jdbcType="VARCHAR" />
<result column="NODELEVEL" property="nodelevel" jdbcType="VARCHAR" />
<result column="NODENAME" property="nodename" jdbcType="VARCHAR" />
<result column="CHILDFLAG" property="childflag" jdbcType="VARCHAR" />
<result column="NODEKEY" property="nodekey" jdbcType="VARCHAR" />
<result column="RUNSCRIPT" property="runscript" jdbcType="VARCHAR" />
<result column="NODEDESCRIPTION" property="nodedescription" jdbcType="VARCHAR" />
<result column="NODESIGN" property="nodesign" jdbcType="VARCHAR" />
<result column="NODEORDER" property="nodeorder" jdbcType="DECIMAL" />
<result column="STATUS" property="status" jdbcType="VARCHAR" />
<result column="OPERATOR" property="operator" jdbcType="VARCHAR" />
<result column="MAKEDATE" property="makedate" jdbcType="DATE" />
<result column="MAKETIME" property="maketime" jdbcType="VARCHAR" />
<result column="MODIFYDATE" property="modifydate" jdbcType="DATE" />
<result column="MODIFYTIME" property="modifytime" jdbcType="VARCHAR" />
<result column="IS_SHOW" property="isShow" jdbcType="CHAR"/>
<result column="PERMISSION" property="permission" jdbcType="VARCHAR"/>


<association property="parent" column="PARENTNODECODE" select="getParent" />


<collection property="children" column="NODECODE" select="getChildren" />
</resultMap>
<sql id="Base_Column_List" >
a.NODECODE, a.PARENTNODECODE AS "parent.nodecode", a.NODELEVEL, a.NODENAME, a.CHILDFLAG, a.NODEKEY, a.RUNSCRIPT, a.NODEDESCRIPTION,
a.NODESIGN, a.NODEORDER, a.STATUS, a.OPERATOR, a.MAKEDATE, a.MAKETIME, a.MODIFYDATE, a.MODIFYTIME,p.name AS "parent.name"
</sql>

<sql id="menuJoins">
LEFT JOIN TBL_LDMENU p ON p.nodecode = a.PARENTNODECODE
</sql>


<select id="getChildren" parameterType="String" resultMap="BaseResultMap">
select * from TBL_LDMENU where PARENTNODECODE = #{nodecode} order by nodeorder
</select>

<select id="getParent" parameterType="String" resultMap="BaseResultMap">
select * from TBL_LDMENU where nodecode = #{nodecode}
</select>

...全文