AO操作图形数据库,一般的增删查改,(以修改为例)如下:
IServerContext sc=null;
IWorkspaceEdit wsEdit = null;
try
{
sc=AOUtil.getServerContext(ConfigBean.getAOIP(), ConfigBean.getAOUserName(), ConfigBean.getAOPSW(), ConfigBean.getMapService());
IWorkspace ws=AOUtil.getWorkSpaceFromWF(sc, ConfigBean.getPSRUserName(), ConfigBean.getPSRPSW(), "sde.DEFAULT");
IFeatureWorkspace featureWorkspace = (IFeatureWorkspace) ws;
wsEdit = (IWorkspaceEdit) featureWorkspace;//设置此ws开始编辑
wsEdit.startEditing(false);
wsEdit.startEditOperation();
IFeatureClass featureC = featureWorkspace.openFeatureClass(featureClass.toUpperCase());
IQueryFilter qf = (IQueryFilter)sc.createObject(QueryFilter.getClsid());
qf.setWhereClause("ID = '"+gisID+"'");
IFeatureCursor featureCursor = featureC.IFeatureClass_update(qf, false);
IFields fields = featureCursor.getFields();
IFeature feature =featureCursor.nextFeature();
while(feature!=null){
for(int i=0; i<list.size();i++){
Element element = (Element)list.get(i);//修改数据来源,我的是XML
String tag = element.getName();
String value = element.getText();
//updateFields = updateFields + tag +" = '"+ value+ "',";
feature.setValue(fields.findField(tag), value);
}
featureCursor.updateFeature(feature);
feature=featureCursor.nextFeature();
}
}catch (Exception e) {
System.out.println(e.getMessage());
logger.error("获取设备图形信息错误!");
}
finally{
try {
wsEdit.stopEditOperation();
wsEdit.stopEditing(true);//保存编辑
count = 1;
} catch (AutomationException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
AOUtil.releaseServerContext(sc);
}