HQL Study

引用

HQL和SQL不一样，HQL查询的是对象，而SQL查询的是数据库中的表。

String HQL = "from User as user where name=?";
// If HQL is "from Object", Hibernate will query all tables in database;
Query query = Session.createQuery(HQL);
query.setString(1,"name");
List list = query.list();

或者

String HQL = "from User as user where name=:name"
Query query = Session.createQuery(HQL);
query.setString(name,"name");
List list = query.list();

分页的实现

query.setFirstResult(0);
query.setMaxResult(10);