petdao.properties

网上购物系统

countPets=\
 SELECT COUNT(*) \
   FROM TBL_PET \
  WHERE DEL_FLG = '0' \
  [ AND PET_NAME = :petName ] \
  [ AND PET_PRICE >= :minPrice ] \
  [ AND PET_PRICE <= :maxPrice ] \

searchPets=\
 SELECT PET_ID petID, \
        PET_NAME petName, \
        PET_PRICE petPrice, \
        PET_COUNT petCount, \
        PET_INFO petInfo \
   FROM TBL_PET \
  WHERE DEL_FLG = '0' \
  [ AND PET_NAME = :petName ] \
  [ AND PET_PRICE >= :minPrice ] \
  [ AND PET_PRICE <= :maxPrice ] \
  ORDER BY petId
  
updatePets=\
 UPDATE TBL_PET \
    SET PET_NAME = :petName, \
        PET_PRICE = :petPrice, \
        PET_COUNT = :petCount, \
        PET_INFO = :petInfo \
  WHERE PET_ID = :petID