Advertisement
Guest User

Untitled

a guest
Nov 27th, 2015
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. @Singleton
  2. @LocalBean
  3. @Startup
  4. public class Tester {
  5.  
  6. @PersistenceContext
  7. private EntityManager em;
  8.  
  9. @PostConstruct
  10. void init(){
  11.  
  12. StoredProcedureQuery query = em.createNamedStoredProcedureQuery("FindStudentByBatch");
  13. query.setParameter("BATCH_NO", 2012);
  14.  
  15. List<Student> students = query.getResultList();
  16.  
  17. System.out.println("Executing Stored Procedure Query ................");
  18. for(Student student : students){
  19. System.out.println("Student : " + student.getFname() +" "+ student.getLname());
  20. }
  21.  
  22. }
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement