java如何批量导入题目_MyBatis 如何批量插入？

方式一、打开批量插入的 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 userList = new ArrayList<>();

for (int i = 46; i <= 55; i++) {

userList.add(new User(i,"ConstXiong" + i));

}

userMapper.insertUserBatch(userList);

insert into user values

(#{item.id}, #{item.name})

完整 Demo：