usermanagedao.properties

网上购物系统

count=\
SELECT COUNT(*) \
   FROM PETUSER \
  WHERE ROLE <> '0' \
  AND DEL_FLAG <> '2' \
  [ AND USERID = :userId ] \
  [ AND NAME = :name ] \
  [ AND PID = :pid ] \
  [ AND SEX = :sex ] \
  

find=\
SELECT USERID userId, \
       PASSWORD password, \
       NAME name, \
       PID pid, \
       SEX sex, \
       EMAIL email, \
       TEL tel, \
       FAX fax, \
       ADDRESS address, \
       ZIPCODE zipCode, \
       ROLE role \
   FROM PETUSER \
   WHERE ROLE <> '0' \
   AND DEL_FLAG = '0' \
   [ AND userId = :userId ] \
   [ AND name = :name ] \
   [ AND pid = :pid ] \
   [ AND sex = :sex ] \
   ORDER BY userId

add=\
INSERT INTO PETUSER (\
   USERID, \
   PASSWORD, \
   NAME, \
   PID, \
   SEX, \
   EMAIL, \
   TEL, \
   FAX, \
   ADDRESS, \
   ZIPCODE, \
   ROLE, \
   DEL_FLAG\
   ) VALUES (\
   :userId,:password,:name,:pid, \
   :sex,:email,:tel,:fax,:address, \
   :zipCode,:role,'0')

modify=\
UPDATE PETUSER \
  SET PASSWORD = :password, \
      NAME = :name, \
      PID = :pid, \
      SEX = :sex, \
      EMAIL = :email, \
      TEL = :tel, \
      FAX = :fax, \
      ADDRESS = :address, \
      ZIPCODE = :zipCode, \
      ROLE = :role \
  WHERE USERID = :userId

delete=UPDATE PETUSER SET DEL_FLAG = '2' WHERE USERID = :userId