{"id":533,"date":"2020-06-29T09:37:57","date_gmt":"2020-06-29T01:37:57","guid":{"rendered":"http:\/\/wp.vicds.com\/?p=533"},"modified":"2020-06-29T09:40:52","modified_gmt":"2020-06-29T01:40:52","slug":"java-with-mariadb","status":"publish","type":"post","link":"https:\/\/wp.vicds.com\/?p=533","title":{"rendered":"java with mariadb"},"content":{"rendered":"\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-\">\u5148\u4e0b\u8f09connector\/j\n<blockquote class=\"wp-embedded-content\" data-secret=\"ZxiwGR5fHz\"><a href=\"https:\/\/mariadb.org\/download\/\">Download<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Download&#8221; &#8212; MariaDB.org\" src=\"https:\/\/mariadb.org\/download\/embed\/#?secret=ZxiwGR5fHz\" data-secret=\"ZxiwGR5fHz\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n\u6311\u4e00\u500b\u65b0\u7248\u672c\u4f86\u7528, \u5728\u9019\u88e1\u662f 2.6.1\neclipse\u65b0\u958b\u4e00\u500bjava project\nproject\u53f3\u9375\u9078properties\n\u5de6\u908a\u9078Java Build Path, \u53f3\u908a\u9078Libraries, \u9edeAdd External JARs\n\u9078\u525b\u525b\u4e0b\u8f09\u7684connector, \u9078\u5b8c\u6210\n\n\u958b\u4e00\u500bclass\u53ebMariaDB\n\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.SQLException;\nimport java.util.Properties;\n\npublic class MariaDB {\n\n\tprivate static final String dbClassName = &quot;org.mariadb.jdbc.Driver&quot;;\n\tprivate static final String CONNECTION = &quot;jdbc:mariadb:\/\/localhost:3306\/dataTable&quot;;\t\n\n\tpublic static void main(String[] args) throws ClassNotFoundException, SQLException {\n\t\tSystem.out.println(dbClassName);\n\t\tClass.forName(dbClassName);\n\t\tProperties p = new Properties();\n\t\tp.put(&quot;user&quot;, &quot;USERNAME&quot;);\n\t\tp.put(&quot;password&quot;, &quot;PASSWORD&quot;);\n\t\tConnection c = DriverManager.getConnection(CONNECTION, p);\n\t\tSystem.out.println(&quot;It works !&quot;);\n\t\tc.close();\n\t}\n\n}\n\n\u51fa\u73fe It works !\u5c31\u6210\u529f\u56c9<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","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-533","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/posts\/533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=533"}],"version-history":[{"count":2,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/posts\/533\/revisions"}],"predecessor-version":[{"id":535,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/posts\/533\/revisions\/535"}],"wp:attachment":[{"href":"https:\/\/wp.vicds.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}