RdbPredicates

java.lang.Object
- ohos.data.rdb.AbsRdbPredicates
- - ohos.data.rdb.RdbPredicates

```
public class RdbPredicates
extends AbsRdbPredicates
```
Represents predicates of the relational database (RDB).
This class determines whether the value of conditional expressions in the RDB is true or false.

从以下版本开始:

1

SystemCapability

SystemCapability.Data#DATA_APPDATAMGR

构造器概要

构造器
构造器说明

RdbPredicates(String tableName)
A parameterized constructor used to create an RdbPredicates instance for searching RDB objects.

构造器
构造器	说明
`RdbPredicates(String tableName)`	A parameterized constructor used to create an `RdbPredicates` instance for searching RDB objects.

方法概要

所有方法实例方法具体方法
限定符和类型	方法	说明
`RdbPredicates`	`and()`	Adds an `and` condition to the predicate.
`RdbPredicates`	`beginsWith(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value starts with a specified string.
`RdbPredicates`	`beginWrap()`	Adds a left parenthesis to the predicate.
`RdbPredicates`	`between(String field, double low, double high)`	Configures the predicates to match the specified field whose data type is `double` and value is within a given range.
`RdbPredicates`	`between(String field, float low, float high)`	Configures the predicates to match the specified field whose data type is `float` and value is within a given range.
`RdbPredicates`	`between(String field, int low, int high)`	Configures the predicates to match the specified field whose data type is `int` and value is within a given range.
`RdbPredicates`	`between(String field, long low, long high)`	Configures the predicates to match the specified field whose data type is `long` and value is within a given range.
`RdbPredicates`	`between(String field, String low, String high)`	Configures the predicates to match the specified field whose data type is `String` and value is within a given range.
`RdbPredicates`	`between(String field, Time low, Time high)`	Configures the predicates to match the specified field whose data type is `Time` and value is within a given range.
`RdbPredicates`	`between(String field, Timestamp low, Timestamp high)`	Configures the predicates to match the specified field whose data type is `Timestamp` and value is within a given range.
`RdbPredicates`	`between(String field, Calendar low, Calendar high)`	Configures the predicates to match the specified field whose data type is `Calendar` and value is within a given range.
`RdbPredicates`	`between(String field, Date low, Date high)`	Configures the predicates to match the specified field whose data type is `Date` and value is within a given range.
`void`	`clear()`	Clears the search conditions of `RdbPredicates`.
`RdbPredicates`	`contains(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value contains a specified value.
`RdbPredicates`	`crossJoin(String tableName)`	Adds a `cross join` condition to a SQL statement.
`RdbPredicates`	`distinct()`	Configures the predicates to filter out duplicate records and retain only one of them.
`RdbPredicates`	`endsWith(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value ends with a specified string.
`RdbPredicates`	`endWrap()`	Adds a right parenthesis to the predicate.
`RdbPredicates`	`equalTo(String field, boolean value)`	Configures the predicates to match the field whose data type is `boolean` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, byte value)`	Configures the predicates to match the field whose data type is `byte` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, double value)`	Configures the predicates to match the field whose data type is `double` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, float value)`	Configures the predicates to match the field whose data type is `float` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, int value)`	Configures the predicates to match the field whose data type is `int` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, long value)`	Configures the predicates to match the field whose data type is `long` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, short value)`	Configures the predicates to match the field whose data type is `short` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, Time value)`	Configures the predicates to match the field whose data type is `Time` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, Timestamp value)`	Configures the predicates to match the field whose data type is `Timestamp` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, Calendar value)`	Configures the predicates to match the field whose data type is `Calendar` and value is equal to a specified value.
`RdbPredicates`	`equalTo(String field, Date value)`	Configures the predicates to match the field whose data type is `Date` and value is equal to a specified value.
`RdbPredicates`	`glob(String field, String value)`
`RdbPredicates`	`greaterThan(String field, double value)`	Configures the predicates to match the field whose data type is `double` and value is greater than a specified value.
`RdbPredicates`	`greaterThan(String field, float value)`	Configures the predicates to match the field whose data type is `float` and value is greater than a specified value.
`RdbPredicates`	`greaterThan(String field, int value)`	Configures the predicates to match the field whose data type is `int` and value is greater than a specified value.
`RdbPredicates`	`greaterThan(String field, long value)`	Configures the predicates to match the field whose data type is `long` and value is greater than a specified value.
`RdbPredicates`	`greaterThan(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value is greater than a specified value.
`RdbPredicates`	`greaterThan(String field, Time value)`	Configures the predicates to match the field whose data type is `Time` and value is greater than a specified value.
`RdbPredicates`	`greaterThan(String field, Timestamp value)`	Configures the predicates to match the field whose data type is `Timestamp` and value is greater than a specified value.
`RdbPredicates`	`greaterThan(String field, Calendar value)`	Configures the predicates to match the field whose data type is `Calendar` and value is greater than a specified value.
`RdbPredicates`	`greaterThan(String field, Date value)`	Configures the predicates to match the field whose data type is `Date` and value is greater than a specified value.
`RdbPredicates`	`greaterThanOrEqualTo(String field, double value)`	Configures the predicates to match the field whose data type is `double` and value is greater than or equal to a specified value.
`RdbPredicates`	`greaterThanOrEqualTo(String field, float value)`	Configures the predicates to match the field whose data type is `float` and value is greater than or equal to a specified value.
`RdbPredicates`	`greaterThanOrEqualTo(String field, int value)`	Configures the predicates to match the field whose data type is `int` and value is greater than or equal to a specified value.
`RdbPredicates`	`greaterThanOrEqualTo(String field, long value)`	Configures the predicates to match the field whose data type is `long` and value is greater than or equal to a specified value.
`RdbPredicates`	`greaterThanOrEqualTo(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value is greater than or equal to a specified value.
`RdbPredicates`	`greaterThanOrEqualTo(String field, Time value)`	Configures the predicates to match the field whose data type is `Time` and value is greater than or equal to a specified value.
`RdbPredicates`	`greaterThanOrEqualTo(String field, Timestamp value)`	Configures the predicates to match the field whose data type is `Timestamp` and value is greater than or equal to a specified value.
`RdbPredicates`	`greaterThanOrEqualTo(String field, Calendar value)`	Configures the predicates to match the field whose data type is `Calendar` and value is greater than or equal to a specified value.
`RdbPredicates`	`greaterThanOrEqualTo(String field, Date value)`	Configures the predicates to match the field whose data type is `Date` and value is greater than or equal to a specified value.
`RdbPredicates`	`groupBy(String[] fields)`	Configures `RdbPredicates` to group query results by specified columns.
`RdbPredicates`	`in(String field, double[] values)`	Configures `RdbPredicates` to match the specified field whose data type is double array and values are within a given range.
`RdbPredicates`	`in(String field, float[] values)`	Configures `RdbPredicates` to match the specified field whose data type is float array and values are within a given range.
`RdbPredicates`	`in(String field, int[] values)`	Configures `RdbPredicates` to match the specified field whose data type is int array and values are within a given range.
`RdbPredicates`	`in(String field, long[] values)`	Configures `RdbPredicates` to match the specified field whose data type is long array and values are within a given range.
`RdbPredicates`	`in(String field, String[] values)`	Configures `RdbPredicates` to match the specified field whose data type is String array and values are within a given range.
`RdbPredicates`	`in(String field, Time[] values)`	Configures `RdbPredicates` to match the specified field whose data type is Time array and values are within a given range.
`RdbPredicates`	`in(String field, Timestamp[] values)`	Configures `RdbPredicates` to match the specified field whose data type is Timestamp array and values are within a given range.
`RdbPredicates`	`in(String field, Calendar[] values)`	Configures `RdbPredicates` to match the specified field whose data type is Calendar array and values are within a given range.
`RdbPredicates`	`in(String field, Date[] values)`	Configures `RdbPredicates` to match the specified field whose data type is Date array and values are within a given range.
`RdbPredicates`	`indexedBy(String indexName)`	Configures `RdbPredicates` to specify the index column.
`RdbPredicates`	`innerJoin(String tableName)`	Adds an `inner join` condition to a SQL statement.
`RdbPredicates`	`isNotNull(String field)`	Configures the predicates to match the specified fields whose value is not `null`.
`RdbPredicates`	`isNull(String field)`	Configures the predicates to match the fields whose value is `null`.
`RdbPredicates`	`leftOuterJoin(String tableName)`	Adds a `left outer join` condition to a SQL statement.
`RdbPredicates`	`lessThan(String field, double value)`	Configures the predicates to match the field whose data type is `double` and value is less than a specified value.
`RdbPredicates`	`lessThan(String field, float value)`	Configures the predicates to match the field whose data type is `float` and value is less than a specified value.
`RdbPredicates`	`lessThan(String field, int value)`	Configures the predicates to match the field whose data type is `int` and value is less than a specified value.
`RdbPredicates`	`lessThan(String field, long value)`	Configures the predicates to match the field whose data type is `long` and value is less than a specified value.
`RdbPredicates`	`lessThan(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value is less than a specified value.
`RdbPredicates`	`lessThan(String field, Time value)`	Configures the predicates to match the field whose data type is `Time` and value is less than a specified value.
`RdbPredicates`	`lessThan(String field, Timestamp value)`	Configures the predicates to match the field whose data type is `Timestamp` and value is less than a specified value.
`RdbPredicates`	`lessThan(String field, Calendar value)`	Configures the predicates to match the field whose data type is `Calendar` and value is less than a specified value.
`RdbPredicates`	`lessThan(String field, Date value)`	Configures the predicates to match the field whose data type is `Date` and value is less than a specified value.
`RdbPredicates`	`lessThanOrEqualTo(String field, double value)`	Configures the predicates to match the field whose data type is `double` and value is less than or equal to a specified value.
`RdbPredicates`	`lessThanOrEqualTo(String field, float value)`	Configures the predicates to match the field whose data type is `float` and value is less than or equal to a specified value.
`RdbPredicates`	`lessThanOrEqualTo(String field, int value)`	Configures the predicates to match the field whose data type is `int` and value is less than or equal to a specified value.
`RdbPredicates`	`lessThanOrEqualTo(String field, long value)`	Configures the predicates to match the field whose data type is `long` and value is less than or equal to a specified value.
`RdbPredicates`	`lessThanOrEqualTo(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value is less than or equal to a specified value.
`RdbPredicates`	`lessThanOrEqualTo(String field, Time value)`	Configures the predicates to match the field whose data type is `Time` and value is less than or equal to a specified value.
`RdbPredicates`	`lessThanOrEqualTo(String field, Timestamp value)`	Configures the predicates to match the field whose data type is `Timestamp` and value is less than or equal to a specified value.
`RdbPredicates`	`lessThanOrEqualTo(String field, Calendar value)`	Configures the predicates to match the field whose data type is `Calendar` and value is less than or equal to a specified value.
`RdbPredicates`	`lessThanOrEqualTo(String field, Date value)`	Configures the predicates to match the field whose data type is `Date` and value is less than or equal to a specified value.
`RdbPredicates`	`like(String field, String value)`	Configures the predicates to match the fields whose data type is `String` and value is similar to a specified string.
`RdbPredicates`	`limit(int value)`	Sets the maximum number of data records in the column that match the specified predicates.
`RdbPredicates`	`notBetween(String field, double low, double high)`	Configures `RdbPredicates` to match the specified field whose data type is double and value is out of a given range.
`RdbPredicates`	`notBetween(String field, float low, float high)`	Configures `RdbPredicates` to match the specified field whose data type is float and value is out of a given range.
`RdbPredicates`	`notBetween(String field, int low, int high)`	Configures `RdbPredicates` to match the specified field whose data type is int and value is out of a given range.
`RdbPredicates`	`notBetween(String field, long low, long high)`	Configures `RdbPredicates` to match the specified field whose data type is long and value is out of a given range.
`RdbPredicates`	`notBetween(String field, String low, String high)`
`RdbPredicates`	`notBetween(String field, Time low, Time high)`	Configures `RdbPredicates` to match the specified field whose data type is Time and value is out of a given range.
`RdbPredicates`	`notBetween(String field, Timestamp low, Timestamp high)`	Configures `RdbPredicates` to match the specified field whose data type is Timestamp and value is out of a given range.
`RdbPredicates`	`notBetween(String field, Calendar low, Calendar high)`	Configures `RdbPredicates` to match the specified field whose data type is Calendar and value is out of a given range.
`RdbPredicates`	`notBetween(String field, Date low, Date high)`	Configures `RdbPredicates` to match the specified field whose data type is Date and value is out of a given range.
`RdbPredicates`	`notEqualTo(String field, boolean value)`	Configures the predicates to match the field whose data type is `boolean` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, byte value)`	Configures the predicates to match the field whose data type is `byte` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, double value)`	Configures the predicates to match the field whose data type is `double` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, float value)`	Configures the predicates to match the field whose data type is `float` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, int value)`	Configures the predicates to match the field whose data type is `int` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, long value)`	Configures the predicates to match the field whose data type is `long` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, short value)`	Configures the predicates to match the field whose data type is `short` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, Time value)`	Configures the predicates to match the field whose data type is `Time` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, Timestamp value)`	Configures the predicates to match the field whose data type is `Timestamp` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, Calendar value)`	Configures the predicates to match the field whose data type is `Calendar` and value is unequal to a specified value.
`RdbPredicates`	`notEqualTo(String field, Date value)`	Configures the predicates to match the field whose data type is `Date` and value is unequal to a specified value.
`RdbPredicates`	`notIn(String field, double[] values)`	Configures `RdbPredicates` to match the specified field whose data type is double array and values are out of a given range.
`RdbPredicates`	`notIn(String field, float[] values)`	Configures `RdbPredicates` to match the specified field whose data type is float array and values are out of a given range.
`RdbPredicates`	`notIn(String field, int[] values)`	Configures `RdbPredicates` to match the specified field whose data type is int array and values are out of a given range.
`RdbPredicates`	`notIn(String field, long[] values)`	Configures `RdbPredicates` to match the specified field whose data type is long array and values are out of a given range.
`RdbPredicates`	`notIn(String field, String[] values)`	Configures `RdbPredicates` to match the specified field whose data type is String array and values are out of a given range.
`RdbPredicates`	`notIn(String field, Time[] values)`	Configures `RdbPredicates` to match the specified field whose data type is Time array and values are out of a given range.
`RdbPredicates`	`notIn(String field, Timestamp[] values)`	Configures `RdbPredicates` to match the specified field whose data type is Timestamp array and values are out of a given range.
`RdbPredicates`	`notIn(String field, Calendar[] values)`	Configures `RdbPredicates` to match the specified field whose data type is Calendar array and values are out of a given range.
`RdbPredicates`	`notIn(String field, Date[] values)`	Configures `RdbPredicates` to match the specified field whose data type is Date array and values are out of a given range.
`RdbPredicates`	`offset(int rowOffset)`	Configures `RdbPredicates` to specify the start position of the returned result.
`RdbPredicates`	`on(String... clauses)`	Adds an `on` condition to the predicate.
`RdbPredicates`	`or()`	Adds an `or` condition to the predicate.
`RdbPredicates`	`orderByAsc(String field)`	Configures the predicates to match the columns whose values are sorted in ascending order.
`RdbPredicates`	`orderByDesc(String field)`	Configures the predicates to match the columns whose values are sorted in descending order.
`RdbPredicates`	`using(String... fields)`	Adds a `using` condition to the predicate.

从类继承的方法 ohos.data.rdb.AbsRdbPredicates
getTableName

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- 构造器详细资料
  - RdbPredicates
```
public RdbPredicates(String tableName)
```
    A parameterized constructor used to create an RdbPredicates instance for searching RDB objects.
    
    参数:
    
    tableName - Indicates the table name of the database.
- 方法详细资料
  - clear
```
public void clear()
```
    Clears the search conditions of RdbPredicates.
    This method retains only the value of private attribute tableName in RdbPredicates and restores other private attributes to their default values.
    
    覆盖:
    
    clear 在类中 AbsRdbPredicates
  - equalTo
```
public RdbPredicates equalTo(String field,
                             byte value)
```
    Configures the predicates to match the field whose data type is byte and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             short value)
```
    Configures the predicates to match the field whose data type is short and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             int value)
```
    Configures the predicates to match the field whose data type is int and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             long value)
```
    Configures the predicates to match the field whose data type is long and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             double value)
```
    Configures the predicates to match the field whose data type is double and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             float value)
```
    Configures the predicates to match the field whose data type is float and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             boolean value)
```
    Configures the predicates to match the field whose data type is boolean and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             Date value)
```
    Configures the predicates to match the field whose data type is Date and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             Time value)
```
    Configures the predicates to match the field whose data type is Time and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             Timestamp value)
```
    Configures the predicates to match the field whose data type is Timestamp and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             Calendar value)
```
    Configures the predicates to match the field whose data type is Calendar and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - equalTo
```
public RdbPredicates equalTo(String field,
                             String value)
```
    Configures the predicates to match the field whose data type is String and value is equal to a specified value.
    This method is similar to = of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                byte value)
```
    Configures the predicates to match the field whose data type is byte and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                short value)
```
    Configures the predicates to match the field whose data type is short and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                int value)
```
    Configures the predicates to match the field whose data type is int and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                long value)
```
    Configures the predicates to match the field whose data type is long and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                double value)
```
    Configures the predicates to match the field whose data type is double and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                float value)
```
    Configures the predicates to match the field whose data type is float and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                boolean value)
```
    Configures the predicates to match the field whose data type is boolean and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                Date value)
```
    Configures the predicates to match the field whose data type is Date and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                Time value)
```
    Configures the predicates to match the field whose data type is Time and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                Timestamp value)
```
    Configures the predicates to match the field whose data type is Timestamp and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                Calendar value)
```
    Configures the predicates to match the field whose data type is Calendar and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notEqualTo
```
public RdbPredicates notEqualTo(String field,
                                String value)
```
    Configures the predicates to match the field whose data type is String and value is unequal to a specified value.
    This method is similar to != of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - beginWrap
```
public RdbPredicates beginWrap()
```
    Adds a left parenthesis to the predicate.
    This method is similar to ( of the SQL statement and needs to be used together with endWrap().
    
    返回:
    
    Returns the predicate with the left parenthesis.
  - endWrap
```
public RdbPredicates endWrap()
```
    Adds a right parenthesis to the predicate.
    This method is similar to ) of the SQL statement and needs to be used together with beginWrap().
    
    返回:
    
    Returns the predicate with the right parenthesis.
  - or
```
public RdbPredicates or()
```
    Adds an or condition to the predicate.
    This method is similar to or of the SQL statement.
    
    返回:
    
    Returns the predicate with the or condition.
  - and
```
public RdbPredicates and()
```
    Adds an and condition to the predicate.
    This method is similar to and of the SQL statement.
    
    返回:
    
    Returns the predicate with the and condition.
  - contains
```
public RdbPredicates contains(String field,
                              String value)
```
    Configures the predicates to match the field whose data type is String and value contains a specified value.
    This method is similar to contains of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - beginsWith
```
public RdbPredicates beginsWith(String field,
                                String value)
```
    Configures the predicates to match the field whose data type is String and value starts with a specified string.
    This method is similar to value% of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - endsWith
```
public RdbPredicates endsWith(String field,
                              String value)
```
    Configures the predicates to match the field whose data type is String and value ends with a specified string.
    This method is similar to %value of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - isNull
```
public RdbPredicates isNull(String field)
```
    Configures the predicates to match the fields whose value is null.
    This method is similar to is null of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    返回:
    
    Returns the predicates that match the specified field.
  - isNotNull
```
public RdbPredicates isNotNull(String field)
```
    Configures the predicates to match the specified fields whose value is not null.
    This method is similar to is not null of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    返回:
    
    Returns the predicates that match the specified field.
  - like
```
public RdbPredicates like(String field,
                          String value)
```
    Configures the predicates to match the fields whose data type is String and value is similar to a specified string.
    This method is similar to like of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates. The percent sign (%) in the value is a wildcard (like * in a regular expression).
    
    返回:
    
    Returns the predicates that match the specified field.
  - glob
```
public RdbPredicates glob(String field,
                          String value)
```
  - between
```
public RdbPredicates between(String field,
                             int low,
                             int high)
```
    Configures the predicates to match the specified field whose data type is int and value is within a given range.
    This method is similar to between of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with the predicates.
    
    high - Indicates the maximum value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - between
```
public RdbPredicates between(String field,
                             long low,
                             long high)
```
    Configures the predicates to match the specified field whose data type is long and value is within a given range.
    This method is similar to between of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with the predicates.
    
    high - Indicates the maximum value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - between
```
public RdbPredicates between(String field,
                             double low,
                             double high)
```
    Configures the predicates to match the specified field whose data type is double and value is within a given range.
    This method is similar to between of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with the predicates.
    
    high - Indicates the maximum value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - between
```
public RdbPredicates between(String field,
                             float low,
                             float high)
```
    Configures the predicates to match the specified field whose data type is float and value is within a given range.
    This method is similar to between of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with the predicates.
    
    high - Indicates the maximum value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - between
```
public RdbPredicates between(String field,
                             Date low,
                             Date high)
```
    Configures the predicates to match the specified field whose data type is Date and value is within a given range.
    This method is similar to between of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with the predicates.
    
    high - Indicates the maximum value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - between
```
public RdbPredicates between(String field,
                             Time low,
                             Time high)
```
    Configures the predicates to match the specified field whose data type is Time and value is within a given range.
    This method is similar to between of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with the predicates.
    
    high - Indicates the maximum value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - between
```
public RdbPredicates between(String field,
                             Timestamp low,
                             Timestamp high)
```
    Configures the predicates to match the specified field whose data type is Timestamp and value is within a given range.
    This method is similar to between of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with the predicates.
    
    high - Indicates the maximum value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - between
```
public RdbPredicates between(String field,
                             Calendar low,
                             Calendar high)
```
    Configures the predicates to match the specified field whose data type is Calendar and value is within a given range.
    This method is similar to between of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with the predicates.
    
    high - Indicates the maximum value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - between
```
public RdbPredicates between(String field,
                             String low,
                             String high)
```
    Configures the predicates to match the specified field whose data type is String and value is within a given range.
    This method is similar to between of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with the predicates.
    
    high - Indicates the maximum value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - notBetween
```
public RdbPredicates notBetween(String field,
                                int low,
                                int high)
```
    Configures RdbPredicates to match the specified field whose data type is int and value is out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with RdbPredicates.
    
    high - Indicates the maximum value to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public RdbPredicates notBetween(String field,
                                long low,
                                long high)
```
    Configures RdbPredicates to match the specified field whose data type is long and value is out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with RdbPredicates.
    
    high - Indicates the maximum value to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public RdbPredicates notBetween(String field,
                                double low,
                                double high)
```
    Configures RdbPredicates to match the specified field whose data type is double and value is out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with RdbPredicates.
    
    high - Indicates the maximum value to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public RdbPredicates notBetween(String field,
                                float low,
                                float high)
```
    Configures RdbPredicates to match the specified field whose data type is float and value is out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with RdbPredicates.
    
    high - Indicates the maximum value to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public RdbPredicates notBetween(String field,
                                Date low,
                                Date high)
```
    Configures RdbPredicates to match the specified field whose data type is Date and value is out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with RdbPredicates.
    
    high - Indicates the maximum value to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public RdbPredicates notBetween(String field,
                                Time low,
                                Time high)
```
    Configures RdbPredicates to match the specified field whose data type is Time and value is out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with RdbPredicates.
    
    high - Indicates the maximum value to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public RdbPredicates notBetween(String field,
                                Timestamp low,
                                Timestamp high)
```
    Configures RdbPredicates to match the specified field whose data type is Timestamp and value is out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with RdbPredicates.
    
    high - Indicates the maximum value to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public RdbPredicates notBetween(String field,
                                Calendar low,
                                Calendar high)
```
    Configures RdbPredicates to match the specified field whose data type is Calendar and value is out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    low - Indicates the minimum value to match with RdbPredicates.
    
    high - Indicates the maximum value to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public RdbPredicates notBetween(String field,
                                String low,
                                String high)
```
  - greaterThan
```
public RdbPredicates greaterThan(String field,
                                 int value)
```
    Configures the predicates to match the field whose data type is int and value is greater than a specified value.
    This method is similar to > of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThan
```
public RdbPredicates greaterThan(String field,
                                 long value)
```
    Configures the predicates to match the field whose data type is long and value is greater than a specified value.
    This method is similar to > of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThan
```
public RdbPredicates greaterThan(String field,
                                 double value)
```
    Configures the predicates to match the field whose data type is double and value is greater than a specified value.
    This method is similar to > of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThan
```
public RdbPredicates greaterThan(String field,
                                 float value)
```
    Configures the predicates to match the field whose data type is float and value is greater than a specified value.
    This method is similar to > of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThan
```
public RdbPredicates greaterThan(String field,
                                 Date value)
```
    Configures the predicates to match the field whose data type is Date and value is greater than a specified value.
    This method is similar to > of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThan
```
public RdbPredicates greaterThan(String field,
                                 Time value)
```
    Configures the predicates to match the field whose data type is Time and value is greater than a specified value.
    This method is similar to > of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThan
```
public RdbPredicates greaterThan(String field,
                                 Timestamp value)
```
    Configures the predicates to match the field whose data type is Timestamp and value is greater than a specified value.
    This method is similar to > of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThan
```
public RdbPredicates greaterThan(String field,
                                 Calendar value)
```
    Configures the predicates to match the field whose data type is Calendar and value is greater than a specified value.
    This method is similar to > of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThan
```
public RdbPredicates greaterThan(String field,
                                 String value)
```
    Configures the predicates to match the field whose data type is String and value is greater than a specified value.
    This method is similar to > of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThan
```
public RdbPredicates lessThan(String field,
                              int value)
```
    Configures the predicates to match the field whose data type is int and value is less than a specified value.
    This method is similar to < of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThan
```
public RdbPredicates lessThan(String field,
                              long value)
```
    Configures the predicates to match the field whose data type is long and value is less than a specified value.
    This method is similar to < of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThan
```
public RdbPredicates lessThan(String field,
                              double value)
```
    Configures the predicates to match the field whose data type is double and value is less than a specified value.
    This method is similar to < of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThan
```
public RdbPredicates lessThan(String field,
                              float value)
```
    Configures the predicates to match the field whose data type is float and value is less than a specified value.
    This method is similar to < of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThan
```
public RdbPredicates lessThan(String field,
                              Date value)
```
    Configures the predicates to match the field whose data type is Date and value is less than a specified value.
    This method is similar to < of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThan
```
public RdbPredicates lessThan(String field,
                              Time value)
```
    Configures the predicates to match the field whose data type is Time and value is less than a specified value.
    This method is similar to < of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThan
```
public RdbPredicates lessThan(String field,
                              Timestamp value)
```
    Configures the predicates to match the field whose data type is Timestamp and value is less than a specified value.
    This method is similar to < of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThan
```
public RdbPredicates lessThan(String field,
                              Calendar value)
```
    Configures the predicates to match the field whose data type is Calendar and value is less than a specified value.
    This method is similar to < of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThan
```
public RdbPredicates lessThan(String field,
                              String value)
```
    Configures the predicates to match the field whose data type is String and value is less than a specified value.
    This method is similar to < of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThanOrEqualTo
```
public RdbPredicates greaterThanOrEqualTo(String field,
                                          int value)
```
    Configures the predicates to match the field whose data type is int and value is greater than or equal to a specified value.
    This method is similar to >= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThanOrEqualTo
```
public RdbPredicates greaterThanOrEqualTo(String field,
                                          long value)
```
    Configures the predicates to match the field whose data type is long and value is greater than or equal to a specified value.
    This method is similar to >= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThanOrEqualTo
```
public RdbPredicates greaterThanOrEqualTo(String field,
                                          double value)
```
    Configures the predicates to match the field whose data type is double and value is greater than or equal to a specified value.
    This method is similar to >= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThanOrEqualTo
```
public RdbPredicates greaterThanOrEqualTo(String field,
                                          float value)
```
    Configures the predicates to match the field whose data type is float and value is greater than or equal to a specified value.
    This method is similar to >= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThanOrEqualTo
```
public RdbPredicates greaterThanOrEqualTo(String field,
                                          Date value)
```
    Configures the predicates to match the field whose data type is Date and value is greater than or equal to a specified value.
    This method is similar to >= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThanOrEqualTo
```
public RdbPredicates greaterThanOrEqualTo(String field,
                                          Time value)
```
    Configures the predicates to match the field whose data type is Time and value is greater than or equal to a specified value.
    This method is similar to >= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThanOrEqualTo
```
public RdbPredicates greaterThanOrEqualTo(String field,
                                          Timestamp value)
```
    Configures the predicates to match the field whose data type is Timestamp and value is greater than or equal to a specified value.
    This method is similar to >= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThanOrEqualTo
```
public RdbPredicates greaterThanOrEqualTo(String field,
                                          Calendar value)
```
    Configures the predicates to match the field whose data type is Calendar and value is greater than or equal to a specified value.
    This method is similar to >= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - greaterThanOrEqualTo
```
public RdbPredicates greaterThanOrEqualTo(String field,
                                          String value)
```
    Configures the predicates to match the field whose data type is String and value is greater than or equal to a specified value.
    This method is similar to >= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThanOrEqualTo
```
public RdbPredicates lessThanOrEqualTo(String field,
                                       int value)
```
    Configures the predicates to match the field whose data type is int and value is less than or equal to a specified value.
    This method is similar to <= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThanOrEqualTo
```
public RdbPredicates lessThanOrEqualTo(String field,
                                       long value)
```
    Configures the predicates to match the field whose data type is long and value is less than or equal to a specified value.
    This method is similar to <= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThanOrEqualTo
```
public RdbPredicates lessThanOrEqualTo(String field,
                                       double value)
```
    Configures the predicates to match the field whose data type is double and value is less than or equal to a specified value.
    This method is similar to <= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThanOrEqualTo
```
public RdbPredicates lessThanOrEqualTo(String field,
                                       float value)
```
    Configures the predicates to match the field whose data type is float and value is less than or equal to a specified value.
    This method is similar to <= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThanOrEqualTo
```
public RdbPredicates lessThanOrEqualTo(String field,
                                       Date value)
```
    Configures the predicates to match the field whose data type is Date and value is less than or equal to a specified value.
    This method is similar to <= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThanOrEqualTo
```
public RdbPredicates lessThanOrEqualTo(String field,
                                       Time value)
```
    Configures the predicates to match the field whose data type is Time and value is less than or equal to a specified value.
    This method is similar to <= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThanOrEqualTo
```
public RdbPredicates lessThanOrEqualTo(String field,
                                       Timestamp value)
```
    Configures the predicates to match the field whose data type is Timestamp and value is less than or equal to a specified value.
    This method is similar to <= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThanOrEqualTo
```
public RdbPredicates lessThanOrEqualTo(String field,
                                       Calendar value)
```
    Configures the predicates to match the field whose data type is Calendar and value is less than or equal to a specified value.
    This method is similar to <= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - lessThanOrEqualTo
```
public RdbPredicates lessThanOrEqualTo(String field,
                                       String value)
```
    Configures the predicates to match the field whose data type is String and value is less than or equal to a specified value.
    This method is similar to <= of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    value - Indicates the value to match with the predicates.
    
    返回:
    
    Returns the predicates that match the specified field.
  - orderByAsc
```
public RdbPredicates orderByAsc(String field)
```
    Configures the predicates to match the columns whose values are sorted in ascending order.
    This method is similar to order by field asc of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    返回:
    
    Returns the predicates that match the specified columns.
  - orderByDesc
```
public RdbPredicates orderByDesc(String field)
```
    Configures the predicates to match the columns whose values are sorted in descending order.
    This method is similar to order by field desc of the SQL statement.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    返回:
    
    Returns the predicates that match the specified columns.
  - distinct
```
public RdbPredicates distinct()
```
    Configures the predicates to filter out duplicate records and retain only one of them.
    This method is similar to distinct of the SQL statement.
    
    返回:
    
    Returns the predicates that can be used to filter out duplicate records.
  - limit
```
public RdbPredicates limit(int value)
```
    Sets the maximum number of data records in the column that match the specified predicates.
    This method is similar to limit of the SQL statement.
    
    参数:
    
    value - Indicates the maximum number of data records.
    
    返回:
    
    Returns the predicates that can be used to set the maximum number of data records.
  - offset
```
public RdbPredicates offset(int rowOffset)
```
    Configures RdbPredicates to specify the start position of the returned result.
    Use this method together with RdbPredicates#limit(int).
    
    参数:
    
    rowOffset - Indicates the start position of the returned result. The value is a positive integer.
    
    返回:
    
    Returns RdbPredicates with the specified start position of the returned result.
    
    从以下版本开始:
    
    3
    
    另请参阅:
    
    limit(int)
  - groupBy
```
public RdbPredicates groupBy(String[] fields)
```
    Configures RdbPredicates to group query results by specified columns.
    
    参数:
    
    fields - Indicates the specified columns by which query results are grouped.
    
    返回:
    
    Returns RdbPredicates with the specified columns by which query results are grouped.
    
    从以下版本开始:
    
    3
  - indexedBy
```
public RdbPredicates indexedBy(String indexName)
```
    Configures RdbPredicates to specify the index column.
    before using this method, you need to create an index column.
    
    参数:
    
    indexName - Indicates the name of the index column.
    
    返回:
    
    Returns RdbPredicates with the specified index column.
    
    从以下版本开始:
    
    3
  - in
```
public RdbPredicates in(String field,
                        int[] values)
```
    Configures RdbPredicates to match the specified field whose data type is int array and values are within a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public RdbPredicates in(String field,
                        long[] values)
```
    Configures RdbPredicates to match the specified field whose data type is long array and values are within a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public RdbPredicates in(String field,
                        double[] values)
```
    Configures RdbPredicates to match the specified field whose data type is double array and values are within a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public RdbPredicates in(String field,
                        float[] values)
```
    Configures RdbPredicates to match the specified field whose data type is float array and values are within a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public RdbPredicates in(String field,
                        Date[] values)
```
    Configures RdbPredicates to match the specified field whose data type is Date array and values are within a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public RdbPredicates in(String field,
                        Time[] values)
```
    Configures RdbPredicates to match the specified field whose data type is Time array and values are within a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public RdbPredicates in(String field,
                        Timestamp[] values)
```
    Configures RdbPredicates to match the specified field whose data type is Timestamp array and values are within a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public RdbPredicates in(String field,
                        Calendar[] values)
```
    Configures RdbPredicates to match the specified field whose data type is Calendar array and values are within a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public RdbPredicates in(String field,
                        String[] values)
```
    Configures RdbPredicates to match the specified field whose data type is String array and values are within a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public RdbPredicates notIn(String field,
                           int[] values)
```
    Configures RdbPredicates to match the specified field whose data type is int array and values are out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public RdbPredicates notIn(String field,
                           long[] values)
```
    Configures RdbPredicates to match the specified field whose data type is long array and values are out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public RdbPredicates notIn(String field,
                           double[] values)
```
    Configures RdbPredicates to match the specified field whose data type is double array and values are out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public RdbPredicates notIn(String field,
                           float[] values)
```
    Configures RdbPredicates to match the specified field whose data type is float array and values are out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public RdbPredicates notIn(String field,
                           Date[] values)
```
    Configures RdbPredicates to match the specified field whose data type is Date array and values are out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public RdbPredicates notIn(String field,
                           Time[] values)
```
    Configures RdbPredicates to match the specified field whose data type is Time array and values are out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public RdbPredicates notIn(String field,
                           Timestamp[] values)
```
    Configures RdbPredicates to match the specified field whose data type is Timestamp array and values are out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public RdbPredicates notIn(String field,
                           Calendar[] values)
```
    Configures RdbPredicates to match the specified field whose data type is Calendar array and values are out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public RdbPredicates notIn(String field,
                           String[] values)
```
    Configures RdbPredicates to match the specified field whose data type is String array and values are out of a given range.
    
    参数:
    
    field - Indicates the column name in the database table.
    
    values - Indicates the values to match with RdbPredicates.
    
    返回:
    
    Returns RdbPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - crossJoin
```
public RdbPredicates crossJoin(String tableName)
```
    Adds a cross join condition to a SQL statement.
    In SQLite, you can use cross joins to associate two unrelated tables. The cross join joins every row from the first table with every row from the second table, and the result set is the product of rows in both tables. Exercise caution when using cross joins during application development because they will exert heavy load on memory and subsequent data processing.
    
    参数:
    
    tableName - Indicates the names of the tables to join.
    
    返回:
    
    Returns the predicate with the cross join condition.
  - innerJoin
```
public RdbPredicates innerJoin(String tableName)
```
    Adds an inner join condition to a SQL statement.
    In SQLite, you can use inner joins to query data from two related tables. The inner join selects all the rows to display in the result set from the related tables only if both tables meet the conditions specified in the ON clause. The inner joins are syntactically equivalent to the cross joins. Note that inner joins must be used together with RdbPredicates#on(String...). Otherwise, use RdbPredicates#crossJoin(String) instead.
    
    参数:
    
    tableName - Indicates the names of the tables to join.
    
    返回:
    
    Returns the predicate with the inner join condition.
  - leftOuterJoin
```
public RdbPredicates leftOuterJoin(String tableName)
```
    Adds a left outer join condition to a SQL statement.
    The left join or left outer join allows you to query data from tables A and B and returns the inner joins between A and B and the unmatched rows of A. A is the first join defined in the clause, and is therefore left join.
    
    参数:
    
    tableName - Indicates the names of the tables to join.
    
    返回:
    
    Returns the predicate with the left outer join condition.
  - using
```
public RdbPredicates using(String... fields)
```
    Adds a using condition to the predicate. This method is similar to using of the SQL statement.
    using is the abbreviation of the specified join condition in the left join RdbPredicates#leftOuterJoin or inner join RdbPredicates#innerJoin. When adding the using condition, ensure that the specified columns exist in both tables.
    
    参数:
    
    fields - Indicates the column names in the database table.
    
    返回:
    
    Returns the predicate with the using condition.
  - on
```
public RdbPredicates on(String... clauses)
```
    Adds an on condition to the predicate.
    on is used to set the join conditions of multiple tables when obtaining the join type. It is used with the left join RdbPredicates#leftOuterJoin or inner join RdbPredicates#innerJoin.
    
    参数:
    
    clauses - Indicates the conditions of the join clauses.
    
    返回:
    
    Returns the predicate with the on condition.

类 RdbPredicates

构造器概要

方法概要

从类继承的方法 ohos.data.rdb.AbsRdbPredicates

从类继承的方法 java.lang.Object

构造器详细资料

RdbPredicates

方法详细资料

clear

equalTo

equalTo

equalTo

equalTo

equalTo

equalTo

equalTo

equalTo

equalTo

equalTo

equalTo

equalTo

notEqualTo

notEqualTo

notEqualTo

notEqualTo

notEqualTo

notEqualTo

notEqualTo

notEqualTo

notEqualTo

notEqualTo

notEqualTo

notEqualTo

beginWrap

endWrap

or

and

contains

beginsWith

endsWith

isNull

isNotNull

like

glob

between

between

between

between

between

between

between

between

between

notBetween

notBetween

notBetween

notBetween

notBetween

notBetween

notBetween

notBetween

notBetween

greaterThan

greaterThan

greaterThan

greaterThan

greaterThan

greaterThan

greaterThan

greaterThan

greaterThan

lessThan

lessThan

lessThan

lessThan

lessThan

lessThan

lessThan

lessThan

lessThan