search using criteria in hibernate

[Miranda Mosby]

I created a jsp page with a text field.According to the text entered in the field the database is searched using hibernate. The datbase has a field name. It will search the dbs for name that matches the entered name. The criteria query for this will be which one from these?

Criteria criteria = session.createCriteria(Hello.class)
.add(Restrictions.eq(name, "%"));
.add(Restrictions.eq("name", name));
.add(Restrictions.eq(name, "name%"));
.add(Restrictions.eq("id", new Integer(0)));
.add(Restrictions.ilike("name", "%",MatchMode.ANYWHERE));

[L Foster]

I do not have great depth in Criteria (although I do think Criterion API is a great idea because it potentially can eliminate reliance on SQL strings), but I would be very surprised to learn that it is not that second line.

.add(Restrictions.eq("name", name)); 

The others are using percent which is SQL wildcard, or id which is a different (both) name and type.