Hibernate Restriction to search with like clause in list

Question

I need help with hibernate criteria restriction.

As we know that we use IN restriction with list , i.e

Criteria criteria = session.createCriteria(Student.class);
List<String> studentNames= new ArrayList();
criteria.add(Restrictions.in("name",studentNames);
List list = criteria.list();

and to use like we use restriction like this i.e

String matchString = "Suraj Kumar";
criteria.add(Restrictions.like(
"studentName", matchString));

Problem: What i want is that every element in list should be searched with "LIKE" clause. If we use IN clause, then it compares the element with all the elements passed in the IN clause, and that comparison is based on equality.

But requirement is that , every element in the list should be checked with the LIKE clause , with the corresponding database column.

Please help me to create hibernate criteria restriction with the same.

Thanks

score 0 · Answer 1 · answered Feb 23 '20 at 15:46

You can try to use Disjunction which can be used if you have multiple OR conditions.

    Criteria criteria = session.createCriteria(Student.class);
    List<String> studentNames= new ArrayList();
    Disjunction disj = Restrictions.disjunction();
    for (String value : studentNames) {
        disj.add(Restrictions.like("name", value));
    }
    criteria.add(disj);
    List list = criteria.list();

Hibernate Restriction to search with like clause in list

1 Answers1