如何获得结果从JPA自定义@查询在Spring启动到DTO

Question

我想在不使用元组的情况下，从这个查询中得到DTO的结果。

@Repository公共界面CustomMapRepository扩展了JpaRepository{

@Query(
    nativeQuery = true,
    value = "select  i.id as  permissionId, p.id as projectId,p.name as projectName,i.user_id as userId,\n" +
        "case " +
        "when  i.scopes is not null then i.scopes\n" +
        "when i.scopes is null   then \"[{'edit':false},{'create':false},{'update':flase},{'delete':false},{'view':false}]\" end as scopes \n" +
        "from   internal_permission i  \n" +
        "right join project p\n" +
        "on i.project_id=p.id\n" +
        "where \n" +
        "(user_id=:userId or user_id is null )and \n" +
        "p.space_id=:spaceId )")
List<CustomMapDTO> findBySpaceIdAndUserId(@Param("spaceId") Long spaceId, @Param("userId") String userId);

}

the DTO Class 

公共类CustomMapDTO实现可序列化{

private  String permissionId;
private  Long projectId;
private  String projectName;
private  String userId;
private  String  scopes;

//..接受者和接受者}

Answer 1

  List<CustomMapDTO> res= ((Session)this.em.getDelegate()).createSQLQuery(
        "\n select p.id as projectId,p.name as projectName, i.id as permissionId,i.user_id as userId,\n" +
            "case\n" +
            "  when  i.scopes is not null then i.scopes\n" +
            "  when i.scopes  is null   then \"[{'edit':false},{'create':false},{'update':flase},{'delete':false},{'view':false}]\" end as scopes \n" +
            "from internal_permission i right join project p \n" +
            "on i.project_id=p.id \n" +
        "where \n" +
        "((user_id=:userId or user_id is null ) " +
        " and \n" +
        "(p.space_id=:spaceId))")
        .addScalar("projectId", LongType.INSTANCE)
        .addScalar("projectName", StringType.INSTANCE)
        .addScalar("permissionId", LongType.INSTANCE)
        .addScalar("userId", StringType.INSTANCE)
        .addScalar("scopes", StringType.INSTANCE)
        .setResultTransformer(new AliasToBeanResultTransformer( CustomMapDTO.class))
        .setParameter("spaceId",spaceId)
        .setParameter("userId",userId)
        .unwrap(org.hibernate.query.Query.class)
        .getResultList();