{"id":4858,"date":"2017-07-12T11:04:46","date_gmt":"2017-07-12T02:04:46","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=4858"},"modified":"2020-05-28T14:24:11","modified_gmt":"2020-05-28T05:24:11","slug":"mariadb%ec%9d%98-jdbc-%ec%97%b0%ea%b2%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=4858","title":{"rendered":"MariaDB\uc758 JDBC \uc5f0\uacb0"},"content":{"rendered":"<p>MySQL\uc5d0\uc11c \ud30c\uc0dd\ub41c MariaDB\ub97c \ud504\ub85c\uc81d\ud2b8\uc5d0 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\ub370\uc694. \uc774 MariaDB\ub97c Java\uc5d0\uc11c \uc5f0\uacb0\ud574 \ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uae30 \uc704\ud574 JDBC\ub97c \uc0ac\uc6a9\ud558\ub294 \ucf54\ub4dc\ub97c \uc815\ub9ac\ud574 \ub461\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.PreparedStatement;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\n\r\npublic class MainEntry {\r\n    public static void main(String[] args) {\r\n        Connection con = null;\r\n        PreparedStatement pstmt = null;   \r\n        ResultSet rs = null;\r\n\r\n        try {\r\n            Class.forName(\"org.mariadb.jdbc.Driver\");\r\n\t\t\t\r\n            con = DriverManager.getConnection(\r\n                \"jdbc:mariadb:\/\/100.100.100.7:3306\/dbname\",\r\n                \"userId\",\r\n                \"password\");\r\n\t\t\t\t\t\t\r\n            pstmt = con.prepareStatement(\"select * from his_bus_voltage\");\r\n\t\t\t\r\n            rs = pstmt.executeQuery();\r\n\t\t\t\r\n            while(rs.next()) {\r\n                \/\/.\r\n            }\r\n        } catch(Exception e) {\r\n            e.printStackTrace();\r\n        } finally {\r\n            try {\r\n                if(rs != null) {\r\n                    rs.close(); \/\/ \uc120\ud0dd \uc0ac\ud56d\r\n                }\r\n\t\t\t\t\r\n                if(pstmt != null) {\r\n                    pstmt.close(); \/\/ \uc120\ud0dd\uc0ac\ud56d\uc774\uc9c0\ub9cc \ud638\ucd9c \ucd94\ucc9c\r\n                }\r\n\t\t\t\r\n                if(con != null) {\r\n                    con.close(); \/\/ \ud544\uc218 \uc0ac\ud56d\r\n                }\r\n            } catch (SQLException e) {\r\n                e.printStackTrace();\r\n            }\r\n        }\r\n    }\r\n}\r\n<\/pre>\n<p>MariaDB\uc758 JDBC \ub77c\uc774\ube0c\ub7ec\ub9ac\ub294 \uacf5\uc2dd \uc0ac\uc774\ud2b8\uc778 https:\/\/downloads.mariadb.org\/connector-java\/\uc5d0\uc11c \ub2e4\uc6b4\ub85c\ub4dc\ubc1b\uc558\uc73c\uba70, \uc774 \uae00\uc744 \uc791\uc131\ud560 \ub54c\ub294 mariadb-java-client-2.0.3.jar\ub97c \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\uc5d0\uc11c \ud30c\uc0dd\ub41c MariaDB\ub97c \ud504\ub85c\uc81d\ud2b8\uc5d0 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\ub370\uc694. \uc774 MariaDB\ub97c Java\uc5d0\uc11c \uc5f0\uacb0\ud574 \ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uae30 \uc704\ud574 JDBC\ub97c \uc0ac\uc6a9\ud558\ub294 \ucf54\ub4dc\ub97c \uc815\ub9ac\ud574 \ub461\ub2c8\ub2e4. import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class MainEntry { public static void main(String[] args) { Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; try { Class.forName(&#8220;org.mariadb.jdbc.Driver&#8221;); con &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=4858\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;MariaDB\uc758 JDBC \uc5f0\uacb0&#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-4858","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\/4858","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=4858"}],"version-history":[{"count":3,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4858\/revisions"}],"predecessor-version":[{"id":9665,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4858\/revisions\/9665"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4858"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}