栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

spring-data-elasticsearch使用笔记

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

spring-data-elasticsearch使用笔记

文章目录
  • 一、定义document
  • 二、手动put es mapping(类似于建表,定义表结构)
  • 三、创建respository,并定义方法(可省略)
  • 四、ElasticsearchOperations使用及与Mybatis-plus方法的转换
    • - 增删改
    • - 查
  • 五、一些坑

一、定义document
@Data
@EqualsAndHashCode(callSuper = false)
@Document(indexName = "syni_sjb_encyclopedia_entry")
public class SjbEncyclopediaEntryDocument implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    private String id;

    
    @Field(type = FieldType.Text, analyzer = "ik_max_word", searchAnalyzer="ik_max_word")
    private String name;

    
    @Field(type = FieldType.Text, analyzer = "ik_max_word", searchAnalyzer="ik_max_word")
    private String entryExplain;

    
    @Field(type = FieldType.Integer)
    private Integer initPeopleCount;

    
    @Field(type = FieldType.Integer)
    private Integer complementPeopleCount;

    
    @Field(type = FieldType.Integer)
    private Integer realPeopleCount;

    
    @Field(type = FieldType.Integer)
    private Integer sumPeopleCount;

    
    @Field(type = FieldType.Keyword)
    private String link;

    
    @Field(type = FieldType.Keyword)
    private String createWay;

    
    @Field(type = FieldType.Keyword)
    private String creator;

    
    @Field(type = FieldType.Date, format = DateFormat.date_hour_minute_second)
    @JsonFormat(shape = JsonFormat.Shape.STRING, pattern ="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
    private LocalDateTime createTime;

    
    @Field(type = FieldType.Date, format = DateFormat.date_hour_minute_second)
    @JsonFormat(shape = JsonFormat.Shape.STRING, pattern ="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
    private LocalDateTime updateTime;


}

这里有个坑:时间字段使用
@Field(type = FieldType.Date, format = DateFormat.custom, pattern = “yyyy-MM-dd HH:mm:ss”)
调用find时时间会反序列化失败,不知道是不是版本问题
我的版本是2.3.4 RELEASE

二、手动put es mapping(类似于建表,定义表结构)
put http://xxx.xxx.xx:9200/syni_sjb_encyclopedia_entry
{
    "mappings": {
        "properties": {
            "_class": {
                "type": "text",
                "fields": {
                    "keyword": {
                        "type": "keyword",
                        "ignore_above": 256
                    }
                }
            },
            "complementPeopleCount": {
                "type": "integer"
            },
            "createTime": {
                "type": "date",
                "format": "yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd||epoch_millis"
            },
            "createWay": {
                "type": "keyword"
            },
            "creator": {
                "type": "keyword"
            },
            "entryExplain": {
                "type": "text",
                "analyzer": "ik_max_word"
            },
            "initPeopleCount": {
                "type": "integer"
            },
            "link": {
                "type": "keyword"
            },
            "name": {
                "type": "text",
                "analyzer": "ik_max_word"
            },
            "realPeopleCount": {
                "type": "integer"
            },
            "sumPeopleCount": {
                "type": "integer"
            },
            "updateTime": {
                "type": "date",
                "format": "yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd||epoch_millis"
            }
        }
    }
}

ES自带有自动建表的功能,那为什么还要手动put?
因为字段的类型可能不会合你意,比如时间格式只有yyyy-MM-dd’T’HH:mm:ss,但实际上还可能需要yyyy-MM-dd

三、创建respository,并定义方法(可省略)
public interface SjbEncyclopediaEntryRepository extends ElasticsearchRepository {

    List findByNameAndIdNot(String name, String id);
}

方法定义类似JPA(虽然我也没用过JPA,大概意思就是按照一定规范定义方法,框架就自动帮你实现,比如findByName)
这个不太好用,因为用这个就不知道怎么分页,怎么排序了。

四、ElasticsearchOperations使用及与Mybatis-plus方法的转换

我的需求是把mysql的数据转移到ES,功能不变。所以需要把Mybatis-plus的方法转化成ES

- 增删改

增:xxxService.save(entity) => elasticsearchOperations.save(entity)
改:xxxService.update(entity) => elasticsearchOperations.save(entity)
删:xxxService.removeById(id) => elasticsearchOperations.deleteById(id)

增和改同样是使用save,只要id一样就会自动覆盖。

- 查

查比较复杂,上一段代码大家看看前后对比

    public Page queryByParam(SjbEncyclopediaEntryQueryDTO dto) {
    	// 分页
        Page page = new Page<>(dto.getPageNo(), dto.getPageSize());
        QueryWrapper queryWrapper = new QueryWrapper<>();
        if(StringUtils.isNotBlank(dto.getName())) {
            queryWrapper.lambda().eq(SjbEncyclopediaEntry::getName, dto.getName());
        }
        if(dto.getStartDate() != null && dto.getEndDate() != null) {
            queryWrapper.lambda().between(SjbEncyclopediaEntry::getCreateTime, dto.getStartDate(), dto.getEndDate().plusDays(1));
        }
        // 排序
        queryWrapper.lambda().orderByDesc(SjbEncyclopediaEntry::getRealPeopleCount);
        page = page(page, queryWrapper);
        Page result = new Page<>(dto.getPageNo(), dto.getPageSize());
        BeanUtils.copyProperties(page, result);
        result.setRecords(page.getRecords().stream().map(sjbEncyclopediaEntry -> {
            SjbEncyclopediaEntryVO vo = new SjbEncyclopediaEntryVO();
            BeanUtils.copyProperties(sjbEncyclopediaEntry, vo);
            vo.setRealPeopleCount(getRedisRealPeopleCount(sjbEncyclopediaEntry.getId()));
            return vo;
        }).collect(Collectors.toList()));
        return result;
    }
    public Page queryByParam(SjbEncyclopediaEntryQueryDTO dto) {
        Pageable pageable = PageRequest.of(dto.getPageNo()-1, dto.getPageSize());
        BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
        if(StringUtils.isNotBlank(dto.getName())) {
            boolQueryBuilder.must(QueryBuilders.termsQuery("name", dto.getName()));
        }
        if(dto.getStartDate() != null && dto.getEndDate() != null) {
            boolQueryBuilder.filter(QueryBuilders.rangeQuery("createTime").from(dto.getStartDate()).to(dto.getEndDate().plusDays(1)));
        }
        SortBuilder sortBuilder = SortBuilders.fieldSort("createTime").order(SortOrder.DESC);
        NativeSearchQuery build = new NativeSearchQueryBuilder()
                .withQuery(boolQueryBuilder)
                .withPageable(pageable)
                .withSort(sortBuilder)
                .build();
        SearchHits search = elasticsearchOperations.search(build, SjbEncyclopediaEntryDocument.class);
        Page result = new Page<>(dto.getPageNo(), dto.getPageSize());
        result.setTotal(search.getTotalHits());

        List> collect = search.get().collect(Collectors.toList());
        result.setRecords(collect.stream().map(sjbEncyclopediaEntry -> {
            SjbEncyclopediaEntryVO vo = new SjbEncyclopediaEntryVO();
            BeanUtils.copyProperties(sjbEncyclopediaEntry.getContent(), vo);
            vo.setRealPeopleCount(getRedisRealPeopleCount(sjbEncyclopediaEntry.getId()));
            return vo;
        }).collect(Collectors.toList()));
        return result;
    }

可以大致理解mybatis-plus与es的实体与api对应关系为:

QueryWrapper => NativeSearchQuery
Page => Pageable
wrapper.orderByDesc => SortBuilder
Page result => List>
page(page, queryWrapper); => elasticsearchOperations.search(build, SjbEncyclopediaEntryDocument.class);
五、一些坑

boolQueryBuilder.filter(QueryBuilders.rangeQuery(“publishTime”).lt(LocalDateTime.now()));
这句话又报错了,估计是lt里的时间值转字符串时多了毫秒值,试了mapping里加毫秒格式也不行。
解决方案:直接用字符串
String format = LocalDateTime.now().format(DateTimeFormatter.ofPattern(“yyyy-MM-dd’T’HH:mm:ss”));
boolQueryBuilder.filter(QueryBuilders.rangeQuery(“publishTime”).lt(format));

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/956362.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号