java - Implement a method that generates the last insert id -


i'm using jpql , want implement simple methode generate last insert id table test.

    public integer lastinsertid(){     string jpql="select t test t id=:last_insert_id()";     query query=entitymanager.createquery(jpql);     return ; } 

if want last id, given id's generated sequentially, this:

em.createquery("select max(t.id) test t", integer.class).getsingleresult(); 

Comments

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -