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

2024-12-30
广东
本文字数：612 字
阅读完需：约 2 分钟

本文内容来自 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.