Criteria with variable size.

pedrosacosta · **Joined:** Wed Dec 14, 2005 7:27 am **Posts:** 18

Hi,

probably there is a lot of posts with the same problem that i have, but i can't find any example. My problem is how to build a query with the Criteria, but the values after WHERE have a variable size.

I want to know the following:

SELECT * FROM TABLE1 WHERE ID = 1, ID = 2, ...., ID = 5.
The ID is a primary key.

The values after WHERE have a variable size, and may alternate. Ie, ID can have the values 2,4,5 or 1,3,5, etc...

This values are in a java.util.List.

criteria.createCriteria(Table1.class)
.add(<How should i do it?>);

Thanks,
Pedro

kochcp · **Posted:** Wed Aug 02, 2006 10:21 am

Code:

Criteria c = createCriteria(class);
for (Iterator iter...) {
if (condition) {
c.add(Restriction.eq(prop, value);
}
}

execute

bkmr_77 · **Joined:** Tue Apr 25, 2006 12:04 pm **Posts:** 260

I guess you can use similar code to the following

Code:

List idList =  new ArrayList();
idList.add( new Integer( 1 ) );
idList.add( new Integer( 2 ) );
idList.add( new Integer( 3 ) );

Criteria crit = session.createCriteria( Table1.class, "one" );
crit.add( Restrictions.in( "one.ID", idList ) );
List results = crit.list();