Build Criteria Dinamically

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

Is it possible to build Criteria queries dinamically, like an SQL query?

For example, i've this query

SELECT name FROM table1 where 1=1 and name = Tom and program=JBOss and address = Lisbon, etc ...,

and i want to build a criteria query, but i don't know how many conditions i would have in the Criteria.

How i do this?

Thanks,
Pedro

kochcp · **Posted:** Fri Apr 21, 2006 4:59 pm

thats what the Criteria stuff was made for. Just string some if statements or some loops and you can keep adding stuff to your query depending on the need

Code:

Critera crit = new Criteria(some.class);

if (checkSomethingHere)
    crit.addCondition;

if (checkSomethingElse)
    crit.addCondition;