java - Dynamic Hibernate Query -

i have method use return dynamic query. method shown below

 public query getlastid(string sprovider) {        string serviceprovider = sprovider.tolowercase();             string query2 = "select max(:serviceprovider.id) " +                     " :sprovider :serviceprovider ";         return em.createquery(query2)               .setparameter("sprovider", sprovider)               .setparameter("serviceprovider", serviceprovider);  } 

i want method return this

select max(multichoice.id) multichoice multichoice

when call method this

getlastid("multichoice");

please how write query variable return answer?

to task can use criteria object model , projections run query on different types: take @ article (15.7. projections, aggregation , grouping)

here code :

list results = session.createcriteria(class) .setprojection( projections.max("id")) .list(); 

then instead of string should send class method.