本文整理了Java中org.jooq.Field.notLike()
方法的一些代码示例,展示了Field.notLike()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Field.notLike()
方法的具体详情如下:
包路径:org.jooq.Field
类名称:Field
方法名:notLike
[英]Create a condition to pattern-check this field against a value.
SQL: this not like value
[中]创建一个条件,根据值对该字段进行模式检查。
SQL:this not like value
代码示例来源:origin: unipop-graph/unipop
private Condition getTextCondition(Object value, BiPredicate<?, ?> biPredicate, Field<Object> field) {
String predicateString = biPredicate.toString();
switch (predicateString) {
case ("LIKE"):
return field.like(value.toString().replace("*", "%"));
case ("UNLIKE"):
return field.notLike(value.toString().replace("*", "%"));
case ("REGEXP"):
return field.likeRegex(value.toString());
case ("UNREGEXP"):
return field.notLikeRegex(value.toString());
case ("PREFIX"):
return field.like(value.toString() + "%");
case ("UNPREFIX"):
return field.notLike(value.toString() + "%");
default:
throw new IllegalArgumentException("predicate not supported in has step: " + biPredicate.toString());
}
}
}
代码示例来源:origin: org.jooq/jooq-meta
@Override
protected List<SequenceDefinition> getSequences0() throws SQLException {
List<SequenceDefinition> result = new ArrayList<SequenceDefinition>();
for (Record record : create().select(
Sequences.SEQUENCE_SCHEMA,
Sequences.SEQUENCE_NAME)
.from(SEQUENCES)
.where(Sequences.SEQUENCE_SCHEMA.in(getInputSchemata()))
.and(Sequences.SEQUENCE_NAME.upper().notLike("SYSTEM!_SEQUENCE!_%", '!'))
.orderBy(
Sequences.SEQUENCE_SCHEMA,
Sequences.SEQUENCE_NAME)
.fetch()) {
SchemaDefinition schema = getSchema(record.get(Sequences.SEQUENCE_SCHEMA));
if (schema != null) {
String name = record.get(Sequences.SEQUENCE_NAME);
DefaultDataTypeDefinition type = new DefaultDataTypeDefinition(
this,
schema,
H2DataType.BIGINT.getTypeName()
);
result.add(new DefaultSequenceDefinition(schema, name, type));
}
}
return result;
}
代码示例来源:origin: org.jooq/jooq
return escape
? not
? ((Field) left).notLike(right, character)
: ((Field) left).like(right, character)
: not
? ((Field) left).notLike(right)
: ((Field) left).like(right);
内容来源于网络,如有侵权,请联系作者删除!