1、新建UserMapper并继承baseMapper
@Mapper
public interface UserMapper extends BaseMapper<User> {
}
2、新建UserService并继承IService
public interface UserService extends IService<User> {
int saveBatch(List<User> userList);
}
3、新建UserService的实现类并继承ServiceImpl<M,T>
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
@Resource
private UserMapper userMapper;
@Override
public void saveBatch(List<User> userList) {
this.saveBatch(userList, userList.size());
}
}
4、完成测试
public class UserController {
@Resource
private UserService userService;
public void test() {
List<User> users = new ArrayList<>();
// 把要插入的数据 .add 到 users 集合中即可
userService.saveBatch(users);
}
总结
利用这种方式批量插入数据,会生成多条INSERT语句一条条执行,然后按设置的batchSize(第3步中设置的userList.size()的值)来提交事务。