dynamic criteria list

pfenn · **Joined:** Fri Jul 16, 2004 3:21 am **Posts:** 40

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.0.5

I want to make a dynamic critaria list:

i want to select all my adresses with the country spain,france, andorra.

table Adress:
ID : number
name : varachar
surname : varachar
city : varachar
phone : varachar
country : varachar

how can i do that with a criteria.
during runtime the list of countries varied. so i seek somthing that i can give the cirteria a java.util.List or Set.

rgds stefan

ramnath · **Posted:** Thu Aug 18, 2005 4:37 am

Hi Stefan

Try this

Criteria crt = sess.createCriteria(new YourClass());
if(info.getCountry() != null)
crt.add(Expression.eq("country",info.getCountry()));
List list = crt.list() ;

This is for getting a value for a single Country.

You can create a ArrayList and then add the country in to the list and pass it in the Expression.

crt.add(Expression.eq("country",ArrayList));

I dont remember the syntax check it out.

pfenn · **Joined:** Fri Jul 16, 2004 3:21 am **Posts:** 40

Thanks Ramnath

i will try this.
is crt.add(Expression.eq("country",ArrayList));
then a "AND" betweend the different Members of the ArrayList or are this Members with "OR" linked?

rgds stefan

ramnath · **Posted:** Thu Aug 18, 2005 5:15 am

Hi Stefan

Its AND

ramnath · **Posted:** Thu Aug 18, 2005 5:16 am

Sorry

Its OR

pfenn · **Joined:** Fri Jul 16, 2004 3:21 am **Posts:** 40

Hello Ramnath

it works, thanks for the help.

here the code:

Code:

ArrayList countryList = new ArrayList();
countryList.add("Switzerland");
countryList.add("Germany");
countryList.add("France");
Criteria critetria=  session.createCriteria(Adress.class);
critetria.add(Expression.in("Country",countryList));
List <Adress>list = critetria.list();
for (Adress adress : list) {
     // iterate through 
}

rgds stefan

ramnath · **Posted:** Thu Aug 18, 2005 11:42 pm

Hi Stefan

You forgot to rate my posting