GeoService-Xr 공간서버에 직접 Java 언어로 SELECT 구문과 쿼리를 요청하는 코드 Keeping ..
try { URL url = new URL("http://X.X.X.X:8078/Xr?sql|oracle|0"); HttpURLConnection httpConn = (HttpURLConnection)url.openConnection(); httpConn.setUseCaches(false); httpConn.setDoOutput(true); httpConn.setRequestMethod("POST"); OutputStream outputStream = httpConn.getOutputStream(); String sql = "SELECT IDN, CDE, MNG FROM TBLNAME WHERE IDN=2437"; byte[] bytesSql = sql.getBytes(); ByteBuffer bb = ByteBuffer.allocate(bytesSql.length + 1 + 4); bb.order(ByteOrder.BIG_ENDIAN); bb.putInt(bytesSql.length + 1); bb.put(bytesSql); bb.put((byte)0); bb.flip(); byte[] bytes = bb.array(); outputStream.write(bytes); outputStream.close(); int responseCode = httpConn.getResponseCode(); if(responseCode == HttpURLConnection.HTTP_OK) { BufferedReader reader = new BufferedReader(new InputStreamReader(httpConn.getInputStream())); System.out.println("Server's response: "); while(true) { String response = reader.readLine(); if(response == null) break; System.out.println("\t" + response); } } else { System.out.println("Server returned non-Ok code: " + responseCode); } } catch (Exception e) { e.printStackTrace(); }