使用JPA自定义SQL查询结果

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

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());
        }

@Entity 
@NamedQuery(name = "Person.withNameAndAddressNamedQuery",
query = "select p from Person p where p.name=?1 and address=?2")
public class Person {
    ......
}

public interface PersonRepo extends JpaRepository<Person,Long>{
    //使用的是NameQuery里定义的查询语句，而不是根据方法名称来查询
    Person withNameAndAddressNamedQuery(String name,String address);
}

public interface PersonRepo extends JpaRepository<Person,Long>{
    @Query("select p from Person p where p.address= ？1")
    List<Person> findByAddress(String address);
}

public interface PersonRepo extends JpaRepository<Person,Long>{
    @Query("select p from Person p where p.name= :name and p.address= :address")
    Person withNameAndAddressQuery(@Param("name")String name,@Param("address")String address);
}

public interface PersonRepo extends JpaRepository<Person,Long>{
    @Modifying
    @Transactional
    @Query("update Person p set p.name=?1")
    int setName(String name);//表示更新语句影响的行数
}