CreationScript.java
sessionFactory = createSessionFactory(); Session objSession = sessionFactory.openSession(); objSession.beginTransaction(); Criteria crt = objSession.createCriteria(Users.class); crt.add(Restrictions.eq("UserName", "UserName 9")); List<Users> arrUsers = (List<Users>)crt.list(); for (Users users : arrUsers) { System.out.println(users.getUserName()); }
AND Restrictions
Criteria crt = objSession.createCriteria(Users.class); crt.add(Restrictions.eq("UserName", "UserName 9")). add(Restrictions.gt("UserId", 5));
Criteria crt = objSession.createCriteria(Users.class); crt.add(Restrictions.eq("UserName", "UserName 9")). add(Restrictions.gt("UserId", 5));
Criteria crt = objSession.createCriteria(Users.class); crt.add(Restrictions.eq("UserName", "UserName 9")). add(Restrictions.between("UserId", 5, 10));
Criteria crt = objSession.createCriteria(Users.class); crt.add(Restrictions.eq("UserName", "UserName 9")). add(Restrictions.between("UserId", 5, 10));
OR Restrictions
Criteria crt = objSession.createCriteria(Users.class); crt.add(Restrictions.or(Restrictions.between("UserId", 0, 5), Restrictions.like("UserName", "Updated %")));