【YashanDB知识库】如何使用jdbc向YashanDB批量插入gis数据

本文内容来自YashanDB官网,原文内容请见 https://www.yashandb.com/newsinfo/7817897.html?templateId=1718516

以gis表为例:

drop table gis;

create table gis(id number not null, pos st_geometry not null);

使用如下的java代码片断,可以向gis表中插入POINT类型的gis数据:

conn.setAutoCommit(false);

PreparedStatement ps = conn.prepareStatement("insert into gis values(?,ST_GEOMFROMTEXT(?))");

for(int i = 0; i < 10; i++) {

    ps.setInt(1, 1);

    ps.setString(2, "POINT(-137.690708 33.187434)");

    ps.addBatch();

}

ps.executeBatch();

conn.commit();

最终效果:

SQL> select id, st_astext(pos) from gis;

ID ST_ASTEXT(POS)

----------- ----------------------------------------------------------------

1 POINT (-137.690708000000001 33.187434000000003)

1 POINT (-137.690708000000001 33.187434000000003)

1 POINT (-137.690708000000001 33.187434000000003)

1 POINT (-137.690708000000001 33.187434000000003)

1 POINT (-137.690708000000001 33.187434000000003)

1 POINT (-137.690708000000001 33.187434000000003)

1 POINT (-137.690708000000001 33.187434000000003)

1 POINT (-137.690708000000001 33.187434000000003)

1 POINT (-137.690708000000001 33.187434000000003)

1 POINT (-137.690708000000001 33.187434000000003)

 

10 rows fetched.

posted @   YashanDB  阅读(1)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· [翻译] 为什么 Tracebit 用 C# 开发
· 腾讯ima接入deepseek-r1,借用别人脑子用用成真了~
· Deepseek官网太卡,教你白嫖阿里云的Deepseek-R1满血版
· DeepSeek崛起:程序员“饭碗”被抢,还是职业进化新起点?
· RFID实践——.NET IoT程序读取高频RFID卡/标签
点击右上角即可分享
微信分享提示