CityRepository.java

package common.repository;

import common.model.City;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * Created by zxy on 2017/12/26.
 */
public interface CityRepository extends JpaRepository<City, Long>
{
    @Query(value="select `name` from city",nativeQuery=true)
    List<String> findCitys();
}