mybatis递归查询树

所谓的树,说白了就是父子关系,就是爹与儿子的关系,只需要按照格式返回,就可以成树.

找爹的sql(pid=0表示跟节点)

    <select id="selectList1" resultMap="BaseTreeResultMap">
        select id,pid,warehouse_name as warehouseName from BASE_WAREHOUSE where pid = 0
    </select>

找儿子的sql

    <select id="getSubNode" resultMap="BaseTreeResultMap">
        select id,pid,warehouse_name as warehouseName from BASE_WAREHOUSE
        where pid = #{id}
    </select>

关系递归

<resultMap id="BaseTreeResultMap" type="org.jeecg.modules.system.model.BaseWareHouse">
        <id property="id" jdbcType="VARCHAR" column="id"/>
        <result property="warehouseName" jdbcType="VARCHAR" column="warehouseName"/>

        <result property="pid" jdbcType="VARCHAR" column="id"/>

        <result property="key" jdbcType="VARCHAR" column="id"/>
        <result property="value" jdbcType="VARCHAR" column="id"/>
        <result property="title" jdbcType="VARCHAR" column="warehouseName"/>

        <collection property="children" ofType="org.jeecg.modules.system.model.BaseWareHouse" column="id"
                    select="getSubNode"/>
    </resultMap>

效率:这种方法效率低能,不建议用,建议查询出所有数据,按照格式用程序写