java sde_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

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

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

}

}

}

}

}