{"id":5065,"date":"2018-02-01T16:36:34","date_gmt":"2018-02-01T07:36:34","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=5065"},"modified":"2020-05-28T14:08:09","modified_gmt":"2020-05-28T05:08:09","slug":"geoservice-xr%ec%9d%98-sql-%ec%8b%a4%ed%96%89-%ec%84%9c%eb%b9%84%ec%8a%a4-%ed%98%b8%ec%b6%9c-%ec%bd%94%eb%93%9c","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=5065","title":{"rendered":"GeoService-Xr\uc758 SQL \uc2e4\ud589 \uc11c\ube44\uc2a4 \ud638\ucd9c \ucf54\ub4dc"},"content":{"rendered":"<p>GeoService-Xr\uc5d0\uc11c DBMS\ub97c \ub300\uc0c1\uc73c\ub85c Query \ubb38\uc744 \ud638\ucd9c\ud558\ub294 \ucf54\ub4dc\ub97c \uc815\ub9ac\ud574 \ub461\ub2c8\ub2e4. GET \ubc29\uc2dd\uacfc POST \ubc29\uc2dd \ubaa8\ub450 \uc801\uc6a9\ud560 \uc218 \uc788\ub294\ub370\uc694. \uba3c\uc800 POST \ubc29\uc2dd\uc5d0 \ub300\ud55c \uc608\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"js\">\r\nsql = \"SELECT USER_ID, SEC_NUM, NAM, EMAIL from web_user_man\";\r\nurl = \"http:\/\/168.192.76.103:8080\/Xr?sql|BzSewage|1\";\r\n                        \r\n$.ajax({\r\n    url: url,\r\n    type: \"POST\",\r\n    crossDomain: true,\r\n    data: sql,\r\n    dataType: \"text\",\r\n    \r\n    success: function (response) {\r\n        response = response.substr(0, response.length - 1); \/\/ data \ubb38\uc790\uc5f4 \ub05d\uc5d0 \\0 \ubb38\uc790\ub97c \uc81c\uac70\r\n        response = JSON.parse(response);\r\n\r\n        \/\/ ...\r\n    },\r\n\r\n    error: function (xhr, status) {\r\n        alert(\"ajax error\");\r\n    }\r\n});\r\n<\/pre>\n<p>\uc544\ub798\ub294 \uc704\uc640 \ub3d9\uc77c\ud55c SQL \ubb38\uc5d0 \ub300\ud574 GET \ubc29\uc2dd\uc73c\ub85c \ud638\ucd9c\ud55c \uc608\uc785\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"js\">\r\nsql = \"SELECT USER_ID, SEC_NUM, NAM, EMAIL from web_user_man\";\r\nurl = \"http:\/\/168.192.76.103:8080\/Xr?sql|\" + encodeURIComponent(sql) + \"|BzSewage|1\";\r\n\r\n$.ajax({\r\n    url: url,\r\n    type: \"GET\",\r\n    crossDomain: true,\r\n    dataType: \"text\",\r\n\r\n    success: function (response) {\r\n        response = response.substr(0, response.length - 1); \/\/ data \ubb38\uc790\uc5f4 \ub05d\uc5d0 \\0 \ubb38\uc790\ub97c \uc81c\uac70\r\n        response = JSON.parse(response);\r\n\r\n        \/\/ ...\r\n    },\r\n\r\n    error: function (xhr, status) {\r\n        alert(\"ajax error\");\r\n    }\r\n});\r\n<\/pre>\n<p>\uc774\ub7f0 \ubc29\uc2dd\uc740 \uac1c\ubc1c \ub2e8\uacc4\uc5d0\uc11c \ubcc4\ub3c4\uc758 \uc11c\ubc84\uc124\uc815\uc5c6\uc774 \ubc14\ub85c SQL \ubb38\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\ub294\ub370\uc694. \ucd5c\uc885\uc801\uc73c\ub85c\ub294 SQL \ubb38\uc744 \uc774\ucc98\ub7fc \ucf54\ub4dc \ub2e8\uc5d0 \ub2f4\uae30 \ubcf4\ub2e4\ub294 <a href='http:\/\/www.gisdeveloper.co.kr\/?p=5045'>GeoService-Xr\uc758 SQL \uc2e4\ud589 \uc11c\ube44\uc2a4<\/a>\uc758 \ubc29\uc2dd\uc73c\ub85c \ubcc0\uacbd\ud574 \uc18c\uc2a4\ucf54\ub4dc\ub97c \ubc30\ud3ec\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>GeoService-Xr\uc5d0\uc11c DBMS\ub97c \ub300\uc0c1\uc73c\ub85c Query \ubb38\uc744 \ud638\ucd9c\ud558\ub294 \ucf54\ub4dc\ub97c \uc815\ub9ac\ud574 \ub461\ub2c8\ub2e4. GET \ubc29\uc2dd\uacfc POST \ubc29\uc2dd \ubaa8\ub450 \uc801\uc6a9\ud560 \uc218 \uc788\ub294\ub370\uc694. \uba3c\uc800 POST \ubc29\uc2dd\uc5d0 \ub300\ud55c \uc608\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. sql = &#8220;SELECT USER_ID, SEC_NUM, NAM, EMAIL from web_user_man&#8221;; url = &#8220;http:\/\/168.192.76.103:8080\/Xr?sql|BzSewage|1&#8221;; $.ajax({ url: url, type: &#8220;POST&#8221;, crossDomain: true, data: sql, dataType: &#8220;text&#8221;, success: function (response) { response = response.substr(0, response.length &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=5065\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;GeoService-Xr\uc758 SQL \uc2e4\ud589 \uc11c\ube44\uc2a4 \ud638\ucd9c \ucf54\ub4dc&#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":[50],"tags":[],"class_list":["post-5065","post","type-post","status-publish","format-standard","hentry","category-gisdev"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5065","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=5065"}],"version-history":[{"count":4,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5065\/revisions"}],"predecessor-version":[{"id":9629,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5065\/revisions\/9629"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5065"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5065"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}