java映射查询到dto
@Query(value = "SELECT (6371 * 2 * ASIN(SQRT(POWER(SIN((:ulatitude - abs(latitude)) * pi()/180 / 2),2) +" +
"COS(:ulatitude * pi()/180 ) * COS(abs(latitude) * pi()/180) *" +
"POWER(SIN((:ulongitude - longitude) * pi()/180 / 2), 2)))) as distance,lakes.id,lakes.name " +
"FROM lakes", nativeQuery = true)
List<Lake>lakeLocalization(@Param("ulat") double ulat, @Param("ulng") double ulng);
我无法将此查询映射到Dto。有人能帮我吗
共 (0) 个答案