地图两点坐标距离计算

java

public class LocationUtils {

    private static double EARTH_RADIUS = 6378.137;

    private static double rad(double d) {
        return d * Math.PI / 180.0;
    }

    /**
     * 通过经纬度获取距离(单位：米)
     *
     * @param lat1
     * @param lng1
     * @param lat2
     * @param lng2
     * @return 距离
     */
    public static double getDistance(double lat1, double lng1, double lat2,
                                     double lng2) {
        double radLat1 = rad(lat1);
        double radLat2 = rad(lat2);
        double a = radLat1 - radLat2;
        double b = rad(lng1) - rad(lng2);
        double s = 2 * Math.asin(Math.sqrt(Math.pow(Math.sin(a / 2), 2)
                + Math.cos(radLat1) * Math.cos(radLat2)
                * Math.pow(Math.sin(b / 2), 2)));
        s = s * EARTH_RADIUS;
        s = Math.round(s * 10000d) / 10000d;
        s = s * 1000;
        return s;
    }

    public static void main(String[] args) {
        double distance = getDistance(34.2675560000, 108.9534750000,
                34.2464320000, 108.9534750000);
        System.out.println("距离" + distance / 1000 + "公里");
    }

}

mysql计算两点坐标距离

SELECT
 ROUND(
		6378.137 * 2 * ASIN(
            SQRT(
                POW(
                    SIN(
                        (
                            34.2675560000 * PI() / 180 - 34.2464320000 * PI() / 180
                        ) / 2
                    ),
                    2
                ) + COS(34.2675560000 * PI() / 180) * COS(34.2464320000 * PI() / 180) * POW(
                    SIN(
                        (
                            108.9534750000 * PI() / 180 - 108.9534750000 * PI() / 180
                        ) / 2
                    ),
                    2
                )
            )
        ) * 1000 
    ,1) AS distance
FROM
st_user;