Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Devaka Cooray
Saloon Keepers:
  • Ganesh Patekar
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • salvin francis
Bartenders:
  • Ron McLeod
  • Frits Walraven
  • Pete Letkeman

search using criteria in hibernate  RSS feed

 
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));
 
Ranch Hand
Posts: 257
15
Android Angular Framework AngularJS Java Spring
  • 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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!