Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. <form action="/hms/accommodations?searchBY" method="GET">
  2. <input type="text" name="searchKeyword"/>
  3. <input type="submit" value="Submit"/>
  4. </form>
  5.  
  6. @RequestMapping(value = "/{searchKeyword}", method = RequestMethod.GET)
  7. public List<Accommodation> listofAccomo(@PathVariable("searchKeyword") String searchKeyword){
  8. List<Accommodation> searchResult = accommodationService.findAllAccommodationBySearchBox(searchKeyword);
  9. return searchResult;
  10. }
  11.  
  12. public abstract List<Accommodation> findAllAccommodationBySearchBox(String searchKeyword);
  13.  
  14. public List<Accommodation> findAllAccommodationBySearchBox(String searchKeyword){
  15. TypedQuery<Accommodation> searchResult = em.createNamedQuery("findAllAccommodationBySearch", Accommodation.class);
  16. searchResult.setParameter("searchKeyword",'%'+searchKeyword+'%');
  17. List<Accommodation> result=searchResult.getResultList();
  18. return result;
  19. }
  20.  
  21. @NamedQueries(
  22. {
  23. @NamedQuery(
  24. name = "findAllAccommodationBySearch",
  25. query = "SELECT a FROM Accommodation a WHERE a.person.firstName LIKE :searchKeyword OR a.person.middleName LIKE :searchKeyword OR a.person.lastName LIKE :searchKeyword OR a.room.roomNumber LIKE :searchKeyword OR a.person.pvId LIKE :searchKeyword OR a.startDate LIKE :searchKeyword OR a.endDate LIKE :searchKeyword"
  26. )
  27. })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement