创建:
fun main {
var user User{Name:"chen",Age: 22}
db.create(&user)
}
查询:
//根据主键id查询
db.First(&user, 10)
//根据多个主键id查询多条数据
db.Find(&users, []int{1,2,3})
//查询所有数据
result := db.Find(&users)
//根据条件查询
db.Where("name <> ?", "jinzhu").Find(&users)
更新:
//更新多个字段
db.Model(&user)>Where("id = ?",10).Updates(User{Name: "hello", Age: 18, Active: false})
删除:
func main{
db.Where("id = ?",10).Delete(&user)
//永久删除
db.Unscoped().Delete(&order)
}