HQL multiple condition

http://www.coderanch.com/t/597389/ORM/databases/HQL-query-multiple-conditions-met

view plain print ?

Note: Text content in the code blocks is automatically word-wrapped

1. String queryString = "select employee from Employee employee where employee.age = :age and employee.date = :date and employee.name = :name";   
2. Query query = getSession().createQuery(queryString);  
3. query.setParameter("age", 25);  
4. query.setParameter("date", new Date());  
5. query.setParameter("name", "Shinu");  
6. List<Employee> employeeList = query.list();   

如果是更新多个column：

hql = "update User as u set u.groId=:groId, u.userType=:userType where u.userId=:userId";