文章摘自我的个人博客: 网页地址
插入
import (
"beetest/models"
"fmt"
"github.com/beego/beego/v2/client/orm"
beego "github.com/beego/beego/v2/server/web"
)
func (c *Register) Post() {
o := orm.NewOrm()
user := models.User{Name: "王丰", PassWord: "111111", UserName: "wdf"}
_, err := o.Insert(&user)
if err != nil {
fmt.Println("插入失败")
}
}
查询
func (c *Login) Post() {
c.Data["title"] = "登录post"
c.TplName = "login.html"
o := orm.NewOrm()
user := models.User{}
user.Id = 1
err := o.Read(&user)
//非主键
//err := o.Read(&user,"Name")
if err != nil {
fmt.Println("查询失败")
c.Data["title"] = "查询失败"
} else {
fmt.Println("查询成功",user)
c.Data["title"] = user.Name
}
}
更新
//方式一
o := orm.NewOrm()
user := models.User{Id: 1}
err := o.Read(&user)
if err == nil {
user.Name = "王王丰"
_, err1 := o.Update(&user)
if err1 == nil {
fmt.Println("更新成功")
c.Data["title"] = "更新成功"
} else {
c.Data["title"] = "更新失败"
}
} else {
c.Data["title"] = "查询失败 "
}
删除
o := orm.NewOrm()
user := models.User{Id: 1}
_, err := o.Delete(&user)
if err == nil {
fmt.Println("删除成功")
}