Java\u3067SQL\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3059\u308b\u306b\u306f\u3001JDBC\uff08Java Database Connectivity\uff09\u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u64cd\u4f5c\u3057\u307e\u3059\u3002\u4e00\u822c\u7684\u306a\u65b9\u6cd5\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u30021. JDBC\u30c9\u30e9\u30a4\u30d0\u306e\u8ffd\u52a0: \u307e\u305a\u3001Java\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u9069\u5207\u306aJDBC\u30c9\u30e9\u30a4\u30d0\u3092\u8ffd\u52a0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u3088\u3063\u3066\u7570\u306a\u308b\u30c9\u30e9\u30a4\u30d0\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u3001MySQL\u3067\u4f7f\u7528\u3059\u308b\u30c9\u30e9\u30a4\u30d0\u306fmysql-connector-java\u3067\u3001\u516c\u5f0f\u30a6\u30a7\u30d6\u30b5\u30a4\u30c8\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u307e\u3059\u30022. \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u306e\u78ba\u7acb: JDBC\u306eConnection\u30af\u30e9\u30b9\u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u3092\u78ba\u7acb\u3057\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306eURL\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u306a\u3069\u306e\u60c5\u5831\u304c\u5fc5\u8981\u3067\u3059\u3002“`javaimport java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class Main {
\npublic static void main(String[] args) {
\nString url = “jdbc:mysql:\/\/localhost:3306\/database_name”;
\nString username = “root”;
\nString password = “password”;\u00a0 \u00a0 \u00a0 \u00a0try {
\nConnection connection = DriverManager.getConnection(url, username, password);
\n\/\/ \u3053\u3053\u3067\u3059SQL\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c
\n\/\/ …
\nconnection.close();
\n} catch (SQLException e) {
\ne.printStackTrace();
\n}
\n}}“`3. SQL\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c: JDBC\u306eStatement\u307e\u305f\u306fPreparedStatement\u30af\u30e9\u30b9\u3092\u4f7f\u7528\u3057\u3066SQL\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002Statement\u30af\u30e9\u30b9\u306f\u9759\u7684\u306aSQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306b\u4f7f\u7528\u3055\u308c\u3001PreparedStatement\u30af\u30e9\u30b9\u306f\u52d5\u7684\u306aSQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306b\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002“`javaimport java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class Main {
\npublic static void main(String[] args) {
\nString url = “jdbc:mysql:\/\/localhost:3306\/database_name”;
\nString username = “root”;
\nString password = “password”;\u00a0 \u00a0 \u00a0 \u00a0try {
\nConnection connection = DriverManager.getConnection(url, username, password);
\nStatement statement = connection.createStatement();
\n\/\/ SQL\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c
\nString sqlScript = “CREATE TABLE table_name (column1 datatype, column2 datatype, …)”;
\nstatement.execute(sqlScript);
\nstatement.close();
\nconnection.close();
\n} catch (SQLException e) {
\ne.printStackTrace();
\n}
\n}}“`\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u306e “CREATE TABLE table_name (column1 datatype, column2 datatype, …)” \u306f\u3001\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308bSQL\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u4f8b\u3067\u3059\u3002\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u3001\u72ec\u81ea\u306eSQL\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u5909\u66f4\u3067\u304d\u307e\u3059\u3002\u6ce8\u610f: SQL\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3059\u308b\u524d\u306b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306e\u63a5\u7d9a\u3092\u78ba\u7acb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002MySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5834\u5408\u306f\u3001URL\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\uff08\u4f8b: “jdbc:mysql:\/\/localhost:3306\/database_name”\uff09\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
Java\u3067SQL\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3059\u308b\u306b\u306f\u3001JDBC\uff08Java Database Connectivity\uff09\u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u64cd\u4f5c\u3057\u307e\u3059\u3002\u4e00\u822c\u7684\u306a\u65b9\u6cd5\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u30021. JDBC\u30c9\u30e9\u30a4\u30d0\u306e\u8ffd\u52a0: \u307e\u305a\u3001Java\u30d7 […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-111761","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n