| 123456789101112131415161718192021222324252627 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="">
- <query id="login.select" desc="" fetchSize="10">
- <![CDATA[
- SELECT
- USER_CD REG_ID, -- 用户代码
- USER_NM REG_NM, -- 用户姓名
- DEPT_CD, -- 部门代码
- DEPT_MNG_YN, -- 部门管理
- ROOT_AMN_YN, -- 最高管理
- ROLE_CD,
- NVL(LOCKED_YN, 'N') LOCKED_YN -- 是否锁定
- FROM TBZ01_USER
- WHERE USER_CD = ? -- 参数：用户代码
- AND USER_PW = UTL_ENCODE.BASE64_ENCODE(UTL_RAW.CAST_TO_RAW(NVL(?, '111111'))) -- 参数：用户口令
- AND NVL(ROLEUSER_TP, 'U') = 'U'
- ]]>
- </query>
- <query id="locked.select" desc="" fetchSize="10">
- <![CDATA[
- SELECT LOCKED_YN FROM TBZ01_DEPT B
- WHERE LOCKED_YN = 'Y'
- START WITH DEPT_CD = ?
- CONNECT BY PRIOR P_DEPT_CD = DEPT_CD
- ]]>
- </query>
- </queryMap>
|
