hibernate查询条件表达式Restrictions

- 日理万妓 2022-08-14 02:48 194阅读 0赞

主要是从官网上拔下来的例子：

官网链接：http://docs.jboss.org/hibernate/orm/3.5/javadocs/org/hibernate/criterion/Restrictions.html

static Criterion	allEq(Map propertyNameValues) 
              Apply an "equals" constraint to each property in the key set of a Map
    static LogicalExpression	and(Criterion lhs, Criterion rhs) 
              Return the conjuction of two expressions
    static Criterion	between(String propertyName, Object lo, Object hi) 
              Apply a "between" constraint to the named property
    static Conjunction	conjunction() 
              Group expressions together in a single conjunction (A and B and C...)
    static Disjunction	disjunction() 
              Group expressions together in a single disjunction (A or B or C...)
    static SimpleExpression	eq(String propertyName, Object value) 
              Apply an "equal" constraint to the named property
    static PropertyExpression	eqProperty(String propertyName, String otherPropertyName) 
              Apply an "equal" constraint to two properties
    static SimpleExpression	ge(String propertyName, Object value) 
              Apply a "greater than or equal" constraint to the named property
    static PropertyExpression	geProperty(String propertyName, String otherPropertyName) 
              Apply a "greater than or equal" constraint to two properties
    static SimpleExpression	gt(String propertyName, Object value) 
              Apply a "greater than" constraint to the named property
    static PropertyExpression	gtProperty(String propertyName, String otherPropertyName) 
              Apply a "greater than" constraint to two properties
    static Criterion	idEq(Object value) 
              Apply an "equal" constraint to the identifier property
    static Criterion	ilike(String propertyName, Object value) 
              A case-insensitive "like", similar to Postgres ilike operator
    static Criterion	ilike(String propertyName, String value, MatchMode matchMode) 
              A case-insensitive "like", similar to Postgres ilike operator
    static Criterion	in(String propertyName, Collection values) 
              Apply an "in" constraint to the named property
    static Criterion	in(String propertyName, Object[] values) 
              Apply an "in" constraint to the named property
    static Criterion	isEmpty(String propertyName) 
              Constrain a collection valued property to be empty
    static Criterion	isNotEmpty(String propertyName) 
              Constrain a collection valued property to be non-empty
    static Criterion	isNotNull(String propertyName) 
              Apply an "is not null" constraint to the named property
    static Criterion	isNull(String propertyName) 
              Apply an "is null" constraint to the named property
    static SimpleExpression	le(String propertyName, Object value) 
              Apply a "less than or equal" constraint to the named property
    static PropertyExpression	leProperty(String propertyName, String otherPropertyName) 
              Apply a "less than or equal" constraint to two properties
    static SimpleExpression	like(String propertyName, Object value) 
              Apply a "like" constraint to the named property
    static SimpleExpression	like(String propertyName, String value, MatchMode matchMode) 
              Apply a "like" constraint to the named property
    static SimpleExpression	lt(String propertyName, Object value) 
              Apply a "less than" constraint to the named property
    static PropertyExpression	ltProperty(String propertyName, String otherPropertyName) 
              Apply a "less than" constraint to two properties
    static NaturalIdentifier	naturalId() 
               
    static SimpleExpression	ne(String propertyName, Object value) 
              Apply a "not equal" constraint to the named property
    static PropertyExpression	neProperty(String propertyName, String otherPropertyName) 
              Apply a "not equal" constraint to two properties
    static Criterion	not(Criterion expression) 
              Return the negation of an expression
    static LogicalExpression	or(Criterion lhs, Criterion rhs) 
              Return the disjuction of two expressions
    static Criterion	sizeEq(String propertyName, int size) 
              Constrain a collection valued property by size
    static Criterion	sizeGe(String propertyName, int size) 
              Constrain a collection valued property by size
    static Criterion	sizeGt(String propertyName, int size) 
              Constrain a collection valued property by size
    static Criterion	sizeLe(String propertyName, int size) 
              Constrain a collection valued property by size
    static Criterion	sizeLt(String propertyName, int size) 
              Constrain a collection valued property by size
    static Criterion	sizeNe(String propertyName, int size) 
              Constrain a collection valued property by size
    static Criterion	sqlRestriction(String sql) 
              Apply a constraint expressed in SQL.
    static Criterion	sqlRestriction(String sql, Object[] values, Type[] types) 
              Apply a constraint expressed in SQL, with the given JDBC parameters.
    static Criterion	sqlRestriction(String sql, Object value, Type type) 
              Apply a constraint expressed in SQL, with the given JDBC parameter.