MyBatis 如何批量插入？

爱被打了一巴掌 2022-12-13 11:29 107阅读 0赞

**方式一、打开批量插入的 SqlSession**

SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    for (int i = 36; i <= 45; i++) {
        userMapper.insertUser(new User(i, "ConstXiong" + i));
    }
    sqlSession.commit();
    sqlSession.close();

**方式二、拼接批量插入的 insert SQL**

//Java 代码
    List< User> userList = new ArrayList< >();
    for (int i = 46; i <= 55; i++) {
        userList.add(new User(i,"ConstXiong" + i));
    }
    userMapper.insertUserBatch(userList);
    
    
    < insert id="insertUserBatch" parameterType="java.util.List">
        insert into user values
        < foreach collection="list" item="item" separator =",">
            (#{item.id}, #{item.name})
        < /foreach>
    < /insert>

完整 Demo：

[https://javanav.com/val/2d21b1463f2e4faeaf0def0c49df34a4.html][https_javanav.com_val_2d21b1463f2e4faeaf0def0c49df34a4.html]

--------------------

### 【Java面试题与答案】整理推荐 ###

*  [基础与语法][Link 1]
 *  [集合][Link 2]
 *  [网络编程][Link 3]
 *  [并发编程][Link 4]
 *  [Web][]
 *  [安全][Link 5]
 *  [设计模式][Link 6]
 *  [框架][Link 7]
 *  [算法与数据结构][Link 8]
 *  [异常][Link 9]
 *  [文件解析与生成][Link 10]
 *  [Linux][]
 *  [MySQL][]
 *  [Oracle][]
 *  [Redis][]
 *  [Dubbo][]

[https_javanav.com_val_2d21b1463f2e4faeaf0def0c49df34a4.html]: https://javanav.com/val/2d21b1463f2e4faeaf0def0c49df34a4.html
[Link 1]: https://www.javanav.com/interview/93b0069472fd479393006c0e73043fc4.html
[Link 2]: https://www.javanav.com/interview/4147d95e693945e7a50345fd33ec817e.html
[Link 3]: https://www.javanav.com/interview/68a57ffc78de4133bb890bdd502ac418.html
[Link 4]: https://www.javanav.com/interview/36a24fa3258e45c89873f474ce914912.html
[Web]: https://www.javanav.com/interview/4e27cb63adb440c6825a159d35cf4010.html
[Link 5]: https://www.javanav.com/interview/03affb2ce3f04fda8853f714e5764906.html
[Link 6]: https://www.javanav.com/interview/07a32a9ff17a4006a53550ce658cafed.html
[Link 7]: https://www.javanav.com/interview/5c466456e9b54ab0a749b5948e51f1d3.html
[Link 8]: https://www.javanav.com/interview/943f917041ee4f05add24539f5b861b2.html
[Link 9]: https://www.javanav.com/interview/d3f058cfc05d4c6dadd821b622e84d36.html
[Link 10]: https://www.javanav.com/interview/67a50996c28f418e83b109ea42fc3eff.html
[Linux]: https://www.javanav.com/interview/00cccb81729540d1923bd0a0ef49533a.html
[MySQL]: https://www.javanav.com/interview/d311e78502a845f1a4bb307bd6aec2b3.html
[Oracle]: https://www.javanav.com/interview/5f29e9677edf4a16be3dce30d257c9ab.html
[Redis]: https://www.javanav.com/interview/066c62b3af4d4827b2243a822c3084a9.html
[Dubbo]: https://www.javanav.com/interview/9a3e7a7740324757abaab953f7ebc455.html