From ab849f796bdc17236a95ea5fe5c166fb8f24a75c Mon Sep 17 00:00:00 2001
From: sws <15810472099@163.com>
Date: 星期六, 26 十一月 2022 16:12:02 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java | 42 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 42 insertions(+), 0 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
new file mode 100644
index 0000000..be599cb
--- /dev/null
+++ b/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
@@ -0,0 +1,42 @@
+package com.lf.server.mapper.all;
+
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
+
+/**
+ * 绌洪棿鍩虹Mapper
+ * @author WWW
+ * @param <T> 娉涘瀷
+ */
+public interface GeomBaseMapper<T> extends BasicMapper<T> {
+ /**
+ * 鏍规嵁ID鏌ヨWKT
+ *
+ * @param tab 琛ㄥ悕
+ * @param gid GID
+ * @return WKT
+ */
+ @Select("select ST_AsText(geom) geom from ${tab} where gid = #{gid}")
+ public String selectWktById(@Param("tab") String tab, @Param("gid") Integer gid);
+
+ /**
+ * 鏍规嵁琛ㄥ悕鏌ヨ绌洪棿鍙傝��
+ *
+ * @param tab 琛ㄥ悕
+ * @return SRID
+ */
+ @Select("select ST_SRID(geom) from ${tab} limit 1")
+ public Integer selectSrid(@Param("tab") String tab);
+
+ /**
+ * 鏇存柊绌洪棿浣嶇疆
+ *
+ * @param tab 琛ㄥ悕
+ * @param gid GID
+ * @param wkt WKT
+ * @return 褰卞搷琛屾暟
+ */
+ @Update("update ${tab} set geom = ST_GeomFromText('${wkt}') where gid = #{gid}")
+ public Integer updateGeom(@Param("tab") String tab, @Param("gid") Integer gid, @Param("wkt") String wkt);
+}
--
Gitblit v1.9.3