GeoService-Xr\uc740 \uc5f0\uacb0\ub41c DBMS\uc5d0 \ub300\ud574 SQL\ubb38 \uc2e4\ud589\uc744 \ub300\uc2e0\ud574 \uc8fc\uace0 \uadf8 \uacb0\uacfc\ub97c \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uac8c JSON \ud615\uc2dd\uc73c\ub85c \uc804\uc1a1\ud574 \uc8fc\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574\uc11c \uc2e4\ud589\ud560 SQL \ubb38\uc774 \uc815\uc758\ub41c \ud30c\uc77c\uc774 \uc11c\ubc84\uce21\uc5d0 \ud544\uc694\ud55c\ub370\uc694. \uc544\ub798\ub294 \uadf8 \ud55c\uac00\uc9c0 \uc608\uc785\ub2c8\ub2e4.<\/p>\n
\r\n{\r\n \"metadata\": {\r\n \"startToken\": \"{$\",\r\n \"endToken\": \"}\"\r\n },\r\n\t\r\n \"sql\": {\r\n \"getLayers\": \"SELECT layers FROM core_users LIMIT 1\",\r\n \"getBuildingsByRoadCode\": \"SELECT ST_AsText(the_geom) FROM buld_a WHERE rn_cd ='{$road_cd}' LIMIT 1\",\r\n \"addUseLog\": \"INSERT INTO core_uselog (systemname, username) VALUES('{$systemName}', '{$userName}')\" \t\r\n }\r\n}\r\n<\/pre>\n\uc704\uc758 \ub0b4\uc6a9\uc5d0 \uaddc\uce59\uc774 \uc874\uc7ac\ud558\ub294\ub370\uc694. sql \ubb38\uc758 id\uac00 get\uc73c\ub85c \uc2dc\uc791\ud558\ub294 getLayers\ub098 getBuildingsByRoadCode\ub294 \ubc18\ub4dc\uc2dc SELECT \ubb38\uc774\uc5ec\uc57c \ud558\uace0, add\ub85c \uc2dc\uc791\ud55c\ub2e4\uba74 INSERT \ubb38, del\ub85c \uc2dc\uc791\ud558\uba74 DELETE \ubb38, set\uc73c\ub85c \uc2dc\uc791\ud558\uba74 UPDATE \ubb38\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc704\uc758 SQL \uc815\uc758 \ud30c\uc77c\uc758 \uc774\ub984\uc774 SQL.json\uc774\ub77c\uace0 \ud55c\ub2e4\uba74, GeoService-Xr\uc758 \ud658\uacbd\uc124\uc815 \ud30c\uc77c\uc778 XrConfig.xml\uc5d0 \ub2e4\uc74c\ucc98\ub7fc \uae30\uc220\ub418\uc5b4\uc838\uc57c GeoService-Xr\uc774 \uc2e4\ud589\ub420\ub54c SQL \ubb38\uc774 \ub85c\ub529\ub418\uc5b4 \uc2e4\ud589\ud560 \uc900\ube44\uac00 \uc644\ub8cc\ub429\ub2c8\ub2e4..<\/p>\n
\r\n\r\n ....\r\n\r\n d:\/config\/SQL.json<\/SqlFile>\r\n<\/Config>\r\n<\/pre>\n\uc704\uc640 \uac19\uc740 \uc900\ube44\uac00 \ub418\uba74, \ud074\ub77c\uc774\uc5b8\ud2b8 \uce21\uc5d0\uc11c SQL \ubb38\uc744 \ud638\ucd9c\ud560 \uc218 \uc788\ub294\ub370\uc694. \uc544\ub798\ub294 javascript \ubb38\uc744 \ud1b5\ud574 \uc2e4\ud589\ud55c \ub0b4\uc6a9\uc758 \uc608\uc785\ub2c8\ub2e4.<\/p>\n
\r\nvar road_cd = this._CodeMap_Road[name];\r\n\r\n$.ajax({\r\n url: url = ConfigValues.GIS_SERVER + \"\/Xr?rsql|getBuildingsByRoadCode|\" + ConfigValues.DB_NAME,\r\n type: \"POST\",\r\n crossDomain: true,\r\n data: \"road_cd:=\" + road_cd + \"\\nparam2:=param2\", \/\/ \ud30c\ub77c\uba54\ud130\uc758 \uad6c\ubd84\uc740 \\n \ubb38\uc790\ub85c \ud568\r\n dataType: \"text\",\r\n success: function (response) {\r\n \/\/ Java, C\/C++ \ub4f1\uacfc \uac19\uc740 \uc5b8\uc5b4\uc758 \ud3b8\uc758\uc131\uc744 \uc704\ud574 \uacb0\uacfc\uc758 \ub05d\uc5d0 \\0\uc774 \ubd99\uc74c\r\n \/\/ javascript\uc5d0\uc11c json\uc73c\ub85c \ud30c\uc2f1\ud558\uae30 \uc704\ud574 response \ubb38\uc790\uc5f4 \ub05d\uc5d0 \\0 \ubb38\uc790\ub97c \uc81c\uac70\ud574\uc57c \ud568\r\n response = response.substr(0, response.length - 1); \r\n response = JSON.parse(response);\r\n \r\n ...\r\n },\r\n\r\n error: function (xhr, status) {\r\n alert(\"ERROR\");\r\n }\r\n});\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"GeoService-Xr\uc740 \uc5f0\uacb0\ub41c DBMS\uc5d0 \ub300\ud574 SQL\ubb38 \uc2e4\ud589\uc744 \ub300\uc2e0\ud574 \uc8fc\uace0 \uadf8 \uacb0\uacfc\ub97c \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uac8c JSON \ud615\uc2dd\uc73c\ub85c \uc804\uc1a1\ud574 \uc8fc\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574\uc11c \uc2e4\ud589\ud560 SQL \ubb38\uc774 \uc815\uc758\ub41c \ud30c\uc77c\uc774 \uc11c\ubc84\uce21\uc5d0 \ud544\uc694\ud55c\ub370\uc694. \uc544\ub798\ub294 \uadf8 \ud55c\uac00\uc9c0 \uc608\uc785\ub2c8\ub2e4. { “metadata”: { “startToken”: “{$”, “endToken”: “}” }, “sql”: { “getLayers”: “SELECT layers FROM core_users LIMIT 1”, “getBuildingsByRoadCode”: “SELECT ST_AsText(the_geom) FROM buld_a WHERE rn_cd ='{$road_cd}’ … <\/p>\n