OrmPredicates

java.lang.Object
- ohos.data.orm.OrmPredicates

```
public class OrmPredicates
extends Object
```
Represents predicates of the object-relational mapping (ORM) database.
This class determines whether the value of conditional expressions in the ORM database is true or false.

从以下版本开始:

1

SystemCapability

SystemCapability.Data#DATA_APPDATAMGR

构造器概要

构造器
构造器说明

OrmPredicates(Class<T> klass)
A parameterized constructor used to create an OrmPredicates instance for searching ORM objects.

构造器
构造器	说明
`OrmPredicates(Class<T> klass)`	A parameterized constructor used to create an `OrmPredicates` instance for searching ORM objects.

方法概要

所有方法实例方法具体方法
限定符和类型	方法	说明
`OrmPredicates`	`and()`	Adds an `and` condition to the predicate.
`OrmPredicates`	`beginsWith(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value starts with a specified string.
`OrmPredicates`	`beginWrap()`	Adds a left parenthesis to the predicate.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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 `OrmPredicates`.
`OrmPredicates`	`contains(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value contains a specified value.
`<J extends OrmObject> OrmPredicates`	`crossJoin(Class<J> clz)`	Adds a `cross join` condition to a SQL statement.
`OrmPredicates`	`distinct()`	Configures the predicates to filter out duplicate records and retain only one of them.
`OrmPredicates`	`endsWith(String field, String value)`	Configures the predicates to match the field whose data type is `String` and value ends with a specified string.
`OrmPredicates`	`endWrap()`	Adds a right parenthesis to the predicate.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`String`	`getEntityName()`	Obtains the value of variable `entityName`.
`OrmPredicates`	`glob(String field, String value)`
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`groupBy(String[] fields)`	Configures `OrmPredicates` to group query results by specified columns.
`OrmPredicates`	`in(String field, double[] values)`	Configures `OrmPredicates` to match the specified field whose data type is double array and values are within a given range.
`OrmPredicates`	`in(String field, float[] values)`	Configures `OrmPredicates` to match the specified field whose data type is float array and values are within a given range.
`OrmPredicates`	`in(String field, int[] values)`	Configures `OrmPredicates` to match the specified field whose data type is int array and values are within a given range.
`OrmPredicates`	`in(String field, long[] values)`	Configures `OrmPredicates` to match the specified field whose data type is long array and values are within a given range.
`OrmPredicates`	`in(String field, String[] values)`	Configures `OrmPredicates` to match the specified field whose data type is String array and values are within a given range.
`OrmPredicates`	`in(String field, Time[] values)`	Configures `OrmPredicates` to match the specified field whose data type is Time array and values are within a given range.
`OrmPredicates`	`in(String field, Timestamp[] values)`	Configures `OrmPredicates` to match the specified field whose data type is Timestamp array and values are within a given range.
`OrmPredicates`	`in(String field, Calendar[] values)`	Configures `OrmPredicates` to match the specified field whose data type is Calendar array and values are within a given range.
`OrmPredicates`	`in(String field, Date[] values)`	Configures `OrmPredicates` to match the specified field whose data type is Date array and values are within a given range.
`OrmPredicates`	`indexedBy(String indexName)`	Configures `OrmPredicates` to specify the index column.
`<J extends OrmObject> OrmPredicates`	`innerJoin(Class<J> clz)`	Adds an `inner join` condition to a SQL statement.
`OrmPredicates`	`isNotNull(String field)`	Configures the predicates to match the specified fields whose value is not `null`.
`OrmPredicates`	`isNull(String field)`	Configures the predicates to match the fields whose value is `null`.
`<J extends OrmObject> OrmPredicates`	`leftOuterJoin(Class<J> clz)`	Adds a `left outer join` condition to a SQL statement.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`limit(int value)`	Sets the maximum number of data records in the column that match the specified predicates.
`OrmPredicates`	`notBetween(String field, double low, double high)`	Configures `OrmPredicates` to match the specified field whose data type is double and value is out of a given range.
`OrmPredicates`	`notBetween(String field, float low, float high)`	Configures `OrmPredicates` to match the specified field whose data type is float and value is out of a given range.
`OrmPredicates`	`notBetween(String field, int low, int high)`	Configures `OrmPredicates` to match the specified field whose data type is int and value is out of a given range.
`OrmPredicates`	`notBetween(String field, long low, long high)`	Configures `OrmPredicates` to match the specified field whose data type is long and value is out of a given range.
`OrmPredicates`	`notBetween(String field, String low, String high)`
`OrmPredicates`	`notBetween(String field, Time low, Time high)`	Configures `OrmPredicates` to match the specified field whose data type is Time and value is out of a given range.
`OrmPredicates`	`notBetween(String field, Timestamp low, Timestamp high)`	Configures `OrmPredicates` to match the specified field whose data type is Timestamp and value is out of a given range.
`OrmPredicates`	`notBetween(String field, Calendar low, Calendar high)`	Configures `OrmPredicates` to match the specified field whose data type is Calendar and value is out of a given range.
`OrmPredicates`	`notBetween(String field, Date low, Date high)`	Configures `OrmPredicates` to match the specified field whose data type is Date and value is out of a given range.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`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.
`OrmPredicates`	`notIn(String field, double[] values)`	Configures `OrmPredicates` to match the specified field whose data type is double array and values are out of a given range.
`OrmPredicates`	`notIn(String field, float[] values)`	Configures `OrmPredicates` to match the specified field whose data type is float array and values are out of a given range.
`OrmPredicates`	`notIn(String field, int[] values)`	Configures `OrmPredicates` to match the specified field whose data type is int array and values are out of a given range.
`OrmPredicates`	`notIn(String field, long[] values)`	Configures `OrmPredicates` to match the specified field whose data type is long array and values are out of a given range.
`OrmPredicates`	`notIn(String field, String[] values)`	Configures `OrmPredicates` to match the specified field whose data type is String array and values are out of a given range.
`OrmPredicates`	`notIn(String field, Time[] values)`	Configures `OrmPredicates` to match the specified field whose data type is Time array and values are out of a given range.
`OrmPredicates`	`notIn(String field, Timestamp[] values)`	Configures `OrmPredicates` to match the specified field whose data type is Timestamp array and values are out of a given range.
`OrmPredicates`	`notIn(String field, Calendar[] values)`	Configures `OrmPredicates` to match the specified field whose data type is Calendar array and values are out of a given range.
`OrmPredicates`	`notIn(String field, Date[] values)`	Configures `OrmPredicates` to match the specified field whose data type is Date array and values are out of a given range.
`OrmPredicates`	`offset(int rowOffset)`	Configures `OrmPredicates` to specify the start position of the returned result.
`OrmPredicates`	`on(String... clauses)`	Adds an `on` condition to the predicate.
`OrmPredicates`	`or()`	Adds an `or` condition to the predicate.
`OrmPredicates`	`orderByAsc(String field)`	Configures the predicates to match the columns whose values are sorted in ascending order.
`OrmPredicates`	`orderByDesc(String field)`	Configures the predicates to match the columns whose values are sorted in descending order.
`OrmPredicates`	`using(String... fields)`	Adds a `using` condition to the predicate.

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

- 构造器详细资料
  - OrmPredicates
```
public OrmPredicates(Class<T> klass)
```
    A parameterized constructor used to create an OrmPredicates instance for searching ORM objects.
    
    参数:
    
    klass - Indicates the class of the ORM objects to search.
- 方法详细资料
  - clear
```
public void clear()
```
    Clears the search conditions of OrmPredicates.
    This method retains only the value of private attribute entityName in OrmPredicates and restores other private attributes to their default values.
  - getEntityName
```
public String getEntityName()
```
    Obtains the value of variable entityName. Obtain value of variable entityName.
    
    返回:
    
    Returns the value of variable entityName.
  - equalTo
```
public OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates glob(String field,
                          String value)
```
  - between
```
public OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates notBetween(String field,
                                int low,
                                int high)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    high - Indicates the maximum value to match with OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public OrmPredicates notBetween(String field,
                                long low,
                                long high)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    high - Indicates the maximum value to match with OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public OrmPredicates notBetween(String field,
                                double low,
                                double high)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    high - Indicates the maximum value to match with OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public OrmPredicates notBetween(String field,
                                float low,
                                float high)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    high - Indicates the maximum value to match with OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public OrmPredicates notBetween(String field,
                                Date low,
                                Date high)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    high - Indicates the maximum value to match with OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public OrmPredicates notBetween(String field,
                                Time low,
                                Time high)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    high - Indicates the maximum value to match with OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public OrmPredicates notBetween(String field,
                                Timestamp low,
                                Timestamp high)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    high - Indicates the maximum value to match with OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public OrmPredicates notBetween(String field,
                                Calendar low,
                                Calendar high)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    high - Indicates the maximum value to match with OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notBetween
```
public OrmPredicates notBetween(String field,
                                String low,
                                String high)
```
  - greaterThan
```
public OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates 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 OrmPredicates offset(int rowOffset)
```
    Configures OrmPredicates to specify the start position of the returned result.
    Use this method together with OrmPredicates#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 OrmPredicates groupBy(String[] fields)
```
    Configures OrmPredicates to group query results by specified columns.
    
    参数:
    
    fields - Indicates the specified columns by which query results are grouped.
    
    返回:
    
    Returns OrmPredicates with the specified columns by which query results are grouped.
    
    从以下版本开始:
    
    3
  - indexedBy
```
public OrmPredicates indexedBy(String indexName)
```
    Configures OrmPredicates 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 OrmPredicates with the specified index column.
    
    从以下版本开始:
    
    3
  - in
```
public OrmPredicates in(String field,
                        int[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public OrmPredicates in(String field,
                        long[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public OrmPredicates in(String field,
                        double[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public OrmPredicates in(String field,
                        float[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public OrmPredicates in(String field,
                        Date[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public OrmPredicates in(String field,
                        Time[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public OrmPredicates in(String field,
                        Timestamp[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public OrmPredicates in(String field,
                        Calendar[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - in
```
public OrmPredicates in(String field,
                        String[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public OrmPredicates notIn(String field,
                           int[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public OrmPredicates notIn(String field,
                           long[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public OrmPredicates notIn(String field,
                           double[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public OrmPredicates notIn(String field,
                           float[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public OrmPredicates notIn(String field,
                           Date[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public OrmPredicates notIn(String field,
                           Time[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public OrmPredicates notIn(String field,
                           Timestamp[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public OrmPredicates notIn(String field,
                           Calendar[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - notIn
```
public OrmPredicates notIn(String field,
                           String[] values)
```
    Configures OrmPredicates 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 OrmPredicates.
    
    返回:
    
    Returns OrmPredicates that matches the specified field.
    
    从以下版本开始:
    
    3
  - crossJoin
```
public <J extends OrmObject> OrmPredicates crossJoin(Class<J> clz)
```
    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.
    
    参数:
    
    clz - Indicates the names of the class to join.
    
    返回:
    
    Returns the predicate with the cross join condition.
  - innerJoin
```
public <J extends OrmObject> OrmPredicates innerJoin(Class<J> clz)
```
    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 OrmPredicates#on(String...). Otherwise, use OrmPredicates#crossJoin instead.
    
    参数:
    
    clz - Indicates the names of the class to join.
    
    返回:
    
    Returns the predicate with the inner join condition.
  - leftOuterJoin
```
public <J extends OrmObject> OrmPredicates leftOuterJoin(Class<J> clz)
```
    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.
    
    参数:
    
    clz - Indicates the names of the class to join.
    
    返回:
    
    Returns the predicate with the left outer join condition.
  - using
```
public OrmPredicates 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 OrmPredicates#leftOuterJoin or inner join OrmPredicates#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.
    
    抛出:
    
    IllegalPredicateException - You must handle this exception by yourself.
    
    IllegalStateException - You must handle this exception by yourself.
  - on
```
public OrmPredicates 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 OrmPredicates#leftOuterJoin or inner join OrmPredicates#innerJoin.
    
    参数:
    
    clauses - Indicates the conditions of the join clauses.
    
    返回:
    
    Returns the predicate with the on condition.
    
    抛出:
    
    IllegalPredicateException - You must handle this exception by yourself.
    
    IllegalStateException - You must handle this exception by yourself.

类 OrmPredicates

构造器概要

方法概要

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

构造器详细资料

OrmPredicates

方法详细资料

clear

getEntityName

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