计算两个坐标之间的距离SQL + Criteria Builder

// 使用Criteria Builder构建查询
CriteriaBuilder cb = entityManager.getCriteriaBuilder();
CriteriaQuery<Double> query = cb.createQuery(Double.class);
Root<Coordinates> root = query.from(Coordinates.class);

// 定义要查询的字段
Expression<Double> latitude1 = root.get("latitude");
Expression<Double> longitude1 = root.get("longitude");
Expression<Double> latitude2 = cb.literal(40.7128); // 第二个坐标的纬度
Expression<Double> longitude2 = cb.literal(-74.0060); // 第二个坐标的经度

// 使用地理信息系统函数计算距离
Expression<Double> distance = cb.function("ST_Distance", Double.class,
        cb.function("ST_MakePoint", Geometry.class, longitude1, latitude1),
        cb.function("ST_MakePoint", Geometry.class, longitude2, latitude2));

// 添加查询条件
query.select(distance);

// 执行查询
Double result = entityManager.createQuery(query).getSingleResult();