springboot 注解方式批量插入数据的实现

一次请求需要往数据库插入多条数据时，可以节省大量时间，本文主要介绍了springboot 注解方式批量插入数据，文中通过示例代码介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们可以参考一下

一.使用场景

一次请求需要往数据库插入多条数据时，可以节省大量时间，mysql操作在连接和断开时的开销超过本次操作总开销的40%。

二.实现方法

1.mysql表结构

在这里插入图片描述

2.domain

在这里插入图片描述

package com.cxstar.order.domain; import java.util.Date; @lombok.Data public class Data { private int id; private String ruid; private String title; private String author; private String coverUrl; private String detialUrl; private String code; private int type; private String publisher; private int groupId; private String groupName; private int pageNo; private String searchKey; private Date createTime; }

3.mapper

在这里插入图片描述

package com.cxstar.order.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.cxstar.order.domain.Data; import org.apache.ibatis.annotations.InsertProvider; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import java.text.MessageFormat; import java.util.ArrayList; import java.util.List; import java.util.Map; @Mapper public interface DataMapper extends BaseMapper { @InsertProvider(type = Provider.class, method = "batchInsert") int batchInsert(List data); class Provider { /* 批量插入 */ public String batchInsert(Map map) { List data = (List) map.get("list"); StringBuilder sb = new StringBuilder(); sb.append("INSERT INTO data (" + "ruid," + "title," + "author," + "code," + "type," + "publisher," + "group_id," + "group_name," + "page_no," + "search_key," + "create_time," + "cover_url," + "detial_url" + ") VALUES "); MessageFormat mf = new MessageFormat( "(" + "#'{'list[{0}].ruid}, " + "#'{'list[{0}].title}, " + "#'{'list[{0}].author}, " + "#'{'list[{0}].code}, " + "#'{'list[{0}].type}, " + "#'{'list[{0}].publisher}, " + "#'{'list[{0}].groupId}, " + "#'{'list[{0}].groupName}, " + "#'{'list[{0}].pageNo}, " + "#'{'list[{0}].searchKey}, " + "#'{'list[{0}].createTime}, " + "#'{'list[{0}].coverUrl}, " + "#'{'list[{0}].detialUrl}" + ")" ); for (int i = 0; i

4.测试类

在这里插入图片描述

package com.cxstar.order; import com.alibaba.fastjson.JSONObject; import com.cxstar.order.domain.Data; import com.cxstar.order.mapper.DataMapper; //import com.cxstar.order.service.OrderService; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import java.util.ArrayList; import java.util.Date; import java.util.UUID; @SpringBootTest class OrderApplicationTests { @Autowired DataMapper dataMapper; @Test void data_batch_insert() { ArrayList batchInsertList = new ArrayList<>(); Data data = new Data(); data.setTitle("历史上的今天"); data.setAuthor("郭漫"); data.setCoverUrl("http://image31.bookschina.com/2011/20110520/s5143135.jpg-600"); data.setDetialUrl("http://www.bookschina.com/5143135.htm"); data.setGroupId(1); data.setGroupName("中国图书网"); data.setRuid(UUID.randomUUID().toString().replaceAll("-","")); data.setType(1); data.setCode(null); data.setPublisher(null); data.setPageNo(1); data.setSearchKey("历史上的今天"); data.setCreateTime(new Date()); batchInsertList.add(data); System.out.println(dataMapper.batchInsert(batchInsertList)); } }