{"id":1575,"date":"2012-01-04T06:51:45","date_gmt":"2012-01-04T06:51:45","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1575"},"modified":"2017-01-27T19:23:26","modified_gmt":"2017-01-27T10:23:26","slug":"fingereyes-sql-query-api-%ec%82%ac%ec%9a%a9%ec%98%88","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1575","title":{"rendered":"[GIS] FingerEyes, SQL Query API \uc0ac\uc6a9 \uc608"},"content":{"rendered":"<p>Flex \uae30\ubc18\uc758 GIS \uc5d4\uc9c4\uc778 \ud551\uac70\uc544\uc774\uc988\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \uc27d\uac8c \ucffc\ub9ac\ud560 \uc218 \uc788\ub294 \ub9e4\uc6b0 \uc190\uc26c\uc6b4 API\ub97c \ub0b4\uc7a5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. XrQueryTableService\ub77c\ub294 \ud074\ub798\uc2a4\ub85c \uc774\ub984\uc5d0\uc11c\ub3c4 \uc54c \uc218 \uc788\ub4ef\uc774 \ud14c\uc774\ube14\uc5d0 \ub300\ud574 \ucffc\ub9ac\ub97c \ub0a0\ub824\uc8fc\ub294 \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5\ud558\ub294 \ub140\uc11d\uc785\ub2c8\ub2e4. SQL \uad6c\ubb38 \uc911 SELECT \uad6c\ubb38\uc744 \ud1b5\ud574 \uc27d\uac8c \ub370\uc774\ud130\ub97c \uc9c8\uc758\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798\ub294 \uc774 \ud074\ub798\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \ud55c\uac00\uc9c0 \uc608\uc785\ub2c8\ub2e4.<\/p>\n<pre>var svc:XrQueryTableService = new XrQueryTableService(\r\n    \"127.0.0.1:8080\",\r\n    \"postgis\",\r\n    searchQueryRequestComplete,\r\n    searchQueryRequestError\r\n);\r\n\r\nvar select:String = \"SELECT * FROM yp_admindistrict_main\";\r\nsvc.run({sql:select});<\/pre>\n<p>DBMS\ub294 127.0.0.1:8080 \uc8fc\uc18c\uc5d0 \uc874\uc7ac\ud558\ub294 \uc11c\ubc84\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 DBMS\ub294 postgis\uc774\uad6c\uc694. arcsde\ub098 jdbc\ub85c\ub3c4 \uc9c0\uc815\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ucffc\ub9ac\uac00 \uc131\uacf5\ud588\uc744 \uc2dc searchQueryRequestComplete\ub77c\ub294 \ud568\uc218\uac00 \ucf5c\ubc31\ub418\uace0 \uc2e4\ud328\ud588\uc744 \uc2dc\uc5d0\ub294 searchQueryRequestError\ub77c\ub294 \ud568\uc218\uac00 \ucf5c\ubc31\ub429\ub2c8\ub2e4. \uc2e4\uc81c SQL\ubb38\uc758 \uc9c0\uc815\uc740 XrQueryTableService\uc758 run \ub9e4\uc11c\ub4dc\ub97c \ud1b5\ud574 \uc2e4\uc5b4 \ubcf4\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ucffc\ub9ac\uc2dc \uc131\uacf5\ud588\uc744 \ub54c\uc640 \uc2e4\ud328\ud588\uc744 \ub54c\uc758 \ucf5c\ubc31 \ud568\uc218\uc758 \uc608\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>private function searchQueryRequestComplete(result:String):void\r\n{\r\n    ta.text = result;\r\n}\r\n   \r\nprivate function searchQueryRequestError():void\r\n{\r\n    ta.text = \"err!\";\r\n}<\/pre>\n<p>\uc704\uc5d0\uc11c ta\ub294 Flex\uc758 TextArea \ucef4\ud3ec\ub10c\ud2b8\uc785\ub2c8\ub2e4. \ubc84\ud2bc\uc744 \ud074\ub9ad\ud588\uc744 \uc2dc \uc704\uc758 \ucf54\ub4dc\ub4e4\uc744 \ud1b5\ud574 \ucffc\ub9ac\ub97c \ub0a0\ub9ac\uace0 \uacb0\uacfc\ub97c \ubc1b\uc544 \ud654\uba74\uc5d0 \ud45c\uc2dc\ud558\ub294 \ud654\uba74\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1357029260.png\" class=\"aligncenter\" width=\"270\" height=\"492\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\ubcf4\uc2dc\ub294 \uac83\ucc98\ub7fc TextArea\uc5d0 \ucffc\ub9ac \uacb0\uacfc\uac00 XML \ud615\ud0dc\ub85c \ub118\uc5b4 \uc624\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud551\uac70\uc544\uc774\uc988\ub294 \uac1c\ubc1c\uc790\uac00 \uc27d\uac8c DBMS\uc5d0 \uc811\uadfc\ud558\uc5ec \uac1c\ubc1c\ud560 \uc218 \uc788\ub3c4\ub85d XrQueryTableService\ub77c\ub294 \ud074\ub798\uc2a4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774 \uc678\uc5d0\ub3c4 ID\ub97c \ud1b5\ud574 \uacf5\uac04 \ub3c4\ud615\uc758 MBR\uc744 \uac00\uc838\uc624\ub294 \uc11c\ube44\uc2a4 \ub4f1\ub3c4 \ud074\ub77c\uc774\uc5b8\ud2b8 \ub9f5 \uc5d4\uc9c4 \ub2e8\uc5d0\uc11c \uc81c\uacf5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Flex \uae30\ubc18\uc758 GIS \uc5d4\uc9c4\uc778 \ud551\uac70\uc544\uc774\uc988\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \uc27d\uac8c \ucffc\ub9ac\ud560 \uc218 \uc788\ub294 \ub9e4\uc6b0 \uc190\uc26c\uc6b4 API\ub97c \ub0b4\uc7a5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. XrQueryTableService\ub77c\ub294 \ud074\ub798\uc2a4\ub85c \uc774\ub984\uc5d0\uc11c\ub3c4 \uc54c \uc218 \uc788\ub4ef\uc774 \ud14c\uc774\ube14\uc5d0 \ub300\ud574 \ucffc\ub9ac\ub97c \ub0a0\ub824\uc8fc\ub294 \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5\ud558\ub294 \ub140\uc11d\uc785\ub2c8\ub2e4. SQL \uad6c\ubb38 \uc911 SELECT \uad6c\ubb38\uc744 \ud1b5\ud574 \uc27d\uac8c \ub370\uc774\ud130\ub97c \uc9c8\uc758\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798\ub294 \uc774 \ud074\ub798\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \ud55c\uac00\uc9c0 \uc608\uc785\ub2c8\ub2e4. var svc:XrQueryTableService = new XrQueryTableService( &#8220;127.0.0.1:8080&#8221;, &#8220;postgis&#8221;, searchQueryRequestComplete, &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1575\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;[GIS] FingerEyes, SQL Query API \uc0ac\uc6a9 \uc608&#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":[70],"tags":[69,5,53],"class_list":["post-1575","post","type-post","status-publish","format-standard","hentry","category-fingereyes-xr","tag-fingereyes","tag-gis","tag-xr"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1575","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=1575"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1575\/revisions"}],"predecessor-version":[{"id":3105,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1575\/revisions\/3105"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1575"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}