{"id":432,"date":"2022-10-21T09:15:49","date_gmt":"2022-10-21T00:15:49","guid":{"rendered":"https:\/\/sheltie-garage.xyz\/tech\/?p=432"},"modified":"2022-11-23T09:00:46","modified_gmt":"2022-11-23T00:00:46","slug":"go%e8%a8%80%e8%aa%9e%e3%81%a7drud%e3%81%97%e3%81%a6%e3%81%bf%e3%82%8b","status":"publish","type":"post","link":"https:\/\/sheltie-garage.xyz\/tech\/2022\/10\/go%e8%a8%80%e8%aa%9e%e3%81%a7drud%e3%81%97%e3%81%a6%e3%81%bf%e3%82%8b\/","title":{"rendered":"Go\u8a00\u8a9e\u3067CRUD\u3057\u3066\u307f\u308b"},"content":{"rendered":"\n

Go\u8a00\u8a9e\u306e\u52c9\u5f37\u3092\u3061\u3087\u3053\u3061\u3087\u3053\u59cb\u3081\u3066\u3044\u307e\u3059\u3002
\u307e\u305a\u306fDB\u64cd\u4f5c\u3092\u3068\u3044\u3046\u3053\u3068\u3067\u3001CRUD\u3092\u8a66\u3057\u3066\u898b\u307e\u3057\u305f<\/p>\n\n\n\n

\u3044\u304d\u306a\u308a\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9<\/h2>\n\n\n\n
package main\n\nimport (\n\t"database\/sql"\n\t"fmt"\n\t"log"\n\n\t_ "github.com\/go-sql-driver\/mysql"\n)\n\nfunc main() {\n\tdbconf := "root:password@tcp(127.0.0.1:3306)\/practice?charset=utf8mb4"\n\n\tdb, err := sql.Open("mysql", dbconf)\n\tif err != nil {\n\t\tfmt.Println(err.Error())\n\t}\n\tdefer db.Close()\n\n\terr = db.Ping()\n\n\tif err != nil {\n\t\tfmt.Println("\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u5931\u6557")\n\t\treturn\n\t} else {\n\t\tfmt.Println("\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u6210\u529f")\n\t}\n\n\t\/\/ INSERT\n\tfmt.Println("Insert")\n\tsqlInsert(db)\n\n\t\/\/ UPDATE\n\tfmt.Println("Update")\n\tsqlUpdate(db)\n\n\t\/\/ DELETE\n\tfmt.Println("Delete")\n\tsqlDelete(db)\n\n\t\/\/ SELECT\n\tfmt.Println("Select")\n\tsqlSelect(db)\n}\n\n\/\/ Insert\nfunc sqlInsert(db *sql.DB) {\n\tins, err := db.Prepare("INSERT INTO test VALUES (null, ?)")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\n\tres, err := ins.Exec("messsage 1")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\n\tlastInsertId, err := res.LastInsertId()\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tfmt.Println(lastInsertId)\n\n\tres, err = ins.Exec("messsage 2")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tlastInsertId, err = res.LastInsertId()\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tfmt.Println(lastInsertId)\n\n\tres, err = ins.Exec("messsage 3")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tlastInsertId, err = res.LastInsertId()\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tfmt.Println(lastInsertId)\n}\n\n\/\/ UPDATE\nfunc sqlUpdate(db *sql.DB) {\n\tupd, err := db.Prepare("UPDATE test SET message = ? WHERE id = 1")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tres, err := upd.Exec("updated message")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\n\tlastInsertId, err := res.LastInsertId()\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tfmt.Println(lastInsertId)\n}\n\n\/\/ DELETE\nfunc sqlDelete(db *sql.DB) {\n\tupd, err := db.Prepare("DELETE FROM test WHERE id = ?")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tres, err := upd.Exec(2)\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\n\tlastInsertId, err := res.LastInsertId()\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tfmt.Println(lastInsertId)\n}\n\n\/\/ SELECT\nfunc sqlSelect(db *sql.DB) {\n\n\trows, err := db.Query("SELECT id, message FROM test")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tdefer rows.Close()\n\n\tfor rows.Next() {\n\t\tvar (\n\t\t\tid      int\n\t\t\tmessage string\n\t\t)\n\n\t\terr := rows.Scan(&id, &message)\n\t\tif err != nil {\n\t\t\tpanic(err.Error())\n\t\t}\n\t\tfmt.Println("id=", id, "message=", message)\n\t}\n}<\/code><\/pre><\/div>\n\n\n\n
\u4e0a\u8a18\u306e\u5b9f\u884c\u7d50\u679c\u304c\u3053\u3061\u3089<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u4e00\u56de\u52d5\u4f5c\u78ba\u8a8d\u3057\u3061\u3083\u3063\u305f\u306e\u3067\u3001ID\u306f3\u304b\u3089\u59cb\u307e\u3063\u3066\u3044\u307e\u3059\u3002
DELETE\u6587\u306e\u5f15\u6570\u3067ID=2\u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u306e\u3067\u3001DELETE\u306f\u7a7a\u632f\u308a\u3057\u3066\u3044\u307e\u3059\u306d\u30fb\u30fb\u30fb<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
VSCode\u306e\u51fa\u529b\u7d50\u679c\u306f\u3053\u3093\u306a\u611f\u3058\u3067\u3001\u305d\u308c\u305e\u308c\u51e6\u7406\u304c\u884c\u308f\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
\u4ee5\u4e0a<\/h2>\n\n\n\n
\u77ed\u3044\u3067\u3059\u304c\u3001\u4ee5\u4e0a\u3067\u3059\u3002
OR\u30de\u30c3\u30d1\u30fc\u3082\u5229\u7528\u3057\u3066\u3044\u306a\u3044\u305f\u3081\u3001\u304b\u306a\u308a\u30b7\u30f3\u30d7\u30eb\u306b\u66f8\u304f\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002
Go\u306edefer\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067DB\u306e\u9589\u3058\u5fd8\u308c\u3082\u9632\u6b62\u3067\u304d\u305d\u3046\u3067\u3059\u3002<\/p>\n\n\n
\n\t
\n\t\t
\n\t\t\t\t\t\t\t<\/a>\t\t\t\t\t<\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t\t\u30b9\u30bf\u30fc\u30c6\u30a3\u30f3\u30b0Go\u8a00\u8a9e \uff08CodeZine\u3000books\uff09 [ \u677e\u5c3e\u611b\u8cc0 ]<\/a>\t\t\t\t\t\t\t<\/div>\n\t\t\t
\n\t\t\t\t\t\t\t
created by Rinker<\/a><\/div>\n\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\u00a53,278<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(2026\/04\/24 10:51:21\u6642\u70b9 \u697d\u5929\u5e02\u5834\u8abf\u3079-<\/span>\u8a73\u7d30)<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t