将原生 SQL 查询的结果映射到 Grails 域类 [英] Mapping result of a native SQL query to Grails domain class

问题描述

是否可以将本机 SQL 查询的结果映射到 Grails 域类实例的集合?

Is it possible to map the result of a native SQL query to a collection of Grails domain class instances?

推荐答案

import com.acme.domain.*

def sessionFactory
sessionFactory = ctx.sessionFactory  // this only necessary if your are working with the Grails console/shell
def session = sessionFactory.currentSession 

def query = session.createSQLQuery("select f.* from Foo where f.id = :filter)) order by f.name");
query.addEntity(com.acme.domain.Foo.class); // this defines the result type of the query
query.setInteger("filter", 88);
query.list()*.name;

这篇关于将原生 SQL 查询的结果映射到 Grails 域类的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！