golang修仙记之gorm（一）

学习了如何连接数据库、简单的错误处理、关闭数据库、创建表、创建表中的一条记录、读取表的记录、更新表的记录、删除标的记录

package main import ( "github.com/jinzhu/gorm" _ "github.com/jinzhu/gorm/dialects/mysql" "time" ) type User struct { gorm.Model Name string Age int 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) }