java - 我可以在 JPA CriteriaBuilder 中引用非映射表吗？

Question

我正在尝试使用实体管理器重写以下查询..

public abstract class HibernateEntitySelector<T> extends HibernateDAOSupport implements EntitySelector<T> {
    @Autowired
    public void init(SessionFactory factory) {
        setSessionFactory(factory);
    }
    public String SELECT_IDS = " IN (SELECT RESULT_ID FROM QUERY_RESULTS)";

    public List<T> getEntitiesByIds(){
        DetachedCriteria criteria = DetachedCriteria.forClass(getEntityClass());
        criteria.add(Restrictions.sqlRestriction(getPrimaryKeyField()+SELECT_IDS));
        return (List<T>) this.getHibernateTemplate().findByCriteria(criteria);
    }

类似这样的事情..

public abstract class HibernateEntitySelector<T> implements EntitySelector<T> {

public String SELECT_IDS = " IN (SELECT RESULT_ID FROM QUERY_RESULTS)";

    @PersistenceContext
    protected EntityManager em;

    public List<T> getEntitiesByIds(){
        String s = "FROM " + getEntityClass().getSimpleName() + " ent WHERE ent."+getEntityId()+SELECT_IDS;
        Query query = this.em.createNamedQuery(s);
        return (List<T>)query.getResultList();
    }
}

但是由于 QUERY_RESULTS 未映射，因此失败。有没有一种方法可以在不使用 createNativeQuery 方法然后手动映射所有列的情况下执行此操作？

Answer 1

虽然你正在使用:

，但你已经非常接近了

Query query = this.em.createNamedQuery(s);

改用 createNativeQuery 并同时更改查询字符串:

String s = "SELECT ent.* FROM " + getEntityClass().getSimpleName() + " ent WHERE ent."+getEntityId() + SELECT_IDS;
Query query = this.em.createNativeQuery(s, getEntityClass());

尝试一下。