从远程服务器读取数据进行处理,直接贴代码:
public class ConnectDB { private static String SERVER = "xxx.xxx.xxx.xxx"; private static String INSTANCE = "xxx"; private static String DB_NAME = "xxx"; private static String USER_NAME = "xxx"; private static String PASSWORD = "xxx"; private static String SERVER_VERSION = "xxx"; private Workspace featureWksp; public ConnectDB() throws AutomationException, IOException{ SdeWorkspaceFactory sdeWorkspaceFactory = new SdeWorkspaceFactory(); PropertySet pset = new PropertySet(); pset.setProperty("SERVER", SERVER); pset.setProperty("INSTANCE", INSTANCE); pset.setProperty("DATABASE", DB_NAME); pset.setProperty("USER", USER_NAME); pset.setProperty("PASSWORD", PASSWORD); pset.setProperty("VERSION", SERVER_VERSION); featureWksp = new Workspace(sdeWorkspaceFactory.open(pset, 0)); } //根据名称获取FeatureClass public FeatureClass getFeatureClass(String fcName) throws AutomationException, IOException{ FeatureClass fc = new FeatureClass(featureWksp.openFeatureClass(fcName)); return fc; } public Workspace getWorkspace(){ return featureWksp; } }