项目使用框架JPA+Spring Boot, 想使用原生sql实现一个复杂的关联查询,返回特定的数据结果;
因EntityManager中createNativeQuery方法直接返回的需是JPA管理的Entity, 固需自定义一个只用于映射查询结果的Entity;
使用方式如下:
首先自定义查询结果的Entity:
import javax.persistence.*;
@SqlResultSetMapping(name = "houseResponseResultMapping", entities={
@EntityResult(entityClass=HouseQueryResult.class,fields={
@FieldResult(name="id", column="ID"),
@FieldResult(name="houseAddress", column="HouseAddress"),
@FieldResult(name="houseBuilding", column="HouseBuilding"),
@FieldResult(name="houseUnit", column="HouseUnit"),
@FieldResult(name="houseFloor", column="houseFloor"),
@FieldResult(name="houseNumber", c