CriteriaBuilder<GuoShengKongViewData> cb = cbf.create(em, xxx.class);
if (StringUtils.hasText(search.getWktStr())) {
WKTReader reader = new WKTReader();
Geometry read = reader.read(search.getWktStr());
read.setSRID(4326);
// 使用postgis方言函数进行地理相交查询
cb.whereExpression("FUNCTION('st_intersects', point, :point) = true").setParameter("point", read);
}
jpa querydsl 使用函数查询地理信息
最新推荐文章于 2024-10-08 14:23:59 发布