使用 JDBC 批量插入 YashanDB GIS 空间数据的示例

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

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();

select id, st_astext(pos) from gis;

ID | ST_ASTEXT(POS)
---|-------------------------
1  | POINT (-137.690708... 33.187434...)