cmporderquery.txt

来自「可以和任何语言搭配使用」· 文本 代码 · 共 19 行

LineItemBean.findAll() :
SELECT OBJECT(l) FROM LineItem l

OrderBean.ejbSelectAll() :
SELECT OBJECT(o) FROM Order o

VendorBean.findByOrder(java.lang.Integer orderId) :
SELECT DISTINCT l.vendorPart.vendor FROM Order o, IN(o.lineItems) AS l 
WHERE o.orderId = ?1 ORDER BY l.vendorPart.vendor.name

VendorBean.findByPartialName(String name) :
SELECT OBJECT(v) FROM Vendor v WHERE LOCATE(?1, v.name) > 0

VendorPartBean.ejbSelectAvgPrice() :
SELECT AVG(vp.price) FROM VendorPart vp

VendorPartBean.ejbSelectTotalPricePerVendor(int vendorId) :
SELECT SUM(vp.price) FROM VendorPart vp WHERE vp.vendor.vendorId = ?1