2024-09-25
|
ZH
DataRow row = new ElasticSearchRow(); row.put("_id" ,123);//指定主键值 ServiceProxy.delete(table_name, row);
2024-09-25
|
ZH
List<Object> ids = new ArrayList<>(); ids.add(1); ids.add(2); ServiceProxy.delete("crm_user", ids);
2024-09-25
|
ZH
import org.elasticsearch.client.Request; import org.elasticsearch.client.Response; import org.elasticsearch.client.RestClient; /* PUT index_user/_bu
2024-09-26
|
ZH
ElasticSearch根据SQL查询,SQL查询时 注意 列名(属性名) 区分大小写
2024-09-28
|
ZH
如果比较简单可以直接放到query方法参数中 如果exists比较复杂,如涉及到动态条件可以先构造RunPrepare
2024-09-28
|
ZH
group/order/having/exists都可以放在query参数中,与查询条件混在一块,如 service.query("SSO_USER AS M", "order by id desc", "group by type", "exists(SELECT * FROM HR_USER A
2024-10-07
|
ZH
复杂的查询以及非JDBC协议的数据源要通过 1.Table.aggregation() service.querys(table) Table table = new Table("TAB_AGG(DEPT_CODE, TYPE_CODE)"); table.aggregatio