easyexcel读文件入批量入es

最新推荐文章于 2024-09-12 14:36:22 发布

原创

最新推荐文章于 2024-09-12 14:36:22 发布 · 428 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java

1. 封装实体类，并对应excel表中的列

@Data
public class User {

    private String md5;

    private String id; 
    @ExcelProperty(value = "age")
    private String age;
    @ExcelProperty(value = "username")
    private String name;
  }

2. 批量入库


   private void insertBatchToES(List<User> dataList, String indexName) {
        try {
            BulkProcessor bulkProcessor = BulkProcessor.builder(
                    (request, bulkListener) -> elasticsearchClient.bulkAsync(request, RequestOptions.DEFAULT, bulkListener),
                    new BulkProcessor.Listener() {

                        @Override
                        public void beforeBulk(long executionId, org.elasticsearch.action.bulk.BulkRequest request) {
                            // 准备执行前的操作
                        }

                        @Override
                        public void afterBulk(long executionId, org.elasticsearch.action.bulk.Bulk