<select id="getTreeMenu" parameterClass ="map" resultClass="menu">
select * from (select * from tbl_menu where 1=1
<isEqual prepend="AND" property="menuScope" compareValue ="INFO">
coltype in ('NEWS','IMAGE','DOWN')
</isEqual>
<isEqual prepend="AND" property="state" compareValue ="Y">
state = #state#
</isEqual>
<isEqual prepend="AND" property="state" compareValue ="N">
state = #state#
</isEqual>
<isNotEmpty prepend="AND" property="siteroot">
siteroot = #siteroot#
</isNotEmpty>
) start with
<isNotEmpty prepend="" property="pid">
pid = #pid#
</isNotEmpty>
connect by prior menuid = pid
order by pid,xuhao
</select>
MySQL使用递归存储过程实现树状结构,实现Oracle的Connect By 功能大家帮帮忙!我在网上搜到的我也做了,都不对!