页面代码:
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>
分享到:
相关推荐
现在市面上有一些解压缩软件是要收费的,大家有没有想过用python做一个解压缩程序呢 接上篇
NULL 博文链接:https://killeraction.iteye.com/blog/1022141
NULL 博文链接:https://myten.iteye.com/blog/869111
NULL 博文链接:https://solodu.iteye.com/blog/466780
ESP8266模块调试-接线篇
FANUC数控系统0i-F Plus连接说明(功能篇)
Linux C函数参考 接口处理篇 欢迎参考
FANUC数控系统0i-F Plus连接说明(硬件篇)
几篇优秀的关于图像拼接的论文 几篇优秀的关于图像拼接的论文 几篇优秀的关于图像拼接的论文 几篇优秀的关于图像拼接的论文 几篇优秀的关于图像拼接的论文
音频接口接线释义篇要点PPT学习教案.pptx
5GNSA接入信令流程改进篇.pdf5GNSA接入信令流程改进篇.pdf5GNSA接入信令流程改进篇.pdf5GNSA接入信令流程改进篇.pdf5GNSA接入信令流程改进篇.pdf
信捷触摸屏连接篇手册rar,信捷触摸屏连接篇手册
三菱PLC PROFIBUS-DP接口模块用户手册(详细篇)。
21,浏览器常见事件 浏览器弹窗事件 window.alert() 提示框 window.prompt() 输入框 window.confirm() 确认框 浏览器事件 [removed] 加载事件 当页面内容完全加载完毕之后,...window.navigato
接上篇小菜的《吹弹牛皮之Unity Shader放大镜效果》发布之后,小菜一直在想同样的实现原理还能改造下做些什么事情呢?殊途同归,Game中很多酷炫效果的表达其原理都是相似的。经过小菜的几番失眠挣扎。于是乎萌生了...
文档包含了Oracle数据库的连接,以及检测是否连接成功,还包含的MySQL数据库的连接及检测,这是基于初学者的学习使用
电子-Altium常用3D封装库Step接插件篇.rar,综合电子技术PCB
9篇论文 1
主要介绍了Android 蓝牙连接 ESC/POS 热敏打印机打印实例(蓝牙连接篇),具有一定的参考价值,感兴趣的小伙伴们可以参考一下。
亲测可用,unity3d接入支付宝 android篇