java 获取当前时间和计算经纬度之间距离

获取当前时间:
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
Date date = new Date(System.currentTimeMillis());
System.out.println(date);

获取当前时间包括时分秒
Date date = new Date();
SimpleDateFormat dateFormat= new SimpleDateFormat("yyyy-MM-dd :hh:mm:ss");
System.out.println(dateFormat.format(date));

    /**
     * 默认地球半径
     */
    private static double EARTH_RADIUS = 6371000;//赤道半径(单位m)
 
    /**
     * 转化为弧度(rad)
     * */
    private static double rad(double d)
    {
        return d * Math.PI / 180.0;
    }
    /**
     * @param lon1 第一点的精度
     * @param lat1 第一点的纬度
     * @param lon2 第二点的精度
     * @param lat2 第二点的纬度
     * @return 返回的距离，单位m
     * */
    public static double calculate(double lon1,double lat1,double lon2, double lat2) {
        double radLat1 = rad(lat1);
        double radLat2 = rad(lat2);
        double a = radLat1 - radLat2;
        double b = rad(lon1) - rad(lon2);
        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 * 10000) / 10000;
        return s;
    }

统计月度环比同比请参考这篇博客:
https://blog.csdn.net/dongyan3595/article/details/122533958?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165664186316782389419832%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=165664186316782389419832&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~times_rank-6-122533958-null-null.142^v29^pc_rank_34,185^v2^control&utm_term=mysql%E6%9C%88%E5%BA%A6%E7%8E%AF%E6%AF%94%E5%92%8C%E6%9C%88%E5%BA%A6%E5%90%8C%E6%AF%94&spm=1018.2226.3001.4187