{"id":9104,"date":"2020-04-22T12:31:11","date_gmt":"2020-04-22T03:31:11","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=9104"},"modified":"2020-05-28T09:31:10","modified_gmt":"2020-05-28T00:31:10","slug":"tibero%ec%9d%98-jdbc-%ec%97%b0%ea%b2%b0%ec%97%90-%eb%8c%80%ed%95%9c-%ec%98%88%ec%a0%9c","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=9104","title":{"rendered":"Tibero\uc758 JDBC \uc5f0\uacb0\uc5d0 \ub300\ud55c \uc608\uc81c"},"content":{"rendered":"<p>\ud2f0\ubca0\ub85c\uc5d0 \ub300\ud55c JDBC \uc5f0\uacb0 \ubc0f \ucffc\ub9ac \uc608\uc81c\uc785\ub2c8\ub2e4. \ud2f0\ubca0\ub85c\uc758 JDBC \ub4dc\ub77c\uc774\ube0c\uc5d0 \ub300\ud55c jar\ub294 \ud2f0\ubca0\ub85c\uac00 \uc124\uce58\ub41c \ub514\ub809\ud1a0\ub9ac client\/lib\/jar\uc5d0 tibero6-jdbc.jar \ud30c\uc77c \ud558\ub098\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc544\ub798\uc758 \ucf54\ub4dc\ub294 \uc608\uc81c \ucf54\ub4dc\uc785\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 DBMS\uc5d0 \ub300\ud55c JDBC\uc5d0 \ub300\ud55c \uc608\uc81c \ucf54\ub4dc\uac00 \ube44\uc2b7\ud55c \ud328\ud134\uc774\ubbc0\ub85c \uc124\uba85\uc740 \uc0dd\ub7b5\ud569\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">\r\npackage tstTibero;\r\n\r\nimport java.sql.Connection; \r\nimport java.sql.DriverManager; \r\nimport java.sql.ResultSet; \r\nimport java.sql.ResultSetMetaData; \r\nimport java.sql.SQLException; \r\nimport java.sql.Statement;\r\n\r\npublic class MainEntry {\r\n    private String ip = \"192.168.0.254\";\r\n    private int port = 8629;\r\n    private String database = \"tibero\";\r\n    private String user = \"sys\";\r\n    private String password = \"tibero\";\r\n\t\r\n    private final String DRIVER_NAME = \"com.tmax.tibero.jdbc.TbDriver\";\r\n    private final String TIBERO_JDBC_URL = \"jdbc:tibero:thin:@\" + ip + \":\" + port + \":\" + database;\r\n\t\r\n    private Connection conn = null;\r\n\r\n    private void connect() {\r\n        try {\r\n\t    Class.forName(DRIVER_NAME);\r\n            conn = DriverManager.getConnection(TIBERO_JDBC_URL, user, password);\r\n        } catch(ClassNotFoundException e) {\r\n            System.err.println(e);\r\n        } catch(SQLException e) {\r\n            System.err.println(e);\r\n        }\r\n    }\r\n\t\r\n    private void executeQuery() {\r\n        String sql = \"select ST_AsText(GEOM) from tstGIS\";\r\n        try {\r\n            Statement stmt = conn.createStatement();\r\n            ResultSet rs = stmt.executeQuery(sql);\r\n\t\t\t\r\n            while(rs.next()) {\r\n                System.out.println(rs.getString(1));\r\n            }\r\n        } catch(SQLException e) {\r\n            System.err.println(e);\r\n        }\r\n    }\r\n\t\r\n    private void disconnect() {\r\n        if(conn != null) {\r\n            try {\r\n                conn.close();\r\n            } catch(SQLException e) {\r\n                System.err.println(e);\r\n            }\r\n        }\r\n    }\r\n\t\r\n    public static void main(String[] args) {\r\n        MainEntry tibero = new MainEntry();\r\n\t\t\r\n        tibero.connect();\r\n        tibero.executeQuery();\r\n        tibero.disconnect();\r\n    }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\ud2f0\ubca0\ub85c\uc5d0 \ub300\ud55c JDBC \uc5f0\uacb0 \ubc0f \ucffc\ub9ac \uc608\uc81c\uc785\ub2c8\ub2e4. \ud2f0\ubca0\ub85c\uc758 JDBC \ub4dc\ub77c\uc774\ube0c\uc5d0 \ub300\ud55c jar\ub294 \ud2f0\ubca0\ub85c\uac00 \uc124\uce58\ub41c \ub514\ub809\ud1a0\ub9ac client\/lib\/jar\uc5d0 tibero6-jdbc.jar \ud30c\uc77c \ud558\ub098\uc785\ub2c8\ub2e4. \uc544\ub798\uc758 \ucf54\ub4dc\ub294 \uc608\uc81c \ucf54\ub4dc\uc785\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 DBMS\uc5d0 \ub300\ud55c JDBC\uc5d0 \ub300\ud55c \uc608\uc81c \ucf54\ub4dc\uac00 \ube44\uc2b7\ud55c \ud328\ud134\uc774\ubbc0\ub85c \uc124\uba85\uc740 \uc0dd\ub7b5\ud569\ub2c8\ub2e4. package tstTibero; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; public class MainEntry { private String ip &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=9104\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;Tibero\uc758 JDBC \uc5f0\uacb0\uc5d0 \ub300\ud55c \uc608\uc81c&#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":[1],"tags":[],"class_list":["post-9104","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9104","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=9104"}],"version-history":[{"count":4,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9104\/revisions"}],"predecessor-version":[{"id":9321,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9104\/revisions\/9321"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9104"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}