Hi friend,

package roseindia;

import org.hibernate.Session;
import org.hibernate.*;
import org.hibernate.criterion.*;
import org.hibernate.cfg.*;
import java.util.*;

public class hibernatebetweenexample {

public static void main(String[] args) {
Session session = null;
try {
// This step will read
// hibernate.cfg.xml and prepare hibernate for
// use
SessionFactory sessionFactory = new Configuration().configure()
.buildSessionFactory();
session = sessionFactory.openSession();
//Criteria Query Example
Criteria crit = session.createCriteria(Information.class);
crit.add(Expression.between("amount", new Integer(1000),new Integer(2500)));
//Between condition
crit.setMaxResults(5);
// Restricts the max rows to 5

List information = crit.list();
System.out.println(information);
for(Iterator it = information.iterator();
it.hasNext();){
Information inform = (Information) it.next();
System.out.println("Id:"+inform.getId());
System.out.println("Name:"+inform.getName());
System.out.println("Amount:"+inform.getAmount());

}
session.close();
}
catch (Exception e) {
System.out.println(e.getMessage());
}
finally {
}
}
}


-----------------------------------

read for more information,

http://www.roseindia.net/hibernate/