JPA自定義SQL查詢結(jié)果

很多時(shí)候都會(huì)遇到自定義sql，自定義返回字段，而不是pojo類。這個(gè)情況要通過接口定義返回。

@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);

對(duì)于這種情況，只返回了兩個(gè)字段，就需要定義一個(gè)接口來接收(注意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