MyBatis - 批量INSERT

最新推荐文章于 2024-09-23 21:44:23 发布

chernyog

最新推荐文章于 2024-09-23 21:44:23 发布

阅读量404

点赞数

分类专栏： Java 文章标签： mybatis insert

本文链接：https://blog.csdn.net/chenyblog/article/details/102622833

版权

Java 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

XML文件

<insert id ="insertBatch" parameterType="java.util.List">
    <selectKey resultType ="java.lang.Integer" keyProperty= "id"
               order= "AFTER">
      SELECT LAST_INSERT_ID()
    </selectKey >
    INSERT INTO message_user
    (user_id, message_id, create_time)
    values
    <foreach collection ="list" item="model" index= "index" separator =",">
      (
      #{model.userId}, #{model.messageId}, #{model.createTime}
      )
    </foreach >
</insert >

JAVA代码

// 部分代码
messageService.insert(message);
int messageId = message.getId();
int size = userIdList.size();
int startIndex = 0;
// MAX_BATCH_REQUEST: 最大批处理请求数
int endIndex = MAX_BATCH_REQUEST;
while (startIndex <= size) {
    if (endIndex > size) {
        endIndex = size;
    }
    List<String> subItems = userIdList.subList(startIndex, endIndex);
    List<MessageUser> modelList = new ArrayList<>();
    for (String obj : subItems) {
        if (StringUtils.isEmpty(obj)) continue;
        MessageUser mu = new MessageUser();
        mu.setUserId(new BigDecimal(obj).intValue());
        mu.setMessageId(messageId);
        mu.setCreateTime(now);
        modelList.add(mu);
    }
    // 调用Service方法
    messageUserService.insertBatch(modelList);
    startIndex += MAX_BATCH_REQUEST;
    endIndex += MAX_BATCH_REQUEST;
}