Usage of OR and and in hibernate criteria

2. /s filter to remove invalid data
4. /* DETACHEDCRITERIA.ADD (
6. Restrictions.or (
8. Restrictions.like ("Chanpin", "refrigerator", matchmode.anywhere),
10. Restrictions.or (
12. Restrictions.like ("Chanpin", "Washing Machine", matchmode.anywhere),
14. Restrictions.or (
16. Restrictions.like ("Chanpin", "water heater", matchmode.anywhere),
18. Restrictions.like ("Chanpin", "air conditioner", Matchmode.anywhere))))
20. );
22. */
24. Disjunction dis=restrictions.disjunction ();
26. Dis.add (Restrictions.like ("Chanpin", "refrigerator", matchmode.anywhere));
28. Dis.add (Restrictions.like ("Chanpin", "washing machine", matchmode.anywhere));
30. Dis.add (Restrictions.like ("Chanpin", "water heater", matchmode.anywhere));
32. Dis.add (Restrictions.like ("Chanpin", "air conditioning", matchmode.anywhere));
34. Detachedcriteria.add (DIS);
36. //e filtering to remove invalid data

Method used to combine a set of logical OR "or" conditions

Java code

1. Restrictions.disjunction ();

A method used to combine a set of logical and "and" conditions

Java code

1. Restrictions.conjunction ();

Comment out part of the code, the query results and the following code, if you write multiple logic or conditions for a field, the following way is better. Select the appropriate method according to the specific situation.

Usage of OR and and in hibernate criteria