spring data elasticSearch CRUD+分页查询

看到网上一些关于spring data es的资料比较乱 而且多数都过时了
故总结一篇备使用
基于 spring-data-elasticsearch-4.0.9.RELEASE 编写

引入项目

		<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-elasticsearch</artifactId>
            <version>4.0.9.RELEASE</version>
        </dependency>

配置连接

spring:
  elasticsearch:
    rest:
      uris: http://127.0.0.1:9200
      username: 1
      password: 1

加包扫描

@SpringBootApplication
@EnableElasticsearchRepositories(basePackages = {"com.demo.esmapper"})
public class DemoProjectApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoProjectApplication.class, args);
    }

}

构建实体类

import lombok.Data;
import org.springframework.data.annotation.Id;
import org.springframework.data.elasticsearch.annotations.DateFormat;
import org.springframework.data.elasticsearch.annotations.Document;
import org.springframework.data.elasticsearch.annotations.Field;
import org.springframework.data.elasticsearch.annotations.FieldType;

import java.util.Date;

@Data
@Document(indexName = "demo", createIndex = true)
public class DemoDo {

    /**
     * id
     */
    @Id
    private String id;

    /**
     * biz_no
     */
    @Field(value = "biz_no", type = FieldType.Keyword)
    private String bizNo;

    /**
     * content
     */
    @Field(value = "content", type = FieldType.Keyword)
    private Integer content;

    /**
     * 创建时间
     */
    @Field(value = "create_time", type = FieldType.Date, format = DateFormat.custom, pattern = "yyyy-MM-dd HH:mm:ss")
    private Date createTime;

    /**
     * 创建人
     */
    @Field(value = "create_by", type = FieldType.Keyword)
    private String createBy;

    /**
     * 更新时间
     */
    @Field(value = "last_update_time", type = FieldType.Date, format = DateFormat.custom, pattern = "yyyy-MM-dd HH:mm:ss")
    private Date lastUpdateTime;

    /**
     * 更新人
     */
    @Field(value = "last_update_by", type = FieldType.Keyword)
    private String lastUpdateBy;
}

createIndex为true,会在项目启动时在es自动创建索引

创建repository

import org.springframework.data.elasticsearch.repository.ElasticsearchRepository;

import java.util.List;


public interface DemoMapper extends ElasticsearchRepository<DemoDo, String> {


    /**
     * 按spring data的规则命名的方法,spring data会解析后生成dsl
     */
    List<DemoDo> findByBizNoOrderByCreateTimeDesc(String bizNo);
}

官网的规则表
官网的规则表
因为ElasticsearchRepository继承自CrudRepository,所以基本的CRUD方法都提供了。

分页查询

import com.baomidou.mybatisplus.core.toolkit.LambdaUtils;
import com.baomidou.mybatisplus.core.toolkit.support.SFunction;
import org.apache.ibatis.reflection.property.PropertyNamer;
import org.elasticsearch.index.query.BoolQueryBuilder;
import org.elasticsearch.index.query.MatchQueryBuilder;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;
import org.springframework.data.elasticsearch.core.ElasticsearchRestTemplate;
import org.springframework.data.elasticsearch.core.SearchHit;
import org.springframework.data.elasticsearch.core.SearchHitSupport;
import org.springframework.data.elasticsearch.core.SearchHits;
import org.springframework.data.elasticsearch.core.query.NativeSearchQuery;
import org.springframework.data.elasticsearch.core.query.NativeSearchQueryBuilder;
import org.springframework.stereotype.Component;
import org.springframework.util.StringUtils;

import javax.annotation.Resource;


@Component
public class DemoRepository {


    @Resource
    private DemoMapper demoMapper;


    @Resource
    private ElasticsearchRestTemplate elasticsearchRestTemplate;


    public void save(DemoDo demoDo) {
        demoMapper.save(demoDo);
    }

    public Page<SearchHit<DemoDo>> pageList(String bizNo,String content,Integer pageNum,Integer pageSize) {
        //这里要注意 pageNum 是从0开始算起的
        Pageable pageable = PageRequest.of(pageNum,
                pageSize,
                Sort.by(Sort.Direction.DESC, this.columnToString(DemoDo::getCreateTime)));
        
        BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();
        //this.columnToString(DemoDo::getBizNo) equals "biz_no"
        if (StringUtils.hasLength(bizNo)) {
            boolQueryBuilder.must(new MatchQueryBuilder(this.columnToString(DemoDo::getBizNo), bizNo));
        }
        if (StringUtils.hasLength(content)) {
            boolQueryBuilder.must(new MatchQueryBuilder(this.columnToString(DemoDo::getContent), content));
        }
        NativeSearchQuery nativeSearchQuery = new NativeSearchQueryBuilder()
                .withQuery(boolQueryBuilder)
                .withPageable(pageable)
                .build();
        SearchHits<DemoDo> search = elasticsearchRestTemplate.search(nativeSearchQuery, DemoDo.class);
        return SearchHitSupport.searchPageFor(search, nativeSearchQuery.getPageable());
    }

    public static <T> String columnToString(SFunction<T, ?> column) {
        return com.baomidou.mybatisplus.core.toolkit.StringUtils.camelToUnderline(PropertyNamer
                .methodToProperty(LambdaUtils.resolve(column).getImplMethodName()));
    }
}

spring data elasticSearch官方文档:
https://docs.spring.io/spring-data/elasticsearch/docs/current-SNAPSHOT/reference/html/#elasticsearch.repositories
(小声吐槽官方文档不详细)

  • 5
    点赞
  • 10
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值