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