java根据经纬度计算两点距离(java 代码 sql 代码)

最新推荐文章于 2022-10-31 15:17:26 发布

rub

最新推荐文章于 2022-10-31 15:17:26 发布

阅读量170

点赞数

文章标签： java

本文链接：https://blog.csdn.net/jms_exception/article/details/83911730

版权

项目上正好用到。顺便贴给JE们。


public double distance(double n1, double e1, double n2, double e2)
     {
         double jl_jd = 102834.74258026089786013677476285//每经度单位米;
         double jl_wd = 111712.69150641055729984301412873//每纬度单位米;
         double b = Math.abs((e1 - e2) * jl_jd);
         double a = Math.abs((n1 - n2) * jl_wd);
         return Math.sqrt((a * a + b * b));

     }



ALTER FUNCTION dbo.fnGetDistance  

 (  
     @LatBegin REAL 

    , @LngBegin REAL 

     , @LatEnd REAL 

     , @LngEnd REAL 

 )  

 RETURNS FLOAT 

 AS 

 BEGIN 

     DECLARE @Distance REAL 

     DECLARE @EARTH_RADIUS REAL 

     SET @EARTH_RADIUS = 6378.137  



     DECLARE @RadLatBegin REAL, @RadLatEnd REAL, @RadLatDiff REAL, @RadLngDiff REAL 

     SET @RadLatBegin = @LatBegin * PI() / 180.0  

     SET @RadLatEnd = @LatEnd * PI() / 180.0  

     SET @RadLatDiff = @RadLatBegin - @RadLatEnd  

     SET @RadLngDiff = @LngBegin * PI() / 180.0 - @LngEnd * PI() / 180.0  



     SET @Distance = 2 * ASIN(SQRT(POWER(Sin(@RadLatDiff / 2), 2) + COS(@RadLatBegin) * COS(@RadLatEnd) * POWER(SIN(@RadLngDiff/2),2)))  

     SET @Distance = @Distance * @EARTH_RADIUS  

     --SET @Distance = Round(@Distance * 10000) / 10000  



     RETURN @Distance  

 END


/**
	 * @param longitude 经度
	 * @param latitude纬度
	 * @param range   多少范围内的
**/

	public Integer getWhereInfo(double longitude,double latitude,double range){

		StringBuffer hql = new StringBuffer();
		double jl_jd = 102834.74258026089786013677476285;
        double jl_wd = 111712.69150641055729984301412873;
        hql.append("from whereInfo w where  sqrt(power((w.longitude-"+longitude+")*"+jl_jd+",2)+power((w.latitude-"+latitude+")*"+jl_wd+",2))<="+range);
        return this.whereInfoDao.getwhereInfo(hql.toString());

	}