java操作oracle空间信息介绍(SDE)

sde是Spatial Database Engine简写，中文全称：空间数据库引擎。

SDE是一种客户/服务器软件，可使空间数据在工业标准的数据库管理系统中存储、管理和快速查询检索。把GIS数据放在RDBMS中，但是一般的RDBMS都没有提供GIS的数据类型（如点、线、多边形、以及这些feature之间的拓扑关系和投影坐标等相关信息），RDBMS只提供了少量的数据类型支持：int，float，double，Blob，Long ，char等，一般都是数字，字符串和二进制数据几种。并且RDBMS不仅没有提取对GIS数据类型的存储，也没有提供对这些基础类型的操作（如：判断包含关系，相邻、相交、求差、距离、最短路径等）
JAVA对sde操作，首先需要下载sde支持的jar包。jpe92_sdk.jar和jsde92_sdk.jar两个包，这两个包可以从安装的目录下找到。
下面是java获的sde的链接代码：

/**
	 * 连接sde服务
	 * @return
	 */
	public  SeConnection getConnection () {
        SeConnection conn = null ;
        try {
            conn = new SeConnection(SDE_SERVER_IP, SDE_PROT, SDE_DATEBASE_SID, SDE_USERNAME, SDE_PASSWORD); 
        } catch (SeException e) {
            return null;
        }
        return conn;
	}

对sde数据进行添加，点线面的新增

/**
	 * 添加资源信息点到sde中
	 * @param pointBean 坐标点 POJO
	 * @param tbName    图层名称
	 * @param String typeName 所画的类型 1 点 2 线 3 面
	 * @return   Long   sde的id
	 * @throws Exception
	 */
	public Long addPointObject(PointBean pointBean, List columnList, String tableName, String typeName) throws Exception {
		SeLayer insertLayer = null;
		SeConnection conn = null;
		Long intsertRowID = null;
		SeInsert insert = null;
		try {
			conn = this.getConnection();
			insertLayer = new SeLayer( conn,  tableName, "SHAPE");
			if (insertLayer == null) {
				throw new Exception("找不到空间表：" + tableName);
			}
			conn.startTransaction();
			int arrayLength = columnList.size() + 1 ;
			String[] cols = new String[arrayLength];
			cols[0] = "SHAPE";
			for (int i = 0 ;i<columnList.size() ; i++) {
				ColumnBean columnBean = (ColumnBean)columnList.get(i);
				cols[i+1] = columnBean.getName();
			}
			insert = new SeInsert(conn);
			insert.intoTable(insertLayer.getName(), cols);
			insert.setWriteMode(true);
			SeCoordinateReference coordref = (SeCoordinateReference) insertLayer.getCoordRef();
			SeShape shape = new SeShape(coordref);
			
			if ("1".equals(typeName)) {
				this.addPoint(pointBean, shape);
			} else if ("2".equals(typeName)) {
				this.addLine(pointBean, shape);
			} else if ("3".equals(typeName)) {
				this.addPolygon(pointBean, shape);
			}
			SeRow row = insert.getRowToSet();
			row.setShape(0, shape);
			for (int i = 0 ;i<columnList.size() ; i++) {
				ColumnBean columnBean = (ColumnBean)columnList.get(i);
				if (columnBean.getTypeObject() == 1) {
					row.setNString(i+1, String.valueOf(columnBean.getValObject()));
				} else if (columnBean.getTypeObject() == 2) {
					row.setInteger(i+1, Integer.parseInt(columnBean.getValObject().toString()));
				}else if (columnBean.getTypeObject() == 3) {
					row.setDouble(i+1, Double.parseDouble(columnBean.getValObject().toString()));
				} 
			}
			insert.execute();
			intsertRowID = new Long(insert.lastInsertedRowId().longValue());
			conn.commitTransaction();
		} catch (Exception ex) {
			ex.printStackTrace();
			conn.rollbackTransaction();
		} finally {
			if (insert != null) {
				insert.close();
			}
			if (conn != null) {
				conn.close();
			}
		}
		return intsertRowID;
	}

sde查询接口实现

/**
	 * 查询sde
	 * @param productId 产品id
	 * @throws SeException
	 */
	public SeQuery searchSde (Long productId, String tableName) throws SeException {
		SeConnection conn = getConnection();
		SeLayer layer = new SeLayer( conn,  tableName, "SHAPE");
        SeSqlConstruct sqlConstruct = new SeSqlConstruct(layer.getName());
        if (productId != null) {
        	sqlConstruct.setWhere("yid="+productId.intValue());
        }
        String[] cols = null;
        if (tableName.equals("YU_AN_POINT") || tableName.equals("FANG_AN_POINT")) {
            cols = new String[4];
            cols[0] = new String("OBJECTID");
            cols[1] = layer.getSpatialColumn();
            cols[2] = new String("NAME");
            cols[3] = new String("IMAGETYPE");
        } else {
        	cols = new String[3];
            cols[0] = new String("OBJECTID");
            cols[1] = layer.getSpatialColumn();
            cols[2] = new String("NAME");
        }
        System.out.println("cols.length : " + cols.length);
        SeQuery query = new SeQuery(conn, cols, sqlConstruct );
        query.prepareQuery();
        query.execute();
        return query;
	}

SDE信息删除操作

/**
	 * 
	 * 删除 通过列对应的值
	 * @param id     值
	 * @param column 列 
	 * @param tbName 表名
	 * @throws SeException
	 */
	 public void deletePointObject(String id, String column, String tbName) throws SeException {
		SeConnection conn = null;
		SeLayer layer = null;
		SeDelete delete = null;
		try {
			conn = this.getConnection();
			layer = new SeLayer(conn, tbName, "SHAPE"); // 得到对应图层
			if (layer == null) {
				throw new Exception("找不到空间表：" + tbName);
			}
			conn.startTransaction();
			delete = new SeDelete(conn);
			delete.fromTable(layer.getName(), column + "='" + id+"'");
			conn.commitTransaction();
		} catch (Exception ex) {
			conn.rollbackTransaction();
		} finally {
			if (delete != null) {
				try {
					delete.close();
				} catch (SeException e) {
					e.printStackTrace();
					throw e;
				} finally {
					if (conn != null) {
						conn.close();
					}
				}
			}
		}
	}