|
1
7 package jfox.test.ejb3.entity;
8
9 import java.util.List  ;
10 import javax.ejb.Stateless ;
11 import javax.persistence.EntityManager;
12 import javax.persistence.NamedNativeQueries;
13 import javax.persistence.NamedNativeQuery;
14 import javax.persistence.PersistenceContext;
15
16 import org.jfox.entity.dao.DAOSupport;
17
18
21 @NamedNativeQueries(
22 {
23 @NamedNativeQuery(
24 name = OrderDAOImpl.GET_LINEITEM_BY_ID,
25 query = "select * from lineitem where id=$id",
26 resultClass = LineItem.class
27 ),
28 @NamedNativeQuery(
29 name = OrderDAOImpl.GET_LINEITEMS_BY_ORDER_ID,
30 query = "select * from lineitem where orderid=$orderid",
31 resultClass = LineItem.class
32 ),
33 @NamedNativeQuery(
34 name = OrderDAOImpl.GET_ORDER_BY_ID,
35 query = "select * from orders where id=$id",
36 resultClass = Order.class
37 ),
38 @NamedNativeQuery(
39 name = OrderDAOImpl.GET_ORDERS,
40 query = "select * from orders",
41 resultClass = Order.class
42 )
43 })
44 @Stateless (name="entity.OrderDAO")
45 public class OrderDAOImpl extends DAOSupport implements OrderDAO {
46
47 public static final String GET_LINEITEM_BY_ID = "GET_LINEITEM_BY_ID";
48 public static final String GET_LINEITEMS_BY_ORDER_ID = "GET_LINEITEMs_BY_ORDER_ID";
49 public static final String GET_ORDER_BY_ID = "GET_ORDER_BY_ID";
50 public static final String GET_ORDERS = "GET_ORDERS";
51
52 @PersistenceContext(unitName = "default")
53 EntityManager em;
54
55 protected EntityManager getEntityManager() {
56 return em;
57 }
58
59 public List <Order> getOrders(){
60 return (List <Order>)createNamedNativeQuery(GET_ORDERS).getResultList();
61 }
62
63 public Order getOrder(int id) {
64 return (Order)createNamedNativeQuery(GET_ORDER_BY_ID).setParameter("id",id).getSingleResult();
65 }
66
67 }
68 |
Popular Tags |
Java API By Example, From Geeks To Geeks.