您也可以使用数据库的本地 SQL 方言表达查询。如果您想利用数据库特定的功能，例如查询提示或 Oracle 中的 CONNECT BY 选项，这将很有用。它还提供了一条从直接 SQL/JDBC 应用程序迁移到 Hibernate 的清晰路径。请注意，Hibernate 允许您为所有创建、更新、删除和加载操作指定手写 SQL（包括存储过程）（有关更多信息，请参阅参考指南。）

@SqlResultSetMapping(name="GetNightAndArea", entities={

    @EntityResult(name="org.hibernate.test.annotations.query.Night", fields = {

        @FieldResult(name="id", column="nid"),

        @FieldResult(name="duration", column="night_duration"),

        @FieldResult(name="date", column="night_date"),

        @FieldResult(name="area", column="area_id")

    }),

    @EntityResult(name="org.hibernate.test.annotations.query.Area", fields = {

        @FieldResult(name="id", column="aid"),

        @FieldResult(name="name", column="name")

    })

    }

)


//or

@SqlResultSetMapping(name="defaultSpaceShip", entities=@EntityResult(name="org.hibernate.test.annotations.query.SpaceShip"))

@SqlResultSetMapping(name="ScalarAndEntities",

    entities={

        @EntityResult(name="org.hibernate.test.annotations.query.Night", fields = {

            @FieldResult(name="id", column="nid"),

            @FieldResult(name="duration", column="night_duration"),

            @FieldResult(name="date", column="night_date"),

            @FieldResult(name="area", column="area_id")

        }),

        @EntityResult(name="org.hibernate.test.annotations.query.Area", fields = {

            @FieldResult(name="id", column="aid"),

            @FieldResult(name="name", column="name")

        })

    },

    columns={

        @ColumnResult(name="durationInSec")

    }

)

String sqlQuery = "select night.id nid, night.night_duration, night.night_date, area.id aid, "

    + "night.area_id, area.name from Night night, Area area where night.area_id = area.id "

    + "and night.night_duration >= ?";

Query q = entityManager.createNativeQuery(sqlQuery, "GetNightAndArea");

q.setParameter( 1, expectedDuration );

q.getResultList();

String sqlQuery = "select * from tbl_spaceship where owner = ?";

Query q = entityManager.createNativeQuery(sqlQuery, SpaceShip.class);

q.setParameter( 1, "Han" );

q.getResultList();

Query q = entityManager.createNamedQuery("getSeasonByNativeQuery");

q.setParameter( 1, name );

Season season = (Season) q.getSingleResult();