秦皇岛工程建设信息网站/线上运营推广方案

刚开始使用spring data elasticsearch 会有有一个疑问就是：能不能像操作mysql那样打印sql日志，也便于分析啊，其实特别简单，具体如下的代码所示：

    /*** 高亮显示* @param keyword* @param pageNum* @param pageSize* @return*/@GetMapping("/getUserList2")public Page<User> query3( String keyword, Integer pageNum, Integer pageSize) {if(pageNum == null || pageNum <= 0){pageNum = 1;}if(pageSize == null || pageSize <= 0){pageSize = 5;}//获取QueryBuilderBoolQueryBuilder querryBuilder = this.getQuerryBuilder(keyword,"三1006");NativeSearchQueryBuilder nativeSearchQueryBuilder = this.getWildcardQuery(keyword, "myes", "myuser");//关联分页、过滤器nativeSearchQueryBuilder.withIndices("myes").withTypes("myuser")//添加bool过滤器.withFilter(querryBuilder).withSort(SortBuilders.fieldSort("age").order(SortOrder.DESC))//添加分页条件.withPageable(PageRequest.of(pageNum - 1, pageSize));//查询结果NativeSearchQuery searchQuery = nativeSearchQueryBuilder.build();//打印filter 的dsl语句log.info(searchQuery.getFilter().toString());System.out.println("=================");//log.info(searchQuery.get);//打印query的 的dsl语句System.out.println(nativeSearchQueryBuilder.build().getQuery().toString());AggregatedPage<User> esEntityList = estemplate.queryForPage(nativeSearchQueryBuilder.build(), User.class);return esEntityList;}

完整代码地址: https://github.com/Dr-Water/springdata-es-action