接上篇

页面代码：

String allChildOrgs = (String) request
   .getAttribute(Constants.ALLCHILDORGS);

 

select id="orgId" name="orgId">
        <!---->
       select>

 

ibatis文件内容：

sqlMap namespace="J_QRYSEQNUM">
 <typealias alias="userBean"></typealias>  
 《select id="queryPersonAndOrgInfo" resultMap="personAndOrgResult"
  parameterClass="personAndOrgInfo">
select
       u.uplogonname,
       u.uprealname,
       uc.ctlogonname,
       uc.ctrealname,
       up.prologonname,
       up.prorealname,
       un.cnlogonname,
       un.cnrealname,
       u.uporgname,
       uc.ctyorgname,
       up.proorgname,
       un.cntorgname,
       a.cty_audit_remark  ctyadvice,
       a.prov_audit_remark  proadvice,
       a.cnt_audit_remark  cntadvice
      
  from tb_int_file_seq a
  left join (select u.oid        upoid,
                    u.logon_name uplogonname,
                    u.realname   uprealname,
                    u.deptoid    updeptoid,
                    c.name       uporgname
               from internet_sys_user u,internet_addresslist_categoris c where c.oid=u.deptoid) u on a.up_oper_num = u.upoid
  left join (select u.oid        ctoid,
                    u.logon_name ctlogonname,
                    u.realname   ctrealname,
                    u.deptoid    ctdeptoid,
                    c.name       ctyorgname
               from internet_sys_user u,internet_addresslist_categoris c where c.oid=u.deptoid) uc on a.cty_audit_oper_num =
                                               uc.ctoid
  left join (select u.oid        prooid,
                    u.logon_name prologonname,
                    u.realname   prorealname,
                    u.deptoid    prodeptoid,
                    c.name as proorgname
               from internet_sys_user u,internet_addresslist_categoris c where c.oid=u.deptoid) up on a.prov_audit_oper_num =
                                               up.prooid
  left join (select u.oid        cnoid,
                    u.logon_name cnlogonname,
                    u.realname   cnrealname,
                    u.deptoid    cndeptoid,
                    c.name as cntorgname
               from internet_sys_user u,internet_addresslist_categoris c where c.oid=u.deptoid) un on a.cnt_audit_oper_num =
                                               un.cnoid
                                                                  
 where a.seq_num = #seq_num#
〈/select>
 〈select id="queryAllChildOrgUser" resultMap="userResult"
  parameterClass="java.lang.String">
  <!---->
  select a.oid as oid, a.logon_name as logon_name, a.realname as
  realname, a.dist_cd as dist_cd, a.deptoid as deptoid, b.name as
  name, b.org_lev as org_lev from internet_sys_user a,
  internet_addresslist_categoris b where a.enabled = 0 and
  a.user_type = 3 and a.deptoid = b.oid and a.deptoid in (select
  deptoid from (select c.deptoid as deptoid, c.parentoid as
  parentoid, c.dept_name as dept_name, c.org_lev as org_lev,
  dist_cd from (select oid as deptoid, parentoid as parentoid,
  name as dept_name, org_lev as org_lev, dist_cd from
  internet_addresslist_categoris) c connect by prior deptoid =
  parentoid start with deptoid = $String$)) order by b.org_lev,
  a.deptoid, a.dist_cd, a.logon_name
 〈/select>

 <typealias alias="userBean"></typealias>  省略 
 〈select id="queryAllChild" resultMap="userResultAllChild">
  <!---->
  select a.deptoid as deptoid, a.parentoid as parentoid,
  a.dept_name as dept_name,a.org_lev as org_lev,dist_cd from
  (select oid as deptoid, parentoid as parentoid, name as
  dept_name,org_lev as org_lev,dist_cd from
  internet_addresslist_categoris) a connect by prior deptoid =
  parentoid
  <include refid="Dy_SCStart"></include>

 〈/select>