import sample.data.jpa.domain.HotelSummary; //导入依赖的package包/类
@Test
public void executesQueryMethodsCorrectly() {
	City city = this.cityRepository
			.findAll(new PageRequest(0, 1, Direction.ASC, "name")).getContent()
			.get(0);
	assertThat(city.getName()).isEqualTo("Atlanta");

	Page<HotelSummary> hotels = this.repository.findByCity(city,
			new PageRequest(0, 10, Direction.ASC, "name"));
	Hotel hotel = this.repository.findByCityAndName(city,
			hotels.getContent().get(0).getName());
	assertThat(hotel.getName()).isEqualTo("Doubletree");

	List<RatingCount> counts = this.repository.findRatingCounts(hotel);
	assertThat(counts).hasSize(1);
	assertThat(counts.get(0).getRating()).isEqualTo(Rating.AVERAGE);
	assertThat(counts.get(0).getCount()).isGreaterThan(1L);
}
 

import sample.data.jpa.domain.HotelSummary; //导入依赖的package包/类
@Test
public void executesQueryMethodsCorrectly() {
	City city = this.cityRepository
			.findAll(new PageRequest(0, 1, Direction.ASC, "name")).getContent()
			.get(0);
	assertThat(city.getName(), is("Atlanta"));

	Page<HotelSummary> hotels = this.repository.findByCity(city,
			new PageRequest(0, 10, Direction.ASC, "name"));
	Hotel hotel = this.repository.findByCityAndName(city,
			hotels.getContent().get(0).getName());
	assertThat(hotel.getName(), is("Doubletree"));

	List<RatingCount> counts = this.repository.findRatingCounts(hotel);
	assertThat(counts, hasSize(1));
	assertThat(counts.get(0).getRating(), is(Rating.AVERAGE));
	assertThat(counts.get(0).getCount(), is(greaterThan(1L)));
}
 

import sample.data.jpa.domain.HotelSummary; //导入依赖的package包/类
@Query("select h.city as city, h.name as name, avg(r.rating) as averageRating "
		+ "from Hotel h left outer join h.reviews r where h.city = ?1 group by h")
Page<HotelSummary> findByCity(City city, Pageable pageable);
 

import sample.data.jpa.domain.HotelSummary; //导入依赖的package包/类
@Override
public Page<HotelSummary> getHotels(City city, Pageable pageable) {
	Assert.notNull(city, "City must not be null");
	return this.hotelRepository.findByCity(city, pageable);
}
 

import sample.data.jpa.domain.HotelSummary; //导入依赖的package包/类
@Query("select new sample.data.jpa.domain.HotelSummary(h.city, h.name, avg(r.rating)) "
		+ "from Hotel h left outer join h.reviews r where h.city = ?1 group by h")
Page<HotelSummary> findByCity(City city, Pageable pageable);
 

import sample.data.jpa.domain.HotelSummary; //导入依赖的package包/类
Page<HotelSummary> getHotels(City city, Pageable pageable);