{"id":1301,"date":"2010-11-12T06:13:30","date_gmt":"2010-11-11T21:13:30","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1301"},"modified":"2017-02-06T14:29:28","modified_gmt":"2017-02-06T05:29:28","slug":"%ec%9e%90%eb%b0%94-api%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-arcsde-92-%ec%97%b0%eb%8f%99","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1301","title":{"rendered":"[GIS] \uc790\ubc14 API\ub97c \uc774\uc6a9\ud55c ArcSDE 9.2 \uc5f0\ub3d9"},"content":{"rendered":"<p>\ud658\uacbd\uc740 ArcSDE 9.2\uc774\uace0..\u00a0 ArcSDE \uc11c\ube44\uc2a4 \ud329\uc740 \uc124\uce58\ud558\uc9c0 \uc54a\uc558\uc73c\uba70 \uc624\ub77c\ud074\uc740 10g \ubc84\uc804\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 ArcSDE\uc5d0 \ub300\ud55c \uc790\ubc14 API\ub294 ArcSDE 9.2 \uc11c\ube44\uc2a4\ud3296\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4. \ucc38\uace0\ub85c \uc790\ubc14 API\ub97c \uad6c\uc131\ud558\ub294 jar \ud30c\uc77c\uc740 \ub2e4\uc74c\uacfc \uac19\uc73c\uba70 \ubaa8\ub450 \ubc18\ub4dc\uc2dc.. \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li>jsde92_sdk.jar<\/li>\n<li>jpe92_sdk.jar<\/li>\n<li>icu4j_3_2.jar<\/li>\n<\/ul>\n<p>\ub124.. \uc774\uc81c ArcSDE\uc640 \uc5f0\ub3d9\ud558\uae30 \uc704\ud55c \uc790\ubc14 API\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.. \uba3c\uc800 \uc5f0\uacb0\uc5d0 \ub300\ud55c \ucf54\ub4dc\uc785\ub2c8\ub2e4..<\/p>\n<pre>import java.util.*;\r\nimport com.esri.sde.sdk.client.*;\r\n\r\npublic class MainEntry {\r\n\u00a0 \u00a0 @SuppressWarnings(\"unchecked\")\r\n\u00a0 \u00a0 public static void main(String[] args) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 SeConnection conn = null;\r\n\u00a0 \u00a0 \u00a0 \u00a0 String server = \"192.168.0.18\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 int service = 5151;\r\n\u00a0 \u00a0 \u00a0 \u00a0 String database = \"\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 String user = \"na_gis\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 String password = \"na_gis\";\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 try {\r\n\u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0\u00a0 conn = new SeConnection(server, service, database, user, password);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0Vector layerList = conn.getLayers();\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(layerList.size() + \" layers existed... \");\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 for(int i=0; i<layerList.size(); ++i) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeLayer lyr = (SeLayer)layerList.get(i);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(i + \" - \" + lyr.getQualifiedName());\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 \u00a0 \u00a0 } catch(SeException e) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 e.printStackTrace();\r\n\u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 }\r\n}<\/pre>\n<p>\uc704\uc758 \ucf54\ub4dc\ub294 \uc5f0\uacb0\ubfd0\ub9cc \uc544\ub2c8\ub77c \uc5f0\uacb0\ub41c ArcSDE \uc11c\ubc84\uac00 \uad00\ub9ac\ud558\uace0 \uc788\ub294 \ub808\uc774\uc5b4 \uac1c\uc218\uc640 \uc774\ub984\uc744 \ud654\uba74\uc5d0 \ucd9c\ub825\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc740 \ub808\uc774\uc5b4\ub97c \uad6c\uc131\ud558\ub294 \ud544\ub4dc \uc815\ubcf4\ub97c \uc5bb\uc5b4 \uc624\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n<pre>import java.util.*;\r\nimport com.esri.sde.sdk.client.*;\r\n\r\npublic class MainEntry {\r\n\u00a0 \u00a0 @SuppressWarnings(\"unchecked\")\r\n\u00a0 \u00a0 public static void main(String[] args) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 SeConnection conn = null;\r\n\u00a0 \u00a0 \u00a0 \u00a0 String server = \"192.168.0.18\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 int service = 5151;\r\n\u00a0 \u00a0 \u00a0 \u00a0 String database = \"\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 String user = \"na_gis\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 String password = \"na_gis\";\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 try {\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0conn = new SeConnection(server, service, database, user, password);\r\n\r\n\u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0\u00a0 Vector tableList = conn.getTables(SeDefs.SE_SELECT_PRIVILEGE);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0System.out.println(tableList.size() + \" table existed... \");\r\n\u00a0 \u00a0\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 for(int i=0; i<tableList.size(); ++i) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeTable tbl = (SeTable)tableList.get(i);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0System.out.println(i + \" - \" + tbl.getQualifiedName());\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0SeTable tbl = (SeTable)tableList.get(37);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0System.out.println(\"\\nTable Name(\" \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 + tbl.getQualifiedName() + \")'s Field List\");\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0SeColumnDefinition[] tableDef = tbl.describe();\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 for(int iField =0; iField < tableDef.length; iField++) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(tableDef[iField].getName() \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 + \", \" + tableDef[iField].getType());\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 \u00a0 \u00a0 } catch(SeException e) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 e.printStackTrace();\r\n\u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 }\r\n}<\/pre>\n<p>\ud544\ub4dc \uc815\ubcf4\ub294 \ub808\uc774\uc5b4 \uac1c\ub150\uc774 \uc544\ub2cc \ud14c\uc774\ube14 \uac1c\ub150\uc73c\ub85c \uac00\uc838\uc640\uc57c \ud569\ub2c8\ub2e4. \ub808\uc774\uc5b4\ub294 \ud14c\uc774\ube14 + \ub3c4\ud615 \ub370\uc774\ud130 \ucbe4\uc73c\ub85c.. \uc0dd\uac01\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc740 \ud14c\uc774\ube14\uc758 \ud2b9\uc815 \ud544\ub4dc(\ub4e4)\uc758 \uac12\uc744 \uc5bb\uc5b4\uc624\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n<pre>import java.util.*;\r\nimport com.esri.sde.sdk.client.*;\r\n\r\npublic class MainEntry {\r\n\u00a0 \u00a0 @SuppressWarnings(\"unchecked\")\r\n\u00a0 \u00a0 public static void main(String[] args) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 SeConnection conn = null;\r\n\u00a0 \u00a0 \u00a0 \u00a0 String server = \"192.168.0.18\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 int service = 5151;\r\n\u00a0 \u00a0 \u00a0\u00a0 \u00a0String database = \"\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 String user = \"na_gis\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 String password = \"na_gis\";\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 try {\r\n\u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0\u00a0 conn = new SeConnection(server, service, database, user, password);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0Vector tableList = conn.getTables(SeDefs.SE_SELECT_PRIVILEGE);\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeTable tbl = (SeTable)tableList.get(89);\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeSqlConstruct sqlConstruct = \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 new SeSqlConstruct(tbl.getQualifiedName());\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 String[] cols = new String[1];\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0cols[0] = \"IST_YMD\";\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeQuery query = new SeQuery(conn, cols, sqlConstruct);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0query.prepareQuery();\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0query.execute();\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeRow row;\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0while((row = query.fetch()) != null)\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 String value = row.getString(0);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(value);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0}\r\n\u00a0 \u00a0 \u00a0 \u00a0 } catch(SeException e) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 e.printStackTrace();\r\n\u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 }\r\n}<\/pre>\n<p>\uc5bb\uc5b4\uc628 \ud14c\uc774\ube14 \ub9ac\uc2a4\ud2b8(Vector tableList)\uc5d0\uc11c \uc778\ub371\uc2a4 \ubc88\ud638 89\uc5d0 \ud574\ub2f9\ud558\ub294 \ud14c\uc774\ube14\uc758 IST_YMD \ud544\ub4dc\uc5d0 \ub300\ud55c \uac12\uc744 \ubf51\uc544 \ub0b4 \ud654\uba74\uc5d0 \ud45c\uc2dc\ud569\ub2c8\ub2e4. \ub9cc\uc57d SQL\uc758 Where \uad6c\ubb38\uc744 \uc9c0\uc815\ud558\uace0\uc790 \ud55c\ub2e4\uba74 SeSqlConstruct sqlConstruct \uac1d\uccb4\uc758 \ub9e4\uc11c\ub4dc setWhere\uc5d0 \uad6c\ubb38\uc744 \uc9c0\uc815\ud558\uba74 \ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uba74.. \ub9cc\uc57d \ud544\ub4dc ADM_NAM\uc5d0 \ub300\ud574\uc11c '\ubaa9'\uc73c\ub85c \uc2dc\uc791\ud558\ub294 \uc870\uac74\uc758 \uacbd\uc6b0\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\u00a0 \u00a0 ....\r\n\r\n\u00a0 \u00a0 sqlConstruct.setWhere(\"ADM_NAM LIKE '\ubaa9%'\");\r\n\r\n\u00a0 \u00a0 ....<\/pre>\n<p>\ub2e4\uc74c\uc740 \ub808\uc774\uc5b4\uc5d0\uc11c \ub3c4\ud615\uc5d0 \ub300\ud55c \uc88c\ud45c\ub97c \ud45c\uc2dc\ud558\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\nimport java.util.*;\r\nimport com.esri.sde.sdk.client.*;\r\n\r\npublic class MainEntry {\r\n    @SuppressWarnings(\"unchecked\")\r\n    public static void main(String[] args) {\r\n        SeConnection conn = null;\r\n        String server = \"192.168.0.18\";\r\n        int service = 5151;\r\n        String database = \"\";\r\n        String user = \"na_gis\";\r\n        String password = \"na_gis\";\r\n\r\n        try {\r\n            conn = new SeConnection(server, service, database, user, password);\r\n            Vector layerList = conn.getLayers();\r\n\r\n            SeLayer lyr = (SeLayer)layerList.get(4);\r\n            SeSqlConstruct sqlConstruct =\r\n                new SeSqlConstruct(lyr.getQualifiedName());\r\n\r\n            String[] cols = new String[3];\r\n            cols[0] = \"BD_NM\";\r\n            cols[1] = \"BD_MGT_SN\";\r\n            cols[2] = \"SHAPE\";\r\n\r\n            SeQuery query = new SeQuery(conn, cols, sqlConstruct);\r\n            query.prepareQuery();\r\n            query.execute();\r\n\r\n            SeRow row;\r\n            while((row = query.fetch()) != null)\r\n            {\r\n                SeShape shp = row.getShape(2);\r\n\r\n                double coordinates[][][] = shp.getAllCoords();\r\n                System.out.println(\"coordinates.length = \" + coordinates.length);\r\n                System.out.println(\"coordinates[0].length = \" + coordinates[0].length);\r\n                System.out.println(\"coordinates[0][0].length = \" + coordinates[0][0].length);\r\n\r\n                double partCoords[] = coordinates[0][0];\r\n                for(int i=0; i<partCoords.length; i+=2) {\r\n                    System.out.println(\"(X:\" + partCoords[i] + \", Y:\" + partCoords[i+1] + \")\");\r\n                }\r\n            }\r\n        }\r\n    } catch(SeException e) {\r\n        e.printStackTrace();\r\n    }\r\n}\r\n<\/pre>\n<p>\uc5bb\uc5b4\uc628 \ub808\uc774\uc5b4 \ub9ac\uc2a4\ud2b8(Vector layerList)\uc5d0\uc11c \uc778\ub371\uc2a4 4\ubc88\uc5d0 \ud574\ub2f9\ud558\ub294 \ub808\uc774\uc5b4\uc5d0 \ub300\ud574\uc11c \ud544\ub4dc BD_NM, BD_MGT_SN \uadf8\ub9ac\uace0 \uc88c\ud45c\uc5d0 \ub300\ud55c \uac12\uc774 \ub2f4\uae34 SHPAE \ud544\ub4dc\ub97c \uc9c0\uc815\ud574 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4. \uc704\uc758 \ucf54\ub4dc\ub294 \uc9c0\uc815\ub41c \ub808\uc774\uc5b4\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \ub808\ucf54\ub4dc\ub97c \uc77d\uc5b4 \uc624\uac8c \ub429\ub2c8\ub2e4. \uc5ec\uae30\uc5d0 \uc81c\ud55c\uc744 \ub450\uc5b4 \uc9c0\uc815\ub41c MBR\uc5d0 \ud3ec\ud568\ub418\uac70\ub098 \uad50\ucc28\ud558\ub294 \ub808\ucf54\ub4dc\ub9cc\uc744 \uc5bb\uc5b4\uc624\ub294 \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>import java.util.*;\r\nimport com.esri.sde.sdk.client.*; public class MainEntry {\r\n\u00a0 \u00a0 @SuppressWarnings(\"unchecked\")\r\n\u00a0 \u00a0 public static void main(String[] args) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 SeConnection conn = null;\r\n\u00a0 \u00a0 \u00a0 \u00a0 String server = \"192.168.0.18\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 int service = 5151;\r\n\u00a0 \u00a0 \u00a0 \u00a0 String database = \"\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 String user = \"na_gis\";\r\n\u00a0 \u00a0 \u00a0 \u00a0 String password = \"na_gis\";\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 try {\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0conn = new SeConnection(server, service, database, user, password);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0Vector layerList = conn.getLayers();\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0SeLayer lyr = (SeLayer)layerList.get(4);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0SeSqlConstruct sqlConstruct = \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 new SeSqlConstruct(lyr.getQualifiedName());\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 String[] cols = new String[3];\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0cols[0] = \"BD_NM\";\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0cols[1] = \"BD_MGT_SN\";\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0cols[2] = \"SHAPE\";\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeQuery query = new SeQuery(conn, cols, sqlConstruct);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0query.prepareQuery();\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/ Add New Codes\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeShape filterShape = new SeShape(lyr.getCoordRef());\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0SeExtent ext = new SeExtent(148574, 146403, 148587, 146412);\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0filterShape.generateRectangle(ext); \r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeShapeFilter filter = new SeShapeFilter(lyr.getQualifiedName(), \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0lyr.getSpatialColumn(), filterShape, SeShapeFilter.METHOD_AI);\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeShapeFilter[] filters = new SeShapeFilter[1];\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 filters[0] = filter;\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 query.setSpatialConstraints(SeQuery.SE_SPATIAL_FIRST, \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 false, filters);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/ At Here!\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 query.execute();\r\n\u00a0 \u00a0\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0SeRow row;\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0while((row = query.fetch()) != null)\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0{\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeShape shp = row.getShape(2);\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0double coordinates[][][] = shp.getAllCoords();\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0System.out.println(\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"coordinates.length = \" + coordinates.length);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"coordinates[0].length = \" + coordinates[0].length);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0System.out.println(\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"coordinates[0][0].length = \" + coordinates[0][0].length);\r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 double partCoords[] = coordinates[0][0];\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0for(int i=0; i<partCoords.length; i+=2) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"(X:\" + partCoords[i] + \", Y:\" + partCoords[i+1] + \")\");\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0}\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 } catch(SeException e) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 e.printStackTrace();\r\n\u00a0\u00a0 \u00a0}\r\n}<\/pre>\n<p>\ucf54\ub4dc \ubc88\ud638 29~42\uc5d0 \ud574\ub2f9\ud558\ub294 \uc0c8\ub85c\uc6b4 \ucf54\ub4dc\uac00 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc644\uc804\ud558 SELECT \uad6c\ubb38\uc5d0 \ub300\ud55c SQL \ubb38\uc73c\ub85c Row\uc744 \uc77d\uc5b4 \uc624\ub294 \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>import java.util.*; \u00a0 \r\nimport com.esri.sde.sdk.client.*; \r\n\r\npublic class TestArcSDEQuery {\r\n\u00a0\u00a0 \u00a0public static void main(String[] args) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 SeConnection conn = null; \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 String server = \"222.237.78.208\"; \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 int service = 5151; \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 String database = \"\"; \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 String user = \"na_gis\"; \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 String password = \"na_gis\"; \u00a0 \r\n\r\n\u00a0 \u00a0 \u00a0 \u00a0 try {\r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0conn = new SeConnection(server, service, database, user, password); \r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeQuery query = new SeQuery(conn); \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 query.prepareSql(\"SELECT * FROM CC_META\");\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 query.execute(); \u00a0 \r\n\u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0SeRow row;\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 while((row = query.fetch()) != null) \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 int cntFields = query.getNumColumns();\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SeColumnDefinition[] tableDef = row.getColumns();\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 for(int iField=0; iField<cntFields; ++iField)\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 int fieldType = tableDef[iField].getType();\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 String fieldName = tableDef[iField].getName();\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Object valueObj = row.getObject(iField);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0if(valueObj == null)\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(fieldName + \": NULL\");\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 continue;\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0if(fieldType == SeColumnDefinition.TYPE_INT16) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 int value = (Short)valueObj;\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(fieldName + \":\" + value);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } else if(fieldType == SeColumnDefinition.TYPE_INT32) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 int value = (Integer)valueObj;\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(fieldName + \":\" + value);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } else if(fieldType == SeColumnDefinition.TYPE_FLOAT32) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 float value = (Float)valueObj;\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(fieldName + \":\" + value);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } else if(fieldType == SeColumnDefinition.TYPE_FLOAT64) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 double value = (Double)valueObj;\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(fieldName + \":\" + value);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } else if(fieldType == SeColumnDefinition.TYPE_STRING \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 || fieldType == SeColumnDefinition.TYPE_NSTRING) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 String value = (String)valueObj;\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(fieldName + \":\" + value);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } else {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(fieldName + \":\" + \"UNKNOWN\");\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 System.out.println(\"-----------------------\");\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\u00a0 \u00a0\r\n\u00a0 \u00a0 \u00a0 \u00a0 } catch(SeException e) { \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 e.printStackTrace(); \u00a0 \r\n\u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \r\n\u00a0 \u00a0 }\r\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\ud658\uacbd\uc740 ArcSDE 9.2\uc774\uace0..\u00a0 ArcSDE \uc11c\ube44\uc2a4 \ud329\uc740 \uc124\uce58\ud558\uc9c0 \uc54a\uc558\uc73c\uba70 \uc624\ub77c\ud074\uc740 10g \ubc84\uc804\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 ArcSDE\uc5d0 \ub300\ud55c \uc790\ubc14 API\ub294 ArcSDE 9.2 \uc11c\ube44\uc2a4\ud3296\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4. \ucc38\uace0\ub85c \uc790\ubc14 API\ub97c \uad6c\uc131\ud558\ub294 jar \ud30c\uc77c\uc740 \ub2e4\uc74c\uacfc \uac19\uc73c\uba70 \ubaa8\ub450 \ubc18\ub4dc\uc2dc.. \ud544\uc694\ud569\ub2c8\ub2e4. jsde92_sdk.jar jpe92_sdk.jar icu4j_3_2.jar \ub124.. \uc774\uc81c ArcSDE\uc640 \uc5f0\ub3d9\ud558\uae30 \uc704\ud55c \uc790\ubc14 API\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.. \uba3c\uc800 \uc5f0\uacb0\uc5d0 \ub300\ud55c \ucf54\ub4dc\uc785\ub2c8\ub2e4.. import java.util.*; import com.esri.sde.sdk.client.*; public class MainEntry { &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1301\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;[GIS] \uc790\ubc14 API\ub97c \uc774\uc6a9\ud55c ArcSDE 9.2 \uc5f0\ub3d9&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[60,8],"tags":[66,5],"class_list":["post-1301","post","type-post","status-publish","format-standard","hentry","category-java","category-programming","tag-arcsde","tag-gis"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1301"}],"version-history":[{"count":5,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1301\/revisions"}],"predecessor-version":[{"id":4410,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1301\/revisions\/4410"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1301"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}