SQL Where IN + HQL

FROM
    Foo
WHERE
    Id = :id AND
    Bar IN (:barList)
 
To check in a set of results or values. 
Use Query.setParameterList(), Javadoc here.