From 85fbc3fe04a0a2eff185c75687b316d99acd5a04 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 19 十二月 2022 13:25:22 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java | 11 ++++++++++-
1 files changed, 10 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java b/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
index be599cb..5cc4632 100644
--- a/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
+++ b/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
@@ -26,10 +26,19 @@
* @param tab 琛ㄥ悕
* @return SRID
*/
- @Select("select ST_SRID(geom) from ${tab} limit 1")
+ @Select("select ST_SRID(geom) from ${tab} where geom is not null limit 1")
public Integer selectSrid(@Param("tab") String tab);
/**
+ * 鏍规嵁琛ㄥ悕鏌ヨ绌洪棿绫诲瀷
+ *
+ * @param tab 琛ㄥ悕
+ * @return SRID
+ */
+ @Select("select ST_GeometryType(geom) from ${tab} where geom is not null limit 1")
+ public String selectGeometryType(@Param("tab") String tab);
+
+ /**
* 鏇存柊绌洪棿浣嶇疆
*
* @param tab 琛ㄥ悕
--
Gitblit v1.9.3