Java一般用于postgis空间数据库通用的增删查改sql命令-Toy模板网

这篇具有很好参考价值的文章主要介绍了Java一般用于postgis空间数据库通用的增删查改sql命令。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

1 增加

2 删除

3 查询

4 更新

"public"."JGSQGW_Geo"为某模式下得表一般postgrel有这样的设计模式

1 增加

Java一般用于postgis空间数据库通用的增删查改sql命令,Vue+OpenLayer开发,数据库,postgis

#前端绘制出的数据插入
INSERT INTO "public"."JGSQGW_Geo" ( "geom","gridone","gridonebsm","gridtwo","gridtwobsm","type","bsm" ) VALUES ( 
ST_GeomFromText('MULTIPOLYGON (((115.77640535603713 28.204126934984522, 115.7834195975232 28.203722724458206,
 115.77892572755417 28.19677981424149, 115.77640535603713 28.204126934984522)))', 4490),null,null,null,null,null,null)

 
 #QGis绘制得数据插入
INSERT INTO "public"."JGSQGW_Geo"("geom","gridone","gridonebsm","gridtwo","gridtwobsm","type","bsm")
VALUES (st_multi(st_geomfromwkb($1::bytea,4490)),NULL,NULL,NULL,NULL,NULL,NULL) RETURNING "id"

2 删除

Java一般用于postgis空间数据库通用的增删查改sql命令,Vue+OpenLayer开发,数据库,postgis

DELETE FROM "public"."JGSQGW_Geo" WHERE id>17

3 查询

Java一般用于postgis空间数据库通用的增删查改sql命令,Vue+OpenLayer开发,数据库,postgis

SELECT * FROM "public"."JGSQGW_Geo" LIMIT 100

4 更新

Java一般用于postgis空间数据库通用的增删查改sql命令,Vue+OpenLayer开发,数据库,postgis 文章来源地址https://www.toymoban.com/news/detail-647466.html

UPDATE "public"."JGSQGW_Geo" SET "geom" = ST_GeomFromText('MULTIPOLYGON (((116.79316096688741 28.192370357615896,
 115.79606901 28.19830155, 115.79366752 28.18805362, 115.79007718 28.19397412, 116.79316096688741 28.192370357615896)))',
 4490),"gridone" = NULL,"gridonebsm" = NULL,"gridtwo" = NULL,"gridtwobsm" = NULL,"type" = NULL,"bsm" = NULL  WHERE ("id" = '133')

到了这里，关于Java一般用于postgis空间数据库通用的增删查改sql命令的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！