orderdao.properties

网上购物系统

findAllOrder=\
 SELECT ORDERID order_Id, \
        REFERDATE refer_Date, \
        USERID userId, \
        DEALDATE deal_Date \
   FROM ORDERTAB \
  ORDER BY ORDERID
 
findInfoOrder=\
	 SELECT PRODUCTID productId, \
	        PRODUCTNAME productName, \
	        PRICE price, \
	        ORDERID orderId, \
	        PRODUCTCOUNT productCount \
	   FROM ORDERINFO \
	  WHERE ORDERID = :orderId \
	  
findOrder1=\
	 SELECT ORDERID orderId, \
	        REFERDATE referDate, \
	        USERID  userId,  \
	        DEALDATE dealDate,  \
	        ORDERSTATE orderState,  \
	        ORDERNAME orderName  \
	   FROM ORDERTAB \
	  WHERE ORDERID = :orderId \
	  
countOrders=\
 SELECT COUNT(*) \
   FROM ORDERTAB \
  WHERE RFLAG = '0' \
  [ AND USERID = :userId ] \
  [ AND REFERDATE = :referDate ] \
  
searchOrders=\
 SELECT ORDERID orderId, \
        REFERDATE referDate, \
        USERID  userId,  \
        DEALDATE dealDate,  \
        ORDERSTATE orderState,  \
        ORDERNAME orderName  \
  FROM ORDERTAB \
  WHERE RFLAG = '0' \
  [ AND USERID = :userId ] \
  [ AND REFERDATE = :referDate ] \
  [ AND ORDERID = :orderId ] \
  [ AND DEALDATE = :dealDate ] \
  [ AND ORDERNAME = :orderName ] \
  ORDER BY ORDERID

updateOrders=\
  UPDATE ORDERTAB SET ORDERSTATE = :orderState  \
  WHERE  ORDERID = :orderId  \
 
updateOrder=\
  UPDATE ORDERINFO SET ORDERID = :orderId, \
        PRODUCTID = :productId, \
        PRODUCTNAME = :productName,  \
        PRICE = :price,  \
        PRODUCTCOUNT = :productCount  \
  WHERE  ORDERID = :beforeOrderId  \ 
  
saveOrders=\
INSERT INTO ORDERINFO (\
   PRODUCTID, \
   PRODUCTNAME, \
   PRICE, \
   PRODUCTCOUNT, \
   ORDERID \
   ) VALUES ( \
   :productId,:productName,:price,:productCount, \
   :orderId)
   
deleteOrders=UPDATE ORDERTAB SET RFLAG = '1' WHERE ORDERID = :orderId \