图片制作视频_苏州网页制作_网站建设公司企业网站_怎样做好网络营销推广

官网：https://gorm.io/

docs：https://gorm.io/docs/

博客：https://www.tizi365.com/archives/6.html

import ("fmt""gorm.io/driver/mysql""gorm.io/gorm"
)type Product struct {gorm.ModelCode  stringPrice uint
}func main() {fmt.Println("main ...")dsn := "act:Q***wsx@tcp(127.0.0.1:3306)/tbname1?charset=utf8mb4&parseTime=True&loc=Local"var db, err = gorm.Open(mysql.Open(dsn), &gorm.Config{})if err != nil {panic("failed to connect database")}// Migrate the schemadb.AutoMigrate(&Product{})// Createdb.Create(&Product{Code: "D4211", Price: 100})// Readvar product Productdb.First(&product, 1)                 // find product with integer primary keydb.First(&product, "code = ?", "D42") // find product with code D42fmt.Println(product)// Update - update product's price to 200db.Model(&product).Update("Price", 200)// Update - update multiple fieldsdb.Model(&product).Updates(Product{Price: 200, Code: "F42"}) // non-zero fieldsdb.Model(&product).Updates(map[string]interface{}{"Price": 200, "Code": "F42"})// Delete - delete productdb.Delete(&product, 1)fmt.Println("success ...")
}