• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer
  • Core Java
  • Design Patterns
  • JSP
  • Servlets
  • Building Tools
  • jQuery
  • Spring
  • Hibernate
  • Mongo DB
  • More
    • HTML
    • SCJP
    • AJAX
    • UML
    • Struts
    • J2EE
    • Testing
    • Angular JS

J2EE Reference

  • Home
  • About Us
    • Java Learning Centers
  • Contact Us

Hibernate – Query By Criteria

January 29, 2011 By j2eereference Leave a Comment

One of the ways to retrieve Objects from the databases is using Query By Criteria

         Example :

session.createCriteria(Employees.class)

Comparison Operators for Criteria Queries

In Criteria queries, all the operators are available via the Expression class:

Example :

session.createCriteria(Employees.class)

.add( Expression.between(“salary”,

new BigDecimal(5000),

new BigDecimal(10000))

).list();

 

session.createCriteria(Employees.class)

.add( Expression.gt(“salary”, new

BigDecimal(1000) ) )

.list();

 

String[] empIds= { “E-100″,”E-200” };

session.createCriteria(Employees.class)

.add( Expression.in(“empID”, empIds) )

.list();

 

String matching

session.createCriteria(Employees.class).add( Expression.like(“firstname”, “A%”) ).list();

Or

session.createCriteria(Employees.class).add( Expression.like(“firstname”, “A”,MatchMode.START) ).list();

Ordering query results

List results =session.createCriteria(Employees.class)

.addOrder( Order.asc(“firstName”) )

.addOrder( Order.asc(“lastName”) )

.list();

Related Posts

  • First level caching in Hibernate
  • Hibernate Query Language
  • Many to Many mapping in hibernate
  • One To Many mapping using Hibernate
  • one to one mapping using Hibernate
  • Implementing composite primary key with JPA and Hibernate
  • How to implement primary key with JPA and Hibernate
  • What is Hibernate?

Filed Under: Hibernate

Reader Interactions

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

FOLLOW US ONLINE

  • View J2eereference-166104970118637’s profile on Facebook
  • View j2eereference’s profile on Twitter
  • View j2eereference’s profile on LinkedIn

Subscribe by email

Recent posts

  • Java Buzzwords
  • Anonymous Inner Class in Java
  • Network Programming – java.net Package
  • Java Regular Expressions
  • Method Local Inner Class in Java
  • URL Processing in Java
  • Iterator Design Pattern Implementation using Java
  • Strategy Design Pattern Implementation using Java
  • Decorator Design Pattern
  • Adapter Design Pattern Implementation using Java
  • JSF Composite Components
  • JSF UI Components
  • What is JavaServer Faces (JSF)?
  • GOF Design Patterns
  • History and Need for Design Patterns

Footer

Core Java
Design Patterns
JSP
Servlets
HTML
Building Tools
AJAX
SCJP
jQuery
Testing
Spring
UML
Struts
Java Centers
Java Training
Home
About Us
Contact Us
Copyright © j2eereference.com. All right reserved.