Advertisement
panaewboi

servlet max

Nov 5th, 2020 (edited)
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. throws ServletException, IOException {
  2. String searchParam = request.getParameter("searchParam");
  3. if (searchParam == null || searchParam.trim().length()==0) {
  4. request.setAttribute("message","Please enter part of product name" );
  5. request.getRequestDispatcher("/shop.jsp").forward(request, response);
  6. }
  7. EntityManagerFactory emf = Persistence.createEntityManagerFactory("sit.int303.SCproject_SCproject_war_1.0-SNAPSHOTPU");
  8. EntityManager em = emf.createEntityManager();
  9. String sql = "SELECT p FROM Product p WHERE p.productname like :pn";
  10. Query qry = em.createQuery(sql);
  11.  
  12. qry.setParameter("pn", "%"+ searchParam+ "%");
  13. List<Product> pd = qry.getResultList();
  14. request.setAttribute("allproduct",pd);
  15. request.getRequestDispatcher("/shop.jsp").forward(request, response);
  16. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement