mybatis中调用函数方法mybatis中查找表中有父子关联 的信息

mybatis中调用函数方法
<select id="generatorOrder" parameterMap="getParam" statementType="CALLABLE" resultType="java.lang.String">
   <![CDATA[  CALL generatorOrder(?,?,?,?,?,?,?,?,?,?,?,?,?,?)]]> 
</select>
<parameterMap type="java.util.Map" id="getParam">  
    <parameter property="balance" mode="IN" jdbcType="FLOAT"/>  
    <parameter property="walletId" mode="IN" jdbcType="INTEGER"/>
    <parameter property="price" mode="IN" jdbcType="FLOAT"/>    
    <parameter property="num" mode="IN" jdbcType="INTEGER"/>    
     <parameter property="uid" mode="IN" jdbcType="INTEGER"/> 
     <parameter property="cagentName" mode="IN" jdbcType="VARCHAR"/>
     <parameter property="pluId" mode="IN" jdbcType="INTEGER"/>
     <parameter property="deliverAddress" mode="IN" jdbcType="VARCHAR"/>  
     <parameter property="deliverPhone" mode="IN" jdbcType="VARCHAR"/>  
     <parameter property="deliverName" mode="IN" jdbcType="VARCHAR"/> 
     <parameter property="type" mode="IN" jdbcType="INTEGER"/>  
     <parameter property="wtype" mode="IN" jdbcType="INTEGER"/>  
     <parameter property="deliverRmk" mode="IN" jdbcType="VARCHAR"/>  
        <parameter property="_err" mode="OUT" jdbcType="VARCHAR"/> 
   </parameterMap>

mybatis中查找表中有父子关联 的信息

<select id="selectTypeByCagentName" parameterType="java.lang.String" resultType="java.util.Map">
   select tpc.id,tpc.pid,tpc.catename from t_plu_cate tpc
   INNER  JOIN (select id from t_plu_cate where pid=0) parent
   ON (tpc.pid=parent.id OR tpc.id=parent.id)
   WHERE cid=(select id from t_cagent where cagent=#{cagentName})
   order by tpc.id
</select>