HIbernate query

Question

Hi

I want to execute a query using hibernate where the requirment is like

select * from user where regionname=''

that is select all the users from user where region name is some data How to write this in hibernate The below code is giving result appropraitely

Criteria crit= HibernateUtil.getSession().createCriteria(User.class);
        crit.add(Restrictions.eq("regionName", regionName));

Answer 1

String hql = "SELECT u FROM User u WHERE regionName=:regionName";
Query q = session.createQuery(hql);
q.setParameter("regionName", regionName);
List result = q.list();

Answer 2

Well as you alaready said you can either use the Criteria API or create a HQL query:

// Criteria
List<User> users = HibernateUtil.getSession().createCriteria(User.class);
        crit.add(Restrictions.eq("regionName", regionName)).list();

// HQL
String query = "SELECT FROM User WHERE regionName = :region";
List<User> users = HibernateUtil.getSession().createQuery(query).setString("region", regionName).list();