org.jooq.Field.notLike()方法的使用及代码示例

x33g5p2x  于2022-01-19 转载在 其他  
字(2.1k)|赞(0)|评价(0)|浏览(133)

本文整理了Java中org.jooq.Field.notLike()方法的一些代码示例,展示了Field.notLike()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Field.notLike()方法的具体详情如下:
包路径:org.jooq.Field
类名称:Field
方法名:notLike

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);

相关文章