HQL参数为分两种,一种是占位符方式:(注意是从 0 开始)
- String hql = "from User u where u.id=?";
- Query query = session.createQuery(hql);
- query.setParameter(0, 2);
- List<User> user = query.list();
HQL参数为分两种,第二种是使用参数形式:
- String hql = "from User u where u.id=:id";
- Query query = session.createQuery(hql);
- query.setInteger("id", 2);
- List<User> user = query.list();
HQL语句实现分页:
- String hql = "from User u";
- Query query = session.createQuery(hql);
- query.setFirstResult(0);
- query.setMaxResults(5);
- List<User> user = query.list();
HQL语句实现分组和排序:
- String hql = "from User u group by name order by id desc";
- Query query = session.createQuery(hql);
- List<User> user = query.list();