java - How to retrieve and insert data into database using a single url mapping -


i using spring rest , hibernate , want retrieve , update data database on single url mapping. retrieving column data , after sum data want update data table unable update.

here dao class

    public list<post> getpostlist() throws exception { session = sessionfactory.opensession();     criteria cr = session.createcriteria(post.class);     projectionlist projlist = projections.projectionlist();     projlist.add(projections.sum("val"));     projlist.add(projections.groupproperty("userid"));     cr.setprojection(projlist);     list postlist = cr.list();     tx = session.gettransaction();     session.begintransaction();     tx.commit();     return postlist; } 

here entity class post.java

@entity @table(name="post") @jsonignoreproperties({"hibernatelazyinitializer", "handler"}) public class post implements serializable {  private static final long serialversionuid = 1l;  @id @generatedvalue @column(name="id") private long id;  @column(name="uid") private long userid;  @column(name="value") private long val;  public long getid() {     return id; }  public void setid(long id) {     this.id = id; }  public long getuserid() {     return userid; }  public void setuserid(long userid) {     this.userid = userid; }  public long getval() {     return val; }  public void setval(long val) {     this.val = val; }  } 

here rest controller

    @requestmapping(value = "/posts", method = requestmethod.get) public @responsebody list<post> getemployee() {      list<post> postlist = null;     try {         postlist = profileservice.getpostlist();      } catch (exception e) {         e.printstacktrace();     }      return postlist; } 

i want retrieve , update data using single url..please suggest me


Comments