import sample.data.jpa.domain.City; //导入依赖的package包/类
@Override
public Page<City> findCities(CitySearchCriteria criteria, Pageable pageable) {

	Assert.notNull(criteria, "Criteria must not be null");
	String name = criteria.getName();

	if (!StringUtils.hasLength(name)) {
		return this.cityRepository.findAll(null);
	}

	String country = "";
	int splitPos = name.lastIndexOf(",");

	if (splitPos >= 0) {
		country = name.substring(splitPos + 1);
		name = name.substring(0, splitPos);
	}

	return this.cityRepository
			.findByNameContainingAndCountryContainingAllIgnoringCase(name.trim(),
					country.trim(), pageable);
}
 

import sample.data.jpa.domain.City; //导入依赖的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.City; //导入依赖的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.City; //导入依赖的package包/类
@Override
public Page<City> findCities(CitySearchCriteria criteria, Pageable pageable) {

	Assert.notNull(criteria, "Criteria must not be null");
	String name = criteria.getName();

	if (!StringUtils.hasLength(name)) {
		return this.cityRepository.findAll(pageable);
	}

	String country = "";
	int splitPos = name.lastIndexOf(",");

	if (splitPos >= 0) {
		country = name.substring(splitPos + 1);
		name = name.substring(0, splitPos);
	}

	return this.cityRepository
			.findByNameContainingAndCountryContainingAllIgnoringCase(name.trim(),
					country.trim(), pageable);
}
 

import sample.data.jpa.domain.City; //导入依赖的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.City; //导入依赖的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.City; //导入依赖的package包/类
Page<City> findByNameContainingAndCountryContainingAllIgnoringCase(String name,
String country, Pageable pageable);
 

import sample.data.jpa.domain.City; //导入依赖的package包/类
@Override
public City getCity(String name, String country) {
	Assert.notNull(name, "Name must not be null");
	Assert.notNull(country, "Country must not be null");
	return this.cityRepository.findByNameAndCountryAllIgnoringCase(name, country);
}
 

import sample.data.jpa.domain.City; //导入依赖的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.City; //导入依赖的package包/类
@Test
public void findsFirstPageOfCities() {

	Page<City> cities = this.repository.findAll(new PageRequest(0, 10));
	assertThat(cities.getTotalElements()).isGreaterThan(20L);
}
 

import sample.data.jpa.domain.City; //导入依赖的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.City; //导入依赖的package包/类
@Test
public void findsFirstPageOfCities() {

	Page<City> cities = this.repository.findAll(new PageRequest(0, 10));
	assertThat(cities.getTotalElements(), is(greaterThan(20L)));
}