基于数据库计算两个经纬度之间的距离

SELECT
6370 * acos(
cos(
radians(#{lat})) * cos(radians(weidu)) * cos(radians(jingdu) - radians(#{lng})) + sin(radians(#{lat})) * sin(radians(weidu))) AS distance,
qiyemingcheng,jingdu,weidu,id
from ${tableId}