📄 userdao.properties
字号:
countUsers=\
SELECT COUNT(*) \
FROM TBL_USR \
WHERE DEL_FLG = '0' \
[ AND USR_ID = :userId ] \
[ AND USR_NAME = :userName ] \
[ AND USR_PWD = :password ] \
searchUsers=\
SELECT USR_ID userId, \
USR_NAME userName, \
USR_PWD password \
FROM TBL_USR \
WHERE DEL_FLG = '0' \
[ AND USR_ID = :userId ] \
[ AND USR_NAME = :userName ] \
[ AND USR_PWD = :password ] \
ORDER BY userId
updateUsers=\
UPDATE TBL_USR \
SET USR_NAME = :userName, \
USR_PWD = :password \
WHERE USR_ID = :userId
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -