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-09-28
|
ZH
如果比较简单可以直接放到query方法参数中 如果exists比较复杂,如涉及到动态条件可以先构造RunPrepare
2024-09-26
|
ZH
ElasticSearch根据SQL查询,SQL查询时 注意 列名(属性名) 区分大小写
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-25
|
ZH
List<Object> ids = new ArrayList<>(); ids.add(1); ids.add(2); ServiceProxy.delete("crm_user", ids);
2024-09-25
|
ZH
DataRow row = new ElasticSearchRow(); row.put("_id" ,123);//指定主键值 ServiceProxy.delete(table_name, row);
2024-09-25
|
ZH
与insert规则一样,需要有主键值,底层都是调用一样的POST接口 DataRow row = new ElasticSearchRow(); row.put("pub_ymd", DateUtil.format("yyyy-MM-dd")); row.put("read_qty", 123456