Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. public IBOOKProviderManager getBookProviderrManager() {
  2. return bookProviderManager;
  3. }
  4.  
  5. public long getCoursesAddedByTP(Integer bookProviderId){
  6. return courseManager.getCoursesAddedByTP(bookProviderId);
  7. }
  8.  
  9. public long getCoursesAddedByTP(Integer bookProviderId){
  10.  
  11. Query query = this.em.createQuery(
  12.  
  13. " SELECT COUNT(*) AS total FROM Courses c WHERE c.book_provider_id = " +bookProviderId);
  14.  
  15. long coursesByTP = 0;
  16.  
  17. try {
  18. coursesByTP = (Long) query.getSingleResult();
  19. } catch (Exception e) {
  20. e.getStackTrace();
  21. }
  22.  
  23. return coursesByTP;
  24. }
  25.  
  26. public long getCoursesAddedByTP(Integer bookProviderId){
  27. Query query = this.em.createQuery(
  28. "SELECT c FROM Courses c WHERE c.book_provider_id = :tpID");
  29. query.setParameter("tpID", bookProviderId);
  30. long coursesByTP = 0;
  31. try {
  32. coursesByTP = query.getResultList().size(); // getResultList() and not getSingleResult()
  33. } catch (Exception e) {
  34. e.getStackTrace();
  35. }
  36. return coursesByTP;
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement