使用选择示例将Hibernate Native SQL映射到实体 [英] Hibernate Native SQL Mapping to Entity with Selection Example

问题描述

我试图创建本地sql查询并映射到带有参数的实体类，但失败。

I tried to create native sql query and map to entity class with parameter but fail.

/**
     * @return
     */
    public List<PoolRuleMapping> getAllPRM() {
        Session session = null;
        List<PoolRuleMapping> prmList = null;

        try {
            session = HibernateSessionFactory.getSession();

            Query q = session.createSQLQuery("select * from pool_rule_mapping").addEntity(PoolRuleMapping.class);
            prmList = q.list();

        } catch (HibernateException e) {
        } finally {
            session.close();
        }

        return prmList;
    }

请举例说明。谢谢。

推荐答案

您可以尝试下面的代码。

You can try the below code.

session.createSQLQuery("select * from pool_rule_mapping")
 .addScalar("ID", Hibernate.LONG)
 .addScalar("NAME", Hibernate.STRING)
 .addScalar("SOMEDATE", Hibernate.DATE)
 .addEntity(PoolRuleMapping.class);

另外，您可以尝试为各个字段指定别名。

Also, you can try specifying alias for individual fields.

select prm.id AS ID, prm.name AS NAME, prm.somedate as SOMEDATE from pool_rule_mapping prm

这篇关于使用选择示例将Hibernate Native SQL映射到实体的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！