hibernate criteria 转成 hql

最新推荐文章于 2021-09-21 14:07:26 发布

iteye_7816

最新推荐文章于 2021-09-21 14:07:26 发布

阅读量271

点赞数

文章标签： java

本文链接：https://blog.csdn.net/iteye_7816/article/details/82570346

版权

hibernate的查询器Criteria可以生成hql, 注意要收集参数，查询时用到：

public String getCriteriaSql(Criteria criteria) {
  CriteriaImpl criteriaImpl = (CriteriaImpl) criteria;//转型
  SessionImplementor session = criteriaImpl.getSession();//获取SESSION
  SessionFactoryImplementor factory = session.getFactory();//获取FACTORY
  CriteriaQueryTranslator translator = new CriteriaQueryTranslator(factory, criteriaImpl, criteriaImpl.getEntityOrClassName(), CriteriaQueryTranslator.ROOT_SQL_ALIAS);
  String[] implementors = factory.getImplementors(criteriaImpl.getEntityOrClassName());
  CriteriaJoinWalker walker = new CriteriaJoinWalker((OuterJoinLoadable) factory.getEntityPersister(implementors[0]), translator, factory, criteriaImpl, criteriaImpl.getEntityOrClassName(), session.getEnabledFilters());
  String hql = walker.getSQLString();
  hql = hql.replaceAll("this_", "e");
  return hql;
}