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

以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.