{"id":1143,"date":"2023-10-05T11:31:05","date_gmt":"2023-10-05T02:31:05","guid":{"rendered":"https:\/\/java.ihavenomoney.co.kr\/?page_id=1143"},"modified":"2023-10-05T11:36:11","modified_gmt":"2023-10-05T02:36:11","slug":"mariadb-%ec%97%b0%ea%b2%b0%ed%95%98%ea%b8%b0","status":"publish","type":"page","link":"https:\/\/java.ihavenomoney.co.kr\/?page_id=1143","title":{"rendered":"mariadb \uc5f0\uacb0\ud558\uae30"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Overview : mariadb \uc5f0\uacb0\ud558\uae30<\/h2>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:java decode:true \">import java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\nimport java.sql.Statement;\nimport java.util.Iterator;\n\npublic class TestJDBC \n{\n\tpublic static void main(String[] args) \n\t{\n\t\ttry \n\t\t{\n\t\t\tClass.forName(\"org.mariadb.jdbc.Driver\");\n\t\t\tConnection con = DriverManager.getConnection(\"jdbc:mariadb:\/\/localhost:3306\/Demo?user=admin&amp;password=admin\");\n\n\t\t\tStatement stmt = con.createStatement();\n\t\t\tResultSet rs = stmt.executeQuery(\"select * from login\");\n\t\t\trs.beforeFirst();\n\t\t\tSystem.out.println(\"printing database info....\");\n\t\t\twhile(rs.next())\n\t\t\t{\n\t\t\t\tSystem.out.println(rs.getString(1)+\" \"+rs.getString(2));\n\t\t\t}\n\n\t\t}catch (ClassNotFoundException e)\n\t\t{\n\t\t\tSystem.out.println(e.getMessage());\n\t\t}catch(SQLException e)\n\t\t{\n\t\t\tSystem.out.println(e.getMessage());\n\t\t}\n\t}\n}\n<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Lib<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"109\" src=\"https:\/\/java.ihavenomoney.co.kr\/wp-content\/uploads\/2023\/10\/image.png\" alt=\"\" class=\"wp-image-1146\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Overview : mariadb \uc5f0\uacb0\ud558\uae30 Lib<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1143","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/1143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1143"}],"version-history":[{"count":2,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/1143\/revisions"}],"predecessor-version":[{"id":1147,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/1143\/revisions\/1147"}],"wp:attachment":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}