Elasticsearch教程(九) elasticsearch 查询数据 | 分页查询

soゝso 2016-08-23 00:23:13 67869

Elasticsearch  目录

Elasticsearch  的查询很灵活,并且有Filter,有分组功能,还有ScriptFilter等等,所以很强大。下面上代码:

一个简单的查询,返回一个List<对象> .。

/**
 * 根据Id 查询 SOBangg
 * @param key
 * @return
 */
public static List findSOBanggById(String id) {

	Client client = ESTools.client;
	SearchResponse response = client.prepareSearch(MappingManager.INDEX)
    .setTypes(MappingManager.B_TYPE)
    .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
    .setQuery(QueryBuilders.termQuery("id",id))                 // Query
//        .setPostFilter(QueryBuilders.rangeQuery("age").from(12).to(18))     // Filter
    .setFrom(0).setSize(60).setExplain(true)
    .execute()
    .actionGet();
	SearchHits hits = response.getHits();
	List list = new ArrayList();
	for (SearchHit searchHit : hits) {
		Map source = searchHit.getSource();
		SOBangg entity = (SOBangg) JSONObject.toBean(JSONObject.fromObject(source) , SOBangg.class);
		list.add(entity);
	}
	return list;
}

下面我把我整个类贴出来。

package com.sojson.core.elasticsearch.manager;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import net.sf.json.JSONObject;

import org.elasticsearch.action.get.GetRequest;
import org.elasticsearch.action.get.GetResponse;
import org.elasticsearch.action.search.SearchRequestBuilder;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.action.search.SearchType;
import org.elasticsearch.client.Client;
import org.elasticsearch.common.unit.TimeValue;
import org.elasticsearch.index.query.QueryBuilder;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.SearchHits;

import com.sojson.common.model.SOBang;
import com.sojson.common.model.SOBangg;
import com.sojson.common.model.SOBanggKey;
import com.sojson.core.elasticsearch.utils.ESTools;
import com.sojson.core.mybatis.page.Pagination;

public class SelectManager {
	
	
	/**
	 * 分页查询 SOBang
	 * @param resultMap
	 * @param pageSize
	 * @param pageNo
	 * @return
	 */
	public static Pagination findByPage(Map resultMap, 
			Integer pageSize,
			Integer pageNo){
		Pagination page = new Pagination();
		pageNo = null==pageNo?1:pageNo;
		page.setPageNo(pageNo);
		page.setPageSize(pageSize);
		
		
		Client client = ESTools.client;
		SearchRequestBuilder srb = client.prepareSearch(MappingManager.INDEX);
		srb.setSearchType(SearchType.DFS_QUERY_THEN_FETCH);
		srb.setTypes(MappingManager.TYPE);
//		srb.setQuery(resultMap);
		srb.setFrom((pageNo - 1) * pageSize).setSize(pageSize)
		.setExplain(true);
		
		SearchResponse response = srb.execute().actionGet();
		SearchHits hits = response.getHits();
		
		page.setTotalCount((int)hits.getTotalHits());
		List list = new ArrayList();
		for (SearchHit searchHit : hits) {
			Map source = searchHit.getSource();
			SOBang entity = (SOBang)JSONObject.toBean(JSONObject.fromObject(source) 
						, SOBang.class);
			list.add(entity);
		}
		page.setList(list);
		return page;
		
	}
	/**
	 * 分页查询 SOBangg
	 * @param resultMap
	 * @param pageSize
	 * @param pageNo
	 * @return
	 */
	public static Pagination findSOBanggByPage(Map resultMap,
			Integer pageSize,
			Integer pageNo){
		Pagination page = new Pagination();
		pageNo = null==pageNo?1:pageNo;
		page.setPageNo(pageNo);
		page.setPageSize(pageSize);
		
		
		Client client = ESTools.client;
		SearchRequestBuilder srb = client.prepareSearch(MappingManager.INDEX);
		srb.setSearchType(SearchType.DFS_QUERY_THEN_FETCH);
		srb.setTypes(MappingManager.B_TYPE);
		
		srb.setQuery(QueryBuilders.termQuery("status",0));
		srb.setFrom((pageNo - 1) * pageSize).setSize(pageSize)
		.setExplain(true);
		
		SearchResponse response = srb.execute().actionGet();
		SearchHits hits = response.getHits();
		
		page.setTotalCount((int)hits.getTotalHits());
		List list = new ArrayList();
		for (SearchHit searchHit : hits) {
			Map source = searchHit.getSource();
			SOBangg entity = (SOBangg) JSONObject
				.toBean(JSONObject.fromObject(source) , SOBangg.class);
			list.add(entity);
		}
		page.setList(list);
		return page;
		
	}
	/**
	 * 根据ID查询SOBang
	 * @param id
	 * @return
	 */
	public static SOBang findSOBangById(String id){
		GetRequest rq = new GetRequest(MappingManager.INDEX, MappingManager.TYPE, id);
		//GetResponse response = client.prepareGet(MappingManager.INDEX, MappingManager.TYPE, id);
		GetResponse response = ESTools.client.get(rq).actionGet();
		SOBang entity = null;
		//判断非空
		if(!response.isSourceEmpty()){
			Map data = response.getSource();
			entity = (SOBang)JSONObject.toBean(JSONObject.fromObject(data)
						,SOBang.class);
		}
		return entity;
	}
	/**
	 * 根据Key 查询 SOBangg
	 * @param key
	 * @return
	 */
	public static SOBangg findSOBanggByKey(SOBanggKey key) {
		String prefix = "%sx_x%s";
		String id = String.format(prefix, key.getId(),key.getGid());
		GetRequest rq = new GetRequest(MappingManager.INDEX, MappingManager.B_TYPE, id);
		//GetResponse response = client.prepareGet(MappingManager.INDEX, MappingManager.TYPE, id);
		GetResponse response = ESTools.client.get(rq).actionGet();
		SOBangg entity = null;
		//判断非空
		if(!response.isSourceEmpty()){
			Map data = response.getSource();
			entity = (SOBangg)JSONObject.toBean(JSONObject.fromObject(data)
						,SOBangg.class);
		}
		return entity;
	}
	/**
	 * 根据Id 查询 SOBangg
	 * @param key
	 * @return
	 */
	public static List findSOBanggById(String id) {
	
		Client client = ESTools.client;
		SearchResponse response = client.prepareSearch(MappingManager.INDEX)
	    .setTypes(MappingManager.B_TYPE)
	    .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
	    .setQuery(QueryBuilders.termQuery("id",id))                 // Query
	//        .setPostFilter(QueryBuilders.rangeQuery("age").from(12).to(18))     // Filter
	    .setFrom(0).setSize(60).setExplain(true)
	    .execute()
	    .actionGet();
		SearchHits hits = response.getHits();
		List list = new ArrayList();
		for (SearchHit searchHit : hits) {
			Map source = searchHit.getSource();
			SOBangg entity = (SOBangg) JSONObject.toBean(JSONObject.fromObject(source) 
						, SOBangg.class);
			list.add(entity);
		}
		return list;
	}
	
	
	
	public static BangDetailsBo findById(String id) {
		BangDetailsBo result = new BangDetailsBo();
		GetRequest rq = new GetRequest(MappingManager.INDEX, MappingManager.TYPE, id);
		
		GetResponse response = ESTools.client.get(rq).actionGet();
		//判断非空
		if(!response.isSourceEmpty()){
			Map data = response.getSource();
			SOBang entity = (SOBang)JSONObject.toBean(JSONObject.fromObject(data)
						,SOBang.class);
			result.setEntity(entity);
		}
		
		return result;
	}
}


自己鼓捣鼓捣吧,有问题加群问我,Pagination对象我没公开,这个是系统里的,和这个查询没关系,你可以替换成你的Page对象即可。


版权所属:SO JSON在线解析

原文地址:https://www.sojson.com/blog/90.html

转载时必须以链接形式注明原始出处及本声明。

本文主题:

如果本文对你有帮助,那么请你赞助我,让我更有激情的写下去,帮助更多的人。

关于作者
一个低调而闷骚的男人。
相关文章
Elasticsearch教程Elasticsearch count 查询Elasticsearch 查询是否存在
Elasticsearch 教程Elasticsearch 日期查询详解,Elasticsearch Date 查询Java API
Elasticsearch 聚合(aggregation)查询返回所有
Elasticsearch教程(八) elasticsearch delete 删除数据(Java)
Elasticsearch教程(五) elasticsearch Mapping的创建
Elasticsearch教程(七) elasticsearch Insert 插入数据(Java)
Elasticsearch教程Elasticsearch配置文件 — elasticsearch.yml
Elasticsearch教程(六) elasticsearch Client创建
Elasticsearch教程Elasticsearch Java API创建Mapping,指定分词器
Elasticsearch 教程Elasticsearch部署阿里云集群,支持外网请求方式
最新文章
Elasticsearch 好消息, X-Pack的开源:第一阶段完成 15396
文字转语音接口,支持汉字、英语,文字转音频开放接口,还支持翻译播放 8564
Spring JPA查询,JPA 根据方法名字查询详细介绍 32663
Springboot JPA 执行原生sql ,自定义SQL占位符增加参数 54336
Java 随机从 List 随机获取多个不重复对象,Mysql 随机10条数据 16710
Linux 安装 Redis 详细步骤讲解 5720
Javascript 生成UUID,Java生成UUID 9694
Maven的Mirror和Repository 的详细讲解 38075
JDK1.7中新增自动释放资源接口AutoCloseable讲解 15001
对Java的常用对象(POJO、DTO、PO、BO、VO、DAO)详细解释及应用场景 21656
最热文章
Springboot JPA 执行原生sql ,自定义SQL占位符增加参数 54336
Maven的Mirror和Repository 的详细讲解 38075
在windows上安装redis并设置密码,IP绑定【提供安装包】 37951
Spring JPA查询,JPA 根据方法名字查询详细介绍 32663
对Java的常用对象(POJO、DTO、PO、BO、VO、DAO)详细解释及应用场景 21656
最新VS2012破解 序列号,vs2012旗舰版密钥序列号【收藏】 21581
Java 随机从 List 随机获取多个不重复对象,Mysql 随机10条数据 16710
Elasticsearch操作数据后马上更新的办法 16437
Elasticsearch 好消息, X-Pack的开源:第一阶段完成 15396
JDK1.7中新增自动释放资源接口AutoCloseable讲解 15001
支付扫码

所有赞助/开支都讲公开明细,用于网站维护:赞助名单查看

查看我的收藏

正在加载... ...