``` package main import ( "database/sql" "fmt" _ "github.com/go-sql-driver/mysql" //"time" ) func main() { db, err := sql.Open("mysql", "astaxie:astaxie@/test?charset=utf8") checkErr(err) //插入數據 stmt, err := db.Prepare("INSERT userinfo SET username=?,departname=?,created=?") checkErr(err) res, err := stmt.Exec("astaxie", "研發部門", "2012-12-09") 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("astaxieupdate", 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) db.Close() } func checkErr(err error) { if err != nil { panic(err) } } // CREATE TABLE `userinfo` ( // `uid` INT(10) NOT NULL AUTO_INCREMENT, // `username` VARCHAR(64) NULL DEFAULT NULL, // `departname` VARCHAR(64) NULL DEFAULT NULL, // `created` DATE NULL DEFAULT NULL, // PRIMARY KEY (`uid`) // ) // CREATE TABLE `userdetail` ( // `uid` INT(10) NOT NULL DEFAULT '0', // `intro` TEXT NULL, // `profile` TEXT NULL, // PRIMARY KEY (`uid`) // ) ``` ## 連接數據庫 ``` db, err := sql.Open("mysql", "astaxie:astaxie@/test?charset=utf8") ``` ## 查詢數據 ~~~ 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("INSERT userinfo SET username=?,departname=?,created=?") checkErr(err) res, err := stmt.Exec("astaxie", "研發部門", "2012-12-09") checkErr(err) id, err := res.LastInsertId() // 取插入id checkErr(err) ~~~ ## 更新數據 ~~~ stmt, err = db.Prepare("update userinfo set username=? where uid=?") checkErr(err) res, err = stmt.Exec("astaxieupdate", id) checkErr(err) affect, err := res.RowsAffected() checkErr(err) fmt.Println(affect) ~~~ ## 刪除數據 ~~~ 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) ~~~