java 连接 Elasticsearch 使用 RestHighLevelClient 进行插入、删除、修改、查询数据

依赖

org.elasticsearch.client elasticsearch-rest-client 7.13.3 org.elasticsearch.client elasticsearch-rest-high-level-client 7.13.3 配置 @Configuration public class ESConfig {
@Bean
public RestHighLevelClient getRestHighLevelClient(){
    HttpHost http1 = new HttpHost("127.0.0.1", 9200, "http");
    HttpHost http2 = new HttpHost("127.0.0.1", 9201, "http");
    RestClientBuilder restClientBuilder = RestClient.builder(http1, http2);
    RestHighLevelClient restHighLevelClient = new RestHighLevelClient(restClientBuilder);
    return restHighLevelClient;
}

}

@Autowired
private RestHighLevelClient restHighLevelClient;

插入或更新数据
public void insertOrUpdateData() throws IOException {
HashMap<String, String> map = new HashMap<>();
map.put(“name”, “dd df ff”);
map.put(“age”, “16”);

IndexRequest indexRequest = new IndexRequest(“myindex”);
//设置ID
indexRequest.id(“9”);
//添加数据
indexRequest.source(map);

restHighLevelClient.indexAsync(indexRequest,
        RequestOptions.DEFAULT,
        new ActionListener<IndexResponse>() {
            @Override
            public void onResponse(IndexResponse indexResponse) {
                RestStatus status = indexResponse.status();
                System.out.println(status.name());
                if (indexResponse.getResult() == DocWriteResponse.Result.CREATED) {
                    System.out.println("创建成功");
                } else if (indexResponse.getResult() == DocWriteResponse.Result.UPDATED) {
  ## 标题                  System.out.println("更新成功");
                }
            }
            @Override
            public void onFailure(Exception e) {
                System.out.println("出异常了");
            }
        });

}

删除数据
public void deleteData() throws IOException {
DeleteRequest deleteRequest = new DeleteRequest(“myindex”);
deleteRequest.id(“1”);
deleteRequest.timeout(TimeValue.timeValueMinutes(2));

DeleteResponse deleteResponse = restHighLevelClient.delete(
        deleteRequest, RequestOptions.DEFAULT);
if (deleteResponse.getResult() == DocWriteResponse.Result.NOT_FOUND) {
    System.out.println("未找到需要删除的数据");
}

}
更新数据
public void updateData() throws IOException {
Map<String, Object> parameters = new HashMap<>();
parameters.put(“count”, 4);

Script script = new Script(ScriptType.INLINE, "painless",
        "ctx._source.field += params.count", parameters);

UpdateRequest updateRequest = new UpdateRequest("myindex", "2");
updateRequest.script(script);
UpdateResponse updateResponse = restHighLevelClient.update(updateRequest, RequestOptions.DEFAULT);
DocWriteResponse.Result result = updateResponse.getResult();
if (result == DocWriteResponse.Result.CREATED) {
    System.out.println("created");
} else if (result == DocWriteResponse.Result.UPDATED) {
    System.out.println("updated");
} else if (result == DocWriteResponse.Result.DELETED) {
    System.out.println("deleted");
} else if (result == DocWriteResponse.Result.NOOP) {
    System.out.println("noop");
}

}
单条查询数据
public void updateData() throws IOException {
Map<String, Object> parameters = new HashMap<>();
parameters.put(“count”, 4);

Script script = new Script(ScriptType.INLINE, "painless",
        "ctx._source.field += params.count", parameters);

UpdateRequest updateRequest = new UpdateRequest("myindex", "2");
updateRequest.script(script);
UpdateResponse updateResponse = restHighLevelClient.update(updateRequest, RequestOptions.DEFAULT);
DocWriteResponse.Result result = updateResponse.getResult();
if (result == DocWriteResponse.Result.CREATED) {
    System.out.println("created");
} else if (result == DocWriteResponse.Result.UPDATED) {
    System.out.println("updated");
} else if (result == DocWriteResponse.Result.DELETED) {
    System.out.println("deleted");
} else if (result == DocWriteResponse.Result.NOOP) {
    System.out.println("noop");
}

}
单条查询数据
public void getOneData() throws IOException {
String[] includes = Strings.EMPTY_ARRAY;
String[] excludes = Strings.EMPTY_ARRAY;
FetchSourceContext fetchSourceContext =
new FetchSourceContext(true, includes, excludes);

GetRequest getRequest = new GetRequest("myindex");
getRequest.id("9");

getRequest.fetchSourceContext(fetchSourceContext);

boolean exists = restHighLevelClient.exists(getRequest, RequestOptions.DEFAULT);
if (exists) {
    System.out.println("有数据");
}
GetResponse response = restHighLevelClient.get(getRequest, RequestOptions.DEFAULT);
if (response.isExists()) {
    Map<String, Object> sourceAsMap = response.getSourceAsMap();
    //获取索引名称
    String index = response.getIndex();
    //获取索引类型
    String type = response.getType();
    //获取索引id
    String id = response.getId();
    System.out.println("index:" + index);
    System.out.println("type:" + type);
    System.out.println("id:" + id);
    System.out.println(sourceAsMap);
} else {
    System.out.println("没有数据");
}

}
多条查询
public void multiQuery() throws IOException {
MultiGetRequest multiGetRequest = new MultiGetRequest();
multiGetRequest.add(“myindex”, “3”);
multiGetRequest.add(“myindex”, “5”);
MultiGetResponse multiGetResponse = restHighLevelClient
.mget(multiGetRequest, RequestOptions.DEFAULT);
MultiGetItemResponse[] responses = multiGetResponse.getResponses();
Stream.of(responses).forEach(response -> {
String id = response.getResponse().getId();
String source = response.getResponse().getSourceAsString();
System.out.println("id = " + id + " --> " + source);
});
}

  • 1
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
使用elasticsearch-sql框架,可以通过以下步骤将SQL数据插入ES: 1. 创建一个ES索引,定义字段映射 2. 使用ES-SQL框架连接ES,执行SQL查询获取数据 3. 遍历查询结果,使用ES-SQL框架提供的API将数据插入ES 下面是一个示例代码,演示如何使用ES-SQL框架将SQL数据插入ES: ```java import io.github.iamazy.elasticsearch.dsl.sql.parser.SqlParser; import org.elasticsearch.action.bulk.BulkRequest; import org.elasticsearch.action.bulk.BulkResponse; import org.elasticsearch.client.RequestOptions; import org.elasticsearch.client.RestHighLevelClient; import org.elasticsearch.index.query.QueryBuilders; import org.elasticsearch.rest.RestStatus; import org.elasticsearch.search.builder.SearchSourceBuilder; import org.nlpcn.es4sql.exception.SqlParseException; import org.nlpcn.es4sql.query.QueryAction; import org.nlpcn.es4sql.query.SqlElasticRequestBuilder; import java.io.IOException; import java.sql.*; public class SqlToEs { // 定义ES索引名称 private static final String INDEX_NAME = "my_index"; // 定义ES连接客户端 private RestHighLevelClient client; // 定义SQL查询语句 private String sql = "SELECT * FROM my_table WHERE id > 100"; public SqlToEs() { // 初始化ES连接客户端 client = new RestHighLevelClient(); } public void insert() throws SQLException, IOException, SqlParseException { // 解析SQL查询语句 SqlParser sqlParser = new SqlParser(); QueryAction queryAction = sqlParser.parseSelect(sql); // 构建ES查询请求 SqlElasticRequestBuilder requestBuilder = queryAction.explain(); SearchSourceBuilder sourceBuilder = requestBuilder.getSourceBuilder(); sourceBuilder.query(QueryBuilders.matchAllQuery()); String query = sourceBuilder.toString(); // 执行SQL查询获取数据 Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/my_database", "user", "password"); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(query); // 遍历查询结果,将数据插入ES BulkRequest request = new BulkRequest(); while (rs.next()) { // 创建一个ES文档 Map<String, Object> document = new HashMap<>(); document.put("id", rs.getInt("id")); document.put("name", rs.getString("name")); document.put("age", rs.getInt("age")); // 添加到批量请求中 request.add(new IndexRequest(INDEX_NAME).source(document)); } // 执行批量请求 BulkResponse bulkResponse = client.bulk(request, RequestOptions.DEFAULT); if (bulkResponse.status() == RestStatus.OK) { System.out.println("数据插入成功!"); } } } ``` 这里使用ES-SQL框架解析SQL查询语句,并构建ES查询请求。然后执行SQL查询获取数据,并遍历查询结果,将数据插入ES。最后使用ES客户端执行批量请求,将数据插入ES。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值