{"id":12,"date":"2013-11-26T17:03:12","date_gmt":"2013-11-26T08:03:12","guid":{"rendered":"http:\/\/kei0310.info\/?p=12"},"modified":"2013-11-29T04:44:04","modified_gmt":"2013-11-28T19:44:04","slug":"javamysql-java%e3%81%8b%e3%82%89mysql%e3%82%92%e4%bd%bf%e3%81%86%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"http:\/\/kei0310.info\/?p=12","title":{"rendered":"[Java][MySQL] Java\u304b\u3089MySQL\u3092\u4f7f\u3046\u65b9\u6cd5"},"content":{"rendered":"<p>MySQL\u306f\u3001\u30d5\u30ea\u30fc\u3067\u3042\u308a\u306a\u304c\u3089\u5546\u7528\u3068\u3057\u3066\u3082\u4f7f\u7528\u3067\u304d\u308b\u30d1\u30ef\u30fc\u3092\u6301\u3064\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(RDB)\u3067\u3059\u3002<\/p>\n<p>\u4e00\u822c\u7684\u306a\u30a2\u30af\u30bb\u30b9\u6570\u306e\u30b5\u30a4\u30c8\u3067\u3042\u308c\u3070\u3001\u30d0\u30c3\u30af\u30a8\u30f3\u30c9\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u3053\u308c\u4e00\u672c\u3042\u308c\u3070\u5341\u5206\u3067\u3057\u3087\u3046\u3002<\/p>\n<p>\u305f\u3060\u3057\u3001\u5927\u4f01\u696d\u30dd\u30fc\u30bf\u30eb\u30b5\u30a4\u30c8\u30ec\u30d9\u30eb\u306e\u30a2\u30af\u30bb\u30b9\u6570\u304c\u3042\u308b\u5834\u5408\u306f\u3001Redis\u7b49\u306eKVS\u3092\u30ad\u30e3\u30c3\u30b7\u30e5\u306b\u3057\u3066\u305d\u306e\u88cf\u306bRDB\u3092\u7f6e\u304f\u7b49\u306e\u5de5\u592b\u3092\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u305d\u308c\u3067\u306f\u3001\u307e\u305a\u306fMySQL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304b\u3089\u3002<\/p>\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u3092<a title=\"MySQL\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\" href=\"http:\/\/kei0310.info\/?p=17\" target=\"_blank\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<br \/>\n\u30c6\u30b9\u30c8\u7528\u306e\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u306f<a title=\"\u3053\u3061\u3089\u306e\u8a18\u4e8b\" href=\"http:\/\/kei0310.info\/?p=46\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>Java\u304b\u3089MySQL\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306eJDBC\u30c9\u30e9\u30a4\u30d0\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<br \/>\n\u25cf\u5f53\u30b5\u30a4\u30c8\u306e<a title=\"MySQL\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\" href=\"http:\/\/kei0310.info\/?p=17\" target=\"_blank\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u3092\u53c2\u7167\u3057\u3066MySQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u5834\u5408<br \/>\n\u300c[\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5148]\\MySQL\\Connector J x.x.x\\\u300d\u306bJDBC\u30c9\u30e9\u30a4\u30d0\u306ejar\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u25cf\u305d\u308c\u4ee5\u5916\u306e\u5834\u5408<br \/>\n\u4ee5\u4e0b\u30b5\u30a4\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n\u300chttp:\/\/dev.mysql.com\/downloads\/connector\/j\/\u300d<\/p>\n<p>\u8d64\u4e38\u306e\u300cDOWNLOAD\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<a href=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff11.png\"><img loading=\"lazy\" src=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff11-300x115.png\" alt=\"MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff11\" width=\"300\" height=\"115\" class=\"alignnone size-medium wp-image-55\" srcset=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff11-300x115.png 300w, http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff11.png 725w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u6b21\u306b\u3001\u8d64\u4e38\u306e\u300cNo thanks, just start my download.\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n\u305d\u3046\u3059\u308b\u3068\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\u306f\u305a\u3067\u3059\u3002<br \/>\n\u305d\u308c\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u306a\u305c\u304b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u307e\u3059\u3002<br \/>\n<a href=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff12.png\"><img loading=\"lazy\" src=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff12-300x189.png\" alt=\"MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff12\" width=\"300\" height=\"189\" class=\"alignnone size-medium wp-image-56\" srcset=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff12-300x189.png 300w, http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/MySQL_JDBC\u30c9\u30e9\u30a4\u30d0\u53d6\u5f97\uff10\uff12.png 768w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u300cC:\\Program Files (x86)\\MySQL\\MySQL Connector J\u300d<br \/>\n\u3053\u3053\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u306f\u305a\u3067\u3059\u3002<\/p>\n<p>\u6b21\u306b\u3001JDBC\u30c9\u30e9\u30a4\u30d0\u306ejar\u306b\u30af\u30e9\u30b9\u30d1\u30b9\u3092\u901a\u3057\u307e\u3059\u3002<br \/>\nEclipse\u3067\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u307e\u3059\u3002\uff08\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u3067\u306f\u300cjavac -classpath ~~~~\u300d\u3067\u3084\u308a\u307e\u3059\u3002\uff09<\/p>\n<p>\u307e\u305a\u3001\u300c\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\uff1e\u30d3\u30eb\u30c9\u30d1\u30b9\uff1e\u30e9\u30a4\u30d6\u30e9\u30ea\u300d\u3092\u958b\u304d\u307e\u3059\u3002<br \/>\n\u305d\u306e\u5f8c\u3001\u300c\u5916\u90e8Jar\u8ffd\u52a0\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<a href=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff11.png\"><img loading=\"lazy\" src=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff11-300x169.png\" alt=\"JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff11\" width=\"300\" height=\"169\" class=\"alignnone size-medium wp-image-57\" srcset=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff11-300x169.png 300w, http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff11-1024x580.png 1024w, http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff11.png 1082w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Jar\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e\u3057\u3066\u300c\u9078\u629e\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<a href=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff12.png\"><img loading=\"lazy\" src=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff12-300x168.png\" alt=\"JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff12\" width=\"300\" height=\"168\" class=\"alignnone size-medium wp-image-58\" srcset=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff12-300x168.png 300w, http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff12.png 960w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u300cOK\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<a href=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff13.png\"><img loading=\"lazy\" src=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff13-300x169.png\" alt=\"JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff13\" width=\"300\" height=\"169\" class=\"alignnone size-medium wp-image-59\" srcset=\"http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff13-300x169.png 300w, http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff13-1024x580.png 1024w, http:\/\/kei0310.info\/wp-content\/uploads\/2013\/11\/JDBC\u30c9\u30e9\u30a4\u30d0_Eclipse\u8a2d\u5b9a\uff10\uff13.png 1082w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u3053\u3053\u307e\u3067\u3067\u3001\u6e96\u5099\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u65e9\u901f\u3001Java\u30b3\u30fc\u30c9\u3092\u66f8\u3044\u3066\u307f\u307e\u3059\u3002<br \/>\n\u9069\u5f53\u306bJava\u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3057\u3001\u4ee5\u4e0b\u30b3\u30fc\u30c9\u3092\u30b3\u30d4\u30da\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n\u305d\u306e\u5f8c\u3001user\u3068password\u3092\u6b63\u3057\u304f\u8a2d\u5b9a\u3059\u308b\u3068\u52d5\u304f\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<h6>\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\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\nimport java.sql.Statement;\r\n\r\n\r\npublic class TestMySQL {\r\n\r\n    public static void main(String[] args) {\r\n        Connection con = null;\r\n        PreparedStatement ps = null;\r\n        String driver = &quot;com.mysql.jdbc.Driver&quot;;\r\n        String dbname = &quot;JavaTest&quot;;\r\n        String url = &quot;jdbc:mysql:\/\/localhost\/&quot; + dbname;\r\n        String user = &quot;xxx&quot;;\r\n        String passwd = &quot;yyy&quot;;\r\n\r\n        String sql = &quot;select * from JavaTestTable;&quot;;\r\n\r\n        try {\r\n            \/\/ JDBC\u30c9\u30e9\u30a4\u30d0\u8aad\u307f\u8fbc\u307f\r\n            Class.forName(driver);\r\n\r\n            \/\/ \u30b3\u30cd\u30af\u30c8\r\n            con = DriverManager.getConnection(url, user, passwd);\r\n\r\n            \/\/ SQL\u767a\u884c\r\n            Statement stmt = con.createStatement();\r\n            ResultSet rs = stmt.executeQuery (sql);\r\n\r\n            \/\/ \u7d50\u679c\u7167\u4f1a\r\n            while(rs.next()){\r\n                int id = rs.getInt(&quot;id&quot;);\r\n                String name = rs.getString(&quot;name&quot;);\r\n                System.out.println(&quot;ID\uff1a&quot; + id);\r\n                System.out.println(&quot;\u540d\u524d\uff1a&quot; + name);\r\n            }\r\n\r\n            \/\/ \u30af\u30ed\u30fc\u30ba\u51e6\u7406\r\n            rs.close();\r\n            stmt.close();\r\n            con.close();\r\n\r\n        } catch (ClassNotFoundException e){\r\n            e.printStackTrace();\r\n        } catch (SQLException e) {\r\n            e.printStackTrace();\r\n        }\r\n    }\r\n\r\n}\r\n\r\n<\/pre>\n<\/h6>\n<p>\u5b9f\u884c\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308b\u306f\u305a\u3067\u3059\u3002<\/p>\n<h6>\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">\r\nID\uff1a1\r\n\u540d\u524d\uff1a\u4e00\u90ce\r\nID\uff1a2\r\n\u540d\u524d\uff1a\u6b21\u90ce\r\n<\/pre>\n<\/h6>\n<p>\u305f\u3060\u3057\u3001\u4eca\u56de\u306f\u30b5\u30f3\u30d7\u30eb\u306a\u306e\u3067\u7701\u7565\u3057\u307e\u3057\u305f\u304c\u3001<br \/>\n\u7d0d\u54c1\u30b3\u30fc\u30c9\u3092\u66f8\u304f\u969b\u306f\u3001\u3061\u3083\u3093\u3068finally\u306e\u4e2d\u3067\u306e\u30af\u30ed\u30fc\u30ba\u51e6\u7406\u3082\u884c\u3044\u307e\u3057\u3087\u3046\uff01\uff01\uff01<\/p>\n<p>\u4ee5\u4e0a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\u306f\u3001\u30d5\u30ea\u30fc\u3067\u3042\u308a\u306a\u304c\u3089\u5546\u7528\u3068\u3057\u3066\u3082\u4f7f\u7528\u3067\u304d\u308b\u30d1\u30ef\u30fc\u3092\u6301\u3064\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(RDB)\u3067\u3059\u3002 \u4e00\u822c\u7684\u306a\u30a2\u30af\u30bb\u30b9\u6570\u306e\u30b5\u30a4\u30c8\u3067\u3042\u308c\u3070\u3001\u30d0\u30c3\u30af\u30a8\u30f3\u30c9\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u3053\u308c\u4e00\u672c\u3042\u308c\u3070\u5341\u5206\u3067\u3057\u3087\u3046\u3002 \u305f\u3060\u3057\u3001\u5927\u4f01\u696d\u30dd\u30fc\u30bf\u30eb\u30b5\u30a4\u30c8\u30ec [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[183,2,184],"_links":{"self":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts\/12"}],"collection":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12"}],"version-history":[{"count":13,"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts\/12\/revisions"}],"predecessor-version":[{"id":66,"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts\/12\/revisions\/66"}],"wp:attachment":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}