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 ++--
 src/main/resources/application.yml                         |    7 ++++---
 2 files changed, 6 insertions(+), 5 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);
 }
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index dfe0b77..13bd22d 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -41,8 +41,8 @@
   datasource:
     name: prod
     # JDBC 鍩烘湰閰嶇疆 &currentSchema=public
-    url: jdbc:postgresql://103.85.165.99:5433/langfang?useAffectedRows=true
-    #url: jdbc:postgresql://192.168.20.205:5433/langfang?useAffectedRows=true
+    #url: jdbc:postgresql://103.85.165.99:5433/langfang?useAffectedRows=true
+    url: jdbc:postgresql://192.168.20.205:5433/langfang?useAffectedRows=true
     #url: jdbc:postgresql://127.0.0.1:5433/langfang?useAffectedRows=true
     username : postgres
     password: Postgres!_14_Lf
@@ -145,7 +145,8 @@
 # 绯荤粺閰嶇疆
 sys:
   # FME鏈嶅姟鍦板潃
-  fmeUrl: http://103.85.165.99:8051/
+  #fmeUrl: http://103.85.165.99:8051/
+  fmeUrl: http://192.168.20.205:88/
   # 鍑哄浘鏈嶅姟
   exportServer: http://127.0.0.1/ExportMap
   # Gdal椹卞姩鐩綍

--
Gitblit v1.9.3