Java 解析 clob 包含坐标
来源:互联网 发布:linux定制桌面 编辑:程序博客网 时间:2024/05/29 13:27
纯SQL更新 st_geometry 语句。
点坐标更新SQL:update a99 set SHAPE = st_point(120.913881027, 37.40471325200002,4326) where objectid = 9527 线类坐标更新SQL: update a98 set SHAPE = st_LINESTRING('LINESTRING(117.14161515333333 36.68986946888889, 117.14165322333332 36.68978380888889, 117.14175791333332 36.68966006888889, 117.14180550333333 36.68958392888889, 117.14184357333333 36.68950778888889, 117.14190068333333 36.68943164888889, 117.14194827333333 36.68935549888889, 117.14202379222223 36.68927824777778, 117.14208089222222 36.68920210777778, 117.14211896222223 36.689125957777776, 117.14214752222223 36.68904981777778, 117.14221414222223 36.68897367777778, 117.14225221222223 36.68889753777778)', 4326) where objectid = 9527面类资源更新坐标: update a97 set SHAPE = st_polygon('polygon((115.54533362444444 34.823791657777775, 115.54533362444444 34.823058787777775, 115.54535266444445 34.823058787777775, 115.54542880444444 34.823058787777775, 115.54550494444445 34.82303974777778, 115.54558109444444 34.82302071777778, 115.54565723444445 34.822992157777776, 115.54573337444444 34.82296360777778, 115.54580951444444 34.822935047777776, 115.54588566444444 34.82294456777778, 115.54596180444445 34.822992157777776, 115.54596180444445 34.82306830777778, 115.54596180444445 34.82314444777778, 115.54596180444445 34.823220587777776, 115.54597132444445 34.82329672777778, 115.54597132444445 34.82337287777778, 115.54596180444445 34.823449017777776, 115.54596180444445 34.82352515777778, 115.54596180444445 34.82360129777778, 115.54597132444445 34.823677447777776, 115.54599035444444 34.82375358777778, 115.54595228444444 34.82382972777778, 115.54587614444445 34.82382972777778, 115.54580000444444 34.82382972777778, 115.54572385444445 34.82381069777778, 115.54564771444444 34.82381069777778, 115.54557157444445 34.823791657777775, 115.54549542444444 34.823791657777775, 115.54540976444444 34.823791657777775, 115.54533362444444 34.823791657777775))', 4326) where objectid = 9527
JAVA 中获取 CLOB 解析并更新
//锁定数据行进行更新,注意“for update”语句,这里不用for update锁定不可以插入clob pstmt = gisConnection.getConnection().prepareStatement("select st_astext(shape) SHAPE from a100 where objectid = 9527 for update"); rs = pstmt.executeQuery(); if(rs.next()){ CLOB clob =((OracleResultSet)rs).getCLOB(1); String tempStr = "偏移之后的坐标数据"; // 这个地方最为关键, 最外面没有'' , linestring同样 String xystring="POLYGON(("+tempStr+"))"; clob.putString(1,xystring); String upsql = "update a100 set SHAPE =ST_POLYGON(?,4326) WHERE OBJECTID=9527"; pstmt = gisConnection.prepareStatement(upsql); pstmt.setClob(1, clob); int p =pstmt.executeUpdate(); System.out.println("POLYGON 更新成功 : "+p); }
0 0
- Java 解析 clob 包含坐标
- 包含clob数据列的表
- java处理CLOB字段
- java插入clob字段
- Java读取clob字段
- java 存取 clob 字段
- JAVA CLOB字段处理
- java插入clob字段
- java 操作clob
- Java数据库编程---Clob
- java插入clob字段
- Clob in java
- java操作clob
- java Clob 问题解决
- 【职坐标】使用FastJson创建Java Json解析工具类
- <JAVA>字符串中包含空格的字符串解析
- JAVA读写ORCALE CLOB字段
- java 操作ORACLE Clob字段
- ubuntu12.04 安装lamp <1>
- svn合并代码报错:Attempt to add tree conflict that already exists
- 致亲爱的偷车贼
- SWT 官方资料
- 常用汉字简繁体对照
- Java 解析 clob 包含坐标
- 正则表达式 价格正则表达式 非负整数正则表达式 正整数正则表达式
- VC6最基本
- 旧笔记一页
- gcc 执行c++报错
- kvm--default网络配置
- python类继承中构造子的调用
- Python正则表达式
- 美剧学英语清单