golang修仙記之gorm(一)
學習瞭如何連線資料庫、簡單的錯誤處理、關閉資料庫、建立表、建立表中的一條記錄、讀取表的記錄、更新表的記錄、刪除標的記錄
package main import ( "github.com/jinzhu/gorm" _ "github.com/jinzhu/gorm/dialects/mysql" "time" ) type User struct { gorm.Model Namestring Ageint Birthday time.Time } func main() { // connect the database db, err := gorm.Open("mysql", "user:password@tcp(ip:port)/database?charset=utf8&parseTime=True&loc=Local") // panic handle if err != nil { panic("failed to connect database") } // close the connection defer db.Close() // Migrate the schema db.AutoMigrate(&User{}) // create user of table db.Create(&User{Name: "Jinzhu", Age: 19, Birthday: time.Now()}) // read the user of table var user User db.First(&user, 1) db.First(&user, "Name = ?", "Jinzhu") //update db.Model(&user).Update("Name", "Michael") //delete db.Delete(&user) }