JPA自定义sql查询结果

JPA自定义SQL查询结果

很多时候都会遇到自定义sql，自定义返回字段，而不是pojo类。这个情况要通过接口定义返回。

@Query(value = "select m.field AS field,COUNT(m.field) AS size from MigrationObject m where m.xmlName = ?1 and m.groupName = ?2 group by m.field")
   List<WorkCenter> getKey(String xmlName, String groupName);

对于这种情况，只返回了两个字段，就需要定义一个接口来接收(注意AS别名的配置)

public interface WorkCenter { 
    String getField();
    String getSize();
}

List<WorkCenter> list = migrationObjectRepository.getKey("EN_Work centerResource.xml","Key");
     for (WorkCenter workCenter:list){
         System.out.println(workCenter.getField());
         System.out.println(workCenter.getSize());
     }

ARBPL
5
SPRAS
2
CANUM
2
ENDDA
1
WERKS
5