src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/resources/application.yml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
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); } src/main/resources/application.yml
@@ -41,8 +41,8 @@ datasource: name: prod # JDBC 基本配置 ¤tSchema=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驱动目录