This is a short post on how to use MyBatis to insert an object using XML <insert> or annotation @Insert and return the value of the primary id.
The complete code on GitHub is using Spring & H2 embedded database to provide ready to run example.
- How to use <insert..> & @Insert to insert an object?
- How to get primary Id of the inserted object?
Here we will see what we need to do to connect to a relational database “MySql, Oracle, H2..etc” using myBatis with Spring framework & how to implement mappers using xml or annotation such as @Select, @Insert,….etc. For the sake of simplicity I have used H2 embedded database so you can run the sample code. However, you can use this sample code to run with MySql or any other relational database.
Source Code @ github
Note: If you have Maven you can run this sample code directly using
- How to use MyBatis with Spring framework?
- How to implement mapper using xml or annotation @Select, @Insert…?