1、hibernate联合查询:from UQuestion q left join UAnswer a on q.id=a.questionId where q.parentQuestion is null报错:outer or full join must be followed by path expr ession
大家说hql不支持 inner join 连接和on。于是将查询语句改为
select q from UQuestion q, UAnswer a where q.id=a.questionId and q.parentQuestion is null
2、createQuery与createSQLQuery区别
createQuery 用hql语句进行查询,它以hibernate生成的bean为对象装入list返回。
createSQLQuery 用sql语句查询,以对象数组进行存储。
注意:createSQLQuery有一个方法可以直接转换对象
Query query=session.createSQLQuery(sql).addEntity(XXXX.class);
3、hibernate分页 (不使用executeFind)
SessionFactory sf = this.getSessionFactory() ;
Session session = sf.openSession() ;
Query query = session.createSQLQuery(sql);?
query.setFirstResult((pageIndex-1)*pageSize) ;
query.setMaxResults(pageSize);
List list = query.list() ;
session.flush();
session.close() ;