页面代码:
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>