Cuckoo Framework GIS扩展计划开始启动。
代码举例: 保存几何元素到oracle spatial
package org.cuckooframework.gis.utils;
import java.sql.*;
import org.cuckooframework.jdbc.JdbcWrapping;
import oracle.spatial.geometry.JGeometry;
import oracle.sql.STRUCT;
public class OracleSpatialUtil {
private JdbcWrapping jdbc = new JdbcWrapping();
public void updatePoint(String tableName, String geoColName, String pkName,
String pkValue, double[] coords) throws SQLException {
Connection conn = null;
PreparedStatement ps = null;
try {
conn = jdbc.getConnection();
JGeometry j_geom = JGeometry.createPoint(coords, 1, 8307);
ps = conn.prepareStatement("UPDATE " + tableName + " SET "
+ geoColName + "=? WHERE " + pkName