logindao.properties

网上购物系统

findByPrimaryKey=\
 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 userId = :userId \
   AND DEL_FLAG = '0' \
   ORDER BY USERID