Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. public Response initiateTriggerUpdate(Listing listing)
  2. {
  3. try
  4. {
  5. session=sessionFactory.openSession();
  6. tx=session.beginTransaction();
  7. SQLQuery query=session.createSQLQuery("Update ABCD set rollNo="+listing.getCl1().get(0).getRollNo()+" ,name="+listing.getCl1().get(0).getName()+" , english="+listing.getCl1().get(0).getEnglish()+" where rollNo=1"+"Update ABCD set rollNo="+listing.getCl2().get(1).getRollNo()+",name="+listing.getCl2().get(1).getName()+",english="+listing.getCl2().get(1).getEnglish()+"where rollNo=2");
  8. query.executeUpdate();
  9. response.setMessage("successful");
  10. response.setStatus("200");
  11. tx.commit();
  12. return response;
  13. }
  14. catch( Exception e){
  15. System.out.println(e.getMessage());
  16. response.setMessage("unsuccessfull");
  17. response.setStatus("500");
  18. return response;
  19. }
  20. finally
  21. {
  22. session.close();
  23. }
  24. }
  25.  
  26. }
  27. ],
  28. "cl2":
  29. [
  30. {
  31. "rollNo":4,
  32. "name":"ajay",
  33. "english":70.00
  34. }
  35. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement