Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

search using criteria in hibernate

 
Miranda Mosby
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 185
10
Android Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.


The others are using percent which is SQL wildcard, or id which is a different (both) name and type.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic