golang中mysql增刪改查實踐
package main import ( "database/sql" "fmt" //"time" _ "github.com/go-sql-driver/mysql" ) func checkErr(err error) { if err != nil { panic(err) } } func main() { db, err := sql.Open("mysql", "root:Hudp-.1234@/test?charset=utf8") checkErr(err) //插入資料 stmt, err := db.Prepare("INSERT userinfo SET username=?,departname=?,created=?") checkErr(err) res, err := stmt.Exec("michael", "系統運營部", "2018-10-30") checkErr(err) id, err := res.LastInsertId() checkErr(err) fmt.Println(id) //更新資料 stmt, err = db.Prepare("update userinfo set username=? where uid=?") checkErr(err) res, err = stmt.Exec("tony",id) checkErr(err) affect, err := res.RowsAffected() checkErr(err) fmt.Println(affect) //查詢資料 rows, err := db.Query("SELECT * FROM userinfo") checkErr(err) for rows.Next() { var uid int var username string var department string var created string err = rows.Scan(&uid, &username, &department, &created) checkErr(err) fmt.Println(uid) fmt.Println(username) fmt.Println(department) fmt.Println(created) } //刪除資料 stmt, err = db.Prepare("delete from userinfo where uid=?") checkErr(err) res, err = stmt.Exec(id) checkErr(err) affect, err = res.RowsAffected() checkErr(err) fmt.Println(affect) defer db.Close() }
參考連結:ofollow,noindex" target="_blank">https://www.golang123.com/book/9?chapterID=165