OrmPredicates 数据库条件

 Java API参考-OrmPredicates (harmonyos.com)

Method Summary

Modifier and Type	Method	Description
OrmPredicates	and​()	加一个条件
OrmPredicates	beginsWith​(String field, String value)	就是某一个字段，某个字符开头
OrmPredicates	beginWrap​()	Adds a left parenthesis to the predicate.
OrmPredicates	between​(String field, double low, double high)	双精数值在某某之间
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)	整型在某某之间
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)	时间值在某某之前
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.