petinfodao.properties

网上购物系统

findAll=\
 SELECT PET_NO petId, \
        PET_NAME pName, \
        DESCRIPT descript, \
        PRICE price \
   FROM PETINFO \
  ORDER BY petId

findByPrimaryKey=\
 SELECT PET_NAME petName, \
        DESCRIPT descript, \
        PRICE price \
   FROM PETINFO \
  WHERE PET_NO = :petNo
 
searchUsers=\
 SELECT PETID petId, \
        PNAME pname, \
        SPECIES species, \
        PNUMBER pnumber, \
        PRICE price, \
        PROAREA proarea \
   FROM PETINFO \
  ORDER BY petId
  
searchPets=\
 SELECT PETID pet_Id, \
        PNAME pname, \
        SPECIES species, \
        PNUMBER pnumber, \
        PRICE price, \
        PROAREA proarea \
   FROM PETINFO \
  WHERE \
  PETID=PETID \
  [ AND SPECIES = :species ] \
  [ AND PRICE >= :minPrice ] \
  [ AND PRICE <= :maxPrice ]