{"id":2028,"date":"2014-04-07T09:08:00","date_gmt":"2014-04-07T09:08:00","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=2028"},"modified":"2017-01-27T10:58:36","modified_gmt":"2017-01-27T01:58:36","slug":"java%ec%97%90%ec%84%9c-post-%eb%b0%a9%ec%8b%9d%ec%9c%bc%eb%a1%9c-geoservice-x%ec%97%90-sql-%ec%bf%bc%eb%a6%ac-%ec%9a%94%ec%b2%ad","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=2028","title":{"rendered":"Java\uc5d0\uc11c POST \ubc29\uc2dd\uc73c\ub85c GeoService-X\uc5d0 SQL \ucffc\ub9ac \uc694\uccad"},"content":{"rendered":"<p>GeoService-Xr \uacf5\uac04\uc11c\ubc84\uc5d0 \uc9c1\uc811 Java \uc5b8\uc5b4\ub85c SELECT \uad6c\ubb38\uacfc \ucffc\ub9ac\ub97c \uc694\uccad\ud558\ub294 \ucf54\ub4dc Keeping .. <\/p>\n<pre>\r\ntry {\r\n    URL url = new URL(\"http:\/\/X.X.X.X:8078\/Xr?sql|oracle|0\");\r\n    HttpURLConnection httpConn = (HttpURLConnection)url.openConnection();\r\n    httpConn.setUseCaches(false);\r\n    httpConn.setDoOutput(true);\r\n    httpConn.setRequestMethod(\"POST\");\r\n    OutputStream outputStream = httpConn.getOutputStream();\r\n    String sql \r\n        = \"SELECT IDN, CDE, MNG FROM TBLNAME WHERE IDN=2437\";\r\n    byte[] bytesSql = sql.getBytes();\r\n    ByteBuffer bb = ByteBuffer.allocate(bytesSql.length + 1 + 4);\r\n\t\t\t\r\n    bb.order(ByteOrder.BIG_ENDIAN);\r\n    bb.putInt(bytesSql.length + 1);\r\n    bb.put(bytesSql);\r\n    bb.put((byte)0);\r\n    bb.flip();\r\n\t\t\t\r\n    byte[] bytes = bb.array();\r\n    outputStream.write(bytes);\r\n    outputStream.close();\r\n\t\t\t\r\n    int responseCode = httpConn.getResponseCode();\r\n    if(responseCode == HttpURLConnection.HTTP_OK) {\r\n        BufferedReader reader \r\n            = new BufferedReader(new InputStreamReader(httpConn.getInputStream()));\r\n        System.out.println(\"Server's response: \");\r\n        while(true) {\r\n            String response = reader.readLine();\r\n            if(response == null) break;\r\n            System.out.println(\"\\t\" + response);\r\n        }\r\n    } else {\r\n        System.out.println(\"Server returned non-Ok code: \" + responseCode);\r\n    }\r\n} catch (Exception e) {\r\n    e.printStackTrace();\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>GeoService-Xr \uacf5\uac04\uc11c\ubc84\uc5d0 \uc9c1\uc811 Java \uc5b8\uc5b4\ub85c SELECT \uad6c\ubb38\uacfc \ucffc\ub9ac\ub97c \uc694\uccad\ud558\ub294 \ucf54\ub4dc Keeping .. try { URL url = new URL(&#8220;http:\/\/X.X.X.X:8078\/Xr?sql|oracle|0&#8221;); HttpURLConnection httpConn = (HttpURLConnection)url.openConnection(); httpConn.setUseCaches(false); httpConn.setDoOutput(true); httpConn.setRequestMethod(&#8220;POST&#8221;); OutputStream outputStream = httpConn.getOutputStream(); String sql = &#8220;SELECT IDN, CDE, MNG FROM TBLNAME WHERE IDN=2437&#8221;; byte[] bytesSql = sql.getBytes(); ByteBuffer bb = ByteBuffer.allocate(bytesSql.length + 1 + 4); bb.order(ByteOrder.BIG_ENDIAN); bb.putInt(bytesSql.length &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=2028\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;Java\uc5d0\uc11c POST \ubc29\uc2dd\uc73c\ub85c GeoService-X\uc5d0 SQL \ucffc\ub9ac \uc694\uccad&#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":[8],"tags":[],"class_list":["post-2028","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2028","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=2028"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2028\/revisions"}],"predecessor-version":[{"id":2871,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2028\/revisions\/2871"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2028"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}