cmporderquery.txt

《j2ee经典实例详解》的源代码。原书无附带光盘。介绍的是一个在线银行系统的例子。绝对难得

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