regeistdao.properties

网上购物系统

regeist=\
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,'2','0')
   
findUserByUserId= SELECT USERID userId FROM PETUSER WHERE userId = :userId