| 1234567891011121314151617 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="">
- <query id="password.select" desc="" fetchSize="10">
- <![CDATA[
- SELECT USER_CD FROM TBZ01_USER
- WHERE USER_CD = ? -- 参数：用户代码
- AND USER_PW = UTL_ENCODE.BASE64_ENCODE(UTL_RAW.CAST_TO_RAW(NVL(?, '111111'))) -- 参数：用户原口令
- ]]>
- </query>
- <query id="password.update" desc="" fetchSize="10">
- <![CDATA[
- UPDATE TBZ01_USER SET
- USER_PW = UTL_ENCODE.BASE64_ENCODE(UTL_RAW.CAST_TO_RAW(NVL(?, '111111'))) -- 参数：用户新口令
- WHERE USER_CD = ? -- 参数：用户代码
- ]]>
- </query>
- </queryMap>
|
