import sample.data.jpa.domain.Hotel; //导入依赖的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.Hotel; //导入依赖的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.Hotel; //导入依赖的package包/类
@Override
public Hotel getHotel(City city, String name) {
	Assert.notNull(city, "City must not be null");
	Assert.hasLength(name, "Name must not be empty");
	return this.hotelRepository.findByCityAndName(city, name);
}
 

import sample.data.jpa.domain.Hotel; //导入依赖的package包/类
@Override
public Page<Review> getReviews(Hotel hotel, Pageable pageable) {
	Assert.notNull(hotel, "Hotel must not be null");
	return this.reviewRepository.findByHotel(hotel, pageable);
}
 

import sample.data.jpa.domain.Hotel; //导入依赖的package包/类
@Override
public Review getReview(Hotel hotel, int reviewNumber) {
	Assert.notNull(hotel, "Hotel must not be null");
	return this.reviewRepository.findByHotelAndIndex(hotel, reviewNumber);
}
 

import sample.data.jpa.domain.Hotel; //导入依赖的package包/类
@Override
public Review addReview(Hotel hotel, ReviewDetails details) {
	Review review = new Review(hotel, 1, details);
	return this.reviewRepository.save(review);
}
 

import sample.data.jpa.domain.Hotel; //导入依赖的package包/类
@Override
public ReviewsSummary getReviewSummary(Hotel hotel) {
	List<RatingCount> ratingCounts = this.hotelRepository.findRatingCounts(hotel);
	return new ReviewsSummaryImpl(ratingCounts);
}
 

import sample.data.jpa.domain.Hotel; //导入依赖的package包/类
@Query("select r.rating as rating, count(r) as count "
		+ "from Review r where r.hotel = ?1 group by r.rating order by r.rating DESC")
List<RatingCount> findRatingCounts(Hotel hotel);
 

import sample.data.jpa.domain.Hotel; //导入依赖的package包/类
@Override
public Review addReview(Hotel hotel, ReviewDetails details) {
	Review review = new Review(hotel, 1, details);
	return reviewRepository.save(review);
}
 

import sample.data.jpa.domain.Hotel; //导入依赖的package包/类
@Query("select new sample.data.jpa.domain.RatingCount(r.rating, count(r)) "
		+ "from Review r where r.hotel = ?1 group by r.rating order by r.rating DESC")
List<RatingCount> findRatingCounts(Hotel hotel);
 

import sample.data.jpa.domain.Hotel; //导入依赖的package包/类
@Override
public Review addReview(Hotel hotel, ReviewDetails details) {
	Review review = new Review(hotel, details);
	return reviewRepository.save(review);
}