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