保存几何元素到oracle spatial

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