Batch Insert / Update MyBatis Using Annotations

Question

Please let me know how to perform batch insert / update in mybatis using annotated maps.

Answer 1

you can do it like this :

@Insert({
            "<script>",
            "insert into mybatis_demo (name, age)",
            "values ",
            "<foreach  collection='dmoList' item='dmo' separator=','>",
            "( #{dmo.name,jdbcType=VARCHAR}, #{dmo.age,jdbcType=INTEGER})",
            "</foreach>",
            "</script>"
    })
    int insertBatch(@Param("dmoList") List<MybatisDemoDMO> dmoList);

Answer 2

make in a simple way

@Insert({"<script>", 
        "insert into  user_master (first_name,last_name) values ",
        "<foreach collection='userList' item='user' index='index' open='(' separator = '),(' close=')' >#{user.first_name},#{user.last_name}</foreach>",
        "</script>"})
    int insertUserList(@Param("userList") List<UserNew> userList);

It works perfect for me, and I inserted a massive record into my PostgreSQL database using the insert above.