Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Response initiateTriggerUpdate(Listing listing)
- {
- try
- {
- session=sessionFactory.openSession();
- tx=session.beginTransaction();
- 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");
- query.executeUpdate();
- response.setMessage("successful");
- response.setStatus("200");
- tx.commit();
- return response;
- }
- catch( Exception e){
- System.out.println(e.getMessage());
- response.setMessage("unsuccessfull");
- response.setStatus("500");
- return response;
- }
- finally
- {
- session.close();
- }
- }
- }
- ],
- "cl2":
- [
- {
- "rollNo":4,
- "name":"ajay",
- "english":70.00
- }
- ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement