{"id":1597,"date":"2012-02-01T05:02:11","date_gmt":"2012-02-01T05:02:11","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1597"},"modified":"2017-01-27T19:18:04","modified_gmt":"2017-01-27T10:18:04","slug":"fingereyes-update-insert-delete-sql-%eb%ac%b8-%ec%8b%a4%ed%96%89","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1597","title":{"rendered":"[GIS] FingerEyes, UPDATE, INSERT, DELETE SQL \ubb38 \uc2e4\ud589"},"content":{"rendered":"

\ud551\uac70\uc544\uc774\uc988\ub294 \uc11c\ubc84\uce21\uc758 DBMS\uc5d0 UPDATE, INSERT, DELETE\uc640 \uac19\uc740 SQL \ubb38\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \uc694\uccad\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \ucf54\ub4dc\ub294 \uadf8 \uc608\uc785\ub2c8\ub2e4.<\/p>\n

var svc:XrUpdateTableService = new XrUpdateTableService(\r\n    \"127.0.0.1:8076\",\r\n    \"postgis\",\r\n    __completed,\r\n    __error\r\n);\r\n\r\nvar sql:String = \"INSERT INTO tstTbl VALUES (100, '\uc548\ub155\ud558\uc138\uc694!')\";\r\n\r\nsvc.run({sql:sql});<\/pre>\n
SQL\ubb38\uc758 \uc2e4\ud589\uc744 \uc11c\ubc84\uce21\uc5d0 \uc694\uccad\ud558\uace0 \uadf8 \uacb0\uacfc\ub97c \ubc1b\uc544\uc624\ub294 \uc77c\ub828\uc758 \uacfc\uc815\uc744 \uc0ac\uc6a9\ud558\uae30 \uc27d\uac8c \ucea1\uc290\ud654\ub41c XrUpdateTableService \ud074\ub798\uc2a4\ub97c \uc774\uc6a9\ud569\ub2c8\ub2e4. \uc11c\ubc84\uc758 IP\uc640 \uc0ac\uc6a9\ud558\ub294 DBMS\uc758 \uc885\ub958 \uadf8\ub9ac\uace0 SQL \ubb38\uc774 \uc11c\ubc84\uce21\uc5d0\uc11c \uc131\uacf5\uc801\uc73c\ub85c \uc2e4\ud589\ub418\uc5c8\uc744\ub54c\uc640 \uc2e4\ud328\ud588\uc744\ub54c\uc5d0 \ub300\ud55c \ucf5c\ubc31\ud568\uc218\ub97c \uc0dd\uc131\uc790\uc758 \uc778\uc790\ub85c \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/p>\n
\uc544\ub798\ub294 SQL\ubb38\uc774 \uc131\uacf5\uc801\uc73c\ub85c \uc2e4\ud589\ub418\uc5c8\uc744\ub54c\uc640 \uc2e4\ud328\ud588\uc744\ub54c\uc5d0 \ub300\ud55c \ucf5c\ubc31\ud568\uc218\uc758 \uc608\uc785\ub2c8\ub2e4.<\/p>\n
protected function __completed(cntRowUpdated:uint):void\r\n{\r\n    \/\/ cntRowUpdated\ub294 SQL\ubb38\uc758 \uc2e4\ud589\uc5d0 \uc758\ud574 \uc601\ud5a5\uc744 \ubc1b\uc740 Row\uc758 \uc218\r\n}\r\n\r\nprotected function __error():void\r\n{\r\n    \/\/ SQL \uc2e4\ud589\ud558\ub294\ub370 \ubb38\uc81c \uc788\uc74c\r\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"
\ud551\uac70\uc544\uc774\uc988\ub294 \uc11c\ubc84\uce21\uc758 DBMS\uc5d0 UPDATE, INSERT, DELETE\uc640 \uac19\uc740 SQL \ubb38\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \uc694\uccad\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \ucf54\ub4dc\ub294 \uadf8 \uc608\uc785\ub2c8\ub2e4. var svc:XrUpdateTableService = new XrUpdateTableService( “127.0.0.1:8076”, “postgis”, __completed, __error ); var sql:String = “INSERT INTO tstTbl VALUES (100, ‘\uc548\ub155\ud558\uc138\uc694!’)”; svc.run({sql:sql}); SQL\ubb38\uc758 \uc2e4\ud589\uc744 \uc11c\ubc84\uce21\uc5d0 \uc694\uccad\ud558\uace0 \uadf8 \uacb0\uacfc\ub97c \ubc1b\uc544\uc624\ub294 \uc77c\ub828\uc758 \uacfc\uc815\uc744 \uc0ac\uc6a9\ud558\uae30 \uc27d\uac8c \ucea1\uc290\ud654\ub41c XrUpdateTableService \ud074\ub798\uc2a4\ub97c \uc774\uc6a9\ud569\ub2c8\ub2e4. \uc11c\ubc84\uc758 … <\/p>\n
\ub354 \ubcf4\uae30 “[GIS] FingerEyes, UPDATE, INSERT, DELETE SQL \ubb38 \uc2e4\ud589”<\/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-1597","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\/1597","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=1597"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1597\/revisions"}],"predecessor-version":[{"id":3097,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1597\/revisions\/3097"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1597"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}