From f52d5579915db640078c0ff2cc0cac1beef05bc5 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 06 三月 2023 10:04:21 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java | 4 ++--
1 files changed, 2 insertions(+), 2 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 0014a67..7ec2db1 100644
--- a/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
+++ b/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
@@ -19,7 +19,7 @@
* @param gid GID
* @return WKT
*/
- @Select("select ST_AsText(geom) geom from ${tab} where gid = #{gid}")
+ @Select("select ST_AsText(geom) geom from ${tab} where gid = #{gid} limit 1")
public String selectWktById(@Param("tab") String tab, @Param("gid") Integer gid);
/**
@@ -65,6 +65,6 @@
* @param wkt WKT
* @return 褰卞搷琛屾暟
*/
- @Update("update ${tab} set geom = ST_GeomFromText('${wkt}') where gid = #{gid}")
+ @Update("update ${tab} set geom = ST_GeomFromText('${wkt}') where gid = #{gid} limit 1")
public Integer updateGeom(@Param("tab") String tab, @Param("gid") Integer gid, @Param("wkt") String wkt);
}
--
Gitblit v1.9.3