MyBatis gets the self-growing field value of the inserted record

The first step:

Add the attribute "Usegeneratedkeys" and "Keyproperty" in the MyBatis mapper file, where Keyproperty is the property name of the Java Object!

[HTML]View Plain Copy

2. < insert   = &NBSP; parametertype = &NBSP;&NBSP;&NBSP;
4. usegeneratedkeys="true" keyproperty="id" >
6. INSERT INTO spares (spares_id,spares_name,
8. Spares_type_id,spares_spec)
10. values (#{id},#{name},#{typeid},#{spec})
12. </insert >

Step Two:

MyBatis automatically assigns the self-growth value to the property ID of the object spares after the INSERT statement is executed. Therefore, it can be obtained by spares the corresponding Getter Method!

[Java]View Plain Copy

2. /** 
4. * New Spare parts
6. * @author hellostory
8. * @param spares
10. * @return
12.  */  
14. @RequestMapping(value = "/insert")
16. @ResponseBody
18. Public jsonresponse Insert (Spares spares) {
20. int count = Sparesservice.insert (spares);
22. System.out.println ("Total Insert" + count + "Record!) "  
24. + "\ n the primary key self-growth value of the record just inserted is:" + Spares.getid ());

MyBatis gets the self-growing field value of the inserted record