CODEWITHSUNDEEP
javahibernate
sarah
sarah

Reputation: 2397

HIbernate query

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));

Upvotes: 0

Views: 2064

Answers (2)

Daff
Daff

Reputation: 44215

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();

Upvotes: 2

Bozho
Bozho

Reputation: 597362

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

Upvotes: 1

Related Questions