estemplate 导入MySQL_ElasticSearch使用ElasticsearchTemplate整合spring

1、首先引进maven依赖

org.springframework.data

spring-data-elasticsearch

2.0.2.RELEASE

2.配置es.properties

#默认即为elasticsearch

elasticsearch_cluster_name=elasticsearch

#配置es节点信息，逗号分隔，如果没有指定，则启动ClientNode

elasticsearch_cluster_nodes=172.16.30.56:19300,172.16.30.126:19300

3.配置applicationContext-es.xml，整合spring

//对应es.properties中的数据

class="org.springframework.data.elasticsearch.core.ElasticsearchTemplate">

4、导入、注入ElasticsearchTemplate

importorg.springframework.data.elasticsearch.core.ElasticsearchTemplate;//导入包

@Autowired(required=false)privateElasticsearchTemplate esTemplate;

5、新增或者更新数据到ES

//增加或者更新

public ReturnResult addEsCashInfo(String cashId, String type) throwsException {

ReturnResult result= newReturnResult();if(StringUtils.isBlank(cashId)) {

String msg= "cashId不能为空";

logger.info(msg);throw newGmallException(msg);

}

logger.info("addEsCashInfo cashId=" + cashId + ",type=" +type);

net.sf.json.JSONObject obj= newnet.sf.json.JSONObject();if(SuperAppConstant.CASH_CALL_BACK_TYPE.equals(type)) {

Cash cash=cashMapper.selectByPrimaryKey(cashId);

obj=net.sf.json.JSONObject.fromObject(cash);

CashEs cashEs= newCashEs();

BeanUtils.copyProperties(cashEs, cash);

IndexQuery indexQuery= newIndexQueryBuilder().withIndexName(SuperAppConstant.ES_INDEX_NAME)

.withType(SuperAppConstant.ES_CASH_TYPE).withId(cashId).withObject(cashEs).build();

esTemplate.index(indexQuery);

}else{

String msg= "未知支付类型";

logger.info(msg);throw newGmallException(msg);

}

result.setCode(ReturnCodeType.SUCCESS).setMessage("插入成功");returnresult;

}

6、查询ES中的数据

ES查询语句

{"query": {"bool": {"must": [{"term": {"state": 1}

}, {"term": {"appId": "99999999-9999-9999-9999-999999999999"}

}, {"bool": {"should": [{"match": {"payPlatform": {"query": "TL","type": "boolean"}

}

}, {"match": {"payPlatform": {"query": "TL_WX_APP","type": "boolean"}

}

}, {"match": {"payPlatform": {"query": "TL_ALI","type": "boolean"}

}

}, {"match": {"payPlatform": {"query": "TL_WX_JS","type": "boolean"}

}

}, {"match": {"payPlatform": {"query": "TL_APP","type": "boolean"}

}

}, {"match": {"payPlatform": {"query": "TL_WX_H5","type": "boolean"}

}

}, {"match": {"payPlatform": {"query": "WX_GWORLD","type": "boolean"}

}

}, {"match": {"payPlatform": {"query": "ALI_GWORLD","type": "boolean"}

}

}]

}

}]

}

}

}

对应使用Java查询

public Sum getEsPaySummaryInfo(String appId) throwsException {SumBuilder sb= AggregationBuilders.sum("tpPrice").field("payPrice");

BoolQueryBuilder bqb =QueryBuilders.boolQuery();

bqb.must(QueryBuilders.termQuery("state",SuperAppConstant.PAY_STATUS_SUCCESS));

bqb.must(QueryBuilders.termQuery("appId",appId));

bqb.must(QueryBuilders.boolQuery()

.should(QueryBuilders.matchQuery("payPlatform", SuperAppConstant.PAY_PLATFORM_TL))

.should(QueryBuilders.matchQuery("payPlatform", SuperAppConstant.PAY_PLATFORM_TL_WX_APP))

.should(QueryBuilders.matchQuery("payPlatform", SuperAppConstant.PAY_PLATFORM_TL_ALI))

.should(QueryBuilders.matchQuery("payPlatform", SuperAppConstant.PAY_PLATFORM_TL_WX_JS))

.should(QueryBuilders.matchQuery("payPlatform", SuperAppConstant.PAY_PLATFORM_TL_APP))

.should(QueryBuilders.matchQuery("payPlatform", SuperAppConstant.PAY_PLATFORM_TL_WX_H5))

.should(QueryBuilders.matchQuery("payPlatform", SuperAppConstant.PAY_PLATFORM_WX_GWORLD))

.should(QueryBuilders.matchQuery("payPlatform", SuperAppConstant.PAY_PLATFORM_ALI_GWORLD))

);

SearchQuery searchQuery= newNativeSearchQueryBuilder().withQuery(bqb).withIndices(SuperAppConstant.ES_INDEX_NAME).withTypes(SuperAppConstant.ES_PAY_TYPE)

.withSearchType(SearchType.DEFAULT)

.addAggregation(sb).build();

Aggregations aggregations= esTemplate.query(searchQuery, new ResultsExtractor() {

@OverridepublicAggregations extract(SearchResponse response) {returnresponse.getAggregations();

}

});

Sum _sum= aggregations.get("tpPrice");if(_sum != null){

logger.info("sum="+_sum.getValue());

}return_sum;

}

7、聚合查询，分组求和(对应sql的group by)

public Map getEsCashSummaryInfo(String appId) throwsException {

Map map= new HashMap<>();

TermsBuilder tb= AggregationBuilders.terms("cash").field("appId");//appId 是分组字段名，cash是查询结果的别名

SumBuilder sb = AggregationBuilders.sum("amount").field("paid");//paid是求和字段名称，amount是结果别名

tb.subAggregation(sb);

BoolQueryBuilder bqb=QueryBuilders.boolQuery();

bqb.mustNot(QueryBuilders.termQuery("settled",SuperAppConstant.CASH_STATUS_CANCLED));

bqb.must(QueryBuilders.termQuery("appId",appId));

SearchQuery searchQuery= newNativeSearchQueryBuilder().withQuery(bqb).withIndices(SuperAppConstant.ES_INDEX_NAME).withTypes(SuperAppConstant.ES_CASH_TYPE)

.withSearchType(SearchType.DEFAULT)

.addAggregation(tb)

.build();

Aggregations aggregations= esTemplate.query(searchQuery, new ResultsExtractor() {

@OverridepublicAggregations extract(SearchResponse response) {returnresponse.getAggregations();

}

});

Terms term= aggregations.get("cash");//获取结果后进行解析if(term.getBuckets().size()>0){for(Bucket bk : term.getBuckets()) {long count =bk.getDocCount();//得到所有子聚合

Map subaggmap =bk.getAggregations().asMap();//sum值获取方法

double amount = ((InternalSum) subaggmap.get("amount")).getValue();

map.put("count", count);

map.put("amount", amount);

}returnmap;

}else{return null;

}

}