本文整理了Java中org.jooq.Field.contains()
方法的一些代码示例,展示了Field.contains()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Field.contains()
方法的具体详情如下:
包路径:org.jooq.Field
类名称:Field
方法名:contains
[英]Convenience method for #like(String,char) including proper adding of wildcards and escaping.
SQL: this like ('%' || escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance val(1133).contains(13)
If you're using SQLDialect#POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example: ``
// Use this expression
val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 })
// ... to render this SQL
ARRAY[1, 2, 3] @> ARRAY[1, 2]
Note, this does not correspond to the Oracle Text CONTAINS()
function. Refer to OracleDSL#contains(Field,String) instead.
[中]#like(String,char)的简便方法,包括正确添加通配符和转义。
SQL:this like ('%' || escape(value, '\') || '%') escape '\'
注意:这也适用于数字,例如val(1133).contains(13)
如果您使用的是SQL方言#POSTGRES,那么还可以使用此方法来表示“ARRAY contains”操作符。例如:``
// Use this expression
val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 })
// ... to render this SQL
ARRAY[1, 2, 3] @> ARRAY[1, 2]
注意,这与Oracle文本CONTAINS()
函数不对应。请参考OracleDSL#contains(字段、字符串)。
代码示例来源:origin: com.walmartlabs.concord.server/concord-server
private void filterByMetaFilters(SelectQuery<Record> query, Map<String, String> filters) {
if (filters == null || filters.isEmpty()) {
return;
}
for (Map.Entry<String, String> e : filters.entrySet()) {
query.addConditions(jsonText(PROCESS_QUEUE.META, e.getKey()).contains(e.getValue()));
}
}
代码示例来源:origin: orientechnologies/spring-data-orientdb
protected Condition toCondition(Part part, Iterator<Object> iterator) {
String property = part.getProperty().toDotPath();
Field<Object> field = field(property);
switch (part.getType()) {
case AFTER:
case GREATER_THAN: return field.gt(iterator.next());
case GREATER_THAN_EQUAL: return field.ge(iterator.next());
case BEFORE:
case LESS_THAN: return field.lt(iterator.next());
case LESS_THAN_EQUAL: return field.le(iterator.next());
case BETWEEN: return field.between(iterator.next(), iterator.next());
case IS_NULL: return field.isNull();
case IS_NOT_NULL: return field.isNotNull();
case IN: return field.in(toList(iterator));
case NOT_IN: return field.notIn(toList(iterator));
case LIKE: return lowerIfIgnoreCase(part, field, iterator);
case NOT_LIKE: return lowerIfIgnoreCase(part, field, iterator).not();
case STARTING_WITH: return field.startsWith(iterator.next());
case ENDING_WITH: return field.endsWith(iterator.next());
case CONTAINING: return field.contains(iterator.next());
case SIMPLE_PROPERTY: return field.eq(iterator.next());
case NEGATING_SIMPLE_PROPERTY: return field.ne(iterator.next());
case TRUE: return field.eq(true);
case FALSE: return field.eq(false);
default: throw new IllegalArgumentException("Unsupported keyword!");
}
}
代码示例来源:origin: com.orientechnologies/spring-data-orientdb-commons
return field.endsWith(iterator.next());
case CONTAINING:
return field.contains(iterator.next());
case SIMPLE_PROPERTY:
return field.eq(iterator.next());
代码示例来源:origin: mevdschee/java-crud-api
switch (command) {
case "cs":
condition = field.contains(parts[2]);
break;
case "sw":
代码示例来源:origin: org.jooq/jooq
return toField(ctx, left).contains((Field) toField(ctx, parseConcat(ctx, null)));
内容来源于网络,如有侵权,请联系作者删除!