ceil(sqrt(pow((#{longitude,jdbcType=DECIMAL} -longitude) * 102834.74258026089786013677476285, 2)
+ pow((#{latitude,jdbcType=DECIMAL} -latitude) * 111712.69150641055729984301412873, 2))) as distance
原文：https://www.cnblogs.com/rubekid/p/15136202.html