MySQL and MSSQL return primary key method
In the Personmap.xml
<id= "Addperson" parametertype= "orm. Person " keyproperty=" id " usegeneratedkeys=" true "> INSERT INTO Person (Name,age,gender) VALUES (#{name},#{age},#{gender}) </ Insert >
Call the Insert method to automatically return the auto-Grow ID returned by MyBatis to the id attribute
sqlsession session =dbutils.getsqlsession (); Person P=NewPerson ();p. SetName ("Caoyc");p. Setage (byte) -);p. Setgender ("male"); System. out. println (Session.insert ("Orm.personMapper.addPerson", p));; Session.commit (); Session.close (); System. out. println (P.getid ());
Through the Entity Object P.getid (): You can get the ID of the record after it is inserted.
Oracle data
<InsertID= "Addperson"ParameterType= "orm." Person " > <SelectkeyResulttype= "Java.long.Integer"Keyproperty= "id"Order= "Before">Select Idauto.nextval from dual</Selectkey>INSERT into person (Id,name,age,gender) VALUES (#{id},#{name},#{age},#{gender})</Insert>
Mybatis returns the database autogrow ID after inserting